Re: Materialized attributes

From: Frank Hamersley <terabitemightbe_at_bigpond.com>
Date: Tue, 11 Apr 2006 22:58:02 GMT
Message-ID: <_vW_f.4596$vy1.3389@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 Tue Apr 11 2006 - 17:58:02 CDT