IMW14238USEN - IBM Software Group White Paper XML Changing...

Info icon This preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
IBM Software Group White Paper XML: Changing the data warehouse Deliver new levels of business analysis and bring users closer to their data
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
2 Deliver new levels of business analysis Executive summary Some saw it coming years ago. Others are just beginning to realize what lies ahead. We’re talking about the impact that XML is having on data warehousing environments. For IT leaders building data warehouses that meet the evolving demands of their business environments, integration of XML data into their infrastructures is critical. With XML, organizations can support evolving business reporting and analysis requirements without incurring signifcant database schema changes or rewriting applications. Simultaneously, they can bring their users closer to the information that they need to make accurate business decisions while providing the user with a result set that is similar to a search engine on the Internet. XML has become the preferred data exchange format across many industries. As a result, organizations must fnd ways to effciently manage and manipulate XML within their data warehouses. In fact, leading-edge frms in retail, fnance, healthcare and other industries already have production environments that leverage both relational and XML database technologies. While their implementations vary, early adopters are often striving to promote greater business agility, providing decision makers with more accurate and timely information and improving IT staff productivity. IBM ® DB2 ® pureXML ® makes it possible for organizations to manage XML data as well as relational data. This increases database effciency, improves the user experience and increases their competitive advantage by fully exploiting data interchange standards. Data warehouses and evolving business needs One of the primary goals of data warehousing is to make it as easy as possible for users to get the information that they need when they need it. However, traditional relational schemes can make this diffcult to achieve. Consider a data warehouse in the retail industry that tracks sales information. Using a typical star schema database design, as pictured in Figure 1, a “fact” table might contain sales data by product, region and time period. Such data would typically be joined with data in multiple “dimension” tables to obtain specifc details pertaining to various products, regions and so on. Unfortunately, different products have different attributes, which presents challenges both in database design and in fguring out how to expose the data to users. With a relational-only design, each product attribute must be captured in its own column. But because attributes vary widely from one type of product to another, the result could be an ineffcient, unwieldy product table with thousands of sparsely populated columns. And, as new products and new product attributes are introduced over time, the database schema—and any applications that depend on it—would need to be altered, which can be quite costly.
Image of page 2
3
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern