40,808 Hits in 2.9 sec

Completeness of queries over SQL databases

Werner Nutt, Simon Razniewski
2012 Proceedings of the 21st ACM international conference on Information and knowledge management - CIKM '12  
of a query using completeness assertions for (parts of) tables Completeness of Queries over SQL Databases 31.10.2012 7 ... vocational schools use the information system of the province to manage  ...  Implementation techniques [Demo today] Completeness of Queries over SQL Databases 31.10.2012 10 Table completeness statement completeness holds over the incomplete database (D i ,D a ) because  ... 
doi:10.1145/2396761.2396875 dblp:conf/cikm/NuttR12 fatcat:zahpborpoze4lj5cdoxticxhsa

SQL Queries Over Unstructured Text Databases

Alpa Jain, AnHai Doan, Luis Gravano
2007 2007 IEEE 23rd International Conference on Data Engineering  
By processing a text database with information extraction systems, we can define a variety of structured "relations," over which we can then issue SQL queries.  ...  avoid processing large numbers of useless documents) may compromise result completeness.  ...  Discussion We performed an extensive evaluation of our query processing approach, which relies on document sampling to estimate the goodness of the candidate query execution strategies.  ... 
doi:10.1109/icde.2007.368986 dblp:conf/icde/JainDG07 fatcat:ggmyaurtynhx5khoktgmppg7ay

SQL Query Completion for Data Exploration [article]

Marie Le Guilly, Vasile-Marian Scuturici
2018 arXiv   pre-print
Since the process can be repeated over and over again -- until the data analyst reaches her data of interest --, SQL query completion facilitates the exploration of databases.  ...  SQL query completion has been implemented in a SQL editor on top of a database management system.  ...  This semantic SQL query completion allows the exploration of databases, since the process can be iteratively repeated over and over again until the data analyst reaches arXiv:1802.02872v1 [cs.DB] 8 Feb  ... 
arXiv:1802.02872v1 fatcat:chl6z4ekubfifmqyky7w47ejxe

Point-based temporal extensions of SQL and their efficient implementation [chapter]

David Toman
1998 Lecture Notes in Computer Science  
In addition we provide an efficient query evaluation procedure based on a compilation technique that translates SQL/TP queries to SQL/92.  ...  Therefore existing off-shelf database systems can be used as back-ends for managing temporal data. 1 Why yet another temporal extension of SQL?  ...  Figure 1 Then we say that Q is a SQL/TP query over the class of concrete interval-based temporal databases.  ... 
doi:10.1007/bfb0053704 fatcat:ycv4x5unwza3fpxygyrlnkadzu

Containment of Conjunctive Queries over Databases with Null Values [chapter]

Carles Farré, Werner Nutt, Ernest Teniente, Toni Urpí
2006 Lecture Notes in Computer Science  
We study containment of conjunctive queries that are evaluated over databases that may contain tuples with null values.  ...  We assume the semantics of SQL for single block queries with a SELECT DISTINCT clause.  ...  In the present paper we study null containment of conjunctive queries, that is, containment under set semantics over databases that contain null values, where conditions involving nulls are evaluated as  ... 
doi:10.1007/11965893_27 fatcat:my72etzbybbnrncwduqko4cooe

An End-to-end Neural Natural Language Interface for Databases [article]

Prasetya Utama, Nathaniel Weir, Fuat Basik, Carsten Binnig, Ugur Cetintemel, Benjamin Hättasch, Amir Ilkhechi, Shekar Ramaswamy, Arif Usta
2018 arXiv   pre-print
Second, to support the users in phrasing questions without knowing the database schema and the query features, DBPal provides a learned auto-completion model that suggests partial query extensions to users  ...  However, understanding natural language questions and translating them accurately to SQL is a challenging task, and thus Natural Language Interfaces for Databases (NLIDBs) have not yet made their way into  ...  Considering the unawareness of users regarding the database schema, auto-completion becomes even more crucial.  ... 
arXiv:1804.00401v1 fatcat:hblzvhczajcmzi3suknmk6tuhy

MQT, an Approach for Run-Time Query Translation: From EOL to SQL

Xabier De Carlos, Goiuria Sagardui, Salvador Trujillo
2014 ACM/IEEE International Conference on Model Driven Engineering Languages and Systems  
This paper presents MQT, an approach that translates EOL (model-level queries) to SQL (persistence-level queries) at runtime.  ...  Translation process used by MQT is described through two examples and we also evaluate performance of the approach.  ...  MQT only executes the translated SQL query over the database when the results are needed.  ... 
dblp:conf/models/CarlosST14a fatcat:ryy4py5c4za4nita6f6zznmj3a

On the Codd semantics of SQL nulls

Paolo Guagliardo, Leonid Libkin
2018 Information Systems  
To use results about Codd nulls for real-life SQL queries, we need to understand which queries preserve the Codd interpretation of SQL nulls.  ...  For such queries, interpreting SQL nulls as Codd nulls would incorrectly change the semantics of query answers.  ...  For queries, the NNC condition then ensures that the input table of each " operation is indeed complete.  ... 
doi:10.1016/ fatcat:viing5rmvvdndges7h2wbogexa


Fuat Basik, Benjamin Hättasch, Amir Ilkhechi, Arif Usta, Shekar Ramaswamy, Prasetya Utama, Nathaniel Weir, Carsten Binnig, Ugur Cetintemel
2018 Proceedings of the 2018 International Conference on Management of Data - SIGMOD '18  
Second, to support the users in phrasing questions without knowing the database schema and the query features, DBPal provides a learned auto-completion model that suggests to users partial query extensions  ...  to SQL, making the translation process more robust to paraphrasing and linguistic variations.  ...  Interactive Query Auto-Completion. We provide real-time auto-completion and query suggestion to help users who may be unfamiliar with the database schema or the supported query features.  ... 
doi:10.1145/3183713.3193562 dblp:conf/sigmod/BasikHIURUWBC18 fatcat:dgjqy2ac4jguxnsfj5qziybzpy

SQL Anywhere: An Embeddable DBMS

Ivan T. Bowman, Peter Bumbulis, Dan Farrar, Anil K. Goel, Brendan Lucier, Anisoara Nica, G. N. Paulley, John Smirnios, Matthew Young-Lai
2007 IEEE Data Engineering Bulletin  
We present an overview of the embeddability features of SQL Anywhere, a full-function relational database system designed for frontline business environments with minimal administration.  ...  SQL Anywhere supports features common to enterprise-class database management systems, such as intra-query parallelism, materialized views, OLAP functionality, stored procedures, triggers, and hot failover  ...  This permits the OEM application to be in complete control of the user interface for the application. Active database support.  ... 
dblp:journals/debu/BowmanBFGLNPSY07 fatcat:yi2kz3vyyfaevhls24m6j44hs4

TransSQL: A Translation and Validation-Based Solution for SQL-injection Attacks

Kai-Xiang Zhang, Chia-Jun Lin, Shih-Jen Chen, Yanling Hwang, Hao-Lun Huang, Fu-Hau Hsu
2011 2011 First International Conference on Robot, Vision and Signal Processing  
SQL injection attacks, a class of injection flaw in which specially crafted input strings leads to illegal queries to databases, are one of the topmost threats to web applications.  ...  After queries are executed on a SQL database and a LDAP one, TransSQL checks the difference in responses between a SQL database and a LDAP one to detect and block SQL injection attacks.  ...  It seems completely different model in theory, but both of them have many common functions such as query and storage.  ... 
doi:10.1109/rvsp.2011.59 dblp:conf/rvsp/ZhangLCHHH11 fatcat:g52xtmjat5eetniyyfiqyc6ldq

Null values in SQL

John Grant
2008 SIGMOD record  
The purpose of this article is to show that, contrary to Rubinson's claim, Date's critique of query evaluation in the presence of null values in SQL is completely justified.  ...  In various writings over the past 20 years, such as [3], Date has pointed out that SQL produces incorrect answers to some queries where a null value is included in a table.  ...  DISCUSSION Over many years Date criticized the evaluation of queries in SQL involving null values.  ... 
doi:10.1145/1462571.1462575 fatcat:ob3qrr6isfbqnfh45pjgn4k3su


Torsten Grust, Manuel Mayr, Jan Rittinger, Sherif Sakr, Jens Teubner
2007 Proceedings of the 2007 ACM SIGMOD international conference on Management of data - SIGMOD '07  
In a sense, this demonstration thus lets relational algebra and SQL swap their traditional roles in database query processing.  ...  The result is a code generator that (1) supports an almost complete dialect of XQuery, (2) can target any RDBMS with a SQL:1999 language interface, and (3) exhibits quite promising performance characteristics  ...  Once query evaluation is complete, a database client can perform a single sequential scan over the result table to serialize the final XML output.  ... 
doi:10.1145/1247480.1247642 dblp:conf/sigmod/GrustMRST07 fatcat:fffwngyowjheth46lg4vowt65a

Novel Investigation Methodologies to Identify the SQL Server Query Performance

Muthukumar Murugesan, K. Karthikeyan, K. Sivakumar
2015 Indian Journal of Science and Technology  
Widely known fact that 60% of the performance problems are direct result of the inefficient queries. Method of Analysis: SQL Query is one of the most essential parts of application performance.  ...  Over the period, inefficient queries pull down the performance in live applications gradually. To achieve better application performance, proper database design and efficient query are needed.  ...  All these transactions should be captured in the database for further reference. Over the period, size of these databases will get increased to MBs and GBs of data.  ... 
doi:10.17485/ijst/2015/v8i27/70620 fatcat:3hfoamdcuvhwrok6unkkhxkt64

Semistructured Models, Queries and Algebras in the Big Data Era

Yannis Papakonstantinou
2016 Proceedings of the 2016 International Conference on Management of Data - SIGMOD '16  
form) features that SQL acquired over the years.  ...  We refer to SQL databases with JSON support as SQL/JSON databases.  ...  databases, SQL-on-Hadoop databases or middleware that operates over them: Amazon, Couchbase, MapR, Informatica (which develops middleware for data warehousing and virtual databases over SQL, NoSQL, Hadoop-on-SQL  ... 
doi:10.1145/2882903.2912573 dblp:conf/sigmod/Papakonstantinou16 fatcat:cxzkm73575dsldxyzcan2shtqi
« Previous Showing results 1 — 15 out of 40,808 results