(Object-Relational Mapping) Converting data from tables in a relational database to objects and vice versa. Many applications employ object-oriented programming, but keep the data in traditional relational tables. The O-R mapping function can be accomplished with statements in the object-oriented programming language or via a third-party O-R mapping program.
For Complex Relationships
When an object model is very complex with a large number of many-to-many relationships, it takes time to store the data in relational tables. This "impedance mismatch" is resolved with the use of an object database, which is designed for complex object data. See object database and object-oriented programming.
Object Relational Mapping
There are three common types of O-R mapping from tables to objects and back again. A third-party O-R mapping program eliminates much of the tedium of writing this conversion code. (Illustration courtesy of the Real Time Division of Progress Software, www.progress.com/realtime)
For Complex Relationships
When an object model is very complex with a large number of many-to-many relationships, it takes time to store the data in relational tables. This "impedance mismatch" is resolved with the use of an object database, which is designed for complex object data. See object database and object-oriented programming.
Object Relational Mapping
There are three common types of O-R mapping from tables to objects and back again. A third-party O-R mapping program eliminates much of the tedium of writing this conversion code. (Illustration courtesy of the Real Time Division of Progress Software, www.progress.com/realtime)
 | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2009 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- Apple acquires map purveyor Placebase
- MacRumors discovered that Apple quietly acquired mapping service Placebase back in July. Placebase CEO Jaron Waldman's updated LinkedIn profile now lists him on the "Geo Team" at Apple. So what's Apple's interest in a mapping company? The obvious guess would be as a replacement for the Google...
- Blog posts 2009-10-01
- Apple files patents on haptic feedback, biometrics and RFID detection
- A patent application filed by Apple in February 2008 for multi-touch display screen with localized tactile feedback indicates that the company is researching haptic feedback for possible inclusion in the iPhone and iPod touch. Most telling is a line in the application about the competitive advantages of...
- Blog posts 2009-07-02
- Google Wave: Surfing the future of collaboration
- Google is a remarkable company. Need proof? Just consider how reliant we are on Google Maps to find our way around the world. That didn't happen by accident. It happened because Google empowered a couple of brothers, Lars and Jens Rasmussen, to open up the developer APIs to the mapping...
- Blog posts 2009-05-29
- TomTom One 140 S portable navigation device
- The TomTom One 140 S builds on TomTom's successful One series of entry-level portable navigation devices PNDs, with the addition of features that were once the hallmarks of TomTom's top-of-the-line models. The diminutive PND gains advanced lane guidance, which details complex freeway interchanges for easier navigation, as well as downloadable...
- Product reviews 2009-05-12
- Windows 7 build 7057 - Performance that blasts past XP, Vista and previous builds
- Windows 7 build 7057 - Performance that blasts past XP, Vista and previous buildsWill you be able to post the actual times?Just wondering.a lot of work, but...where's the beef.Many people don't care about windoze anymore.The real test can be only against Linux and OSX.You must care linux geekAs your here...
- Discussion threads 2009-03-16
- What do you want from the next iPhone?
- What do you want from the next iPhone?iPhoneIt's obvious what all of us iPhone owners want, which if the firmware 3.0 comes for the new hardware they should be bright enough to know what we want.. MMS, iChat, Video Recording without Jailbreak, Copy and Paste.. Loaded QuestionI have a first...
- Discussion threads 2009-01-29
- Obama likely to name outsider to head NASA
- Obama likely to name outsider to head NASAHas nothing to do with itObama is all for education and raising America's standing in the world, two corner stones of his campaign. He also wants NASA to operate more efficiently. He is not out to kill education and stifling scientific power. NASA...
- Discussion threads 2009-01-15
- Should our President be computer literate?
- Should our President be computer literate?The man with the BlackBerry gets my voteAlthough I fundamentally agree with you that being the leader of the free world is a bit more important that being able to check email and certainly requires a much broader range of qualifications, I have to say...
- Discussion threads 2008-09-29
- Neocleus secure access
- Neocleus secure accessNeocleus is not secureNeocleus security architecture is flawed at its basic level. The architecture uses a software mechanism to provide direct physical device assignment to virtual machines, such as graphics cards and wireless networks. It does not support hardware based direct I/O assignment or hardware based...
- Discussion threads 2008-09-25
- TechCrunch50: Day 3
- Photo by Steve Maller I've been covering TC50 for the past few days, and believe it or not, I'm still hungry for more startup pitches. 6:30 a.m. The final sessions of the conference are posted on BusinessWire: s Akoha...
- Blog posts 2008-09-10
- TechCrunch50: Day 2
- Yesterday's presentations were a lot of fun to cover. I'm getting right back into the grind today. 6:30 a.m. Here is a list of today's presentations: Alfabetic Presented by Oded Broshi and Arik Kopelman DropBox (Presented by Drew Houston...
- Blog posts 2008-09-09
- Apple releases Mac OS 10.5.3; includes Google contact sync (updated)
- Apple today released Mac OS 10.5.3 via Software Update advisory. The 10.5.3 Combo Update weighs in at 536MB while the regular 10.5.3 Update is 420MB. The 10.5.3 Update is recommended for all users running Mac OS X Leopard and includes general operating system fixes that enhance the...
- Blog posts 2008-05-28
- News to know: Microhoo; Adobe; MacBook Air; OLPC; RIAA
- Notable headlines: Microsoft: We'll raise our bid for Yahoo, but can't make up our mind yet. Techmeme Jason O'Grady: Excess thermal paste causing high temps in MacBook Air Ryan Stewart: Adobe Open Screen Project Dan Farber: IBM...
- Blog posts 2008-05-01
- News to know: AOL, Linux; Mac clones; Mobile Web
- Notable headlines: Ed Bott: Making sense of Windows' irrational pricing and licensing Robin Harris: 2.5" disks to become new standard in 2009 TechRepublic: 10 common mistakes to avoid when you're installing Linux software Christopher Dawson: My kid hates...
- Blog posts 2008-04-15
- Troubleshooting Skype performance on a Mac (updated)
- Any ace Skype troubleshooters out there? I've been using the venerable VOIP client on my MacBook Pro almost since it came out without many issues â€" until recently. I've used Skype almost weekly to record 70 episodes of the PowerPage Podcast with good results but in the...
- Blog posts 2008-03-14
- News to know: Microsoft's Hyper-V and reorg; NetSuite; Cisco patches; MacBook Air diary
- Notable headlines: Mary Jo Foley: Review: Microsoft’s Hyper-V puts VMWare and Linux on notice Dana Gardner: Merger target suspect Citrix assembles virtualization products as Delivery Center Dan Kusnetzky: Why is the concept of virtual machine software so sticky? Former Microsoft...
- Blog posts 2008-02-15
- ARM Android prototype (Photos: Android prototype, Sony Erickson takes on iPhone)
- ARM Android prototype (Photos: Android prototype, Sony Erickson takes on iPhone)Looks more like a Blackberry too me....Now don't get me wrong I think the iPhone is an amazing piece of work. I'm a fan but still is EVERY single new phone made after the iPhone going to be asked...
- Discussion threads 2008-02-12
- Why+Microhoo%3A+To+stop+the+Google+machine
- Why+Microhoo%3A+To+stop+the+Google+machineYang will NOT want to work under MS. He WILL take the money and run thoughas Google is eating their lunch, and MS has billions to throw at anything and everything. Time to exit the stage with a suitcase full of cash. My bet is that Yang ends up at...
- Discussion threads 2008-02-01
- Why Microsoft hates Google's Android
- Why Microsoft hates Google's AndroidWho hates Android? (Not me.)Indeed, JavaME already is highly fragmented, so what does Monson-Haefel want to protect? I really wonder what the purpose of his posting is. Strengthen Java? Strengthen Microsoft? Create FUD around Android? Why?As we have seen with Eclipse, competition and open source are...
- Discussion threads 2007-11-29
- Are all 'open' Web platforms created equal?
- There's been a lot of talk lately about various Web platform vendors opening up their programming interfaces in order to make their offerings more readily customizable and programmable. Facebook has opened up its social-networking platform to developers. Google is poised to open its Orkut social-networking application programming...
- Blog posts 2007-10-16
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- The best support in the Linux business
-
If Linux is going to power your mission-critical applications, you'd better have the best support known to business. Novell was rated the top provider of Linux technical support.
- Learn more >>
- Learn more about tools to grow your business
-
The Business Essentials Guide provides you useful tools and templates to help grow your business and save you time with automated shipping solutions.
- Save time with the UPS Business Essentials Guide
- Keep Up With The Latest In Document Management with The DocuMentor.
-
Doc delivers the scoop on today's enterprise content management, printer maintenance, and all other issues related to document management. It's the DocuMentor Blog.
- Learn more >>
- New Online Dashboard for IT Leaders
-
Read about top issues IT decision-makers face every day, plus get cost-effective solutions to real-life IT problems.
- Learn more >>
- Microsoft Dynamics CRM Online - Free Six-Month Trial for Eligible Organizations
-
Microsoft Dynamics CRM Online provides fast online access, simple contact management and better sales performance for a low monthly cost - the best value on the market today.
- Learn more about the free, six-month trial offer>>
Enterprise Applications
- Check out some of the easiest and most powerful ways to boost productivity while saving money on your application infrastructure. See ZDNet's comprehensive Enterprise Application resource center, now!
- New Online Dashboard
-
- Read about top issues IT decision-makers face every day, plus get cost effective solutions to real life IT problems. Oracle Topline
-
