Breadcrumb

 
 

Linking CORAL to MySQL and PostgreSQL

Title:

Linking CORAL to MySQL and PostgreSQL

Wang, Guang (2004) Linking CORAL to MySQL and PostgreSQL. PhD thesis, Concordia University.

[img]
Preview
PDF - Accepted Version
3384Kb

Abstract

A Graph Database System is developed at Concordia University. In this system, CORAL is used as the deductive engine. Since MySQL and PostgreSQL are selected to manage the persistent data, connections between CORAL and MySQL as well as PostgreSQL need to be established. This thesis mainly proposes a solution for these connections. Firstly, CORAL's architecture is analyzed. Its relational database interface is described. Class diagrams, object diagrams, and interaction diagrams are drawn to illustrate CORAL's rules and to identify the requirements. Then, classes are designed as an extension of CORAL's structure to communicate with MySQL and PostgreSQL. Data type conversion rules are defined based on the characteristics of each database system. Classes and parent classes are described in detail and patterns applied in these classes are discussed for the reusability of the design. Additionally, databases for MySQL and PostgreSQL are created and the extended CORAL system is tested. Finally, a CORAL client process is designed and implemented so as to integrate the TGL translator, which translates from the GraphLog graph database language to CORAL, with client-server mode CORAL and communicate with the underlying relational databases. The implementation of this solution uses C++ in a UNIX environment.

Divisions:Concordia University > Faculty of Engineering and Computer Science > Computer Science and Software Engineering
Item Type:Thesis (PhD)
Authors:Wang, Guang
Pagination:ix, 108 leaves : ill. ; 29 cm.
Institution:Concordia University
Degree Name:Ph. D.
Program:Computer Science
Date:2004
Thesis Supervisor(s):Butler, Gregory
ID Code:7953
Deposited By:Concordia University Libraries
Deposited On:18 Aug 2011 14:11
Last Modified:18 Aug 2011 14:11
Related URLs:
All items in Spectrum are protected by copyright, with all rights reserved. The use of items is governed by Spectrum's terms of access.

Repository Staff Only: item control page

Document Downloads

More statistics for this item...

Concordia University - Footer