NDLI: R-MESHJOIN for near-real-time data warehousing

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

Query processing in Oracle DBMS

Using ontologies to discover fact IDs

Towards OLAP query reformulation in peer-to-peer data warehousing

Relational versus non-relational database systems for data warehousing

Time-HOBI: indexing dimension hierarchies by means of hierarchically organized bitmaps

Multiversion data warehouse constraints

Immediate materialized views with outerjoins

Exploring graphics processing units as parallel coprocessors for online aggregation

A methodology and tool for conceptual designing a data warehouse from ontology-based sources

R-MESHJOIN for near-real-time data warehousing

Integrating OLAP and recommender systems: an evaluation perspective

Towards readable layouts for modeling data warehouses

Repairing OLAP queries in databases with referential integrity errors

Balancing accuracy and privacy of OLAP aggregations on data cubes

Towards the definition of spatial data warehouses integrity constraints with spatial OCL

Context-aware generalization for cube measures

R-MESHJOIN for near-real-time data warehousing

Content Provider	ACM Digital Library
Author	Weber, Gerald Naeem, M. Asif Dobbie, Gillian Alam, Shafiq
Abstract	To fulfill the increasing demand of business for the latest information, current data integration approaches are moving towards real-time updates. One important element in real-time data integration is the join of a continuous incoming data stream with a disk-based relation. In this paper we investigate a stream-based join algorithm, called mesh join (MESHJOIN), and propose an improved version called reduced MESHJOIN (R-MESHJOIN). Both algorithms tune the memory, allocating parts of the memory to key components. In MESHJOIN there is a dependency between the size of partitions in an internal queue for the stream data and the number of iterations required to bring the disk-based relation into memory. This dependency hampers the optimal distribution of memory among the join components. In particular the size of the disk-buffer varies with the size of the disk-based relation which is unnecessary. On the other hand the R-MESHJOIN algorithm removes this dependency. This enables an optimal distribution of available memory among the join components. In R-MESHJOIN a change in the size of the disk-based relation does not affect the size of the disk-buffer. An experimental study is conducted in order to validate the arguments.
Starting Page	53
Ending Page	60
Page Count	8
File Format	PDF
ISBN	9781450303835
DOI	10.1145/1871940.1871952
Language	English
Publisher	Association for Computing Machinery (ACM)
Publisher Date	2010-10-30
Publisher Place	New York
Access Restriction	Subscribed
Subject Keyword	Performance optimization and tuning Data warehousing foundations and architectures Real-time data warehouses
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