In 2000, a standard was ratified that defines a common interface for
interchange of metadata implementations. Named the Common Warehouse Metadata
Interchange (CWMI) by the Object Management Group (OMG), this standard
is based on XML interchange. Oracle was one of the early proponents and developers
of the technology in this standard. For example, Oracle has a CWM bridge for
exchanging metadata stored in the Oracle Warehouse Builder repository. OWB also
includes a metadata viewer for more detailed metadata reports, and a viewer for data
lineage and impact analysis diagrams.
Best Practices | 249
As noted earlier in this chapter, an emerging complementary solution??”one in which
ETL into a single data warehouse is not the entire solution??”is the leveraging of master
data management and data hub solutions. Today, most organizations are still a
long way from consolidated metadata, and when they have tried to do this as an IT
best-practice project, they generally have not been successful. Such projects are usually
adopted only when delivered within a business intelligence project that delivers
business value.
Pages:
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549