Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
Object Relation Mapping (ORM)

Another technical term? Yes - this one is a formal name for how you convert a database into Objects - applicable to any OO language (Perl, Python, PHP, Java ...)

Let's reduce it to basics.

* SQL Tables become object classes
* Table rows each become individual objects
* Individual columns become attributes.

OK - perhaps you've been doing it for years .... I know I have, though not so formalised. It's nice to have a buzzword now to impress people with! But there's more to it than that.

By writing code to formalise the conversion of data held in databases to objects, you can add a layer of abstraction and move the need to write SQL code within your application our to a separate module - very possibly a module that's already been written and placed on the CPAN or in the Cheeseshop or PEAR.

In Perl, there have been a number of ORM modules placed on the CPAN; the current "flavour of the month" is DBIx::Class. A year or two back, it was Class::DBI, which you'll still find in use on some legacy applications. Both DBIx::Class and Class::DBI rely on Tim Bunce's DBI module internally, so they can be used with the same wide variety of databases that DBI/DBD supports.




When you map a table onto a class, you'll note that your code repeats the definition of the column names in the Perl code (or Perl configuration file if you're being really good). But the programming axiom is "don't repeat anything" and if you're feeling REALLY clever, you can use DBIx::Class::Schema::Loader to pick it up from the database - as the cost of a little inefficiency in that the extra database enquiry is made every time you run your Perl. And THAT inefficiency can be prevented with dump_to_dir.
(written 2007-06-09 07:17:33)

 
Associated topics are indexed under
P308 - Using SQL Databases from Perl
Q907 - Object Orientation and General technical topics - Object Orientation: Design Techniques

Back to
Asda opening large new store in Melksham
Previous and next
or
Horse's mouth home
Forward to
Perl - functions for directory handling
Some other Articles
Some progress on the train campaign
Melksham businesses - networking together
Melksham Art Cafe
Perl - functions for directory handling
Object Relation Mapping (ORM)
Asda opening large new store in Melksham
Perl, the substitute operator s
Bathtubs and pecking birds
for loop - how it works (Perl, PHP, Java, C, etc)
Judging the quality of contributed Perl code
2259 posts, page by page
Link to page ... 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46 at 50 posts per page


This is a page archived from The Horse's Mouth at http://www.wellho.net/horse/ - the diary and writings of Graham Ellis. Every attempt was made to provide current information at the time the page was written, but things do move forward in our business - new software releases, price changes, new techniques. Please check back via our main site for current courses, prices, versions, etc - any mention of a price in "The Horse's Mouth" cannot be taken as an offer to supply at that price.

Link to Ezine home page (for reading).
Link to Blogging home page (to add comments).

© WELL HOUSE CONSULTANTS LTD., 2009: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 707126 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho