star schema

Also found in: Wikipedia.

star schema

A data warehouse design that enhances the performance of multidimensional queries on traditional relational databases. One fact table is surrounded by a series of related tables. Data are joined from one of the points to the center, providing a so-called "star query." See OLAP.

Mentioned in ?

dimensional modeling

References in periodicals archive ?

UPDATING FACT ROWS inside a star schema set of tables is never a best practice.

Updating facts is not a good practice

traditional indices map and the values to a list of record ids, it materializes relational join in JI file and speeds up relational joining rather costly operation in data warehouses, join index relates the values of the dimensions of a star schema to rows in the fact table illustrated from fact table Sales and two dimensions city and product.

An overview of data warehousing and OLAP technology

RD) Remove isolated classes (Disconnected classes): This function verify if there is isolated classes, then removes a class without incoming or outgoing relationships), while the smallest Star schema require two connected classes one for fact and other for dimension,

An approach for generating an XML data warehouse schema using model transformation language

In this case, the fact table will not have only one level of dimensions tables so this is why snowflake schema is better suited than the star schema for the modelling (Adamson, 2010).

Optimal data architecture for an telemedicine analytic platform

This guide to best practices in dimensional design provides information on star schema design techniques for data warehouses.

The complete reference star schema

Taking the relationship type Cont ribut ion in Figure 7 as core type of a star schema, the subschema containing Contribution, Member, Document, Project, and Time defines another star structure.

Using meta-structures in database design

A star schema requires that a dimension hierarchy is contained with in a single table.

Application of the OLAP cubes technology in the data mining

As example, the original data is shown in Table 1, and the corresponding star schema is shown in Table 2.

Using intelligent multi-agents to simulate investor behaviors in a stock market

Adding a new transaction data set, or modifying an existing one and then regenerating the star schema, is a point-and-click operation.

Data warehousing in 'real time'

The resulting data is stored in an analytic data server, which uses a star schema design to enable multidimensional analysis.

Informatica delivers beyond the warehouse

You can manage this information most effectively when it's modeled at the lowest meaningful level of detail using a star schema, adding summary tables to enhance performance.

Clearing the Clutter

For this reason, and others, the data in a data warehouse is usually represented in a star schema with the factual information at the center of the star, surrounded by the various types of reference data.