Home Page Icon
Home Page
Table of Contents for
Cover
Close
Cover
by Graeme Simsion, Len Silverston
The Data Model Resource Book, Volume 1
Cover
Foreword
Acknowledgments
About the Author
Introduction
Why Is There a Need for This Book?
Who Can Benefit from Reading This Book?
The Need for Universal Data Models
A Holistic Approach to Systems Development
What Is the Intent of This Book and These Models?
What Is New in the Second Edition of the Data Model Resource Book?
Conventions and Standards Used in This Book
The Companion Electronic Product
People and Organizations
Organization
Person
Party
Party Roles
Party Relationship
Party Contact Information
Facility Versus Contact Mechanism
Party Communication Event
Products
Product Definition
Product Category
Product Identification Codes
Product Features
Suppliers and Manufacturers of Products
Inventory Item Storage
Product Pricing
Product Costing
Product to Product Associations
Ordering Products
Standard Order Model
Order and Order Items
Order Parties and Contact Mechanisms
Order Adjustments
Order Item Association
Optional Order Models
Requirements
Requests
Quote Definition
Agreement Definition
Agreement Item
Agreement Terms
Agreement Pricing
Agreement to Order
Shipments
Shipment
Shipping Detail
Shipment-to-Order Relationship
Shipment Receipts
Item Issuance for Outgoing Shipments
Shipment Documents
Shipment Routing
Work Effort
Work Requirement and Work Efforts
Work Requirement Definition
Work Requirement Roles
Work Effort Generation
Work Effort Associations
Work Effort Party Assignment
Work Effort Time Tracking
Work Effort Rates
Inventory Assignments
Fixed Asset Assignments
Party Fixed Asset Assignments
Work Effort Type Standards
Work Effort Results
Invoicing
Invoices and Invoice Items
Invoice Roles
Billing Account
Invoice Specific Roles
Invoice Terms and Status
Invoice and Associated Transactions
Payments
Financial Accounts, Deposits, and Withdrawals
Accounting and Budgeting
Chart of Accounts for Internal Organizations
Accounting Transactions Definition
Accounting Transaction Details
Account Balances and Transactions
Subsidiary Accounts
Asset Depreciation
Budget Definition
Budget Revision
Budget Review
Budget Scenarios
Usage and Sources of Budgeted Amounts
Budget Relationship to General Ledger
Human Resources
Standard Human Resources Model
Employment
Position Definition
Position Type Definition
Position Fulfillment and Tracking
Position Reporting Relationships
Salary Determination and Pay History
Benefits Definition and Tracking
Payroll Information
Employment Application
Employee Skills and Qualifications
Employee Performance
Employee Termination
Creating the Data Warehouse Data Model from the Enterprise Data Model
The Data Warehouse Architecture
The Enterprise Data Model
Making the Transformation
A Sample Data Warehouse Data Model
Transformation to Customer Invoice
The Sample Data Warehouse Data Model
Star Schema Designs for Sales Analysis
Sales Analysis Data Mart
Transaction-Oriented Sales Data Mart
Variations on the Sales Analysis Data Mart
Variation 1: Sales Rep Performance Data Mart
Variation 2: Product Analysis Data Mart
Star Schema Designs for Human Resources
Human Resources Star Schema
Human Resources Star Schema at a Higher Level of Granularization
Additional Star Schema Designs
Inventory Management Analysis
Purchase Order Analysis
Shipment Analysis
Work Effort Analysis
Financial Analysis
Implementing the Universal Data Models
The Enterprise Data Model—An Integrated Business View of the Enterprise's Information
Using a Data Model for a Particular Application
Physical Database Design
Using the Data Warehouse Models
For More Information
Logical Data Model Entities and Attributes
Logical Data Model Entities and Attributes Listing
Data Warehouse Data Model Tables and Columns
Data Warehouse Data Model Tables and Column Listing
Star Schema Design Tables and Columns
Star Schema Designs Tables and Column Listing
Other Reusable Data Model and Data Warehouse Design Resources
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Titlepage
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset