Supporting Database Applications as a Service
Proceedings - International Conference on Data EngineeringPublished 1 March 2009Open access
Mei Hui, Dawei Jiang, Guoliang Li, Yuan Zhou
Citations73
SJR quartileQ4
SJR score0.11
SNIP0.06
Generate an AI Snapshot to get a quick, structured summary of this paper.
Study Snapshot
ObjectiveStudy objective
MethodsResearch methodology
PopulationPopulation studied
Sample sizeSample sizes
OutcomesStudy outcomes here
ResultsStudy results comes here
LimitationsResearch study limitations comes here
A concise AI-generated summary of the paper will appear here once you click Generate AI Snapshot.
TL;DR
The experimental results show that the proposed approach is a promising multi-tenancy storage and indexing scheme which can be easily integrated into existing DBMS and extended MySQL based on the proposed design and conducted extensive experiments.
Abstract
10.1109/ICDE.2009.82
Keywords
Computer Science
Bigtable: a distributed storage system for structured data
1,955 Citations2006Fay W. Chang, Jay B. Dean +7 more
Proceedings of the VLDB EndowmentPNUTS
960 Citations2008Brian F. Cooper, Raghu Ramakrishnan +7 more
PNUTS provides data storage organized as hashed or ordered tables, low latency for large numbers of concurrent requests including updates and queries, and novel per-record consistency guarantees and utilizes automated load-balancing and failover to reduce operational complexity.
Providing database as a service
617 Citations2003Hakan Hacígümüş, B. R. Iyer +1 more
A novel paradigm for data management in which a third party service provider hosts "database as a service", providing its customers with seamless mechanisms to create, store, and access their databases at the host site is explored.
Dynamic authenticated index structures for outsourced databases
413 Citations2006Li Fei-Fei, Marios Hadjieleftheriou +2 more
This work defines a variety of essential and practical cost metrics associated with ODB systems and looks at solutions that can handle dynamic scenarios, where owners periodically update the data residing at the servers, both for static and dynamic environments.
Multi-tenant databases for software as a service
262 Citations2008Stefan Aulbach, Torsten Grust +3 more
A new schema-mapping technique for multi-tenancy called Chunk Folding is described, where the logical tables are vertically partitioned into chunks that are folded together into different physical multi-Tenant tables and joined as needed.
Storage and Querying of E-Commerce Data
178 Citations2001Rakesh Agrawal, Amit Somani +1 more
This work represents objects in a vertical format storing an object as a set of tuples, and creates a logical horizontal view of the vertical representation and transforms queries on this view to the vertical table.
ACM Transactions on Database SystemsView indexing in relational databases
169 Citations1982N. Roussopoulos
This paper investigates the problem of selecting an optimal index set of views and describes an efficient algorithm for this selection.
Query execution assurance for outsourced databases
142 Citations2005Radu Sion
This work introduces query execution proofs; for each executed batch of queries the database service provider is required to provide a strong cryptographic proof that provides assurance that the queries were actually executed correctly over their entire target data set.
ACM SIGMOD RecordThe case for partial indexes
115 Citations1989Michael Stonebraker
This paper suggests the advantages that result from indexes which contain only some of the possible values in a column of a relation.
Extending RDBMSs To Support Sparse Datasets Using An Interpreted Attribute Storage Format
90 Citations2006Jennifer Beckmann, Alan Halverson +2 more
This paper argues that the proper way to handle sparse data is not to use a vertical schema, but rather to extend the RDBMS tuple storage format to allow the representation of sparse attributes as interpreted fields, and shows that the interpreted storage approach dominates in query efficiency and ease-of-use over the current horizontal storage and vertical schema approaches over a wide range of queries.
Conference on Innovative Data Systems ResearchColumn Stores For Wide and Sparse Data
64 Citations2007Daniel J. Abadi
It is speculated that column-stores may be good storage layers for Semantic Web data, XML data, and data with GEM-style schemas.
The case for a wide-table approach to manage sparse relational data sets
57 Citations2007Eric Chu, Jennifer Beckmann +1 more
This paper argues that the single-table approach is a necessary component of self-managing database systems because it frees users from a tedious and potentially ineffective schema-design phase when managing sparse data sets.
Sharoes: A Data Sharing Platform for Outsourced Enterprise Storage Environments
47 Citations2008Aameek Singh, Ling Liu
Conference on Innovative Data Systems ResearchOne table stores all: Enabling painless free-and-easy data publishing and sharing.
22 Citations2007Beng Chin Ooi, Bei Yu +1 more
A free-and-easy data publishing and sharing system based on folksonomy that accepts data objects described with user-created metadata, called data units, and devise a generic table model for storing and representing the data units of various structures.
ACM SIGMOD RecordCommunity systems research at Yahoo!
12 Citations2007Community Systems Group
The ongoing research efforts within the Community Systems group here at Yahoo! Research to address the challenges of systems and community in the next generation of web experiences centered around people and social networks are described.
National University of SingaporeOne Table Stores All: Enabling Painless Free-and-Easy Data Publishing and Sharing
7 Citations2008Bei Yu