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

Report data query method, device and system based on multiple data sources and storage medium

A report data, multi-data source technology, applied in database model, relational database, digital data processing and other directions, can solve the problems of slow speed, error-prone, low efficiency, etc., to reduce time consumption, improve efficiency, and improve accuracy Effect

Active Publication Date: 2021-03-19
SUZHOU KEDA TECH
View PDF6 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] This application provides a report data query method, device, and storage medium based on multi-source data, which can solve the problems of low efficiency, slow speed, and error-prone in existing data processing methods from different data sources

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
  • Report data query method, device and system based on multiple data sources and storage medium
  • Report data query method, device and system based on multiple data sources and storage medium
  • Report data query method, device and system based on multiple data sources and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0055] The specific implementation manners of the present application will be further described in detail below in conjunction with the drawings and embodiments. The following examples are used to illustrate the present application, but not to limit the scope of the present application.

[0056] An embodiment of the present invention provides a report data query method based on multi-source data, which integrates data from different data sources into a report to facilitate query and improve query efficiency.

[0057] figure 1 It is a schematic diagram of the network architecture of the data query system provided by an embodiment of this application, please refer to figure 1 , the network architecture of the data query system includes: a client computer device 1 and a server-side data management platform 2, and the client computer device 1 and the server-side data management platform 2 establish a network connection. Optionally, the client computer device 1 may be a user's de...

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 report data query method, device and system based on multiple data sources and a storage medium, and belongs to the technical field of computer data processing. The method comprises the steps: according to a report generation request, obtaining a report target task, analyzing the report target task, and obtaining a main task and multiple sub-tasks, determining a target data source corresponding to the main task and an associated data source corresponding to each sub-task; according to the associated data source, obtaining report data of different data sources corresponding to each subtask, and processing each subtask to obtain a result data set corresponding to each subtask; processing each result data set according to an association relationship with a target data source to generate a target report; and obtaining a data query result according to the target report. According to the method, the problem of relatively low query speed caused by data query of different data sources can be solved; according to the method and the device, different data sources can be integrated into one report by decomposing the target task, so that quick query of the data is realized.

Description

technical field [0001] The application relates to a report data query method, device, system and storage medium based on multiple data sources, and belongs to the technical field of computer data processing. Background technique [0002] In daily work, users often need to query business-related data information, and the query data results often need to be obtained by querying data from different data sources. The data source is simply the source of the data, which refers to the data used by the database application. A database or database server is a device or raw medium that provides some kind of required data. All information for establishing a database connection is stored in the data source. Just as a file can be found in the file system by specifying its name, by providing the correct data source name the corresponding database connection can be found. [0003] The data results that users want to query are generally displayed in the form of reports. When the data resu...

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/2457G06F16/248G06F16/28
CPCG06F16/2457G06F16/248G06F16/287Y02D10/00
Inventor 谭璟刘配齐周军
Owner SUZHOU KEDA TECH
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