You are here

FAU Collections » FAU Research Repository » FAU Theses and Dissertations

Reducing impedance mismatch in SQL embeddings for object-oriented programming languages

Download pdf | Full Screen View

Date Issued:
2012
Summary:
We survey and compare the different major mechanisms for embedding the relational database language SQL in object-oriented programming languages such as Java and C#, with regard to how much impedance mismatch these embeddings suffer. Here impedance mismatch refers to clarity and performance difficulties that arise because of the nature of the embedding. Because of the central position in the information technology industry of object-oriented programs that access SQL-based relational database systems, reducing impedance mismatch is generally recognized in that industry as an important practical problem. We argue for the suitability of SQL as a database language, and hence for the desirability of keeping SQL as the view provided by a SQL embedding. We make the case that SQLJ, a SQL embedding for Java in which it appears that Java directly supports SQL commands, is the kind of SQL embedding that suffers the least impedance mismatch, when compared with call-level interfaces and object-relational mappings. We propose extensions to SQLJ that would reduce its impedance mismatch even further.
Title: Reducing impedance mismatch in SQL embeddings for object-oriented programming languages.
196 views
51 downloads
Name(s): Hurtado, Jose Luis
College of Engineering and Computer Science
Department of Computer and Electrical Engineering and Computer Science
Type of Resource: text
Genre: Electronic Thesis Or Dissertation
Date Issued: 2012
Publisher: Florida Atlantic University
Physical Form: electronic
Extent: ix, 112 p.
Language(s): English
Summary: We survey and compare the different major mechanisms for embedding the relational database language SQL in object-oriented programming languages such as Java and C#, with regard to how much impedance mismatch these embeddings suffer. Here impedance mismatch refers to clarity and performance difficulties that arise because of the nature of the embedding. Because of the central position in the information technology industry of object-oriented programs that access SQL-based relational database systems, reducing impedance mismatch is generally recognized in that industry as an important practical problem. We argue for the suitability of SQL as a database language, and hence for the desirability of keeping SQL as the view provided by a SQL embedding. We make the case that SQLJ, a SQL embedding for Java in which it appears that Java directly supports SQL commands, is the kind of SQL embedding that suffers the least impedance mismatch, when compared with call-level interfaces and object-relational mappings. We propose extensions to SQLJ that would reduce its impedance mismatch even further.
Identifier: 820353092 (oclc), 3355565 (digitool), FADT3355565 (IID), fau:3936 (fedora)
Note(s): by Jose Luis Hurtado.
Thesis (M.S.C.S.)--Florida Atlantic University, 2012.
Includes bibliography.
Mode of access: World Wide Web.
System requirements: Adobe Reader.
Subject(s): Object-oriented programming (Computer science)
SQL (Computer program language)
Java (Computer program language)
Relational databases
Persistent Link to This Record: http://purl.flvc.org/FAU/3355565
Use and Reproduction: http://rightsstatements.org/vocab/InC/1.0/
Host Institution: FAU