This wiki has undergone a migration to Confluence found Here
Database with native ISO datatypes
Revision as of 20:35, 16 January 2009 by Rene spronk (talk | contribs) (New page: category:RIMBAA Issue ==Summary== The ISO (or: Datatypes R2) data types can be implemented as 'native datatypes' at the database level. This may be an attractive option for RIMBAA...)
Summary
The ISO (or: Datatypes R2) data types can be implemented as 'native datatypes' at the database level. This may be an attractive option for RIMBAA applications.
Discussion
- It would be great to have an Ad Hoc query and don't bother with the details of e.g. a PQ.
- Grahame tried to implement UDT's in SQL-Server, but he did not like it because
- no support for inheritence/substituability
- the data is stored serialized as strings.
- very difficult to address nested content (lists/sets)
- Performance is an issue.
- There might be a problem with current ORM implementations witch cannot currently handle UDT's.