Analytic logical data model

a data model and analytical technology, applied in relational databases, data mining, instruments, etc., can solve the problems of reaching the limits of traditional query and reporting tools, difficult for humans to see or interpret subtle relationships, and organizations are beginning to amass very large databases

Inactive Publication Date: 2003-04-22
TERADATA US
View PDF13 Cites 136 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Benefits of technology

The patented technology allows customers to see how their owners are being used over time. It uses tables that show which products they have been using most frequently and who use them first. These tables can be updated regularly with new data from previous transactions. This helps businesses make informed decisions about where to purchase these items based on their usage patterns.

Problems solved by technology

This patent describes a technical problem addressed in the patent text describing the challenges faced during the development of a data retrieval system called Intelligent Platform Control (IPSC) that uses advanced analytic function engines to efficiently retrieve data from a database. Current methods involve generating executable code modules and storing them in order to meet the needs of data mineralograms (ADL) programming languages. However, current methods require extensive effort and resources to develop a solution for optimizing data mining operations.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Analytic logical data model
  • Analytic logical data model
  • Analytic logical data model

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

Results Table

This table supports the MODES function to calculate modes, or the most frequently occurring value(s) for a column. This function takes as parameters a table name and column name, and determines the value(s) of the column that occurs most frequently. Note that this may result in more than one row as more than one value can occur the maximum number of times. By default, the smaller of these maximum occurring values is returned along with the number of modes or modality. Optionally, the user can request that all modal values be returned. The count and a percentage are also returned either the percentage of all selected records or, if the group option is used, the percentage within each group.

OVERLAP Results Table

This table supports the OVERLAP function to count overlapping column values in combinations of tables. This function takes as parameters a column name and a list of table names, and calculates the number of instances of that column which each pair-wise combination of

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

A method, apparatus (1), and article of manufacture for performing data mining applications (110) in a relational database management system (114). An analytic logic data model (LDM) provides logical entity and attribute definitions for advanced analytic processing (112) performed by the relational database management system directly against the relational database.

Description

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Owner TERADATA US
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap