Integration
Of A Data Mining System With A Database Or Data Warehouse System
DB andDW
systems, possible integration schemes include no coupling, loose coupling,
semitight coupling, and tight coupling. We examine each of
these schemes, as follows:
1.No coupling: No coupling means
that a DM system will not utilize any function of a DB or DW system. It may fetch data from a
particular source (such as a file system), process data using some data mining
algorithms, and then store the mining results in another file.
2.Loose coupling: Loose coupling means
that a DM system will use some facilities of a DB or DW system, fetching data from a data repository managed by these
systems, performing data mining, and then storing the mining results either in
a file or in a designated place in a database or data Warehouse. Loose coupling
is better than no coupling because it can fetch any portion of data stored in
databases or data warehouses by using query processing, indexing, and other
system facilities.
However,
many loosely coupled mining systems are main memory-based. Because mining does
not explore data structures and query optimization methods provided by DB or DW
systems, it is difficult for loose coupling to achieve high scalability and
good performance with large data sets.
3.Semitight coupling: Semitight coupling means
that besides linking a DM system to a DB/DW
system, efficient implementations of a few essential data mining primitives
(identified by the analysis of frequently encountered data mining functions)
can be provided in the DB/DW system. These primitives can include sorting,
indexing, aggregation, histogram analysis, multi way join, and precomputation
of some essential statistical measures, such as sum, count, max, min ,standard
deviation,
4.Tight coupling: Tight coupling means
that a DM system is smoothly integrated into the DB/DW system. The data mining subsystem is treated as one functional
component of information system. Data mining queries and functions are
optimized based on mining query analysis, data structures, indexing schemes,
and query processing methods of a DB or DW system.
Related Topics
Privacy Policy, Terms and Conditions, DMCA Policy and Compliant
Copyright © 2018-2023 BrainKart.com; All Rights Reserved. Developed by Therithal info, Chennai.