Showing papers on "Data warehouse published in 1987"
01 Sep 1987
TL;DR: The POSTGRES as mentioned in this paper data model is a relational model that has been extended with abstract data types, data of type procedure, and attribute and procedure inheritance, which can be used to simulate a wide variety of semantic and object-oriented data modeling constructs including aggregation and generalization, complex objects with shared subobjects, and attributes that reference tuples in other relations.
Abstract: : This paper describes the data model for POSTGRES, a next-generation extensible database management system being developed at the University of California StR86 The data model is a relational model that has been extended with abstract data types, data of type procedure, and attribute and procedure inheritance These mechanisms can be used to simulate a wide variety of semantic and object-oriented data modeling constructs including aggregation and generalization, complex objects with shared subobjects, and attributes that reference tuples in other relations
223 citations
TL;DR: This paper investigates the possibility of handling different kinds of data structures, as well as both coordinate and attribute information within a unified conceptual scheme in an integrated geographical information system called GEO VIEW which can be implemented in a relational data base environment.
Abstract: Digital map data are currently available based on a variety of data structures, depending on the uses to which the data are to be put Within the major categories of vector and raster data, as well as other structures, there is a multiplicity of data formats. Further to this, data for digital map coordinates are frequently stored in a different way from attribute data pertaining to points, lines and polygons. Given these problems, this paper investigates the possibility of handling different kinds of data structures, as well as both coordinate and attribute information within a unified conceptual scheme. This scheme is expressed in terms of the design of an integrated geographical information system called GEO VIEW, which can be implemented in a relational data base environment. The structure of the tables in the data base is outlined, together with the methodology for coding different kinds of data structure into a standard form. Examples of queries are provided, using the SQL query language, to ...
38 citations
Book•
01 Jan 1987
TL;DR: Why database?
Abstract: Why database? elements of data data analysis data modelling normalization and synthesis implementatons and exploitation advanced data models databases in perspective selected solutions.
24 citations
01 Dec 1987
TL;DR: This paper first outlines the various types of information that fall under the purview of the proposed data manager, and considers extensions to the entity-relationship data model to implement the notion of hierarchical ordering, commonly found in musical data.
Abstract: As part of our research into a general purpose data management system for musical information, a major focus has been the development of tools to support a data model for music. This paper first outlines the various types of information that fall under the purview of our proposed data manager. We consider extensions to the entity-relationship data model to implement the notion of hierarchical ordering, commonly found in musical data. We then present examples from our schema for representing musical notation in a database, taking advantage of these extensions.
22 citations
TL;DR: ADAMO is a data management system for defining data and manipulating them from FORTRAN programs that combines a form of the Entity-Relationship model and the data flow diagrams of structured analysis to provide a system suited to algorithmic work.
17 citations
TL;DR: Computer automation has expanded the traditional concept of ensuring data quality to include a complex array of interrelated tasks that must be properly managed to achieve the desired results.
4 citations
TL;DR: These features show that the TDM not only improves the system performance, increases the parallelism and the data processing power, but also eliminates the performance bottlenecks in relational database systems.
Abstract: This paper proposes a Tree-structured Database Machine (TDM), which is designed for supporting large relational database systems. The TDM aims at totally improving three level performance bottlenecks in relational database systems, i.e. IO data transfer bottleneck, data processing bottleneck, and multiquery optimization bottleneck. For reducing these bottlenecks, the TDM provides the approaches of data partition and data distribution upon data storages for concurrent data accesses, the tree-structured multiprocessor architecture for parallel data processing, the technique of tightly-coupled-shared-memory for decreasing data movement, the mechanisms of indices and dictionaries for reducing data transfer from the data storages to the memory, and so on. These features show that the TDM not only improves the system performance, increases the parallelism and the data processing power, but also eliminates the performance bottlenecks in relational database systems.
3 citations
TL;DR: It is shown that an object‐oriented data management system is a step towards solving the problems of design data management, based on a systematic specification of data structures and data access methods, using abstract data type specifications.
Abstract: The computer-aided design of dedicated pipelined processors for numerical applications and signal processing requires design tools that support system refinement, partitioning strategies and the transformation of behavioural descriptions into structure. This in turn poses problems of design data management which are considered here. We show that an object-oriented data management system is a step towards solving the problems. The method proposed here is based on a systematic specification of data structures and data access methods, using abstract data type specifications. As a result, the data management is completely transparent to the application programs. The data-management system is written in Enhanced C (EC), a set-orientated extension of the language C.
3 citations