Reverse star schema

The reverse star schema is a schema optimized for fast retrieval of large quantities of descriptive data. The design was derived from a warehouse star schema,[1] and its adaptation for descriptive data required that certain key characteristics of the classic star schema be "reversed".

Model

The relation of the central table to those in dimension tables is one-to-many, or in some cases many-to-many rather than many-to-one; the primary keys of the central table are the foreign keys in dimension tables, and the main tables are, in general, smaller than the dimension tables.

Main table columns are typically the source of query constraints, as opposed to dimension tables in the classical star schema. By starting queries with the smaller table, many results are filtered out early in the querying process, thereby streamlining the entire search path.

To add further flexibility, more than one main table is allowed, with main and submain tables having a one-to-many relation. Each main table can have its own dimension tables. To provide further query optimization, a data set can be partitioned into separate physical schemas on either the same database server or different database servers.

gollark: Also, SCP-2950 is a chair and also Safe-class.
gollark: I'd like to remind you, by the way, that SCP-3443 does not exist.
gollark: Go visit SCP-055.
gollark: Fine. We will pay you 0.5 melons per day in addition to your current pay.
gollark: Invalid POTAT-O5 credentials. Deploying MTF α-1 to your location. Deploying memetic kill agents. Deploying orbital lasers. Deploying apeirohazards.

See also

References

This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.