Schema Integration Essay

2304 words - 9 pages

In literature there exist several definitions of Schema:

“Schema integration is the process of merging autonomously developed DB schema into a unified, global schema to provide transparency through a unified view” [73].

“Schema integration is the process of identifying the components of a database which are related to one another, selecting the best representation for the global conceptual schema, and finally, integrating the components of each intermediate schema” [74].

12.2. Why is Schema Integration Required?

With respect to the web warehouse, schema integration is one of its important perspectives. There are heterogeneous sources of data in World Wide Web which vary in their schema configuration. Schemas from different domains vary in their structure and terminology like property tax schema or real estate schema. It may happens that the schemas from same real world domain also differ, since the schemas are developed independently in different real world contexts. This give rise to the need of schema integration to present a global conceptual schema for integrating the components and providing a unified view. “The aim of the integration process is the development of a global schema which integrates and subsumes the local schema in such a way that (global) users are provided with a uniform and correct view of the global database. The most urgent problem in this respect is semantic heterogeneity—if it is not detected and resolved, the usage of integrated data leads to invalid results” [75].

12.3. Problems in Schema Integration

Mainly two problems can arise in schema integration: [76]

12.3.1. Identification of associations among various conceptual schemas.
12.3.2. Verification of the identified associations, whether consistent with the schemas’ semantics.

12.4. Classification of Schema Integration Process

The schema integration process can be classified into following phases: [76], [81]

12.4.1. Pre-integration

An analysis of local schemata is carried out. The analysis made governs the choice of schemas to be integrated and the order of integration. A number of schemas to be integrated at a time and the amount of designer interaction are also decided in this step [81].

12.4.2. Schema Comparison/Matching

This step involves identifying and analyzing inter-schema relationships by determining the correspondences between the schemas. Possible conflicts are also detected in this phase.

12.4.3. Schema Conforming

In order to integrate schemas, the detected conflicts between them have to be resolved so that it was possible to merge them [81]. It implies modification of one or both schemas that will be integrated until each phenomenon in the Universe of the Discourse (UoD) reflects the same form in both schemas.

12.4.4. Schema Merging

Schema merging results into a single global integrated schema by superimposing the local schemas.

12.5. Conflicts in Schema Integration

Schema integration...

Find Another Essay On Schema Integration

Strategy formation and problem solving Essay

2569 words - 10 pages disagreement but by consensus and similarity - by the fact that decision makers share the same cognitive frames of reference and do not realise that they share these cognitive schema." Mabey et. al. (1998, p. 510).Mabey, et. al. (1998), present a dualist view of organisational decision making which, they claim can be described in diametrically opposed dimensions of pluralist, self-serving, politicking and unitarily, group-serving, cognitive schematics. In

A Glimpse into Different Aspects of Phonemic Restoration

2047 words - 8 pages settings. This paper explores - with illustrative demonstrations - four queries concerning different aspects of phonemic restoration: 1. Is phonemic restoration a conscious act? Are there any conditions for its activation? 2. What exactly takes place during the process of phonemic restoration? How is it best modeled? 3. Would visual/ auditory integration of a stimulus enhance phonemic restoration? 4. Does hearing impairment affect phonemic

When worlds collide: Marriage of Structured and Unstructured Data

923 words - 4 pages , Enterprise Application Integration, Business-to-Business Communication, e-Commerce, and a myriad of other applications. XML (extensible Markup Language) is becoming the new standard language for building Corporate Portals, integrating legacy databases, and facilitating B2C (Business to Customer) and B2B (Business to Business) data communication. The single most important factor in successfully using XML is meta data management: definition

Singapore's No Child Left Behind Quality Assurance Program

1119 words - 4 pages as the member institutions of the “no-child-left-behind” initiative. A common characteristic of the IT architecture of these institutions is the existence of applications in silos, which must be accounted for in proposing an data collection and assurance strategy. The incorporation of open standards in the proposed architecture and the definition of metadata to be collected will greatly aid the integration of information obtained from the

Building a Case for Database Migration

1536 words - 6 pages complete a migration project is primarily the time it takes to perform integration and test and is a small fraction of the time it would take without automation. c)     ROI on the migration project is a question companies have to deal with no matter what the reasons for the migration. But given the need for new hardware, software and the effort to migrate, all coming from different vendors, the ROI can be unclear. Look for a

The CCR and CCD contain some of the same standard rules

1126 words - 5 pages standard that is used for the exchange of clinical data (Health, 2009). The CCR format must adhere to a strict XML schema and accompanied by implementation guide required to support the standards compliant interoperability (E31.25, 2012). The XML scheme creates flexibility for the transmission and view of the CCR in many ways, such as in a web browser, Health Level 7(HL7) messaging, secured emails, PDF files, HTML files and word documents. This XML


1046 words - 4 pages . Normalisation is a process which cannot operate without the appropriate support from both the educational community and the wider community. This support exists within the integration and development of Policies, Principles, Legislations and Frameworks. Although, it is clear to say that in the modern day society such Policies, Principles, Legislations and Frameworks are readily available for developmental usage by educators, it has not always been this

Evolution of DBMS

1065 words - 4 pages model replaced the Flat file database system because it was more fast and simple but inflexible as the relationship was restricted to one-to-many. Network – 1970s - 1990s Network Database model is conceived as a more flexible model as compared to the Hierarchical model as it can have many-to-many relationship between the children and the parents. Its schema is viewed as a graph in which object types are nodes and the relationships are arcs

Prochaska Stages of Change

1264 words - 5 pages , this schema of change can set the stage for a truly holistic and integrative approach. As Prochaska so aptly states,Psychotherapy could be enhanced by the integration of the profoundinsights of psychoanalysis, the powerful techniques of behaviorism,the experiential methods of cognitive therapies, and theliberating philosophy of existentialism. Although somepsychotherapists insist that such theoretical integration isphilosophically impossible

Skills and Certification Design and Implementation Project

1992 words - 8 pages include empowered divisional managers with stake in project objectives SponsorSkill Librarian Funding High Approval is needed to fund a skill librarian. Determine responsibility and see if integration into existing role feasible. Steering Committee, Project ManagerAdditional Equipment Funding Low IT confident that existing hardware for database and web server can run application Project Manager, IT ManagerDevelopers Time Low Application

A Formalist Guide to Harry Potter and the Sorcerer’s Stone: Mikhail Bakhtin's Novel Form

3659 words - 15 pages . There would be no integration of magic into the changing world. Magic would stay the same throughout all of history and the characters would be okay with that. However, since the genre of the novel requires a setting in the present working towards the future, Rowling and the characters must take what they know about what magic was and transform it to fit within the schema of the novel so readers can still relate. With that being said, there are a

Similar Essays

Data Quality Essay

2366 words - 9 pages integrated it evokes some data quality issues. In heterogeneous source systems; data management systems, data models, schema designs and actual data are varied in nature. Each source may contain some data quality problems with different representations. These sources when combined may lead to several issues. Both schema-level and instance level problems can be observed in the integration phenomenon. Naming conflicts and structural conflicts are the

Eye Witness Testimony Essay

3209 words - 13 pages in which schemas might affect memory i. Selection and Storage - Inputs from the environment not contained within a current schema are likely to be ignored. ii. Abstraction - Schemas allow us to get the point if incoming material rather than precise details of it. iii. Interpretation and Integration - Schemas provide past knowledge to interpret current situations. This can help us with things not

The Power Of Media Framing Essay

3736 words - 15 pages , the most readily available attitude and/or knowledge which is also deemed applicable will be the basis for the decision, and will guide the processing of the information provided in the message (Price, Tewksbury, & Powers, 1997; Price & Tewksbury, 1997). Expanding on this, and a large body of additional work, Scheufele and Scheufele argue that frames are activating numerous attitudes and information stores. These are known as cognitive schema

Crm In Microsoft Essay

1522 words - 6 pages the product.4.2 CustomizationThere are several levels of customization possible in Microsoft CRM--forms, database schema, and business processes. In the UI, all forms, views, and previews can be modified to achieve the level of specialization required by the business. This level of customization can be superficial or require modifications to the database schema. Both types of customization are accomplished with the System Customization area in