Abstract
A database system consists of three components: schemas, data, and programs. Database reengineering starts with the schema, which defines the meaning of data and their relationship in different models. Only after a schema has been redefined can data and programs be reengineered into a new database system, which makes use of the translated schema. Schema translation is the process of changing a schema expressed in one data model into an equivalent schema expressed in a different data model.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Booch G (1994) Object-oriented analysis design with application. Benjamin Cummings, San Francisco, p 15
Elmasri R, Navathe S (1989) Fundamentals of database systems. Benjamin Cummings, San Francisco
Fong J (1992) Methodology for schema translation from hierarchical or network into relational. Inf Softw Technol 34(3):159–174
Fong J, Cheung SK (2005) Translating relational schema into XML schema definition with data semantic preservation and XSD Graph. Inf Softw Technol 47(7):437–462
Fong J, Kwan I (1994) An re-engineering approach for object-oriented database design. Proceedings of First IFIP/SQI International Conference on Software Quality and Productivity (ICSQP’94). Chapman and Hall, 5–7, pp 139–147
Funderburk JE, Kierman G, Shanmugasundaram J, Shekita E, Wei C (2002) XTABLES: Bridging Relational technology and XML. IBM Syst J 41(4):616–641
Navathe S, Awong A (1988) Abstracting relational and hierarchical data with a semantic data model. Entity-relationship Approach, pp 305–333
Quizon A (1990) End-user computing in multi-environment systems. Proceedings of South-East Asia Regional Computer Confederation Conference on Information Technology, pp 602–617
Zaniolo C (1979) Design of relational views over network schemas. Proceedings of ACM SIGMOD 79 Conference, pp 179–190
Author information
Authors and Affiliations
Corresponding author
Questions
Questions
Question 3.1
Translate the following network database schema to network database DDL.
Question 3.2
Translate the following hierarchical database schema into network database DDL and also into a relational schema.
Question 3.3
How can one compare the abstract level of the EER model and UML, and the features of a relational database and object-oriented database?
Question 3.4
-
a.
Show the steps needed in designing an entity-relationship model. What are the steps of mapping an EER model into a relational model?
-
b.
Consider a case study with the following business requirements and relational database:
-
A company has two regions, A and B.
-
Each region forms its own departments.
-
Each department approves many trips in a year.
-
Each staff makes many trips in a year.
-
In each trip, a staff needs to hire cars for transportation.
-
Each hired car can carry many staff for each trip.
-
A staff can be either a manager or an engineer.
-
The data requirements are:
Data field | Description |
---|---|
Department_id | The identity number of department |
Salary | The salary of department staff |
Classification | The classification of regional office |
Trip_id | The identity of each business trip by department staff |
Car_model | The model of the car rented by staff during the business trip |
Staff_id | The identity number of department staff |
Name | The name of the staff who rents the car during business trip |
DOB | Date of birth of department staff |
Size | The size of the car rented by department staff for business trip |
Description | Description of the car rented by department staff on business trip |
Title | The job title of department staff on business trip |
Based on the user and data requirement, design an EER model to meet these requirements.
Question 3.5
-
(a) What are the steps of mapping Unified Modeling Language into an object-oriented schema?
-
(b) Map the following Unified Modeling Language into an object-oriented schema:
-
(c)
Question 3.6
What is DTD-graph? How can one compare a DTD-graph with EER model?
Question 3.7
Show the steps of translating the following DTD-graph into DTD?
Question 3.8
Translate the following relational schema into an XSD such that the selected XML view is called “Factory” and the relevant relations under the root are relation Category and the other navigable relations.
Relational Schemas:
where underlined words are primary key and words with “*” prefixes are foreign keys.
Rights and permissions
Copyright information
© 2015 Springer International Publishing Switzerland
About this chapter
Cite this chapter
Fong, J. (2015). Schema Translation. In: Information Systems Reengineering, Integration and Normalization. Springer, Cham. https://doi.org/10.1007/978-3-319-12295-3_3
Download citation
DOI: https://doi.org/10.1007/978-3-319-12295-3_3
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-12294-6
Online ISBN: 978-3-319-12295-3
eBook Packages: Computer ScienceComputer Science (R0)