Data Warehouse Meta-Model

  • Article

The meta-model of the Commerce Server 2000 Data Warehouse is a set of definitions used to construct the Data Warehouse logical schema. These definitions, or meta-data, describe how to create classes, data members, relations, and keys. Additionally, the meta-data describes the data source used for the logical schema. The primary purpose of the meta-data is to separate the logical schema from the physical schema. The logical schema may be accessed and extended without detailed knowledge of the underlying physical store. Using the values given to the meta-data attributes, the OLE DB Provider for Commerce Server creates the physical tables and columns to store the user data. This ensures consistency and simplifies the use of the Data Warehouse. For information about creating a new class of objects, see Extending the Data Warehouse.

Ee799281.note(en-US,CS.10).gif Note

  • When accessing the meta-data tables through ActiveX Data Objects (ADO), fields appear in the returned Record object in addition to those listed in the tables. ADO does not recognize the objects contained in these fields and produces a run time error. To access these objects, use OLE DB Provider for Commerce Server. The following is a partial list of these columns (ADO Field objects):

    __COMMIT, __NEXT, ALLMEMBERS, ATTRIBUTES, CHILDCLSDEF, CHILDREFMEMDEF, CLASSGUID, CLSDEF, DEFAULTVIEW, KEYDEFINITIONS, KEYMEMBERS, MEMBERDEF, MEMDEFS, MEMNONREFDEFS, PARENTCLASSES, PARENTCLSDEF, PARENTKEYDEF, PERSISTENTKEYMEMS, REFERENCEMEMBERS, REFMEMBERS, RELMEMDEFS, TOPLEVELMEMBERS

This section contains:


All rights reserved.