Close
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Latest News
    • Storage

    Active Warehousing

    By
    Peter Coffee
    -
    June 23, 2003
    Share
    Facebook
    Twitter
    Linkedin

      Ive recently used this space to warn of the perils of building real-time systems that dont feed a real-time decision-making process. To look at the input side of that equation, and at the strengths that a system must have to make real-time decision making a plausible goal, Id like to share some things I heard from Stephen Brobst, CTO of the Teradata division of NCR, when he spoke at this months Chicago conference titled “Creating the Real-Time Enterprise.”

      Brobst took what could be another mere buzzword, “active data warehousing,” and explained it as a process of evolution in how an enterprise uses data. Without the “active” adjective, a data warehouse can still be a valuable resource for strategic identification of trends and opportunities; with the active emphasis, though, a data warehouse becomes much more of an operational tool and represents much more of an opportunity to change the way the

      enterprise makes tactical decisions that dramatically increase its value to all its partners.

      I found Brobsts five-stage model persuasive: It fits my own experience of how organizations grow in their use of data. His first stage, reporting, relies on batch-oriented tools with little in the way of ad hoc query capability. This is the approach that first-wave personal computing brought to enterprise desktops with tools like Ashton-Tates dBase II, starting around 20 years ago.

      I remember how startled people were by the low cost and rapid development cycles of those early tools and the speed with which they replaced costly minicomputer-based systems—but I also remember the upfront effort involved in defining the range of queries that these systems would support and the high cost of redefining queries as users learned what these systems could provide.

      In the second stage of data use, analysis, people want to ask new questions when the old ones give unexpected answers. Spreadsheets spread, so to speak, across enterprise desktops to enable this kind of dynamic process. Unfortunately, in the process, spreadsheets do more than just illuminate our thinking: They cast shadows that can warp our perceptions. Studies have found that people who use spreadsheets become overly confident of their ability to predict, and even control, the numbers that they crunch with such facility.

      Analytics, therefore, should be constructed with the same rigor that administrators apply to raw data. The conclusions that come from statistical methods, for example, need to be viewed with professional skepticism by people who know the difference between a high degree of fit and a useful level of significance. Plotting best-fit regression lines is much easier than it ought to be, considering the potential of those lines to point in misleading directions.

      When analytic tools are properly used, though, the organization is ready to enter Brobsts third stage of data use: prediction. This is an important step, but the resulting forecasts are still an offline, strategic device that doesnt really change the way business gets done.

      This is just the foundation that must be in place before the enterprise can move into the fourth and fifth stages. I dont especially care for Brobsts name of “operationalizing” for stage four. It sounds like psychobabble, but I cant come up with anything better to describe the goal of this stage—to move the organization from asking “What will happen?” to “What is happening?”

      It might seem as if describing the present would be easier than predicting the future, but different types of information move at different speeds: Producing an accurate snapshot in time is like making an elaborate dinner and having all the different dishes ready to serve at the same moment. Its harder than it looks.

      When we can actually say that we know whats happening right now, were ready to build event-triggered systems that enable better moment-to-moment decisions—not just annual plans or quarterly goals. When quality information is delivered to people who can appreciate its impact, in a way that helps them see opportunities before they grow stale, then enterprise systems are able to address the question, “What do I want to happen?” Thats what deserves the label of “active” warehousing—and its a beginning, not an end, to a real-time transformation. ´

      Peter Coffee can be reached at peter_coffee@ziffdavis.com.

      Peter Coffee
      Peter Coffee is Director of Platform Research at salesforce.com, where he serves as a liaison with the developer community to define the opportunity and clarify developers' technical requirements on the company's evolving Apex Platform. Peter previously spent 18 years with eWEEK (formerly PC Week), the national news magazine of enterprise technology practice, where he reviewed software development tools and methods and wrote regular columns on emerging technologies and professional community issues.Before he began writing full-time in 1989, Peter spent eleven years in technical and management positions at Exxon and The Aerospace Corporation, including management of the latter company's first desktop computing planning team and applied research in applications of artificial intelligence techniques. He holds an engineering degree from MIT and an MBA from Pepperdine University, he has held teaching appointments in computer science, business analytics and information systems management at Pepperdine, UCLA, and Chapman College.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.

      MOST POPULAR ARTICLES

      Latest News

      Zeus Kerravala on Networking: Multicloud, 5G, and...

      James Maguire - December 16, 2022 0
      I spoke with Zeus Kerravala, industry analyst at ZK Research, about the rapid changes in enterprise networking, as tech advances and digital transformation prompt...
      Read more
      Applications

      Datadog President Amit Agarwal on Trends in...

      James Maguire - November 11, 2022 0
      I spoke with Amit Agarwal, President of Datadog, about infrastructure observability, from current trends to key challenges to the future of this rapidly growing...
      Read more
      IT Management

      Intuit’s Nhung Ho on AI for the...

      James Maguire - May 13, 2022 0
      I spoke with Nhung Ho, Vice President of AI at Intuit, about adoption of AI in the small and medium-sized business market, and how...
      Read more
      Applications

      Kyndryl’s Nicolas Sekkaki on Handling AI and...

      James Maguire - November 9, 2022 0
      I spoke with Nicolas Sekkaki, Group Practice Leader for Applications, Data and AI at Kyndryl, about how companies can boost both their AI and...
      Read more
      Cloud

      IGEL CEO Jed Ayres on Edge and...

      James Maguire - June 14, 2022 0
      I spoke with Jed Ayres, CEO of IGEL, about the endpoint sector, and an open source OS for the cloud; we also spoke about...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2022 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×