Tabellenebene

Tabellenebene is a term used in German information technology to denote the layer of a data architecture in which data are stored and organized in tabular structures, typically relational tables. It represents the persistent storage layer where records are kept and can be queried by SQL or equivalent query languages. In this layer, data are described by table schemas consisting of columns (attributes) and rows (records); integrity constraints, keys, indexes, and normalization rules govern the content and performance.

In database design and data management, the Tabellenebene is contrasted with other layers such as the Anwendungsebene (application layer) and the Präsentationsebene (presentation layer) or the Verarbeitungsebene (processing layer). The Tabellenebene focuses on storage and retrieval of data and may include staging or raw data tables as well as cleansed or aggregated tables depending on the architecture. In data warehouses, a multi-layer approach might include staging tables and core fact and dimension tables on the Tabellenebene, while business logic and analytics reside elsewhere.

Examples of typical tables in the Tabellenebene include a customer table with customer_id, name, and address; an order table with order_id, customer_id, and date; and a product table. These tables can be joined to answer business questions and generate reports.

Notes: The term is more common in German documentation and may be used differently across organizations. It is generally synonymous with the data storage layer in a tabular form.

See also: relational database, data model, normalization, ETL, data warehouse.