| Information warehousing implies information that is | | | | and data warehousing must be equipped with |
| integrated from several diverse sources into a single | | | | information technology skill sets. Being able to build |
| comprehensive database that can be easily | | | | database structures and knowing the nuances of |
| manipulated. There is only one database in the end | | | | relational database management are a must for the |
| and sources can be many provided of course that | | | | staff working on data warehousing. The business |
| the database is able to manage the volume. This | | | | intelligence people are usually experts in statistics and |
| method has been employed by businesses to analyze | | | | mathematics. Both these tools are therefore created |
| trends over the years to make and plan strategies. | | | | to help identify trends through an overview of past |
| An overview of long term data can help a company | | | | accumulated transactional data to arrive at sound |
| to make business models, projections and forecasts | | | | business decisions. |
| but this data remains read-only and to modify it, one | | | | A data warehouse appliance is a combined collection |
| would need to make a new query. But this does not | | | | of software and hardware designed for a definite |
| mean data is never updated here, rather, in a data | | | | purpose comprising of servers, data storage facilities, |
| center warehouse, data gets updated all the time. | | | | operating systems, database management systems |
| Data warehousing only stores particular information | | | | etc that are optimized for data warehousing. |
| for particular analyses while the more comprehensive | | | | Organizations use information warehouse appliances |
| data storage needs infrastructure wherein data | | | | for its multiple advantages: |
| cannot be easily changed. Data warehousing is more | | | | Optimize different areas of information processing. |
| used by big companies that analyze large chunks of | | | | Easy to deploy and maintain like any ordinary |
| data for business functions. Smaller organizations | | | | household appliance since it does not require any |
| seek data marts that deal with more focused | | | | indexing or fine tuning. |
| information. | | | | Can deliver nearly thousands of query processing |
| Business intelligence data and data warehousing are | | | | nodes in a single appliance package. |
| both terms that cause a lot of confusion regarding | | | | Can offer a high performance advantage nearly 100 |
| their connotation. While the latter means the | | | | times faster than general-use information |
| technology used to create a bank of data, business | | | | warehousing systems. |
| intelligence refers to tools used to analyze and | | | | Low maintenance costs since it does not need any |
| interpret such information. Both work in sync to | | | | indexing to improve performance. |
| support a user dashboard which can give customized | | | | Low power requirements since processors do not |
| data to a user. Business intelligence software helps to | | | | need to handle voluminous information |
| manage huge amounts of data, build queries and | | | | Allows businesses to staff their warehouse better |
| make reports. While the data warehouse holds | | | | and helps middle level organizations to deal with |
| transactional information, business intelligence reviews | | | | business intelligence challenges. |
| the data. Personnel working on business intelligence | | | | |