Hongjun Lu
Skip Abstract Section
Abstract
Relational database systems have been on market for more than a decade. SQL has been accepted as the standard query language of relational systems. To further understand the usage of relational systems and relational query language SQL, we conducted a survey recently that covers various aspects of the usage of SQL in industrial organizations. In this paper, we present those results that may interest DBMS researcher and developers, including the profiles of SQL users, the application areas where SQL is used, the usage of different features of SQL and difficulties encountered by SQL users.
- [Chan et al. 1993] Chan, H.C., Lu, H., and Wei, K.K., "A Survey of SQL Usage," Technical Publications, Department of Information Systems and Computer Sciences, National University of Singapore, June 1993.Google Scholar
- [Codd 1970] Codd, E.F., "A Relational Model of Data for Large Shared Data Banks," Communication of the ACM Vol. 13, No. 6, June 1970. Google ScholarDigital Library
- [Codd 1982] Codd, E.F., "Relational Database: A Practical Foundation for Productivity," Communication of the ACM, Vol. 25, No. 2 New York: Association for Computing Machinery, Inc., Feb 1982. Google ScholarDigital Library
- [Codd 1988] Codd, E.F., "Fatal Flaws in SQL," Datamation , Aug 1988, 45-48, and Datamation, Sept 1988, 71-74.Google Scholar
- [Codd 1990] Codd, E.F. (1990). The Relational Model for Database Management, Version 2, Addison-Wesley Publishing Company, 1990. Google ScholarDigital Library
- [Date 1986] Date, C.J., "A Critique of the SQL Database Language", in Relational Database: Selected Writings, Addison-Wesley Publishing Company, 1986. Google ScholarDigital Library
- [Date 1987] Date, C.J., A Guide to the SQL Standard, Addison-Wesley Publishing Company, 1987. Google ScholarDigital Library
- [Date 1989] Date, C.J., Relational Database Writings 1985-1989, Addison-Wesley Publishing Company, 1989. Google ScholarDigital Library
- [Dieckmann 1981] Dieckmann, E.M., "Three Relational DBMS," Datamation, Sept 1981, 137-148.Google Scholar
- [Greenblat & Waxman 1978] Greenblatt, D. and Waxman, J., "A Study of Three Database Query Languages," in Databases: Improving Usability and Responsiveness, Ed. B. Shneiderman, New York: Academic Press, 1978, 77-97.Google Scholar
- [Greene et al. 1989] Greene, S.L., Devlin, S.J., Cannata, P.E., and Gomez, L.M., "No IFs, ANDs, or ORs: A Study of Database Querying," Database Querying, 1989, 303-325. Google ScholarDigital Library
- [SQL 1987-1992] International Organization for Standardization (ISO), Database Language SQL, Document ISO/IEC 9075:1987, 9075:1989, 9075:1992.Google Scholar
- [Lusardi 1988] Lusardi, F., The Database Experts' Guide to SQL, Intertext Publications/Multiscience Press, Inc., 1988. Google ScholarDigital Library
- [Niederman et al 1991] Niederman, F., Brancheau, J.C., Wetherbe, J.C., "Information Systems Management Issues for the 1990s," MIS Quarterly, Dec 1991, 475-500.Google ScholarDigital Library
- [Reisner 1977] Reisner, P., "Use of psychological experimentation as an aid to development of a query language". IEEE Transactions on Software Engineering, SE-3, 1977, 218-229.Google ScholarDigital Library
- [Reisner 1981] Reisner, P., "Human Factors Studies of Database Query Languages: A Survey and Assessment," Computing Surveys, Vol. 13, No. 1, March 1981, 13-31. Google ScholarDigital Library
- [Samet 1981] Samet, P.A., Query Languages: A unified approach, Heyden and Son Ltd., Cambridge, 1981.Google Scholar
- [Smelcer 1989] Smelcer, J.B., Understanding User Errors in Database Query, Doctoral thesis, University of Michigan, Ann Arbor, USA, 1989. Google ScholarDigital Library
- [Welty & Stemple 1981] Welty, C., and Stemple, D.W., "Human Factors Comparison of a Procedural and a Nonprocedural Query Language," ACM Transactions on Database Systems, Vol. 6, No. 4, 1981, 626-649. Google ScholarDigital Library
- [Welty 1985] Welty, C. "Correcting User Errors in SQL," International Journal of Man-Machine Studies, No. 22, 1985, 463-477.Google Scholar
Index Terms
- A survey on usage of SQL
Comments