Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Online analytical processing (OLAP) query log mining and recommending method based on efficient mining of frequent closed sequences (BIDE)

A recommendation method and log technology, which is applied in special data processing applications, instruments, electrical digital data processing, etc., can solve the problems that the recommended technology cannot be used directly, and achieve the effect of increasing speed, improving accuracy, and simplifying the expression method

Inactive Publication Date: 2011-11-23
ZHEJIANG HONGCHENG COMP SYST
View PDF0 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the traditional recommendation technology cannot be directly used in the OLAP field. The main reason is that the traditional recommendation method recommends a result, while OLAP recommends the next analysis operation in a query target of the user.

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
  • Online analytical processing (OLAP) query log mining and recommending method based on efficient mining of frequent closed sequences (BIDE)
  • Online analytical processing (OLAP) query log mining and recommending method based on efficient mining of frequent closed sequences (BIDE)
  • Online analytical processing (OLAP) query log mining and recommending method based on efficient mining of frequent closed sequences (BIDE)

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0023] Embodiment 1: the present invention is further described below in conjunction with specific embodiment, but protection scope of the present invention is not limited to this:

[0024] The system architecture of the present invention consists of two parts: data preparation and real-time recommendation. The overall system architecture is as follows: figure 1 Shown: In this system, the data preparation part is responsible for mining the query pattern in the OLAP historical query log, and the real-time recommendation part is responsible for obtaining the user's current query sequence and finding the matching pattern in the query pattern, so as to recommend the next query to the user .

[0025] General flowchart of the present invention, as figure 2 As shown, this embodiment uses MDX syntax to express OLAP queries. In the MDX query language, there is a specific grammatical structure for the definition of dimensions and levels of multidimensional data sets: for drilling at ...

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

The invention relates to the OLAP recommending technology, in particular to an online analytical processing (OLAP) query log mining and recommending method based on efficient mining of frequent closed sequences (BIDE). In the method, the possible next query is recommended to OLAP users, so that the process of browsing and analyzing multi-dimensional data by the users is simplified. The method has the advantages that: based on the characteristic of query operation in the field of OLAP, fields for expressing OLAP operation in log files are extracted, and the log files are abstracted to form a query sequence, so that the expression method of the log files is simplified; a query pattern is mined in the query sequence by a BIDE algorithm, so that the efficiency of subsequent recommending is improved on the premise of ensuring that the recommending accuracy is not reduced; a suffix tree is established on the query mode, so that a starting point of query matching is not needed to be searched for by a search algorithm in subsequent pattern matching to improve the speed of the pattern matching; and a matching algorithm of a fuzzy query pattern is provided to improve the recommending accuracy.

Description

technical field [0001] The invention relates to OLAP recommendation technology, in particular to a BIDE-based OLAP query log mining and recommendation method. Background technique [0002] Online Analytical Processing (OLAP) enables analysts and decision makers to access data quickly, consistently, and interactively from multiple perspectives. In the OLAP system, users can independently conduct data analysis and knowledge discovery from multiple perspectives through operations such as scrolling, drilling down, rotating, slicing, and dicing through multi-dimensional views, so as to gain a deeper understanding of the data. However, the process of browsing multidimensional data through OLAP operations is very cumbersome, and users are often unable to determine what to do next, and constantly try invalid query operations, which reduces the efficiency of achieving business analysis goals. [0003] In order to improve the user's rapid response to massive information, the recommen...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 张鲁杭陈岭肖敏殷婷胡黎玮
Owner ZHEJIANG HONGCHENG COMP SYST
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com