Translating between SQL and Tutorial D

The relational model of data has a strong influence on the database field and cannot be discarded for any future direction regarding the development of databases (Date and Darwen, 2007). Two relational database languages that are associated with this model are the Structured Query Language (SQL) and Tutorial D. The purpose of this dissertation is to translate between these two languages so that SQL clients can interoperate with a Tutorial D database via SQL. Through studying the literature, it is shown that such translation is important. It will allow the most popular relational database language (i.e. SQL) to interoperate with a true relational database language (i.e. Tutorial D) utilising its features to solve some of the deficiencies that exist in SQL. The main method conducted for this research is through implementing a translation layer between SQL and Tutorial D using direct string manipulation. The translation logic utilises some of the available methods for string manipulation to manipulate the executed SQL statements and translate them to the corresponding Tutorial D statements. The translation layer then takes care of executing the resultant Tutorial D statements on a chosen Tutorial D database called Rel. Testing the translation layer consisted of three steps. The first one is to test the translation layer against valid SQL statements to study the feasibility aspect of such translation. It is shown that all the chosen SQL statements for this step pass the test. The second step is to test the translation layer as a solution to the SQL deficiencies defined. It is shown that the test cases that are defined in this step pass the test, and thus, the translation layer solves the deficiencies of SQL. Finally, the translation layer is tested against robustness. All the invalid SQL statements defined in this step are not translated and suitable error messages are shown. Finally, the dissertation concluded with proving that the translation between SQL and Tutorial D is feasible and can be a suitable approach to solve SQL deficiencies while still using SQL.UnpublishedAtkinson, M., Bancilhon, F., DeWitt, D., Dittrich, K., Maier, D., & Zdonik, S. (1989). The object-oriented database system manifesto, in Proceedings of the First International Conference on Deductive and Object-Oriented Databases (DOOD'89). Kyoto, Japan, Dec 4-6, 223-240. Barker, R. (1990). Case*Method: Entity relationship modelling. USA: Addison-Wesley Inc. Burns, R. K. (1990). Referential secrecy. IEEE, Symposium on Security and Privacy, 133-142. Codd, E. F. (1970). A relational model of data for large shared data banks. Communications of the ACM, 13(6), 377-387. Codd, E. F. (1981). Data models in database management. ACM SIGMOD Record, 11(2), 112-114. Codd, E. F. (1990). The relational model for database management: version 2. Massachusetts, USA: Addison Wesley Longman Inc. Date, C. J. (1983). Null values in database management. In C. J. Date (Ed.), Relational database: Selected writings. Massachusetts, USA: Addison-Wesley. Date, C. J. (1984). A critique of the SQL database language. In C. J. Date (Ed.), Relational database: Selected writings. Massachusetts, USA: Addison-Wesley. Date, C. J. (1988). Why relational. In C. J. Date & A. Warden (Ed.), Relational database: Writings. Massachusetts, USA: Addison-Wesley. Date, C. J. (1990). Why duplicate rows are prohibited. In C. J. Date & A. Warden, Relational database: Writings. Massachusetts, USA: Addison-Wesley. Date, C. J. (2003). A sweet disorder. In C. J. Date (Ed.), Date on database: Writings 2000 – 2006. California, USA: Apress. Date, C. J., & Darwen, H. (1997). A guide to the SQL standard (4th ed.). USA: Addison-Wesley Inc. Date, C. J., & Darwen, H. (2000). Foundation for future database systems: The third Manifesto (2nd ed.). Massachusetts, USA: Addison Wesley Longman Inc. Date, C. J., & Darwen, H. (2007). Databases, types, and the relational model: The third manifesto (3rd ed.). USA: Pearson Education, Inc. Eisenberg, A., & Melton, J. (1998). Standards in practice. ACM SIGMOND Record. 27(3), 53-58. Eisenberg, A., & Melton, J. (2000). SQL standardization: The next steps. ACM SIGMOND Record, 29(1): 63-67. GNU General Public License. (2007). Retrieved September 13, 2007, from http://www.gnu.org/copyleft/gpl.html ISO (2003) Database Language SQL, International standard ISO/IEC 9075:2003. International Organisation for Standardisation (ISO). Geneva, Switzerland. Jagerskogh, M. (2005). Translating SQL expressions to functional queries in a mediator database system. Unpublished master’s thesis, Uppsala University, Uppsala, Sweden. Jigyasu, S., Banerjee, S., Borkar, V., Carey, M., Dixit, K., Malkani, A. & Thatte, S. (2006). SQL to XQuery translation in the AquaLogic data services platform, in Proceedings of the 22nd International Conference on Data Engineering (ICDE'06). p. 97. Rel: An implementation of Date and Darwen’s Tutorial D. (2007). Retrieved August 29, 2007, from http://dbappbuilder.sourceforge.net/Rel.html Silberschatz, A., Korth, H., & Sudarshan, S. (2002). Database System Concepts. (4th Ed.). Singapore: McGraw-Hill Soderstrom, E. (2002). Standardising the business vocabulary of standards, ACM SIGMOND Record, 1048-1052. Stonebraker, M., Rowe, L. A., Lindsay, B., Gray, J., Carey, M., Brodie, M., Bernstein, P., & Beech, D. (1990) Third-generation database system manifesto. ACM SIGMOD Record, 19(3), 31-44