ProSQL: A Prototyping Tool for SQL Temporal Language Extensions

  • James Green
  • Roger Johnson
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2712)


This paper describes ProSQL, a novel prototyping tool to support the development of extensions to SQL. ProSQL provides a simple way to prototype the features of a proposed extension and thus provide a proof of concept. Further, it provides proposers and reviewers of extensions with a clearer view of their positive and negative features. The approach adopted has been to build a wrapper around an existing database management system, in this case Microsoft Access, and to provide a collection of interfaces with which a designer can define extensions to the basic relational database.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Blackwell, A. F. Metacognitive Theories of Visual Programming. Proceedings IEEE Symposium of Visual Languages, 1996, Pages 240–246.Google Scholar
  2. 2.
    Chan, H. C. Wei, K. K, An empirical study on end users’ update performance for different abstraction levels. Int. J. Human-Computer Studies (1994) Vol 4, Pages 309–328CrossRefGoogle Scholar
  3. 3.
    Davis, J. S, Usability of SQL and menus for database query. Int. J. Man-Machine Studies, 1989, Pages 447–455Google Scholar
  4. 4.
    ORES: Towards The First Generation of Temporal DBMS Valid Time SQL. University Of Athens, Agricultural University of Athens, 1994Google Scholar
  5. 5.
    Goralwalla, I. A., Tansel A. U., Ozsu, M. T, Experimenting with Temporal Relational Databases. CIKM 95, Pages 296–303Google Scholar
  6. 6.
    Greene, S. L, Devlin, S.J, Cannata, P. E, Gomez, L.M. No IFS, ANDS, or ORS: A Study of database querying. Int. J. Man-Machine Studies (1990), Vol. 32, Pages 303–326CrossRefGoogle Scholar
  7. 7.
    Jarke, M, Turner, J, Stohr, E.A, Vassiliou Y, White, N.H, Michielsen, K. A Field Evaluation of Natural Language for Data Retrieval., IEEE Transactions on Software Engineering, Vol. SE-11, 1985 Pages 97–114CrossRefGoogle Scholar
  8. 8.
    Lorentzos, N. A, Mitsopoulos, Y. G. SQL Extension for Interval Data., IEE Transactions on Knowledge and Data Engineering, Vol. 9, No. 3, 1997Google Scholar
  9. 9.
    Rumbaugh, J, Blaha, M, Premerlani, W, Eddy, F, Lorensen, W. Object-Oriented Modeling and Design. Prentice Hall International Editions.Google Scholar
  10. 10.
    Reisner, P, Boyce, R.F, Chamberlain, D.D. Human Factors Evaulation of Two Database Query Langugaes-Square and Sequel., Proceedings of National Computer Conference (1975), Pages 447–452Google Scholar
  11. 11.
    Reisner, P. Use of Psychological Experimentation as and Aid to Development of a Query Language. IEEE Transactions on Software Engineering, Vol. SE-3, No. 3, 1997, Pages 218–229CrossRefGoogle Scholar
  12. 12.
    Human Factors Studies of Database Query Languages: A Survey and Assessment. Computing Surveys, Vol 13, No. 1, 1981Google Scholar
  13. 13.
    Shneiderman, B. Improving Human Factors Aspect of Database Interactions. ACM Transactions on Database Systems, Vol 3., No. 4, 1978, Pages 417–439CrossRefGoogle Scholar
  14. 14.
    Snodgrass, R T. The Temporal Query Language TQUEL. ACM Transactions on Database Systems, Vol. 12, No. 2, 1987Google Scholar
  15. 15.
    Stonebraker, M, Brown, P, Object Relational DBMSs — The Next Great Wave. Morgan Kaufman PublishersGoogle Scholar
  16. 16.
    Snodgrass, R. T, Bohlen, M. H, Jensen, C. S., Steiner, A. Transitioning Temporal Support in TSQL2 to SQL3. Time Centre Technical Report, TR-9, 1997Google Scholar
  17. 17.
    Toman, D. Point vs. Interval based Query Languages for Temporal Databases. PODS 1996, Pages 58–67Google Scholar
  18. 18.
    Torp, K, Jensen, C. S, Snodgrass, R. T, Stratum Approaches to Temporal DBM Implementation, IDEAS Cardiff, 1998Google Scholar
  19. 19.
    Welty, C, Stemple, D.W, Human Factors Comparison of Procedural and Non Procedural Query Language. ACM Transactions. on Database Systems Vol. 6, No.4, 1981 Pages 626–649CrossRefGoogle Scholar
  20. 20.
    van Welie, M, van der Veer, G, Eliens, A. Breaking Down Usability. Human Computer Interaction — INTERACT 99, 1999, Pages 613–620Google Scholar
  21. 21.
    Yi-Miin Yen, M, Scammel, R. W. A Human Factors Experimental Comparison of SQL and QBE. IEEE Transactions on Software Engineering, Vol. 19, No. 4, 1993, Pages 390–409CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2003

Authors and Affiliations

  • James Green
    • 1
  • Roger Johnson
    • 1
  1. 1.School of Computer Science, BirkbeckUniversity of LondonLondonUK

Personalised recommendations