Living on both sides of any issue helps you appreciate why each side firmly defends its respective position.
The ongoing debate between database marketers and information technology professionals regarding data warehouses and database marketing systems lives today for a variety of reasons.
Consolidation activities can potentially reduce these costs by 10 percent to 25 percent or more in some cases.
Optimize Data Integration Tools Licensing — Large organizations tend to have multiple tools and techniques that they use to achieve data integration goals.
For key business systems like sales, accounting, and production, it is critical that input of transactional data to the database is quick and reliable, without disruption to the flow of business.
The database can be optimized for these “write” operations, by minimizing the duplication of data fields (normalizing the data) among the database tables.
I have spent intimate time with both camps and can help illuminate the position for each viewpoint. Perhaps some background on each side is in order, since history often lends perspective.
The concept of data warehousing actually dates back more than 25 years to Massachusetts Institute of Technology research on the requirements of analytic processing versus transaction processing.
In a table, a row corresponds to a record with a set sequence of data fields, while a column lists one given data field for all the records.A staging area, or landing zone, is an intermediate storage area used for data processing during the extract, transform and load (ETL) process.The data staging area sits between the data source(s) and the data target(s), which are often data warehouses, data marts, or other data repositories.Through consolidation of overlapping and redundant tools, organizations can reduce software license and maintenance costs associated with data integration tools, while also enabling a lower investment in acquiring and maintaining the skills to operate the tools.With typical investment in data integration tools falling in the range of 0,000 to 0,000 for software licensing and ,000 to 0,000 for annual maintenance, organizations can achieve software cost savings of 0,000 or more through consolidating tools or replacing tools with lower-cost options.
Search for consolidating datamarts:
Data Management and Integration Trends to be Discussed at Upcoming Gartner Business Intelligence Summit, April 1-3 in Chicago To cope with a tightening economic environment, businesses should prepare now for cutting IT costs, and the data management discipline is one area that affords numerous opportunities for reducing and controlling costs, according to Gartner, Inc.