Knowledge

Reference data

Source 📝

81:. While both provide context for business transactions, reference data is concerned with classification and categorisation, while master data is concerned with business entities. A further difference between reference data and master data is that a change to the reference data values may require an associated change in 94:
For most organisations, most or all reference data is defined and managed within that organisation. Some reference data, however, may be externally defined and managed, for example by standards organizations. An example of externally-defined reference data is the set of country codes as defined in
107:
Curating and managing reference data is key to ensuring its quality and thus fitness for purpose. All aspects of an organisation, operational and analytical, are greatly dependent on the quality of an organization's reference data. Without consistency across business process or applications, for
85:
to support the change, while a change in master data will always be managed as part of existing business processes. For example, adding a new customer or sales product is part of the standard business process. However, adding a new product classification (e.g. "restricted sales item") or a new
347: 108:
example, similar things may be described in quite different ways. Reference data gain in value when they are widely re-used and widely referenced.
294: 240: 86:
customer type (e.g. "gold level customer") will result in a modification to the business processes to manage those items.
277: 199: 17: 414: 376: 74:
Reference data sets are sometimes alternatively referred to as a "controlled vocabulary" or "lookup" data.
355: 269: 191: 30:
used to classify or categorize other data. Typically, they are static or slowly changing over time.
348:"Reference Data Management and Master Data: Are they Related ? (Oracle Master Data Management)" 445: 215: 152: 147: 37: 8: 430: 50: 322: 410: 273: 195: 157: 162: 82: 167: 439: 142: 42: 137: 78: 58: 96: 67: 111:
Examples of good practice in reference data management include:
62: 54: 377:"5 best practices for managing reference data - LightsOnData" 27: 295:"The Foundations of Successful Reference Data Management" 241:"Using reference data for lookups in Stream Analytics" 121:
Govern the reference data specific to your enterprise
431:
Microsoft MSDN, Reference Data Services in DQS, 2012
89: 437: 407:Managing Reference Data in Enterprise Databases 118:Use external reference data as much as possible 266:DAMA-DMBOK: Data Management Body of Knowledge 188:DAMA-DMBOK: Data Management Body of Knowledge 102: 323:"IBM Redbooks | Reference Data Management" 124:Manage reference data at enterprise level 404: 115:Formalize the reference data management 438: 292: 33:Examples of reference data include: 127:Version control your reference data 13: 398: 18:Reference data (financial markets) 14: 457: 424: 90:Externally-defined reference data 409:. Morgan Kaufmann Publishers. 369: 340: 315: 286: 258: 233: 208: 180: 1: 216:"Multilingual reference data" 173: 77:Reference data differs from 7: 270:Data Management Association 192:Data Management Association 131: 10: 462: 405:Chisholm, Malcolm (2001). 15: 103:Reference data management 70:structure and constraints 16:For use in finance, see 153:Enterprise bookmarking 148:Master data management 51:Fixed conversion rates 222:. European Commission 327:www.redbooks.ibm.com 38:Units of measurement 293:Chisholm, Malcolm. 220:EU Open Data Portal 158:Data architecture 453: 420: 392: 391: 389: 388: 373: 367: 366: 364: 363: 354:. Archived from 352:blogs.oracle.com 344: 338: 337: 335: 334: 319: 313: 312: 310: 309: 299: 290: 284: 283: 268:(2nd ed.). 262: 256: 255: 253: 252: 237: 231: 230: 228: 227: 212: 206: 205: 190:(2nd ed.). 184: 163:Transaction data 83:business process 461: 460: 456: 455: 454: 452: 451: 450: 446:Data management 436: 435: 427: 417: 401: 399:Further reading 396: 395: 386: 384: 375: 374: 370: 361: 359: 346: 345: 341: 332: 330: 321: 320: 316: 307: 305: 297: 291: 287: 280: 264: 263: 259: 250: 248: 239: 238: 234: 225: 223: 214: 213: 209: 202: 186: 185: 181: 176: 168:Code (metadata) 134: 105: 92: 47:Corporate codes 21: 12: 11: 5: 459: 449: 448: 434: 433: 426: 425:External links 423: 422: 421: 415: 400: 397: 394: 393: 368: 339: 314: 285: 279:978-1634622349 278: 257: 232: 207: 201:978-1634622349 200: 178: 177: 175: 172: 171: 170: 165: 160: 155: 150: 145: 140: 133: 130: 129: 128: 125: 122: 119: 116: 104: 101: 91: 88: 72: 71: 65: 48: 45: 40: 24:Reference data 9: 6: 4: 3: 2: 458: 447: 444: 443: 441: 432: 429: 428: 418: 412: 408: 403: 402: 382: 378: 372: 358:on 2015-10-11 357: 353: 349: 343: 328: 324: 318: 304:. TopQuadrant 303: 296: 289: 281: 275: 271: 267: 261: 246: 242: 236: 221: 217: 211: 203: 197: 193: 189: 183: 179: 169: 166: 164: 161: 159: 156: 154: 151: 149: 146: 144: 143:Data modeling 141: 139: 136: 135: 126: 123: 120: 117: 114: 113: 112: 109: 100: 98: 87: 84: 80: 75: 69: 66: 64: 60: 56: 52: 49: 46: 44: 43:Country codes 41: 39: 36: 35: 34: 31: 29: 25: 19: 406: 385:. Retrieved 383:. 2018-07-25 381:LightsOnData 380: 371: 360:. Retrieved 356:the original 351: 342: 331:. Retrieved 329:. 2013-05-16 326: 317: 306:. Retrieved 301: 288: 265: 260: 249:. Retrieved 244: 235: 224:. Retrieved 219: 210: 187: 182: 110: 106: 93: 76: 73: 32: 23: 22: 302:TopQuadrant 247:. Microsoft 138:Master data 79:master data 59:temperature 416:1558606971 387:2018-08-17 362:2015-12-09 333:2015-12-09 308:2020-06-07 251:2020-06-07 226:2020-06-07 174:References 97:ISO 3166-1 245:Microsoft 440:Category 272:. 2017. 194:. 2017. 132:See also 68:Calendar 413:  276:  198:  63:length 61:, and 55:weight 53:e.g., 298:(PDF) 411:ISBN 274:ISBN 196:ISBN 28:data 26:is 442:: 379:. 350:. 325:. 300:. 243:. 218:. 99:. 57:, 419:. 390:. 365:. 336:. 311:. 282:. 254:. 229:. 204:. 20:.

Index

Reference data (financial markets)
data
Units of measurement
Country codes
Fixed conversion rates
weight
temperature
length
Calendar
master data
business process
ISO 3166-1
Master data
Data modeling
Master data management
Enterprise bookmarking
Data architecture
Transaction data
Code (metadata)
Data Management Association
ISBN
978-1634622349
"Multilingual reference data"
"Using reference data for lookups in Stream Analytics"
Data Management Association
ISBN
978-1634622349
"The Foundations of Successful Reference Data Management"
"IBM Redbooks | Reference Data Management"
"Reference Data Management and Master Data: Are they Related ? (Oracle Master Data Management)"

Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.