Structure of database schemata

FirstSpirit has powerful mechanisms for connecting databases. A graphical schema editor can be used to create and modify database tables, define templates for maintaining and displaying datasets and formulate queries for filtering the datasets. To support this, a database abstraction layer that maps the universal FirstSpirit content type system to the specific database system to be used has been implemented by FirstSpirit.

The procedure for adding and editing a database schema is described in detail in the following chapters:

• Adding a schema: Either a new schema can be created in the database or a schema can be generated on the basis of an existing database schema.
• Schema editor: The desired database schema can be modeled using the graphical editor.
• Table templates: These connect the tables of a database schema to the data input by the editor.
• Queries: The number of datasets output for a data source can be restricted.