Microsoft SQL Server 2008 R2 master data services [[electronic resource] ] : manage and maintain your organization's master data effectively with Microsoft SQL Server 2008 R2 master data services / / Jeremy Kashel, Tim Kent, Martyn Bullerwell |
Autore | Kashel Jeremy |
Pubbl/distr/stampa | Olton, Birmingham, U.K., : Packt Pub., 2011 |
Descrizione fisica | 1 online resource (360 p.) |
Disciplina |
005.75/65
005.7565 |
Altri autori (Persone) |
KentTimothy J
BullerwellMartyn |
Collana | Professional Expertise Distilled |
Soggetto topico | Database management |
Soggetto genere / forma | Electronic books. |
ISBN |
1-283-30831-2
9786613308313 1-84968-051-5 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Copyright; Credits; Foreword; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Master Data Management; Master data; The need for Master Data Management; Manual updates; Different descriptions for the same attributes; Mergers and acquisitions; Master Data Management overview; Data quality; Operational and analytical Master Data Management; Analytical MDM; Operational MDM; Different approaches to Master Data Management; Transaction Hub; Registry; Hybrid; Data governance; Data stewardship; Politics and organizational changes; Summary
ReferencesChapter 2: Master Data Services Overview; Master Data Services overview; Master Data Services architecture; MDS SQL Server database; Internet Information Services (IIS); Master Data Manager; Accessing Master Data Manager; Explorer; Version Management; Integration Management; System Administration; User and Group Permissions; Summary; Chapter 3: Installing and Configuring Master Data Services; Planning for a Master Data Services installation; Server topology; Database service account; Administrator account; Installing Master Data Services; Master Data Services Configuration Manager Configuring Master Data Services for the first timeDatabase creation; Database settings; Web configuration; Installing sample models; Summary; Chapter 4: Creating and Using Models; MDS object model overview; Models; Entities and attributes; Attributes; Domain attributes and relationships between entities; Creating an entity; Editing an entity; Members; The Master Data Manager Explorer; Adding a member; Editing a member; Deleting members; Annotating members; Transactions; Attribute Groups; Creating Attribute Groups; Using Attribute Groups; Hierarchies; Derived Hierarchies Exploring Derived HierarchiesAdding a member in a Derived Hierarchy; Explicit Hierarchies; Creating an Explicit Hierarchy; Consolidated members; Moving hierarchy members; Collections; Creating a collection; Master Data Services Metadata; Altering the default MDS Metadata; Viewing Metadata; User-defined Metadata; Summary; Chapter 5: Version Management; Introduction to versions; The need for versions; The version interface; Version status; Creating and managing versions; Copying a version; Managing versions; Using versions; Validating versions; Member validation status; Validating a version Locking, unlocking, and committing versionsNotifications; Locking versions; Unlocking versions; Committing versions; Managing Flags; Transactions; Summary; Chapter 6: Importing Data into Master Data Services; The staging load process; Introduction; Staging tables; Data import security; Populating MDS step 1-populating the staging tables; Creating new members; Creating new collections; Adding members to collections; Updating member attributes; Deleting a member (or collection); Populating MDS step 2-invoking the staging process; Populating MDS step 3-validating the model Clearing the staging tables |
Record Nr. | UNINA-9910456967403321 |
Kashel Jeremy
![]() |
||
Olton, Birmingham, U.K., : Packt Pub., 2011 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Microsoft SQL Server 2008 R2 master data services [[electronic resource] ] : manage and maintain your organization's master data effectively with Microsoft SQL Server 2008 R2 master data services / / Jeremy Kashel, Tim Kent, Martyn Bullerwell |
Autore | Kashel Jeremy |
Pubbl/distr/stampa | Olton, Birmingham, U.K., : Packt Pub., 2011 |
Descrizione fisica | 1 online resource (360 p.) |
Disciplina |
005.75/65
005.7565 |
Altri autori (Persone) |
KentTimothy J
BullerwellMartyn |
Collana | Professional Expertise Distilled |
Soggetto topico | Database management |
ISBN |
1-283-30831-2
9786613308313 1-84968-051-5 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Copyright; Credits; Foreword; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Master Data Management; Master data; The need for Master Data Management; Manual updates; Different descriptions for the same attributes; Mergers and acquisitions; Master Data Management overview; Data quality; Operational and analytical Master Data Management; Analytical MDM; Operational MDM; Different approaches to Master Data Management; Transaction Hub; Registry; Hybrid; Data governance; Data stewardship; Politics and organizational changes; Summary
ReferencesChapter 2: Master Data Services Overview; Master Data Services overview; Master Data Services architecture; MDS SQL Server database; Internet Information Services (IIS); Master Data Manager; Accessing Master Data Manager; Explorer; Version Management; Integration Management; System Administration; User and Group Permissions; Summary; Chapter 3: Installing and Configuring Master Data Services; Planning for a Master Data Services installation; Server topology; Database service account; Administrator account; Installing Master Data Services; Master Data Services Configuration Manager Configuring Master Data Services for the first timeDatabase creation; Database settings; Web configuration; Installing sample models; Summary; Chapter 4: Creating and Using Models; MDS object model overview; Models; Entities and attributes; Attributes; Domain attributes and relationships between entities; Creating an entity; Editing an entity; Members; The Master Data Manager Explorer; Adding a member; Editing a member; Deleting members; Annotating members; Transactions; Attribute Groups; Creating Attribute Groups; Using Attribute Groups; Hierarchies; Derived Hierarchies Exploring Derived HierarchiesAdding a member in a Derived Hierarchy; Explicit Hierarchies; Creating an Explicit Hierarchy; Consolidated members; Moving hierarchy members; Collections; Creating a collection; Master Data Services Metadata; Altering the default MDS Metadata; Viewing Metadata; User-defined Metadata; Summary; Chapter 5: Version Management; Introduction to versions; The need for versions; The version interface; Version status; Creating and managing versions; Copying a version; Managing versions; Using versions; Validating versions; Member validation status; Validating a version Locking, unlocking, and committing versionsNotifications; Locking versions; Unlocking versions; Committing versions; Managing Flags; Transactions; Summary; Chapter 6: Importing Data into Master Data Services; The staging load process; Introduction; Staging tables; Data import security; Populating MDS step 1-populating the staging tables; Creating new members; Creating new collections; Adding members to collections; Updating member attributes; Deleting a member (or collection); Populating MDS step 2-invoking the staging process; Populating MDS step 3-validating the model Clearing the staging tables |
Record Nr. | UNINA-9910781686203321 |
Kashel Jeremy
![]() |
||
Olton, Birmingham, U.K., : Packt Pub., 2011 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|