An Educational Tool for Formal Relational Database Query Languages

Dietrich, Suzanne W.

doi:10.1080/0899340930040201

Cited by 15 publications

(8 citation statements)

References 7 publications

(10 reference statements)

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The paper uses the EMPLOYEE TRAINING enterprise from [9] as a scenario to illustrate the use of LINQ over ROX. The enterprise maintains a record of the training courses taken by employees.…”

Section: Linq Overviewmentioning

confidence: 99%

“…These same queries can be used in a companion LINQ assignment. Figure 3 gives the relational schema for the EMPLOYEE TRAINING enterprise, and Figure 4 shows LINQ queries for such an assignment [9]. These queries illustrate various features of LINQ including existential (Any) and universal (All) quantifiers, join, grouping, returning a single element (Single), and Contains.…”

Section: Linq To Sqlmentioning

confidence: 99%

See 1 more Smart Citation

Linq Rox!

Dietrich

Chaudhari

2011

Proceedings of the 42nd ACM Technical Symposium on Computer Science Education

View full text Add to dashboard Cite

The Language INtegrated Query (LINQ) language is a declarative query language integrated within an object-oriented programming language that provides a unified paradigm for querying relations, objects, and XML (ROX). This paper describes a suite of exercises, from cooperative in-class activities to larger-scale graded assignments, for incorporating LINQ into the database curriculum. These exercises support various student learning outcomes and illustrate the applicability of LINQ by querying the same database enterprise across the ROX data models.

show abstract

Section: Linq Overviewmentioning

confidence: 99%

Section: Linq To Sqlmentioning

confidence: 99%

Linq Rox!

Dietrich

Chaudhari

2011

Proceedings of the 42nd ACM Technical Symposium on Computer Science Education

View full text Add to dashboard Cite

show abstract

“…The relational interpreter introduced in [7] is used as a tool to create the relational databases. The interpreter is an educational tool that utilizes the integration of artificial intelligence and database technologies.…”

Section: The Implementation Environmentmentioning

confidence: 99%

“…The ONTOS object-oriented database [16] system was used to build the meta database over which global queries are expressed. For relational database access, we used the public domain, relational database interpreter educational tool described in [7] 2 to provide a means for building relational tables and executing SQL queries. An object algebra [21] provides a query language for expressing global queries, using the structural mapping details to translate object algebra queries into SQL queries over the local relational schemas.…”

Section: Introductionmentioning

confidence: 99%

Object-oriented query language access to relational databases: A semantic framework for query translation

Urban

Abdellatif

1995

Journal of Systems Integration

View full text Add to dashboard Cite

Abstract. This research investigates an approach to query processing in a multidatabase system that uses an objectoriented model to capture the semantics of other data models. The object-oriented model is used to construct a global schema, defining an integrated view of the different schemas in the environment. The model is also used as a self-describing model to build a meta-database for storing information about the global schema. A unique aspect of this work is that the object-oriented model is used to describe the different data models of the multidatabase environment, thereby extending the meta database with semantic information about the local schemas. With the global and local schemas all represented in an object-oriented form, structural mappings between the global schema and each local schema are then easily supported. An object algebra then provides a query language for expressing global queries, using the structural mappings to translate object algebra queries into SQL queries over local relational schema. The advantage of using an object algebra is that the object-oriented database can be viewed as a blackboard for temporary storage of local data and for establishing relationships between different databases. The object algebra can be used to directly retrieve temporarily-stored data from the object-oriented database or to transparently retrieve data from local sources using the translation process described in this paper.

show abstract

“…The markup language allows for user-defined tags to provide the semantics of the data contained in the document. Consider the schema of a simple employee table [3]: employee(eID, eLast, eFirst, eTitle, eSalary) Figure 1 shows a sample XML document representing a canonical table-based mapping of the employee relational table in XML based on the format discussed in [6]. A tag is a label that is contained within a < and >.…”

Section: A Brief Introduction To Xmlmentioning

confidence: 99%

Exploring XML for data exchange in the context of an undergraduate database curriculum

Dietrich

Urban

et al. 2005

SIGCSE Bull.

View full text Add to dashboard Cite

The relationship between XML and database management systems has become an important topic for coverage at the undergraduate level. This paper presents an approach to teaching the use of XML through the study of data exchange. After a brief review of XML, the paper provides a tutorial on the different features that are provided in major relational database products for the import and export of XML, providing a discussion of how these features can be used as implementation exercises for students. In addition to addressing the use of XML for data exchange in relational systems, the paper also provides an overview of several teaching tools that are also used in the study of XML for object-oriented data and also for the exchange of object-oriented and object-relational data.

show abstract

An Educational Tool for Formal Relational Database Query Languages

Cited by 15 publications

References 7 publications

Linq Rox!

Linq Rox!

Object-oriented query language access to relational databases: A semantic framework for query translation

Exploring XML for data exchange in the context of an undergraduate database curriculum

Contact Info

Product

Resources

About