www.uhasselt.be
DSpace

Document Server@UHasselt >
Research >
Research publications >

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
Citation: ADVANCES IN DATABASE TECHNOLOGY - EDBT 2004, PROCEEDINGS. p. 823-825
Series/Report: LECTURE NOTES IN COMPUTER SCIENCE, 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?
URI: http://hdl.handle.net/1942/698
DOI: 10.1007/978-3-540-24741-8_48
ISI #: 000189447000048
ISBN: 3-540-21200-0
ISSN: 0302-9743
Category: A1
Type: Journal Contribution
Appears in Collections: Research publications

Files in This Item:

Description SizeFormat
N/A91.21 kBAdobe PDF

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