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

Method and device for dividing databases and tables according to time

A time-splitting and table-splitting technology, applied in the database field, can solve problems such as not considering the generation mechanism of databases and tables, difficulty in improving efficiency, and inability to reduce configuration complexity. It achieves convenient storage and management mechanisms, wastes storage space, and reduces The effect of configuration complexity

Pending Publication Date: 2022-05-06
航天信息软件技术有限公司
View PDF1 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This patent mainly focuses on the nodes using sub-database and sub-table, without considering the generation mechanism of sub-database and sub-table, which cannot reduce the complexity of configuration and is difficult to improve efficiency

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
  • Method and device for dividing databases and tables according to time
  • Method and device for dividing databases and tables according to time
  • Method and device for dividing databases and tables according to time

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] Embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings.

[0025] It should be noted that, in the case of no conflict, the following embodiments and the features in the embodiments can be combined with each other; and, based on the embodiments in the present disclosure, those of ordinary skill in the art obtained without creative work All other embodiments belong to the protection scope of the present disclosure.

[0026] It is noted that the following describes various aspects of the embodiments that are within the scope of the appended claims. It should be apparent that the aspects described herein may be embodied in a wide variety of forms and that any specific structure and / or function described herein is illustrative only. Based on the present disclosure one skilled in the art should appreciate that an aspect described herein may be implemented independently of any other aspects and that two or more of t...

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 method and a device for dividing a database and a table according to time. The method comprises the following steps: acquiring request information for operating a database; the request information is used for carrying out at least one of an addition operation, a search operation, a deletion operation or a rewriting operation on a database; when the request information is used for representing increase operation, judging whether a corresponding table structure is established or not; when it is determined that no corresponding table structure exists, the corresponding table structure is newly built, and adding operation is executed in the newly built corresponding table structure; and when it is determined that the corresponding table structure has been established, executing an addition operation in the established corresponding table structure. According to the method, only when the request information is used for representing the increase operation, the corresponding table structure is dynamically generated, so that the storage and management mechanism is greatly facilitated, the cost is saved, the configuration complexity is reduced, and the efficiency is improved.

Description

technical field [0001] The present invention relates to the technical field of databases, in particular to a method and device for sorting databases and tables according to time. Background technique [0002] In the past, it was enough to use only a stand-alone database. Then, in the face of more and more requests, the write operation and read operation of the database were separated, and multiple copies of the slave library (Slaver Replication) were used for reading, and the master library (Master) was used for reading. Write, the slave library updates data synchronously from the master library to keep the data consistent. The architecture is database master-slave synchronization. Slaves can scale horizontally, so more read requests are not a problem. But when the user level increases, there are more and more write requests. Adding a master cannot solve the problem, because the data must be consistent, and the write operation needs to be synchronized between the two mast...

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/22G06F16/2458
CPCG06F16/2282G06F16/2474
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