Data Quality: The Accuracy Dimension
An informative resource for any data management staff, IT management staff, and CIOs of companies with data assets.
TABLE OF CONTENTS Data Quality: The Accuracy Dimension
Appendix A: Examples of Column Properties, Data Structure, Data Rules, and Value Rules
This appendix demonstrates definitions of column properties, data structure, data rules, and value rules over a sample database. The information shown is not intended to be exhaustive, just representative. This is not a real database definition; it was invented to demonstrate principles in this book.
A.1 Business Objects
The business objects in this example include INVENTORY data, SUPPLIER data, and PURCHASE_ORDER data. The inventory business object records the current state of parts in the corporation's warehouses. These are parts needed for manufacturing, as well as parts needed for operation of the business. Each part in the inventory has current status information, as well as history information.
The supplier business object describes companies from which parts are acquired. This includes the subject corporation as well: parts that are manufactured internally. It includes information about the supplier, as well as ordering and invoicing information.
The purchase order business object records each order of parts from a supplier. It tracks the order from inception through delivery to the inventory warehouse.
A.2 Tables
The following table definitions exist for these business objects. Figure A.1 shows a diagram of the integration points between them.
Figure A.I: Table diagram.
Each part in inventory has a master inventory row in the INVENTORY table and one row in the INVENTORY_HISTORY table for every calendar quarter the part has been carried in inventory.
| INVENTORY | |
| PART_NUMBER | CHARACTER(8) |
| DESCRIPTION | CHARACTER(20) |
| TYPE | CHARACTER(1) |
| UNIT_OF_MEASURE | CHARACTER(3) |
| QUANTITY_ONHAND | INTEGER |
| QUANTITY_ONORDER | INTEGER |
| ENG_DRAWING_NUM | NUMBER(9) |
| INVENTORY_PRICE | MONEY |
| LAST_PURCHASE_PRICE | MONEY |
| DATE_LAST_RECEIVED | DATE |
| LAST_PURCHASE_ORDER | NUMBER(8) |
| DO_NOT_ORDER_FLAG | CHARACTER(1) |
Copyright Elsevier Science (USA) 2003 under license agreement with Books24x7
