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
Explain Strict Two-Phase locking A transaction T does not release any type of its exclusive (X) locks until that transaction commits or aborts. In this method no other transact

How does Tuple-oriented relational calculus vary from domain-oriented relational calculus? The tuple-oriented calculus uses a tuple variables i.e., variable whose only allowed

Concurrency issues Data integrity: Threads accessing same object need to be synchronized, such as: banking account. Deadlock: One or more threads in system are perman

State the Design of Associations Before designing associations, it is essential to know the way they are used. For this, analysis of association traversals is required. It is

explain three types of internet risks to the consummers whent he business system is data dependent. how can we minimise these risks


A database administrator''s responsibilities and data contents

A Functional dependency is described by X Y between two groups of attributes Y and X that are subsets of R specifies a constraint on the possible tuple that can make a relation

Storage Of Database On Hard Disks At this point, it is worthwhile to note the difference among the terms file Organisation and the access method. A file organisation shows to t

Define Forms Based Interfaces? Forms-Based Interfaces - A forms-based interface display a form to each user. Forms are commonly designed and programmed for naive users and inte