Current Search:  SQL Computer program language (x)

View All Items

  • CSV Spreadsheet
(1 - 6 of 6)
critical investigation of SQLJ
Title
A critical investigation of SQLJ.
Creator
Borkar, Anjali P., Florida Atlantic University, Solomon, Martin K.
Abstract/Description
We critically investigate, evaluate, and illustrate the language of SQL and Java provided by SQLJ. We investigate the main constructs of SQLJ, such as use of declarative and executable statements, SQLJ clauses, and use of bind variables in SQLJ applications. We also observe usage of named and position iterators and we illustrate how to develop and run applications on the server side. In particular, we analyze the difference between SQLJ and JDBC and we find that SQLJ is good for static SQL...
Show moreWe critically investigate, evaluate, and illustrate the language of SQL and Java provided by SQLJ. We investigate the main constructs of SQLJ, such as use of declarative and executable statements, SQLJ clauses, and use of bind variables in SQLJ applications. We also observe usage of named and position iterators and we illustrate how to develop and run applications on the server side. In particular, we analyze the difference between SQLJ and JDBC and we find that SQLJ is good for static SQL whereas JDBC is good for dynamic SQL. We also compare the relationship of SQLJ to ANSI/ISO embedded SQL. Finally we evaluate the advantages of developing SQLJ stored procedure over PL/SQL procedures.
Show less
Date Issued
1999
PURL
http://purl.flvc.org/fcla/dt/15722
Subject Headings
Database management, SQL (Computer program language), Java (Computer program language)
Format
Document (PDF)
GSM network simulation and performance analysis
Title
GSM network simulation and performance analysis.
Creator
Bothra, Piyush., Florida Atlantic University, Ilyas, Mohammad
Abstract/Description
This research focuses on analyzing the effect of change in network parameters on the performance of GSM cellular network. A simulation model is created using visual C++ and network performance in terms of call failures and handover failures are studied. A cellular network architecture and its performance are based on so many parameters and complexities that it is very difficult to analyze the effect of a parameter on any one aspect of performance. The purpose of this thesis is to study the...
Show moreThis research focuses on analyzing the effect of change in network parameters on the performance of GSM cellular network. A simulation model is created using visual C++ and network performance in terms of call failures and handover failures are studied. A cellular network architecture and its performance are based on so many parameters and complexities that it is very difficult to analyze the effect of a parameter on any one aspect of performance. The purpose of this thesis is to study the performance of network with respect to some of those parameters while neglecting other effects. The simulated network takes parameters like cell diameter, traffic intensity and mobility pattern as input and a simulation run results in the evaluation of the call failure and success statistics.
Show less
Date Issued
2002
PURL
http://purl.flvc.org/fcla/dt/12952
Subject Headings
Database management, SQL (Computer program language), Java (Computer program language)
Format
Document (PDF)
Reducing impedance mismatch in SQL embeddings for object-oriented programming languages
Title
Reducing impedance mismatch in SQL embeddings for object-oriented programming languages.
Creator
Hurtado, Jose Luis, College of Engineering and Computer Science, Department of Computer and Electrical Engineering and Computer Science
Abstract/Description
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...
Show moreWe 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.
Show less
Date Issued
2012
PURL
http://purl.flvc.org/FAU/3355565
Subject Headings
Object-oriented programming (Computer science), SQL (Computer program language), Java (Computer program language), Relational databases
Format
Document (PDF)
A relational algebra implementation
Title
A relational algebra implementation.
Creator
Rivero, Gene Richard., Florida Atlantic University, Solomon, Martin K.
Abstract/Description
Although the Relational Algebra (RA) is a fundamental component of the relational model of database storage and retrieval, it has not been widely implemented in commercial database systems. The Structured Query Language (SQL) has been for some time the most widely implemented relational database language. This thesis provides and describes the first implementation of a particularly powerful version of the relational algebra that includes an n-ary join operator as well as including the...
Show moreAlthough the Relational Algebra (RA) is a fundamental component of the relational model of database storage and retrieval, it has not been widely implemented in commercial database systems. The Structured Query Language (SQL) has been for some time the most widely implemented relational database language. This thesis provides and describes the first implementation of a particularly powerful version of the relational algebra that includes an n-ary join operator as well as including the division operator, and nested expressions. With this implementation, that powerful version of the relational algebra can be used as a front end to any SQL-92 compliant database management system, such as Oracle, Informix, DB2, Sybase, SQL Server, and Access.
Show less
Date Issued
2003
PURL
http://purl.flvc.org/fcla/dt/13067
Subject Headings
Relation algebras, SQL (Computer program language), Database management, Relational databases
Format
Document (PDF)
survey of object-oriented features in SQL3
Title
A survey of object-oriented features in SQL3.
Creator
Wu, Zaiwu., Florida Atlantic University, Solomon, Martin K., College of Engineering and Computer Science, Department of Computer and Electrical Engineering and Computer Science
Abstract/Description
This thesis, based on (ISO/ANSI) X3H2-93-091 Working Draft Database Language SQL (SQL3) (Melton, 1993, 1994), systematically specifies the characteristics and manipulation of object-oriented techniques in SQL3. An essential difference between SQL3 and the previous SQL standards lies in the fact that the abstract data type (ADT) facility supported in SQL3 causes SQL3 to become an extended relational data model rather than a "pure" relational data model. This master's thesis focuses on the...
Show moreThis thesis, based on (ISO/ANSI) X3H2-93-091 Working Draft Database Language SQL (SQL3) (Melton, 1993, 1994), systematically specifies the characteristics and manipulation of object-oriented techniques in SQL3. An essential difference between SQL3 and the previous SQL standards lies in the fact that the abstract data type (ADT) facility supported in SQL3 causes SQL3 to become an extended relational data model rather than a "pure" relational data model. This master's thesis focuses on the careful examination and explication of ADTs and the corresponding families--type templates as they are used in SQL3. These topics involve four aspects: (1) general concepts and technologies in object-oriented data models, (2) the definition of ADTs and their advantages, (3) the manipulation of ADTs in SQL3, including type templates (e.g., distinct types, explicit ADTs, user-defined type templates, standard type templates) and collection types, (4) "tables of ADTs" (row types with table), and (5) conclusions and challenges.
Show less
Date Issued
1994
PURL
http://purl.flvc.org/fcla/dt/15044
Subject Headings
Abstract data types (Computer science), Object-oriented programming (Computer science), Database management, SQL (Computer program language)
Format
Document (PDF)
Implementation of an improved embedded SQL for Java
Title
Implementation of an improved embedded SQL for Java.
Creator
Bradley, Louis M., College of Engineering and Computer Science, Department of Computer and Electrical Engineering and Computer Science
Abstract/Description
The Java Devlopment Environment defines SQLJ as a standard way of embedding the relational database language SQL in the object-oriented programming language Java. Oracle Corporation provides an extension of SQLJ that supports dynamic SQL constructs for the processing of SQL commands that are not completely known at compile time. Unfortunately, these constructs are not sufficient to handle all dynamic situations, so that the programmer has to depend on other SQL embeddings, such as JDBC, in...
Show moreThe Java Devlopment Environment defines SQLJ as a standard way of embedding the relational database language SQL in the object-oriented programming language Java. Oracle Corporation provides an extension of SQLJ that supports dynamic SQL constructs for the processing of SQL commands that are not completely known at compile time. Unfortunately, these constructs are not sufficient to handle all dynamic situations, so that the programmer has to depend on other SQL embeddings, such as JDBC, in addition to Oracle's SQLJ. In this thesis we implement several extensions to Oracle's SQLJ so that all dynamic situations can be programmed in SQLJ, without resorting to other SQL embeddings. We also add a sub-query based for loop facility, similar to the one provided in Oracle's database programming language PL/SQL, as an improvement over the iterator constructs that SQLJ provides. This thesis discusses the design, development and implementation of these SQLJ extensions, and provided applications that show the utility of these extensions in terms of clarity and power.
Show less
Date Issued
2012
PURL
http://purl.flvc.org/FAU/3358327
Subject Headings
SQL (Computer program language), Java ( (Computer program language), Object-oriented programming ( (Computer science), Client/server computing, Application software, Development
Format
Document (PDF)