National and Kapodistrian University of Athens
ΣΧΕΔΙΑΣΜΟΣ ΚΑΙ ΒΕΛΤΙΣΤΟΠΟΙΗΜΕΝΗ ΥΛΟΠΟΙΗΣΗ ΕΝΟΣ ΣΥΣΤΗΜΑΤΟΣ ΔΙΑΧΕΙΡΗΣΗΣ ΒΑΣΕΩΝ ΔΕΔΟΜΕΝΩΝ ΙΣΤΟΡΙΚΟΥ ΤΥΠΟΥ
Abstract
dc:descriptionIN 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- Βάσεις δεδομένων
- Βελτιστοποίηση
- ΔΟΣΟΛΗΨΙΕΣ
- ΙΣΤΟΡΙΚΟΥ ΤΥΠΟΥ
- Μοντέλο κόστους
- ΤΑΥΤΟΧΡΟΝΟΙ ΧΡΗΣΤΕΣ
- Υλοποίηση
- ΧΡΟΝΟΣ ΕΓΚΥΡΟΤΗΤΑΣ
- CONCURRENT USERS
- Cost model
- Databases
- Historical
- Implementation
- Optimization
- Transactions
- VALID TIME
- Φυσικές Επιστήμες
- Επιστήμη Ηλεκτρονικών Υπολογιστών και Πληροφορική
- Natural Sciences
- Computer and Information Sciences
Rights
- Language dc:language
- gre
Identifiers
dc:identifier.*- Identifier
- 10.12681/eadd/5016