Client ID-based library division method and device

A client and sub-database technology, applied in database distribution/replication, special data processing applications, structured data retrieval, etc., can solve problems such as inconsistency of transactions within services, and achieve the convenience of daily operation and maintenance of maintenance personnel, and intuitive and convenient database segmentation. Solution, the effect of simplifying the difficulty of service development

Pending Publication Date: 2020-09-04
北京思特奇信息技术股份有限公司
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When using the Ali DRDS database, when the database is divided based on the order code or user ID, it will cause a problem of inconsistency in transactions within the service.

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
  • Client ID-based library division method and device
  • Client ID-based library division method and device
  • Client ID-based library division method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035] The principles and features of the present invention will be described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.

[0036] like figure 1 As shown, it is a method of sub-database based on customer ID provided by the embodiment of the present invention. The method includes: S1, adding a segmentation field to the customer ID in the original accepted instance table model;

[0037] S2, when the database accepts the order of the customer ID again, the database executes the table creation script according to the segmentation field, and divides the order information into the database corresponding to the customer ID.

[0038] It should be noted that writing the table creation script of the sub-database means that the table creation script is written and divided according to the customer ID, and deployed to the distributed relational ...

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 client ID-based library division method and device, and relates to the field of telecommunication operation. The method comprises the following steps that a segmentation field is added into a client ID in an originally accepted instance table model; when the database accepts the order of the client ID again, the database executes the table building script according to thesegmentation field, the order information is divided into the database corresponding to the client ID, and a more visual and convenient database segmentation scheme is provided, so that the service development difficulty after database migration is reduced, and daily operation and maintenance of maintenance personnel are facilitated.

Description

technical field [0001] The invention relates to the field of telecommunication operation, in particular to a method and device for sub-database based on customer ID. Background technique [0002] Most of the sales centers of existing telecom operators are still based on the oracle database, and most of the distributed databases use order codes or user identification sub-databases. When using the Ali DRDS database, when the database is divided based on the order code or user ID, it will cause a problem of inconsistency in transactions within the service. Contents of the invention [0003] The technical problem to be solved by the present invention is to provide a method and device for sub-database based on customer ID in view of the deficiencies in the prior art. [0004] The technical scheme that the present invention solves the problems of the technologies described above is as follows: [0005] A method of sub-library based on customer ID, including: [0006] S1, add ...

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/27
CPCG06F16/278
Inventor 张振中
Owner 北京思特奇信息技术股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap