Show simple item record

dc.contributor.authorAlmulla, Ahmed Yusufen_NZ
dc.date.available2011-04-07T03:10:01Z
dc.date.copyright2007-10en_NZ
dc.identifier.citationAlmulla, A. Y. (2007, October). Translating between SQL and Tutorial D (Dissertation, Bachelor of Applied Science with Honours in Software Engineering). Retrieved from http://hdl.handle.net/10523/1189en
dc.identifier.urihttp://hdl.handle.net/10523/1189
dc.description.abstractThe 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.en_NZ
dc.format.mimetypeapplication/pdf
dc.subject.lcshQA76 Computer softwareen_NZ
dc.titleTranslating between SQL and Tutorial Den_NZ
dc.typeDissertationen_NZ
dc.description.versionUnpublisheden_NZ
otago.bitstream.pages99en_NZ
otago.date.accession2008-03-10en_NZ
otago.schoolInformation Scienceen_NZ
thesis.degree.disciplineInformation Scienceen_NZ
thesis.degree.nameBachelor of Applied Science with Honours in Software Engineering
thesis.degree.grantorUniversity of Otagoen_NZ
thesis.degree.levelHonours Dissertationsen_NZ
otago.openaccessOpen
dc.identifier.eprints780en_NZ
otago.school.eprintsDatabase Research Centreen_NZ
otago.school.eprintsInformation Scienceen_NZ
dc.description.referencesAtkinson, 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.en_NZ
 Find in your library

Files in this item

Thumbnail

This item appears in the following Collection(s)

Show simple item record