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-2008 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- Stolen: Google employees' personal data
- Names, addresses, and Social Security numbers of pre-2006 staffers were taken from offices of Colt Express Outsourcing Services. Google has confirmed that personal data of U.S. employees hired prior to 2006 have been stolen in a recent burglary. Records kept at Colt Express Outsourcing Services, an external...
- News items 2008-07-03
- Viacom vs YouTube exposes Google's data retention policy
- Viacom vs YouTube exposes Google's data retention policyDon't trust GoogleGoogle has more information about more people, all over the world, than any government agency anywhere in the world. People worry about the Bush administration, but they should be worrying about Google.Power corrupts. Absolute power corrupts, absolutely.If you don't...
- Discussion threads 2008-07-03
- EIC podcast: Search wars; Viacom vs. YouTube (and its users)
- EIC podcast: Search wars; Viacom vs. YouTube and its usersViacom's Data DragnetIt seems to me that their is no justification for allowing this data dragnet.Whether dynamic or static, IP addresses can be traced back to many of the original users through data from Internet service providers. The Whitter article cited...
- Discussion threads 2008-07-03
- On deck from MS: Four 'important' patches but nothing for IE
- Next Tuesday, Microsoft plans to ship four security updates for multiple flaws affecting Windows, Microsoft SQL Server and Microsoft Exchange Server but the absence of fixes for publicly known Internet Explorer issues is causing raised eyebrows among security professionals. According to the company's advance notice for July's...
- Blog posts 2008-07-03
- I have to stop using Gmail :(
- I have to stop using Gmail :(You can enable POP3 support in Gmail...If you switch on POP3 support in Gmail, then you can still comply with archiving procedures: http://mail.google.com/support/bin/answer.py?hl=en&answer=13273That way, you can both send and receive e-mails with an e-mail client like Thunderbird or Evolution or even Outlook Express. I...
- Discussion threads 2008-07-03
- Viacom vs YouTube exposes Google's data retention policy
- In the ongoing litigation between Viacom and YouTube Google over alleged copyright infringement, a US court has ruled that Google must divulge the viewing habits of every user who has ever watched any video on YouTube. The one thing that bothers me more than the court ruling itself, however, is...
- Blog posts 2008-07-03
- Judge: Viacom gets 12TB of YouTube user data
- Judge: Viacom gets 12TB of YouTube user dataWell it's not like anyone has EVER... used an IP address to take legal action against an individual....oh wait. They have.Never mind.RE: Judge: Viacom gets 12TB of YouTube user dataGlad I am not a Google Log-Oner!Of course who's to say that the data...
- Discussion threads 2008-07-03
- Encrypt File or Parent Folder (How to encrypt data on your laptop for holiday travel)
- Encrypt File or Parent Folder How to encrypt data on your laptop for holiday travelencryptionso hard to used, how about a printable form, all pages...this might have been useful.RE: Encrypt File or Parent Folder How to encrypt data on your laptop for holiday travelOR you could just right-click on the...
- Discussion threads 2008-07-03
- Opera patches serious code exection flaw
- Opera Software has joined the list of browser vendors shipping fixes for serious remote code execution vulnerabilities. The company's new Opera 9.5.1 patches at least four security issues, the most serious being a flaw reported by Microsoft's Billy Rios that could be used to execute arbitrary code....
- Blog posts 2008-07-03
- Q'n'A: Are Youtube users are royally screwed?
- I've been reading the headlines today, and the main headlines on most of the top technology websites are about the YouTube/Google/Viacom saga. I'd like to call this: Youglecomgate, a potentially volatile situation hovers over the midst of everyone who has been on YouTube ever, so that's probably the majority of...
- Blog posts 2008-07-03
- Judge: Viacom gets 12TB of YouTube user data
- A federal judge ordered PDF Google to hand over 12 terabytes of YouTube user data to Viacom, finding that the list of "login IDs" does not qualify as personally identifying information. In opposing Viacom's request for the information, Google had asserted users' privacy rights: "Plaintiffs would...
- Blog posts 2008-07-03
- I have to stop using Gmail :(
- Regular readers know that I'm a Google devotee. Between Gmail and Google Apps, I spend more time accessing Google servers than any other place on the Net. Since I forward my other school accounts to Gmail, I can use the slick Gmail interface with all of my mail....
- Blog posts 2008-07-03
- 12 terabytes of YouTube data
- 12 terabytes of YouTube dataHorrible loss for ConsumersThis Judge needs to be taught what he has the power to do, and not to do. This is a clear violation of the Video Privacy Protection Act. Not to mention a major privacy issue for all of us that have ever watched...
- Discussion threads 2008-07-03
- 12 terabytes of YouTube data
- A lot of us block YouTube access in our schools. There's plenty of objectionable content worth hiding from young eyes. Probably an equal number of us, however, leave it open at the request of teachers who use its vast resources for teaching (yes, there is more than zit...
- Blog posts 2008-07-03
- Getaway day: How to secure your laptop for holiday travel
- It's getaway day and as we prepare to hit the road, trudge through airport security and snag that car rental, spare a thought for the valuable data that travels with you on that trusty old laptop. According to a recent study by the Ponemon Institute, more than...
- Blog posts 2008-07-03
- Amid ugly job picture, tech related employment holds up
- The U.S. economy lost 62,000 jobs in June for the sixth straight month of employment losses with an unemployment rate of 5.5 percent, but underneath the technology sector is holding up well, according to Labor Department statistics. What a difference a downturn makes. Last...
- Blog posts 2008-07-03
- How to encrypt data on your laptop for holiday travel
- Instructions on how to encrypt files or folders on Windows XP and Windows Vista. by Ryan Naraine
- Image galleries 2008-07-03
- YouTube vs. Viacom: Google's IP wins; Users lose
- Updated: The latest battle in Google's ongoing court battle with Viacom over YouTube copyright infringement is a glass half full or half empty situation. In the half full department, Google scored a legal victory as a judge shot down Viacom requests for the search giant's search code and other critical...
- Blog posts 2008-07-03
- OzLINK for UPS OnLine Tools (exe)
- You now can quickly and easily track a package, check rates and validate an address all from one integrated user interface. Along with support for standard UPS tracking numbers, OzLINK seamlessly tracks packages by a customers internal reference number. OzLINK displays all services, all rates and all delivery commitment times...
- Software downloads 2008-07-03
- SecureRequest (zip)
- If you have a classic asp application that is not secured against SQL injection attacks then SecureRequest is the way to go! By replacing the native ASP request-object you'll be in full control of all the data that is passed by your Web sites's visitors before it can do any...
- Software downloads 2008-07-03
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- The Cisco Mobility Resource Center is your source for FREE mobility solutions
-
The Cisco Mobility Resource Center offers FREE videos, downloads, podcasts and more, all designed to help small and medium businesses get mobile connectivity solutions, improve productivity and drive sales and revenue.
- New mobility solutions at the Cisco Mobility Resource Center
- Which solar technology will survive?
-
At the Cleantech Forum in San Francisco, Todd Glass of Heller Ehrman moderates a discussion, among tech execs, on the various solar technologies making a difference in the green movement.
- Watch the video >>
- New entries posted to Know Issues, Best Practices and Workarounds Wiki
-
Latest Topics: Running virtual machines and DHCP can cause Intel® AMT to be inaccessible; Wildcard certificates are currently not supported for remote; Dell 755 returns a duplicate UUID during activation configuration.
- See the latest entries on the Intel Wiki >>
- BNET Industries
- Check out BNET's newest resource for managers and executives. Need to do research on your competitors? Don't have time to read every trade pub? BNET Industries is the new source for daily news, insights, and research on 11 major industries and 9,000 public companies.
-
- The technology industry from a different angle
-
- See what's hot in the auto industry
-
- Stay on top of the energy industry
