The goal of the ITS Database Standards is to document new databases and applications in a consistent manner across
platforms. These methods and requirements should provide a template for better documentation and make it easier to
identify objects during daily maintenance and crisis events.
With the current industry buzz focused on master data management (MDM) and customer data integration (CDI), it’s time to revisit one of the most critical elements of the Kimball Method. Back in 1999, Ralph Kimball wrote an Intelligent Enterprise column entitled “The Matrix.” The 1999 movie of the same name spawned two sequels, but we haven’t devoted a column to our matrix in more than six years.
Data stewardship can be defined as custodianship of the access, integrity and content of a company’s information. Although many IT authors have preached on the need for sound data stewardship for more than a decade, it always amazes me how many companies haven’t bought into the philosophy. These companies often have no defined data ownership model.
We have the council.
There’s only one problem with the theory: it’s difficult to execute in actual practice. The reason has nothing to do with BI tools themselves, and everything to do with the nature of portals and the applications – such as customer relationship management (CRM), enterprise resource planning (ERP), and your garden-variety databases – that feed them.
However, the key to building a successful enterprise portal that fully integrates BI tools is by first recognizing that the portal is not simply a launching pad. Rather, it allows users to fully manage business applications and transactions from within the portal. Further, it allows end users to access critical business information dynamically and securely across a range of online and mobile devices.
Business decisions often require group interaction and the assemblage of data from multiple sources. The data often is both quantitative and discursive. Even though many companies create and update briefing books to aid decision-making, Ventana%u2019s research shows that the users of these briefing books believe that they are not comprehensive enough. Further, they often distrust the accuracy and validity of the data in them. Ventana Research believes organizations must address the challenges of integrating business data and assuring users of its value.
In order to successfully integrate OLTP systems, two main issues need to be addressed. First, every application, or group of applications, that will be considered as an independent processing entity with well-defined boundaries should have a rich meta-information repository. This repository will unambiguously define all the relevant data within the scope of the business processes supported by this system. For instance, I was recently part of an effort where the domain model had three main parts: business class model, business use case realizations, and system use case model. No data element would be added to the domain model unless it was initially called out in the business and system use cases.
What is meta data? There are lots of definitions. In this article, meta data refers to anything that is important to information acquisition, integration and retrieval but not information itself. It includes technical meta data and business meta data.
Now, more than ever, companies need a way to consolidate and coordinate their data management and governance efforts. Stiffer competition for most companies at home and abroad has created an enormous demand for enterprise performance management.�Further, unnecessary complexity in systems and processes has led to poor information quality and inconsistent answers.�To answer the need, many companies have increased information technology (IT) spending, trying to search out a “single version of the truth” from their information systems.
The world of meta data continuous to evolve where technologies like taxonomies, Folksonomies, and many others are changing they way the world looks at meta data. From a database technology, to an enterprise architecture, to an Internet innovation, meta data continues to provide value everywhere.