Abstract
In this paper we describe a query paradigm based on ontologies, aggregate table-driven querying and expansion of QBE. It has two novel features: visually specifying aggregate table queries and table layout in a single process, and providing users with an ontology guide in composing complex analysis tasks as queries. We present the role of the fundamental concept of ontology in the context of the content representation of distributed databases with large numbers of multi-valued attributes, and in query formulation and processing. The methods and techniques developed for representing and manipulating ontologies for query formulation and processing make extensive use of XML and DOM. The core functionalities of content representation, query formulation without prior knowledge about databases, statistical summary and result presentation are integrated into a front-end client within the underpinning MVC architecture, which has been implemented in Java and JAXP.
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
Zloof, M.: Query by Example. AFIPS, 44, (1975).
Bi, Y., Murtagh, F. and McClean, S.I.: Metadata and XML for Organising and Accessing Multiple Statistical Data Sources, Proceedings of ASC International Conference, Edinburgh, (1999) 393–404.
Scotney, B.W., McClean, S.I., Rodgers, M. C.: Optimal and Efficient Integration of Heterogeneous Summary Tables in a Distributed Database. The Journal of Data and Knowledge Engineering, Vol. 29. (1999) 337–350.
Sadreddini, M. N. Bell, D. A. and McClean, S. I.: A Model for Integration of Raw Data and Aggregate Views in Heterogeneous Statistical databases. Database Technology, Vol. 4(2), (1992) 115–127.
Gamma, E., Helm, R., Johnson, R., and Vlissides, J.: Design Patterns: Elements of Reusable Object-Oriented Software. Addison-Wesley (1994).
Tanin, E., Plaisant, C., Shneiderman, B.: Broadening Access to Large Online Databases by Generalizing Query Previews, Proceedings of the Symposium on New Paradigms in Information Visualization and Manipulation, (2000) 80–85.
Levy, A. Y., Rajaraman, A., Ordille, J. J.: Querying Heterogeneous Information Sources Using Source Descriptions. Proceedings of the 22nd VLDB Conference, Bombay, India. (1996).
Wache, H. Vogele, T. Visser, U. Stuckenschmidt, H. Schuster, G. Neumann, H., H ubner, S.: Ontology-based integration of information — a survey of existing approaches. In Stuckenschmidt, H. (ed.): IJCAI-01 Workshop: Ontologies and Information Sharing, (2001) 108–117.
Gruber, T.: A translation Approach to Portable Ontology Specifications. Knowledge Acquisition. Vol. 5(2), (1993)199–220.
McClean, S., Páircéir, R., Scotney, B., Greer, K.: A Negotiation Agent for Distributed Heterogeneous Statistical Databases in SSDBM (2002) 207–217.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2003 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Bi, Y., Bell, D., Lamb, J. (2003). Aggregate Table-Driven Querying via Navigation Ontologies in Distributed Statistical Databases. In: James, A., Younas, M., Lings, B. (eds) New Horizons in Information Management. BNCOD 2003. Lecture Notes in Computer Science, vol 2712. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-45073-4_6
Download citation
DOI: https://doi.org/10.1007/3-540-45073-4_6
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-40536-8
Online ISBN: 978-3-540-45073-3
eBook Packages: Springer Book Archive