I recently spoke to a friend of mine who works as a business intelligence consultant about writing an article for Information Management with a new twist on the operational data store which I call D’ORDS. After a moment of silence, he said, “A what?”  I said, “A D’ORDS. It’s a dimensional operational reporting data store.” Then he asked, in his very low gravelly voice, “You have my attention.” So I proceeded to describe a recent project I had completed for a very small startup company with a unique business model. 

Last year, I was contacted by a representative of this large company about my expertise on building data warehouses. For about 15 minutes, they described their business in general terms and their desire to create a data warehouse. I listened intently and took many mental notes. Taking a few minutes to gather my thoughts, I proceeded to describe several options. One option is to create an operational data store, which would alleviate the biggest problem of executing complex report queries against a transaction system. I proceeded to describe what they could do with this ODS and how they could subsequently create a real data warehouse as the main repository at a future date. We also discussed the transaction database issues, hardware configuration and their network. 

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access