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
Draw an EER diagram that captures the "is-a" hierarchy of students in another simple database. The database captures both the "basic" information (say, student ID and student name)

Consider the subsequent relation schemes:  Project (Project#, Project_name, chief_architect)  Employee (Emp#, Empname)  Assigned_To (Project#, Emp#)  Give expression i

Increased parallelism : Since the replicated date has several copies a query can be distributed or can be answered from the smallest loaded site. Also, with more replicas you have

Give an example of enforcement in Typing. You can understand the idea of enforcement as it makes sure objects of dissimilar classes may not be interchanged as below:  Exampl

What is NULL? Simply NULL means not in value.

The Third Normal Form (3NF) Even though, transforming a relation that is not in 2NF into a number of relations that are in 2NF take out many of the anomalies, it does not neces

What are the several kinds of the update operations on relations? Also explain the constraints on these update operation. Give instance in support of your answer. There are th

What are domain constraints? A domain is a set of values that might be assigned to an attribute .all values that appear in a column of a relation must be taken from the similar

Enumerate or state the steps in creating a relevant database of a shop.

Example : Create a sequence named SEQSS that starts at 105, has a step of 1 and can take maximum value as 2000.  CREATE SEQUENCE SEQSS START WITH 105 INCREMENT BY 1 MAX VA