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.
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.
 | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2009 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- News to know: Intel; Microsoft layoffs; Motorola, Palm; Oracle-Sun; MSN
- Here are today's notable headlines. You can get News To Know via email alert and RSS daily. For continuous updates see BNET's around-the-Web tech coverage.: Sam Diaz: New York AG files antitrust charges against Intel; alleges bribery, coercion Mary Jo Foley: Are the Microsoft...
- Blog posts 2009-11-05
- HP takes converged infrastructure a notch higher with new data warehouse appliance
- HP isn’t just betting on a market whim. Recent market research it supported reveals that more than 90 percent of senior business decision makers believe business cycles will continue to be unpredictable for the next few years â€" and 80 percent recognize they need to be far more flexible in...
- Blog posts 2009-11-04
- 3DPaintBrush 2.0 (Windows)
- 3DPaintBrush is a real-time and easy-to-use visualization tool that enables you to create near photo-realistic images and videos from your 3D models. You can easily enhance an existing model by adding colors, textures, shaders, background, lighting and camera effects, background environments to create quick yet stunning images. Import 3D models...
- Software downloads 2009-11-04
- MightyQuery 1.0.1 (Windows)
- MightyQuery is a single user SQL database management software working with data stored as comma separated values (.csv, .txt) in plain, flat, textual files. It is serverless, self-contained, simple and effective SQL DBMS for querying CSV files. In contrast to most database systems, MightyQuery does not require neither server installation,...
- Software downloads 2009-10-27
- Advanced ETL Processor 2.4.2.8 (Windows)
- Advanced ETL Processor extracts data from any database, transforms, validates it and loads into another database automatically. A unique technology called "What You See Is What You Load" saves a lot of time during testing and design of validation and transformation processes. It shows you how the data will be...
- Software downloads 2009-10-26
- Brickbats over bricks
- This is an IT Tech site, Mr. Fuller.ntCodes as gatekeepers?As an architect, I have never once consulted a building code to determine which product I should use for a building, especially considering that neither clay brick or fly ash brick is likely to be used in a structural capacity. ...
- Discussion threads 2009-10-21
- Teradata unveils cloud strategy, answer for Oracle's Exadata machine
- Data warehousing giant Teradata is outlining its cloud computing strategy including an internal cloud service and a public offering via Amazon Web Services. In addition, Teradata is rolling out an appliance it claims will provide a big performance boost. The announcements, timed for Teradata's partner conference in...
- Blog posts 2009-10-19
- Microsoft's 'Madison' data-warehouse-appliance testing set for July
- A copy of a current utility billsRE: Microsoft's 'Madison' data-warehouse-appliance testing set for JulyPine Trail isn?t going to be in the ultrathins. My mistaken interpretation there. An Intel spokesperson sent the sexy costumesfollowing correction: ?Only netbooks are Atom-based, not ultra thin laptops. Our ultra thin laptops have processors including Core...
- Discussion threads 2009-10-14
- ARK Systems Waybill Tracking 8.02 (Windows)
- Freight / Courier software with online PODs, pickup requests, scanned house bills options. This easy-to-use package prints invoices, house waybills, alerts, labels. Export to QuickBooks or Excel. Add-ons include Client/Server back-end, EDI, and Warehouse Management. The program is customizable to fit your needs. Need to improve your Web site? Our...
- Software downloads 2009-10-09
- Collaboration Strategy Shortcomings? Whack the Community Manager
- There's been a good flow of conversation around the role of 'community management' in large companies recently, with an underlying idea that although it's a tough job things will work out if the right people are involved, although Dennis Howlett recognises the danger of burn out....
- Blog posts 2009-10-03
- Massive But Agile: Best Practices for Scaling the Next-Generation Enterprise Data Warehouse - Forrester Report
- Information and knowledge management (I&KM) professionals continue to expand the scale, scope, and deployment roles for their enterprise data warehouse EDW investments. Information managers are adopting EDW best practices that push the scalability and performance envelope without sacrificing the agility to optimize this critical infrastructure to ever-changing analytic workloads. This...
- White papers 2009-10-02
- The coming "big crunch" - IT systems will start failing on a large scale
- ScaremongeringAll that was missing - the placard reading 'The End of the World is Nigh'.So my critical, clustered systems are going to start failing are they? Why did I cluster them then?My RAID arrays are going to start failing are they? Why did I go RAID then? And have I...
- Discussion threads 2009-09-29
- Infobright Community Edition (ICE) (64-bit) 3.2 (Windows)
- Infobright technology combines a column-oriented database with our Knowledge Grid architecture to deliver the ideal solution for your growing analytic needs. While other data warehouse products require extensive IT effort to create indexes, partition data and build physical data structures, our self-managing solution delivers rapid response to complex queries created...
- Software downloads 2009-09-22
- Infobright Community Edition (ICE) 3.2 GA (Windows)
- Infobright technology combines a column-oriented database with our Knowledge Grid architecture to deliver the ideal solution for your growing analytic needs. While other data warehouse products require extensive IT effort to create indexes, partition data and build physical data structures, our self-managing solution delivers rapid response to complex queries created...
- Software downloads 2009-09-16
- Microsoft exec: 'When Windows is executing well, Microsoft is in good shape'
- upgrade pathdo you really think that people will rush to their next best buy to make a clean install on their old xp hardware? do you think corporations will want the hassle of clean installs on their xp hardware? never going to happen. windows 7 is a non event in...
- Discussion threads 2009-09-15
- AMD's Charlie Boswell: With cloud computing, 'follow the money' [interview]
- Cloud computing can't possibly handle streaming a first-person shooter or a feature-length film, can it? Ask AMD's Charlie Boswell, and he'll not only tell you it's possible, but he'll nearly leap with excitement about it. Boswell, AMD's director of digital...
- Blog posts 2009-09-11
- MySQL Workbench OSS 5.1.18 (Mac)
- MySQL Workbench enables a DBA, developer, or data architect to visually design, generate, and manage all types of databases including Web, OLTP, and data warehouse databases. It includes everything a data modeler needs for creating complex ER models, and also delivers key features for performing difficult change management and documentation...
- Software downloads 2009-09-05
- Is your supply chain gonna kill you?
- A General Management Issue?To me, the biggest roadblock to change is treating this as a supply chain or IT issue and not a general management issue. Most companies today function in a networked world, where they are critically dependent on other companies. The dependence goes way beyond "supply chain." The...
- Discussion threads 2009-09-04
- EMC Corporation Delivers Reports in Minutes With Unified Data Warehouse and Analytics Tools
- EMC Corporation wanted to consolidate disparate data sources to reduce total cost of ownership, improve efficiency, and sharpen decision making and provide diverse users with insight into data on various topics, from sales metrics and customer information to Human Resources HR and financial figures. The challenge was to grow market...
- Case studies 2009-09-01
- iPhone soars, Microsoft 'main loser'
- Well......Beings I don't tie my confidence to a phone or computer I could give two sh1ts about what anyone thinks. Frankly the Samsung Omnia has been an excellent phone and I have no problem letting anyone and everyone see me use it. Plus Windows Mobile is in alot of...
- Discussion threads 2009-08-20
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
SmartPlanet
- Thought-provoking progressive ideas on diverse topics that intersect with technology, business, and life, and matter to the world at large. Visit SmartPlanet
- More from IBM
-
- Can your business work smarter? Learn more about Lotus Symphony
- Learn how to work smarter and optimize cost using the IBM Smart SOA approach Download the eBook
- Smarter ways to make smarter products Read the brief from IBM
