eBook - ePub
The Data Model Resource Book, Volume 1
A Library of Universal Data Models for All Enterprises
- English
- ePUB (mobile friendly)
- Available on iOS & Android
eBook - ePub
The Data Model Resource Book, Volume 1
A Library of Universal Data Models for All Enterprises
About this book
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.
Frequently asked questions
Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn more here.
Perlego offers two plans: Essential and Complete
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Yes, you can access The Data Model Resource Book, Volume 1 by Len Silverston in PDF and/or ePUB format, as well as other popular books in Computer Science & Data Warehousing. We have over one million books available in our catalogue for you to explore.
Information
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