Abstract
Query a database by users unfamiliar with its schema can be a challenging test due mainly to the difficulty of understanding dozens or more of possibly poorly designed inter-linked tables, beyond outdated or missing documentation (usability problem). Such users include database developers and sophisticated users: they may eventually need to acquire detailed knowledge of the schema, and then their ability to do so would be greatly improved if they could start with a simplified, easy-to-read schema. Simplified and easy-toread schemas have been studied within a research direction called database schema summarization [8, 10, 11, 12, 13].
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Afrati, F., Chirkova, R.: Selecting and Using Views to Compute Aggregate Queries. In: International Conference on Database Theory, pp. 383–397 (2005)
Agrawal, S., Chaudhuri, S., Narasayya, V.: Automated Selection of Materialized Views and Indexes for SQL Databases. In: 26th International Conference on Very Large Databases, pp. 496–505 (2000)
Blaha, M., Premerlani, W.: Object-Oriented Modeling and Design for Database Applications. Prentice-Hall (2008)
Chakaravarthy, V.T., et al.: Efficiently Linking Text Documents with Relevant Structured Information. In: VLDB 2006, pp. 667–678 (2006)
Chaudhuri, S., Krishnamurthy, R., Potaminianos, S., Schim, K.: Optimizing Queries with Materialized Views. In: 11th IEEE International Conference on Data Engineering (IEEE ICDE 2011), pp. 190–200 (1995)
Chen, D., Chirkova, R., Sadri, F.: Query Optimization Using Restructured Views: Theory and Experiments. Information Systems 34, 353–370 (2009)
Cunningham, C., Galindo-Legaria, C.A., Graefe, G.: PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS. In: 30th VLDB Conference, pp. 998–1009 (2004)
Jagadish, H.V., et al.: Making Database Systems Usable. In: SIGMOD 2007, pp. 13–24 (2007)
Roussos, Y., Stavrakas, Y., Pavlaki, V.: Towards a Context-Aware Relational Model. In: Proceeding of the Contextual Representation and Reasoning Workshop of the 5th International and Interdisciplinary Conference on Modeling and Using Context, CONTEXT 2005 (2005)
Yang, X., Procopiuc, C.M., Srivastava, D.: Summarizing Relational Databases. In: VLDB 2006 (2009)
Yu, C., Jagadish, H.V.: Schema Summarization. In: VLDB 2006 (2006)
Yu, C., Jagadish, H.V.: Querying Complex Structured Databases. In: VLDB 2007, pp. 1010–1021 (2007)
Wu, W., et al.: Discovering Topical Structures of Databases. In: SIGMOD 2008, pp. 1019–1030 (2008)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Sampaio, M., Quesado, J., Barros, S. (2013). Relational Schema Summarization: A Context-Oriented Approach. In: Morzy, T., Härder, T., Wrembel, R. (eds) Advances in Databases and Information Systems. Advances in Intelligent Systems and Computing, vol 186. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-32741-4_20
Download citation
DOI: https://doi.org/10.1007/978-3-642-32741-4_20
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-32740-7
Online ISBN: 978-3-642-32741-4
eBook Packages: EngineeringEngineering (R0)