Meta Data and Data Administration:
Data Warehousing Trends for 2000
Over the last 10 years, decision support has evolved from the "hottest" new industry buzzword to a technology that has demonstrated that it can provide significant value to a corporation. Now as decision support moves into the 21st century, we are maturing in ways we never anticipated. It's critical to understand these trends, as they will impact most every corporation. In this month's column, we will look at these trends that are currently changing data warehousing or will occur over the next 12 months and make some predictions.
Decision Support Moves Beyond the Global 2000
I believe that we are starting to see a strong influx of middle-tier and small-tier corporations looking to build their own decision support systems. For the most part, data warehousing has been exclusively reserved for the Global 2000 companies of the world. As the owner of a consulting company, rarely did smaller companies contact us to work with them to construct a decision support system. However, within the last three months, I have received calls from several smaller firms looking to construct their own data warehouse.
Global 2000 companies have proven that decision support systems yield strong returns and provide a competitive advantage in the marketplace. In fact, the industries that first entered the decision support arena (retail, banks, insurance, healthcare, telecommunications, etc.) have grown to depend on their warehouses on a day-to-day basis. Another factor fueling this adoption is that decision support software is becoming a commodity. In fact, with the emergence of Microsoft in the decision support market, the cost of software is becoming affordable within the IT (information technology) budget of these smaller businesses.
Current Decision Support Systems are Reengineered
As we discuss the emergence of middle-tier to small-tier companies, it is important to understand that many of the Global 2000 companies will be doing more than their fair share of data warehousing. During the 1990s, corporations raced to build their decision support systems as quickly as they could. Unfortunately, in their zeal to do this, too many of these organizations neglected to build the architecture necessary to grow their systems over time. In many cases, these companies built independent data marts, which are data marts that are directly sourced from operational systems without a data warehouse. Because a data warehouse provides the necessary architecture that allows data marts to scale to meet the ever-growing needs of their business, many of these corporations will move to address this fundamental weakness in their decision support systems now that the Y2K issues are behind us.
Proliferation of Advanced Decision Support Architectures
Those corporations that have been successful in their decision support efforts will look to implement more advanced decision support architectures. Global 2000 companies will want to integrate their customer relationship management (CRM) and e-business initiatives with their decision support systems to provide new levels of business intelligence. In addition, these same corporations will want to implement more closed-loop decision support systems which capture information from their business users and feed that information back into their operational systems.
A Data Warehousing Meta Data Standard is Reached
Industry standard meta data models are critical to allow the various decision support tools to share their data with one another. I believe that the Meta Data Coalition (backed by Microsoft, Computer Associates and others) and the Object Management Group (backed by Oracle, IBM, Hyperion, Unisys and others) will decide to work together to make one meta data standard for data warehousing a reality. They will realize that it is best for the industry and best for each of them and declare mutual victory in this arena.
One thing that will not change in the upcoming year is that those decision support systems that provide the greatest benefit to their companies will be the ones that provide definable and measurable business value to the enterprise. Don't start or expand a data warehouse initiative for the "glory" of doing it. Start one of these initiatives to add value to your corporation. Do this and all of us will have a fantastic 2000 and beyond.
For more information on related topics visit the following related portals...
DW Administration, Mgmt., Performance and
David Marco is an internationally recognized expert in the fields of enterprise architecture, data warehousing and business intelligence and is the world's foremost authority on meta data. He is the author of Universal Meta Data Models (Wiley, 2004) and Building and Managing the Meta Data Repository: A Full Life-Cycle Guide (Wiley, 2000). Marco has taught at the University of Chicago and DePaul University, and in 2004 he was selected to the prestigious Crain's Chicago Business "Top 40 Under 40." He is the founder and president of Enterprise Warehousing Solutions, Inc., a GSA schedule and Chicago-headquartered strategic partner and systems integrator dedicated to providing companies and large government agencies with best-in-class business intelligence solutions using data warehousing and meta data repository technologies. He may be reached at (866) EWS-1100 or via e-mail at DMarco@EWSolutions.com.
Provided by IndustryBrains
|Design Databases with ER/Studio: Free Trial|
ER/Studio delivers next-generation data modeling. Multiple, distinct physical models based on a single logical model give you the tools you need to manage complex database environments and critical metadata in an intuitive user interface.
|cost-effective Web server security|
$200 discount coupon available now for the purchase of dotDefender, a website security solution that is available for a 30-day evaluation period. dotDefender supports Apache, IIS and iPlanet Web servers and all Linux Operating Systems.
|Verify Data at the Point of Collection: Free Trial|
Protect against fraud, waste and excess marketing costs by cleaning your customer database of inaccurate, incomplete or undeliverable addresses. Add on phone check, name parsing and geo-coding as needed. FREE trial of Data Quality dev tools here.
|Free EII Buyer's Guide|
Understand EII - Trends. Tech. Apps. Calculate ROI. Download Now.
|Data Mining: Levels I, II & III|
Learn how experts build and deploy predictive models by attending The Modeling Agency's vendor-neutral courses. Leverage valuable information hidden within your data through predictive analytics. Click through to view upcoming events.
|Click here to advertise in this space|