An abbreviated concept-based query language and its exploratory evaluation

Journal of Systems and Software

Volumn 63, Issue 1, 2002, Pages 45-67

  Owei, Vesper ^a,d   Navathe, Shamkant B ^b   Rhee, Hyeun Suk ^c  

^a UNIVERSITY OF OKLAHOMA   (United States)

^b Georgia Institute of Technology   (United States)

^c UNIVERSITY OF TEXAS AT DALLAS   (United States)

^d GEORGE WASHINGTON UNIVERSITY   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

EVALUATION; INTERFACES (COMPUTER); SOFTWARE PROTOTYPING; STATISTICAL METHODS;

CONCEPTUAL QUERY LANGUAGES (CQL);

QUERY LANGUAGES;

EID: 0037101507     PISSN: 01641212     EISSN: None     Source Type: Journal    
DOI: 10.1016/S0164-1212(01)00139-X     Document Type: Article

References (55)

1. Anderson M., Shin, Doug-Guk Integrating an intelligent interface with a relational database for two way man-machine communication. Proc. IEEE/ACM Int'l Conf. on Developing and Managing Expert System Programs, Washington, DC, September 30. - October 2, 1991:1991;4-11.
2. Batra D. A framework for studying human error behavior in conceptual database modeling. Information and Management. 25:1993;121-131.
3. Batra D., Hoffer J.A., Bostrom R.P. Comparing representations with relational and EER models. CACM. 33(2):1990;126-139.
4. Batra D., Sein M.K. Improving conceptual database design through feedback. International Journal of Human-Computer Studies. 40:1994;653-676.
5. Bell J., Rowe L. An exploratory study of ad hoc query languages to databases. Proc. 8th Int'l Conf. on Data Engineering, February 3-7, 1992. 1992;606-613.
6. Berztiss A.T. Data abstraction in the specification of information systems. Proc. IFIP World Congress 86. 1986;83-90.
7. Berztiss A.T. The query language vizla. IEEE TKDE. 5(5):1993;813-825.
8. Bloesch A.C., Halpin T.A. ConQuer: a conceptual query language. Conceptual Modeling - ER'96. Lecture Notes in Computer Science. vol. 1157:1996;121-133 Springer, Berlin.
9. Bloesch A.C., Halpin T.A. Conceptual queries using conquer - II. Proc. ER97: 16th Int'l Conf. on Conceptual Modeling. 1997;112-126 Springer, Los Angeles.
10. Bono G., Ficorilli P. Natural language restatement of queries expressed in a graphical language. Proc. 11th Int'l Conf. on the E-R Approach. Karlsruhe, Germany, October 1992. 1992;357-374.
11. Brosey M., Shneiderman B. Two experimental comparisons of relational and hierarchical database models. International Journal of Man-Machines Studies. 10:1978;625-637.
12. Catarci T., Santucci G. Query by diagram: a graphic query system. Proc. 7th Int'l Conf. on The E-R Approach, Rome, Italy, November 16-18, 1988. 1988;157-174.
13. Chan, H.C., 1989. A knowledge level user interface using the ER model. Ph.D. Dissertation, The University of British Columbia, Vancouver, BC.
14. Chan H., Siau K., Wei K. The effect of data model, system and task characteristics on user query performance - an empirical study. Data Base. 29(1):1998;31-49.
15. Chan H.C., Wei K.K., Siau K.L. User-database interface: the effect of abstraction levels on query performance. MIS Quarterly. 17(4):1993;441-464.
16. Chang T., Sciore E. A universal relation data model with semantic abstractions. IEEE TKDE. 4(1):1992;23-33.
17. Cook, T.D., Campbell, D.T., 1979. Quasi-experimental design and analysis issues for field settings, Houghton, Mifflin, Boston.
18. Cronan T., Douglas D. End user training and computing effectiveness in public agencies: an empirical study. JMIS. 6(4):1990;21-40.
19. Czejdo B., Elmasri R., Embley D.W., Rusinkiewicz M. A graphical data manipulation language for an extended entity-relationship model. Computer. 23(March):1990;26-36.
20. Dalianis H. Explaining conceptual models - an architecture and design principles. Conceptual Modeling ER-97. 1997;214-228.
21. Gallupe R., DeSanctis G., Dickson G.W. Computer-based support for group problem-finding: an experimental investigation. MIS Quarterly. (June):1988;277-296.
22. Greenblatt D., Waxman J. A study of three database query languages. Shneiderman B. Databases: Improving Usability and Representativeness. 1978;Academic Press, New York.
23. Gulla J.A. A general explanation component for conceptual modelling in CASE environments. ACM TOIS. 14(2):1996;297-329.
24. Halpin T.A. Conceptual Schema and Relational Database Design. second ed. 1995;Prentice-Hall, Sydney, Australia.
25. Halpin T.A. Business rules and object-role modeling. Database Program and Design. 9(10):1996;66-72.
26. Halpin T.A., Orlowska M.E. Fact-oriented modelling for data analysis. Journal of Information Systems. 2(2):1992;1-23.
27. Halpin T.A., Proper H.A. Subtyping and polymorphism in object-role modeling. Data and Knowledge Engineering. 15:1995a;251-281.
28. Halpin T.A., Proper H.A. Database schema transformation and optimization. OOER'95: Object-Oriented and Entity-Relationship Modeling. Lecture Notes in Computer Science. vol. 1021:1995b;191-203 Springer, Berlin.
29. Higa, K., 1988. End-user logical database design: the structured entity model approach. Ph.D. Thesis, Submitted to the Committee on Business Admin., Graduate College, The University of Arizona.
30. Jarvenpaa S.L., Machesky J.J. End user learning behavior in data analysis and data modeling tools. Proc. 17th Int'l Conf. on Information Systems, San Diego, CA, 1986. 1986;152-167.
31. Jarvenpaa S.L., Machesky J.J. Data analysis and learning: An experimental study of data modeling tools. International Journal of Man-Machine Studies. 31:1989;367-391.
32. Jih W.J., Bradbard D.A., Snyder C.A., Thompson N.G.A. The effects of relational and ER data models on query performance of end-users. International Journal Man-Machine Studies. 31:1989;257-267.
33. Maier D., Rozenshtein D., Warren D.S. Window Functions. Kanellakis P. Advances in Computing Research. 1986;213-246 JAI Press.
34. Maier D., Ullman J.D. Maximal object and the semantics of universal relation databases. ACM TODS. 8(1):1983;1-14.
35. Mannino M.V., Shapiro L.D. Extensions to query languages for graph traversal problems. IEEE TKDE. 2(3):1990;353-363.
36. Markowitz, Shoshani Abbreviated query interpretation in EER oriented databases. Proc. 8th Int'l. Conf. on E-R Approach, October 18-20, 1989. 1989;325-344.
37. McKeen J.D., Guimaraes T., Wetherbe J.C. The relationship between user participation and user satisfaction: an investigation of four contingency factors. MIS Quarterly. 18(4):1994;427-451.
38. Nunnally J.C. Psychometric Theory. second ed. 1978;McGraw-Hill, New York.
39. Owei, V., 1994. Framework for a conceptual query language for capturing relationship semantics in databases. Ph.D. Dissertation, The Georgia Institute of Technology.
40. Owei V., Higa K. A paradigm for natural language explanation of database queries: a semantic data model approach. Journal of Database Management. (Winter):1994.
41. Owei V., Navathe S.B. A formal basis for an abbreviated concept-based query language. Data and Knowledge Engineering. 36(2):2001;109-151.
42. Owei, V., Navathe, S.B., Rhee, H., 1997a. Natural language query filtration in the conceptual query language. In: Proc. of 30th Hawaii International Conference on System Sciences, Maui, Hawaii, USA, January 1997.
43. Owei, V., Rhee, H., Navathe, S.B., 1997b. Statistical validation of the CQL approach. Technical Report Georgia Tech-UIC CQL-TR -1.
44. Peckham J., Maryanski F., Demurjian S. Towards the correctness and consistency of update semantics in semantic databases. IEEE TKDE. 8(3):1996;503-507.
45. Pittges, J., 1995a. Maintaining instance-based constraints for semantic query optimization. In: Proc. 6th IFIP TC-2 Working Conf. on Data Semantics (DS-6), Stone Mountain, Georgia, May 1995.
46. Pittges, J., 1995b. Metadata view graphs: a framework for query optimization and metadata management. Ph.D. Thesis, Georgia Institute of Technology.
47. Pittges, J., Mark, L., Navathe, S., 1995. Maintaining semantic and structural metadata in the metadata view graph. In: Proc. 7th Int'l. Conf. on Management of Data (COMAD'95), Pune, India, December 1995.
48. Puranik, S., 1988. A data definition language for the object-oriented semantic association model and algorithms for intelligent query processing. Master of Science Thesis, Presented to the Graduate School of the University of Florida.
49. Shaw M.E. Group Dynamics: The Psychology of Small Group Behavior. third ed. 1981;McGraw-Hill, New York.
50. Siau K.L., Chan H.C., Tan K.P. Visual knowledge query language as a front-end to relational systems. Proc. 15th Annual Int'l Computer Software and Applications Conf., Tokyo, 1991. 1991;373-378.
51. Siau K.L., Chan H.C., Tan K.P. Visual knowledge query language. IEICE Transactions on Information and Systems. E75-D(5):1992;697-703.
52. Siau K.L., Chan H.C., Wei K.K. The effects of conceptual and logical interfaces on visual query performance of end users. Proc. ICIS, Amsterdam, The Netherlands, December 10-13, 1995. 1995;225-235.
53. Wald J., Sorenson P. Explaining ambiguity in a formal query language. ACM TODS. 15(2):1990;125-161.
54. Wu X., Ichikawa T. KDA: a knowledge-based database assistant with a query guiding facility. IEEE TKDE. 4(5):1992.
55. Zmud R.W. Individual differences and mis success: a review of the empirical literature. Management Science. 25(10):1979;966-979.