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 I command in QBE ? I : It is the command in QBE that is used to insert tuple (s) into the database

What are the different approaches for database design? There are two basic approaches for database design which are as follows: Attribute driven: It compiles a list of att

Define about the Stored Procedure - It's a set of T-SQL statements combined together to perform a single task formed by combining numerous small tasks. - When you essentiall

Explain the disadvantages of a file processing system? Ans: Disadvantages of File Processing Systems include: 1) Data Redundancy 2) Data Inconsistency 3) Difficult to acce

Create Relational Database Model (RDM) for Sailing bed and breakfast club Table_Name( attribute_1, attribute_2, attribute_3, ? ,attribute_x) Primary Key ( attribute_1, attribute_2)

I want Database Of United Kingdom with Criteria of:\r\n\r\n1). Name, Number, City, State, Postal Code, Address, Email id, DOB.\r\n\r\n2). Unsecure Debts only adds Credit Card Payme

Cyber Transit Ltd keeps up-to-date information on the processing and current position of each dispatched item. Dispatched items are the main concern of the Cyber Transit product tr

Explain the Query Processing  Data Query Processing permits a user to report or analyze structured and unstructured data pulled from multiple data sources.

At its most essential level the DBMS architecture can be divide into two parts: the back end and the front end. The back end is responsible for managing the physical database an

An object-oriented design process  1. Define the context and modes 2. Designs the system architecture 3. Identifies the principal system objects 4. Identifies concurrency in