Converting the Logical Data Model
Foundations of database design/Foundations of database design series · 2005
Cited by 0
Read the abstract, see who wrote it and who cites it, and get the citation in APA, MLA, Chicago or Harvard.
About 10,000 papers for “Logical data model”
Foundations of database design/Foundations of database design series · 2005
Cited by 0
Nadeem Mahmood, S. M. Aqil Burney, Kamran Ahsan · arXiv (Cornell University) · 2010
Time is one of the most difficult aspects to handle in real world applications such as database systems. Relational database management systems proposed by Codd offer very little built-in query language support for temporal data management. The model itself incorporates neither the concept of time nor any theory of temporal semantics. Many temporal extensions of the relational model have been proposed and some of them are also implemented. This paper offers a brief introduction to temporal database research. We propose a conceptual model for handling time varying attributes in the relational database model with minimal temporal attributes.
Cited by 14Open access
C. Michael Walton, Dan Seedah, Alejandra Cruz-Ross et al. · Texas Digital Library (University of Texas) · 2014
In November 2011, the Texas Department of Transportation (TxDOT) funded a study to integrate data from multiple sources to optimize freight transportation planning efforts in the state. The Center for Transportation (CTR) study team was commissioned to explore the feasibility of entering into a data-sharing partnership with representatives of the private sector (i.e., shippers, receivers, trucking companies, forwarders, etc.), and obtain sample data that can be used in formulating a strategy for integrating multiple data sources. To build relationships with the private sector, the study team contacted 493 companies, received 151 responses, and conducted 33 key-person interviews with executive level managers of trucking companies, shippers, airports, logistics companies, rail carriers, and ports. These interviews were preceded by an online survey of 32 companies to establish private-sector willingness to enter into a data-sharing partnership, and assist the study team in understanding their needs and concerns. This document summarizes the study team’s efforts to establish data-sharing partnerships and relay the lessons learned. In addition, it provides information on a prototype freight data architecture and supporting description and specifications that will facilitate the storage and exchange of data through a data sharing partnership with members of Texas’s freight community. Final recommendations on who should be responsible for populating and developing the integrated freight system are also made, and list of items to be considered in estimating the cost for developing and maintaining the system are presented.
Cited by 0Open access
Sandro Bimonte, Enrico Gallinucci, Patrick Marcel et al. · Knowledge and Information Systems · 2022
Abstract Multi-model DBMSs, which support different data models with a fully integrated backend, have been shown to be beneficial to data warehouses and OLAP systems. Indeed, they can store data according to the multidimensional model and, at the same time, let each of its elements be represented through the most appropriate model. An open challenge in this context is the lack of methods for logical design. Indeed, in a multi-model context, several alternatives emerge for the logical representation of dimensions and facts. The goal of this paper is to devise a set of guidelines for the logical design of multi-model data warehouses so that the designer can achieve the best trade-off between features such as querying, storage, and ETL. To this end, for each model considered (relational, document-based, and graph-based) and for each type of multidimensional element (e.g., non-strict hierarchy) we propose some solutions and carry out a set of intra-model and inter-model comparisons. The resulting guidelines are then tested on a case study that shows all types of multidimensional elements.
Cited by 15Open access
Globaldev · Zenodo (CERN European Organization for Nuclear Research) · 2023
The energy and utilities industry is facing several challenges as it moves towards sustainability, like legacy infrastructure, more complex processes, pressure from consumers and government, and data interpreting issues. Out of all those challenges, legacy infrastructure and issues with data gathering are the hardest ones to overcome. Assets are aging rapidly and are often insubstantial to meet the needs of a changing industry. The process of updating crucial energy infrastructure with more efficient, digital-ready parts can't be achieved overnight. And with digital transformation in place, sometimes companies end up drowning in too much data from too many assets. It isn't easy to know which data to focus on and what it tells us.To solve these problems, energy & utilities companies need to use new technology, come up with new business models, and, most importantly, get help from experts who can guide them through the whole process. One of the leading tech companies in New Zealand, Gentrack, made it their goal to simplify the sustainability journey for energy & utilities companies.With Globaldev's experts, they were able to design and develop a completely new data and analytics layer, Gentrack Logical Data Model, to process a wealth of data. GLDM acts as a single source of data, gives a complete overview of the customer, can generate reports and analytics quickly, and allows the implementation of AI/ML use cases on top of 100s of predefined utility-centric KPIs. To accomplish this, Gentrack leveraged Globaldev's BI and D&A specialists that were integrated into the in-house team. Read more
Cited by 0Open access
Stephen Berman · Unisa Institutional Repository (University of South Africa) · 1987
Semantic data models were originally introduced as a tool for data description and design. SDMI (Semantic Data Model Interface) investigates their use in another role - as the basis for a data manipulation language - and shows how this can provide a means of achieving complete logical data independence. With SDMI users view a database simply in terms of objects and their attributes, and can access any combination of related information just by stating the relationship(s) of interest. This paper outlines the problem of logical data dependence that is inherent in all existing database systems and shows how the universal relation approach fails to provide a complete solution. SDMI is described and shown to be a more promising alternative.
Cited by 0Open access
Globaldev · Zenodo (CERN European Organization for Nuclear Research) · 2023
The energy and utilities industry is facing several challenges as it moves towards sustainability, like legacy infrastructure, more complex processes, pressure from consumers and government, and data interpreting issues. Out of all those challenges, legacy infrastructure and issues with data gathering are the hardest ones to overcome. Assets are aging rapidly and are often insubstantial to meet the needs of a changing industry. The process of updating crucial energy infrastructure with more efficient, digital-ready parts can't be achieved overnight. And with digital transformation in place, sometimes companies end up drowning in too much data from too many assets. It isn't easy to know which data to focus on and what it tells us.To solve these problems, energy & utilities companies need to use new technology, come up with new business models, and, most importantly, get help from experts who can guide them through the whole process. One of the leading tech companies in New Zealand, Gentrack, made it their goal to simplify the sustainability journey for energy & utilities companies.With Globaldev's experts, they were able to design and develop a completely new data and analytics layer, Gentrack Logical Data Model, to process a wealth of data. GLDM acts as a single source of data, gives a complete overview of the customer, can generate reports and analytics quickly, and allows the implementation of AI/ML use cases on top of 100s of predefined utility-centric KPIs. To accomplish this, Gentrack leveraged Globaldev's BI and D&A specialists that were integrated into the in-house team. Read more
Cited by 0Open access
Ctg. Apa · 2008
Cited by 0
Waseem Jeelani Bakshi, Rana Hashmy, Majid Zaman et al. · International Journal of Database Theory and Application · 2018
Physical integration of heterogeneous data sources is too high a price for small and medium level enterprises. This is primarily because of the variance in data base management system (MySQL, MsSQL, Oracle, etc.), underlying operating systems (Linux, Windows, etc.), besides numerous legacy sources (DBase, Foxplus, etc.). Enterprises are spending huge amounts for establishing data warehouses while as the data of interest increases gradually [Harmeek Bedi]. Over the years enterprises have accumulated numerous data sources along with legacy repositories which have variant data, schema and context and their integration is increasingly difficult. In this paper we propose a LDIM (Logical Data Integration Model) which will describe data, schema and context for integration of heterogeneous data sources including legacy repositories.
Cited by 0Open access
Juha-Pekka Soininen, Gabriella Laatikainen · Data in Brief · 2025
The paper presents a use case model and a logical architecture model of a data space system. The models view the data space system from the user and operator perspectives and describe the needed functionalities and their connection on an abstract level. The core features in our data space model are collaboration networks and contract-based data sharing. The models are meant as a simple and explainable first introduction to what a data space system is, and they provide an implementation technology-independent basis for creating data space implementation specifications. The model is validated by comparing it with existing data space reference models from IDSA, GAIA-X, and the Data Space Support Centre. The modelled core features map with the technical specifications of the system. Our study enables data space system developers to think out of the box and create new innovative solutions.
Cited by 3Open access
Moshe Y. Vardi · IEEE Software · 1988
The universal-relation model is introduced, and its fundamental ideas are outlined. This model keeps access-path independence by removing the need for logical navigation among relations. One benefit is a simple yet powerful query-language interface. Two universal-relation database-management systems are discussed that provide good examples of the model: System/U, developed at Stanford University, and FIDL, developed at International Computers Ltd. in Britain.< <ETX xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xlink="http://www.w3.org/1999/xlink">></ETX>
Cited by 35
Alexandr Savinov · 2005
The paper describes logical navigation in the concept-oriented data model. This model explicitly and formally separates physical structure and logical structure so that each element of the model is simultaneously a collection and a combination of other elements. The physical structure is used to representing and access by elements by means of references. The logical structure is used to reflect the problem domain dependencies. The two-level model considered in the paper consists of a set of concepts and a set of items. Concept structure defines the model syntax while item structure defines its semantics. In the paper it is shown how the properties of the model can be used for logical navigation where we do not need to specify join conditions or other complicated parameters of queries. 1.
Cited by 16
Nataly Zhukova, Alexey Subbotin · 2022
The article presents a logical data model for intelligent video surveillance systems. New opportunities for creating data models focused on the widespread use of machine learning methods are considered. New methods for constructing logical models and their application in intelligent video surveillance systems are proposed. A smartphone application has been developed. The effectiveness of using the proposed logical models for data processing in fog and cloud environments has been proved. Specific examples are given.
Cited by 7
Henriques, Telmo Antonio, O'Neill, Henrique · Journal of the Association for Information Systems · 2020
Developing Action and Design Research (ADR) interventions involves the application of a rigorous set of processes, and the production of explicit data to support the whole process, evidencing its base, intermediate, and final results. In a previous publication – based on empirical work, a comprehensive literature review, and the practice of its application teaching graduate students on qualitative research – a conceptual model for ADR has been developed. It has presented a tri-dimensional perspective, emergent from the Organization Development, Engineering and Science approaches, identifying its core processes and data. Based on that view, a high-level Process Meta-Model has been produced, detailing the main processes involved in ADR interventions and the associated data flows. Progressing within this structured line of research, the objective of this publication is to present a pragmatic approach to ADR main data structures – under the form of a high-level Data Model – evidencing the core data involved in the design, planning, development, and evaluation of this kind of initiatives. It includes the associated data structure diagram and the relevant details of the respective data components, which will act as researchers’ facilitators for documenting the whole process.
Cited by 0
Henriques, T., O'Neill, Henrique · Repositório Institucional do ISCTE-IUL (ISCTE-IUL) · 2020
Developing Action and Design Research (ADR) interventions involves the application of a rigorous set of processes, and the production of explicit data to support the whole process, evidencing its base, intermediate, and final results. In a previous publication – based on empirical work, a comprehensive literature review, and the practice of its application teaching graduate students on qualitative research – a conceptual model for ADR has been developed. It has presented a tri-dimensional perspective, emergent from the Organization Development, Engineering and Science approaches, identifying its core processes and data. Based on that view, a high-level Process Meta-Model has been produced, detailing the main processes involved in ADR interventions and the associated data flows. Progressing within this structured line of research, the objective of this publication is to present a pragmatic approach to ADR main data structures – under the form of a high-level Data Model – evidencing the core data involved in the design, planning, development, and evaluation of this kind of initiatives. It includes the associated data structure diagram and the relevant details of the respective data components, which will act as researchers’ facilitators for documenting the whole process.
Cited by 0Open access
LABELLA, Anna · IRIS Research product catalog (Sapienza University of Rome) · 1977
Cited by 0
Mokrane Bouzeghoub, Zoubida Kedad · Lecture notes in computer science · 2000
Cited by 17
Borelli-Vittori, Evelyne · OpenGrey (Institut de l'Information Scientifique et Technique) · 1992
Cited by 0
Demetrovics, J. · Repository of the Academy's Library (Library of the Hungarian Academy of Sciences) · 1982
Cited by 0
Zehua Liu, Feifei Li, Wee Keong Ng · 2002
Information sources over the WWW contain a large amount of data organized according to different interests and values. Thus, it is important that facilities are there to enable users to extract information of interests in a simple and effective manner. To do this, information from the Web sources need to be extracted automatically according to users&apos; interests. However, the extraction of information requires in-depth knowledge of relevant technologies and the extraction process is slow, tedious and difficult for ordinary users. We propose the Wiccap Data Model, an XML data model that maps Web information sources into commonly perceived logical models. Based on this data model, ordinary users are able to extract information easily and efficiently. To accelerate the creation of data models, we also define a formal process for creating such data model and have implemented a software tool to facilitate and automate the process of producing Wiccap Data Models.
Cited by 0