NDLI: Dimension table driven approach to referential partition relational data warehouses

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

Discovering functional dependencies for multidimensional design

A taxonomy of ETL activities

pygrametl: a powerful programming framework for extract-transform-load programmers

Consistency-aware evaluation of OLAP queries in replicated data warehouses

Dimension table driven approach to referential partition relational data warehouses

Automatic generation of ETL processes from conceptual models

Cardinality estimation in ETL processes

Query recommendations for OLAP discovery driven analysis

A comprehensive approach to data warehouse testing

Defining ETL worfklows using BPMN and BPEL

Generating data quality rules and integration into ETL process

LMDQL: link-based and multidimensional query language

View usability and safety for the answering of top-k queries via materialized views

Dimension table driven approach to referential partition relational data warehouses

Content Provider	ACM Digital Library
Author	Bellatreche, Ladjel Woameno, Komla Yamavo
Abstract	Most of business intelligence applications use data warehousing solutions. The star schema or its variants modelling these applications are usually composed of hundreds of dimension tables and multiple huge fact tables. Referential horizontal partitioning is one of physical design techniques adapted to optimize queries posed over these schemes. In referential partitioning, a fact table can inherit the fragmentation characteristics from dimension table(s). Most of the existing works done on referential partitioning start from a bag containing selection predicates defined on dimension tables, partition each one based on its predicates and finally propagate their fragmentation schemes to the fact table. This procedure gives all dimension tables the same probability to partition the fact table which is not always true. In order to ensure a high performance of the most costly queries, the identification of relevant dimension table(s) to referential partition a fact table is a crucial issue that should be addressed. In this paper, we first study the complexity of the problem of selecting dimension table(s) used to partition a fact table. Secondly, we present strategies to perform their selection. Finally, to validate of our proposal, we conduct intensive experimental studies using a mathematical cost model and the obtained results are verified on Oracle11G DBMS.
Starting Page	9
Ending Page	16
Page Count	8
File Format	PDF
ISBN	9781605588018
DOI	10.1145/1651291.1651294
Language	English
Publisher	Association for Computing Machinery (ACM)
Publisher Date	2009-11-06
Publisher Place	New York
Access Restriction	Subscribed
Subject Keyword	Referential partitioning Star join query optimization Join order problem Physical design
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