NDLI: Real-time data warehouse loading methodology

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

IDEAS the pre-teen years

Ontology-based data source localization in a structured peer-to-peer environment

Enforcing time-constraints effectively for QoS-aware servers

Intensional semantics for RDF data structures

Towards generating ETL processes for incremental loading

A bottom-up approach for XML documents classification

Efficient algorithms for stream mining of constrained frequent patterns in a limited memory environment

Order-preserving optimization of twig queries with structural preferences

Dynamic data recovery for database systems based on fine grained transaction log

A comparative benchmark of large objects in relational databases

A DHT-based infrastructure for ad-hoc integration and querying of semantic data

Real-time data warehouse loading methodology

Ontology assisted query reformulation using the semantic and assertion capabilities of OWL-DL ontologies

A unified apriori-like algorithm for conjunctive query containment

EXsum: an XML summarization framework

Memory efficient subspace clustering for online data streams

Improved count suffix trees for natural language data

WIDS: a sensor-based online mining wireless intrusion detection system

A spot-matching framework for improving matching accuracy in protein 2-DE gel image analysis

Robust aggregation in peer-to-peer database systems

Efficiently loading and processing XML streams

Showing correctness of a replication algorithm in a component based system

Pruning attribute values from data cubes with diamond dicing

On the efficient search of an XML twig query in large DataGuide trees

H-IQTS: a semantics-aware histogram for compressing categorical OLAP data

A strategy to develop adaptive and interactive query brokers

Measuring text similarity with dynamic time warping

R2O transformation system: relation to ontology transformation for scalable data integration

Updates and views dependencies in semi-structured databases

Incremental view-based analysis of stock market data streams

Usage-driven storage structures for native XML databases

Pattern based processing of XPath queries

Real-time data warehouse loading methodology

Content Provider	ACM Digital Library
Author	Bernardino, Jorge Santos, Ricardo Jorge
Abstract	A data warehouse provides information for analytical processing, decision making and data mining tools. As the concept of real-time enterprise evolves, the synchronism between transactional data and data warehouses, statically implemented, has been redefined. Traditional data warehouse systems have static structures of their schemas and relationships between data, and therefore are not able to support any dynamics in their structure and content. Their data is only periodically updated because they are not prepared for continuous data integration. For real-time enterprises with needs in decision support purposes, real-time data warehouses seem to be very promising. In this paper we present a methodology on how to adapt data warehouse schemas and user-end OLAP queries for efficiently supporting real-time data integration. To accomplish this, we use techniques such as table structure replication and query predicate restrictions for selecting data, to enable continuously loading data in the data warehouse with minimum impact in query execution time. We demonstrate the efficiency of the method by analyzing its impact in query performance using benchmark TPC-H executing query workloads while simultaneously performing continuous data integration at various insertion time rates.
Starting Page	49
Ending Page	58
Page Count	10
File Format	PDF
ISBN	9781605581880
DOI	10.1145/1451940.1451949
Language	English
Publisher	Association for Computing Machinery (ACM)
Publisher Date	2008-09-10
Publisher Place	New York
Access Restriction	Subscribed
Subject Keyword	Data warehouse refreshment loading process Continuous data integration for data warehousing Real-time and active data warehousing
Content Type	Text
Resource Type	Article

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

Active Datawarehouse Loading by GUI Based ETL Procedure

Optimizing data warehouse loading procedures for enabling useful-time data warehousing

Zero-Latency Data Warehousing For

Designing data warehouse refreshment systems (1997).

Modeling and executing the data warehouse refreshment process (2000).

Problems and available solutions on the stage of Extract, Transform, and Loading in near real-time data warehousing (a literature study)

Modeling Data Warehouse Refreshment Process as a Workflow Application (1999)

24/7 Real-Time Data Warehousing: A Tool for Continuous Actionable Knowledge

Towards Near Real-Time Data Warehousing

Real-time data warehouse loading methodology

Similar Documents

Active Datawarehouse Loading by GUI Based ETL Procedure

Optimizing data warehouse loading procedures for enabling useful-time data warehousing

Zero-Latency Data Warehousing For

Designing data warehouse refreshment systems (1997).

Modeling and executing the data warehouse refreshment process (2000).

Problems and available solutions on the stage of Extract, Transform, and Loading in near real-time data warehousing (a literature study)

Modeling Data Warehouse Refreshment Process as a Workflow Application (1999)

24/7 Real-Time Data Warehousing: A Tool for Continuous Actionable Knowledge

Towards Near Real-Time Data Warehousing

Real-time data warehouse loading methodology