Here are the sections of Data Model Patterns:
Data Architecture in a Box. These are "applications" in the
Oracle® Designer
tool. All customers will purchase The Core Model.
The others are optional. (Click on a title to see the entities in each section.)
The Core Model
The Core Model contains the primary elements required in any enterprise
data model: Descriptions of people and organizations, geography, products (called here ASSETS),
activities, and contracts.
Accounting
This section includes a complete model of double-entry bookkeeping, including
definitions of account, cost center, and accounting transactions. It includes a technique
for describing in data the rules which define each kind of accounting transaction.
Document Management
In one sense, documents should not be the subject of a data model:
They are but retrievals of data elsewhere in the model. In some businesses,
however, the documents themselves are things of significance, to be stored,
distributed, and indexed. This section models that side of document
management.
In addition, this section addresses the problem of modeling complex documents.
Here, for example, are presented models for pharmaceutical clinical trial case report
forms and material safety data sheets.
Process Manufacturing
The structure of process manufacturing data is significantly different from that for discrete
manufacturing. This section is a model of a process plant (chemicals, oil refining,
etc.) It also includes a comprehensive model of the laboratory. This
describes any laboratory, not just one for a process plant.
Materials Planning
Materials Requirements Planning (MRP) is itself a simulation of the business. Thus the
data model for it will consist almost entirely of computed values. This turns out to
produce a relatively simple data model, but understanding the calculations is difficult.
Consequently, the narrative that accompanies this section is particularly detailed
in explaining the logic of MRP. Also included is an Excel™ spreadsheet with MRP loaded,
so the customer can experiment with the logic to find out the implications of various kinds of
decisions.
|