Supercharge Your Innovation With Domain-Expert AI Agents!

Data table reconstruction method of database mode, device and system

A data table and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., to achieve the effect of reducing cross-database connection operations

Active Publication Date: 2018-09-14
SUN YAT SEN UNIV
View PDF4 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in this database mode, there are some obvious deficiencies. All tenant data are put into one data table. In this way, the user's operation speed will be a very serious problem. Therefore, we need to take some measures Reconstructing the data tables in this way can not only ensure the user's operation speed, but also avoid a large increase in database maintenance costs

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 table reconstruction method of database mode, device and system
  • Data table reconstruction method of database mode, device and system
  • Data table reconstruction method of database mode, device and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0040] 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 part of the embodiments of the present invention, not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0041] It should be noted that if there is a directional indication (such as up, down, left, right, front, back...) in the embodiment of the present invention, the directional indication is only used to explain the position in a certain posture (as shown in the accompanying drawing). If the specific posture changes, the directional indication will also change accordingly.

[0042]In addition, if there are descriptions involving "first", "second" and s...

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 discloses a data table reconstruction method of a database mode, a device and a system. The method comprises the following steps: inputting data into a data table mt_data of a UniversalTable Layout database mode by a tenant; recording and matching one tenant ID (Identity) and a table ID in each row of data, wherein the tenant ID is used for marking a tenant identity, and the table ID is used for marking the name of a data table of a current tenant; dividing the data table t_data into a data table of each tenet in one to one correspondence to tenant ID values; dividing the data table of each tenant according to the table ID, wherein foreign key constraint is set up between sub-tables in the middle of the divided data tables; according to the existing foreign key constraint, generating digraph diagrams among data tables; rejecting included routs from all routes of the digraph diagrams so as to obtain digraph diagrams with pure routs; dividing data on each pure route in thedigraph diagrams into one data table, and reconstructing a database. By adopting the method, database-span connection operation can be avoided to the maximum extent.

Description

technical field [0001] The invention relates to the field of power grid dispatching communication, in particular to a data table reconstruction method, device and system of a database mode. Background technique [0002] SaaS is the abbreviation of Software-as-a-Service. With the development of Internet technology and the maturity of application software, a completely innovative software application model emerged in the early 21st century. It is a mode of providing services through the Internet. Manufacturers uniformly deploy application software on their own servers. Customers can order the required application software services from manufacturers through the Internet according to their actual needs, according to the number of services ordered and the length of time. Pay the manufacturer. Users do not need to purchase complete software, but instead rent web-based software from the provider to manage business activities, and there is no need to maintain the software. The ser...

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): G06F17/30
Inventor 周晓聪尹林枫
Owner SUN YAT SEN UNIV
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com