Thursday, September 27, 2012

O/R Series Epilogue 2: Towards a not-so-simple explanation of Object Relational Database Management Systems

›
Object relational databases build on the relational model but focus on answering questions regarding information that is derived from other ...
Sunday, September 23, 2012

O/R Series Epilogue 1: 4 Things I Wish PostgreSQL did

›
In this area there are things I wish PostgreSQL did.  These are listed in order of priority.  Each item also has workarounds listed. Para...
1 comment:
Wednesday, September 19, 2012

Object/Relational modelling Part 7: General Design Considerations

›
The previous posts have hopefully opened up the way we look at modelling relational data, in a move from thinking about relations and tuples...
Sunday, September 16, 2012

O/R Modelling in part 6: Polymorphism (and Gotchas) in PostgreSQL

›
Polymorphism is common in virtually all database management systems.  When we add an integer to a float, we expect this to just work.  Simil...
Thursday, September 13, 2012

Object/Relational Interlude: Messaging in PostgreSQL

›
PostgreSQL as an object-relational development platform doesn't end with data modelling.  The notification system is particularly power...
3 comments:
Saturday, September 8, 2012

O/R modelling interlude: PostgreSQL vs MySQL

›
Every time we see people look at PostgreSQL and MySQL on the internet it falls into a flame war fast.  I think that a large part of the pr...
17 comments:
Wednesday, September 5, 2012

O/R Modelling part 5: Nested Data Structures, Do's and Don'ts

›
One of the promises of object-relational modelling is the ability to address information modelling on complex and nested data structures. ...
1 comment: