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

Python-based data query method and device, equipment and storage medium

A data query and data technology, applied in the field of artificial intelligence, can solve problems such as low query efficiency, and achieve the effect of increasing data query speed, increasing query speed, and improving data reading speed

Pending Publication Date: 2022-03-04
CHINA PING AN PROPERTY INSURANCE CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The present invention provides a python-based data query method, device, equipment and storage medium, the main purpose of which is to solve the problem of low query efficiency when using python for data query

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
  • Python-based data query method and device, equipment and storage medium
  • Python-based data query method and device, equipment and storage medium
  • Python-based data query method and device, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

specific Embodiment approach

[0118] In detail, the specific implementation of each module of the python-based data query device 100 is as follows:

[0119] Step 1. Obtain the original data set, and use the preset python mapping program to perform database configuration on the original data set and the preset database to obtain an in-memory database.

[0120] In the embodiment of the present invention, the original data set may be products in different fields, user information, and the like. For example, in the financial field, the original data set may be the user's stock information, fund information, and trust information. The preset python mapping program may be an ORM (Object Relational Mapping, object mapping relationship program) in python. The preset database can be a sqlite3 memory database. Compared with traditional relational databases or file databases, the memory database has significantly improved reading speed of the same data, improves the response time of data query, and then improves the...

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 an artificial intelligence technology, and discloses a python-based data query method, which comprises the following steps of: performing database configuration on an original data set and a preset database by utilizing a python mapping program to obtain a memory database, performing data cleaning and data classification on the original data set to obtain a database table, and constructing a query host process based on the data query instruction, setting a timed updating sub-process based on a preset python process tool, performing data updating on the database table by utilizing the timed updating sub-process, and querying the updated database table based on the query host process to obtain a data query result. In addition, the invention also relates to a block chain technology, and the data query result can be stored in a node of a block chain. The invention further provides a python-based data query method and device, electronic equipment and a computer readable storage medium. The problem that the query efficiency is low when python is used for data query can be solved.

Description

technical field [0001] The present invention relates to the technical field of artificial intelligence, in particular to a python-based data query method, device, electronic equipment and computer-readable storage medium. Background technique [0002] Python is a clear and simple programming language with rich and practical third-party libraries. It is increasingly favored by programmers and has become the most widely used language by developers. However, due to the characteristics of its interpreted language, the operating efficiency is low and the speed is slow. For scenarios with large amounts of data or complex calculations, the processing efficiency of python is not very ideal. For example, during data query, due to the existence of Global Interpreter Lock (GIL, Global Interpreter Lock), a python interpreter process has a main thread and multiple user program execution threads, but even on a multi-core CPU platform, Python will also prohibit the parallel execution of m...

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/215G06F16/22G06F16/23G06F16/28
CPCG06F16/215G06F16/2282G06F16/23G06F16/285
Inventor 韩延福吴燕平卓陈朋张彩平李晓雄汤慧翁泽钏邱龙根黄梦如黄陈海黄静看
Owner CHINA PING AN PROPERTY INSURANCE CO LTD
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