The Data Model Resource Book, Volume 1

A Library of Universal Data Models for All Enterprises

Len Silverston

• Publisher: Wiley
• Year: 2011
• ISBN:
  9781118082324
• Edition: 1
• Topic: Informatica
• Subtopic: Archiviazione di dati

A quick and reliable way to build proven databases for core business functions Industry experts raved about The Data Model Resource Book when it was first published in March 1997 because it provided a simple, cost-effective way to design databases for core business functions. Len Silverston has now revised and updated the hugely successful 1st Edition, while adding a companion volume to take care of more specific requirements of different businesses. This updated volume provides a common set of data models for specific core functions shared by most businesses like human resources management, accounting, and project management. These models are standardized and are easily replicated by developers looking for ways to make corporate database development more efficient and cost effective. This guide is the perfect complement to The Data Model Resource CD-ROM, which is sold separately and provides the powerful design templates discussed in the book in a ready-to-use electronic format. A free demonstration CD-ROM is available with each copy of the print book to allow you to try before you buy the full CD-ROM.

Index

A

Account balances

ACCOUNT BALANCES entity

Accounting

ACCOUNTING PERIOD entity

ACCOUNTING PERIOD TYPE entity

ACCOUNTING TRANSACTION entity

ACCOUNTING TRANSACTION TYPE entity

account number attribute

acctg period num attribute

ACQUIRING ITEM entity

ACTIVITY entity

ACTIVITY REQUEST entity

actual arrival datetime attribute

actual completion datetime attribute

actual employer paid percentage attribute

actual from date attribute

actual hours attribute

actual ship cost attribute

actual start datetime attribute

actual thru date attribute

add delete flag attribute

addendum creation date attribute

addendum effective date attribute

ADDENDUM entity

addendum text attribute

address1 attribute

address2 attribute

ADDRESSES dimension

address_id

address_line1

address_line2

ADJUSTMENT ITEM entity

ADJUSTMENT TYPE entity

affected by attribute

age

AGENT entity

AGREEMENT entity

orders and

AGREEMENT EXHIBIT entity

AGREEMENT GEOGRAPHICAL APPLICABILITY

entity

AGREEMENT ITEM entity

Agreement item prices, table of

Agreement items

AGREEMENT ITEM TERMS entity

AGREEMENT ORGANIZATION APPLICABILITY

entity

AGREEMENT PRICE COMPONENT entity

Agreement pricing

AGREEMENT PRICING PROGRAM entity

AGREEMENT PRODUCT APPLICABILITY entity

AGREEMENT PRODUCT TYPE APPLICABILITY

entity

AGREEMENT ROLE entity

AGREEMENT ROLE TYPE entity

Agreements

in data models

defined

table of

AGREEMENT SECTION entity

AGREEMENT TERM entity

Agreement terms

table of

AGREEMENT TYPE entity

alias name attribute

allocated cost attribute

AMORTIZATION entity

amount

amount attribute

amount change attribute

ANSI-compliant databases

Anticipated demand, work effort and

Applications, in data models

approved date attribute

Architected data warehouses

arising from attribute

Arrays, of data

Artifacts

Asset depreciation

asset ID attribute

Associated transactions, of invoices

ASSOCIATION entity

Asterisk (*), with mandatory keys

Atomic level

Attributes

of entities

mandatory

naming conventions for

optional

in unique identifiers

available from date attri...

Table of contents

• Cover
• Foreword
• Acknowledgments
• About the Author
• Introduction
• People and Organizations
• Products
• Ordering Products
• Shipments
• Work Effort
• Invoicing
• Accounting and Budgeting
• Human Resources
• Creating the Data Warehouse Data Model from the Enterprise Data Model
• A Sample Data Warehouse Data Model
• Star Schema Designs for Sales Analysis
• Star Schema Designs for Human Resources
• Additional Star Schema Designs
• Implementing the Universal Data Models
• Logical Data Model Entities and Attributes
• Data Warehouse Data Model Tables and Columns
• Star Schema Design Tables and Columns
• Other Reusable Data Model and Data Warehouse Design Resources
• Index