Re: Materialized attributes
Date: Tue, 11 Apr 2006 22:58:02 GMT
Message-ID: <_vW_f.4596$vy1.3389_at_news-server.bigpond.net.au>
dawn wrote:
> Has anything been written about or are there any SQL-DBMS or other DBMS
> tools that address data modeling with materialized virtual attributes
> (not materialized views)? I've found some materials that relate to
> performance and optimization of various materialized derived data, but
> it seems to all be related to entire views of derived data, rather than
> individual attributes. I'm interested in data modeling (design) that
> associates derived data with a base table, for example.
FWICR Sybase ASE 15.0 provides this exact feature. Personally I haven't been close to using it and as such have not investigated its potential uses or abuses.
> This might be mentioned in BI information related to cubes since such
> data would only be written by the dbms (or perhaps coded using
> triggers) and would otherwise be read-only and because cube products
> often permit the specification of stored aggregate data. I'm not
> interested in anything related to a separate BI system (data mart,
> warehouse), however.
Cheers, Frank. Received on Wed Apr 12 2006 - 00:58:02 CEST