How to access data in a relational database

This section contains examples of how to access data in a relational database using object-relational mapping with transparent persistence. The examples show the code needed to perform the operations illustrated by the animation of transparent persistence (new window).

The code opens a database, starts a transaction, executes a query to find a Person object named "Doug Barry," does some further processing on that object, traverses to an Address object, updates the street of the Address object, commits the transaction, and closes the database. Also see transparent persistence vs. JDBC call-level interface (new window).

Examples of relational database access using transparent persistence can be found using the following links:

bulletJava and object-relational mapping
bulletJDO and object-relational mapping
bulletC++ and object-relational mapping

For how to use object-relational mapping with Java application servers, see enterprise architectures using Java application servers (new window).

 

Web Services and Service-Oriented Architectures
Online articles>
Consulting
Mentoring
Speaking
Suggested programs
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
Mapping layer
Writing your own mapping layer
Using existing relational schema
Article suggestions
Transparent persistence in object-relational mapping
Transparent persistence vs. JDBC call-level interfaces
How to access data in a relational database>
Navigation with object-relational mapping
Java and object-relational mapping
JDO and object-relational mapping
C++ and object-relational mapping

Related recent articles from Google News


Which EII Solution Is Right for You?
Web Services Journal, NJ - 15 hours ago
This model serves as the schema of the virtual database. The types of logical models include relational, object, and XML. Depending on the approach, ...

LinuxDevices.com

Embedded Linux SQL database adds Java, C# bindings
LinuxDevices.com - May 7, 2008
ITTIA has released a new version of its lightweight SQL R-DBMS (relational database management system) for embedded systems and mobile devices. ...

RETINOBASE: a web database, data mining and analysis platform for ...
7thSpace Interactive (press release), NY - May 5, 2008
In this context we have built RETINOBASE, a dedicated microarray database for retina.DescriptionRETINOBASE is a microarray relational database, analysis and ...

Hospital Reg/ADT Application Senior Developer.
Seattle Times, United States - May 5, 2008
?Minimum two years experience in application development using relational database technologies in a UNIX or LINUX-based client server environment. ...

HIP2: An Online Database of Human Plasma Proteins from Healthy ...
7thSpace Interactive (press release), NY - Apr 25, 2008
... and has protein data captured in a relational database schema built to contain mappings of supporting peptide evidence from several high-quality and ...

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) (For Mere Mortals)
by Michael J. Hernandez
Average Customer Review: 4 stars based on 123 reviews.
Customer Review: This is an excellent book for the average person who wants to know more about database design. The author has an excellent way of explaining the not so obvious and bringing it down to layman's terms. Great learning tool.

Database in Depth: Relational Theory for Practitioners
by C.J. Date
Average Customer Review: 4 stars based on 18 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 ...

Information Modeling and Relational Databases, Second Edition (Morgan Kaufman Series in Data Management Systems)
by Terry Halpin, Tony Morgan
Average Customer Review: 5 stars based on 2 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...

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...

Logic and Databases: The Roots of Relational Theory
by C. J. Date
Publisher: Trafford Publishing
Publication Date: June 2007

More related books: Search Amazon.com for relational database

 

Copyright © 2000-2008 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

 

 Information on becoming a sponsor

 

 

Google

 

Barry & Associates, Inc.