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

Database query method and system and electronic equipment

A query method and data query technology, applied in the field of database query, can solve problems such as inability to query data in multidimensional databases, inability to return user relational data, etc., and achieve the effect of improving user experience

Inactive Publication Date: 2022-03-04
广州思迈特软件有限公司
View PDF6 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] In view of this, the application provides a database query method, system and electronic equipment, which solves the problem that users cannot query data in multidimensional databases using structured query statements, and cannot return relational data to users, thereby improving user experience.

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
  • Database query method and system and electronic equipment
  • Database query method and system and electronic equipment
  • Database query method and system and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0031] The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, but not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present application.

[0032] The relational database is a database based on the relational database model. The table of the relational database uses two-dimensional tables to store data. It is a logical group with related information arranged in rows and columns. The logical structure of a relational model is a two-dimensional table consisting of rows and columns. This two-dimensional table is called a relationship. A database can contain any num...

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 provides a database query method and system and electronic device.The database query method comprises the steps that an SQL statement input by a user on a user terminal and sent by the user terminal is received, a multi-dimensional expression MDX statement is obtained according to the first SQL statement, multi-dimensional data are obtained from a multi-dimensional database according to the MDX statement, and meanwhile, the multi-dimensional data are obtained according to the MDX statement; the method comprises the following steps: acquiring a first SQL statement, converting multi-dimensional data into relational data, generating a relational data table according to the relational data, acquiring a second SQL statement according to the first SQL statement and address information of the relational data table, querying in the relational data table according to the second SQL statement to obtain a data query result, and sending the data query result to a user terminal. According to the technical scheme, the data can be queried in the multi-dimensional database by using the structured query statement, and the data can be returned to the user relational data table, so that the user experience is improved.

Description

technical field [0001] The present application relates to the field of database query, and more particularly, to a database query method, system and electronic device. Background technique [0002] Structured Query Language (SQL), referred to as SQL, is a database query language used to access data and query, update and manage relational databases. The relational database has the advantages of simple syntax, easy to understand and use, and easy to maintain, so it is widely used in data analysis work, and therefore, has a large user group. Compared with relational databases, multidimensional databases have the advantages of faster data processing speed, faster response time, and higher query efficiency in complex data analysis scenarios such as calculation of chain ratios and year-on-year ratios. [0003] However, the user group of the SQL statement cannot directly use the SQL statement to query in the multidimensional database, and cannot return the relational data table to...

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
IPC IPC(8): G06F16/242G06F16/2455G06F16/28
CPCG06F16/242G06F16/2455G06F16/284
Inventor 黄浩曹攀黄潮勇吴华夫
Owner 广州思迈特软件有限公司
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