NoDB: Efficient query execution on raw data files

Proceedings of the ACM SIGMOD International Conference on Management of Data

Volumn , Issue , 2012, Pages 241-252

  Alagiannis, Ioannis ^a   Borovica, Renata ^a   Branco, Miguel ^a   Idreos, Stratos ^b   Ailamaki, Anastasia ^a  

^a EPFL   (Switzerland)

^b CWI   (Netherlands)

Author keywords

adaptive loading; in situ querying; positional map

Indexed keywords

ADAPTIVE LOADING; CONVERSION COST; DATA COLLECTION; DATA TYPE; DATABASE ARCHITECTURE; FEATURE SETS; FULLY INTEGRATED; FUNDAMENTAL LIMITATIONS; IN-SITU; INDEXING MECHANISMS; PERFORMANCE BOTTLENECKS; POSITIONAL INFORMATION; POSTGRESQL; QUERY ENGINES; QUERY EXECUTION; QUERY PERFORMANCE; RAW DATA FILES; ROADMAP; SCIENTIFIC DATA; SOCIAL NETWORKS; TOKENIZING;

DATA ACQUISITION; DATA HANDLING; DATABASE SYSTEMS; DESIGN; IN SITU PROCESSING; LOADING;

SEARCH ENGINES;

EID: 84862692326     PISSN: 07308078     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/2213836.2213864     Document Type: Conference Paper

References (30)

1. S. Agrawal, S. Chaudhuri, L. Kollar, A. Marathe, V. Narasayya, and M. Syamala. Database tuning advisor for microsoft sql server 2005. In VLDB, 2004.
2. S. Agrawal, S. Chaudhuri, and V. R. Narasayya. Automated selection of materialized views and indexes in sql databases. In VLDB, 2000.
3. S. Agrawal, V. Narasayya, and B. Yang. Integrating vertical and horizontal partitioning into automated physical database design. In SIGMOD, 2004.
4. A. Ailamaki, V. Kantere, and D. Dash. Managing scientific data. Commun. ACM, 53:68-78, 2010.
5. N. Bruno and S. Chaudhuri. Automatic physical database tuning: a relaxation-based approach. In SIGMOD, 2005.
6. N. Bruno and S. Chaudhuri. To tune or not to tune?: a lightweight physical design alerter. In VLDB, 2006.
7. S. Chaudhuri and V. R. Narasayya. An efficient cost-driven index selection tool for microsoft sql server. In VLDB, 1997.
8. J. Cohen, B. Dolan, M. Dunlap, J. M. Hellerstein, and C. Welton. Mad skills: new analysis practices for big data. PVLDB, 2:1481-1492, 2009.
9. B. Dageville, D. Das, K. Dias, K. Yagoub, M. Zait, and M. Ziauddin. Automatic sql tuning in oracle 10g. In VLDB, 2004.
10. D. Dash, N. Polyzotis, and A. Ailamaki. Cophy: a scalable, portable, and interactive index advisor for large workloads. PVLDB, 4:362-372, 2011.
11. G. Graefe, S. Idreos, H. Kuno, and S. Manegold. Benchmarking adaptive indexing. In TPCTC, 2011.
12. G. Graefe and H. Kuno. Adaptive indexing for relational keys. ICDEW, 0:69-74, 2010.
13. G. Graefe and H. Kuno. Self-selecting, self-tuning, incrementally optimized indexes. In EDBT, 2010.
14. J. Gray, D. T. Liu, M. Nieto-Santisteban, A. Szalay, D. J. DeWitt, and G. Heber. Scientific data management in the coming decade. SIGMOD Rec., 34:34-41, 2005.
15. S. Idreos, I. Alagiannis, R. Johnson, and A. Ailamaki. Here are my data files. here are my queries. where are my results? In CIDR, 2011.
16. S. Idreos, M. L. Kersten, and S. Manegold. Database cracking. In CIDR, 2007.
17. S. Idreos, M. L. Kersten, and S. Manegold. Updating a cracked database. In SIGMOD, 2007.
18. S. Idreos, M. L. Kersten, and S. Manegold. Self-organizing tuple reconstruction in column-stores. In SIGMOD, 2009.
19. S. Idreos, S. Manegold, H. Kuno, and G. Graefe. Merging what's cracked, cracking what's merged: adaptive indexing in main-memory column-stores. PVLDB, 4:586-597, 2011.
20. H. V. Jagadish, A. Chapman, A. Elkiss, M. Jayapandian, Y. Li, A. Nandi, and C. Yu. Making database systems usable. In SIGMOD, 2007.
21. A. Jain, A. Doan, and L. Gravano. Optimizing sql queries over text databases. In ICDE, 2008.
22. M. L. Kersten, S. Idreos, S. Manegold, and E. Liarou. The researcher's guide to the data deluge: Querying a scientific database in just a few seconds. In VLDB, 2011.
23. K. Lorincz, K. Redwine, and J. Tov. Grep versus flatsql versus mysql: Queries using unix tools vs. a dbms, 2003.
24. A. Nandi and H. V.Jagadish. Guided interaction: Rethinking the query-result paradigm. In VLDB, 2011.
25. S. Papadomanolakis and A. Ailamaki. Autopart: Automating schema design for large scientific databases using data partitioning. In SSDBM, 2004.
26. M. T. Roth and P. M. Schwarz. Don't scrap it, wrap it! a wrapper architecture for legacy data sources. In VLDB, 1997.
27. K. Schnaitter, S. Abiteboul, T. Milo, and N. Polyzotis. Colt: continuous on-line tuning. In SIGMOD, 2006.
28. M. Stonebraker, J. Becla, D. J. DeWitt, K.-T. Lim, D. Maier, O. Ratzesberger, and S. B. Zdonik. Requirements for science data bases and scidb. In CIDR, 2009.
29. G. Valentin, M. Zuliani, D. C. Zilio, G. Lohman, and A. Skelley. Db2 advisor: An optimizer smart enough to recommend its own indexes. In ICDE, 2000.
30. D. C. Zilio, J. Rao, S. Lightstone, G. M. Lohman, A. J. Storm, C. Garcia-Arellano, and S. Fadden. Db2 design advisor: Integrated automatic physical database. In VLDB, 2004.