|
| This Article | ||
| ||
| Share | ||
| Bibliographic References | ||
| Add to: | ||
 Digg  Furl  Spurl  Blink  Simpy  Google  Del.icio.us  Y!MyWeb | ||
| Search | ||
| ||
2008 IEEE 24th International Conference on Data Engineering
Filtered Indices and Their Use in Flexible Schema Scenarios
Cancun, Mexico
April 07-April 12
ISBN: 978-1-4244-1836-7
| ASCII Text | x | ||
| Srini Acharya, Cesar Galindo-Legaria, Milind Joshi, Babu Krishnaswamy, Stefano Stefani, Pawel Terlecki, "Filtered Indices and Their Use in Flexible Schema Scenarios," Data Engineering, International Conference on, pp. 1259-1266, 2008 IEEE 24th International Conference on Data Engineering, 2008. | |||
| BibTex | x | ||
| @article{ 10.1109/ICDE.2008.4497535, author = {Srini Acharya and Cesar Galindo-Legaria and Milind Joshi and Babu Krishnaswamy and Stefano Stefani and Pawel Terlecki}, title = {Filtered Indices and Their Use in Flexible Schema Scenarios}, journal ={Data Engineering, International Conference on}, volume = {0}, year = {2008}, isbn = {978-1-4244-1836-7}, pages = {1259-1266}, doi = {http://doi.ieeecomputersociety.org/10.1109/ICDE.2008.4497535}, publisher = {IEEE Computer Society}, address = {Los Alamitos, CA, USA}, } | |||
| RefWorks Procite/RefMan/Endnote | x | ||
| TY - CONF JO - Data Engineering, International Conference on TI - Filtered Indices and Their Use in Flexible Schema Scenarios SN - 978-1-4244-1836-7 SP1259 EP1266 A1 - Srini Acharya, A1 - Cesar Galindo-Legaria, A1 - Milind Joshi, A1 - Babu Krishnaswamy, A1 - Stefano Stefani, A1 - Pawel Terlecki, PY - 2008 VL - 0 JA - Data Engineering, International Conference on ER - | |||
Efficient and convenient handling of heterogeneous data is a current challenge for data management systems. In this paper, we discuss several common relational approaches to represent heterogeneity and argue for a design based on a single wide-table, referred to as a flexible schema. For this scenario, we focus on partial indexation and its support for efficient data storage and processing. Filtered indices provide partial indexation functionality in the Microsoft SQL Server product. We describe here the implementation of this feature, including index utilization in queries, index maintenance and query parameterization issues. Our performance experiments validate the expected benefits of the approach in our implementation.
Citation:
Srini Acharya, Cesar Galindo-Legaria, Milind Joshi, Babu Krishnaswamy, Stefano Stefani, Pawel Terlecki, "Filtered Indices and Their Use in Flexible Schema Scenarios," icde, pp.1259-1266, 2008 IEEE 24th International Conference on Data Engineering, 2008
Usage of this product signifies your acceptance of the Terms of Use.