book

The Data Model Resource Book, Volume 1

by Len Silverston, Graeme Simsion

March 2001

Beginner to intermediate

560 pages

13h 22m

English

Wiley

Read now

Unlock full access

Why Is There a Need for This Book?Who Can Benefit from Reading This Book?The Need for Universal Data ModelsA Holistic Approach to Systems DevelopmentWhat 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 BookThe Companion Electronic Product
OrganizationPersonPartyParty RolesParty RelationshipParty Contact InformationFacility Versus Contact MechanismParty Communication Event
Product DefinitionProduct CategoryProduct Identification CodesProduct FeaturesSuppliers and Manufacturers of ProductsInventory Item StorageProduct PricingProduct CostingProduct to Product Associations
Standard Order ModelOrder and Order ItemsOrder Parties and Contact MechanismsOrder AdjustmentsOrder Item AssociationOptional Order ModelsRequirementsRequestsQuote DefinitionAgreement DefinitionAgreement ItemAgreement TermsAgreement PricingAgreement to Order
ShipmentShipping DetailShipment-to-Order RelationshipShipment ReceiptsItem Issuance for Outgoing ShipmentsShipment DocumentsShipment Routing
Work Requirement and Work EffortsWork Requirement DefinitionWork Requirement RolesWork Effort GenerationWork Effort AssociationsWork Effort Party AssignmentWork Effort Time TrackingWork Effort RatesInventory AssignmentsFixed Asset AssignmentsParty Fixed Asset AssignmentsWork Effort Type StandardsWork Effort Results

Invoices and Invoice ItemsInvoice RolesBilling AccountInvoice Specific RolesInvoice Terms and StatusInvoice and Associated TransactionsPaymentsFinancial Accounts, Deposits, and Withdrawals
Chart of Accounts for Internal OrganizationsAccounting Transactions DefinitionAccounting Transaction DetailsAccount Balances and TransactionsSubsidiary AccountsAsset DepreciationBudget DefinitionBudget RevisionBudget ReviewBudget ScenariosUsage and Sources of Budgeted AmountsBudget Relationship to General Ledger
Standard Human Resources ModelEmploymentPosition DefinitionPosition Type DefinitionPosition Fulfillment and TrackingPosition Reporting RelationshipsSalary Determination and Pay HistoryBenefits Definition and TrackingPayroll InformationEmployment ApplicationEmployee Skills and QualificationsEmployee PerformanceEmployee Termination
The Data Warehouse ArchitectureThe Enterprise Data ModelMaking the Transformation
Transformation to Customer InvoiceThe Sample Data Warehouse Data Model
Sales Analysis Data MartTransaction-Oriented Sales Data MartVariations on the Sales Analysis Data MartVariation 1: Sales Rep Performance Data MartVariation 2: Product Analysis Data Mart
Human Resources Star SchemaHuman Resources Star Schema at a Higher Level of Granularization
Inventory Management AnalysisPurchase Order AnalysisShipment AnalysisWork Effort AnalysisFinancial Analysis
The Enterprise Data Model—An Integrated Business View of the Enterprise's InformationUsing a Data Model for a Particular ApplicationPhysical Database DesignUsing the Data Warehouse ModelsFor More Information
Logical Data Model Entities and Attributes Listing
Data Warehouse Data Model Tables and Column Listing
Star Schema Designs Tables and Column Listing

Content preview from The Data Model Resource Book, Volume 1

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

The Data Model Resource Book, Vol. 2: A Library of Data Models for Specific Industries

Len Silverston

Data Management at Scale, 2nd Edition

Piethein Strengholt

The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition

Ralph Kimball, Margy Ross

Patterns of Data Modeling

Michael Blaha

Publisher Resources

ISBN: 9780471380238Purchase book

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,and much more.

You might also like

The Data Model Resource Book, Vol. 2: A Library of Data Models for Specific Industries

Data Management at Scale, 2nd Edition

The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition

Patterns of Data Modeling

Publisher Resources

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.