Sciweavers

21 search results - page 3 / 5
» Stacked indexed views in microsoft SQL server
Sort
View
SIGMOD
1998
ACM
145views Database» more  SIGMOD 1998»
13 years 10 months ago
AutoAdmin 'What-if' Index Analysis Utility
As databases get widely deployed, it becomes increasingly important to reduce the overhead of database administration. An important aspect of data administration that critically i...
Surajit Chaudhuri, Vivek R. Narasayya
VLDB
2004
ACM
125views Database» more  VLDB 2004»
13 years 11 months ago
Indexing XML Data Stored in a Relational Database
As XML usage grows for both data-centric and document-centric applications, introducing native support for XML data in relational databases brings significant benefits. It provide...
Shankar Pal, Istvan Cseri, Gideon Schaller, Oliver...
VLDB
2000
ACM
166views Database» more  VLDB 2000»
13 years 9 months ago
Oracle8i Index-Organized Table and Its Application to New Domains
Primary B+ -tree, a variant of B+ -tree structure with row data in leaf blocks, is an ideal storage organization for queries involving exact match and/or range search on primary k...
Jagannathan Srinivasan, Souripriya Das, Chuck Frei...
ICDE
2007
IEEE
130views Database» more  ICDE 2007»
14 years 7 months ago
Dynamic Materialized Views
A conventional materialized view blindly materializes and maintains all rows of a view, even rows that are never accessed. We propose a more flexible materialization strategy aime...
Jingren Zhou, Jonathan Goldstein, Luping Ding, Per...
SIGMOD
2001
ACM
147views Database» more  SIGMOD 2001»
14 years 6 months ago
Optimizing Queries Using Materialized Views: A practical, scalable solution
Materialized views can provide massive improvements in query processing time, especially for aggregation queries over large tables. To realize this potential, the query optimizer ...
Jonathan Goldstein, Per-Åke Larson