SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 05:00 AM
| ||||
| ||||
 TYPES, HEIRARCHIES etc 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      |
|
02-27-2008, 05:00 AM
| ||||
| ||||
| Re: TYPES, HEIRARCHIES etc 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 |
Linear Mode
