Holdings: Measuring data quality for ongoing improvement

Measuring data quality for ongoing improvement: a data quality assessment framework

Saved in:

Bibliographic Details
Main Author:	Sebastian-Coleman, Laura (Author)
Format:	Book
Language:	English
Published:	Amsterdam [u.a.] Elsevier 2013
Subjects:	Informationsqualität Qualitätskontrolle
Online Access:	Inhaltsverzeichnis
Item Description:	Includes bibliographical references and index
Physical Description:	XXXIX, 324 S.
ISBN:	9780123970336

Staff View

MARC


LEADER	00000nam a2200000 c 4500
001	BV040795653
003	DE-604
005	20130326
007	t
008	130305s2013 \|\|\|\| 00\|\|\| eng d
010			\|a 2012039039
020			\|a 9780123970336 \|9 978-0-12-397033-6
035			\|a (OCoLC)835326149
035			\|a (DE-599)GBV733647316
040			\|a DE-604 \|b ger \|e aacr
041	0		\|a eng
049			\|a DE-473 \|a DE-522
084			\|a ST 515 \|0 (DE-625)143677: \|2 rvk
100	1		\|a Sebastian-Coleman, Laura \|e Verfasser \|4 aut
245	1	0	\|a Measuring data quality for ongoing improvement \|b a data quality assessment framework \|c Laura Sebastian-Coleman
264		1	\|a Amsterdam [u.a.] \|b Elsevier \|c 2013
300			\|a XXXIX, 324 S.
336			\|b txt \|2 rdacontent
337			\|b n \|2 rdamedia
338			\|b nc \|2 rdacarrier
500			\|a Includes bibliographical references and index
650	0	7	\|a Informationsqualität \|0 (DE-588)4793947-3 \|2 gnd \|9 rswk-swf
650	0	7	\|a Qualitätskontrolle \|0 (DE-588)4047968-7 \|2 gnd \|9 rswk-swf
689	0	0	\|a Informationsqualität \|0 (DE-588)4793947-3 \|D s
689	0	1	\|a Qualitätskontrolle \|0 (DE-588)4047968-7 \|D s
689	0		\|5 DE-604
856	4	2	\|m Digitalisierung UB Bamberg \|q application/pdf \|u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=025775859&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA \|3 Inhaltsverzeichnis
999			\|a oai:aleph.bib-bvb.de:BVB01-025775859

Record in the Search Index

_version_	1804150130968887296
adam_text	Contents Acknowledgments .............................................................................................................................xxiii Foreword .............................................................................................................................................xxv Author Biography .............................................................................................................................xxvii Introduction: Measuring Data Quality for Ongoing Improvement ....................................................xxix SECTION 1 CONCEPTS AND DEFINITIONS ____________________________ CHAPTER 1 Data .............................................................................................................................3 Purpose ........................................................................................................................3 Data ..............................................................................................................................3 Data as Representation ................................................................................................4 The Implications of Data s Semiotic Function ........................................................6 Semiotics and Data Quality .....................................................................................8 Data as Facts ..............................................................................................................11 Data as a Product .......................................................................................................11 Data as Input to Analyses ..........................................................................................12 Data and Expectations ...............................................................................................13 Information ................................................................................................................14 Concluding Thoughts ................................................................................................15 CHAPTER 2 Data, People, and Systems .............................................................................17 Purpose ......................................................................................................................17 Enterprise or Organization ........................................................................................17 IT and the Business ...................................................................................................18 Data Producers ...........................................................................................................19 Data Consumers .........................................................................................................19 Data Brokers ..............................................................................................................20 Data Stewards and Data Stewardship ........................................................................20 Data Owners ..............................................................................................................21 Data Ownership and Data Governance .....................................................................21 IT, the Business, and Data Owners, Redux ...............................................................22 Data Quality Program Team ......................................................................................23 Stakeholder ................................................................................................................24 Systems and System Design ......................................................................................24 Concluding Thoughts ................................................................................................25 VII VIII Contents CHAPTER 3 Data Management, Models, and Metadata 27 Purpose ...................................................................................................................... Δ Data Management ......................................................................................................27 Database, Data Warehouse, Data Asset, Dataset .......................................................28 Source System, Target System, System of Record ....................................................29 Data Models ...............................................................................................................30 Types of Data Models ................................................................................................31 Physical Characteristics of Data ................................................................................32 Metadata ....................................................................................................................32 Metadataas Explicit Knowledge ...............................................................................35 Data Chain and Information Life Cycle ....................................................................36 Data Lineage and Data Provenance ...........................................................................37 Concluding Thoughts ................................................................................................37 CHAPTER 4 Data Quality and Measurement ....................................................................... 39 Purpose ...................................................................................................................... ЗУ Data Quality ...............................................................................................................39 Data Quality Dimensions ..........................................................................................40 Measurement .............................................................................................................41 Measurement as Data ................................................................................................42 Data Quality Measurement and the Business/IT Divide ...........................................43 Characteristics of Effective Measurements ...............................................................44 Measurements must be Comprehensible and Interpretable ...................................44 Measurements must be Reproducible ....................................................................45 Measurements must be Purposeful ........................................................................46 Data Quality Assessment ...........................................................................................46 Data Quality Dimensions, DQAF Measurement Types, Specific Data Quality Metrics ...............................................................................47 Data Profiling .............................................................................................................49 Data Quality Issues and Data Issue Management .....................................................49 Reasonability Checks ................................................................................................49 Data Quality Thresholds ............................................................................................50 Process Controls ........................................................................................................52 In-line Data Quality Measurement and Monitoring ..................................................53 Concluding Thoughts ................................................................................................53 SECTION 2 DQAF CONCEPTS AND MEASUREMENT TYPES _____________ CHAPTERS DQAF Concepts ......................................................................................... ZZZsn Purpose ......................................................................................................................57 The Problem the DQAF Addresses ...........................................................................57 Contents ix Data Quality Expectations and Data Management ....................................................58 The Scope of the DQAF ............................................................................................60 DQAF Quality Dimensions .......................................................................................61 Completeness .........................................................................................................62 Timeliness ..............................................................................................................62 Validity ..................................................................................................................62 Consistency ............................................................................................................63 Integrity .................................................................................................................63 The Question of Accuracy .....................................................................................63 Defining DQAF Measurement Types ........................................................................64 Metadata Requirements .............................................................................................64 Objects of Measurement and Assessment Categories ...............................................65 Functions in Measurement: Collect, Calculate, Compare .........................................66 Concluding Thoughts ................................................................................................69 CHAPTER 6 DQAF Measurement Types .................................................................................71 Purpose ......................................................................................................................71 Consistency of the Data Model .................................................................................71 Ensuring the Correct Receipt of Data for Processing ................................................72 Inspecting the Condition of Data upon Receipt ........................................................72 Assessing the Results of Data Processing .................................................................74 Assessing the Validity of Data Content .....................................................................74 Assessing the Consistency of Data Content ..............................................................76 Comments on the Placement of In-line Measurements .............................................78 Periodic Measurement of Cross-table Content Integrity ...........................................81 Assessing Overall Database Content .........................................................................82 Assessing Controls and Measurements .....................................................................83 The Measurement Types: Consolidated Listing ........................................................83 Concluding Thoughts ................................................................................................91 SECTION 3 DATA ASSESSMENT SCENARIOS _________________________ CHAPTER 7 Initial Data Assessment .....................................................................................97 Purpose ......................................................................................................................97 Initial Assessment ......................................................................................................97 Input to Initial Assessments .......................................................................................97 Data Expectations ......................................................................................................98 Data Profiling ...........................................................................................................100 Column Property Profiling ......................................................................................100 High-Frequency Values .......................................................................................101 Low-Frequency Values ........................................................................................101 Contents Date Data .............................................................................................................101 Observations about Column Population..............................................................102 Structure Profiling ...................................................................................................105 Incomplete Referential Relationships ..................................................................105 Missing or Unexpected Dependency Relationships and Rules ...........................107 Differences in Granularity and Precision ............................................................108 Relationship Cardinality Different from Expectations ........................................109 Profiling an Existing Data Asset ..............................................................................109 From Profiling to Assessment ..................................................................................1 Ю Deliverables from Initial Assessment ......................................................................110 Concluding Thoughts ..............................................................................................111 CHAPTER 8 Assessment in Data Quality Improvement Projects ................................ из Purpose .................................................................................................................... ИЗ Data Quality Improvement Efforts ..........................................................................113 Measurement in Improvement Projects ...................................................................114 CHAPTER 9 Ongoing Measurement .....................................................................................117 Purpose .................................................................................... 117 The Case for Ongoing Measurement .......................................................................117 Example: Health Care Data ............................................................................119 Inputs for Ongoing Measurement ............................................................................121 Criticality and Risk ......................................................................................123 Automation ................................................ 123 Controls ............................................... 124 Periodic Measurement .................................................... 125 Deliverables from Ongoing Measurement ..............................................................126 In-Line versus Periodic Measurement .....................................................................126 Concluding Thoughts ...................................................... 127 ^ REQUIREMENTS ____________ CHAPTER 10 Requirements, Risk, Criticality ..................................................................... Ш Purpose ...................................... 133 Business Requirements ................................ I33 Data Quality Requirements and Expected Data Characteristics .............................136 Data Quality Requirements and Risks to Data ........................................................139 Factors Influencing Data Criticality ...........................................................140 Specifying Data Quality Metrics ........................................ 141 Subscriber Birth Date Example .................................. ....142 Additional Examples .................................... 146 Concluding Thoughts .................................................................................... I49 Contents xi CHAPTER 11 Asking Questions ............................................................................................... ш Purpose ....................................................................................................................151 Asking Questions .....................................................................................................151 Understanding the Project .......................................................................................152 Learning about Source Systems ..............................................................................153 Source Goals and Source Data Consumers .........................................................154 Source Data Processing .......................................................................................155 Individual Data Attributes and Rules ...................................................................155 Your Data Consumers Requirements .....................................................................156 The Condition of the Data .......................................................................................157 The Data Model, Transformation Rules, and System Design .................................158 Measurement Specification Process ........................................................................158 Concluding Thoughts ..............................................................................................162 SECTION 5 A STRATEGIC APPROACH TO DATA QUALITY _______________ CHAPTER 12 Data Quality Strategy ........................................................................................165 Purpose ....................................................................................................................165 The Concept of Strategy ..........................................................................................165 Systems Strategy, Data Strategy, and Data Quality Strategy ...................................166 Data Quality Strategy and Data Governance ...........................................................168 Decision Points in the Information Life Cycle ........................................................169 General Considerations for Data Quality Strategy ..................................................170 Concluding Thoughts ..............................................................................................171 CHAPTER 13 Directives for Data Quality Strategy ............................................................173 Purpose ....................................................................................................................173 Directive 1: Obtain Management Commitment to Data Quality .............................176 Assessing Management Commitment .................................................................176 Directive 2: Treat Data as an Asset ..........................................................................177 Characterizing an Organization s Data Assets .....................................................178 Directive 3: Apply Resources to Focus on Quality .................................................178 Assessing Readiness to Commission a Data Quality Team ................................179 Directive 4: Build Explicit Knowledge of Data ......................................................180 Assessing the Condition of Explicit Knowledge and Knowledge Sharing ..........................................................................................180 Directive 5: Treat Data as a Product of Processes that can be Measured and Improved ......................................................................................181 Assessing Organizational Understanding of Data as a Product ..........................182 Directive 6: Recognize Quality is Defined by Data Consumers .............................182 Assessing How Data Consumers Define Data Quality ........................................183 xii Contents Directive 7: Address the Root Causes of Data Problems ........................................184 Assessing Organizational Ability to Address Root Causes .................................186 Directive 8: Measure Data Quality, Monitor Critical Data .....................................186 Assessing Organizational Readiness for Ongoing Measurement and Monitoring .......................................................................................................187 Directive 9: Hold Data Producers Accountable for the Quality of their Data (and Knowledge about that Data) ........................................................................188 Assessing Options for Accountability .................................................................188 Directive 10: Provide Data Consumers with the Knowledge they Require for Data Use ...........................................................................................189 Directive 11 : Data Needs and Uses will Evolve — Plan for Evolution ....................189 Developing a Plan for Evolution .........................................................................190 Directive 12: Data Quality Goes beyond the Data — Build a Culture Focused on Quality ............................................................................................................191 Building a Culture Focused on Data Quality ......................................................191 Concluding Thoughts: Using the Current State Assessment ...................................192 SECTION 6 THE DQAF IN DEPTH CHAPTER 14 Functions of Measurement: Collection, Calculation, Comparison ...197 Purpose .................................................................................................... 197 Functions in Measurement: Collect, Calculate, Compare .......................................197 Collecting Raw Measurement Data ............................................... 199 Calculating Measurement Data .............................................. I99 Comparing Measurements to Past History ..............................................................201 Statistics ............................................ 201 Measures of Central Tendency ............................................... 202 Measures of Variability ...................................................... 202 The Control Chart: A Primary Tool for Statistical Process Control ........................205 The DQAF and Statistical Process Control .............................................................206 Concluding Thoughts .......................................... 207 CHAPTER 15 Features of the DQAF Measurement Logical Model ....... 209 PurPose .................................................................................................................... 209 Metric Definition and Measurement Result Tables ............................... 209 Common Key Fields .......................................... 21 1 Optional Fields ............................................. .................................... 2i2 Denominator Fields ................................ 2i τ. Automated Thresholds ..................................... ...................................215 Manual Thresholds ......................................... .....................................216 Emergency Thresholds ....................................... ...............................216 Contents xiii Manual or Emergency Thresholds and Results Tables ............................................217 Additional System Requirements ............................................................................217 Support Requirements .............................................................................................218 Concluding Thoughts ..............................................................................................218 CHAPTER 16 Facets of the DQAF Measurement Types ....................................................219 Purpose ....................................................................................................................219 Facets of the DQAF .................................................................................................219 Organization of the Chapter ....................................................................................221 Measurement Type #1: Dataset Completeness — Sufficiency of Metadata and Reference Data ..............................................................................................224 Definition .............................................................................................................224 Business Concerns ...............................................................................................224 Measurement Methodology .................................................................................224 Programming .......................................................................................................225 Support Processes and Skills ...............................................................................225 Measurement Type #2: Consistent Formatting in One Field ...................................225 Definition .............................................................................................................225 Business Concerns ...............................................................................................226 Measurement Methodology .................................................................................226 Programming .......................................................................................................226 Support Processes and Skills ...............................................................................226 Measurement Type #3: Consistent Formatting, Cross-table ....................................227 Definition .............................................................................................................227 Business Concerns ...............................................................................................227 Measurement Methodology .................................................................................227 Programming .......................................................................................................227 Support Processes and Skills ...............................................................................227 Measurement Type #4: Consistent Use of Default Value in One Field ...................227 Definition .............................................................................................................227 Business Concerns ...............................................................................................228 Measurement Methodology .................................................................................228 Programming .......................................................................................................228 Support Processes and Skills ...............................................................................228 Measurement Type #5: Consistent Use of Default Values, Cross-table ..................228 Definition .............................................................................................................228 Business Concerns ...............................................................................................229 Measurement Methodology .................................................................................229 Programming .......................................................................................................229 Support Processes and Skills ...............................................................................229 xiv Contents Measurement Type #6: Timely Delivery of Data for Processing ............................229 Definition ............................................................................................................. 229 999 Business Concerns ............................................................................................... Measurement Methodology ................................................................................. 240 Programming ....................................................................................................... Support Processes and Skills ............................................................................... Measurement Logical Data Model ...................................................................... 231 Measurement Type #7: Dataset Completeness—Availability for Processing .........232 Definition ............................................................................................................. 232 949 Business Concerns ............................................................................................... ^ 914 Measurement Methodology ................................................................................. ¿D 944 Programming ....................................................................................................... i >J 944 Support Processes and Skills ............................................................................... Ĺ3° Measurement Type #8: Dataset Completeness — Record Counts to Control Records ................................................................................................... 233 Definition ............................................................................................................. 233 Business Concerns ...............................................................................................234 Measurement Methodology .................................................................................234 Programming .......................................................................................................234 Support Processes and Skills ...............................................................................234 Measurement Type #9: Dataset Completeness — Summarized Amount Field Data ..............................................................................................234 Definition .............................................................................................................234 Business Concerns ...............................................................................................234 Measurement Methodology .................................................................................235 Programming .......................................................................................................235 Support Processes and Skills ...............................................................................235 Measurement Type #10: Dataset Completeness — Size Compared to Past Sizes .............................................................................................................235 Definition .............................................................................................................235 Business Concerns ...............................................................................................235 Measurement Methodology .................................................................................236 Programming .......................................................................................................236 Support Processes and Skills ...............................................................................236 Measurement Logical Data Model ......................................................................236 Measurement Type #11 : Record Completeness — Length .......................................237 Definition .............................................................................................................237 Business Concerns ...............................................................................................237 Measurement Methodology .................................................................................237 Programming .......................................................................................................238 Support Processes and Skills ...............................................................................238 Contents xv Measurement Type #12: Field Completeness — Non-Nullable Fields .....................238 Definition .............................................................................................................238 Business Concerns ...............................................................................................238 Measurement Methodology .................................................................................238 Programming .......................................................................................................238 Support Processes and Skills ...............................................................................239 Measurement Type #13: Dataset Integrity — De-Duplication ..................................239 Definition .............................................................................................................239 Business Concerns ...............................................................................................239 Measurement Methodology .................................................................................239 Programming .......................................................................................................239 Support Processes and Skills ...............................................................................239 Measurement Type #14: Dataset Integrity — Duplicate Record Reasonability Check ............................................................................................240 Definition .............................................................................................................240 Business Concerns ...............................................................................................240 Measurement Methodology .................................................................................240 Programming .......................................................................................................240 Support Processes and Skills ...............................................................................240 Measurement Logical Data Model ......................................................................241 Measurement Type #15: Field Content Completeness — Defaults from Source .........................................................................................................241 Definition .............................................................................................................241 Business Concerns ...............................................................................................242 Measurement Methodology .................................................................................242 Programming .......................................................................................................242 Support Processes and Skills ...............................................................................243 Measurement Logical Data Model ......................................................................243 Measurement Type #16: Dataset Completeness Based on Date Criteria ................244 Definition .............................................................................................................244 Business Concerns ...............................................................................................244 Measurement Methodology .................................................................................244 Programming .......................................................................................................244 Support Processes and Skills ...............................................................................244 Measurement Type #17: Dataset Reasonability Based on Date Criteria .................245 Definition .............................................................................................................245 Business Concerns ...............................................................................................245 Measurement Methodology .................................................................................245 Programming .......................................................................................................245 Support Processes and Skills ...............................................................................245 Measurement Logical Data Model ......................................................................245 xvi Contents Measurement Type #18: Field Content Completeness — Received Data is Missing Fields Critical to Processing ......................................................247 Definition .............................................................................................................247 Business Concerns ...............................................................................................247 Measurement Methodology .................................................................................247 Programming .......................................................................................................247 Support Processes and Skills ...............................................................................247 Measurement Type #19: Dataset Completeness — Balance Record Counts Through a Process ...................................................................................248 Definition .............................................................................................................248 Business Concerns ...............................................................................................248 Measurement Methodology .................................................................................248 Programming .......................................................................................................248 Support Processes and Skills ...............................................................................249 Measurement Type #20: Dataset Completeness — Reasons for Rejecting Records ................................................................................................249 Definition .............................................................................................................249 Business Concerns ...............................................................................................249 Measurement Logical Data Model ......................................................................249 Measurement Type #21: Dataset Completeness Through a Process- Ratio of Input to Output ......................................................................................250 Definition .............................................................................................................250 Business Concerns ...............................................................................................250 Measurement Methodology .................................................................................251 Programming .......................................................................................................251 Support Processes and Skills ...............................................................................251 Measurement Logical Data Model ......................................................................251 Measurement Type #22: Dataset Completeness Through a Process- Balance Amount Fields ........................................................................................251 Definition .............................................................................................................251 Business Concerns ...............................................................................................252 Measurement Methodology .................................................................................252 Programming ......................................................... ....253 Support Processes and Skills ...............................................................................253 Measurement Type #23: Field Content Completeness—Ratio of Summed Amount Fields ......................................................................................253 Definition ......................................................... 253 Business Concerns ................................................................ 253 Measurement Methodology ............................................ 253 Programming .......................................................... 254 Contents xvii Support Processes and Skills ...............................................................................254 Measurement Logical Data Model ......................................................................255 Measurement Type #24: Field Content Completeness — Defaults from Derivation ............................................................................................................255 Definition .............................................................................................................255 Business Concerns ...............................................................................................255 Measurement Methodology .................................................................................256 Programming .......................................................................................................256 Support Processes and Skills ...............................................................................256 Measurement Logical Data Model ......................................................................256 Measurement Type #25: Data Processing Duration ................................................257 Definition .............................................................................................................257 Business Concerns ...............................................................................................257 Measurement Methodology .................................................................................257 Programming .......................................................................................................258 Support Processes and Skills ...............................................................................258 Measurement Logical Data Model ......................................................................258 Measurement Type #26: Timely Availability of Data for Access ............................259 Definition .............................................................................................................259 Business Concerns ...............................................................................................259 Measurement Methodology .................................................................................260 Programming .......................................................................................................260 Support Processes and Skills ...............................................................................260 Measurement Logical Data Model ......................................................................260 Measurement Type #27: Validity Check, Single Field, Detailed Results ................261 Definition .............................................................................................................261 Business Concerns ...............................................................................................261 Measurement Methodology .................................................................................261 Programming .......................................................................................................262 Support Processes and Skills ...............................................................................263 Measurement Logical Data Model ......................................................................263 Measurement Type #28: Validity Check, Roll-up ...................................................264 Definition .............................................................................................................264 Business Concerns ...............................................................................................264 Measurement Methodology .................................................................................265 Programming .......................................................................................................265 Support Processes and Skills ...............................................................................265 Measurement Logical Data Model ..........................................................................265 Measurement Type #29: Validity Check, Multiple Columns within a Table, Detailed Results ..........................................................................266 xviii Contents Definition............................................................................................................. Business Concerns ............................................................................................... Measurement Methodology................................................................................. _ . ........267 Programming ........................................................................................... Support Processes and Skills ............................................................................... Measurement Logical Data Model ...................................................................... Measurement Type #30: Consistent Column Profile ............................................... 267 Definition ............................................................................................................. 269 Business Concerns ............................................................................................... 269 Measurement Methodology ................................................................................. 269 Programming ....................................................................................................... Support Processes and Skills ............................................................................... 2 Measurement Logical Data Model ...................................................................... Measurement Type #31: Consistent Dataset Content, Distinct Count of Represented Entity, with Ratios to Record Counts .............................................270 Definition ............................................................................................................. 270 271 Business Concerns ............................................................................................... 271 Measurement Methodology ................................................................................. 971 Programming ....................................................................................................... Support Processes and Skills ............................................................................... 27 Measurement Logical Data Model ...................................................................... ¿ Measurement Type #32 Consistent Dataset Content, Ratio of Distinct Counts of Two Represented Entities ................................................................... 2 Definition ............................................................................................................. 272 Business Concerns ............................................................................................... 2 Measurement Methodology ................................................................................. 27* Programming ....................................................................................................... Support Processes and Skills ............................................................................... Measurement Logical Data Model ...................................................................... Measurement Type #33: Consistent Multicolumn Profile ....................................... Definition ............................................................................................................. 274 Business Concerns ............................................................................................... Measurement Methodology ................................................................................. Programming ....................................................................................................... Support Processes and Skills ............................................................................... Measurement Logical Data Model ...................................................................... Measurement Type #34: Chronology Consistent with Business Rules within a Table ......................................................................................................277 Definition ............................................................................................................. 277 Business Concerns ...............................................................................................278 Contents xix Other Facets .........................................................................................................278 Measurement Type #35: Consistent Time Elapsed (hours, days, months, etc.) ......279 Definition .............................................................................................................279 Business Concerns ...............................................................................................279 Measurement Methodology .................................................................................279 Programming .......................................................................................................279 Support Processes and Skills ...............................................................................280 Measurement Logical Data Model ......................................................................280 Measurement Type #36: Consistent Amount Field Calculations Across Secondary Fields .................................................................................................281 Definition .............................................................................................................281 Business Concerns ...............................................................................................281 Measurement Methodology .................................................................................282 Programming .......................................................................................................282 Support Processes and Skills ...............................................................................282 Measurement Logical Data Model ......................................................................283 Measurement Type #37: Consistent Record Counts by Aggregated Date ...............284 Definition .............................................................................................................284 Business Concerns ...............................................................................................284 Measurement Methodology .................................................................................285 Programming .......................................................................................................285 Support Processes and Skills ...............................................................................285 Measurement Logical Data Model ......................................................................286 Measurement Type #38: Consistent Amount Field Data by Aggregated Date ........286 Definition .............................................................................................................286 Business Concerns ...............................................................................................287 Measurement Methodology .................................................................................287 Programming .......................................................................................................287 Support Processes and Skills ...............................................................................287 Measurement Logical Data Model ......................................................................288 Measurement Type #39: Parent/Child Referential Integrity ....................................288 Definition .............................................................................................................288 Business Concerns ...............................................................................................289 Measurement Methodology .................................................................................289 Programming .......................................................................................................289 Support Processes and Skills ...............................................................................290 Measurement Type #40: Child/Parent Referential Integrity ....................................290 Definition .............................................................................................................290 Business Concerns ...............................................................................................290 Measurement Methodology .................................................................................290 xx Contents 1ПЛ Programming ....................................................................................................... *·™ Support Processes and Skills ............................................................................... ¿yv Measurement Type #41: Validity Check, Cross Table, Detailed Results .................291 Definition .............................................................................................................291 Business Concerns ...............................................................................................291 Measurement Methodology .................................................................................291 Programming .......................................................................................................291 Support Processes and Skills ...............................................................................291 Measurement Type #42: Consistent Cross-table Multicolunm Profile ....................292 Definition ............................................................................................................. 292 Business Concerns ...............................................................................................292 Measurement Methodology .................................................................................292 Programming .......................................................................................................292 Support Processes and Skills ...............................................................................293 Measurement Type #43: Chronology Consistent with Business Rules Across-tables .............................................................................................293 Definition .............................................................................................................293 Business Concerns ...............................................................................................293 Measurement Methodology and Programming ...................................................293 Support Processes and Skills ...............................................................................293 Measurement Type #44: Consistent Cross-table Amount Column Calculations ....293 Definition .............................................................................................................293 Business Concerns ...............................................................................................294 Measurement Methodology .................................................................................294 Programming .......................................................................................................294 Support Processes and Skills ...............................................................................294 Measurement Type #45: Consistent Cross-Table Amount Columns by Aggregated Dates ................................................................................................294 Definition .............................................................................................................294 Business Concerns ...............................................................................................295 Measurement Methodology .................................................................................295 Programming .......................................................................................................295 Support Processes and Skills ...............................................................................295 Measurement Type #46: Consistency Compared to External Benchmarks .............295 Definition .............................................................................................................295 Business Concerns ...............................................................................................296 Measurement Methodology .................................................................................296 Programming .......................................................................................................296 Support Processes and Skills ...............................................................................296 Measurement Type #47: Dataset Completeness — Overall Sufficiency for Defined Purposes ...........................................................................................296 Contents xxi Definition.............................................................................................................296 Business Concerns ...............................................................................................296 Measurement Methodology................................................................................. 297 Programming.......................................................................................................297 Support Processes and Skills ...............................................................................297 Measurement Type #48: Dataset Completeness — Overall Sufficiency of Measures and Controls ........................................................................................297 Definition .............................................................................................................297 Business Concerns ...............................................................................................297 Measurement Methodology .................................................................................298 Programming .......................................................................................................298 Support Processes and Skills ...............................................................................298 Concluding Thoughts: Know Your Data ..................................................................298 Glossary ..............................................................................................................................................301 Bibliography .......................................................................................................................................313 Index ...................................................................................................................................................319 Online Materials: Appendix A: Measuring the Value of Data doi: 10.101 6/B978-0-1 2-397033-6.00028-6.................................................................... el Appendix B: Data Quality Dimensions doi:10.1016/B978-0-12-397033-6.00029-8 .................................................................... e5 Appendix C: Completeness, Consistency, and Integrity of the Data Model doi:10.1016/B978-0-12-397033-6.00030-4 .................................................................. ell Appendix D: Prediction, Error, and Shewhart s Lost Disciple, Kristo Ivanov doi:10.1016/B978-0-12-397033-6.00031-6 .................................................................. e21 Appendix E: Quality Improvement and Data Quality doi: 1O.1016/B978-0-12-397033-6.OO013-4 .................................................................. e27
any_adam_object	1
author	Sebastian-Coleman, Laura
author_facet	Sebastian-Coleman, Laura
author_role	aut
author_sort	Sebastian-Coleman, Laura
author_variant	l s c lsc
building	Verbundindex
bvnumber	BV040795653
classification_rvk	ST 515
ctrlnum	(OCoLC)835326149 (DE-599)GBV733647316
discipline	Informatik
format	Book
fullrecord	<?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01444nam a2200361 c 4500</leader><controlfield tag="001">BV040795653</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20130326 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">130305s2013 \|\|\|\| 00\|\|\| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2012039039</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780123970336</subfield><subfield code="9">978-0-12-397033-6</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)835326149</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)GBV733647316</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-473</subfield><subfield code="a">DE-522</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 515</subfield><subfield code="0">(DE-625)143677:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Sebastian-Coleman, Laura</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Measuring data quality for ongoing improvement</subfield><subfield code="b">a data quality assessment framework</subfield><subfield code="c">Laura Sebastian-Coleman</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Amsterdam [u.a.]</subfield><subfield code="b">Elsevier</subfield><subfield code="c">2013</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXXIX, 324 S.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes bibliographical references and index</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Informationsqualität</subfield><subfield code="0">(DE-588)4793947-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Qualitätskontrolle</subfield><subfield code="0">(DE-588)4047968-7</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Informationsqualität</subfield><subfield code="0">(DE-588)4793947-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Qualitätskontrolle</subfield><subfield code="0">(DE-588)4047968-7</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Bamberg</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=025775859&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-025775859</subfield></datafield></record></collection>
id	DE-604.BV040795653
illustrated	Not Illustrated
indexdate	2024-07-10T00:34:02Z
institution	BVB
isbn	9780123970336
language	English
lccn	2012039039
oai_aleph_id	oai:aleph.bib-bvb.de:BVB01-025775859
oclc_num	835326149
open_access_boolean
owner	DE-473 DE-BY-UBG DE-522
owner_facet	DE-473 DE-BY-UBG DE-522
physical	XXXIX, 324 S.
publishDate	2013
publishDateSearch	2013
publishDateSort	2013
publisher	Elsevier
record_format	marc
spelling	Sebastian-Coleman, Laura Verfasser aut Measuring data quality for ongoing improvement a data quality assessment framework Laura Sebastian-Coleman Amsterdam [u.a.] Elsevier 2013 XXXIX, 324 S. txt rdacontent n rdamedia nc rdacarrier Includes bibliographical references and index Informationsqualität (DE-588)4793947-3 gnd rswk-swf Qualitätskontrolle (DE-588)4047968-7 gnd rswk-swf Informationsqualität (DE-588)4793947-3 s Qualitätskontrolle (DE-588)4047968-7 s DE-604 Digitalisierung UB Bamberg application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=025775859&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis
spellingShingle	Sebastian-Coleman, Laura Measuring data quality for ongoing improvement a data quality assessment framework Informationsqualität (DE-588)4793947-3 gnd Qualitätskontrolle (DE-588)4047968-7 gnd
subject_GND	(DE-588)4793947-3 (DE-588)4047968-7
title	Measuring data quality for ongoing improvement a data quality assessment framework
title_auth	Measuring data quality for ongoing improvement a data quality assessment framework
title_exact_search	Measuring data quality for ongoing improvement a data quality assessment framework
title_full	Measuring data quality for ongoing improvement a data quality assessment framework Laura Sebastian-Coleman
title_fullStr	Measuring data quality for ongoing improvement a data quality assessment framework Laura Sebastian-Coleman
title_full_unstemmed	Measuring data quality for ongoing improvement a data quality assessment framework Laura Sebastian-Coleman
title_short	Measuring data quality for ongoing improvement
title_sort	measuring data quality for ongoing improvement a data quality assessment framework
title_sub	a data quality assessment framework
topic	Informationsqualität (DE-588)4793947-3 gnd Qualitätskontrolle (DE-588)4047968-7 gnd
topic_facet	Informationsqualität Qualitätskontrolle
url	http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=025775859&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA
work_keys_str_mv	AT sebastiancolemanlaura measuringdataqualityforongoingimprovementadataqualityassessmentframework

Holdings

There is no print copy available.

Interlibrary loan Place Request Caution: Not in THWS collection! Indexes

MARC

Record in the Search Index

There is no print copy available.

Similar Items