Portals eNewsletters Web Seminars dataWarehouse.com DM Review Magazine
DM Review | Covering Business Intelligence, Integration & Analytics
   Covering Business Intelligence, Integration & Analytics Advanced Search

View all Portals

Scheduled Events

White Paper Library
Research Papers

View Job Listings
Post a job


DM Review Home
Current Magazine Issue
Magazine Archives
Online Columnists
Ask the Experts
Industry News
Search DM Review

Buyer's Guide
Industry Events Calendar
Monthly Product Guides
Software Demo Lab
Vendor Listings

About Us
Press Releases
Advertising/Media Kit
Magazine Subscriptions
Editorial Calendar
Contact Us
Customer Service

Meta Data and Data Administration:
Whassup!?! XML and Data Warehousing that's What!

  Column published in DM Review Magazine
July 2000 Issue
  By David Marco

XML and data warehousing are hotter than the beer commercial that spawned the whassup catch-phase. Data warehousing is a proven technology, while XML offers the hope of making the Internet a much easier world in which to live and develop. There has been a great deal written about the potential uses of XML; however, there are few articles that discuss its uses in data warehousing. Last month, we discussed how XML could be used to bring data into a data warehouse environment. This month, we will present how XML is used to get data out of the data warehouse and send it to other corporations, Web sites and wireless devices.

Web Site Generation

Often the information in data warehouses/data marts is published to a company's intranet Web site. XML will replace hypertext markup language (HTML) in building these Web sites as it makes the data much more accessible and valuable. With XML, the enterprise's decision-makers can have their corporate portal locate the information that they're looking for. Since XML was used to build the Web site, these users can electronically pull this information off their Web sites and manipulate it as they choose. Let's walk through this process.

Figure 1: XML Getting Data Out of the Data Warehouse

Figure 1 shows that data is read from the data warehouse and its data marts (see Figure 1, bullet 1 & 2) and then brought into the XML transformation process. The XML transformation process will then match this data to its corresponding XML schema (bullet 5). As we discussed last month, one of the key challenges with XML is having standard names and meanings for the XML data tags. Unfortunately, XML appears to be going the way of many of the past information technology (IT) standards efforts. Corporations are rushing to use it and in their hurry are creating their own proprietary XML data tag standards. Therefore, many of us in IT will have the unenviable task of juggling multiple XML schemas in our corporations. Next, the XML transformation process will write this data to a corporate intranet Web site (bullet 7). The decision-makers can now use their corporate portal to locate this information and even download it from the Web site onto their client PC for further analysis (bullet 10).

Wireless Devices

The Internet has changed the way many of us purchase products and services. Today, we can order any book online at Amazon or go to Ebay and become the high bidder for the new talking Pokemon action figure. These business-to-consumer (B2C) transactions are meeting the wireless world of cellular phones and personal digital assistants (PDAs). Many companies are creating products (such as the Palm Pilot VII) to enable you to go shopping at selected Internet e-commerce Web sites directly from your wireless device, whenever you want and wherever you may be. A key technology to enable these transactions is XML's sister technology - wireless markup language (WML).

Figure 1 illustrates data that is read from an e-commerce Web site (see Figure 1, bullet 4) and brought into the WML transformation process. The WML transformation process will then match this data to the corresponding WML schema (bullet 6) because WML, like XML, will have multiple WML schemas depending on the wireless device. Lastly, the WML transformation process will push the information to a cellular phone, PDA, pager or some other wireless device (bullet 9).

In addition to these B2C transactions, WML will also allow corporations to extract data out of their data warehouses and operational systems (bullet 3) and send it to their field employees. This is especially valuable for sales force automation.

B2B Information Selling

When we think about Internet revenues, we tend to envision B2C transactions. This is a mistake as the greatest promise of the Internet age may be the quickly growing business-to-business (B2B) economy. Traditionally, data warehousing systems were focused on using their information to help corporations make better strategic decisions. For some companies, a natural progression is to turn their data warehouses into a revenue-generating vehicle by selling some of the information. In fact, there are firms whose chief product is information. Some of these firms will even build customized data marts for their customers. XML will facilitate this movement of data from one company to another.

Figure 1 illustrates data being read from the data warehouse and its data marts (see Figure 1, bullet 1 & 2) and then being brought into the XML transformation process. The XML transformation process will then match up this data to the corresponding XML schema (bullet 5). Next, the XML transformation process will send this data to the B2B (business-to- business) trading partner (bullet 8).

It is clear that XML will greatly aid the new Internet world in which we live. Just keep in mind that XML, like any other new technology, comes with its share of challenges. Use it wisely, and you will know exactly whassup!


For more information on related topics visit the following related portals...

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.

Solutions Marketplace
Provided by IndustryBrains

Data Validation Tools: 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.

Speed Databases 2500% - World's Fastest Storage
Faster databases support more concurrent users and handle more simultaneous transactions. Register for FREE whitepaper, Increase Application Performance With Solid State Disk. Texas Memory Systems - makers of the World's Fastest Storage

Manage Data Center from Virtually Anywhere!
Learn how SecureLinx remote IT management products can quickly and easily give you the ability to securely manage data center equipment (servers, switches, routers, telecom equipment) from anywhere, at any time... even if the network is down.

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.

Free EII Buyer's Guide
Understand EII - Trends. Tech. Apps. Calculate ROI. Download Now.

Click here to advertise in this space

View Full Issue View Full Magazine Issue
E-mail This Column E-Mail This Column
Printer Friendly Version Printer-Friendly Version
Related Content Related Content
Request Reprints Request Reprints
Site Map Terms of Use Privacy Policy
SourceMedia (c) 2006 DM Review and SourceMedia, Inc. All rights reserved.
SourceMedia is an Investcorp company.
Use, duplication, or sale of this service, or data contained herein, is strictly prohibited.