Overview - ISO/IEC 13249-6:2006 (Data mining)
ISO/IEC 13249-6:2006 is part of the SQL multimedia and application packages series and defines a standardized data‑mining package for SQL databases. The standard introduces data‑mining concepts, notations and conventions specific to the package and specifies user‑defined types (UDTs) and associated routines to store, manage and retrieve data‑mining artifacts such as models, settings and test results directly within an SQL environment.
Keywords: ISO/IEC 13249-6, data mining, SQL, database, user-defined types, data-mining models
Key topics and technical requirements
- Scope and conventions
- Defines terms, notations and conventions specific to the data‑mining package and references other parts of ISO/IEC 13249.
- Computational phases
- Covers standard data‑mining phases including training, model introspection, application, and testing - enabling consistent lifecycle management of models in SQL.
- User‑defined types and routines
- Specifies generic UDTs for data‑mining tasks (e.g., types handling logical data specifications, mining data, application data) and their associated methods for definition, import/export, and manipulation.
- Technique‑specific support
- Includes detailed constructs for common techniques such as association rules (DM_RuleSettings, DM_RuleModel, DM_RuleBldTask, etc.) and clustering (DM_ClusSettings, DM_ClusBldTask, DM_ClusteringModel).
- Interoperability
- Maps mining concepts onto SQL UDTs to enable storage, retrieval and consistent handling of models and results across compliant database systems.
Keywords: association rules, clustering, DM_RuleSettings, DM_ClusSettings, DM_MiningData
Practical applications and who uses it
- Database vendors and DBMS implementers
- Implement the UDTs and routines to embed data‑mining capabilities natively in relational systems.
- Application developers and data engineers
- Store, version and apply models, settings and test results inside databases for reproducible, auditable analytics workflows.
- Data scientists and analytics teams
- Use standardized storage of models and rules to simplify deployment, model introspection and integration with SQL queries and ETL processes.
- Enterprise architects and solution integrators
- Leverage standard UDTs to ensure cross‑platform compatibility and reduce custom serialization logic for models.
Practical benefits: tighter integration of analytics with transactional data, consistent model lifecycle management, easier portability of mining artifacts.
Keywords: SQL database, data-mining package, model storage, analytics integration
Related standards
- ISO/IEC 13249 series (e.g., ISO/IEC 13249-1 for shared notations and base definitions)
- Other SQL standards and parts of the multimedia/application packages series for broader context and interoperability.
Keywords: ISO/IEC 13249, SQL multimedia and application packages
Open preview (PDF)Information technology — Database languages — SQL multimedia and application packages — Part 6: Data mining