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
- 2042 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
Enlist various types of interactions created by dbms?
Is it good to store image in database?
What is data abstraction in dbms?
Mention the differences between the clustered and non-clustered index
What are stored procedures in a database?
What do you mean by denormalization?
Explain environment of openedge?
Where is database used?
What is pcbs (program communication blocks)?
Have you written applications to retrieve stored images in a table?
Why is maintaining a database important?
What is sql in dbms?
What is normalization in dbms?
What are the advantages of manual database?
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????
