Data Warehouse Defined

By Deborah Radcliff

October 9, 2001 12:00 PM ET

Computerworld - Stefan Jon Silverman, president of SJS Associates NA, a technology strategy consultancy in San Francisco, offers the following outline of the characteristics that define a data warehouse:

Characterized by an I/O profile favoring batch process reads from the data store.Updates are usually accomplished by batch processes.

Data storage is long term and usually of a time-series nature.

Stores are implemented in hierarchical fashion, characterized by a big raw data store and successive levels of summarization in query tables.

Uses are mostly for decision-support, statistical analysis and customer relationship management systems.

Guarding the data warehouse gate

If Your Warehouse Is Outsourced

Data Warehouse Defined

Business Intelligence

Additional Resources

WEBCAST

Advancing Knowledge Sharing with Google: The LSNC Story

In the modern work environment, knowledge sharing has become paramount to organizational success, given the geographic dispersion, mobility, and information overload. During this session, Legal Services of Northern California (LSNC) will discuss their recent knowledge sharing transformation. With employees across 14 offices, servicing one-third of California, and having to access information across a million documents, the challenge was daunting. To address this, LSNC tapped Google's expertise on enterprise search and cloud computing, and deployed a knowledge-content system.

WHITE PAPER

Cost-Effective Virtualization Security

Trend Micro(tm) Virtualization Security solutions deliver advanced security software to protect operating systems, applications and data on virtual and cloud servers to help ensure compliance, while allowing higher server consolidation rates, and maximizing performance and operational flexibility. With Trend Micro software deployed on your physical servers and virtual machines, your IT infrastructure receives comprehensive and integrated protection.

WHITE PAPER

The Laptop Dilemma: How to Maximize Productivity and Lower the Burden on IT

New era of mobile computing creates opportunities for remote productivity while next-generation, industry-standard technologies address management and data security. Read more in this white paper.

Top Stories

BI and Analytics White Papers

Crystal Reports Server : Unlike Other Solutions, We Don't Play Games: Check It Out!
Crystal Reports Server: Unlike Other Solutions, We Don't Play Games: Want to keep your end users happy and out of your hair? Try SAP Crystal Reports Server and dashboard solutions to build and...
How To Get The Best From Business Data: With today's BI tools, business folks can jump in and start analyzing data themselves, rather than wait for IT to run complex reports....
Business Intelligence in SAP Environments: This paper, commissioned by the Business Application Research Center - offers guidance to IT System Architects, outlining the pros and cons of architectural...
Funding for BI: It's All About ROI, ROI, ROI: Historically Business Intelligence (BI) investments have been justified via intangible values such as a single version of the truth or faster and more...

BI and Analytics Webcasts

Your Goal Achieved: ROI and Happy Online Customers: View now!
1-Min Smart Analytics System Introduction: A one-minute video introduction to IBM Smart Analytics System.
Is Virtualization Compromising Your Data Protection?: Register Now
3 Minutes with Free Tool Can Save Thousands!: Watch Now!
A New Approach to IT Governance: This 5-Minute Demo shows a new approach that lets IT quickly and easily realize the benefits of IT Governance.

IT Jobs

See All Jobs Post a job for $295

Jobs by SimplyHired

BI and Analytics White Papers | All BI and Analytics White Papers