Back to search

National and Kapodistrian University of Athens

ΣΧΕΔΙΑΣΜΟΣ ΚΑΙ ΒΕΛΤΙΣΤΟΠΟΙΗΜΕΝΗ ΥΛΟΠΟΙΗΣΗ ΕΝΟΣ ΣΥΣΤΗΜΑΤΟΣ ΔΙΑΧΕΙΡΗΣΗΣ ΒΑΣΕΩΝ ΔΕΔΟΜΕΝΩΝ ΙΣΤΟΡΙΚΟΥ ΤΥΠΟΥ

Abstract

dc:description

IN THIS STUDY, WE PRESENT THE DESIGN AND IMPLEMENTATION OF AN HISTORICAL DBMS, I.E. A DBMS SUPPORTING VALID TIME DATA. THE DBMS USES VT-SQL, A SYNTACTICALLY AND SEMANTICALLY CONSISTENT EXTENSION TO SQL-89, AS ITS DATA DEFINITION AND MANIPULATION LANGUAGE. VT-SQL ALLOWS FOR THE CREATION OF TABLES CONTAINING VALID TIME DATA AND MANIPULATES THESE DATA TAKING INTO ACCOUNT THEIR TEMPORAL SEMANTICS. THE HISTORICAL DBMS HAS BEEN BUILT AS A SHELL TO THE INGRES RDBMS. INGRES IS USED FOR THE STORAGE AND RETRIEVAL OF DATA, AT THE PHYSICAL LEVEL, WHILE THE SHELL SUPPORTS THE VT-SQL SYNTAX AND IMPLEMENTS THE TEMPORAL SEMANTICS. EMPHASIS HAS BEEN PUT IN THE PERFORMANCE ASPECTS OF THE HISTORICAL DBMS, SO THAT THE SUPPORT OF THE ADDITIONAL SEMANTICS DOES NOT LEAD TO POOR PERFORMANCE. IN ORDER TO PROVIDE HIGH PERFORMANCE, NEW ALGORITHMS HAVE BEEN DESIGNED, EXPLOITING THE POTENTIAL OFFERED BY EMBEDDED SQL. THESE ALGORITHMS DELIVER CONSIDERABLY BETTER PERFORMANCE THAN THE ONES THAT HAD BEEN USED IN PREVIOUS IMPLEMENTATIONS OF THE HISTORICAL DBMS. FINALLY, THE HISTORICAL DBMS HAS BEEN ENHANCED WITH SUPPORT FOR TRANSACTIONS AND CONCURRENT USERS, WHICH ARE IMPORTANT FEATURES FOR A DBMS.

Degree

thesis:*
Grantor dc:publisher
National and Kapodistrian University of Athens
Year dc:date
1995

Author and committee

dc:creator, dc:contributor.*
Author dc:creator
  • Βασιλάκης, Κωνσταντίνος

Subjects

dc:subject × 20

Rights

Language dc:language
gre

Identifiers

dc:identifier.*
Identifier
10.12681/eadd/5016

Chain of custody

source
Harvested from
Greek National Archive of PhD Theses
Base URL
phdtheses.ekt.gr/eadd_oai/request
Last updated
2026-11-18
Source record
OAI-PMH GetRecord
citation

Βασιλάκης, Κωνσταντίνος. ΣΧΕΔΙΑΣΜΟΣ ΚΑΙ ΒΕΛΤΙΣΤΟΠΟΙΗΜΕΝΗ ΥΛΟΠΟΙΗΣΗ ΕΝΟΣ ΣΥΣΤΗΜΑΤΟΣ ΔΙΑΧΕΙΡΗΣΗΣ ΒΑΣΕΩΝ ΔΕΔΟΜΕΝΩΝ ΙΣΤΟΡΙΚΟΥ ΤΥΠΟΥ. National and Kapodistrian University of Athens, 1995. http://hdl.handle.net/10442/hedi/5016