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
- Yahoo's dwindling search share: Time to panic?
- Typical MicrosoftThis is normal business practice for MS. Partner up with someone, take what they need, then discard them.Ask anyone from RealNetworks how their partnership went.It's about search.Wow, it looks like the volume of search users use the search engine that delivers better results.Google search is better than Bing...
- Discussion threads 2009-11-18
- MySQL Workbench OSS 5.2.8b1 (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-11-18
- Advanced ETL Processor 2.4.2.9 (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-11-13
- NBL Inventory 1.3.1 (Windows)
- NBL Inventory is a Windows database-driven software designed for soho, small and medium size company, to manage and monitor raw material warehouse or finished product stock quantity and movement Master Editor: Store Employee, Organization particular / contact and Material / Product information. Listing: Query, print or export master data and...
- Software downloads 2009-11-12
- 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
- CST TPV Free Edition 2.13.0 (Windows)
- Consoltic POS 2010 is a management software application for retail outlets. Its main functions are: management of sales POS; customer management; cash management; warehouse management; supplier management; user management; multilanguage; multicompany; multistore; multisupplier; multirate; synchronizing data between different stores; campaign management and rebates; import and export to excel; collecting cash...
- Software downloads 2009-11-02
- 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
- 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
- Finansbank Improves Performance and Availability of Enterprise Data Warehouse
- Finansbank wanted to implement a new enterprise data warehouse solution to support core banking data from a variety of sources and relieve performance loads on the existing data warehouse and manage a large and rapidly growing data store, now at 16 terabytes and doubling in size approximately every 15 months....
- Case studies 2009-10-01
- Lombard Odier Reduces Data Warehouse Development Times With Integrated Solution
- Lombard Odier is a financial services provider that offers private and institutional clients a wide range of advisory services in asset management, financial products, and specialized areas. Lombard Odier used to handle the consolidation with file extracts that were then loaded in a cube system. They needed to replace this...
- Case studies 2009-10-01
- JSC Kapital Strakhovanie Accelerates Decision Making With Consolidated Data Analysis Solution
- JSC Kapital Strakhovanie wanted to improve the effectiveness of the company's data analysis and management and provide a consolidated data repository as well as the capability to meet regulatory and analytical reporting needs. The challenge was to build a unified processing center for data presentation and provide consolidated reporting capabilities,...
- Case studies 2009-10-01
- Gobierno del Estado de Veracruz, Mexico Improves Analysis With Integrated Information System
- Gobierno del Estado de Veracruz wanted to create a robust, flexible, and scalable information system to facilitate information gathering and provide access to up-to-date information for objective decision making and provide a secure data warehouse to extend information visibility throughout the organization. The challenge was to establish performance analysis indicators...
- Case studies 2009-10-01
- 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
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- Keep Up With The Latest In Document Management with The DocuMentor.
-
Doc delivers the scoop on today's enterprise content management, printer maintenance, and all other issues related to document management. It's the DocuMentor Blog.
- Learn more >>
- New Online Dashboard for IT Leaders
-
Read about top issues IT decision-makers face every day, plus get cost-effective solutions to real-life IT problems.
- Learn more >>
- The best support in the Linux business
-
If Linux is going to power your mission-critical applications, you'd better have the best support known to business. Novell was rated the top provider of Linux technical support.
- Learn more >>
- Learn more about tools to grow your business
-
The Business Essentials Guide provides you useful tools and templates to help grow your business and save you time with automated shipping solutions.
- Save time with the UPS Business Essentials Guide
- Microsoft Dynamics CRM Online - Free Six-Month Trial for Eligible Organizations
-
Microsoft Dynamics CRM Online provides fast online access, simple contact management and better sales performance for a low monthly cost - the best value on the market today.
- Learn more about the free, six-month trial offer>>
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
