A survey on usage of SQL

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.

REFERENCES

• 1: [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.
• 2: E. F. Codd, A relational model of data for large shared data banks, Communications of the ACM, v.13 n.6, p.377-387, June 1970 [doi>10.1145/362384.362685]
• 3: E. F. Codd, Relational database: a practical foundation for productivity, Communications of the ACM, v.25 n.2, p.109-117, Feb 1982 [doi>10.1145/358396.358400]
• 4: [Codd 1988] Codd, E.F., "Fatal Flaws in SQL," Datamation , Aug 1988, 45-48, and Datamation, Sept 1988, 71-74.
• 5: E. F. Codd, The relational model for database management: version 2, Addison-Wesley Longman Publishing Co., Inc., Boston, MA, 1990
• 6: C. J. Date, Relational database: selected writings, Addison-Wesley Longman Publishing Co., Inc., Boston, MA, 1986
• 7: C J Date, A guide to the SQL standard, Addison-Wesley Longman Publishing Co., Inc., Boston, MA, 1986
• 8: C. J. Date , Andrew Warden, Relational database writings (1985–1989), Addison-Wesley Longman Publishing Co., Inc., Boston, MA, 1990
• 9: [Dieckmann 1981] Dieckmann, E.M., "Three Relational DBMS," Datamation, Sept 1981, 137-148.
• 10: [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.
• 11: S. L. Greene , S. J. Devlin , P. E. Cannata , L. M. Gomez, No IFs, ANDs, or ORs: a study of databases querying, International Journal of Man-Machine Studies, v.32 n.3, p.303-326, March 1990 [doi>10.1016/S0020-7373(08)80005-3]
• 12: [SQL 1987-1992] International Organization for Standardization (ISO), Database Language SQL, Document ISO/IEC 9075:1987, 9075:1989, 9075:1992.
• 13: Frank Lusardi, The database experts' guide to SQL, Intertext Publications, Inc.,/McGraw-Hill, Inc., New York, NY, 1988
• 14: [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.
• 15: [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.
• 16: Phyllis Reisner, Human Factors Studies of Database Query Languages: A Survey and Assessment, ACM Computing Surveys (CSUR), v.13 n.1, p.13-31, March 1981 [doi>10.1145/356835.356837]
• 17: [Samet 1981] Samet, P.A., Query Languages: A unified approach, Heyden and Son Ltd., Cambridge, 1981.
• 18: J. B. Smelcer, Understanding user errors in database query, University of Michigan, Ann Arbor, MI, 1990
• 19: Charles Welty , David W. Stemple, Human factors comparison of a procedural and a nonprocedural query language, ACM Transactions on Database Systems (TODS), v.6 n.4, p.626-649, Dec. 1981 [doi>10.1145/319628.319656]
• 20: [Welty 1985] Welty, C. "Correcting User Errors in SQL," International Journal of Man-Machine Studies, No. 22, 1985, 463-477.

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.3 Languages

          Nouns: SQL

Additional Classification:
  H. Information Systems
  H.1 MODELS AND PRINCIPLES
  H.2 DATABASE MANAGEMENT

General Terms:
Design, Human Factors, Languages, Management, Measurement, Performance, Theory