What are a database and a data warehouse?

Sharad Jaiswal
Sharad Jaiswal

Posted On: Feb 22, 2018

 

A database, in general, is a collection of information in a more organized form for better access. The data can be stored or executed in multiple ways and collectively they are defined as tables, views or database objects. Data warehouse refers to the medium of a repository of the data from the multiple resources. The data from the data warehouse is available to transform or even use in online processing.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    SQL Server Interview Questions

    What is normalization according to you and explain its different levels?

    In order to remove the redundant data, normalization is used. It also reduces the null values and enables the efficiency of indexing...

    SQL Server Interview Questions

    What do you understand by the denormalisation?

    Denormalization is the inverse process of normalization...

    SQL Server Interview Questions

    Is there any difference between the primary key and unique key?

    There is, of course, a difference between the primary and unique key..