Information Superiority through Data Warehousing

2001 ◽  
Author(s):  
Neil Warner
Keyword(s):  
Data Warehousing

Healthcare Data Warehousing

2017 ◽  
Vol 4 (4) ◽  
pp. 1
Author(s):  
ARUNACHALAM S. ◽  
PAGE TOM ◽  
THORSTEINSSON G. ◽  
◽  
◽  
...  
Keyword(s):  
Data Warehousing ◽  
Healthcare Data

scholarly journals High-Efficient Fuzzy Querying with HiveQL for Big Data Warehousing

2021 ◽  
pp. 1-1
Author(s):  
Bozena Malysiak-Mrozek ◽  
Jadwiga Wieszok ◽  
Witold Pedrycz ◽  
Weiping Ding ◽  
Dariusz Mrozek
Keyword(s):  
Big Data ◽  
Data Warehousing ◽  
High Efficient

Universal Data Warehousing Based on a Meta-Data Modeling Approach

2003 ◽  
Vol 12 (03) ◽  
pp. 325-363 ◽  
Author(s):  
Joseph Fong ◽  
Qing Li ◽  
Shi-Ming Huang
Keyword(s):  
Data Warehouse ◽  
Data Warehousing ◽  
Object Oriented ◽  
Data Models ◽  
Heterogeneous Databases ◽  
Materialized Views ◽  
Prototype System ◽  
Relational View ◽  
Metadata Model ◽  
Star Schema

Data warehouse contains vast amount of data to support complex queries of various Decision Support Systems (DSSs). It needs to store materialized views of data, which must be available consistently and instantaneously. Using a frame metadata model, this paper presents an architecture of a universal data warehousing with different data models. The frame metadata model represents the metadata of a data warehouse, which structures an application domain into classes, and integrates schemas of heterogeneous databases by capturing their semantics. A star schema is derived from user requirements based on the integrated schema, catalogued in the metadata, which stores the schema of relational database (RDB) and object-oriented database (OODB). Data materialization between RDB and OODB is achieved by unloading source database into sequential file and reloading into target database, through which an object relational view can be defined so as to allow the users to obtain the same warehouse view in different data models simultaneously. We describe our procedures of building the relational view of star schema by multidimensional SQL query, and the object oriented view of the data warehouse by Online Analytical Processing (OLAP) through method call, derived from the integrated schema. To validate our work, an application prototype system has been developed in a product sales data warehousing domain based on this approach.

Sign in / Sign up

Export Citation Format

Share Document