Database horizontal extension method of software service system

An expansion method and software business technology, applied in the field of database horizontal expansion of software business systems, can solve problems such as performance pressure that cannot be completely solved, and achieve the effect of solving system performance bottlenecks and operating efficiency problems, and strong horizontal expansion capabilities

Inactive Publication Date: 2016-07-13
INSPUR COMMON SOFTWARE
View PDF6 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, it has certain limitations. It can only improve the system throughput to a certain extent, and cannot completely solve the performance pressure brought by high concurrency and large data volume.

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0016] The steps of the database horizontal expansion method are as follows:

[0017] 1) Identify the expansion dimension and form the expansion configuration: identify the dimension of the database horizontal expansion according to the horizontal correlation degree of the business function module and the data volume of a single table; form the database horizontal expansion configuration table according to the dimensions of the business module and business organization;

[0018] The above database scale-out configuration table is used to describe the entity structure of the database scale-out results. The data columns include the business module number column, business organization type column, business organization identifier column, reserved extension column 1, reserved extension column 2, and business database Instance number column.

[0019] 2) Routing access to data according to configuration: the business operation framework uniformly encapsulates the access to data from...

Embodiment 2

[0024] The following will be a detailed description of the realization of the horizontal expansion of the database in an ERP business system:

[0025] First, the horizontal expansion of the database entity

[0026] / / /

[0027] / / / Database scale-out settings

[0028] / / /

[0029] publicclassGSPDBExtSetting

[0030] {

[0031] / / module number

[0032] publicstringModule{get;set;}

[0033] / / organization type

[0034] publicstringOrgType{get;set;}

[0035] / / Organization ID

[0036] publicstringOrgID{get;set;}

[0037] / / extend dimension 1

[0038] publicstringExtDim1{get;set;}

[0039] / / extend dimension 2

[0040] publicstringExtDim2{get;set;}

[0041] / / Database connection number

[0042] publicstringDBCode{get;set;}

[0043] / / Set the last modification time, for cache synchronization

[0044] publicDateTimeLastModifyTime{get;set;}

[0045]}

[0046] 2. According to the database horizontal expansion setting, dynamically route the database

[0047] 1) Th...

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 database horizontal extension method of a software service system.The database horizontal extension method includes the following steps that firstly, the extension dimensionality is recognized, and extension configuration is formed; secondly, access is performed on data routes according to configuration; thirdly, horizontal deployment nodes of a database can be flexibly extended, and when current extension setting cannot meet performance requirements, and a new database is dynamically extended.Compared with the prior art, the database horizontal extension method of the software service system makes the system have a horizontal extension design architecture of the database and a system supporting technology; by means of horizontal extension on the database, the system performance bottleneck and running efficiency problem caused by high-load running of the database is solved, the system can respond to pressure on the system caused by high-concurrence and large data at leisure, and the system has extremely high horizontal extension capacity.

Description

technical field [0001] The invention relates to the field of business system access performance, in particular to a database horizontal expansion method of a software business system. Background technique [0002] Excessive business data transaction volume and single-table data volume will lead to slow response of system functions and timeout of large data volume queries. At present, most information systems only use load balancing technology at the application level to deal with high system concurrency, performance bottlenecks, and operating efficiency by expanding application servers, but the high load and pressure on the database itself is Effective solutions are lacking. At the database level, database vendors will provide some solutions with high technical complexity, such as OracleRac, which is a new technology proposed by Oracle9i and later versions, and is also the core technology for Oracle database to support the grid computing environment, realizing the horizonta...

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): G06F17/30
CPCG06F16/25
Inventor 周祥国孙立新戴海宏
Owner INSPUR COMMON SOFTWARE
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