Interested to Buy Any Domain ? << Click Here >> for more details...
What is a Data Warehouse and How is it Different from a Traditional Database?
- 1 Answers
- 1912 Views
- I also Faced
- E-Mail Answers
Answer Posted / hr@tgksolutions.com
A data warehouse is a central repository for storing large volumes of data from multiple sources, designed for query and analysis rather than transaction processing. It supports complex queries, data mining, and business intelligence. Unlike traditional databases optimized for day-to-day operations and transaction processing (OLTP), data warehouses are optimized for read-heavy operations, historical data analysis, and large-scale data aggregation (OLAP).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are 4 types of models?
Can anybody give me link for BOXI R3.1 Key please
What the default privileges which get assigned ?
How do databases help businesses?
Is sql is a dbms?
What is database development process?
What is bcnf in the dbms?
What is the main purpose of database?
What is meant by database server?
Can two oracle blocks have the same address?
1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????
Can you explain the select into statement?
what is the age limit for groups1 examination
What are the main functions of a database management system?
What are the main characteristics of database approach?
