Please use this identifier to cite or link to this item: http://hdl.handle.net/1942/698
Title: Meta-SQL: Towards Practical Meta-Querying
Authors: VAN DEN BUSSCHE, Jan 
VANSUMMEREN, Stijn 
Vossen, Gottfried
Issue Date: 2004
Publisher: Springer-Verlag
Source: ADVANCES IN DATABASE TECHNOLOGY - EDBT 2004, PROCEEDINGS. p. 823-825
Series/Report: LECTURE NOTES IN COMPUTER SCIENCE
Series/Report no.: 2992
Abstract: Enterprise databases often contain not only ordinary data, but also queries. Examples are view definitions in the system catalog; usage logs or workloads; and stored procedures as in SQL/PSM or Postgres. Unfortunately, these queries are typically stored as long strings, which makes it hard to use standard SQL to express meta-queries: queries about queries. Meta-querying is an important activity in situations such as advanced database administration, database usage monitoring, and workload analysis. Here are some examples of meta-queries to a usage log. (i) ldquoWhich queries in the log do the most joins?rdquo (ii) ldquoWhich queries in the log return an empty answer on the current instance of the database?rdquo (iii) View expansion: ldquoReplace, in each query in the log, each view name by its definition as given in the system catalog.rdquo (iv) Given a list of new view definitions (under the old names): ldquoWhich queries in the log give a different answer on the current instance under the new view definitions?
Document URI: http://hdl.handle.net/1942/698
ISBN: 3-540-21200-0
ISSN: 0302-9743
DOI: 10.1007/978-3-540-24741-8_48
ISI #: 000189447000048
Category: A1
Type: Journal Contribution
Appears in Collections:Research publications

Files in This Item:
File Description SizeFormat 
MetaSQL.pdf91.21 kBAdobe PDFView/Open
Show full item record

WEB OF SCIENCETM
Citations

1
checked on May 21, 2022

Page view(s)

50
checked on May 20, 2022

Download(s)

156
checked on May 20, 2022

Google ScholarTM

Check

Altmetric


Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.