This week's book giveaway is in the Artificial Intelligence and Machine Learning forum.
We're giving away four copies of TensorFlow 2.0 in Action and have Thushan Ganegedara on-line!
See this thread for details.
Win a copy of TensorFlow 2.0 in Action this week in the Artificial Intelligence and Machine Learning forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Paul Clapham
  • Bear Bibeault
  • Jeanne Boyarsky
Sheriffs:
  • Ron McLeod
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Jj Roberts
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • salvin francis
  • Scott Selikoff
  • fred rosenberger

Design Patterns & Mapping

 
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm transferring to a new group that does not have an established code library for the data mapping/persistence layers. I'll have to look at third party persistence products like TopLink or, preferably, design a reusable mapping component.
What are some good patterns for to look at for mapping? The system I use today uses a broker to match broker classes to domain classes. All SQL is contained in the broker classes in the mapping layer. GOF does not cover the broker pattern. Any suggestions on a good source on the broker pattern?
What other patterns or design books might be good to look at for designing a mapping component?
http://www.byteworksinc.com

[This message has been edited by Steve Mitchell (edited October 02, 2001).]
 
tumbleweed
Posts: 5089
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Steve I cant help you but I love your site
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have found Information Systems Architecture patterns in martin fowler's website at www.matinfowler.com to be very useful also an article titled "Connecting Business Objects to Relational Databases" by Joseph W. Yoder et al is very good...
 
Steve Mitchell
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That is just what I was looking for! Thanks.

Originally posted by Santanu Barua:
I have found Information Systems Architecture patterns in martin fowler's website at www.martinfowler.com to be very useful also an article titled "Connecting Business Objects to Relational Databases" by Joseph W. Yoder et al is very good...


 
Ranch Hand
Posts: 782
Python Chrome Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You might also want to check out JDO (Java Data Objects),
a transparent persistence framework between Java objects and relational data.
See http://jcp.org/jsr/detail/12.jsp
 
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Kyle Brown has written a paper on the subject of mapping Objects to RDBMS's. He has expressed his views in a pattern language he calls Crossing Chasms. Check it out at http://members.aol.com/kgb1001001/Chasms.htm
 
author
Posts: 3892
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Originally posted by Iain Lowe:
Kyle Brown has written a paper on the subject of mapping Objects to RDBMS's. He has expressed his views in a pattern language he calls Crossing Chasms. Check it out at http://members.aol.com/kgb1001001/Chasms.htm


Thanks for the reference. My pattern language can also be reached through Martin Fowler's ISA patterns, also referenced above. I've been working closely with Martin on his ISA patterns, and I'm not ashamed to say that they're better written than my own. Mine are a bit more complete at the moment, but Martin is quickly moving to change that!

------------------
Kyle Brown,
Author of Enterprise Java (tm) Programming with IBM Websphere
 
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A high level approach I take when doing data mapping is to have a set of objects that acts as an intermediary between my in memory objects and my non-OO data. THis way, the rest of my system thinks it is dealing with an OO database, even though it is not. These layering objects are factories on one hand, creating objects from the database and updaters (for want of a better word) that move objects I need persisted into the rdbms. These layers aren't all that hard and are easy to maintain. It also allows me to write query objects that can work directly on the RDBMS. Relational databases have some really strong advantages if you don't need to worry about differences of the objects. For example, some applications I've worked on have had to worry about different nationalities. In my code, I'd use polymorphism to hide differences in tax rules, ... However, my databases typically could be easily split up so only data from one country was in any one data base. This allows for quick queries and extractions to be done in the RDBMS itself.
------------------
Alan Shalloway,
Look for Jim Trott and my book: Design Patterns Explained
Visit our site Net Objectives.
Visit our on-line companion to the book
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic