Appaserver is an open-source

Open source

The term open source describes practices in production and development that promote access to the end product's source materials. Some consider open source a philosophy, others consider it a pragmatic methodology...

, application server

Application server

An application server is a software framework that provides an environment in which applications can run, no matter what the applications are or what they do...

 used to create multi-user

Multi-user

Multi-user is a term that defines an operating system or application software that allows concurrent access by multiple users of a computer. Time-sharing systems are multi-user systems. Most batch processing systems for mainframe computers may also be considered "multi-user", to avoid leaving the...

, database

Database

A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality , in a way that supports processes requiring this information...

 applications. It runs on UNIX

Unix

Unix is a multitasking, multi-user computer operating system originally developed in 1969 by a group of AT&T employees at Bell Labs, including Ken Thompson, Dennis Ritchie, Brian Kernighan, Douglas McIlroy, and Joe Ossanna...

-flavored operating system

Operating system

An operating system is a set of programs that manage computer hardware resources and provide common services for application software. The operating system is the most important type of system software in a computer system...

s, connecting Oracle

Oracle database

The Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation....

 or MySQL

MySQL

MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...

 to a browser

Web browser

A web browser is a software application for retrieving, presenting, and traversing information resources on the World Wide Web. An information resource is identified by a Uniform Resource Identifier and may be a web page, image, video, or other piece of content...

.

Appaserver's paradigm is to build database applications without painting or programming the user interface

User interface

The user interface, in the industrial design field of human–machine interaction, is the space where interaction between humans and machines occurs. The goal of interaction between a human and a machine at the user interface is effective operation and control of the machine, and feedback from the...

. Instead, applications are assembled from database components — tables, columns, relations, and roles. Web forms are created dynamically, allowing select, insert, update, and delete operations on each table. Also:

• Top/bottom, one-to-many
  One-to-many
  One-to-many may refer to:* Multivalued function, a one-to-many function in mathematics* Fat link, a one-to-many link in hypertext* Point-to-multipoint communication, communication which has a one-to-many relation-See also:*One-to-one...
  
   screens are automatically produced.
• Query screens
  Query by Example
  Query by Example is a database query language for relational databases. It was devised by Moshé M. Zloof at IBM Research during the mid 1970s, in parallel to the development of SQL. It is the first graphical query language, using visual tables where the user would enter commands, example elements...
  
   are automatically produced.
• Buttons to compute statistics
  Statistics
  Statistics is the study of the collection, organization, analysis, and interpretation of data. It deals with all aspects of this, including the planning of data collection in terms of the design of surveys and experiments....
  
   on numeric fields are automatically created.
• Buttons to create time charts and histogram
  Histogram
  In statistics, a histogram is a graphical representation showing a visual impression of the distribution of data. It is an estimate of the probability distribution of a continuous variable and was first introduced by Karl Pearson...
  
  s on numeric fields are automatically created.
• Relations
  Relational model
  The relational model for database management is a database model based on first-order predicate logic, first formulated and proposed in 1969 by Edgar F...
  
   are maintained from within.

1. Primary keys can be updated. The update then cascades throughout the foreign key
   Foreign key
   In the context of relational databases, a foreign key is a referential constraint between two tables.A foreign key is a field in a relational table that matches a candidate key of another table...
   
   s across related tables.
2. Rows can be deleted without creating orphans. Rows in one-to-many related tables will automatically be deleted unless the relationship is flagged to update the foreign key to null.
3. Natural key
   Natural key
   In relational model database design, a natural key is a candidate key that has a logical relationship to the attributes within that row. A natural key is sometimes called a domain key.The main advantage of a natural key over a surrogate key, which has no...
   
   s are used, not Surrogate keys. However, surrogate keys may be used as secondary keys. For example, the primary key for the customer table would likely be "Customer_Name|Address". However, the customer table might also have a customer_number column as a secondary key. Therefore, the primary key for the customer table might be "Customer_Name|Customer_Number".

Security

Database security

Database security concerns the use of a broad range of information security controls to protect databases against compromises of their confidentiality, integrity and availability...

 is obtained by grouping users into roles. Table-level access — select, insert, update, and delete — is then granted to each role. Security can be refined by restricting row-level and column-level access. Processes

Process (computing)

In computing, a process is an instance of a computer program that is being executed. It contains the program code and its current activity. Depending on the operating system , a process may be made up of multiple threads of execution that execute instructions concurrently.A computer program is a...

 are executed via the Common Gateway Interface

Common Gateway Interface

The Common Gateway Interface is a standard method for web servers software to delegate the generation of web pages to executable files...

. Appaserver is available under the GNU

GNU

GNU is a Unix-like computer operating system developed by the GNU project, ultimately aiming to be a "complete Unix-compatible software system"...

software license.

External links

• Appaserver
• Demo
• Download