NDLI: Updating OLAP dimensions

Please wait, while we are loading the content...

starER: a conceptual model for data warehouse design

Event-entity-relationship modeling in data warehouse environments

Deriving initial data warehouse structures from the conceptual data models of the underlying operational information systems

Dealing with slow-evolving fact: a case study on inventory data warehousing

The MRE wrapper approach: enabling incremental view maintenance of data warehouses defined on multi-relation information sources

A progressive view materialization algorithm

Design and selection of materialized views in a data warehousing environment: a case study

Detecting patterns and OLAP operations in the GOLD model

Characterization of hierarchies and some operators in OLAP environment

Updating OLAP dimensions

A dynamic load balancing strategy for parallel datacube computation

Accessing data cubes along complex dimensions

Aggregation everywhere: data reduction and transformation in the Phoenix data warehouse

Query driven knowledge discovery in multidimensional data

A cache filtering optimisation for queries to massive datasets on tertiary storage

Updating OLAP dimensions

Content Provider	ACM Digital Library
Author	Hurtado, Carlos A. Vaisman, Alejandro A. Mendelzon, Alberto O.
Abstract	OLAP systems support data analysis through a multidimensional data model, according to which data facts are viewed as points in a space of application-related “dimensions” , organized into levels which conform a hierarchy. Although the usual assumption is that these points reflect the dynamic aspect of the data warehouse while dimensions are relatively static, in practice it turns out that dimension updates are often necessary to adapt the multidimensional database to changing requirements. These updates can take place either at the structural level (e.g. addition of categories or modification of the hierarchical structure) or at the instance level (elements can be inserted, deleted, merged, etc.). They are poorly supported (or not supported at all) in current commercial systems and have not been addressed in the literature. In a previous paper we introduced a formal model supporting dimension updates. Here, we extend the model, adding a set of semantically meaningful operators which encapsulate common sequences of primitive dimension updates in a more efficient way. We also formally define two mappings (normalized and denormalized) from the multidimensional to the relational model, and compare an implementation of dimension updates using these two approaches.
Starting Page	60
Ending Page	66
Page Count	7
File Format	PDF
ISBN	1581132204
DOI	10.1145/319757.319791
Language	English
Publisher	Association for Computing Machinery (ACM)
Publisher Date	1999-11-06
Publisher Place	New York
Access Restriction	Subscribed
Content Type	Text
Resource Type	Article

Central Library (ISO-9001:2015 Certified)
Indian Institute of Technology Kharagpur
Kharagpur, West Bengal, India | PIN - 721302

See location in the Map
03222 282435
Mail: support@ndl.gov.in

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in