Practical Object-Oriented Models in SQL
http://www.slideshare.net/billkarwin/practical-object-oriented-models-in-sql,
Practical Object-Oriented Models in SQL Presentation [PDF]
SQL is from Mars, Objects are from Venus.
This talk is for software developers who know SQL but are stuck trying to implement common object-oriented structures in an SQL database.
- Polymorphism: Suppose your blog supports comments, but then your comments need to reference multiple types of content, for example news, blog articles, and videos. What then?
- Extensibility: We’ve all designed customizable software, allowing customers to extend a data model with new data attributes. See how to design flexible systems, while using efficient SQL queries.
- Hierarchies: Tree-structured data relationships are common, but working with trees in SQL usually implies recursive queries. There are a few solutions to solve this more cleanly.
- ActiveRecord Dos and Dont’s: Web development frameworks have popularized the use of design patterns, but when it comes to multi-table queries, complex views, and assignment of OO responsibilities, ActiveRecord falls short as a one-size-fits-all Domain Model.
Bill Karwin
Karwin Software Solutions
Bill Karwin has been a software developer and technical writer since 1988. He is widely known for his talent for explaining complex topics and practical techniques with accuracy and a little humor. Recently he worked as the Product Engineering Manager developing the award-winning Zend Framework library for PHP 5.
Comments on this page are now closed.
Sponsorship Opportunities
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com
Download the OSCON Sponsor/Exhibitor Prospectus
Media Partner Opportunities
Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com
Press and Media
For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com
OSCON Newsletter
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the OSCON newsletter (login required)
Contact Us
View a complete list of OSCON contacts
O'Reilly Home | Privacy Policy | Contact Us | Sitemap | conf-webmaster@oreilly.com
Event Software Powered by Expectnation
© 2009, O'Reilly Media, Inc. | (707) 827-7000 / (800) 998-9938
Comments
Excellent! Another high quality presentation. Great content on DB pattern. Very well organized. Great use of examples and diagrams.