IDS Forum

Re: Collection - Denormalization

Posted By: Cesar Inacio Martins
Date: Sunday, 4 April 2010, at 11:34 a.m.

In Response To: Re: Collection - Denormalization (Adam Tauno Williams)

Hi Adam,

Nice to know. Is exactly this information what I looking for... difficulties where discourage developers to use this resource.

You tried working with functional indexes before abandoned this resource?
Can you tell for what kind of data you use it? For relationship or just a real collection data.
Do your remember the table definition of what collection data type used?
What program language you use?

César

--- Em dom, 4/4/10, Adam Tauno Williams <adam@morrison-ind.com> escreveu:

De: Adam Tauno Williams <adam@morrison-ind.com>
Assunto: Re: Collection - Denormalization [19500]
Para: ids@iiug.org
Data: Domingo, 4 de Abril de 2010, 12:17

On Sun, 2010-04-04 at 09:35 -0400, Cesar Inacio Martins wrote:
> Hi Frank,
> There a several ways to use Collections Data tyte, isn't all no ordinal
> position (LIST) and when use together with ROW datatypes your have something
> like as subtables. But to use it, depends what the situation required.
> I know some issues what you can have using Collection data types (already
> cited in last posts) , but maybe you can have some gain in other hand what
> recompense they use... mainly , performance....
> Is this what I looking for, someone what implements in a production
> environment this and did a big difference for the system performance. If
> someone did this, how they implements and how much of gain they have versus
> the difficult to implement the code and administer the table / indexes.

I use collection data types as return results from SPLs. They work very
well in that case if your computed result is complex. Prior to 11.0
however heavily using collection types would eventually result in SPLs
failing with -9628 errors. That bug was fixed in 11.0UCsomething(?).

I've used collection types in schema before - never noticed any
performance issues - but the collections didn't contain key values.
However I abandoned them because client support is essentially
non-existant. As a replacement we just store XML as values in some
tables; every client platform and toolset can process XML.

> I don't pretend implement this now, just looking for examples and who
already
> do that.
> Maybe I try create a test environment to try discovery if is possible to
gain
> performance implementing this... and how hard is administrate tables with
this
> kind data types (variable row sizing, update statistics, indexes, sorts,
etc)

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

____________________________________________________________________________________
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com

Messages In This Thread

• Collection - Denormalization
  Cesar Inacio Martins -- Saturday, 3 April 2010, at 6:43 p.m.
  • Re: Collection - Denormalization
    FRANK COMPUTER -- Saturday, 3 April 2010, at 7:22 p.m.
    • Re: Collection - Denormalization
      Cesar Inacio Martins -- Saturday, 3 April 2010, at 8:54 p.m.
      • Re: Collection - Denormalization
        FRANK COMPUTER -- Saturday, 3 April 2010, at 9:24 p.m.
        • Re: Collection - Denormalization
          Cesar Inacio Martins -- Sunday, 4 April 2010, at 12:00 a.m.
  • Re: Collection - Denormalization
    Obnoxio The Clown -- Saturday, 3 April 2010, at 7:25 p.m.
    • Re: Collection - Denormalization
      Cesar Inacio Martins -- Saturday, 3 April 2010, at 9:01 p.m.
      • Re: Collection - Denormalization
        FRANK COMPUTER -- Sunday, 4 April 2010, at 1:44 a.m.
        • Re: Collection - Denormalization
          Cesar Inacio Martins -- Sunday, 4 April 2010, at 9:35 a.m.
          • Re: Collection - Denormalization
            Adam Tauno Williams -- Sunday, 4 April 2010, at 11:17 a.m.
            • Re: Collection - Denormalization
              Cesar Inacio Martins -- Sunday, 4 April 2010, at 11:34 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.