The Experts below are selected from a list of 1035 Experts worldwide ranked by ideXlab platform

Curtis Maitland Knowles - One of the best experts on this subject based on the ideXlab platform.

  • TRANSLATING DATA BETWEEN XML SCHEMA AND 6NF CONCEPTUAL MODELS
    2016
    Co-Authors: Curtis Maitland Knowles
    Abstract:

    (Under the Direction of Vladan Jovanovic) Sixth Normal Form (6NF) is a term used in relational database theory by Christopher Date to describe databases which decompose relational variables to irreducible elements. While this Form may be unimportant for non-temporal data, it is certainly important for data containing temporal variables of a point-in-time or interval nature. With the advent of Data Warehousing 2.0 (DW 2.0), there is now an increased emphasis on using fully-temporalized databases in the context of data warehousing, in particular with approaches such as the Anchor Model and Data Vault. In this work, we will explore the concepts of temporal data, 6NF conceptual database models, and their relationship with DW 2.0. Further, we will evaluate the Anchor Model and Data Vault as design methods in which to capture temporal data. Using these methods, we will define a process for translating 6NF-compliant data into a standard eXtensible Markup Language (XML) Schema which can be used to describe and present such data to disparate systems in a structured Format suitable for data exchange. Further, we will discuss benefits, advantages, and limitation

Knowles, Curtis Maitland - One of the best experts on this subject based on the ideXlab platform.

  • Translating Data Between Xml Schema and 6Nf Conceptual Models
    Digital Commons@Georgia Southern, 2012
    Co-Authors: Knowles, Curtis Maitland
    Abstract:

    Sixth Normal Form (6NF) is a term used in relational database theory by Christopher Date to describe databases which decompose relational variables to irreducible elements. While this Form may be unimportant for non-temporal data, it is certainly important for data containing temporal variables of a point-in-time or interval nature. With the advent of Data Warehousing 2.0 (DW 2.0), there is now an increased emphasis on using fully-temporalized databases in the context of data warehousing, in particular with approaches such as the Anchor Model and Data Vault. In this work, we will explore the concepts of temporal data, 6NF conceptual database models, and their relationship with DW 2.0. Further, we will evaluate the Anchor Model and Data Vault as design methods in which to capture temporal data. Using these methods, we will define a process for translating 6NF-compliant data into a standard eXtensible Markup Language (XML) Schema which can be used to describe and present such data to disparate systems in a structured Format suitable for data exchange. Further, we will discuss benefits, advantages, and limitations to using XML representations of 6NF models for the transfer of data into a data warehouse

Tatjana Kovač - One of the best experts on this subject based on the ideXlab platform.

  • Relational model of temporal data based on 6th Normal Form
    'Mechanical Engineering Faculty in Slavonski Brod', 2017
    Co-Authors: Darko Golec, Viljan Mahnič, Tatjana Kovač
    Abstract:

    Ovaj rad povezuje dva različita područja istraživanja, tj. Temporalne podatke i Relacijsko modeliranje. Temporalni podaci su podaci koji predstavljaju stanje u vremenu, a temporalna baza podataka je baza podataka s ugrađenom podrškom za baratanje s podacima koji uključuju vrijeme. Većina temporalnih sustava pruža dovoljno temporalnih karakteristika, ali su relacijski modeli nepravilno Normalizirani, a pristupi modeliranju nedostaju ili nisu uvjerljivi. Ovim se prijedlogom daju prednosti modeliranja temporalne baze podataka, prvenstveno korištene u analitici i izvještavanju, gdje tipična pretraživanja uključuju mali podniz atributa i veliku količinu zapisa. U radu se definira posebni logički model koji podržava temporalne podatke i konzistenciju, zasnovan na vertikalnoj dekompoziciji i šestoj Normalnoj Formi (6NF). Primjena 6NF omogućuje neovisnost u promjeni atributnih vrijednosti i tako sprečava redundanciju i anomalije. Naš je model uspoređen s drugim temporalnim modelima i demonstrirano je super brzo pretraživanje postignuto eliminacijom spajanja baze podataka (database join elimination). Svrha je rada pomoći stručnjacima koji se bave bazama podataka u primjeni temporalnog modeliranja.This paper brings together two different research areas, i.e. Temporal Data and Relational Modelling. Temporal data is data that represents a state in time while temporal database is a database with built-in support for handling data involving time. Most of temporal systems provide sufficient temporal features, but the relational models are improperly Normalized, and modelling approaches are missing or unconvincing. This proposal offers advantages for a temporal database modelling, primarily used in analytics and reporting, where typical queries involve a small subset of attributes and a big amount of records. The paper defines a distinctive logical model, which supports temporal data and consistency, based on vertical decomposition and Sixth Normal Form (6NF). The use of 6NF allows attribute values to change independently of each other, thus preventing redundancy and anomalies. Our proposal is evaluated against other temporal models and super-fast querying is demonstrated, achieved by database join elimination. The paper is intended to help database professionals in practice of temporal modelling

Paschim Vihar - One of the best experts on this subject based on the ideXlab platform.

  • Normalization in Conceptual Phase of RDBMS Using AER (Articulated Entity Relationship) Diagram
    2011
    Co-Authors: Vijay Laxmi, Gunjan Batra, Shafali Dhall, Paschim Vihar
    Abstract:

    EXTENDED ABSTRACT The ER model enjoys widespread popularity as a tool for conceptual database design, and received many extensions and variations, which are generally termed as Enhanced-ER (EER) model. In this paper we make use of Articulated Entity Relationship (AER) diagram to accommodate the Functional Dependency (FD) inFormation as its part for complete automation of Normalization with an additional advantage that any modifications (addition, deletion or updation of attributes) made to the AER diagram will automatically be reflected in its FD inFormation. Normalization, which makes up the core of the design theory for relational databases, is also considered an important technique to improve the quality of ER schema. Normalization is the process of grouping attributes into refined structures. The Normal Forms and the process of Normalization have been studied by many researchers, since Codd initiated the subject. First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF) were the only Forms originally proposed by Codd, and they are the Normal Forms supported by commercial case tools. The higher Form of Normalization such as BCNF (Boyce/Codd Normal Form), the Fourth Normal Form (4NF), the Fifth Normal Form (5NF), DKNF (Domain/key Normal Form) and the Sixth Normal Form (6NF) are academically important but are not widely implemented yet. The objective of Normalization is to organize data into stable structures, and thereby minimize update anomalies and maximize data accessibility. Although Normalization is generally regarded as the rule for the statue of relational database design, there are still times when database designers may turn to deNormalizing a database in order to enhance perFormance and ease of use. Even though Normalization results in many benefits, there is at least one major drawback – poor system perFormance. ERD which is the end product of conceptual data modeling phase of database life cycle is first transFormed into relational database design during logical phase and then Normalized. Normalization utilizes association among attributes within an entity table to accomplish its objective. Since an ERD also utilizes association among attributes as a basis to identify entity type structure, it is possible to apply Normalization principles during the conceptual data modeling phase. This paper also suggests inclusion of Normalization techniques before logical design phase. Here, we first present a framework for describing ER schema. Then Normal Forms are defined and a complete set of transFormations to achieve these Normal Forms is suggested. We discuss few of the limitations of AER model and how to overcome these limitations. Finally, we discuss how the theory may be applied and give an outlook on future research.

Darko Golec - One of the best experts on this subject based on the ideXlab platform.

  • Relational model of temporal data based on 6th Normal Form
    'Mechanical Engineering Faculty in Slavonski Brod', 2017
    Co-Authors: Darko Golec, Viljan Mahnič, Tatjana Kovač
    Abstract:

    Ovaj rad povezuje dva različita područja istraživanja, tj. Temporalne podatke i Relacijsko modeliranje. Temporalni podaci su podaci koji predstavljaju stanje u vremenu, a temporalna baza podataka je baza podataka s ugrađenom podrškom za baratanje s podacima koji uključuju vrijeme. Većina temporalnih sustava pruža dovoljno temporalnih karakteristika, ali su relacijski modeli nepravilno Normalizirani, a pristupi modeliranju nedostaju ili nisu uvjerljivi. Ovim se prijedlogom daju prednosti modeliranja temporalne baze podataka, prvenstveno korištene u analitici i izvještavanju, gdje tipična pretraživanja uključuju mali podniz atributa i veliku količinu zapisa. U radu se definira posebni logički model koji podržava temporalne podatke i konzistenciju, zasnovan na vertikalnoj dekompoziciji i šestoj Normalnoj Formi (6NF). Primjena 6NF omogućuje neovisnost u promjeni atributnih vrijednosti i tako sprečava redundanciju i anomalije. Naš je model uspoređen s drugim temporalnim modelima i demonstrirano je super brzo pretraživanje postignuto eliminacijom spajanja baze podataka (database join elimination). Svrha je rada pomoći stručnjacima koji se bave bazama podataka u primjeni temporalnog modeliranja.This paper brings together two different research areas, i.e. Temporal Data and Relational Modelling. Temporal data is data that represents a state in time while temporal database is a database with built-in support for handling data involving time. Most of temporal systems provide sufficient temporal features, but the relational models are improperly Normalized, and modelling approaches are missing or unconvincing. This proposal offers advantages for a temporal database modelling, primarily used in analytics and reporting, where typical queries involve a small subset of attributes and a big amount of records. The paper defines a distinctive logical model, which supports temporal data and consistency, based on vertical decomposition and Sixth Normal Form (6NF). The use of 6NF allows attribute values to change independently of each other, thus preventing redundancy and anomalies. Our proposal is evaluated against other temporal models and super-fast querying is demonstrated, achieved by database join elimination. The paper is intended to help database professionals in practice of temporal modelling