Using existing relational schema

This section shows one way to use an existing relational schema to create an object schema. Key points are:

bulletWays to use type codes and relational views to get ideas about the object class hierarchy.
bulletA step-by-step example of converting a relational schema to an object schema and checking to ensure no information is lost in the process.
bulletAdding method code that was not in the relational schema to the object schema.

To view the steps for this technique in order, just follow the Next link that appears below and on each of the pages in this section. You can also skip around by using the menu choices that appear at the bottom of each page.

You may notice that the notation is somewhat different from current UML diagramming. These diagrams were created prior to the latest UML diagramming conventions. Nevertheless, the meaning in the diagrams should be obvious.

For more information on this technique, see The Object Database Handbook (new window), which is the source of these diagrams. 

Next: Type codes. Also see the related content below.

Related content for: Using existing relational schema

More detail for the current topic: Using existing relational schema
Type codes
Using type codes to construct classes
Multi-type views
Checking the class hierarchy
Adding method code
Using the data

More on the general topic: Object-relational mapping articles
Object-relational mapping (OR mapping) definition
When object-relational mapping should be used
Basic concepts for using object-relational mapping
Mapping layer
Writing your own mapping layer
Article suggestions

Read more free articles on this site

There are nearly 400 pages of articles on this site with over 50 pages on object-relational mapping.

Search this site for more articles

Custom Search

Browse this site for more articles

Click on the topics below to browse the articles on this site.The arrows show the path to the current article: Using existing relational schema.

Web Services and Service-Oriented Architectures
Online briefings
Search results
Online articles -->
Consulting
Mentoring
Speaking
Stencils for the Savvy Manager's Guide
Links
Mail list
Privacy policy
Sitemap
Contact
Web Services articles
XML standards and vocabularies
Application server articles
Database concepts and standards
Object database articles
Relational database articles
Object-relational mapping articles -->
XML database articles
XML middleware articles
Article Sponsorship
Reprint policy
Object-relational mapping (OR mapping) definition
When object-relational mapping should be used
Basic concepts for using object-relational mapping
Mapping layer
Writing your own mapping layer
Using existing relational schema
Article suggestions

Related recent articles from Google News


Database Technology for the Web: Part 1 ? The MapReduce Debate
B-EYE-Network
Relational database products have survived similar battles with object-oriented database technology and multidimensional database systems. ...

and more »

EnterpriseDB Pushes Performance, Oracle Compatibility with Updated ...
eWeek
EnterpriseDB releases Version 8.3 Release 2 of its database. EnterpriseDB's Postgres Plus Advanced Server 8.3 R2 includes new features meant to deepen ...
EnterpriseDB Bidding For Customers With Oracle CompatibilityInformationWeek
EnterpriseDB Smooths Way for Oracle App MigrationLinuxInsider.com

all 34 news articles »

OMB posts financial reporting guidance for Recovery Act funds
GCN.com
Extracting the data from a relational database and inserting it into an XML document would also be easily possible, by a similar mapping process, ...

and more »

Cloud Computing Expo: Network-Centric Computing Model
Ulitzer.com
From a practical perspective, it is important to recognize that a distributed relational database capability can now be implemented on multiple computing ...

and more »

Ted Slater's Semantic Technologies
Bio-IT World
... than implicit in a relational database schema, PEKE supports knowledge bases containing any kind of knowledge with no changes to the architecture. ...

and more »

More related news: relational database schema - Google News

Related books at Amazon.com


Database Design for Mere Mortals(R): A Hands-On Guide to Relational Database Design (2nd Edition)
by Michael J. Hernandez
Average Customer Review: 4 stars based on 123 reviews.
Customer Review: This book was just the text I was looking for as a n00b data base designer looking to build a data base for a pet project of mine. I'm a forester and forest planner, not a computer specialist. Thus, I needed instruction from the ground up, and this book fit the bill. Some specific praise: First, the book bridged the gap between adm...

Pro SQL Server 2008 Relational Database Design and Implementation
by Louis Davidson, Kevin Kline, Scott Klein, Kurt Windisch
Average Customer Review: 4 stars based on 7 reviews.
Customer Review: Good database design is extremely important if you want to have a database that performs well and is easily modifiable. How many times did you have to go back and change countless lines of code because your database was not normalized and it was not easy to add another payment type to the existing database? This is where Pro SQL Serv...

Inside Relational Databases with Examples in Access
by Mark Whitehorn, Bill Marklyn
Average Customer Review: 4.5 stars based on 35 reviews.
Customer Review: The authors of this book don't avoid the more difficult concepts in understanding relational databases but they do a great job of explaining things in simple English. This is a good book for anyone who finds themselves having to work with relational databases but haven't understood why they're built the way they are. I've never read...

Information Modeling and Relational Databases, Second Edition (The Morgan Kaufmann Series in Data Management Systems)
by Terry Halpin, Tony Morgan
Average Customer Review: 5 stars based on 5 reviews.
Customer Review: Everyone needs this book. Read more to find out why: If you intend to create genuinely useful business applications without first creating an accurate conceptual data model and deriving the database schema from the model, then I hope your projects have very large budgets and flexible deadlines, because you'll need both. Accurate conc...

Database in Depth: Relational Theory for Practitioners
by C.J. Date
Average Customer Review: 4 stars based on 19 reviews.
Customer Review: When I was early in my Computer Science degree I took a course in which we discussed database fundamentals. In that class we learned about things like tuples, relations, predicates, predicate logic and deductive proofs. All of these were involved with the relational model, but it wasn't until later when I discovered the writings of ...

More related books: Search Amazon.com for relational database

 

Copyright © 2000-2009 Barry & Associates, Inc. All Rights Reserved.
You can use this material for your work or classes. Click here for our reprint policy.
www.service-architecture.com

 

 

Newletter Sign Up

 

 

Barry & Associates, Inc.