Login | Register

Linking CORAL to MySQL and PostgreSQL


Linking CORAL to MySQL and PostgreSQL

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

[thumbnail of MQ91132.pdf]
Text (application/pdf)
MQ91132.pdf - Accepted Version


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 > Gina Cody School 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
Thesis Supervisor(s):Butler, Gregory
Identification Number:QA 76.73 C29W36 2004
ID Code:7953
Deposited By: Concordia University Library
Deposited On:18 Aug 2011 18:11
Last Modified:13 Jul 2020 20:02
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

Downloads per month over past year

Research related to the current document (at the CORE website)
- Research related to the current document (at the CORE website)
Back to top Back to top