Star Diagram Database. An er diagram is used in the development of conceptual models for an online transaction processing oltp database management system. Star schema design theory refers to two common scd types.
3 Alternatives To Olap Data Warehouses Data Warehouse Data Modeling Business Data from www.pinterest.com
It is the source from which the table structure is translated. It is known as star schema as its structure resembles a star. Star schema database diagram use creately s easy online diagram editor to edit this diagram collaborate with others and export results to multiple image formats.
In computing the star schema is the simplest style of data mart schema and is the approach most widely used to develop data warehouses and dimensional data marts.
A dimension type table could be type 1 or type 2 or support both types simultaneously for different columns. The star schema is the explicit data warehouse schema. A type 1 scd always reflects the latest values and when changes in source data are detected the dimension table data is overwritten. A star schema database uses very few joins and each join expresses the relationship between the elements of the underlying business.
