what is the main difference between database and datawarehousing?

Answer 1

database is 'live' (info being actively added and changed)
datawharehouse tends to be archived (little change on a daily basis)
////

Answer 2

Database is storage of data. Generally the data is stored in an orderly manner, so that it is easy to retreive it later. So database programming primarily deals with "LIVE" or "CURRENT" data. Online Transaction Programming (OLTP) is the primary mode that is involved in Database Programming. One simple example is the buying of a computerized train ticket, where the primary fact that the system looks into is the availability of tickets. Yet before they issue the ticket to you they gather all the other data and store them, which can be of use in DataWarehousing. Technically OLTP systems are Relational Database Management Systems (RDBMS).
Now coming to Datawarehousing, it is Multidimensional database management system (MDBMS) which primarily relies on Historical data to come out with analysis. Hence it is Online Analytical Process (OLAP) system. Data from many different databases are fed into one central database system and the data is modified to the required analysis and reports are generated. So continuing with the railway ticket example, if railways wants to analyze the data and plan for a seasonal introduction of trains, it can easily come out with a solution.
Hope this answer is useful.
Merry christmas and happy 2007

Answer 3

DataWarehousing is utilizing a Database to Store Large Amount of Information in forms of tables,Views etc - upto GBs , Terabits . This information is then analyzed , sorted, Profiled and then reports / Summaries are created from this Huge Volume of Data for various requirement. This operation takes help of various Datawarehousing Tools such as Vendor or Third Party Tools , Reporting Tools like OLAP TOOLS , Reporting Tools such as Brio to carry out the Tasks .

Example could be collecting and Sorting/Analyzing Rainfall and Climate Patterns for a Particular region for a period of 20 years . Or Information of Programs telecasted by a TV Channel for past 7 years . and so on

Answer 4

Islam and Christianity are definitely rather comparable in many respects. the main distinction is that Christianity places emphasis on love and faith in God, while Islam emphasizes submission to God. it particularly is the main philosophical distinction. of direction, ceremonies variety a great deal, with Muslims requiring 5 short guy or woman prayer sessions consistent with day at everywhere, and Christians having weekly group conferences at a church or different accumulating area. Muslims even have some nutritional regulations that Christians do no longer. A notice of warning: there are diverse misconceptions approximately Islam in usa, because of the prejudice in the media. i'd wager that below a million% of Muslims in the worldwide prepare Islam as maximum individuals come across it to be practiced. in case you learn Islam, make surely specific that's from a superb source. i'd advise utilising books, as a google seek will yield all styles of rubbish, tremendously if it replaced into written positioned up-9/11.

Answer 5

Transactional Database Vs DataWarehouse database
1. Transactional Database is Relational Database with normalized tables, whereas a database designed to store a DataWarehouse contains denormalized Tables.

2. Transactional Database is highly volatile... Designed to maintain transactions of the business Whereas DataWarehouse is non volatile.. contains historic data with periodic updates.

3. Transactional Database is OLTP... Datawarehouse is disconnected ... and for analysis...

4. Transactional Database contains functional data e.g. Invoices, purchase orders, cash receipts etc.... DataWarehouse contains data that is subject oriented e.g. Net Sales, Items sold, Gross Profit.

Answer 6

DATA BASE is the LOCATION (from your name, you seem to be an Indian and in Indian English such a place is usually known as a "Godown"), complete with the Materials, where the Data is available.

DATA WAREHOUSING is the structured, orderly, easy-to-find arrangement of the Data within the Godown - like stacking inside Shelves, Cupboards, Racks etc - similar to the alphabetical arrangements - Titlewise/Authorwise - of books in a Library.

So retrieval of the Data is easy.

Answer 7

1)A databse is any structred set of data
2)A data warehouse is a collection of data gathered and organized so that it can easily by analyzed, extracted, synthesized, and otherwise be used for the purposes of further understanding the data. It may be contrasted with data that is gathered to meet immediate business objectives such as order and payment transactions, although this data would also usually become part of a data warehouse.

Answer 8

from what i remember, database is a collection of data and data warehousing is when you retrieve the data.