News

News

• July 22, 2009 22 Jul'09

  What does MapReduce and in-database technology mean for data warehouses?

  By placing the analytic logic inside the data warehouse, in-database technology, including open source MapReduce, can quickly process large sets of Web-based data.

• July 02, 2009 02 Jul'09

  Evaluating and selecting a master data management (MDM) vendor

  Learn how to compare and select a master data management (MDM) vendor. Hear about common MDM mistakes, how to write a streamlined vendor request for proposal (RFP) and how to evaluate customer reference letters.

• June 22, 2009 22 Jun'09

  Data models serve as blueprint for business intelligence, master data management projects

  No business intelligence or master data management initiative should start without a well-designed data model to guide the project.

• June 09, 2009 09 Jun'09

  MDM building blocks from Gartner: governance, metrics key to success

  Before embarking on a master data management (MDM) initiative, organizations must lay the foundation for success, including developing data governance rules and business-centric metrics to measure results.

• June 09, 2009 09 Jun'09

  Data warehouse architecture: Beyond hub-and-spoke

  Hear a hub-and-spoke definition and learn about challenges surrounding hub-and-spoke architecture. Know all the issues and details before implementing a hub-and-spoke design and hear how data governance plays a role in the hub-and-spoke model.

• Sponsored News

  • Choosing the Right Cloud Storage Infrastructure for Improved Risk Management

    Sponsored by NetApp - The growing ubiquity of cloud storage has been accelerated substantially by a variety of factors, not the least of which has been the COVID-19 pandemic that has spiked cloud usage to complement, and in some cases even replace, on-premises storage. But with that growth of cloud storage has come a commensurate increase in risk as more data is in transit. See More

  • Connecting and Integrating With the Public Cloud

    Sponsored by NetApp - Cloud computing is now a hallmark of all enterprise IT strategies, and public cloud computing has become one of the most transformative factors in the entire enterprise computing landscape. By 2023, global expenditures on public cloud computing will exceed $1.1 trillion by 2023, representing a 6-year compound annual growth rate of nearly 24%. See More

  • Enabling Business-Critical Apps For a Distributed Environment

    Sponsored by NetApp - Supporting distributed workforces with essential applications, until recently a concern primarily for larger enterprises, is now a fact of life for nearly all organizations. The global e-commerce movement has dramatically expanded organizations’ ability to do business in any region of the world, typically necessitating local workforces for such functions as support, service and marketing. And the COVID-19 pandemic put an exclamation point on one of the most transformative issues of commerce—remote work. See More

  • Optimizing Your Cloud Storage Spending For Hybrid Cloud Environments

    Sponsored by NetApp - Most organizations know that hybrid cloud’s many benefits extend far beyond financial factors. Agility, flexibility and scalability are just some of the most attractive features of hybrid cloud, as well as the ability to move workloads from on-premises to the cloud and back, or from cloud to cloud. In fact, these and other benefits have driven most organizations to adopt hybrid cloud as part of their overarching IT service delivery strategy. See More

  View All Sponsored News
• April 13, 2009 13 Apr'09

  Open source data integration tools good choice for 'standard' ETL jobs

  Open source data integration tools and software could be the best choice for companies looking to keep costs low in standard extract, transform and load (ETL) scenarios.

• March 30, 2009 30 Mar'09

  Data federation technology complements fragmented data warehouses

  Data federation software, which integrates data straight from the source, can help fill the gaps left by fragmented departmental data warehouses.

• March 04, 2009 04 Mar'09

  Normalization is Impractical for Master Data

  Master data tables seem to be particularly sensitive to the limits of normalization, and Malcolm Chisholm believes that a reflexive attachment to normalization can be counterproductive.

• February 25, 2009 25 Feb'09

  Data quality management roadmap

  Jeff Pettit explains how to reap the benefits of highly productive data for years to come.

• February 17, 2009 17 Feb'09

  Data Cleansing

  The hard reality is that always problematic and often costly data anomalies do exist. Will Dwinnell explains why it is helpful to have a tool to automatically ferret out a substantial fraction of those anomalies.

• January 26, 2009 26 Jan'09

  How to get started with master data management

  Forrester Research's Rob Karel reveals his tips for starting a master data management (MDM) initiative, including how and when to start evaluating vendors.

• November 06, 2008 06 Nov'08

  Motivations for building the data warehouse

  Bill Inmon provides a review of the factors that motivate organizations to build corporate data warehouses.

• November 05, 2008 05 Nov'08

  Exec explains IBM's Information On Demand (IOD) initiative

  Listen to IBM's Steve Mills discuss Big Blue's Information On Demand initiative and why he thinks it's in a better position to help customers than rival Oracle.

• October 30, 2008 30 Oct'08

  Monitoring the data warehouse

  Bill Inmon looks at dormant data in the data warehouse and provides suggestions for addressing data warehouse performance.

• July 21, 2008 21 Jul'08

  Creating successful data stewardship programs, with Jill Dyché

  Learn how data stewardship fits into data governance and data quality management programs, from Jill Dyché.

• June 05, 2008 05 Jun'08

  Master data management must start with data governance

  An effective master data management project starts with managing people and processes, including data governance. The technology is secondary.

• May 27, 2008 27 May'08

  Data quality assessment helps identify, fix data quality problems

  Data quality problems can't be fixed until they are identified. Learn how a data quality assessment can help pinpoint data quality problems.

• May 08, 2008 08 May'08

  A brief history of ETL

  "Do you remember the spread of data warehousing through the public and then private sectors? The IPO of Prism Solutions? This article takes a look at the history of ETL and provides a glimpse into ETL's future."

• April 30, 2008 30 Apr'08

  Is Data Warehousing Essential to Business Intelligence?

  The role of data warehousing is changing as companies move toward using new business intelligence approaches.

• April 10, 2008 10 Apr'08

  Why Are Data Warehouses Growing So Fast?

  Richard Winter provides observations on the causes and effects of the explosion of digital information.

• March 15, 2008 15 Mar'08

  The simplicity and complexity of person name standardization

  There are many different kinds of standardizations that can be applied to data, especially individual data.

• January 22, 2008 22 Jan'08

  Active data warehousing explained and examined

  Active data warehousing brings business intelligence to more operational decision-making processes. Find out how, and why, active data warehouses enable competitive advantages.

• January 10, 2008 10 Jan'08

  Building a business case for data modeling

  A business case for data modeling requires using the levers of better data quality, improved applications and reduced data management costs.

• December 20, 2007 20 Dec'07

  How long should the data model take?

  There are several approaches for data modeling to ensure that the length of time spent in model development is appropriate for the organization.

• December 11, 2007 11 Dec'07

  Data migration planning: Key things to remember

  Putting together a comprehensive data migration plan now can help firms avoid serious downtime later, according to experts.

• November 28, 2007 28 Nov'07

  Nationwide Insurance implements master data management program

  Nationwide Insurance shares master data management (MDM) best practices in this case study podcast and provides an architectural diagram.

• October 24, 2007 24 Oct'07

  Understanding master data management (MDM) implementation styles

  Rick Sherman explains the three styles of master data management (MDM) -- operational, analytical and enterprise - and how to select a style and get started.

• October 11, 2007 11 Oct'07

  Software Quality Assurance in a Data Warehouse/Business Intelligence Environment

  Quality assurance in a data warehouse/business intelligence environment requires testing of the population process, not the user interface provided by the tool vendor.

• October 11, 2007 11 Oct'07

  Data warehouses and scalability

  Is a data warehouse really necessary? What business requirements indicate the need for a data warehouse?

• September 20, 2007 20 Sep'07

  Quality goals for data warehousing

  Carried to an extreme, quality can be a real enemy to progress.

• September 13, 2007 13 Sep'07

  What is metadata? Solutions for leveraging technical and business metadata

  This article introduces Lowell Fryman's Metadata Expert Channel where he will provide insights and solutions on the capture, governance, management, usage, and dissemination of metadata to enhance your organization's knowledge and effectiveness.

• August 30, 2007 30 Aug'07

  The exploration warehouse

  The exploration warehouse is a physically separate data warehouse designed to provide a place for statisticians to do processing as frequently as desired, without impacting the regular users of the data warehouse.

• July 18, 2007 18 Jul'07

  Data governance: How to get started and find success, featuring Jill Dyché

  Data governance, or lack thereof, can make or break many enterprise programs. Learn data governance program success factors and get advice in a podcast with expert Jill Dyché.

• June 21, 2007 21 Jun'07

  Key Data Entities and Data Governance

  This article considers two challenging aspects of enterprise information management: key data entity ownership and data quality management.

• May 15, 2007 15 May'07

  Data management podcast library

  SearchDataManagement.com's growing collection of podcasts features conversations about many aspects of data management, including business intelligence (BI), enterprise data integration (EDI), master data management (MDM), and data quality and ...

• April 03, 2007 03 Apr'07

  Building a Customer-Centric Data Warehouse

  A major focus for retailers is getting a better understanding of the behavior of their customers. Learn how to build a customer-centric data warehouse from key analytic and data subject areas.

• February 08, 2007 08 Feb'07

  Different stages of data warehouse maturity

  This article covers the stages of data warehousing from the data mart through the enterprise data warehouse.

• January 24, 2007 24 Jan'07

  Data quality trends, with expert Larry English

  Data quality tools and processes have changed dramatically, so keep up with the latest data quality trends. Renowned expert Larry English provides timely advice for your data quality strategy.

• December 19, 2006 19 Dec'06

  Enterprise Architecture in Banking

  This article is a continuation in the series on enterprise architecture.

• December 18, 2006 18 Dec'06

  Accuracy, Sampling and the Accuracy of Sampling

  Manually verifying data accuracy is bound to introduce errors. Therefore, sampling can be used to derive some conclusions about a large body of information by selecting a smaller number of instances for the purposes of inferencing.

• November 27, 2006 27 Nov'06

  The relationship between master data and business intelligence analytical processing

  In a business intelligence environment, the master data documents how business information has changed over time, and this historical master data can be combined with other historical business transaction data to produce analytical reports.

• November 17, 2006 17 Nov'06

  Data governance requires checks and balances, Gartner says

  Gartner predicts that 90% of organizations will fail at their first attempts at data governance. An analyst outlines a data governance structure that includes checks and balances.

• October 26, 2006 26 Oct'06

  The Nature of Unstructured and Semi-Structured Data, Part 1

  The purpose of this series is to present and discuss unstructured and semi-structured data as it relates to DW 2.0 - the architecture for the next generation of data warehousing.

• October 03, 2006 03 Oct'06

  Lessons in Data Warehousing from Walt Disney and His Magic Kingdom

  Walt Disney and his Magic Kingdom can serve as sources of inspiration for data warehousing adventures. The two have more in common than you might think.

• September 26, 2006 26 Sep'06

  Metadata-Driven Enterprise Data Management – Future or Fantasy?

  A metadata-driven methodology for EDM allows all components to share information about the data as it moves through its life cycle, thereby enabling consistency, accountability and true control of data assets.

• September 21, 2006 21 Sep'06

  Data confidence

  Data confidence, a critical management success factor, is not automatic. How do you attain it?

• August 10, 2006 10 Aug'06

  Data modeling and unstructured data

  The data model has long been recognized as one of the essentials in the structured environment, but do we need a data model for the unstructured environment as well?

• August 02, 2006 02 Aug'06

  SQL Server vs. MySQL: Syntax differences, similar GUIs

  Discover syntax differences between SQL Server and MySQL, code for a timestamp automation workaround and why it's important to keep your version of MySQL current.

• July 17, 2006 17 Jul'06

  Understanding the DBA job description: Database administrator's roles and responsibilities

  Confusion over the DBA's job description and their role in business often results in misusing their DBA job skills.

• July 14, 2006 14 Jul'06

  Database management best practices: Expert tips for improving DBMS infrastructures

  Database management best practices involve optimizing people, processes and products. Get specific actions and expert tips.

• July 05, 2006 05 Jul'06

  Seven master data management best practices

  Master data management's early adopters share best practices and potential pitfalls.

• May 16, 2006 16 May'06

  Retail Data Warehouse

  Use your retail data warehouse to get a view of your business from the perspective of your customers.

• March 28, 2006 28 Mar'06

  Bioinformatics in Structure-Based Drug Design

  Bioinformatic tools aid in the design of novel drug compounds.

• March 16, 2006 16 Mar'06

  An introduction to DW2.0

  The new architecture for data warehousing addresses mission-critical areas.

• March 14, 2006 14 Mar'06

  Can Toad for Oracle compete against Oracle's free SQL Developer?

  Oracle's newly released free SQL Developer could spell trouble for Quest Software Inc.'s popular Toad for Oracle software.

• February 22, 2006 22 Feb'06

  IBM DB2 and Master Data Management

  Over the past year, master data management has become a topic of interest to CIOs seeking to rationalize their enterprise information architectures. What is master data management? And what role can DB2 play in making master data management a ...

• December 06, 2005 06 Dec'05

  Certified Data and the Certification Process for Financial Institutions

  Legislative & regulatory initiatives can now drive financial institutions to aggregate data and build data management infrastructures on a much larger scale.

• September 22, 2005 22 Sep'05

  A history of database evolution

  The database is the precursor of the data warehouse and data mart, with its future pointing to unstructured data and archival and nearline processing.

• August 18, 2005 18 Aug'05

  Data marts as the basis of a data warehouse: Can this structure work?

  There is a case to be made for management to process and react to data slowly, not quickly.

• June 30, 2005 30 Jun'05

  Data warehousing and statistical processing

  The data warehouse is not the ideal data environment for the statistician.

• June 30, 2005 30 Jun'05

  Cheat sheet: 10 ways to prep for auditors

  There are 10 ways to prepare for those auditors knocking at your door -- and avoid wasting time and money.

• April 14, 2005 14 Apr'05

  Data Warehousing: Our Great Debate Wraps Up

  This last article will summarize our key debate points. reader feedback and answers to questions that have been received will be published in the blog.

• March 22, 2005 22 Mar'05

  Practical Data Quality for Financial Services

  With a Data Governance Entity in place and quality raised as a top-tier issue, the question now becomes how to fix data quality problems.

• March 09, 2005 09 Mar'05

  Data Warehouse Architecture: The Great Debate

  Inmon Vs. Kimball--Differences Between Industry Titans.

• February 16, 2005 16 Feb'05

  How many DBAs?

  Craig Mullins offers tips for DBA staffing.

• February 15, 2005 15 Feb'05

  Open source database systems

  Craig Mullins contemplates the role of open source database systems in the enterprise.

• February 09, 2005 09 Feb'05

  Continental Airlines builds real-time data warehouse

  A Continental Airlines business intelligence project brought together 15 data warehouse developers in a mission that seemed impossible, but resulted in more revenues, less waste and higher customer satisfaction.

• January 06, 2005 06 Jan'05

  Data warehousing for government

  Surprisingly, Data Warehouses have been slow to be adopted in the government circles.

• November 09, 2004 09 Nov'04

  Corporate Information Factory (CIF): The value of a conceptual architecture for BI

  This CIF architecture acts as a road map or plan guiding the IT developer in implementing a Business Intelligence environment.

• October 25, 2004 25 Oct'04

  Top 10 Business Intelligence Applications for Clinical Healthcare

  This article describes how business intelligence applications enable organizations to meet the onslaught of demands for current and accurate information on performance, quality, safety, efficiency, effectiveness and, of course, costs.

• July 19, 2004 19 Jul'04

  Data warehousing: building the foundation

  New and powerful tools will help load and refine information, but you must still develop a strategy to build the optimal data warehouse to use them.

• May 20, 2004 20 May'04

  Contract compliance is a Sarbanes-Oxley issue

  Contract compliance