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

Data modeling method and device, electronic equipment and storage medium

A data modeling and data modeling technology, applied in database design/maintenance, database update, structured data retrieval, etc., can solve problems such as difficulty in completing it alone or in a short time, low efficiency, etc.

Pending Publication Date: 2022-07-22
广州市易工品科技有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] First of all, this method is inefficient, and requires many SQL editors to correspond to different needs of users;
[0006] Secondly, for new fields, professional SQL statement query is required, which is difficult for general users to complete alone or in a short time

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 modeling method and device, electronic equipment and storage medium
  • Data modeling method and device, electronic equipment and storage medium
  • Data modeling method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0047] see figure 1 , figure 1 It is a schematic flowchart of a data modeling method disclosed in an embodiment of the present invention. like figure 1 As shown, the data modeling method includes the following steps:

[0048] S110. Use Vue to monitor the user's SQL content editing operation of the vue2-ace-editor framework in the data model.

[0049]Before monitoring, you first need to create an SQL editor model, which is placed in the vue2-ace-editor framework. Preferably, the SQL editor model corresponds to as many command types as possible, so as to facilitate beginners or no-ones Any basic user can operate, execute the content of the SQL editor model, and get a data model. E.g figure 2 A SQL editor model is shown in .

[0050] The following monitoring actions are all monitoring for the user to edit the SQL content in the SQL editor model. It can be understood that multiple SQL editor models can also be created according to different types of needs of users. Users c...

Embodiment 2

[0072] see image 3 , image 3 It is a schematic structural diagram of a data modeling apparatus disclosed in an embodiment of the present invention. like image 3 As shown, the data modeling apparatus includes:

[0073] The monitoring unit 210 is used to use Vue to monitor the SQL content editing operation of the vue2-ace-editor framework by the user in the data model;

[0074] The updating unit 220 is configured to receive the corresponding model field information or / and model data information generated in real time by Vue according to the SQL content editing operation, and use the model field information or / and the model data information to update the content of the data model. Render to form an updated data model.

[0075] Preferably, the monitoring unit 210 may include:

[0076] The first receiving subunit is used to receive execution instructions, and use Vue to execute the execution instructions when editing the SQL content of the vue2-ace-editor framework;

[007...

Embodiment 3

[0093] see Figure 4 , Figure 4 It is a schematic structural diagram of an electronic device disclosed in an embodiment of the present invention. like Figure 4 As shown, the electronic device may include:

[0094] a memory 310 storing executable program code;

[0095] a processor 320 coupled to the memory 310;

[0096] The processor 320 invokes the executable program code stored in the memory 310 to execute some or all of the steps in the data modeling method in the first embodiment.

[0097] An embodiment of the present invention discloses a computer-readable storage medium, which stores a computer program, wherein the computer program causes a computer to execute some or all of the steps in the data modeling method in the first embodiment.

[0098] The embodiment of the present invention also discloses a computer program product, wherein when the computer program product runs on the computer, the computer is caused to execute some or all of the steps in the data modelin...

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 embodiment of the invention relates to the technical field of information acquisition, and discloses a data modeling method and device, electronic equipment and a storage medium. The method comprises the following steps: monitoring an SQL (Structured Query Language) content editing operation of a user on a vue2-ace-editor framework in a data model by using Vue; and receiving corresponding model field information or / and model data information generated by Vue in real time according to the SQL content editing operation, and rendering the content of the data model by using the model field information or / and the model data information to form an updated data model. By implementing the embodiment of the invention, the process of converting the conventional SQL query from the background to the front-end processing can be completed, and the problem that professional SQL statement query is needed when a field is newly added is solved.

Description

technical field [0001] The present invention relates to the technical field of information acquisition, in particular to a data modeling method, device, electronic device and storage medium. Background technique [0002] Existing information acquisition methods, exemplarily, acquire the required part of the information from the database, and form a table to present the part of the information. It needs to be done through an SQL statement. [0003] SQL is short for Structured Query Language. SQL statement is a database query and programming language used to access data and query, update and manage relational database systems. For each information acquisition process, the existing method generally requires a new SQL editor to be created, and corresponding SQL statements are written according to user requirements. [0004] This approach has the following flaws: [0005] First of all, this method is inefficient, and a lot of SQL editors are needed to correspond to different ...

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/21G06F16/23G06F16/242G06F40/186
CPCG06F16/212G06F16/2433G06F16/23G06F40/186
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