A Temporal Data Warehouse Conceptual Modelling and Its Transformation into Temporal Object Relational Model

A data warehouse is considered a key aspect of success for any decision support system. Research on temporal databases have produced important results in this field, and data warehouses, which store historical data, can clearly benefit from such studies. A slowly changing dimension is a dimension in which any of its attributes in a data warehouse can change infrequently over time. Although different solutions have been proposed, each has its own particular disadvantages. The authors propose the Object-Relational Temporal Data Warehouse (O-RTDW) model for the slowly changing dimensions in this research work. Using this approach, it is possible to keep track of the whole history of an object in a data warehouse efficiently. The proposed model has been implemented on a real data set and tested successfully. Several limitations implied in other solutions, such as redundancy, surrogate keys, incomplete historical data, and creation of additional tables are not present in our solution.

Download Full-text

Converting UML Class Diagrams into Temporal Object Relational DataBase

International Journal of Electrical and Computer Engineering (IJECE) ◽

10.11591/ijece.v7i5.pp2823-2832 ◽

2017 ◽

Vol 7 (5) ◽

pp. 2823 ◽

Cited By ~ 2

Author(s):

Ain El Hayat Soumiya ◽

Bahaj Mohamed

Keyword(s):

Relational Database ◽

Business Environment ◽

Database Management System ◽

Point Of View ◽

Time Varying ◽

Temporal Data ◽

Temporal Object ◽

Object Relational ◽

Modern Business ◽

Class Diagrams

<p class="Text"><span lang="EN-US">Number of active researchers and experts, are engaged to develop and implement new mechanism and features in time varying database management system (TVDBMS), to respond to the recommendation of modern business environment..Time-varying data management has been much taken into consideration with either the attribute or tuple time stamping schema. Our main approach here is to try to offer a better solution to all mentioned limitations of existing works in order to provide the non-procedural data definitions, queries of temporal data as complete as possible technical conversion that allow to easily realize and share all conceptual details of the UML class specifications, from conception and design point of view. This paper contributes to represent a logical design schema by UML class diagrams, which are handled by stereotypes to express a temporal object relational database with attribute timestamping.</span></p>

Download Full-text

ADN Message Designer/Dissector Implementation Based on Object-Relational Model

The Journal of Korean Institute of Communications and Information Sciences ◽

10.7840/kics.2021.46.1.141 ◽

2021 ◽

Vol 46 (1) ◽

pp. 141-153

Author(s):

Myeong-hwan Son ◽

Pu-sik Park ◽

Chong-ho Yoon

Keyword(s):

Relational Model ◽

Object Relational

Download Full-text

Enhancing Decision Support Systems with Spatial Capabilities

Strategic Information Systems ◽

10.4018/978-1-60566-677-8.ch158 ◽

2011 ◽

pp. 2542-2557

Author(s):

Marcus Costa Sampaio ◽

Cláudio de Souza Baptista ◽

André Gomes de Sousa ◽

Fabiana Ferreira do Nascimento

Keyword(s):

Decision Support ◽

Decision Support Systems ◽

Data Warehouse ◽

Spatial Data ◽

Support Systems ◽

Data Cube ◽

Related Data ◽

Spatial Dimensions ◽

Object Relational ◽

Long Time

This chapter introduces spatial dimensions and measures as a means of enhancing decision support systems with spatial capabilities. By some way or other, spatial related data has been used for a long time; however, spatial dimensions have not been fully exploited. It is presented a data model that tightly integrates data warehouse and geographical information systems — so characterizing a spatial data warehouse (SDW) — ; more precisely, the focus is on a formalization of SDW concepts, on a spatial-aware data cube using object-relational technology, and on issues underlying a SDW — specially regarding spatial data aggregation operations. Finally, the MapWarehouse prototype is presented aiming to validate the ideas proposed. The authors believe that SDW allows for the efficient processing of queries that use, jointly, spatial and numerical temporal data (e.g., temporal series from summarized spatial and numerical measures).

Download Full-text

3SST Model

Advances in Database Research - Systems Analysis and Design for Advanced Modeling Methods ◽

10.4018/978-1-60566-344-9.ch001 ◽

2010 ◽

pp. 1-14

Author(s):

Andreea Sabau

Keyword(s):

Data Model ◽

Conceptual Modeling ◽

Domain Model ◽

Relational Model ◽

Temporal Data ◽

Spatio Temporal ◽

Entity Relationship ◽

Temporal Objects ◽

Database Platform ◽

Event Based

In order to represent spatio-temporal data, many conceptual models have been designed and a part of them have been implemented. This chapter describes an approach of the conceptual modeling of spatio-temporal data, called 3SST. Also, the spatio-temporal conceptual and relational data models obtained by following the proposed phases are presented. The 3SST data model is obtained by following three steps: the construction of an entity-relationship spatio-temporal model, the specification of the domain model and the design of a class diagram which includes the objects characteristic to a spatiotemporal application and other needed elements. The relational model of the 3SST conceptual model is the implementation of the conceptual 3SST data model on a relational database platform. Both models are characterized by generality in representing spatial, temporal and spatio-temporal data. The spatial objects can be represented as points or objects with shape and the evolution of the spatio-temporal objects can be implemented as discrete or continuous in time, on time instants or time intervals. More than that, different types of spatial, temporal, spatio-temporal and event-based queries can be performed on represented data. Therefore, the proposed 3SST relational model can be considered the core of a spatio-temporal data model.

Download Full-text

Web Data Warehousing Convergence

Integrated Approaches in Information Technology and Web Engineering ◽

10.4018/978-1-60566-418-7.ch018 ◽

2009 ◽

pp. 278-303

Author(s):

D. Xuan Le ◽

J. Wenny Rahayu ◽

David Taniar

Keyword(s):

Data Warehouse ◽

Object Oriented ◽

Hierarchical Structures ◽

Structured Data ◽

Integration Technique ◽

Web Data ◽

Web Based ◽

Data Semantics ◽

Object Relational ◽

Data Source

This paper proposes a data warehouse integration technique that combines data and documents from different underlying documents and database design approaches. The well-defined and structured data such as Relational, Object- oriented and Object Relational data, semi-structured data such as XML, and unstructured data such as HTML documents are integrated into a Web data warehouse system. The user specified requirement and data sources are combined to assist with the definitions of the hierarchical structures, which serve specific requirements and represent a certain type of data semantics using object-oriented features including inheritance, aggregation, association and collection. A conceptual integrated data warehouse model is then specified based on a combination of user requirements and data source structure, which creates the need for a logical integrated data warehouse model. A case study is then developed into a prototype in a Web-based environment that enables the evaluation. The evaluation of the proposed integration Web data warehouse methodology includes the verification of correctness of the integrated data, and the overall benefits of utilizing this proposed integration technique.

Download Full-text