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

Data processing method and device based on virtual data table technology and electronic equipment

A data processing and data table technology, applied in the database field, can solve the problem that ordinary users do not have permission to design or maintain data tables, etc.

Pending Publication Date: 2020-09-04
PING AN BANK CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] Data tables in relational databases are usually designed by software developers for specific business scenarios. To store and retrieve data in other business scenarios or data with different data structures, new data tables need to be designed additionally. Moreover, usually data tables The database administrator (Database Administrator, referred to as DBA) or operation and maintenance personnel is responsible for the maintenance work, and ordinary users do not have the authority to design or maintain the data table

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 processing method and device based on virtual data table technology and electronic equipment
  • Data processing method and device based on virtual data table technology and electronic equipment
  • Data processing method and device based on virtual data table technology and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0042] An embodiment of the present invention provides a data processing method based on virtual data table technology. refer to figure 1 As shown, it is a schematic flowchart of the data processing method based on the virtual data table technology provided by the first embodiment of the present invention. The method may be performed by a device, and the device may be implemented by software and / or hardware.

[0043] In detail, the first embodiment of the present invention is described from the perspective of how to implement data processing based on virtual data table technology, including:

[0044] S1. Create a first data table and a second data table in the pre-built database, wherein the first data table is used to store the metadata of the virtual data table created by the user, and the second data table is use...

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 big data, and discloses a data processing method based on a virtual data table technology, which comprises the following steps: receiving a virtual data table of a user; acquiring metadata of the virtual data table, and storing the metadata into a first data table pre-created in a preset database; acquiring data stored in the virtual data table by a user, and storing the data in a second data table pre-created in a preset database; and detecting an editing operation of a user on the virtual data table, and converting the editing operation of the user on the virtual data table into an editing operation on the first data table and / or the second data table through a preset conversion function. The invention also relates to a blockchain technology, and the virtual datatable is stored in the blockchain. Based on the virtual data table, a user is helped to achieve visual and simple modification operation on the data table in the database.

Description

technical field [0001] The present invention relates to the technical field of databases, in particular to a data processing method, device, electronic equipment and computer-readable storage medium based on virtual data table technology. Background technique [0002] Data tables in relational databases are usually designed by software developers for specific business scenarios. To store and retrieve data in other business scenarios or data with different data structures, new data tables need to be designed additionally. Moreover, usually data tables The database administrator (Database Administrator, referred to as DBA) or operation and maintenance personnel are responsible for the maintenance work, and ordinary users do not have the authority to design or maintain the data table. [0003] However, in some business scenarios, it is necessary to determine the structure of the data table according to the user's needs, so as to store and retrieve the data of the user-specific ...

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/22G06F16/28G06F40/18G06N3/04
CPCG06F16/2282G06F16/284G06F40/18G06N3/047Y02D10/00
Inventor 朱传亮
Owner PING AN BANK 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