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

Self-service query system based on online analysis and processing

An online analysis and processing and query system technology, applied in the direction of structured data retrieval, database model, etc., can solve the problems of inapplicability, achieve the effect of easy to use, improve the efficiency of query and analysis, and facilitate the use of query

Pending Publication Date: 2019-04-05
EAST CHINA JIAOTONG UNIVERSITY
View PDF3 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, as the market pays more and more attention to user data and the real-time requirements for decision-making continue to strengthen, the previous analysis tools for user offline data (that is, non-real-time data) have gradually become unsuitable for modern analysis.

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
  • Self-service query system based on online analysis and processing

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] The self-service query system based on online analysis and processing of the present invention is a B / S architecture. The system includes a user terminal, a front-end server, a database server, and a database. The user terminal accesses the front-end server through a Web browser for query, and the front-end server communicates with the database server; the database is connected; The server is configured with an online analysis and processing OLAP program module. The OLAP program module is used to build a database table into a multi-dimensional data cube, obtain data source tables, and establish corresponding fact tables and dimension tables. The front-end server is configured with an interface program module, and the front-end server calls the database server data for query through the interface program module. The OLAP program module is developed based on Apache Kylin, and the interface program module of the front-end server is developed based on SpringBoot.

[0023] The ...

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 a self-service query system based on online analysis and processing, the system is of B / S architecture, the system comprises a user terminal, a front-end server, a database server and a database, the user terminal accesses the front-end server for query through a Web browser, and the front-end server is in communication connection with the database server; The database server is provided with an online analysis and processing OLAP program module, and the OLAP program module is used for establishing a multi-dimensional data cube for the database table to obtain a data source table; The front-end server is provided with an interface program module, and the front-end server calls data of the database server through the interface program module to inquire the data.

Description

Technical field [0001] The invention relates to a self-service query system based on online analysis processing. Background technique [0002] With the rapid increase in the number of Internet users and the widespread application of big data technology in enterprises, more and more user behavior data are generated in enterprise databases. Through data cleaning, mining and other technologies, some behavioral data that helps companies make decisions can be obtained. However, the data obtained cannot directly meet the needs of enterprises to analyze user behavior. In recent years, relational databases are still widely used as mainstream data storage media in enterprises, and enterprises have also developed corresponding application systems on this basis to maintain them. However, with the increasing emphasis of the market on user data and the increasing real-time requirements for decision-making, the previous analysis tools for user offline data (ie non-real-time data) have gradua...

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): G06F16/28
Inventor 余鹰袁朝晖石红芹张应龙
Owner EAST CHINA JIAOTONG UNIVERSITY
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