An Object-Oriented Framework For SQL Predicates

Thumbnail Image

URL

Journal Title

Journal ISSN

Volume Title

Helsinki University of Technology | Master's thesis
Checking the digitized thesis and permission for publishing
Instructions for the author
Location:
P1 Ark Aalto

Authors

Date

2005

Department

Tietotekniikan osasto

Major/Subject

Ohjelmistotekniikka

Mcode

T-106

Degree programme

Language

en

Pages

(10) + 71 s.

Series

Abstract

Both relational databases and object-oriented technologies have long histories and they are important parts of software engineering. Combining the two isn't always easy, however, due to the inherent differences between the two methodologies. The common solution for overcoming these problems is to create a data encapsulation layer that facilitates communication between the two, while keeping them separate. One aspect of such an encapsulation layer is the definition of conditions used for restricting the affected data when communicating with a database. This thesis describes a condition framework for defining such conditions in an object-oriented manner. The condition framework described in this thesis is designed to support dynamic manipulation of the condition objects, enabling editing, combination and comparison of different condition objects. This makes the framework very versatile and the framework has proven itself useful in many situations, not only when it comes to querying a database, but also e.g. for keeping track of data loaded into caches, for performing in-memory selections from these caches and for access rights definitions.

Description

Supervisor

Soisalon-Soininen, Eljas

Keywords

object-orientated programming, objekt-orienterad programmering, query formulation, frågeformulering, SQL, SQL, object-relational mapping, objekt-relationell mappning

Other note

Citation

Permanent link to this item

https://urn.fi/URN:NBN:fi:aalto-2020120451860

Collections

[dipl] Teknillinen korkeakoulu / TKK