Sciweavers

3305 search results - page 12 / 661
» Can we Rely on SQL
Sort
View
ICDE
2007
IEEE
117views Database» more  ICDE 2007»
14 years 8 months ago
Unnesting Scalar SQL Queries in the Presence of Disjunction
Optimizing nested queries is an intricate problem. It becomes even harder if in a nested query the linking predicate or the correlation predicate occurs disjunctively. We present ...
Matthias Brantner, Norman May, Guido Moerkotte
GVD
2004
142views Database» more  GVD 2004»
13 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
SIGMOD
2006
ACM
112views Database» more  SIGMOD 2006»
14 years 7 months ago
Join minimization in XML-to-SQL translation: an algebraic approach
Consider an XML view defined over a relational database, and a user query specified over this view. This user XML query is typically processed using the following steps: (a) our t...
Murali Mani, Song Wang, Daniel J. Dougherty, Elke ...
VLDB
2004
ACM
144views Database» more  VLDB 2004»
14 years 25 days ago
Returning Modified Rows - SELECT Statements with Side Effects
SQL in the IBM® DB2® Universal Database™ for Linux®, UNIX®, and Windows® (DB2 UDB) database management product has been extended to support nested INSERT, UPDATE, and DELET...
Andreas Behm, Serge Rielau, Richard Swagerman
SEMWEB
2009
Springer
14 years 2 months ago
Classifying ELH Ontologies In SQL Databases
Abstract. The current implementations of ontology classification procedures use the main memory of the computer for loading and processing ontologies, which soon can become one of...
Vincent Delaitre, Yevgeny Kazakov