Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: the distinction between data and intelligence

Re: the distinction between data and intelligence

From: DM Unseen <dm_unseen_at_hotmail.com>
Date: 13 Jun 2005 01:11:52 -0700
Message-ID: <1118650312.921850.37060@f14g2000cwb.googlegroups.com>


Not only interesting, but already in use as well.

I'm supporting an application that actually stores it's conceptual level views in the actual application database (it has a simple logical/conceptual data dictionary). It does this since 1992! the only drawback is that the views are created in a conceptual language that supports just a small subset of current SQL, and the supporting data dictionary is somewhat primitive. Is this practical ? You bet, i've never bothered with documenting the data dictionary/conceptual datamodel, just writing reports against the data dictionary suffices.
BTW the application also stores (almost) everything else in the database as well: Userforms, code, configuration items etc. Except for the application code, that is stored as BLOBs, everything has a simple data model that you can query.
I tried to fix up the code BLOBs and reload it into our datawarehouse with a simple data model instead. But this was too difficult to do efficiently with SQL so I dropped that. Still, a queryable code model would work very well, and would make code maintence a LOT easier, given you've created some good reports on top of that.

Received on Mon Jun 13 2005 - 03:11:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US