By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

TYPES, HEIRARCHIES etc

P: n/a
Dear Guru's

Can anyone please direct me to articles, documents or indeed help
explain in 'english' the benefits and advantages of using TYPEs,
HEIRARCHYs, TYPE TABLEs and METHODs ?

I've tried reading all I can on the topic but I simply end up wondering
WHY ?

Many thanks, Tim

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
p175 wrote:
Dear Guru's

Can anyone please direct me to articles, documents or indeed help
explain in 'english' the benefits and advantages of using TYPEs,
HEIRARCHYs, TYPE TABLEs and METHODs ?

I've tried reading all I can on the topic but I simply end up wondering
WHY ?

Many thanks, Tim

User defined DISTINCT types are essentially type defs. There benefit is
that you can change the basetypes without having to hunt down all the
usages. (imaginge changing an employee id from smallint to integer
through the DBMS and app).

User defined structured types are a different matter, and so is
everything attached to it.
What you have here is a different (OO) way of thinking.
But one thing is for sure. Structured types and what is associated to
them are tough on an RDBMS.
I would NOT use them for a vanilla app.
My guess is that XMLTYPE and XQUERY replace most of the OO features of
ORDMS.

I developed typed views and was involved with structured data types. So
I'm not an anti-oo person. I just believe that was some sort of IT
fashion to bring those into RDBMS with little if any return on
investment. Ues OO in Java, C#, take your pick. But stick with
relational in the database.

Just my two cents canadian looking into the rearview mirro.
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.