About: From ER Models to Star Schemas: Mapping From Operational Databases to Data Warehouse Designs

Facets (new session)
Description
Metadata
Settings
- owl:sameAs
- Inference Rule:

About: From ER Models to Star Schemas: Mapping From Operational Databases to Data Warehouse Designs Goto Sponge NotDistinct Permalink

An Entity of Type : http://linked.opendata.cz/ontology/domain/vavai/Vysledek, within Data Space : linked.opendata.cz associated with source document(s)

Attributes	Values
rdf:type	skos:Concept http://linked.opendata.cz/ontology/domain/vavai/Vysledek
Description	Dimensional modelling is a conceptual modelling technique developed for designing data warehouse structures. It has become the predominant approach to designing data warehouses in practice and has proven to be highly successful in developing database structures that can be used directly by end users. This paper examines the nature of dimensional modelling and its relationship to traditional Entity Relationship (ER) modelling. It shows that a dimensional model is just a restricted form of an ER model, and that there is quite a straightforward mapping between the two. Understanding the relationship between the two types of models can help to bridge the gap between operational system (OLTP) design and data warehouse (OLAP) design. It also helps to resolve the difficult problem of matching supply (operational data sources) and demand (end user information needs) in data warehouse design. Finally, it results in a more complete dimensional design, which is less dependent on the designe. Dimensional modelling is a conceptual modelling technique developed for designing data warehouse structures. It has become the predominant approach to designing data warehouses in practice and has proven to be highly successful in developing database structures that can be used directly by end users. This paper examines the nature of dimensional modelling and its relationship to traditional Entity Relationship (ER) modelling. It shows that a dimensional model is just a restricted form of an ER model, and that there is quite a straightforward mapping between the two. Understanding the relationship between the two types of models can help to bridge the gap between operational system (OLTP) design and data warehouse (OLAP) design. It also helps to resolve the difficult problem of matching supply (operational data sources) and demand (end user information needs) in data warehouse design. Finally, it results in a more complete dimensional design, which is less dependent on the designe. (en)
Title	From ER Models to Star Schemas: Mapping From Operational Databases to Data Warehouse Designs From ER Models to Star Schemas: Mapping From Operational Databases to Data Warehouse Designs (en)
skos:prefLabel	From ER Models to Star Schemas: Mapping From Operational Databases to Data Warehouse Designs From ER Models to Star Schemas: Mapping From Operational Databases to Data Warehouse Designs (en)
skos:notation	RIV/68407700:21230/03:03093672!RIV/2004/MSM/212304/N
http://linked.open...avai/riv/aktivita	Z
http://linked.open...avai/riv/aktivity	Z(MSM 212300013)
http://linked.open...vai/riv/dodaniDat	2004
http://linked.open...aciTvurceVysledku	Moody, Daniel Lawrence
http://linked.open.../riv/druhVysledku	A(V) - Audiovizuální tvorba se vzdáleným přístupem
http://linked.open...iv/duvernostUdaju	S - Úplné a pravdivé údaje nepodléhající ochraně podle zvláštních právních předpisů
http://linked.open...titaPredkladatele	České vysoké učení technické v Praze / Fakulta elektrotechnická
http://linked.open...dnocenehoVysledku	607758
http://linked.open...ai/riv/idVysledku	RIV/68407700:21230/03:03093672
http://linked.open...riv/jazykVysledku	eng - angličtina
http://linked.open.../riv/klicovaSlova	Dimensional model;Entity Relationship (ER) model;OLAP;data warehouse;star schema (en)
http://linked.open.../riv/klicoveSlovo	star schema Dimensional model Entity Relationship (ER) model data warehouse OLAP
http://linked.open...i/riv/kodPristupu	L
http://linked.open...ontrolniKodProRIV	[0A27CF6A66F4]
http://linked.open...i/riv/mistoVydani	Perth
http://linked.open...telVyzkumneZpravy	Not available
http://linked.open...in/vavai/riv/obor	JC
http://linked.open...ichTvurcuVysledku	1 (xsd:int)
http://linked.open...cetTvurcuVysledku	2 (xsd:int)
http://linked.open...UplatneniVysledku	2003
http://linked.open...iv/tvurceVysledku	Moody, Daniel Lawrence Kortink, M. A. R.
http://linked.open...rzeVyzkumneZpravy	Neuveden
http://linked.open...n/vavai/riv/zamer	http://linked.opendata.cz/resource/domain/vavai/zamer/MSM%20212300013
https://schema.org/isbn	0-7298-0544-1
http://localhost/t...ganizacniJednotka	21230

Faceted Search & Find service v1.16.118 as of Jun 21 2024

Alternative Linked Data Documents: ODE Content Formats:

RDF

ODATA

Microdata

About

OpenLink Virtuoso version 07.20.3240 as of Jun 21 2024, on Linux (x86_64-pc-linux-gnu), Single-Server Edition (126 GB total memory, 58 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software