Abstract
Most Data Base Management Systems lack in offering adequate tools for handling in a sophisticate way the query result. Generally, the output to a query is a table of tuples, offering a flat, boring (and sometime confusing) presentation of data. In this paper we present a dynamic form based data Visualiser whose main goal is to manage the query output in such a way to overcome the above problems. The Visualiser strategies are based on the hypothesis that, when performing a (SQL) query against a set of relational tables, a high level description of the database, through the Entity Relationship model is available. The cardinality of the relationships involved in the query is exploited in order to cluster the tuple attributes in homogeneous subsets and to suitably handle meaningless repetitions of values. In this way the data are presented to the user in a more compact and understandable way.
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
Angelaccio M., Catarci T., Santucci G. QBD*: A Graphical Query Language with Recursion. IEEE Transactions on Software Engineering, Vol.16, No. 10, 11501163 (1991)
Batini C., Catarci T., F.Costabile M., Levialdi S. Visual Query Systems. Technical Report N.04.91, Dipartimento di Informatica e Sistemistica, Università di Roma “La Sapienza”.
Campbell D.M., Embley D.W., Czejdo B. A relationally complete query language for an entity-relationship model. pp. 90–97 in Proc. of the 4th International Conference on Entity-Relationship Approach, Chicago, Illinois, October 1985.
Catarci T., Santucci G., Angelaccio M. Fundamental Graphical Primitives for Visual Query Languages. Information Systems, Vol. 18 No. 2 (1993)
Chen P.P. The Entity-Relationship Model toward a Unified View of Data. ACM Transactions on Data Base Systems, l, 1 (1976)
Consens M., Mendelzon A.O. Graphlog: A Visual Formalism for Real Life Recursion. Proc. of the ACM Symp. on Principles of Database Systems, 404–416 (1990)
Consens M., Mendelzon A.O. Hy+: A Hygraph-based Query and Visualization System. Proc. of the ACM SIGMOD 93, Washington, DC USA (1993)
Cruz I.F., Mendelzon A.O., Wood P.T. G+: Recursive Queries Without Recursion. Proc. of the 2nd International Conference on Expert Database Systems, April, 355–368 (1988)
Hull R., King R. Semantic Database Modeling: Survey, Applications and Research Issues,. ACM Computing Surveys, vol. 19, n. 3, pp. 201–260 (1987)
Kitagawa H., Kunii T.L., et al. For ngraphics: A Form-Based Graphics Architecture Providing a Database Workbench. IEEE CGA, Vol.4, No.6, June pp. 38–56 (1984)
Kitagawa H. Structured Forms Handling By Nested Table Data Model, D.Sc. Thesis, Department of Information Science, Faculty of Science, the University of Tokyo, Japan (1987)
Lum V.Y., Choy D.M., Shu N.C. OPAS: An office procedure automation system. IBM Syst. J., Vol. 21, No. 3, pp. 327–350 (1982)
Peckham J., Maryanski F. Semantic Data Models. ACM Computing Surveys, vol. 20, n. 3, pp. 153–189 (1988)
Purvy R., Farrell J., Klose P. The design of STAR’s records processing: Data processing for the noncomputer professional. ACM Trans. on Office Inf. Syst., Vol.l, No. 1, pp. 3–24 (1983)
Rhiner M. Object Description and Representation for Visual and Multimedia Databases. IFIP Transactions on Visual Database Systems, II, North-Holland (1992)
Rowe L.A., Shoens K.A. A Form Application Development System. Proc of ACM Sigmod `82, pp. 28–38 (1982)
Santucci G. A Multilevel Query Language for the Entity Relationship Model. Technical Report, Dipartimento di Informatica e Sistemistica, Università di Roma “La Sapienza”, in printing. (1994)
Shi N.C. FORMAL: A Forms-Oriented, Visual-Directed Application Development System. Kunii, T.L.(ed), Application Development Systems, Springer, Tokyo and Berlin, 1986, pp. 2–26.
Tufte E.R. The visual Display of Quantitative Information. Graphics Press, Cheshire, Connecticut, (1983)
Whang K.Y.et al. Office-by-Example: An Integrated Office System and Database Manager. ACM Trans. on Office Inf. Syst., Vol. 5, No. 4 pp. 393–427. (1987)
Wilson G.A. Semantics vs. graphics - to show or not to show. Proc. of the 6th Very Large Data Base (1980)
Winkler J. The Entity Relationship approach and the Information Resource Dictionary system standard. Seventh International Conference on the Entity Relationship Approach, North Holland (1989)
Yao S.B., Hevner A.R., Z.Shi, Luo D.: FORMANAGER: An office forms management system. ACM Trans. on Office Inf. Syst., Vol. 2, No. 3, pp. 235–262 (1984)
Yao S.B., and Kitagawa H. Structured Application Generation Using XDB. Proc. AFIPS National Computer Conference, Chicago (1985)
Zloof M.M. Query-by-example: A data base language. IBM Syst. J., Vol. 16, No. 4, pp. 324–343 (1982)
Zloof M.M. Office-by-example: A business language that unifies data and word processing and electronic mail. IBM Syst. J.,Vol.21, No.3, pp.272–304 (1982)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1995 Springer-Verlag London
About this paper
Cite this paper
Santucci, G., Palmisano, F. (1995). A Dynamic Form-Based Data Visualiser for Semantic Query Languages. In: Sawyer, P. (eds) Interfaces to Database Systems (IDS94). Workshops in Computing. Springer, London. https://doi.org/10.1007/978-1-4471-3818-1_14
Download citation
DOI: https://doi.org/10.1007/978-1-4471-3818-1_14
Publisher Name: Springer, London
Print ISBN: 978-3-540-19910-6
Online ISBN: 978-1-4471-3818-1
eBook Packages: Springer Book Archive