Sciweavers

Share
ICDE
2012
IEEE
298views Database» more  ICDE 2012»
6 years 10 months ago
Mapping XML to a Wide Sparse Table
— XML is commonly supported by SQL database systems. However, existing mappings of XML to tables can only deliver satisfactory query performance for limited use cases. In this pa...
Liang Jeff Chen, Philip A. Bernstein, Peter Carlin...
ICDE
2011
IEEE
243views Database» more  ICDE 2011»
7 years 12 months ago
Interactive SQL query suggestion: Making databases user-friendly
— SQL is a classical and powerful tool for querying relational databases. However, it is rather hard for inexperienced users to pose SQL queries, as they are required to be pro...
Ju Fan, Guoliang Li, Lizhu Zhou
ICDE
2011
IEEE
220views Database» more  ICDE 2011»
7 years 12 months ago
Generating test data for killing SQL mutants: A constraint-based approach
—Complex SQL queries are widely used today, but it is rather difficult to check if a complex query has been written correctly. Formal verification based on comparing a specifi...
Shetal Shah, S. Sudarshan, Suhas Kajbaje, Sandeep ...
GVD
2004
142views Database» more  GVD 2004»
8 years 9 months ago
Semantic Errors in SQL Queries: A Quite Complete List
We investigate classes of SQL queries which are syntactically correct, but certainly not intended, no matter for which task the query was written. For instance, queries that are c...
Christian Goldberg, Stefan Brass
GVD
2004
111views Database» more  GVD 2004»
8 years 9 months ago
Detecting Logical Errors in SQL Queries
Abstract. Checking the consistency of query conditions is an old problem, and there are already many proposed solutions. Since the problem is in general undecidable, there is not a...
Stefan Brass, Christian Goldberg
VLDB
1987
ACM
108views Database» more  VLDB 1987»
8 years 11 months ago
Translating and Optimizing SQL Queries Having Aggregates
is at least ae powerful as SQL. Two well known relational query languages that have a sound theoretical foundation are relational algebra and relational calculus. As SQL is more cl...
Günter von Bültzingsloewen
VLDB
1995
ACM
132views Database» more  VLDB 1995»
8 years 11 months ago
Coloring Away Communication in Parallel Query Optimization
We address the problem of finding parallel plans for SQL queries using the two-phase approach of join ordering and query rewrite (JOQR) followed by parallelization. We focus on t...
Waqar Hasan, Rajeev Motwani
DASFAA
2007
IEEE
205views Database» more  DASFAA 2007»
9 years 4 days ago
Efficient Support for Ordered XPath Processing in Tree-Unaware Commercial Relational Databases
Abstract. In this paper, we present a novel ordered XPATH evaluation in treeunaware RDBMS. The novelties of our approach lies in the followings. (a) We propose a novel XML storage ...
Boon-Siew Seah, Klarinda G. Widjanarko, Sourav S. ...
SIGMOD
2000
ACM
161views Database» more  SIGMOD 2000»
9 years 17 days ago
Answering Complex SQL Queries Using Automatic Summary Tables
We investigate the problem of using materialized views to answer SQL queries. We focus on modern decision-support queries, which involve joins, arithmetic operations and other (po...
Markos Zaharioudakis, Roberta Cochrane, George Lap...
EDBT
2009
ACM
160views Database» more  EDBT 2009»
9 years 26 days ago
Estimating aggregates in time-constrained approximate queries in Oracle
The concept of time-constrained SQL queries was introduced to address the problem of long-running SQL queries. A key approach adopted for supporting time-constrained SQL queries i...
Ying Hu, Seema Sundara, Jagannathan Srinivasan
books