Abstract
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.
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
Blackwell, A. F. Metacognitive Theories of Visual Programming. Proceedings IEEE Symposium of Visual Languages, 1996, Pages 240–246.
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–328
Davis, J. S, Usability of SQL and menus for database query. Int. J. Man-Machine Studies, 1989, Pages 447–455
ORES: Towards The First Generation of Temporal DBMS Valid Time SQL. University Of Athens, Agricultural University of Athens, 1994
Goralwalla, I. A., Tansel A. U., Ozsu, M. T, Experimenting with Temporal Relational Databases. CIKM 95, Pages 296–303
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–326
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–114
Lorentzos, N. A, Mitsopoulos, Y. G. SQL Extension for Interval Data., IEE Transactions on Knowledge and Data Engineering, Vol. 9, No. 3, 1997
Rumbaugh, J, Blaha, M, Premerlani, W, Eddy, F, Lorensen, W. Object-Oriented Modeling and Design. Prentice Hall International Editions.
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–452
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–229
Human Factors Studies of Database Query Languages: A Survey and Assessment. Computing Surveys, Vol 13, No. 1, 1981
Shneiderman, B. Improving Human Factors Aspect of Database Interactions. ACM Transactions on Database Systems, Vol 3., No. 4, 1978, Pages 417–439
Snodgrass, R T. The Temporal Query Language TQUEL. ACM Transactions on Database Systems, Vol. 12, No. 2, 1987
Stonebraker, M, Brown, P, Object Relational DBMSs — The Next Great Wave. Morgan Kaufman Publishers
Snodgrass, R. T, Bohlen, M. H, Jensen, C. S., Steiner, A. Transitioning Temporal Support in TSQL2 to SQL3. Time Centre Technical Report, TR-9, 1997
Toman, D. Point vs. Interval based Query Languages for Temporal Databases. PODS 1996, Pages 58–67
Torp, K, Jensen, C. S, Snodgrass, R. T, Stratum Approaches to Temporal DBM Implementation, IDEAS Cardiff, 1998
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–649
van Welie, M, van der Veer, G, Eliens, A. Breaking Down Usability. Human Computer Interaction — INTERACT 99, 1999, Pages 613–620
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–409
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2003 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Green, J., Johnson, R. (2003). ProSQL: A Prototyping Tool for SQL Temporal Language Extensions. In: James, A., Younas, M., Lings, B. (eds) New Horizons in Information Management. BNCOD 2003. Lecture Notes in Computer Science, vol 2712. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-45073-4_15
Download citation
DOI: https://doi.org/10.1007/3-540-45073-4_15
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-40536-8
Online ISBN: 978-3-540-45073-3
eBook Packages: Springer Book Archive