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

Data query method and system

A data query and business system technology, applied in the new data query method and system field, can solve problems such as writing difficulties, achieve the effects of convenient partial modification, upgrade and addition, improvement of comprehensibility, and reduction of coupling degree

Inactive Publication Date: 2014-02-12
北京润乾信息系统技术有限公司
View PDF7 Cites 51 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If there are N tables involved, there may be a relationship between the two, and the connection filter conditions that may be written will be N*(N-1) / 2, and the complexity is also N 2 level, making writing very difficult

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
  • Data query method and system
  • Data query method and system
  • Data query method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0105] The business system in this embodiment is a sales management system that needs to manage customers' orders and payment collections by region and time. The business data tables that exist in this system are as follows: image 3 shown.

[0106] Step 1. First, extract the various dimensions needed in the sales management system, including customer dimension, region dimension, date dimension and product dimension. The levels contained in each dimension are as follows:

[0107] Region dimension: country, province, city

[0108] Date dimension: year, month (including year information), day (including year and month information)

[0109] Determine the calculation relationship between the base layer and the summary layer in each dimension, as follows:

[0110] Date dimension: year=int(month / 100)

[0111] Year=year(day)

[0112] month=year(day)*100+month(day)

[0113] For example: the year is 2012, the month is 201208, and the day is 2012-08-01

[0114] Region dimension: c...

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 discloses a data query method and system. The data query method includes the steps of firstly, extracting various dimensionalities in a business system, building a plurality of logical tables of business data for describing the business system, building incidence relations between the logical tables and the dimensionalities, then building mapping relations between a physical table and the logical tables according to the physical table of the business system, writing logical query statements according to the logical tables and a logical data query grammar defined according to a rule, finally, according to the mapping relations between the physical table and the logical tables, converting the logical query statements into structuring query statements, and executing the structuring query statements in a database to complete querying of the business data. According to the data query method and system, the complexity of data table understanding and writing can be reduced, and the understandability of a data structure of the business system is improved.

Description

technical field [0001] The invention relates to the technical field of data storage and query, in particular to a new data query method and system. Background technique [0002] RDB (Relational Database, relational database) and its SQL (Structured Query Language, Structured Query Language) are the most widely used data storage and query schemes in current information systems. RDB stores data in several physical tables (the basic unit for storing data in relational databases, consisting of several records with the same data structure, referred to as tables when the context is clear). Each table is composed of several records with the same data structure. Properties are called fields. Some of the fields are designated as the primary key of the table, and the values ​​of these fields (groups) are required to be unique in the records in the table (that is, no two records have the same values ​​on these fields), so that this group of field values ​​can be used Uniquely identif...

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): G06F17/30
CPCG06F16/2453G06F16/2264G06F16/285
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