{"product_id":"the-data-model-resource-book-volume-2-isbn-9780471353485","title":"The Data Model Resource Book, Volume 2","description":"\u003cp\u003e\u003cb\u003eA quick and reliable way to build proven databases for core business functions\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIndustry experts raved about \u003ci\u003eThe Data Model Resource Book\u003c\/i\u003e 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 First Edition, while adding a companion volume to take care of more specific requirements of different businesses. Each volume is accompanied by a CD-ROM, which is sold separately. Each CD-ROM provides powerful design templates discussed in the books in a ready-to-use electronic format, allowing companies and individuals to develop the databases they need at a fraction of the cost and a third of the time it would take to build them from scratch.\u003c\/p\u003e \u003cp\u003eWith each business function boasting its own directory, this CD-ROM provides a variety of data models for specific implementations in such areas as financial services, insurance, retail, healthcare, universities, and telecom.\u003c\/p\u003eDatenmodelle für Kernfunktionen, die in nahezu allen Geschäftsbereichen eine Rolle spielen: Dieses zweibändige, überarbeitete Handbuch in der 2. Auflage zeigt Datenbankprogrammierern, wie sie zwei Drittel der üblichen Entwicklungszeit sparen können! Im Mittelpunkt dieses 2. Bandes steht die Erstellung von Datenmodellen für verschiedenste Anwendungsgebiete - von der Finanzdienstleistung über das Versicherungswesen bis zu Bildungsangeboten. Dabei wird jeweils analysiert, wie die im ersten Band des Werkes vorgestellten generischen Modelle auf die spezielle Anwendung zuzuschneiden sind. Eine separat erhältliche CD-ROM beinhaltet sämtliche Datenmodelle in einer Form, die leicht in gebräuchliche kommerzielle Datenbanken zu integrieren ist. \u003cp\u003eForeword xiii\u003c\/p\u003e \u003cp\u003eAcknowledgments xv\u003c\/p\u003e \u003cp\u003eAbout the Author xvii\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1 Introduction 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhy is There a Need for This Book? 1\u003c\/p\u003e \u003cp\u003eTo Integrate or Disintegrate? That is the Question 2\u003c\/p\u003e \u003cp\u003eApproach of This Book 4\u003c\/p\u003e \u003cp\u003eWho is the Intended Audience for This Book? 5\u003c\/p\u003e \u003cp\u003eGeneral Industry Models versus More Specific Industry Models 5\u003c\/p\u003e \u003cp\u003eIndustry Data Models versus Data Model Applications 7\u003c\/p\u003e \u003cp\u003eThe Volume 2 Models: Customized and New Models for Each Industry 8\u003c\/p\u003e \u003cp\u003eConventions and Standards Used in This Book 8\u003c\/p\u003e \u003cp\u003eEntities 8\u003c\/p\u003e \u003cp\u003eSubtypes and Supertypes 15\u003c\/p\u003e \u003cp\u003eNon-Mutually Exclusive Sets of Subtypes 16\u003c\/p\u003e \u003cp\u003eAttributes 17\u003c\/p\u003e \u003cp\u003eRelationships 18\u003c\/p\u003e \u003cp\u003eRelationship Optionality 18\u003c\/p\u003e \u003cp\u003eRelationship Cardinality 19\u003c\/p\u003e \u003cp\u003eForeign Key Relationships 20\u003c\/p\u003e \u003cp\u003eForeign Key Inheritance 20\u003c\/p\u003e \u003cp\u003eIntersection or Association Entities to Handle Many-to Many Relationships 21\u003c\/p\u003e \u003cp\u003eExclusive Arcs 22\u003c\/p\u003e \u003cp\u003eRecursive Relationships 22\u003c\/p\u003e \u003cp\u003ePhysical Models 23\u003c\/p\u003e \u003cp\u003eConventions Used for Illustration Tables 24\u003c\/p\u003e \u003cp\u003eConventions Used to Reference Figures 25\u003c\/p\u003e \u003cp\u003eThe Data Model Resource Book, Volume 2, Industry Download Products 25\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 Manufacturing 27\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePeople and Organizations in Manufacturing 31\u003c\/p\u003e \u003cp\u003eProduct Models in Manufacturing 33\u003c\/p\u003e \u003cp\u003eProducts and Parts 33\u003c\/p\u003e \u003cp\u003eDesign Engineering 36\u003c\/p\u003e \u003cp\u003ePart Specifications and Documentation 36\u003c\/p\u003e \u003cp\u003ePart Specification Roles and Status 40\u003c\/p\u003e \u003cp\u003eEngineering Change 41\u003c\/p\u003e \u003cp\u003eProduct Bill of Material, Substitutes, and Inventory Configurations 43\u003c\/p\u003e \u003cp\u003eProduct Bill of Materials 44\u003c\/p\u003e \u003cp\u003ePart Substitutions 46\u003c\/p\u003e \u003cp\u003eInventory Item Configurations 50\u003c\/p\u003e \u003cp\u003eOther Product Models 53\u003c\/p\u003e \u003cp\u003eOrders 54\u003c\/p\u003e \u003cp\u003eUsage of the Order Models for Manufacturers 54\u003c\/p\u003e \u003cp\u003eMaterials Requirements Planning 56\u003c\/p\u003e \u003cp\u003eDelivery 57\u003c\/p\u003e \u003cp\u003eDeployment and Use of Products 58\u003c\/p\u003e \u003cp\u003eDeployments 58\u003c\/p\u003e \u003cp\u003eDeployment Usage 60\u003c\/p\u003e \u003cp\u003eInventory Ownership 62\u003c\/p\u003e \u003cp\u003eWork Effort 63\u003c\/p\u003e \u003cp\u003eProcess Plan 63\u003c\/p\u003e \u003cp\u003eProduction Runs 65\u003c\/p\u003e \u003cp\u003eInvoicing, Accounting, Budgeting, and Human Resources Models 67\u003c\/p\u003e \u003cp\u003eStar Schema for Manufacturing 69\u003c\/p\u003e \u003cp\u003eProduction Run Fact 70\u003c\/p\u003e \u003cp\u003eDimensions 71\u003c\/p\u003e \u003cp\u003eVariation of Product Run Data Mart 72\u003c\/p\u003e \u003cp\u003eManufacturing Summary 73\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 Telecommunications 75\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePeople and Organizations in Telecommunications 80\u003c\/p\u003e \u003cp\u003eGeneric Person and Organization Roles from Volume 1 80\u003c\/p\u003e \u003cp\u003eParty Roles and Relationships for Telecommunications 80\u003c\/p\u003e \u003cp\u003eExample of Party Roles and Relationships for Telecommunications 83\u003c\/p\u003e \u003cp\u003eTelecommunications Products 84\u003c\/p\u003e \u003cp\u003eTelecommunications Modifications to the Generic Product Data Models 84\u003c\/p\u003e \u003cp\u003eTelecommunications Services 86\u003c\/p\u003e \u003cp\u003eTelecommunications Goods 88\u003c\/p\u003e \u003cp\u003eTelecommunications Features 88\u003c\/p\u003e \u003cp\u003eProduct Feature Interaction 89\u003c\/p\u003e \u003cp\u003eTelecommunications Product and Product Feature Example 89\u003c\/p\u003e \u003cp\u003eProduct Deployment 91\u003c\/p\u003e \u003cp\u003eTelecommunications Product Associations 93\u003c\/p\u003e \u003cp\u003eNetwork Data Models 98\u003c\/p\u003e \u003cp\u003eNetwork Components 99\u003c\/p\u003e \u003cp\u003eNetwork Assemblies 101\u003c\/p\u003e \u003cp\u003eCircuits 104\u003c\/p\u003e \u003cp\u003eProduct, Circuit, and Network Assembly Capabilities 106\u003c\/p\u003e \u003cp\u003eCommunication IDs and Contact Mechanisms 109\u003c\/p\u003e \u003cp\u003eOrders 111\u003c\/p\u003e \u003cp\u003eService Orders 111\u003c\/p\u003e \u003cp\u003eProduct Availability 113\u003c\/p\u003e \u003cp\u003eDelivery 114\u003c\/p\u003e \u003cp\u003eDeployment Usage 114\u003c\/p\u003e \u003cp\u003eInvoicing 118\u003c\/p\u003e \u003cp\u003eWork Effort, Accounting, and Human Resources Models 120\u003c\/p\u003e \u003cp\u003eStar Schema for Telecommunications 121\u003c\/p\u003e \u003cp\u003eProduct Deployment Usage Fact 122\u003c\/p\u003e \u003cp\u003eCustomers 123\u003c\/p\u003e \u003cp\u003eDeployment Usage Types and Unit of Measures Dimensions 123\u003c\/p\u003e \u003cp\u003eProducts 123\u003c\/p\u003e \u003cp\u003eFacilities 124\u003c\/p\u003e \u003cp\u003eTime by Hour 124\u003c\/p\u003e \u003cp\u003eTelecommunications Summary 124\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 Health Care 127\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePeople and Organizations in Health Care 129\u003c\/p\u003e \u003cp\u003ePerson Roles 129\u003c\/p\u003e \u003cp\u003eOrganization Roles 132\u003c\/p\u003e \u003cp\u003eInsured Party Roles 133\u003c\/p\u003e \u003cp\u003eParty Relationships 134\u003c\/p\u003e \u003cp\u003eParty Roles Example 134\u003c\/p\u003e \u003cp\u003eHealth Care Facilities and Contact Mechanisms 138\u003c\/p\u003e \u003cp\u003ePatient, Practitioner, and Provider Information 138\u003c\/p\u003e \u003cp\u003eHealth Care Products 141\u003c\/p\u003e \u003cp\u003eHealth Care Offering Definition 141\u003c\/p\u003e \u003cp\u003eHealth Care “Orders” 144\u003c\/p\u003e \u003cp\u003eAgreement Definition 145\u003c\/p\u003e \u003cp\u003eHealth Care Shipments and Delivery 148\u003c\/p\u003e \u003cp\u003eHealth Care Episodes, Incidents and Visits 148\u003c\/p\u003e \u003cp\u003eHealth Care Delivery 151\u003c\/p\u003e \u003cp\u003eHealth Care Claims 154\u003c\/p\u003e \u003cp\u003eInvoice Data Models versus Claims Data Models 154\u003c\/p\u003e \u003cp\u003eHealth Care Claims Submission 156\u003c\/p\u003e \u003cp\u003eClaim Header Information 157\u003c\/p\u003e \u003cp\u003eClaim Codes 159\u003c\/p\u003e \u003cp\u003eInsurance Policy Information 160\u003c\/p\u003e \u003cp\u003ePayment Settlement 162\u003c\/p\u003e \u003cp\u003eHealth Care Referrals 164\u003c\/p\u003e \u003cp\u003eStar Schema for Health Care 165\u003c\/p\u003e \u003cp\u003eHealth Care Summary 167\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 Insurance 171\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePeople and Organizations in Insurance 173\u003c\/p\u003e \u003cp\u003ePerson Roles 176\u003c\/p\u003e \u003cp\u003eOrganization Roles 178\u003c\/p\u003e \u003cp\u003ePerson or Organization Roles 179\u003c\/p\u003e \u003cp\u003eInsurance Party Relationships 181\u003c\/p\u003e \u003cp\u003eInsurance Product 184\u003c\/p\u003e \u003cp\u003eInsurance Products and Categories 185\u003c\/p\u003e \u003cp\u003eInsurance Product Coverage 188\u003c\/p\u003e \u003cp\u003eDetails behind Coverage Types and Coverage Levels 190\u003c\/p\u003e \u003cp\u003eInsurance Product Features 194\u003c\/p\u003e \u003cp\u003eInsurance Product Rules 196\u003c\/p\u003e \u003cp\u003eInsurance Pricing 200\u003c\/p\u003e \u003cp\u003eCommunity-Based Rating 200\u003c\/p\u003e \u003cp\u003eInsurance Rate Tables 203\u003c\/p\u003e \u003cp\u003eExperienced-Based Insurance Rating 206\u003c\/p\u003e \u003cp\u003eInsurance Policies (Orders for Insurance) 206\u003c\/p\u003e \u003cp\u003eInsurance Application 206\u003c\/p\u003e \u003cp\u003eInsurance Quote 208\u003c\/p\u003e \u003cp\u003eThe Insurance Agreement or Insurance Policy 213\u003c\/p\u003e \u003cp\u003eInsurance Policy Roles 214\u003c\/p\u003e \u003cp\u003eInsurance Policy Items 216\u003c\/p\u003e \u003cp\u003eHealth Care Insurance Agreement 219\u003c\/p\u003e \u003cp\u003eCasualty Insurance Agreement 224\u003c\/p\u003e \u003cp\u003eProperty Insurance Agreement 225\u003c\/p\u003e \u003cp\u003eLife Insurance Agreement 226\u003c\/p\u003e \u003cp\u003ePremium Schedule 227\u003c\/p\u003e \u003cp\u003ePremium Invoicing and Payments 231\u003c\/p\u003e \u003cp\u003ePolicy Claims 231\u003c\/p\u003e \u003cp\u003eInsurance Claim Incidents 232\u003c\/p\u003e \u003cp\u003eInsurance Claims Submission 234\u003c\/p\u003e \u003cp\u003eClaims Settlement 237\u003c\/p\u003e \u003cp\u003eDelivery, Work Efforts, Accounting, and Human Resources for Insurance Enterprises 240\u003c\/p\u003e \u003cp\u003eStar Schemas for Insurance 241\u003c\/p\u003e \u003cp\u003eAnalysis Information 241\u003c\/p\u003e \u003cp\u003eClaim Star Schema 241\u003c\/p\u003e \u003cp\u003eFact Table 242\u003c\/p\u003e \u003cp\u003eDimensions 242\u003c\/p\u003e \u003cp\u003eInsurance Summary 245\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 Financial Services 247\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePeople and Organizations in Financial Services 249\u003c\/p\u003e \u003cp\u003eGeneric Party Role Subtypes 252\u003c\/p\u003e \u003cp\u003eFinancial Service Party Roles 252\u003c\/p\u003e \u003cp\u003eFinancial Service Relationships 254\u003c\/p\u003e \u003cp\u003eFinancial Objectives, Needs, and Plans 257\u003c\/p\u003e \u003cp\u003eFinancial Services Products 261\u003c\/p\u003e \u003cp\u003eFinancial Services Product Definition 262\u003c\/p\u003e \u003cp\u003eProduct Categories 264\u003c\/p\u003e \u003cp\u003eProduct Feature and Functional Setting 264\u003c\/p\u003e \u003cp\u003eFinancial Product and Functional Setting 265\u003c\/p\u003e \u003cp\u003eFeatures and Functional Settings for Product Categories 266\u003c\/p\u003e \u003cp\u003eFeatures and Functional Settings for Products 267\u003c\/p\u003e \u003cp\u003eExample of Predefined Financial Products with Product Features and Functional Settings 267\u003c\/p\u003e \u003cp\u003eFinancial Products That are Customized for the Specific Needs of a Customer 268\u003c\/p\u003e \u003cp\u003eProduct Category Roll-ups 272\u003c\/p\u003e \u003cp\u003eFinancial Product Regulations and Rules 273\u003c\/p\u003e \u003cp\u003eAgreements 276\u003c\/p\u003e \u003cp\u003eFinancial Agreements 276\u003c\/p\u003e \u003cp\u003eAgreement Subtypes and Roles 276\u003c\/p\u003e \u003cp\u003eAsset Roles and Agreement Asset Usage 278\u003c\/p\u003e \u003cp\u003eAgreement Status 279\u003c\/p\u003e \u003cp\u003eDelivery 279\u003c\/p\u003e \u003cp\u003eFinancial Account 279\u003c\/p\u003e \u003cp\u003eAccount Product 280\u003c\/p\u003e \u003cp\u003eAccount Roles 282\u003c\/p\u003e \u003cp\u003eAccount Relationships 282\u003c\/p\u003e \u003cp\u003eMedia 283\u003c\/p\u003e \u003cp\u003eAccount Status 283\u003c\/p\u003e \u003cp\u003eAccount Transaction 284\u003c\/p\u003e \u003cp\u003eAccount Transaction Type 284\u003c\/p\u003e \u003cp\u003eAccount Transaction Status 286\u003c\/p\u003e \u003cp\u003eAccount Transaction Relationships 286\u003c\/p\u003e \u003cp\u003eAccount Transaction Tasks 288\u003c\/p\u003e \u003cp\u003eWork Efforts 290\u003c\/p\u003e \u003cp\u003eAccount Notification 290\u003c\/p\u003e \u003cp\u003eNotification Task Types 291\u003c\/p\u003e \u003cp\u003eInvoicing and Statement Tasks 291\u003c\/p\u003e \u003cp\u003eMarketing Tasks 293\u003c\/p\u003e \u003cp\u003eAlert Tasks 294\u003c\/p\u003e \u003cp\u003eOther Notification Tasks 294\u003c\/p\u003e \u003cp\u003eExample of Account Notification Tasks 295\u003c\/p\u003e \u003cp\u003eAnalysis Task 295\u003c\/p\u003e \u003cp\u003eAnalysis Task Data Model 297\u003c\/p\u003e \u003cp\u003eExample of Risk Analysis Task 299\u003c\/p\u003e \u003cp\u003eInvoicing, Accounting, and Human Resources 299\u003c\/p\u003e \u003cp\u003eStar Schemas for Financial Services 300\u003c\/p\u003e \u003cp\u003eAnalysis Information 300\u003c\/p\u003e \u003cp\u003eAccount Star Schema 300\u003c\/p\u003e \u003cp\u003eFact Table 302\u003c\/p\u003e \u003cp\u003eDimensions 302\u003c\/p\u003e \u003cp\u003eAccount Transaction Star Schema 304\u003c\/p\u003e \u003cp\u003eFact Table 304\u003c\/p\u003e \u003cp\u003eDimensions 304\u003c\/p\u003e \u003cp\u003eFinancial Services Summary 306\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 Professional Services 309\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePeople and Organizations in Professional Services 311\u003c\/p\u003e \u003cp\u003ePerson Roles 313\u003c\/p\u003e \u003cp\u003eOrganization Roles 314\u003c\/p\u003e \u003cp\u003eProfessional Services Roles and Relationships Examples 314\u003c\/p\u003e \u003cp\u003eProfessional Services Products 316\u003c\/p\u003e \u003cp\u003eProfessional Services Products Model 317\u003c\/p\u003e \u003cp\u003eApplicability of Other Product Models 319\u003c\/p\u003e \u003cp\u003eProfessional Service Product Associations 321\u003c\/p\u003e \u003cp\u003eOrders 321\u003c\/p\u003e \u003cp\u003eProfessional Services Requirements 322\u003c\/p\u003e \u003cp\u003eProfessional Services Requests and Quotes 325\u003c\/p\u003e \u003cp\u003eProfessional Services Requests 328\u003c\/p\u003e \u003cp\u003eProfessional Service Quotes (Proposals and Statements of Work) 330\u003c\/p\u003e \u003cp\u003eEngagements 333\u003c\/p\u003e \u003cp\u003eTypes of Engagement Items 333\u003c\/p\u003e \u003cp\u003eEngagement Rates 335\u003c\/p\u003e \u003cp\u003ePlacement versus Deliverables-Based Consulting 336\u003c\/p\u003e \u003cp\u003eEngagement Example 336\u003c\/p\u003e \u003cp\u003eProfessional Services Agreements 338\u003c\/p\u003e \u003cp\u003eDelivery 341\u003c\/p\u003e \u003cp\u003eProfessional Services Entries 341\u003c\/p\u003e \u003cp\u003eWork Efforts 343\u003c\/p\u003e \u003cp\u003eInvoicing 346\u003c\/p\u003e \u003cp\u003eAccounting and Human Resources Management 347\u003c\/p\u003e \u003cp\u003eStar Schema for Professional Services 348\u003c\/p\u003e \u003cp\u003eTime Entry Fact 349\u003c\/p\u003e \u003cp\u003eDimensions 350\u003c\/p\u003e \u003cp\u003eProfessional Services Summary 350\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 Travel 353\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePeople and Organizations in Travel 355\u003c\/p\u003e \u003cp\u003ePerson Roles 357\u003c\/p\u003e \u003cp\u003eOrganization Roles 357\u003c\/p\u003e \u003cp\u003eParty Relationships 359\u003c\/p\u003e \u003cp\u003eTravel Preferences 362\u003c\/p\u003e \u003cp\u003eTravel Products 364\u003c\/p\u003e \u003cp\u003eProduct Definition 364\u003c\/p\u003e \u003cp\u003eTravel Orders (Reservations) 369\u003c\/p\u003e \u003cp\u003eOrder Models 370\u003c\/p\u003e \u003cp\u003eTicketing 373\u003c\/p\u003e \u003cp\u003eAgreements 376\u003c\/p\u003e \u003cp\u003eTravel Agreements 376\u003c\/p\u003e \u003cp\u003ePricing of Agreements and Products 376\u003c\/p\u003e \u003cp\u003eDelivery (Travel Experience) 379\u003c\/p\u003e \u003cp\u003eInvoicing 383\u003c\/p\u003e \u003cp\u003eWork Efforts 383\u003c\/p\u003e \u003cp\u003eTravel Programs and Travel Accounts 383\u003c\/p\u003e \u003cp\u003eTravel Programs, Rules, and Factors 385\u003c\/p\u003e \u003cp\u003eTravel Account Example 385\u003c\/p\u003e \u003cp\u003eStar Schemas for Travel 386\u003c\/p\u003e \u003cp\u003ePassenger Transportation Offering Star Schema 386\u003c\/p\u003e \u003cp\u003eFact Table 386\u003c\/p\u003e \u003cp\u003eDimensions 387\u003c\/p\u003e \u003cp\u003eNon-Transportation Travel Product Star Schema 388\u003c\/p\u003e \u003cp\u003eFact Table 388\u003c\/p\u003e \u003cp\u003eDimensions 388\u003c\/p\u003e \u003cp\u003eTravel Summary 389\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9 E-Commerce Models 393\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePeople and Organizations in E-Commerce 395\u003c\/p\u003e \u003cp\u003eE-Commerce Parties, Roles, and Relationships 397\u003c\/p\u003e \u003cp\u003eAutomated Agent Party Subtype 398\u003c\/p\u003e \u003cp\u003eGeneric Party Roles from Volume 1 399\u003c\/p\u003e \u003cp\u003eE-Commerce Party Roles and Relationships 399\u003c\/p\u003e \u003cp\u003eIs There Always a PARTY for a PARTY ROLE? 400\u003c\/p\u003e \u003cp\u003eExample Data for E-Commerce Party Roles and Relationships 400\u003c\/p\u003e \u003cp\u003eParty Contact Mechanisms in E-Commerce 402\u003c\/p\u003e \u003cp\u003eWeb Site Content and User Login Information 405\u003c\/p\u003e \u003cp\u003eWeb Site Content 405\u003c\/p\u003e \u003cp\u003eLogin Account 407\u003c\/p\u003e \u003cp\u003eE-Commerce Products and Objects 408\u003c\/p\u003e \u003cp\u003eOrders in E-Commerce 410\u003c\/p\u003e \u003cp\u003eParty and Product Needs 412\u003c\/p\u003e \u003cp\u003eSubscriptions 414\u003c\/p\u003e \u003cp\u003eWeb Visits 418\u003c\/p\u003e \u003cp\u003eWeb Hits and Web Logs 419\u003c\/p\u003e \u003cp\u003eWeb Visits Model 420\u003c\/p\u003e \u003cp\u003eVISIT Information 422\u003c\/p\u003e \u003cp\u003eSERVER HIT Information 422\u003c\/p\u003e \u003cp\u003eDefining a Visit 423\u003c\/p\u003e \u003cp\u003eDelivery, Work Efforts, Invoicing, Accounting, and Human Resources 426\u003c\/p\u003e \u003cp\u003eWeb Server Hits Star Schema 426\u003c\/p\u003e \u003cp\u003eServer Hit Star Schema 427\u003c\/p\u003e \u003cp\u003eServer Hit Fact 428\u003c\/p\u003e \u003cp\u003eVisitors Dimension 428\u003c\/p\u003e \u003cp\u003eISPS Dimension 429\u003c\/p\u003e \u003cp\u003eReferrers Dimension 429\u003c\/p\u003e \u003cp\u003eWeb Contents Dimension 429\u003c\/p\u003e \u003cp\u003eUser Agent Types Dimension 430\u003c\/p\u003e \u003cp\u003eProducts Dimension 430\u003c\/p\u003e \u003cp\u003eTime by Hour Dimension 430\u003c\/p\u003e \u003cp\u003eWeb Visit Star Schema 431\u003c\/p\u003e \u003cp\u003eE-Commerce Summary 433\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10 Using the Industry Models in the Real World 435\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing the Models to Build Transaction-Oriented Systems and Data Warehouses 436\u003c\/p\u003e \u003cp\u003eEnterprises in Other Industries 437\u003c\/p\u003e \u003cp\u003eRelevance of Models to Very Specific Industries 438\u003c\/p\u003e \u003cp\u003eDiverse Enterprises Needing Models from Several Chapters 438\u003c\/p\u003e \u003cp\u003eSetting Up Modularized Data Models for Use Across Industries 439\u003c\/p\u003e \u003cp\u003eFor More Information 439\u003c\/p\u003e \u003cp\u003eAppendix A Entities and Attributes for Manufacturing Models 443\u003c\/p\u003e \u003cp\u003eEntities and Attributes Listing for Manufacturing 445\u003c\/p\u003e \u003cp\u003eAppendix B Entities and Attributes for Telecommunications Models 453\u003c\/p\u003e \u003cp\u003eEntities and Attributes Listing for Telecommunications Models 454\u003c\/p\u003e \u003cp\u003eAppendix C Entities and Attributes for Health Care Models 463\u003c\/p\u003e \u003cp\u003eEntities and Attributes Listing for Health Care Models 464\u003c\/p\u003e \u003cp\u003eAppendix D Entities and Attributes for Insurance Models 475\u003c\/p\u003e \u003cp\u003eEntities and Attributes Listing for Insurance Models 476\u003c\/p\u003e \u003cp\u003eAppendix E Entities and Attributes for Financial Services Models 487\u003c\/p\u003e \u003cp\u003eEntities and Attributes Listing for Financial Services Models 488\u003c\/p\u003e \u003cp\u003eAppendix F Entities and Attributes for Professional Services Models 497\u003c\/p\u003e \u003cp\u003eEntities and Attributes Listing for Professional Services Models 498\u003c\/p\u003e \u003cp\u003eAppendix G Entities and Attributes for Travel Models 507\u003c\/p\u003e \u003cp\u003eEntities and Attributes Listing for Travel Models 508\u003c\/p\u003e \u003cp\u003eAppendix H Entities and Attributes for E-Commerce Models 519\u003c\/p\u003e \u003cp\u003eEntities and Attributes Listing for E-Commerce Models 520\u003c\/p\u003e \u003cp\u003eAppendix I List of Entities and Their Associated Figures 525\u003c\/p\u003e \u003cp\u003e\u003cb\u003eOther Reusable Data Model and Data Warehouse Design Resources 541\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eReusable Data Model Resources 541\u003c\/p\u003e \u003cp\u003eReusable Data Warehouse Design Resources 542\u003c\/p\u003e \u003cp\u003e\u003cb\u003eHow to Use the Volume 2 Industry Electronic Products 543\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eContents of the Industry Electronic Products 544\u003c\/p\u003e \u003cp\u003eUsing the Scripts 545\u003c\/p\u003e \u003cp\u003eHow to Use the Industry Electronic Products in Conjunction with the Data Model Resource CD-ROM, Volume 1 545\u003c\/p\u003e \u003cp\u003ePlatform-Specific and Other Information on the Electronic Products 545\u003c\/p\u003e \u003cp\u003eIndex 547\u003c\/p\u003e \"I thought the models in the books were well thought out and adequately explained.\" (Computer Shopper, February 2002) \t \u003cp\u003e\u003cb\u003eLEN SILVERSTON\u003c\/b\u003e (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.   \u003c\/p\u003e\u003cp\u003e\u003cb\u003eData Modeling and Design\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003e\u003ci\u003e\"These books are a must for any company implementing data models. They contain practical insights and templates of universal data models which can be used by all enterprises, regardless of their level of experience.\"\u003c\/i\u003e\u003cbr\u003e \u003cb\u003e—Ron Powell, Publisher,\u003c\/b\u003e\u003cb\u003e\u003ci\u003e DM Review\u003c\/i\u003e\u003c\/b\u003e \t \u003c\/p\u003e\u003cp\u003e\u003cb\u003eIf you've relied on The Data Model Resource Book, Revised Edition, Volume 1 (0-471-38023-7) to jump-start your system development efforts, then you know that using a library of proven data models and data warehouse designs can produce huge savings in development costs. But what about the unique needs of your industry?\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003e\u003cb\u003eThe Data Model Resource Book, Revised Edition, Volume 2, provides data models specifically tailored to your industry. It includes both brand-new models for each industry and generic models that the author customizes. The result is a comprehensive library of the industry's core data models and applications, including models for:\u003c\/b\u003e \u003c\/p\u003e\u003cul\u003e \u003cli\u003eFinancial services\u003c\/li\u003e \u003cli\u003eProfessional services\u003c\/li\u003e \u003cli\u003eE-commerce\u003c\/li\u003e \u003cli\u003eManufacturing\u003c\/li\u003e \u003cli\u003eHealth care\u003c\/li\u003e \u003cli\u003eInsurance\u003c\/li\u003e \u003cli\u003eTravel\u003c\/li\u003e \u003cli\u003eTelecommunications\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003cb\u003eYou not only get the data models themselves, you also learn to:\u003c\/b\u003e \u003c\/p\u003e\u003cul\u003e \u003cli\u003eApply reusable data designs across \ta broad variety of industries\u003c\/li\u003e \u003cli\u003eIntegrate databases and data warehouses across your organization\u003c\/li\u003e \u003cli\u003eCombine models from different applications for your specific needs\u003c\/li\u003e \u003c\/ul\u003e  \u003cul\u003e \u003cli\u003eUse the data structures to provide \tquality assurance for your own models\u003c\/li\u003e \u003cli\u003eEmploy the book's star schema \tdesigns to develop data analysis \tsolutions\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003cb\u003eYou can save even more time and money with \u003ci\u003eThe Data Model Resource Book, Revised Edition, Volume 2, CD-ROM,\u003c\/i\u003e which:\u003c\/b\u003e \u003c\/p\u003e\u003cul\u003e \u003cli\u003eProvides the SQL code you'll need to implement the models described in the book or to reverse-engineer them into your CASE tool\u003c\/li\u003e \u003cli\u003eAllows you to view for free the demonstration of data models from both \u003ci\u003eVolume 1\u003c\/i\u003e and \u003ci\u003eVolume 2\u003c\/i\u003e\n\u003c\/li\u003e \u003cli\u003eAllows you to purchase online the downloadable models by industry type—directions inside\u003c\/li\u003e \u003c\/ul\u003e  \"In addition to being an excellent resource for data modelers, this book will help managers, business analysts and architects gain a high level understanding of various industries and integration challenges facing IT professionals. Len's concepts, insights and models provide a valuable contribution to data architecture.\"--Regina Pieper Enterprise Architect, Sun Microsystems\u003cbr\u003e \u003cbr\u003e \"Len Silverston has produced an enormously useful two-volume compendium of generic (but not too generic) data models for an extensive set of typical enterprise subject areas, and for various industries that any data modeler will likely encounter at some point in his or her career. The material is clearly written, well organized, and goes below the obvious to some of the more perverse and difficult information requirements in an enterprise. This is an invaluable resource for doing one's homework before diving into any modeling session; if you can't find it here, there is certainly a very similar template that you can use for just about any situation with which you might be faced.\"-- William G. Smith President, William G. Smith \u0026amp; Associates\u003cbr\u003e \u003cbr\u003e \"In today's fast-paced e-oriented world, it is no longer acceptable to bury business constraints in hard-to-change data structures. Data architects must comprehend complex requirements and recast them into data architecture with vision for unforeseen futures. Len's models provide an outstanding starting point for novice and advanced data architects for delivering flexible data models. These models position an organization for the business rule age. Their proper implementation and customization allows the organization to externalize and manage business policies and rules so that the business can proactively change itself. In this way, the data architecture, based on Len's models and procedures for customizing them, becomes by design the foundation for business change.\"--Barbara von Halle Founder, Knowledge Partners, Inc. Co-author of Handbook of Relational Database Design\u003cbr\u003e \u003cbr\u003e \"These books are long overdue and a must for any company implementing universal data models. They contain practical insights and templates for implementing universal data models and can help all enterprises regardless of their level of experience. Most books address the needs for data models but give little in the way of practical advice. These books fill in that void and should be utilized by all enterprises.\"--Ron Powell Publisher, DM Review\u003cbr\u003e \u003cbr\u003e \"I was first introduced to The Data Model Resource Book three years ago when I was hired by a firm that wanted an enterprise data model. This company did not believe the dictum that \"all companies are basically the same;\" they felt they were somehow unique. After a little analysis with Len Silverston's help, we found that we were actually quite a bit the same: we had customers, accounts, employees, benefits, and all the things you'd find in any corporation. All we had to do was adapt the product component of Len's book and we were ready to move ahead with a great framework for all of our data. A CD-ROM that accompanies the book provided scripts to build the model in Oracle very quickly. We then began mapping all of our detailed data types to the enterprise model and, voila, we could find a place for all of those various spellings and misspellings of Account Number.\u003cbr\u003e \u003cbr\u003e Volume 2 of this revised edition provided even more exciting features: models of industry-specific data. I began to see interesting patterns that permeated this volume. For example, a reservation is a reservation, whether you're an airline, a restaurant, or a hotel. (We even have something similar in the oil industry--the allocation.)\u003cbr\u003e \u003cbr\u003e Another concept from the book that has changed my thinking and vocabulary is the word \"party.\" I recently managed a project in which an employee could also function as a customer and as an on-line computer user. The team was in disagreement regarding a name for this entity; but after checking The Data Model Resource Book, we realized that here we had a party playing three roles.\u003cbr\u003e \u003cbr\u003e Whether your job is to jump-start a data warehouse project or borrow ideas for any subject area in your next operational database, I highly recommend The Data Model Resource Books, Revised Edition, Volumes 1 and 2 as your bible for design.\"--Ted Kowalski Data Architect, Equilon Enterprises LLC Author of Opening Doors: A Facilitator's Handbook","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47990203777253,"sku":"NP9780471353485","price":79.0,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9780471353485.jpg?v=1761786894","url":"https:\/\/k12savings.com\/es\/products\/the-data-model-resource-book-volume-2-isbn-9780471353485","provider":"K12savings","version":"1.0","type":"link"}