New Tools Automate Data Relationship Discovery

Gorelik, Alex
June 2007
Database Trends & Applications;Jun2007, Vol. 21 Issue 6, p8
The article discusses how new tools in database integration can help consolidate data by automating the data relationship discovery function. Metadata is the detailed description of data relation and transformation as it flows within the system, and not just a simple description of data. It is believed that metadata documentation is time-consuming, error prone, and an expensive process. Therefore, automation is needed to solve these problems. Businesses have an abundance of structured data sources that are shared and managed across the organization.


Related Articles

  • Invest in Repeatable Management Processes to Ensure Success. Lemme, Steve // Database Trends & Applications;Sep2005, Vol. 19 Issue 9, p17 

    This article examines the approach of information technology (IT) managers in moving from tactical to strategic database management in the face of budget constraints and escalating business requirements such as new project deployments and IT governance. Assessing management practices and...

  • SSIS LOGGING and DATA AUDITING. Chessman, Tyler // SQL Server Magazine;Oct2008, Vol. 10 Issue 10, p31 

    The article discusses the use of Business Intelligence Development Studio (BIDS) to customize package logging and data auditing with Structured Query Language (SQL) Server Integration Services (SSIS). SSIS provides organizations with powerful data integration capabilities. Package logging refers...

  • Which Way is the Pendulum Swinging Now? McKendrick, Joe // Database Trends & Applications;Sep2005, Vol. 19 Issue 9, p12 

    This article focuses on the pendulum-like direction of the information technology (IT) industry. The IT industry is both unpredictable and replete missed predictions. But one thing is certain, and has been occurring regularly. That is, the pendulum swing between centralization and...

  • Prevent Database Errors. Kolawa, Adam // Database Trends & Applications;Jun2005, Vol. 19 Issue 6, p25 

    The article discusses issues related to preventing database errors. By ensuring that database is well designed from start, it can be easier to develop, maintain and debug it as time goes by. Data normalization is recommended for detecting structural changes in databases. Load testing can help in...

  • Three Approaches to Looking at Content. Inmon, W. H. // Database Trends & Applications;Sep2005, Vol. 19 Issue 9, p19 

    This article discusses three common methods for determining the contents of a document. These approaches refer to the linguistic, themed, and industrial recognition approach. Linguistic approach has its roots in academia, and an attempt is made to read and understand the language that has been...

  • Converging data architectures. Michael, Gavin // Computer Weekly;2/7/2012, p16 

    The article offers information and recommendations about converging data architectures in a business. Topics include the development of unstructured databases, the management of database structuring by information technology (IT) departments in businesses, and bridge technologies used for...

  • Information Explosion Creating Opportunities for Storage Professionals. Shrivastava, Alok // Certification Magazine;Aug2007, Vol. 9 Issue 8, p26 

    The article describes some of the key functions that are carried out in information technology (IT) organizations either within a formalized storage management group or across IT groups by forming a storage management virtual team. The storage manager is considered a strategic function that...

  • Build-Out OR Build-In? Limp, W. Fredrick // GEOWorld;Apr2005, Vol. 18 Issue 4, p32 

    Considers how geospatial technologies can be integrated in the information technology infrastructure of businesses and government agencies. Idea behind a geospatial build-out; Ways to approach the concept of geospatial build-out; Need for many enterprise information technology situations to...

  • The Accidental Architecture. Sherman, Rick // DM Review;Apr2008, Vol. 18 Issue 4, p34 

    The article discusses the characteristics of information systems that lack an architectural blueprint. The lack of blueprint makes the operation, upgrading and maintenance of data warehouses and business intelligence environments difficult. Companies with data warehouse built on accidental...


Read the Article


Sorry, but this item is not currently available from your library.

Try another library?
Sign out of this library

Other Topics