Preview

A Model Theory for Generic Schema Management Models

Powerful Essays
Open Document
Open Document
5618 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
A Model Theory for Generic Schema Management Models
ATLANTIC INTERNATIONAL UNIVERSITY

A Model Theory for Generic Schema Management Models
Kinan M Al Haffar

UM4699SIT10550D 07/08/2007

Abstract
The core of a model theory for generic schema management is developed. This theory has two distinctive features: it applies to a variety of categories of schemas, and it applies to transformations of both the schema structure and its integrity constraints. A subtle problem of schema integration is considered in its general form, not bound to any particular category of schemas. The proposed solution, as well as the overall theory, is based entirely on schema morphisms that carry both structural and semantic properties. Duality results that apply to the two levels (i.e., the schema and the data levels) are established. These results lead to the main contribution of this paper: a formal schema and data management framework for generic schema management. Implications of this theory are established that apply to integrity problems in schema integration. The theory is illustrated by a particular category of schemas with object-oriented features along with typical database integrity constraints.

1

Introduction

This paper presents the core results of a model theory for generic schema management, by which we mean schema and database transformation capabilities that are independent of a particular data model. Such transformations require major database programming tasks, such as integrating source schemas when building a data warehouse or integrating different user views into an overall database schema. In spite of nontrivial typing issues created by such transformations, database programming and other relevant paradigms have been primarily suited to dealing with structural aspects of those transformations. A major challenge is in properly addressing semantics: the integrity constraints associated with database schemas. A second major challenge is in developing such a model theory that is applicable to a variety of

You May Also Find These Documents Helpful

  • Good Essays

    Week 1 SOW 1

    • 452 Words
    • 2 Pages

    Building the Physical Database: The data model will be translated into the Relational Database Management system of choice. All Tables and Columns with specific data types will be created and will include Relational and other constraints.…

    • 452 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    IT113 Unit 5

    • 393 Words
    • 2 Pages

    • The Active Directory schema includes definitions of all objects and attributes within a single…

    • 393 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Nt1330 Unit 1 Study Guide

    • 1178 Words
    • 5 Pages

    To create Schema definition: It is a database administrator responsible to installation, configuration and upgrading hardware and operating system on given database and also to decide what information to be held in database.…

    • 1178 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    CMGT 400 Week 1 DQs

    • 676 Words
    • 3 Pages

    The project for CIS336 is designed to touch all aspects of the fundamental concepts of database design and logical data modeling covered during the class. The project is team centered and each team will be responsible for designing, developing, and demonstrating the functionality of a database created based on a defined set of business specifications. At the end of the session, each project team will submit the database designed by the team and demonstrate the database's ability to deliver the required information as outlined in the project specifications. All aspects of the project will be ...…

    • 676 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Nt1320 Unit 7

    • 2041 Words
    • 9 Pages

    Answer: A database is a model of how the users view their business world. This means that the users are the final judges as to what data the database should contain and how the records in that database should be related to one another. The easiest time to change the database structure is during the data modeling stage. So the user should be actively involved in the modeling process. The user review of a data model is crucial. When a database is developed, the user must carefully review the data model.…

    • 2041 Words
    • 9 Pages
    Good Essays
  • Satisfactory Essays

    Q3. Which administrative user accounts can view or modify the schema? Only the schadmin can modify the schema and the other two can only view.…

    • 230 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Speed- measures the amount of distnace traveled in a given amount of time. (Doesn't measure the direction of the travel) How fast an object is going with respect to a frame of reference.…

    • 1586 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    It 240 Appendix F

    • 260 Words
    • 2 Pages

    Schema: “The schema of the Active Directory contains a formal definition and set of rules for all objects and attributes of those objects” (Regan, 2006, p.385).…

    • 260 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    Dbm 381 Week 1 Individual

    • 971 Words
    • 4 Pages

    Pratt, P.J., & Adamski, J.J. (2012). Concepts of database management (7th ed.). Retrieved from The University of Phoenix eBook Collection database.…

    • 971 Words
    • 4 Pages
    Better Essays
  • Good Essays

    Cis 111

    • 790 Words
    • 4 Pages

    The relational model would provide Acme Global with a better understanding of the data needs of their organization. A Relational model offers data independence and efficient access. “The conceptual and external schemas provide independence from physical storage decisions and logical design decisions respectively.” (Ramakrishnan, 2007)…

    • 790 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

      Unary or recursive relationships Entity integrity: Keys Interesting design cases Converting logical model to a physical model 3 Last Class Review  JOINS   ANSI and traditional join syntax…

    • 600 Words
    • 9 Pages
    Satisfactory Essays
  • Good Essays

    Bodies of information in the form of an outline/model also that is interpreted, stored, and recalled. A British psychologist named Frederic Bartlett was the first to put forward this theory.…

    • 385 Words
    • 1 Page
    Good Essays
  • Powerful Essays

    data integration

    • 3605 Words
    • 15 Pages

    Figure 2: Simple schematic for a data-integration solution. A system designer constructs a mediated schema against which users can run queries. The virtual database interfaces with the source databases via wrapper code if required.…

    • 3605 Words
    • 15 Pages
    Powerful Essays
  • Powerful Essays

    Generic Organization

    • 1994 Words
    • 8 Pages

    A group is a well structured organization with different individuals that has different characteristics and diversity these groups can be formal or informal. In my research I have found that retail stores such as Wal-Mart and Kmart has organizational structure. Group task satisfaction describes the group-level counterpart to individual job satisfaction and represents the group’s shared attitude toward its task and work environment. Places such as Wal-Mart demonstrate these skills to make their organization. The prevalence of groups and teams in the workplace (Beyerlein, Johnson, & Beyerlein, 1995; Devine, Clayton, Philips, Dunford, & Melner, 1999) makes it important to understand their effects on group members. In this paper I will identify an industry and organization type, explain four problems that could impact groups productivity, develop and describes logical and appropriate recommendations for each of the four problems provided and its recommendation, wide training, and the conclusion.…

    • 1994 Words
    • 8 Pages
    Powerful Essays
  • Satisfactory Essays

    The new schema must go through…

    • 413 Words
    • 2 Pages
    Satisfactory Essays