Title: Create abstract layer over RDBMS system catalog
Version: $Revision: 1.00$
Authors: Alfred Werner <alfred hat thunderstick dawt com>
Created: Friday, 27 February 2004
Discussions To: http://openacs.org/forums/message-post?forum_id=115570
The OpenACS kernel provides a mechanism for storing extended attributes of system objects. Specifically, acs_attributes* and acs_datatypes are intended to map into the physical storage layer of the underlying RDBMS. Currently there is no mechanism for interrogating the underlying system catalog to run audits to compare coverage of the OpenACS catalog against the underlying RDBMS catalog. Providing this abstraction will make the 'data soup' effort much easier and consistent.
I would like to create three specific VIEWS and add them to the OpenACS kernel. acs_tables, acs_views, and acs_constraints. I don't think indexes are necessary from a 'logical design' perspective. Omitting it would be in keeping with current practice. A large portion of the work already exists thanks to the schema-browser package.
Not in Scope
There are additional items in both the Oracle and Postgres catalogs - including data type definitions and other items that probably should be considered in the future where equivalencies exist.