The past two decades has seen a dramatic increase in the
amount of information or data being stored in electronic format. This
accumulation of data has taken place at an explosive rate. It has been
estimated that the amount of information in the world doubles every 20 months
and the size and number of databases are increasing even faster. The increase
in use of electronic data gathering devices such as point-of-sale or remote
sensing devices has contributed to this explosion of available data.
Data mining potential can be enhanced if the appropriate
data has been collected and stored in a data warehouse. A data warehouse is a
relational database management system (RDMS) designed specifically to meet the
needs of transaction processing systems. It can be loosely defined as any
centralised data repository which can be queried for business benefit but this
will be more clearly defined later. Data warehousing is a new powerful
technique making it possible to extract archived operational data and overcome
inconsistencies between different legacy data formats. As well as integrating
data throughout an enterprise, regardless of location, format, or communication
requirements it is possible to incorporate additional or expert information. It
is,
the logical link between what the managers see in
their decision support EIS applications and the company's operational
activities
John McIntyre of SAS Institute Inc
In other words the data warehouse provides data that is already transformed and summarized, therefore making it an appropriate environment for more efficient DSS and EIS applications.
No comments:
Post a Comment