Monthly Archives: July 2014

Schema significance in the Physical model and implementation model

We would like to discuss few issues that customer faces and understanding of those issues while importing Metadata.
 
Importing metadata into the infosphere from Erwin 
 
When a Physical model is imported  and a equivalent  implementation model is generated,  the physical model is made analogous to Schema and all the underlying Tables in the Physical Models map to the  Tables in implementation model and a relation is established namely “ImplementedBy”.  So it is essential to have the schema  for all the tables. But how much are they going to play a role in the lineage is limited.
 
Tools like ERWin and ERStudio do support  creation of tables which have a different owners. Ie valid in case of a view created from different users and those models are re-engineered to Physical model. 
 
Lets take an example where a physical model ( PhysicalM) has 3 tables and out of which one table has Schema1 as a owner,  for another table Schema2,  and the third has PhysicalM as owner. So when the Physical model is imported, 3 schemas should be created each one has one table attached to it as per the design. But how much do they contribute  is limited. We could  make all the tables be under the PhysicalM model and have all the relationships established. If one wants to see what is actual in the re-engineered model  from the original implementation. So it is up to the user  whether user wants to preserve the actual implementation or not.
 
 

Story of Metadata

Metadata is data about data. Metadata will define the architecture of the data that is beingstored. Successfully executing your Information Agenda begins with Getting Your Arms Around WhatYou Have Today. This is one of the most difficult challenges that companies continue to struggle with. Itmeans understanding and confirming what data you have, learning how to use and structure that datato optimize your business and how you can implement a repeatable process to manage this informationover its lifecycle and leverage across your enterprise. It means creating a blueprint that accuratelyrepresents your information.
For a successful governance of Data that is getting generated and filling up the warehouse, athorough understanding of the metadata play an important role. There are many aspects to thegovernance of the Data warehouse.
1.Ensure the data is Trusted and strategic.
2.Management of the Metadata.

 

As cross department information demands continue to grow, the need to address this keychallenge becomes even more important to tackle. For every new IT project comes the daunting task oflocating the information, validating its content, reconciling definitions between sources and ensuringproper usage. The problems are further exacerbated with the increased number of new IT projects thatrequire information across siloed sources with less time to respond. CXOs today still suffer from not being able to get the right information at the right time. Just as information is often times created in the context of specific projects and applications, so are the tools that understand and control the information.
Companies need a unified way to inventory, understand, define and optimize their information separate from applications and technologies. IBM’s unique set of InfoSphere Foundation Tools does exactly just that. Only IBM has the complete set of foundational tools for your Information Agenda to help you to do this across your existing data and content.
The InfoSphere Foundation Toolkit was created to work in any environment and can be deployed at any point with multiple configuration options on any given project for completely flexibility to match your organization’s needs. This unique industry-leading offering allows companies to understand disparate data spread across their heterogeneous systems, govern it as business information over time, and design trusted information structures for business optimization.Foundation Tools combine discovery & understanding, data modeling & mapping, creation of business rule specifications, data stewardship, business vocabulary management, lineage of information and metadata management, all with a shared repository. Foundation Tools works with any data integration,business intelligence, or data warehouse tools or in conjunction with the comprehensive set of IBM Foundation engines for complete end-to-end data integration processing. The Foundation Tools are a perfect entry point for your Information Agenda.