05222nam 2200625 450 991080743870332120230803200037.01-58347-844-21-58347-847-7(CKB)2670000000584745(EBL)1884558(SSID)ssj0001432554(PQKBManifestationID)11778772(PQKBTitleCode)TC0001432554(PQKBWorkID)11405861(PQKB)10971035(MiAaPQ)EBC1884558(Au-PeEL)EBL1884558(CaPaEBR)ebr10996877(CaONFJC)MIL676467(OCoLC)913556562(EXLCZ)99267000000058474520150108h20142014 uy 0engur|n|---|||||txtccrData governance tools evaluation criteria, big data governance, and alignment with enterprise data management. /Sunil SoaresBoise, Idaho :MC Press Online, LLC,2014.©20141 online resource (453 p.)Includes index.1-322-45185-0 1-58347-845-0 Cover; Title Page; Copyright; About the Author; Contents; Forewords; By Aditya Kongara; By John R. Talburt; By Aaron Zornes; Preface; Part I-Introduction; 1: An Introduction to Data Governance; Definition; Case Study; The Pillars of Data Governance; Summary; 2: Enterprise Data Management Reference Architecture; Edm Categories; Big Data; Data Governance Tools; Summary; Part II-Categories of Data Governance Tools; 3: The Business Glossary; Bulk-load Business Terms in Excel, CSV, or XML Format; Create Categories of Business Terms; Facilitate Social CollaborationAutomatically Hyperlink Embedded Business TermsAdd Custom Attributes to Business Terms and Other Data Artifacts; Add Custom Relationships to Business Terms and Other Data Artifacts; Add Custom Roles to Business Terms and Other Data Artifacts; Link Business Terms and Column Names to the Associated Reference Data; Link Business Terms to Technical Metadata; Support the Creation of Custom Asset Types; Flag Critical Data Elements; Provide OOTB and Custom Workflows to Manage Business Terms and Other Data Artifacts; Review the History of Changes to Business Terms and Other Data ArtifactsAllow Business Users to Link to the Glossary Directly From Reporting ToolsSearch for Business Terms; Integrate Business Terms with Associated Unstructured Data; Summary; 4: Metadata Management; Pull Logical Models From Data Modeling Tools; Pull Physical Models From Data Modeling Tools; Ingest Metadata From Relational Databases; Pull in Metadata From Data Warehouse Appliances; Integrate Metadata From Legacy Data Sources; Pull Metadata From ETL Tools; Pull Metadata From Reporting Tools; Reflect Custom Code in the Metadata Tool; Pull Metadata From Analytics ToolsLink Business Terms with Column NamesPull Metadata From Data Quality Tools; Pull Metadata From Big Data Sources; Provide Detailed Views on Data Lineage; Customize Data Lineage Reporting; Manage Permissions in the Metadata Repository; Support the Search for Assets in the Metadata Repository; Summary; 5: Data Profiling; Conduct Column Analysis; Discover the Values Distribution of a Column; Discover the Patterns Distribution of a Column; Discover the Length Frequencies of a Column; Discover Hidden Sensitive Data; Discover Values with Similar Sounds in a ColumnAgree on the Data Quality Dimensions for the Data Governance ProgramDevelop Business Rules Relating to the Data Quality Dimensions; Profile Data Relating to the Completeness Dimension of Data Quality; Profile Data Relating to the Conformity Dimension of Data Quality; Profile Data Relating to the Consistency Dimension of Data Quality; Profile Data Relating to the Synchronization Dimension of Data Quality; Profile Data Relating to the Uniqueness Dimension of Data Quality; Profile Data Relating to the Timeliness Dimension of Data QualityProfile Data Relating to the Accuracy Dimension of Data QualityData governance programs often start off using programs such as Microsoft Excel and Microsoft SharePoint to document and share data governance artifacts. But these tools often lack critical functionality. Meanwhile, vendors have matured their data governance offerings to the extent that today's organizations need to consider tools as a critical component of their data governance programs. In this book, data governance expert Sunil Soares reviews the Enterprise Data Management (EDM) reference architecture and discusses key data governance tasks that can be automated by tools for business glossaInformation technologyManagementDatabase managementComputer programsInformation technologyManagement.Database managementComputer programs.658.4038Soares Sunil1646488MiAaPQMiAaPQMiAaPQBOOK9910807438703321Data governance tools4120696UNINA