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.