Book description
A quick and reliable way to build proven databases for core business functionsIndustry 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.
Table of contents
- 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
- Products
- Ordering Products
- Shipments
-
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
-
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
- 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
Product information
- Title: The Data Model Resource Book, Volume 1
- Author(s):
- Release date: March 2001
- Publisher(s): Wiley
- ISBN: 9780471380238
You might also like
book
The Data Model Resource Book, Volume 3: Universal Patterns for Data Modeling
This third volume of the best-selling "Data Model Resource Book" series revolutionizes the data modeling discipline …
book
The Data Model Resource Book, Vol. 2: A Library of Data Models for Specific Industries
A quick and reliable way to build proven databases for core business functions Industry experts raved …
book
Data Management at Scale, 2nd Edition
As data management continues to evolve rapidly, managing all of your data in a central place, …
book
Data Mesh
We're at an inflection point in data, where our data management solutions no longer match the …