As well as joining Oracle Corp’s Warehouse Technology Initiative (CI No 2,695), Prism Solutions Inc, Sunnyvale, California, has added Changed Data Capture and Warehouse Update modules to its software line-up. The Changed Data system captures only the changed data in Oracle tables used as source files for a warehouse, which Prism says means users don’t have to pass their entire legacy files through its Warehouse Manager’s generated Cobol programs. The time-stamped meta data can be exported to Prism’s Directory Manager for integration into the information directory. The company said the module can also be used to create what it’s calling operational stores of data that are 30 to 60 days old and can be used alongside the full-blown warehouse containing snapshots of historical data, usually spanning several years. Warehouse Update enables users to apply changes in rows in an Oracle data warehouse. The Warehouse Manager generates a Cobol program with embedded SQL manipulation language to replace or insert rows in a data warehouse. Meantime the Prism Directory Manager can now build a direc tory of meta data incorporating models imported and converted from Oracle CASE and technical meta data from Warehouse Manager. Data Capture and Warehouse Update are $25,000 options for Warehouse Manager for use with Oracle data warehouse and are available in September. Directory Manager costs $35,000 for the repository engine and $500 per user for an Oracle server. The software is due to be released next month.
