mumbai university-> computer engineering -> Semester 8 -> Data Warehousing and Management --> . Asked for 10M in May2015

• Each user will have a data mining task in mind, that is, some form of data analysis that he or she would like to have performed.

• A data mining task can be specified in the form of a data mining query, which is input to the data mining system.

• A data mining query is defined in terms of data mining task primitives. These primitives allow the user to inter- actively communicate with the data mining system during discovery in order to direct the mining process, or examine the findings from different angles or depths.

• The data mining primitives specify the following, as illustrated in Figure 1.1.

1. The set of task-relevant data to be mined: This specifies the portions of the database or the set of data in which the user is interested. This includes the database attributes or data warehouse dimensions of interest (referred to as the relevant attributes or dimensions).
2. The kind of knowledge to be mined: This specifies the data mining functions to be per- formed, such as characterization, discrimination, association or correlation analysis, classification, prediction, clustering, outlier analysis, or evolution analysis.
3. The background knowledge to be used in the discovery process: This knowledge about the domain to be mined is useful for guiding the knowledge discovery process and for evaluating the patterns found. Concept hierarchies are a popular form of back- ground knowledge, which allow data to be mined at multiple levels of abstraction. An example of a concept hierarchy for the attribute (or dimension) age is shown in Figure 1.2. User beliefs regarding relationships in the data are another form of back- ground knowledge.
4. The interestingness measures and thresholds for pattern evaluation: They may be used to guide the mining process or, after discovery, to evaluate the discovered patterns. Different kinds of knowledge may have different interestingness measures. For example, interestingness measures for association rules include support and confidence. Rules whose support and confidence values are below user-specified thresholds are considered uninteresting.
5. The expected representation for visualizing the discovered patterns: This refers to the form in which discovered patterns are to be displayed, which may include rules, tables, charts, graphs, decision trees, and cubes.

• A data mining query language can be designed to incorporate these primitives, allowing users to flexibly interact with data mining systems.

• Having a data mining query language provides a foundation on which user-friendly graphical interfaces can be built.

• This facilitates a data mining system’s communication with other information systems and its integration with the overall information processing environment.

• Designing a comprehensive data mining language is challenging because data mining covers a wide spectrum of tasks, from data characterization to evolution analysis. Each task has different requirements.

• The design of an effective data mining query language requires a deep understanding of the power, limitation, and underlying mechanisms of the various kinds of data mining tasks.

• There are several proposals on data mining languages and standards. In this book, we use a data mining query language known as DMQL (Data Mining Query Language), which was designed as a teaching tool, based on the above primitives.

• Examples of its use to specify data mining queries appear throughout this book.

• The language adopts an SQL-like syntax, so that it can easily be integrated with the relational query language, SQL. Let’s look at how it can be used to specify a data mining task.