Please use this identifier to cite or link to this item:
http://hdl.handle.net/1942/698
Full metadata record
DC Field | Value | Language |
---|---|---|
dc.contributor.author | VAN DEN BUSSCHE, Jan | - |
dc.contributor.author | VANSUMMEREN, Stijn | - |
dc.contributor.author | Vossen, Gottfried | - |
dc.date.accessioned | 2005-04-08T09:35:34Z | - |
dc.date.available | 2005-04-08T09:35:34Z | - |
dc.date.issued | 2004 | - |
dc.identifier.citation | ADVANCES IN DATABASE TECHNOLOGY - EDBT 2004, PROCEEDINGS. p. 823-825 | - |
dc.identifier.isbn | 3-540-21200-0 | - |
dc.identifier.issn | 0302-9743 | - |
dc.identifier.uri | http://hdl.handle.net/1942/698 | - |
dc.description.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? | - |
dc.format.extent | 93399 bytes | - |
dc.format.mimetype | application/pdf | - |
dc.language.iso | en | - |
dc.publisher | Springer-Verlag | - |
dc.relation.ispartofseries | LECTURE NOTES IN COMPUTER SCIENCE | - |
dc.title | Meta-SQL: Towards Practical Meta-Querying | - |
dc.type | Journal Contribution | - |
local.bibliographicCitation.conferencename | ADVANCES IN DATABASE TECHNOLOGY - EDBT 2004 | - |
dc.identifier.epage | 825 | - |
dc.identifier.spage | 823 | - |
local.bibliographicCitation.jcat | A1 | - |
local.type.refereed | Refereed | - |
local.type.specified | Article | - |
local.relation.ispartofseriesnr | 2992 | - |
dc.bibliographicCitation.oldjcat | A1 | - |
dc.identifier.doi | 10.1007/978-3-540-24741-8_48 | - |
dc.identifier.isi | 000189447000048 | - |
item.fullcitation | VAN DEN BUSSCHE, Jan; VANSUMMEREN, Stijn & Vossen, Gottfried (2004) Meta-SQL: Towards Practical Meta-Querying. In: ADVANCES IN DATABASE TECHNOLOGY - EDBT 2004, PROCEEDINGS. p. 823-825. | - |
item.fulltext | With Fulltext | - |
item.contributor | VAN DEN BUSSCHE, Jan | - |
item.contributor | VANSUMMEREN, Stijn | - |
item.contributor | Vossen, Gottfried | - |
item.accessRights | Open Access | - |
crisitem.journal.issn | 0302-9743 | - |
Appears in Collections: | Research publications |
Files in This Item:
File | Description | Size | Format | |
---|---|---|---|---|
MetaSQL.pdf | 91.21 kB | Adobe PDF | View/Open |
WEB OF SCIENCETM
Citations
1
checked on Sep 22, 2024
Page view(s)
72
checked on Nov 7, 2023
Download(s)
262
checked on Nov 7, 2023
Google ScholarTM
Check
Altmetric
Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.