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

Real-time query system for organization data

A technology of organization and query system, which is applied in the field of data processing, can solve the problem that external systems cannot realize real-time query of organization data, and achieve the effect of protecting data security

Active Publication Date: 2019-12-20
重庆华医康道科技有限公司
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The purpose of the present invention is to propose a real-time query system for organization data, which aims to solve the problem in the prior art that external systems cannot realize real-time query organization data

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
  • Real-time query system for organization data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0031] This embodiment will provide a real-time query system for organization data, see figure 1 , figure 1 A schematic diagram of an organization data real-time query system provided in this embodiment;

[0032] The real-time query system for organizational data includes: at least one organizational database, kettle, data distributor, Flink, OpenApi (Java program), and external systems;

[0033] Optionally, the organization in this embodiment may be a hospi...

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 real-time query system for organization data. The real-time query system comprises a database of at least one organization, a kettle, a data distributor, a Flink, an OpenApi and an external system, the database of each organization creates a view according to the business requirement of the organization, and data in the view is provided for an external system to inquire; when a query request sent by an external system is received, the kettle extracts data from a database view corresponding to the query request, and performs field conversion on the extracted data according to a preset field; the data distributor distributes the data subjected to field conversion to the Flink; the Flink performs format conversion on the distributed data according to a preset format,and sends the data subjected to format conversion to the OpenApi as a query result; the OpenApi outputs a query result to an external system; real-time conversion of organizational structure data is achieved, and an external system can inquire the organizational structure data in real time.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to an organization data real-time query system. Background technique [0002] At present, the database of the organization has a view, and a new DB user U is added. Only the query authority for the view is set to provide the data required by the external system. The external system connects to the database as user U and queries the view every 10 seconds. Obtain real-time data; this method is not really real-time. If it fails, it needs to perform compensatory operations after checking the data on the same day, and consumes a lot of performance. At present, there is no real-time query function of the organization's data in external systems. Contents of the invention [0003] The purpose of the present invention is to propose a real-time query system for organization data, which aims to solve the problem in the prior art that external systems cannot realize real-time query of...

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/25G06F16/2458G06F16/28G06F16/21
CPCG06F16/25G06F16/258G06F16/2471G06F16/283G06F16/211
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