ISO/IEC 13249-6:2006

Information technology — Database languages — SQL multimedia and application packages — Part 6: Data mining

ISO/IEC 13249 defines a number of packages of generic data types common to various kinds of data used in multimedia and application areas, to enable that data to be stored and manipulated in an SQL database. ISO/IEC 13249-6:2006 introduces the data-mining package, gives the necessary references, defines notations and conventions specific to ISO/IEC 13249-6:2006, defines concepts specific to ISO/IEC 13249-6:2006, and defines data mining user-defined types and their associated routines. The data-mining user-defined types defined in ISO/IEC 13249-6:2006 are generic to data-mining data handling. They address the need to store, manage and retrieve information based on elements such as data-mining models, data-mining settings, and data-mining test results.

Technologies de l'information — Langages de bases de données — Multimédia SQL et paquetages d'application — Partie 6: Exploration de données

General Information

• Status: Published
• Publication Date: 24-Oct-2006
• ICS: 35.060 - Languages used in information technology
• Technical Committee: ISO/IEC JTC 1/SC 32 - Data management and interchange
• Drafting Committee: ISO/IEC JTC 1/SC 32 - Data management and interchange
• Current Stage: 9093 - International Standard confirmed
• Completion Date: 30-Apr-2021

Relations

• Revises: ISO/IEC 13249-6:2002 - Information technology — Database languages — SQL multimedia and application packages — Part 6: Data mining
• Effective Date: 15-Apr-2008

Standards Content (Sample)

INTERNATIONAL ISO/IEC
STANDARD 13249-6
Second edition
2006-11-01
Corrected version
2006-12-01


Information technology — Database
languages — SQL multimedia and
application packages —
Part 6:
Data mining
Technologies de l'information — Langages de bases de données —
Multimédia SQL et paquetages d'application —
Partie 6: Exploration de données





Reference number
ISO/IEC 13249-6:2006(E)
©
ISO/IEC 2006

---------------------- Page: 1 ----------------------
ISO/IEC 13249-6:2006(E)
PDF disclaimer
This PDF file may contain embedded typefaces. In accordance with Adobe's licensing policy, this file may be printed or viewed but
shall not be edited unless the typefaces which are embedded are licensed to and installed on the computer performing the editing. In
downloading this file, parties accept therein the responsibility of not infringing Adobe's licensing policy. The ISO Central Secretariat
accepts no liability in this area.
Adobe is a trademark of Adobe Systems Incorporated.
Details of the software products used to create this PDF file can be found in the General Info relative to the file; the PDF-creation
parameters were optimized for printing. Every care has been taken to ensure that the file is suitable for use by ISO member bodies. In
the unlikely event that a problem relating to it is found, please inform the Central Secretariat at the address given below.


©  ISO/IEC 2006
All rights reserved. Unless otherwise specified, no part of this publication may be reproduced or utilized in any form or by any means,
electronic or mechanical, including photocopying and microfilm, without permission in writing from either ISO at the address below or
ISO's member body in the country of the requester.
ISO copyright office
Case postale 56 • CH-1211 Geneva 20
Tel. + 41 22 749 01 11
Fax + 41 22 749 09 47
E-mail [e-mail]
Web www.iso.org
Published in Switzerland

ii © ISO/IEC 2006 – All rights reserved

---------------------- Page: 2 ----------------------
ISO/IEC 13249-6:2006(E)

Contents Page

Foreword. ix
Introduction . x
1 Scope. 1
2 Normative references . 2
2.1 International standards . 2
2.2 Publicly-available specifications. 2
3 Terms, definitions, notations and conventions . 3
3.1 Terms and definitions. 3
3.2 Notations. 10
3.2.1 Notations provided in ISO/IEC 13249-1. 10
3.2.2 Notations provided in this part of ISO/IEC 13249. 10
3.3 Conventions . 11
4 Concepts. 12
4.1 Data mining techniques. 12
4.2 Computational phases. 12
4.2.1 Training phase. 12
4.2.2 Model introspection phase. 13
4.2.3 Application phase . 15
4.2.4 Testing phase . 16
4.3 Mapping on user-defined types. 17
4.3.1 Target application . 17
4.3.2 The relationships of the user-defined types . 17
4.3.3 User-defined types that are not related to mining techniques. 19
4.3.4 User-defined types that are related to mining techniques . 19
5 Data Mining Data Types. 22
5.1 DM_LogicalDataSpec Type and Routines . 22
5.1.1 DM_LogicalDataSpec Type . 22
5.1.2 DM_addDataSpecFld Method . 24
5.1.3 DM_remDataSpecFld Method . 25
5.1.4 DM_getNumFields Method. 26
5.1.5 DM_getFldName Method . 27
5.1.6 DM_setFldType Method. 28
5.1.7 DM_getFldType Method. 30
5.1.8 DM_isCompatible Method . 31
5.2 DM_MiningData Type and Routines. 32
5.2.1 DM_MiningData Type. 32
5.2.2 DM_defMiningData Method. 34
5.2.3 DM_setFldAlias Method. 35
5.2.4 DM_genDataSpec Method. 36
5.3 DM_ApplicationData Type and Routines. 37
5.3.1 DM_ApplicationData Type. 37
5.3.2 DM_genDataSpec Method. 38
5.3.3 DM_impApplData Method. 39
6 Association Rules . 40
© ISO/IEC 2006 – All rights reserved
iii

---------------------- Page: 3 ----------------------
ISO/IEC 13249-6:2006(E)
6.1 DM_RuleSettings Type and Routines . 40
6.1.1 DM_RuleSettings Type . 40
6.1.2 DM_impRuleSettings Method . 43
6.1.3 DM_expRuleSettings Method . 44
6.1.4 DM_setRuleFilter Method. 45
6.1.5 DM_getRuleFilter Method. 46
6.1.6 DM_setMinSupport Method . 47
6.1.7 DM_getMinSupport Method . 48
6.1.8 DM_setMinConf Method . 49
6.1.9 DM_getMinConf Method. 50
6.1.10 DM_setMaxLength Method . 51
6.1.11 DM_getMaxLength Method . 52
6.1.12 DM_useRuleDataSpec Method . 53
6.1.13 DM_getRuleDataSpec Method. 54
6.1.14 DM_setGroup Method. 55
6.1.15 DM_getGroup Method. 56
6.1.16 DM_setSequence Method . 57
6.1.17 DM_getSequence Method . 58
6.2 DM_RuleBldTask type and Routines . 59
6.2.1 DM_RuleBldTask Type . 59
6.2.2 DM_defRuleBldTask Method . 60
6.2.3 DM_getRuleTrnData Method. 61
6.2.4 DM_getRuleSettings Method . 62
6.2.5 DM_buildRuleModel Method. 63
6.3 DM_RuleModel Type and Routines. 64
6.3.1 DM_RuleModel Type. 64
6.3.2 DM_impRuleModel Method . 67
6.3.3 DM_getRuleMdlType Method. 68
6.3.4 DM_expRuleModel Method . 69
6.3.5 DM_applyRuleModel Method. 70
6.3.6 DM_getNumItemSets Method . 71
6.3.7 DM_getNumSequences Method . 72
6.3.8 DM_getNumRules Method . 73
6.3.9 DM_filterRules Method . 74
6.3.10 DM_getNumTransacts Method . 75
6.3.11 DM_getItemSets Method . 76
6.3.12 DM_getRules Method. 77
6.3.13 DM_getRuleBodies Method . 78
6.3.14 DM_getSequences Method . 79
6.3.15 DM_getSeqDetails Method. 80
6.3.16 DM_getSeqRules Method. 81
6.3.17 DM_getRuleBldTask method . 83
6.4 DM_RuleFilter Type and Routines. 84
6.4.1 DM_RuleFilter Type. 84
6.4.2 DM_addRangeConstr Method. 86
6.4.3 DM_remRangeConstr Method . 88
6.4.4 DM_getRangeConstrs Method. 89
6.4.5 DM_setMaxNumRules Method. 90
6.4.6 DM_getMaxNumRules Method . 91
6.4.7 DM_addCountConstr Method . 92
6.4.8 DM_remCountConstr Method. 93
6.4.9 DM_getCountConstrs Method . 94
6.4.10 DM_setItemConstr Method . 95
6.4.11 DM_getItemConstrs Method . 97
6.5 DM_RuleApplTask Type and Routines . 98
6.5.1 DM_RuleApplTask Type . 98
6.5.2 DM_defRuleApplTask Method . 100
6.5.3 DM_getRuleMdl Method . 102
 © ISO/IEC 2006 – All rights reserved
iv

---------------------- Page: 4 ----------------------
ISO/IEC 13249-6:2006(E)

6.5.4 DM_getRuleApplData Method. 103
6.5.5 DM_getRuleOutpData Method . 104
6.5.6 DM_getRuleGroupFld method . 105
6.5.7 DM_applyRuleMdl method . 106
7 Clustering . 107
7.1 DM_ClusSettings Type and Routines . 107
7.1.1 DM_ClusSettings Type . 107
7.1.2 DM_impClusSettings Method . 109
7.1.3 DM_expClusSettings Method . 110
7.1.4 DM_setMaxNumClus Method. 111
7.1.5 DM_getMaxNumClus Method . 112
7.1.6 DM_setFldWeight Method . 113
7.1.7 DM_getFldWeight Method. 114
7.1.8 DM_setFldSimScale Method . 115
7.1.9 DM_getFldSimScale Method. 116
7.1.10 DM_useClusDataSpec Method . 117
7.1.11 DM_getClusDataSpec Method . 118
7.2 DM_ClusBldTask type and Routines . 119
7.2.1 DM_ClusBldTask Type . 119
7.2.2 DM_defClusBldTask Method . 120
7.2.3 DM_getClusTrnData Method. 121
7.2.4 DM_getClusSettings Method . 122
7.2.5 DM_buildClusModel Method. 123
7.3 DM_ClusteringModel Type and Routines. 124
7.3.1 DM_ClusteringModel Type. 124
7.3.2 DM_impClusModel Method . 126
7.3.3 DM_expClusModel Method . 127
7.3.4 DM_getNumClusters Method. 128
7.3.5 DM_getClusters Method. 129
7.3.6 DM_getMdlQuality Method. 130
7.3.7 DM_applyClusModel Method . 131
7.3.8 DM_getClusTask method . 132
7.3.9 DM_getClusMdlSpec method . 133
7.3.10 DM_getFields. 134
7.4 DM_ClusApplTask Type and Routines . 135
7.4.1 DM_ClusApplTask Type . 135
7.4.2 DM_defClusApplTask Method . 137
7.4.3 DM_getClusMdl Method . 138
7.4.4 DM_getClusApplData Method. 139
7.4.5 DM_getClusOutpData Method . 140
7.4.6 DM_getClusResFld method . 141
7.4.7 DM_applyClusMdl method . 142
7.5 DM_ClusResult Type and Routines . 143
7.5.1 DM_ClusResult Type . 143
7.5.2 DM_getClusterID Method . 144
7.5.3 DM_getQuality Method . 145
8 Classification. 146
8.1 DM_ClasSettings Type and Routines . 146
8.1.1 DM_ClasSettings Type . 146
8.1.2 DM_impClasSettings Method . 149
8.1.3 DM_expClasSettings Method. 150
8.1.4 DM_setClasCostRate Method . 151
8.1.5 DM_getClasCostRate Method. 152
8.1.6 DM_setClasCost Method. 153
8.1.7 DM_getClasCost Method. 154
8.1.8 DM_useClasDataSpec Method . 155
© ISO/IEC 2006 – All rights reserved
v

---------------------- Page: 5 ----------------------
ISO/IEC 13249-6:2006(E)
8.1.9 DM_getClasDataSpec Method . 156
8.1.10 DM_setClasTarget Method. 157
8.1.11 DM_getClasTarget Method. 158
8.2 DM_ClasBldTask Type and Routines. 159
8.2.1 DM_ClasBldTask Type . 159
8.2.2 DM_defClasBldTask Method. 161
8.2.3 DM_getClasTrnData Method . 162
8.2.4 DM_getClasValData Method . 163
8.2.5 DM_getClasSettings Method . 164
8.2.6 DM_buildClasModel Method . 165
8.3 DM_ClasModel Type and Routines . 166
8.3.1 DM_ClasModel Type . 166
8.3.2 DM_impClasModel Method . 169
8.3.3 DM_expClasModel Method . 170
8.3.4 DM_applyClasModel Method . 171
8.3.5 DM_testClasModel Method . 172
8.3.6 DM_getClasCostRate Method. 173
8.3.7 DM_isValidated Method. 174
8.3.8 DM_getRankQuality method. 175
8.3.9 DM_getPredAccuracy Method. 176
8.3.10 DM_getReliability Method . 177
8.3.11 DM_getMdlQuality Method. 178
8.3.12 DM_getGainsChart method. 179
8.3.13 DM_getClasTask method . 180
8.3.14 DM_getClasMdlSpec method. 181
8.3.15 DM_getFields. 182
8.3.16 DM_getClasTarget method . 183
8.4 DM_ClasTestTask Type and Routines. 184
8.4.1 DM_ClasTestTask Type. 184
8.4.2 DM_defClasTestTask Method. 185
8.4.3 DM_getClasTestData Method . 186
8.4.4 DM_getClasTestMdl Method . 187
8.4.5 DM_testClasMdl Method . 188
8.5 DM_ClasTestResult Type and Routines . 189
8.5.1 DM_ClasTestResult Type . 189
8.5.2 DM_getClasError Method. 191
8.5.3 DM_getRankQuality Method . 192
8.5.4 DM_getPredAccuracy Method. 193
8.5.5 DM_getReliability Method . 194
8.5.6 DM_getMdlQuality Method. 195
8.5.7 DM_getGainsChart Method.
...