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.