Muutke küpsiste eelistusi

E-raamat: Data Model Resource Book, Volume 1: A Library of Universal Data Models for All Enterprises

4.07/5 (116 hinnangut Goodreads-ist)
, Foreword by
  • Formaat: PDF+DRM
  • Ilmumisaeg: 08-Aug-2011
  • Kirjastus: John Wiley & Sons Inc
  • Keel: eng
  • ISBN-13: 9781118172759
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 74,10 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Data Model Resource Book, Volume 1: A Library of Universal Data Models for All EnterprisesSuurem pilt
  • Formaat: PDF+DRM
  • Ilmumisaeg: 08-Aug-2011
  • Kirjastus: John Wiley & Sons Inc
  • Keel: eng
  • ISBN-13: 9781118172759
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

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.

Arvustused

"I thought the models in the books were well thought out and adequately explained" (Computer Shopper February 2002)

Foreword xiii
Acknowledgments xv
About the Author xvii
Introduction
1(20)
Why Is There a Need for This Book?
1(1)
Who Can Benefit from Reading This Book?
2(1)
The Need for Universal Data Models
2(1)
A Holistic Approach to Systems Development
3(2)
What Is the Intent of This Book and These Models?
5(1)
What Is New in the Second Edition of the Data Model Resource Book?
6(2)
Conventions and Standards Used in This Book
8(11)
Entities
8(1)
Subtypes and Supertypes
9(2)
Non-Mutually Exclusive Sets of Subtypes
11(1)
Attributes
11(1)
Relationships
12(1)
Relationship Optionality
12(1)
Relationship Cardinality
12(2)
Foreign Key Relationships
14(1)
Foreign Key Inheritance
15(1)
Intersection or Association Entities to Handle Many-to-Many Relationships
15(1)
Exclusive Arcs
16(1)
Recursive Relationships
17(1)
Physical Models
17(1)
Conventions Used for Illustration Tables
18(1)
Conventions Used to Reference Figures
19(1)
The Companion CD-ROM
19(2)
People and Organizations
21(48)
Organization
22(3)
Person
25(4)
Person---Alternate Model
26(3)
Party
29(4)
Party Roles
33(6)
Organization Roles
35(1)
Common Party Role Subtypes
36(1)
Should Roles Be Defined at the Time of the Transaction?
36(1)
Party Role Example
37(1)
Role Types throughout This Book
37(2)
Party Relationship
39(8)
Party Relationship Examples
44(2)
Party Relationship Information
46(1)
Status Types
47(1)
Party Contact Information
47(11)
Postal Address Information
49(2)
Geographic Boundaries
51(2)
Party Contact Mechanism---Telecommunications Numbers and Electronic Addresses
53(1)
Party Contact Mechanism (Expanded)
54(2)
Contact Mechanism Purpose
56(2)
Facility versus Contact Mechanism
58(1)
Party Communication Event
58(9)
Communication Event Follow-Up
63(4)
Summary
67(2)
Products
69(36)
Product Definition
70(1)
Product Category
71(4)
Product Identification Codes
75(1)
Product Features
76(5)
Product Feature Interaction
78(1)
Product Feature Subtypes
78(1)
Product Feature Examples
79(1)
Unit of Measure
80(1)
Suppliers and Manufacturers of Products
81(3)
Inventory Item Storage
84(3)
Product Pricing
87(6)
Pricing Subtypes
87(2)
Price Component Attributes and Relationship to Product or Product Feature
89(1)
Pricing Factors
89(2)
International Pricing
91(1)
Example of Product Pricing
91(2)
Product Costing
93(3)
Product to Product Associations
96(8)
Products and Parts
100(4)
Summary
104(1)
Ordering Products
105(54)
Standard Order Model
106(3)
Order and Order Items
109(4)
Order Parties and Contact Mechanisms
113(11)
Sales Order Parties and Contact Mechanisms
113(3)
Party Placing Order and Related Contact Mechanism
116(1)
Party Taking Order and Related Contact Mechanism
116(1)
Ship-to Party and Contact Mechanism
116(1)
Bill-to Party and Contact Mechanism
117(2)
Person Roles for Orders
119(1)
Purchase Order Parties and Contact Mechanisms
120(1)
Generic Order Roles and Contact Mechanisms
120(4)
Order Adjustments
124(5)
Order Status and Terms
127(1)
Order Status
127(2)
Order Terms
129(1)
Order Item Association
129(2)
Optional Order Models
131(1)
Requirements
132(5)
Requirement Roles
134(1)
Requirement Status
134(1)
Product Requirements
135(1)
Order Requirement Commitments
135(1)
Requirement Example
135(2)
Requests
137(4)
Request
137(3)
Request Items
140(1)
Quote Definition
141(4)
Quote Roles
143(1)
Quote
143(1)
Quote Items
143(1)
Quote Terms
144(1)
Agreement Definition
145(3)
Agreement Item
148(3)
Agreement Terms
151(2)
Agreement Pricing
153(2)
Agreement to Order
155(2)
Summary
157(2)
Shipments
159(26)
Shipments
160(3)
Shipment Types
161(1)
Shipments Parties and Contact Mechanisms
162(1)
Shipping Detail
163(4)
Shipment Status
166(1)
Shipment-to-Order Relationship
167(3)
Shipment Receipts
170(3)
Item Issuance for Outgoing Shipments
173(3)
Shipment Documents
176(2)
Shipment Routing
178(4)
Shipment Vehicle
180(2)
Summary
182(3)
Work Effort
185(44)
Work Requirement and Work Efforts
186(1)
Work Requirement Definition
186(5)
Requirement Types
188(2)
Anticipated Demand
190(1)
Work Requirement Compared to Order
190(1)
Work Requirement Roles
191(2)
Work Effort Generation
193(7)
Work Effort Type and Work Effort Purpose Type
195(1)
Work Effort Attributes
195(1)
Fulfillment of Work Requirements
196(2)
Work Effort and Facility
198(1)
Work Effort Generation---Alternate Model
198(2)
Work Effort Associations
200(3)
Work Effort Association Definition
200(3)
Work Effort Dependency
203(1)
Work Efforts and Work Tasks
203(1)
Work Effort Party Assignment
203(6)
Work Effort Party Assignment
205(1)
Party Skill and Skill Type
206(1)
Work Effort Status
207(1)
Work Effort Party Assignment
207(1)
Work Effort Role Type
208(1)
Work Effort Assignment Facility
209(1)
Work Effort Time Tracking
209(2)
Work Effort Rates
211(4)
Work Effort Assignment Rate
214(1)
Inventory Assignments
215(2)
Fixed Asset Assignments
217(3)
Fixed Asset
218(1)
Fixed Asset Type
218(1)
Fixed Asset Assignment and Status
219(1)
Party Fixed Asset Assignments
220(1)
Work Effort Type Standards
221(3)
Work Effort Skill Standards
223(1)
Work Effort Good Standards
223(1)
Work Effort Fixed Asset Standard
224(1)
Work Effort Results
224(3)
Summary
227(2)
Invoicing
229(30)
Invoices and Invoice Items
230(4)
Invoice Roles
234(3)
Billing Account
237(3)
Invoice Specific Roles
240(2)
Invoice Terms and Status
242(2)
Invoice Status
242(2)
Invoice Terms
244(1)
Invoice and Associated Transactions
244(6)
Billing for Shipment Items
245(2)
Billing for Work Efforts and Time Entries
247(2)
Billing for Order Items
249(1)
Payments
250(4)
Financial Accounts, Deposits, and Withdrawals
254(4)
Summary
258(1)
Accounting and Budgeting
259(40)
Chart of Accounts for Internal Organizations
260(5)
General Ledger Accounts and Types
260(2)
Organization GL Account
262(1)
Accounting Period
263(2)
Accounting Transactions Definition
265(5)
Business Transactions versus Accounting Transactions?
267(1)
Accounting Transaction
267(1)
Accounting Transactions and Their Related Parties
268(2)
Accounting Transaction Details
270(5)
Transaction Detail
270(3)
Relationships between Accounting Transaction Details
273(2)
Account Balances and Transactions
275(1)
Subsidiary Accounts
276(2)
Asset Depreciation
278(2)
Budget Definition
280(3)
Budget
280(2)
Budget Item
282(1)
Budget Status
282(1)
Budget Revision
283(3)
Budget Review
286(2)
Budget Scenarios
288(1)
Usage and Sources of Budgeted Amounts
289(6)
Commitments against Budgets
292(1)
Payments against Budgets
293(2)
Budget Relationship to General Ledger
295(3)
Budgeted Items versus General Ledger Accounts
298(1)
Summary
298(1)
Human Resources
299(38)
Standard Human Resources Model
300(2)
Employment
302(1)
Position Definition
303(4)
Position
305(1)
Position Authorization
305(1)
Position Type
306(1)
Position Responsibilities
306(1)
Position Type Definition
307(2)
Organization
307(2)
Position Fulfillment and Tracking
309(3)
Position Fulfillment
310(1)
Position Status Type
311(1)
Hiring Organization
311(1)
Other Considerations
311(1)
Position Reporting Relationships
312(2)
Position Reporting Structure
312(2)
Salary Determination and Pay History
314(5)
Position Type Rate
316(1)
Pay Grade and Salary Step
317(1)
Pay History and Actual Salary
318(1)
Benefits Definition and Tracking
319(3)
Employment
319(1)
Party Benefit
320(1)
Period Type
321(1)
Benefit Type
321(1)
Payroll Information
322(5)
Employee
322(2)
Payment Method Type
324(1)
Payroll Preference
324(1)
Paycheck
325(1)
Deduction and Deduction Type
326(1)
Employment Application
327(1)
Employee Skills and Qualifications
328(1)
Employee Performance
328(5)
Employee Termination
333(1)
Summary
333(4)
Creating the Data Warehouse Data Model from the Enterprise Data Model
337(20)
The Data Warehouse Architecture
337(3)
The Enterprise Data Model
338(1)
The Data Warehouse Design
338(1)
The Departmental Data Warehouse Design or Data Mart
338(1)
An Architected Data Warehouse Environment
339(1)
The Enterprise Data Model
340(3)
Transformation Requirements
340(2)
Process Models
342(1)
High-Level and Logical Data Models
342(1)
Making the Transformation
343(12)
Removing Operational Data
345(1)
Adding an Element of Time to the Warehouse Key
346(1)
Adding Derived Data
346(1)
Creating Relationship Artifacts
347(3)
Changing Granularity of Data
350(1)
Merging Tables
351(1)
Creation of Arrays of Data
352(2)
Organizing Data According to Its Stability
354(1)
Summary
355(2)
A Sample Data Warehouse Data Model
357(12)
Transformation to Customer Invoice
358(6)
Removing Operational Data
358(1)
Adding an Element of Time
359(1)
Adding Derived Data
360(1)
Creating Relationship Artifacts
360(2)
Accommodating Levels of Granularity
362(1)
Merging Tables
363(1)
Separation Based on Stability
363(1)
Other Considerations
363(1)
The Sample Data Warehouse Data Model
364(1)
Common Reference Tables
365(1)
Summary
365(4)
Star Schema Designs for Sales Analysis
369(18)
Sales Analysis Data Mart
370(7)
Customer Sales Facts
372(1)
Customer Dimension
373(1)
Customer Demographics Dimensions
373(1)
Sales Reps Dimensions
374(1)
Internal Organizations Dimension
375(1)
Addresses Dimension
375(1)
Product Dimension
376(1)
Time Dimension
376(1)
Transaction-Oriented Sales Data Mart
377(3)
Variations on the Sales Analysis Data Mart
380(4)
Sales Rep Performance Data Mart
380(1)
Customer Rep Sales Fact
381(1)
Time Dimension
382(1)
Product Analysis Data Mart
382(1)
Product Sales Facts
383(1)
Geographic Boundaries Dimension
384(1)
Summary
384(3)
Star Schema Designs for Human Resources
387(10)
Human Resources Star Schema
388(5)
Human Resource Fact Table
389(1)
Organizations Dimension
390(1)
Position Types Dimension
391(1)
Genders Dimension
392(1)
Length of Services Dimension
392(1)
Statuses Dimension
392(1)
Pay Grades Dimension
392(1)
EEOC Types Dimension
393(1)
Time_By_Month Dimension
393(1)
Human Resources Star Schema at a Higher Level of Granularization
393(2)
Summary
395(2)
Additional Star Schema Designs
397(10)
Inventory Management Analysis
398(1)
Purchase Order Analysis
399(2)
Shipment Analysis
401(1)
Work Effort Analysis
402(2)
Financial Analysis
404(1)
Summary
405(2)
Implementing the Universal Data Models
407(42)
The Enterprise Data Model---An Integrated Business View of the Enterprise's Information
408(11)
Customizing the Universal Data Models
410(1)
Degrees of Customization
410(1)
Customizing the Models for Unique Business Terminology
411(1)
Example of Changing the Terms for the Specific Enterprise
412(4)
Additional Information Requirements Needed for the Enterprise
416(2)
How the Universal Data Models and Enterprise Data Model Slove Business Problems
418(1)
Using a Data Model for a Particular Application
419(6)
Understanding Business Processes
420(2)
Building the Logical Data Model
422(3)
Physical Database Design
425(19)
Basic Database Design Principles
425(2)
Creating a Physical Database Design
427(1)
Physical Database Design Examples
428(1)
Review of the Party Role and Relationship Model
428(2)
Party Roles and Relationships Physical Design, Option 1
430(3)
Example Data for Physical Database Design, Option 1
433(4)
Party Roles and Relationships Physical Design, Option 2
437(2)
Party Roles and Relationships Generic Design, Option 3
439(5)
Using the Data Warehouse Models
444(2)
Summary
446(1)
For More Information
447(2)
Appendix A Logical Data Model Entities and Attributes 449(54)
Appendix B Data Warehouse Data Model Tables and Columns 503(6)
Appendix C Star Schema Design Tables and Columns 509(10)
How to Use the CD-ROM Product 519(2)
Other Reusable Data Model and Data Warehouse Design Resources 521(2)
Index 523


LEN SILVERSTON (lsilverston @univdata.com) is founder and owner of Universal Data Models, LLC (www.universaldatamodels.com), a Colorado-based firm providing consulting and training for helping enterprises customize and implement "universal data models" and develop holistic, integrated systems. Mr. Silverston has over 20 years' experience in delivering data integration, database and data warehouse solutions to organizations.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97811181727592e.html
Märksõnad: