Tuesday, July 22, 2014

Data Warehouse


In computing, a data warehouse (DW, DWH), or an enterprise data warehouse (EDW), is a system used for reporting and data analysis. Integrating data from one or more disparate sources creates a central repository of data, a data warehouse (DW). Data warehouses store current and historical data and are used for creating trending reports for senior management reporting such as annual and quarterly comparisons.
The data stored in the warehouse is uploaded from the operational systems (such as marketing, sales, etc., shown in the figure to the right). The data may pass through an operational data store for additional operations before it is used in the DW for reporting.Continue Reading...
From Wikipedia, the free encyclopedia

How Data Warehouse Works
Data Warehouse Books
Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals By Paulraj Ponniah
Data Warehousing: Using the Wal-Mart Model By Paul Westerman
Data Warehousing: Architecture and Implementation By Mark Humphries, Michael W. Hawkins
Data Warehousing Fundamentals for IT Professionals By Paulraj Ponniah
Data Warehouses and OLAP: Concepts, Architectures, and Solutions edited by Robert Wrembel, Christian Koncilia

Tuesday, July 15, 2014

MongoDB


MongoDB
(from "humongous") is a cross-platform document-oriented database. Classified as a NoSQL database, MongoDB eschews the traditional table-based relational database structure in favor of JSON-like documents with dynamic schemas (MongoDB calls the format BSON), making the integration of data in certain types of applications easier and faster. Released under a combination of the GNU Affero General Public License and the Apache License, MongoDB is free and open-source software.

First developed by the software company 10gen (now MongoDB Inc.) in October 2007 as a component of a planned platform as a service product, the company shifted to an open source development model in 2009, with 10gen offering commercial support and other services.Since then, MongoDB has been adopted as backend software by a number of major websites and services, including Craigslist, eBay, Foursquare, SourceForge, Viacom, and the New York Times, among others. MongoDB is the most popular NoSQL database system.
Continue Reading....
From Wikipedia, the free encyclopedia


MongoDB Tutorials

MongoDB Vidios


Document-Oriented Database


A document-oriented database is a computer program designed for storing, retrieving, and managing document-oriented information, also known as semi-structured data. Document-oriented databases are one of the main categories of NoSQL databases and the popularity of the term "document-oriented database" (or "document store") has grown with the use of the term NoSQL itself. In contrast to relational databases and their notions of "Relations" (or "Tables"), these systems are designed around an abstract notion of a "Document".Continue Reading...
From Wikipedia, the free encyclopedia

Document-Oriented Database Books
Beginning Database Design Solutions By Rod Stephens
The Definitive Guide to MongoDB: The NoSQL Database for Cloud and Desktop ... By Peter Membrey, Eelco Plugge, Tim HawkinsMongoDB and Python: Patterns and Processes for the Popular Document-oriented ... By Niall O'HigginsMongoDB in Action

Wednesday, July 2, 2014

DBMS Architecture


The design of a Database Management System highly depends on its architecture. It can be centralized or decentralized or hierarchical. DBMS architecture can be seen as single tier or multi tier. n-tier architecture divides the whole system into related but independent n modules, which can be independently modified, altered, changed or replaced.Continue Reading....
From Tutorialspoint

DBMS Architecture Books
Architecture of a Database System By Joseph M. Hellerstein, Michael Stonebraker, James Hamilton
Real-Time Database Systems: Architecture and Techniques edited by Kam-Yiu Lam, Tei-Wei Kuo
Advanced database machine architectureExpert Oracle Database Architecture: 9i and 10g Programming Techniques and ... By Thomas Kyte

Monday, June 30, 2014

Temporal Database


A temporal database is a database with built-in support for handling data involving time, for example a temporal data model and a temporal version of Structured Query Language (SQL).
More specifically the temporal aspects usually include valid time and transaction time. These attributes can be combined to form bitemporal data.
  • Valid time is the time period during which a fact is true with respect to the real world.
  • Transaction time is the time period during which a fact stored in the database is considered to be true.
  • Bitemporal data combines both Valid and Transaction Time.Continue Reading.....
From Wikipedia, the free encyclopedia

Temporal database books
Temporal Databases: Research and Practice edited by Opher Etzion, Sushil Jajodia, Suryanarayana Sripada
Temporal databases: theory, design, and implementation Abdullah Uz Tansel
Active, Real-Time, and Temporal Database Systems: Second International ... edited by Sten F. Andler, Jörgen Hansson
Spatio-Temporal Databases: The CHOROCHRONOS Approach edited by Manolis Koubarakis
Spatio-Temporal Database Management: International Workshop STDBM'99 ... edited by Michael H. Böhlen, Christian S. Jensen, Michel O. Scholl





Wednesday, June 25, 2014

Cloud Database


A cloud database is a database that typically runs on a cloud computing platform, such as Amazon EC2, GoGrid, Salesforce and Rackspace. There are two common deployment models: users can run databases on the cloud independently, using a virtual machine image, or they can purchase access to a database service, maintained by a cloud database provider. Of the databases available on the cloud, some are SQL-based and some use a NoSQL data model.Continue  Reading....
From Wikipedia, the free encyclopedia