Databases and data warehouses , Database Management System

Databases and data warehouses both are databases and both contains number of rows and columns of tables containing data. Data warehouse is really different from databases because data warehouse helps in creating a sustainable analysis. It is designed for analysis facilities and query facilities. The data that is stored in a data warehouse is multi dimensional and in databases it ensures that the solution is scalable and managed in a better way and answers the questions easily and very effectively. In most of the companies, managers are most interested in knowing about the buying patterns of the group of the customers rather dealing with only one customer and only one purchase. It is easily found in the data warehouses decision support system if the sale has been just made.

Most businesses have not just one large database for all their data, both current and historical because in one single database the data is more risky and it becomes easy for a hackers to steal the data, they would achieve their target very easily because if they hack this one single database which is very large in its size they will also save their cost and money and will achieve their target very easily. If you have only one database you will require giving details to some form of access to sales, research and marketing. Most companies have multiple domains and they control their data in these multiple locations. Big companies always host multiple databases with huge number of small systems.

 

Posted Date: 3/15/2013 3:33:36 AM | Location : United States







Related Discussions:- Databases and data warehouses , Assignment Help, Ask Question on Databases and data warehouses , Get Answer, Expert's Help, Databases and data warehouses Discussions

Write discussion on Databases and data warehouses
Your posts are moderated
Related Questions
How to design a formal and exact model How to design a formal and exact model of real-world problems by applying findings of analysis phase of OMT. The object design phase find

What are the kinds of Strings?  -A binary string in MySQL is one that MySQL treats as case sensitive in comparisons. -A non binary string in MySQL is one that MySQL does'nt

What are object interaction diagrams? Object interaction diagrams are the diagrams that used to describe order in which messages are communicated in execution of an operation,

Use Access 2007 to create a database called UniLib.mdb. - this file should be created on your personal drive at the university (or C: if you're using Access 2007 at home) and t

Describe identifying relationship? Identifying relationship: It is relationship among strong entity and a weak entity it is represented through a doubly outlined diamond in C

Association as a cache This association must be updated when any new element is added to it, but testing for overlap using association is more efficient.    Figure:

Differentiate between various levels of data abstraction? Data Abstraction - Abstraction is the procedure to hide the irrelevant things from the users and represent the rele

Data Manipulation Language Data manipulation language (DML) describes a set of commands that are used to query and change data within existing schema objects. In this case comm

Timestamps For Read operations: If TS (T) If TS (T) >= W-timestamp (Q), then the transaction T is trying to read a value of data item Q which has been written and committed

An instance of relational schema R (A, B, C) has distinct values of A including NULL values. then A is a candidate key or not? If relational schema R (A, B, C) has distinct val