data warehouse
55 ResultsDictionary
data warehouse
A database designed to support decision making in an organization. Data from the production databases are copied to the data warehouse so that queries can be performed without disturbing the...
Dictionary
Definition: data warehouse
A database designed to support decision making in an organization. Data from the production databases are copied to the data warehouse so that queries can be performed without disturbing the performance or the stability of the production systems.
Data Marts
Data warehouses can become enormous with hundreds of gigabytes of transactions. As a result, subsets, known as "data marts," are often created for just one department or product line.
Updated at the End of a Period
Data warehouses are generally batch updated at the end of the day, week or some period. Its contents are typically historical and static and may also contain numerous summaries.
Operational Data Stores
The data warehouse is structured to support a variety of analyses, including elaborate queries on large amounts of data that can require extensive searching. When databases are set up for queries on daily transactions, they are often called "operational data stores" rather than data warehouses (see ODS). See OLAP, DSS, EIS and BI software.
THIS DEFINITION IS FOR PERSONAL USE ONLY
All other reproduction is strictly prohibited without permission from the publisher.
© 1981-2010 The Computer Language Company Inc. All rights reserved.
Sponsored White Papers, Webcasts & Resources
-
Live Webcast: Getting to Microsoft Office 365: The Right Migration for Your Business
If you've been stuck using bare bones, web-based tools, you'll appreciate the full featured collaboration in MS Office 365. Check out this live webcast to learn more about Microsoft Office 365,...
-
Where's Hadoop for Microsoft's Windows Server?
Microsoft and Hortonworks' implementation of the Hadoop big-data framework for Azure is in the midst of testing. But where's the promised Windows Server implementation?
-
Former senior Oracle exec Gary Bloom named CEO of Mark Logic
Gary Bloom returns to his database roots...
-
Hadapt partners with Cloudera, puts MPP and Hadoop side-by-side
The Big Data world has no shortage of hybrid solutions, joining BI and relational technology with Hadoop and MapReduce. Hadapt offers a hybrid too, but prefers technology coexistence to...
-
Teradata to acquire cloud digital marketing provider eCircle
Teradata announces yet another acquisition in the digital marketing space, going all-in on value-added Big Data for the CMO.
-
SAP and Oracle up the ante in the phony database wars
Round two in the war of words between Oracle and SAP is underway. This time we're trading facts and FUD.
-
-
Cloudera partners with IBM, as its own influence grows
IBM has a new partnership with Cloudera, and it's hardly the Palo Alto startup's first such deal. Is Cloudera becoming the de facto arbiter of Big Data credibility?
-
Samsung Galaxy S Aviator (photos)
The first US Cellular handset to promise 4G LTE data access, the $199 Samsung Galaxy S Aviator provides a solid if not exceptional Android experience.
-
Teradata and SAS partner on analytics appliance
Two lions of BI have allied, bringing analytics into the parallel processing, in-memory, appliance-based fast track.
-
IBM launches DB2 10, InfoSphere 10 with eye on big data
The new software is designed to integrate with big data systems, compress data and provide quick data warehouse querie
-
Analytics software market to hit $33.9 billion, says IDC
Analytics is 2012's version of the term "cloud computing." Everyone is talking cloud and everyone is talking analytics. Combine the two and vendors are in heaven.
-
10 business trends for enterprise architecture in the '10s
For enterprise architects in the years ahead thinking about the business: it's all about data, data, data.
-
What is Apple's huge data warehouse for?
Why is Steve Jobs standing in front a huge data warehouse just weeks after patching a huge privacy hole in iOS?
-
Teradata preps hybrid SSD, hard disk data warehouse appliance
Teradata launched a data warehouse appliance that puts information tiering on autopilot as it is shuttled between solid state and hard disk drives.
-
Teradata lands California smart grid implementation
Teradata said that Southern California Edison is using its data warehouse platform for its smart meter implementation.
-
EMC launches free edition of Greenplum database
EMC rolled out an open source community edition of its Greenplum data warehousing software. The free version is aimed at bringing more developers into the data warehousing fold.
-
Oracle launches data warehouse aimed at financial services
The company's Oracle Financial Services Data Warehouse hits on the common theme in enterprise software circles of targeting specific verticals with optimized software and hardware.
-
Teradata rolls out latest database, pushes time aware analysis
Teradata said its Database 13.10 is available and stumped for better time aware analysis in data warehousing applications. The company also made a bevy of other analytics moves.
-
EMC's launches Greenplum appliance
EMC will launch a Greenplum data warehousing appliance designed to take on the likes of IBM's Netezza, Oracle's Exadata and Teradata.
-
Cloudera, EMC Greenplum form data warehousing alliance
Cloudera, a Hadoop distribution provider, has forged alliances with EMC's Greenplum unit and Teradata to cover its data warehousing bases.
-
Teradata, Cloudera team up on Hadoop data warehousing
Teradata and Cloudera plan to collaborate on Hadoop-powered enterprise analytics and data warehousing projects.
Resources from our Sponsor
- Use Microsoft™'s 10-minute assessment tool to find out how private cloud ready you are today >
- Increase VM density. Not your costs. Download the white paper >
- Get the latest private cloud news from Microsoft™'s top experts. Watch the Transforming IT with Microsoft Private Cloud webcast > Increase VM density. Not your costs. Download the white paper >
The best of ZDNet, delivered
ZDNet Newsletters
Get the best of ZDNet delivered straight to your inbox
Vendor Showcase
Facebook Activity
