by Chat Siu Wing. / Thesis (M.Phil.)--Chinese University of Hong Kong, 1990. / Bibliography: leaves 104-107. / ABSTRACT --- p.i / ACKNOWLEDGEMENTS --- p.ii / TABLE OF CONTENTS --- p.iii / Chapter CHAPTER 1 --- INTRODUCTION --- p.1 / Chapter CHAPTER 2 --- TEMPORAL DATABASES --- p.5 / Chapter 2.1 --- The Importance of Temporal Data --- p.5 / Chapter 2.2 --- Incorporating Time in Databases --- p.6 / Chapter 2.2.1 --- Time Dimensions --- p.6 / Chapter 2.2.2 --- Classification --- p.6 / Chapter 2.2.2.1 --- Snapshot Databases --- p.6 / Chapter 2.2.2.2 --- Rollback Databases --- p.7 / Chapter 2.2.2.3 --- Historical Databases --- p.8 / Chapter 2.2.2.4 --- Temporal Databases --- p.9 / Chapter 2.2.3 --- Current Research Areas --- p.9 / Chapter 2.2.3.1 --- Time Semantics at the Conceptual Level --- p.10 / Chapter 2.2.3.2 --- Temporal Data Model --- p.11 / Chapter 2.2.3.3 --- Temporal Query Language --- p.11 / Chapter CHAPTER 3 --- CONCEPTUAL TEMPORAL DATA MODELING …… --- p.13 / Chapter 3.1 --- The Time Generic --- p.13 / Chapter 3.1.1 --- Time Unit --- p.14 / Chapter 3.1.2 --- Interval --- p.15 / Chapter 3.1.3 --- Periodic Time --- p.16 / Chapter 3.1.4 --- Time Point --- p.17 / Chapter 3.2 --- Extended Entity Relationship (EER) Model --- p.17 / Chapter 3.2.1 --- Attribute --- p.18 / Chapter 3.2.2 --- Entity --- p.22 / Chapter 3.2.3 --- Relationship --- p.23 / Chapter 3.2.4 --- Event --- p.23 / Chapter 3.3 --- EER Modeling of Temporal Data --- p.25 / Chapter 3.3.1 --- Classify entities and attributes --- p.25 / Chapter 3.3.2 --- Define events --- p.26 / Chapter 3.3.3 --- Define relationships --- p.27 / Chapter 3.3.4 --- Classify Attributes --- p.27 / Chapter CHAPTER 4 --- LOGICAL TEMPORAL DATABASE DESIGN --- p.28 / Chapter 4.1 --- Embedding a Temporal Relation into a Snapshot Relation --- p.28 / Chapter 4.2 --- The Proposed Temporal Relational Model --- p.29 / Chapter 4.2.1 --- Extension to Relational Model --- p.30 / Chapter 4.2.2 --- Extended Properties --- p.31 / Chapter 4.2.3 --- Extended Information Contents --- p.32 / Chapter 4.2.3.1 --- Different Temporal Information --- p.32 / Chapter 4.2.3.2 --- Retroactive and Postactive Recording --- p.33 / Chapter 4.2.3.3 --- Multiple Values at an Instant --- p.33 / Chapter 4.2.3.4 --- Discrete Valid Intervals --- p.34 / Chapter 4.2.4 --- Data Manipulation --- p.34 / Chapter 4.2.4.1 --- Retrieval --- p.35 / Chapter 4.2.4.2 --- Updating --- p.36 / Chapter 4.2.5 --- Probable Undesirable Properties --- p.37 / Chapter 4.2.5.1 --- Redundancy --- p.37 / Chapter 4.2.5.2 --- Update Anomalies --- p.39 / Chapter 4.2.5.3 --- Retrieval Anomalies --- p.39 / Chapter 4.3 --- Mapping Conceptual to Temporal Relational Model --- p.40 / Chapter 4.3.1 --- Relations For the Time Generic --- p.40 / Chapter 4.3.1.1 --- Interval --- p.40 / Chapter 4.3.1.2 --- Time Point --- p.41 / Chapter 4.3.1.3 --- Periodic Time --- p.42 / Chapter 4.3.2 --- Mapping History into Time Attributes --- p.42 / Chapter 4.3.2.1 --- Attribute History --- p.42 / Chapter 4.3.2.2 --- Existence History --- p.43 / Chapter 4.3.3 --- Mapping Entity Type --- p.43 / Chapter 4.3.3.1 --- Strong Entity --- p.43 / Chapter 4.3.3.2 --- Weak Entity --- p.46 / Chapter 4.3.3.3 --- Temporally Weak Entity --- p.46 / Chapter 4.3.4 --- Mapping Event Type --- p.46 / Chapter 4.3.5 --- Mapping Relationship Type --- p.48 / Chapter 4.4 --- Joining Synchronous Relations --- p.49 / Chapter 4.5 --- Integrity Constraints --- p.50 / Chapter 4.5.1 --- Creation --- p.51 / Chapter 4.5.2 --- Deletion --- p.51 / Chapter 4.5.3 --- Modification of Past States --- p.52 / Chapter CHAPTER 5 --- A TEMPORAL QUERY LANGUAGE - TempSQL --- p.53 / Chapter 5.1 --- New Statements --- p.53 / Chapter 5.2 --- New Constructs in Statements --- p.54 / Chapter 5.2.1 --- Temporal Operators --- p.54 / Chapter 5.2.2 --- Temporal Comparison Operators --- p.55 / Chapter 5.2.3 --- WHEN Clause --- p.56 / Chapter 5.2.4 --- AS OF clause --- p.58 / Chapter 5.2.5 --- VALID clause --- p.58 / Chapter 5.2.6 --- A General Example --- p.60 / Chapter 5.3 --- Semantics of TempSQL Statements --- p.61 / Chapter 5.3.1 --- SELECT --- p.62 / Chapter 5.3.2 --- INSERT --- p.64 / Chapter 5.3.3 --- DISCARD --- p.66 / Chapter 5.3.4 --- UPDATE --- p.68 / Chapter CHAPTER 6 --- IMPLEMENTATION OF TempSQL --- p.78 / Chapter 6.1 --- The Underlying Environment --- p.78 / Chapter 6.2 --- The Preprocessor --- p.79 / Chapter 6.3 --- The Interactive Interpreter --- p.81 / Chapter 6.4 --- Limitations --- p.82 / Chapter CHAPTER 7 --- AN EXAMPLE TEMPORAL DATABASE --- p.84 / Chapter 7.1 --- The Scenario --- p.84 / Chapter 7.2 --- EER modeling of data --- p.84 / Chapter 7.3 --- Transformation into Temporal Relations --- p.85 / Chapter 7.4 --- Joining Synchronous Relations --- p.87 / Chapter 7.5 --- Sample Queries --- p.87 / Chapter 7.6 --- Remarks --- p.91 / Chapter CHAPTER 8 --- CONCLUSION AND FUTURE RESEARCH / DIRECTIONS --- p.94 / Chapter APPENDIX A --- BNF of TempSQL --- p.100 / REFERENCES --- p.104
| Identifer | oai:union.ndltd.org:cuhk.edu.hk/oai:cuhk-dr:cuhk_318617 |
| Date | January 1990 |
| Contributors | Chat, Siu Wing., Chinese University of Hong Kong Graduate School. Division of Computer Science. |
| Publisher | Chinese University of Hong Kong |
| Source Sets | The Chinese University of Hong Kong |
| Language | English |
| Detected Language | English |
| Type | Text, bibliography |
| Format | print, v, 107 leaves : ill. ; 30 cm. |
| Rights | Use of this resource is governed by the terms and conditions of the Creative Commons “Attribution-NonCommercial-NoDerivatives 4.0 International” License (http://creativecommons.org/licenses/by-nc-nd/4.0/) |
Page generated in 0.2441 seconds