Abstract
This paper describes the design and implementation of a type-safe, vendor-neutral Application Programming Interface (API) to interact with a database system. It reviews the current practice in this area and summarizes the problems and limitations, and shows some solutions that were developed in response. The paper explains the benefits that Ada brings to the task of writing a high level SQL API.
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
PostgreSQL 8.3.0 Documentation, http://www.postgresql.org/docs/8.3/static/index.html
MySQL 6.0 Reference Manual, http://dev.mysql.com/doc/refman/6.0/en/index.html
Erdmann, M.: GNADE user’s guide, http://gnade.sourceforge.net/gnade/gnade.pdf
Gay, W.W.: APQ home page, http://home.cogeco.ca/~ve3wwg/software.html
ODBC–Open Database Connectivity Overview, http://support.microsoft.com/kb/110093
Erdmann, M.: Embedded SQL with GNADE, http://gnade.sourceforge.net/#ESQL
Templates Parser User’s Guide, https://libre.adacore.com/aws/templates_parser-gpl-2.3.0.pdf
Erdmann, M.: GNAT Ada Database Development Environment. In: Blieberger, J., Strohmeier, A. (eds.) Ada-Europe 2002. LNCS, vol. 2361, pp. 334–343. Springer, Heidelberg (2002)
North, K.: Understanding multidatabase APIs and ODBC (1994), http://www.dbmsmag.com/9403d13.html
IBM, SQL Reference Volume 1, ftp://ftp.software.ibm.com/ps/products/db2/info/vr9/pdf/letter/en_US/db2s1e90.pdf
Dewar, R.B.K.: Quality control in a multi-platform multi-product software company (June 2001), http://www.adacore.com/2001/03/02/quality-control-in-a-multi-platform-multi-product-software-company/
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2008 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Villoing, F., Briot, E. (2008). A Type-Safe Database Interface. In: Kordon, F., Vardanega, T. (eds) Reliable Software Technologies – Ada-Europe 2008. Ada-Europe 2008. Lecture Notes in Computer Science, vol 5026. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-68624-8_11
Download citation
DOI: https://doi.org/10.1007/978-3-540-68624-8_11
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-68621-7
Online ISBN: 978-3-540-68624-8
eBook Packages: Computer ScienceComputer Science (R0)