Data cross-database access method and device

An access method and database technology, applied in database management systems, electronic digital data processing, structured data retrieval, etc., can solve problems such as poor timeliness of data acquisition and affect the progress of big data analysis, and achieve timely data acquisition sexual effect

Active Publication Date: 2020-09-18
CHENGDU SEFON SOFTWARE CO LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, this data acquisition method has the problem that the timeliness of data acquisition is not strong, which affects the implementation progress of big data 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
  • Data cross-database access method and device
  • Data cross-database access method and device
  • Data cross-database access method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] In order to make the purposes, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments It is a part of the embodiments of this application, not all of them. The components of the embodiments of the application generally described and illustrated in the figures herein may be arranged and designed in a variety of different configurations.

[0029] Accordingly, the following detailed description of the embodiments of the application provided in the accompanying drawings is not intended to limit the scope of the claimed application, but merely represents selected embodiments of the application. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art w...

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 cross-database access method and device. The method comprises the following steps of receiving a data access request from a user terminal, and analyzing to obtain all target database identifiers and target data characteristics corresponding to each target database identifier; searching a target mapping table corresponding to the target database identifier in all stored Hive data mapping tables; when the target data features are found, querying feature information corresponding to the target data features in a target mapping table; accessing a target server provided with a database corresponding to the target mapping table, and acquiring target acquisition data matched with the inquired feature information; and after obtaining the target acquisition data corresponding to all the target mapping tables, carrying out data arrangement on all the target acquisition data, and feeding back an arrangement data result to the user terminal. According to the method, the cross-database associated access of data among a plurality of databases can be realized, the overall data acquisition timeliness is improved, and the realization progress of big data analysis is ensured.

Description

technical field [0001] The present application relates to the technical field of database cross-database access, and in particular, relates to a data cross-database access method and device. Background technique [0002] With the continuous development of science and technology, the application of big data technology is becoming more and more extensive. With the use of big data technology in various industries, different types of data are usually stored in different types of databases. For example, the general-purpose business system Real-time data is usually stored in a relational database built with an oracle database style or a MySQL database style, while historical data of a general-purpose business system is stored in a non-relational database built with an HBase database style or a Hive database style . In this case, big data technology needs to perform data query on each database separately, and correspondingly obtain the desired data from each database before realiz...

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 Patents(China)
IPC IPC(8): G06F16/25G06F16/2455G06F16/84G06F16/835
Inventor 李森林王纯斌贾金元张永飞
Owner CHENGDU SEFON SOFTWARE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap