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
Determine the Three Views of Data We know that the similar thing, if viewed from dissimilar angles produces difference sights. Similarly, the database that we have formed alrea

Create an entity relationship diagram, Database Management System

DROP TABLE Command: When an existing object is not needed for further use, it is always better to eliminate it from the database. To remove the existing object from the databas

What is magnetic disks?explain it? Magnetic disk provides the bulk of secondary storage of modern computer system. The disk capacity is growing at over 50% per year. But the st

For this application, we will consider IBM DB2 catalog data (i.e., metadata) for IBM's enterprise-class servers running the z/OS (formerly OS/390 or MVS) operating system.  One of

Q. Describe how an ER schema can be represented by relation schemas and constraints arising from ER design can be mapped to constraints on a relation schema.     The entity rela

1. Which model is used to store data in tree structures Ans: Hierarchical model is used to store data in tree structures


List out various user authorization to modify the database schema. a)  Index authorization b)  Resource authorization c)  Alteration authorization d)  Drop authorizat

need a DBMS system on any data for assignment.