Matches in SemOpenAlex for { <https://semopenalex.org/work/W1888032506> ?p ?o ?g. }
Showing items 1 to 45 of
45
with 100 items per page.
- W1888032506 endingPage "825" @default.
- W1888032506 startingPage "823" @default.
- W1888032506 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) “Which queries in the log do the most joins?” (ii) “Which queries in the log return an empty answer on the current instance of the database?” (iii) View expansion: “Replace, in each query in the log, each view name by its definition as given in the system catalog.” (iv) Given a list of new view definitions (under the old names): “Which queries in the log give a different answer on the current instance under the new view definitions?”" @default.
- W1888032506 created "2016-06-24" @default.
- W1888032506 creator A5022558461 @default.
- W1888032506 creator A5083197733 @default.
- W1888032506 creator A5089823917 @default.
- W1888032506 date "2004-01-01" @default.
- W1888032506 modified "2023-09-25" @default.
- W1888032506 title "Meta-SQL: Towards Practical Meta-Querying" @default.
- W1888032506 doi "https://doi.org/10.1007/978-3-540-24741-8_48" @default.
- W1888032506 hasPublicationYear "2004" @default.
- W1888032506 type Work @default.
- W1888032506 sameAs 1888032506 @default.
- W1888032506 citedByCount "6" @default.
- W1888032506 countsByYear W18880325062013 @default.
- W1888032506 crossrefType "book-chapter" @default.
- W1888032506 hasAuthorship W1888032506A5022558461 @default.
- W1888032506 hasAuthorship W1888032506A5083197733 @default.
- W1888032506 hasAuthorship W1888032506A5089823917 @default.
- W1888032506 hasBestOaLocation W18880325062 @default.
- W1888032506 hasConcept C41008148 @default.
- W1888032506 hasConcept C510870499 @default.
- W1888032506 hasConcept C77088390 @default.
- W1888032506 hasConceptScore W1888032506C41008148 @default.
- W1888032506 hasConceptScore W1888032506C510870499 @default.
- W1888032506 hasConceptScore W1888032506C77088390 @default.
- W1888032506 hasLocation W18880325061 @default.
- W1888032506 hasLocation W18880325062 @default.
- W1888032506 hasOpenAccess W1888032506 @default.
- W1888032506 hasPrimaryLocation W18880325061 @default.
- W1888032506 hasRelatedWork W135304835 @default.
- W1888032506 hasRelatedWork W1545523085 @default.
- W1888032506 hasRelatedWork W2003616250 @default.
- W1888032506 hasRelatedWork W2131119797 @default.
- W1888032506 hasRelatedWork W2356335648 @default.
- W1888032506 hasRelatedWork W2367232817 @default.
- W1888032506 hasRelatedWork W2368606217 @default.
- W1888032506 hasRelatedWork W2374348909 @default.
- W1888032506 hasRelatedWork W2380770581 @default.
- W1888032506 hasRelatedWork W2925841936 @default.
- W1888032506 isParatext "false" @default.
- W1888032506 isRetracted "false" @default.
- W1888032506 magId "1888032506" @default.
- W1888032506 workType "book-chapter" @default.