NDLI: Supporting table partitioning by reference in oracle

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

Capacity constrained assignment in spatial databases

Discovering bucket orders from full rankings

Towards identity anonymization on graphs

Near-optimal algorithms for shared filter evaluation in data stream systems

CRD: fast co-clustering on large datasets utilizing sampling-based matrix decomposition

Monochromatic and bichromatic reverse skyline search over uncertain databases

Building a database on S3

Relational-style XML query

Cost-based variable-length-gram selection for string collections to support approximate queries efficiently

Graphs-at-a-time: query language and access methods for graph databases

Privacy-MaxEnt: integrating background knowledge in privacy quantification

Relational joins on graphics processors

Efficient aggregation for graph summarization

Query-based partitioning of documents and indexes for information lifecycle management

Ranking queries on uncertain data: a probabilistic threshold approach

Serializable isolation for snapshot databases

Sampling cube: a framework for statistical olap over sampling data

Interactive generation of integrated schemas

SQAK: doing more with keywords

Configuration-parametric query optimization for physical design tuning

Efficient provenance storage

Handling data skew in parallel joins in shared-nothing systems

.NET database programmability and extensibility in microsoft SQL server

SPADE: the system s declarative stream processing engine

Damia: data mashups for intranet applications

SGL: a scalable language for data-driven games

SchemaScope: a system for inferring and cleaning XML schemas

Borealis-R: a replication-transparent stream processing system for wide-area monitoring applications

Provenance and scientific workflows: challenges and opportunities

Corrigendum to "efficient similarity search and classification via rank aggregation" by Ronald Fagin, Ravi Kumar and D. Sivakumar (proc. SIGMOD'03)

PODS Alberto O. Mendelzon Test-of-Time Award 2008

Extreme data mining

$ST^{2}B-tree:$ a self-tunable spatio-temporal $b^{+}-tree$ index for moving objects

Ad-hoc aggregations of ranked lists in the presence of hierarchies

Dynamic anonymization: accurate statistical analysis with privacy preservation

Efficient pattern matching over event streams

Outlier-robust clustering using independent components

Angle-based space partitioning for efficient parallel skyline computation

Paths to stardom: calibrating the potential of a peer-based data management system

Query biased snippet generation in XML search

Approximate embedding-based subsequence matching of time series

Graph summarization with bounded error

Preservation of proximity privacy in publishing numerical sensitive data

Optimizing complex queries with multiple relation instances

Efficient algorithms for exact ranked twig-pattern matching over graphs

Skippy: a new snapshot indexing method for time travel in the storage manager

MCDB: a monte carlo approach to managing uncertain data

Middleware-based database replication: the gaps between theory and practice

Querying continuous functions in a database system

Pay-as-you-go user feedback for dataspace systems

EASE: an effective 3-in-1 keyword search method for unstructured, semi-structured and structured data

Automatic virtual machine configuration for database workloads

Efficient lineage tracking for scientific workflows

Efficient and scalable statistics gathering for large databases in Oracle 11g

Pig latin: a not-so-foreign language for data processing

Query-aware partitioning for monitoring massive network data streams

Effective and efficient semantic web data management over DB2

The DBO database system

DiMaC: a system for cleaning disguised missing data

Tinycasper: a privacy-preserving aggregate location monitoring system in wireless sensor networks

Object/relational mapping 2008: hibernate and the entity data model (edm)

SIGMOD 10-year Test-of-Time Award: “Integration of heterogeneous databases without common domains using queries based on textual simularity”

Extreme visualization: squeezing a billion records into a million pixels

Scalable network distance browsing in spatial databases

ARCube: supporting ranking aggregate queries in partially materialized data cubes

Private queries in location based services: anonymizers are not necessary

Scalable regular expression matching on data streams

Efficient EMD-based similarity search in multimedia databases via flexible dimensionality reduction

Categorical skylines for streaming data

Just-in-time query retrieval over partially indexed data on structured P2P overlays

Cooperative XPath caching

Sampling time-based sliding windows in bounded space

Mining significant graph patterns by leap search

Stream firewalling of xml constraints

Dynamic programming strikes back

Efficiently answering reachability queries on very large directed graphs

OLAP on sequence data

Query efficiency in probabilistic XML models

On efficient top-k query processing in highly distributed environments

An efficient filter for approximate membership checking

Bootstrapping pay-as-you-go data integration systems

A graph method for keyword-based selection of the top-K databases

Column-stores vs. row-stores: how different are they really?

Discovering topical structures of databases

Grouping and optimization of XPath expressions in $DB2^{®}$ pureXML

Supporting table partitioning by reference in oracle

Helping satisfy multiple objectives during a service desk conversation

Multi-tenant databases for software as a service: schema-mapping techniques

Stretch 'n' shrink: resizing queries to user preferences

An xml index advisor for DB2

The Demaq system: declarative development of distributed applications

Query answering techniques on uncertain and probabilistic data: tutorial summary

SIGMOD Best Dissertation Award: “Efficient query processing over inconsistent databases”

Extreme streaming: business optimization driving algorithmic challenges

Efficient storage scheme and query processing for supply chain management using RFID

XML query optimization in the presence of side effects

Mining relationships among interval-based events for classification

CSV: visualizing and mining cohesive subgraphs

Generating targeted queries for database testing

Adding magic to an optimising datalog compiler

Minimization of tree pattern queries with constraints

Improving suffix array locality for fast pattern matching on disk

Event queries on correlated probabilistic streams

Efficient bulk insertion into a distributed ordered table

Finding frequent items in probabilistic data

Supporting OLAP operations over imperfectly integrated taxonomies

Keyword proximity search in complex data graphs

OLTP through the looking glass, and what we found there

Toward best-effort information extraction

A case for flash memory ssd in enterprise database applications

Oracle database replay

Spatial indexing in microsoft SQL server 2008

Incorporating string transformations in record matching

Clip: a tool for mapping hierarchical schemas

ProSem: scalable wide-area publish/subscribe

Information fusion in wireless sensor networks

Best Newcomer Award: Evaluating rank joins with optimal costs

SEMMO: a scalable engine for massively multiplayer online games

UQBE: uncertain query by example for web service mashup

A demonstration of Cascadia through a digital diary application

Introduction to recommender systems

Orion 2.0: native support for uncertain data

Muse: a system for understanding and designing mappings

From del.icio.us to x.qui.site: recommendations in social tagging sites

Building a global location search service

NAGA: harvesting, searching and ranking knowledge

Enriching topic-based publish-subscribe systems with related content

Freebase: a collaboratively created graph database for structuring human knowledge

The Spicy system: towards a notion of mapping quality

XRPC: distributed XQuery and update processing with heterogeneous XQuery engines

Querying and re-using workflows with VsTrails

XArch: archiving scientific and reference data

XQuery in the browser

HERMES: aggregative LBS via a trajectory DB engine

LearnPADS: automatic tool generation from ad hoc data

BibNetMiner: mining bibliographic information networks

Supporting table partitioning by reference in oracle

Content Provider	ACM Digital Library
Author	Raghavan, Ananth Srinivasan, Jagannathan Das, Souripriya Chong, Eugene Inseok Shankar, Shrikanth Eadon, George
Abstract	Partitioning is typically employed on large-scale data to improve manageability, availability, and performance. However, for tables connected by a referential constraint (capturing a parent-child relationship), the current approaches require individually partitioning each table thereby burdening the user with the task of maintaining the tables equi-partitioned, which not only is cumbersome but also error prone. This paper proposes a new partitioning method (partition by reference) that allows tables with a parent-child relationship to be logically equi-partitioned by inheriting the partition key from the parent table without duplicating the key columns. The partitioning key is resolved through an existing parent-child relationship, enforced by an active referential constraint. This logical dependency is used to automatically i) cascade partition maintenance operations performed on parent table to child tables, and ii) handle migration of child rows when partition key or parent key in parent table is updated, as a single atomic operation. This method has been introduced in Oracle Database 11gR1 with support for tables with both single level and composite partitioning methods. The paper describes the key concepts of table partitioning by reference method, discusses the design and implementation challenges, and presents an experimental study covering a usage scenario common in Information Life Cycle Management (ILM) applications.
Starting Page	1111
Ending Page	1122
Page Count	12
File Format	PDF
ISBN	9781605581026
DOI	10.1145/1376616.1376727
Language	English
Publisher	Association for Computing Machinery (ACM)
Publisher Date	2008-06-09
Publisher Place	New York
Access Restriction	Subscribed
Subject Keyword	Partition by reference Vertical partitioning Partition pruning Partitioning Partition maintenance Partition-wise join Information lifecycle management
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