SODA: Generating SQL for business users

Proceedings of the VLDB Endowment

Volumn 5, Issue 10, 2012, Pages 932-943

  Blunschi, Lukas ^a   Jossen, Claudio ^b   Kossmann, Donald ^a   Mori, Magdalini ^b   Stockinger, Kurt ^b  

^a ETH ZURICH   (Switzerland)

^b Credit Suisse group   (Switzerland)

Author keywords

[No Author keywords available]

Indexed keywords

PATTERN MATCHING; SEARCH ENGINES;

BUSINESS ANALYSTS; BUSINESS-USERS; COMPLEX DATA WAREHOUSE; CURRENT COMPLEXITY; FINANCIAL SERVICES INDUSTRIES; GRAPH PATTERN MATCHING; KEYWORD QUERIES; TECHNICAL COMPLEXITY;

DATA WAREHOUSES;

EID: 84873168632     PISSN: None     EISSN: 21508097     Source Type: Conference Proceeding    
DOI: 10.14778/2336664.2336667     Document Type: Article

References (24)

1. S. Agrawal, S. Chaudhuri, and G. Das. DBExplorer: A System for Keyword-Based Search over Relational Databases. In ICDE, pages 5-16, 2002.
2. S. Bergamaschi, E. Domnori, F. Guerra, R. T. Lado, and Y. Velegrakis. Keyword Search over Relational Databases: A Metadata Approach. In SIGMOD, pages 565-576, 2011.
3. G. Bhalotia, A. Hulgeri, C. Nakhe, S. Chakrabarti, and S. Sudarshan. Keyword Searching and Browsing in Databases using BANKS. In ICDE, pages 431-440, 2002.
4. L. Blunschi, C. Jossen, D. Kossmann, M. Mori, and K. Stockinger. Data-Thirsty Business Analysts need SODA -Search Over DAta Warehouse. In CIKM (demo), pages 2525-2528, 2011.
5. G. Brunner and K. Stockinger. Data Warehouse Historization Concept. Credit Suisse internal architecture document, 2008.
6. E. Demidova, I. Oelze, and P. Fankhauser. Do We Mean the Same?: Disambiguation of Extracted Keyword Queries for Database Search. In KEYS, pages 33-38, 2009.
7. E. Demidova, X. Zhou, I. Oelze, and W. Nejdl. Evaluating Evidences for Keyword Query Disambiguation in Entity Centric Database Search. In DEXA (2), pages 240-247, 2010.
8. A. Geppert, L. Baumgartner, and D. Jonscher. The Data Warehouse Reference Architecture. Credit Suisse internal architecture document, 2008.
9. H. He, H. Wang, J. Yang, and P. S. Yu. BLINKS: Ranked Keyword Searches on Graphs. In SIGMOD, pages 305-316, 2007.
10. V. Hristidis and Y. Papakonstantinou. DISCOVER: Keyword Search in Relational Databases. In VLDB, pages 670-681, 2002.
11. C. Jossen, L. Blunschi, M. Mori, D. Kossmann, and K. Stockinger. The Credit Suisse Meta-data Warehouse. In ICDE, 2012.
12. N. Khoussainova, Y. Kwon, M. Balazinska, and D. Suciu. SnipSuggest: Context-Aware Autocompletion for SQL. PVLDB, 4(1):22-33, 2010.
13. R. Kimball. The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses. John Wiley, 1996.
14. Y. Li, H. Yang, and H. V. Jagadish. NaLIX: Generic Natural Language Search Environment for XML Data. Transactions on Database Systems, 32(4), 2007.
15. F. Liu, C. Yu, W. Meng, and A. Chowdhury. Effective Keyword Search in Relational Databases. In SIGMOD, pages 563-574, 2006.
16. Z. Liu and Y. Chen. Processing Keyword Search on XML: A Survey. World Wide Web, 14(5-6):671-707, 2011.
17. M. Ortega-Binderberger, K. Chakrabarti, and S. Mehrotra. An Approach to Integrating Query Refinement in SQL. In EDBT, pages 15-33, 2002.
18. L. Qin, J. X. Yu, and L. Chang. Keyword Search in Databases: The Power of RDBMS. In SIGMOD, pages 681-694, 2009.
19. A. Simitsis, G. Koutrika, and Y. Ioannidis. Précis: From Unstructured Keywords as Queries to Structured Databases as Answers. VLDB Journal, 17(1):117-149, 2008.
20. R. T. Snodgrass. Developing Time-Oriented Database Applications in SQL. Morgan Kaufmann, 1999.
21. http://www.w3.org/TR/rdf-sparql-query/. SPARQL Query Language for RDF.
22. A. S. Szalay, J. Gray, A. Thakar, P. Z. Kunszt, T. Malik, J. Raddick, C. Stoughton, and J. vandenBerg. The SDSS Skyserver: Public Access to the Sloan Digital Sky Server Data. In SIGMOD, pages 570-581, 2002.
23. S. Tata and G. M. Lohman. SQAK: Doing More with Keywords. In SIGMOD, pages 889-902, 2008.
24. X. Yang, C. M. Procopiuc, and D. Srivastava. Summarizing Relational Database. PVLDB, 2(1):634-645, 2009.