A Data Warehouse is a collection of computerised data that is organised to most optimally support reporting and analysis activity. Bill Inmon's formal systems definition of a Data Warehouse is a computer database and its supporting components that is:
- Subject Oriented, meaning that the data in the database is organised so that all the data elements relating to the same real-world event or object are linked together;
- Time Variant, meaning that the changes to the data in the database are tracked and recorded so that reports can be produced showing changes over time;
- Non-Volatile, meaning that data in the database is never over-written or deleted, but retained for future reporting; and,
- Integrated, meaning that the database contains data from most or all of an organisation's operational applications, and that this data is made consistent.
Data warehouse implementations are complex because they need to intergrate all data sources into the datawarehouse. We have a team of specialists in this area who are both professional and keen to be part of your solution.
for more information email ps@starmedal.com.au |