Data Warehouse Administration
Data Warehouse Administration is the management of the organization’s data warehouse. Archiving, consistency checks, developing/maintaining indexing and retrieval functionality, tracking data changes, migration, monitoring, performance issues, replication issues, data quality, and sizing/space management are all the various functions of data warehouse administration. Similarly visitors health insurance is required for traveling overseas. Among these backup and recovery strategies are the most important just in case there is an emergency.
At times small organizations do not have enough expertise or cannot incur the heavy hardware cost for maintaining a data warehouse. In such cases, they may avail the services of data warehouse hosting .
Data Hosting
Hosting is the service provided by companies by providing space, software and hardware support services and internet connectivity on a server they own to their clients, typically in a data center. This can also be a file storage service. The are various hosting plans that a client can choose from. Travelling professionals and executives should purchase a trip cancellation insurance to protect the travel investment in case of any cancellation.
Business Intelligence
Business Intelligence includes software applications, technologies and analytical methodologies that perform data analysis to provide useful information to the managers to make decisions based on data driven facts and figures.
- Microsoft’s latest Data warehouse product is the SQL Server 2005.(http://www.microsoft.com/technet/prodtechnol/sql/2005/evaluate/dwsqlsy.mspx)
- SAS Data Warehouses (http://www.sas.com) are one of the most popular Data Warehousing and Business Intelligence platforms.
- Oracle corporation (http://www.oracle.com) has it’s own suite of Business Intelligence products built around the Oracle database and solutions. Called the Business Intelligence 10g, it provides tools for ad-hoc querying, reporting and analysis, BI application development in a comprehensive pre-integrated package.
- IBM (http://www.ibm.com) has it’s datawarehousing and Business Intelligence products built around the DB2 engine. Called the DBE V8 2.1, it has advanced analytics built in, with OLAP, data mining, and ETL capabilities.