CN105760510A - Database horizontal extension method of software business system - Google Patents
Database horizontal extension method of software business system Download PDFInfo
- Publication number
- CN105760510A CN105760510A CN201610100449.4A CN201610100449A CN105760510A CN 105760510 A CN105760510 A CN 105760510A CN 201610100449 A CN201610100449 A CN 201610100449A CN 105760510 A CN105760510 A CN 105760510A
- Authority
- CN
- China
- Prior art keywords
- data base
- extending transversely
- database
- data
- extension
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 27
- 230000008520 organization Effects 0.000 claims description 14
- 230000006870 function Effects 0.000 claims description 9
- 230000008569 process Effects 0.000 claims description 5
- 230000008859 change Effects 0.000 claims description 3
- 238000005194 fractionation Methods 0.000 claims description 3
- 230000007423 decrease Effects 0.000 description 2
- CVOFKRWYWCSDMA-UHFFFAOYSA-N 2-chloro-n-(2,6-diethylphenyl)-n-(methoxymethyl)acetamide;2,6-dinitro-n,n-dipropyl-4-(trifluoromethyl)aniline Chemical compound CCC1=CC=CC(CC)=C1N(COC)C(=O)CCl.CCCN(CCC)C1=C([N+]([O-])=O)C=C(C(F)(F)F)C=C1[N+]([O-])=O CVOFKRWYWCSDMA-UHFFFAOYSA-N 0.000 description 1
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 238000010079 rubber tapping Methods 0.000 description 1
- 230000009897 systematic effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a database transverse expansion method of a software service system, which comprises the following steps: 1) identifying extension dimensions to form extension configuration; 2) accessing the data routes as configured; 3) the database transverse deployment node can be flexibly expanded, and when the current expansion setting does not meet the performance requirement, a new database is dynamically expanded. Compared with the prior art, the method for transversely expanding the database of the software service system enables the system to have a database transversely-expandable design framework and a system supporting technology; by the transverse expansion of the database, the problems of the bottle diameter and the operation efficiency of the system caused by the high-load operation of the database are solved, the pressure of high-concurrency and large data on the system is easily responded, and the system has extremely strong transverse expansion capability.
Description
Technical field
The present invention relates to operation system access performance field, specifically a kind of data base's method extending transversely of software operation system.
Background technology
Business datum trading volume and single table data volume are excessive, can cause systemic-function low-response, and time-out occurs in big data quantity inquiry.At present, most of information systems are in high concurrent, the performance bottle diameter of the system of solution and operational efficiency, it is only by load-balancing technique at application, is tackled by the extension of application server, and the high load capacity and pressure for data base itself lacks effective solution.In data base's aspect, data base manufacturer can provide the scheme that some technical sophistication degree are higher, such as OracleRac, is the new technology that after Oracle9i, version proposes, also it is the core technology of oracle database support grid computing environment, it is achieved that data base's is extending transversely.But there is certain limitation, throughput of system can only be promoted to a certain extent, the performance pressures that high concurrent, big data quantity brings can not be fully solved.
Disclosed Patents file: name is called " a kind of distributed data base method extending transversely ", this document discloses that " a kind of distributed data base method extending transversely, the method includes: create database hub node；Create database data node；Disposing middle layer node, this middle layer node presses probability selection back end according to load weight；On described database data node, redundancy creates tables of data；Described middle layer node creates remote table；Carry out data query by middle layer node, and data query result is sent to client.The present invention by distributed data base method extending transversely effectively prevent visit capacity excessive time data base querying standalone processes ability decline, by effectively tapping inquiry, improve the query performance of data base ".
Name is called " a kind of method of dynamic expansion data-base cluster ", this document disclose " a kind of method of dynamic expansion data-base cluster; be applicable to that there is the data-base cluster of dynamic extending and include in resource: internal memory, CPU, disk etc. are fast close to full load; the increase server node of automatic touch trigger arrives cluster, it is achieved the real-time extension of prosthetic operation intervention.This system provides the automatic in real time extension approach of a kind of data-base cluster so that the data-base cluster with dynamic ability extending transversely increases resource automatically, it is achieved real-time extension；Solve the hydraulic performance decline that brings when scarcity of resources, function is made mistakes and system crash etc. affect the abnormal problem of regular traffic, the availability of raising system and stability ".
File disclosed above and present invention to solve the technical problem that, the technological means of employing is different from.
Summary of the invention
The technical assignment of the present invention is to provide a kind of data base's method extending transversely of software operation system.
The technical assignment of the present invention realizes in the following manner, and this data base method step extending transversely is as follows:
1) identify extension dimension, form expanded configuration: according to the factor of the horizontal degree of association of business function module, the data volume size of single table, the dimension that identification database is extending transversely；Data base's allocation list extending transversely is formed by the dimension of business module, work organization；
2) by configuration to data route access: service operation unified frame encapsulates the business function access to data, result according to data base's configuration extending transversely, realize routing scheduling and the information sharing of disparate databases server, when service switchover module, work organization, the target database of handover access simultaneously；
3) data base laterally dispose node can flexible expansion, when current extension setting is unsatisfactory for performance requirement, the data base that dynamic expansion is new: when calculating, I/O performance pressures occurs in a database server, increase by second database server, second when also there is pressure, increase the 3rd, until performance meets needs.
Described data base allocation list extending transversely is for the entity structure of descriptive data base result extending transversely, and data row include business module numbering row, work organization type column, work organization identity column, reserved extension columns one, reserved extension columns two and Service Database example number row.
The buffered results of described data base configuration extending transversely is buffered results, and this buffered results ensure that in substantial amounts of database access process, dynamically judge, arrange access database server time do not have performance bottleneck.
The data base that described dynamic expansion is new adopts two ways: expands new extension and merges original extension；Above two extension all along with the change of physical database server, can relate to the merging of physical data, fractionation simultaneously；The buffer memory of data base's switching route extending transversely is also required to lose efficacy, reload.
Compared to the prior art, the method makes system possess data base can design architecture extending transversely and system support technology for data base's method extending transversely of a kind of software operation system of the present invention；Extending transversely by data base, solves factor data bank high loaded process and the systematic function bottle diameter brought and operational efficiency problem, the pressure that system is brought by the high data concurrent, big of calm reply, and makes system have extremely strong ability extending transversely.
Detailed description of the invention
Embodiment 1:
This data base method step extending transversely is as follows:
1) identify extension dimension, form expanded configuration: according to the factor of the horizontal degree of association of business function module, the data volume size of single table, the dimension that identification database is extending transversely；Data base's allocation list extending transversely is formed by the dimension of business module, work organization；
Above-mentioned data base allocation list extending transversely is for the entity structure of descriptive data base result extending transversely, and data row include business module numbering row, work organization type column, work organization identity column, reserved extension columns one, reserved extension columns two and Service Database example number row.
2) by configuration to data route access: service operation unified frame encapsulates the business function access to data, result according to data base's configuration extending transversely, realize routing scheduling and the information sharing of disparate databases server, when service switchover module, work organization, the target database of handover access simultaneously；
The buffered results of above-mentioned data base configuration extending transversely is buffered results, and this buffered results ensure that in substantial amounts of database access process, dynamically judge, arrange access database server time do not have performance bottleneck.
3) data base laterally dispose node can flexible expansion, when current extension setting is unsatisfactory for performance requirement, the data base that dynamic expansion is new: when calculating, I/O performance pressures occurs in a database server, increase by second database server, second when also there is pressure, increase the 3rd, until performance meets needs.
The data base that above-mentioned dynamic expansion is new adopts two ways: expands new extension and merges original extension；Above two extension all along with the change of physical database server, can relate to the merging of physical data, fractionation simultaneously；The buffer memory of data base's switching route extending transversely is also required to lose efficacy, reload.
Embodiment 2:
Below by the detailed description of the realization extending transversely by the data base in a certain ERP operation system:
One, the extending transversely of data base sets entity
///<summary>
The setting extending transversely of ///data base
///</summary>
publicclassGSPDBExtSetting
{
// module is numbered
publicstringModule{get;set;}
// organization type
publicstringOrgType{get;set;}
// organization identification
publicstringOrgID{get;set;}
// extension dimension 1
publicstringExtDim1{get;set;}
// extension dimension 2
publicstringExtDim2{get;set;}
// data base connects numbering
publicstringDBCode{get;set;}
// last modification time is set, for cache synchronization
publicDateTimeLastModifyTime{get;set;}
}
Two, according to data base's setting extending transversely, dynamic routing data storehouse
1) user logs in ERP management information system by system login interface.Application server adopts trunking mode to dispose, and multiple application servers have unified logentry.
2) user identity verifies by rear, and ERP management information system opens system main frame.
3) the crucial session information of ERP management information system initialising subscriber, and be illustrated on main frame after obtaining the data such as the essential information of this user, the function menu having permission, message informing from operation system integrated data store.
4) user enters specific functional modules and carries out business operation, and ERP management information system, according to current functional module and routing configuration table, automatically switches to specified database, and in current interface the menu etc. of switching display user's corresponding authority.
5) user opens certain concrete business paper, such as in fixed assets module, increases the operation of assets card, when stored, is directly saved in the data base having switched to.
6), when being switched to other functional modules or tissue as user, ERP management information system can divide storehouse dimension values according to current data, dynamically carries out the switching of data base.
7) when different users logs in ERP management information system simultaneously, the session information of each user preserves the data point storehouse dimension values of oneself, and therefore matching the database instance each connected, they can non-interfering be connected in different data bases.
By detailed description of the invention above, described those skilled in the art can be easy to realize the present invention.It is understood that the present invention is not limited to above-mentioned several detailed description of the invention.On the basis of disclosed embodiment, described those skilled in the art can the different technical characteristic of combination in any, thus realizing different technical schemes.
Claims (4)
1. the data base of software operation system method extending transversely, it is characterised in that this data base method step extending transversely is as follows:
1) identify extension dimension, form expanded configuration: according to the factor of the horizontal degree of association of business function module, the data volume size of single table, the dimension that identification database is extending transversely；Data base's allocation list extending transversely is formed by the dimension of business module, work organization；
2) by configuration to data route access: service operation unified frame encapsulates the business function access to data, result according to data base's configuration extending transversely, realize routing scheduling and the information sharing of disparate databases server, when service switchover module, work organization, the target database of handover access simultaneously；
3) data base laterally dispose node can flexible expansion, when current extension setting is unsatisfactory for performance requirement, the data base that dynamic expansion is new: when calculating, I/O performance pressures occurs in a database server, increase by second database server, second when also there is pressure, increase the 3rd, until performance meets needs.
2. data base's method extending transversely of a kind of software operation system according to claim 1, it is characterized in that, described data base allocation list extending transversely is for the entity structure of descriptive data base result extending transversely, and data row include business module numbering row, work organization type column, work organization identity column, reserved extension columns one, reserved extension columns two and Service Database example number row.
3. data base's method extending transversely of a kind of software operation system according to claim 1, it is characterized in that, the buffered results of described data base configuration extending transversely is buffered results, this buffered results ensure that in substantial amounts of database access process, dynamically judge, arrange access database server time do not have performance bottleneck.
4. data base's method extending transversely of a kind of software operation system according to claim 1, it is characterised in that the data base that described dynamic expansion is new adopts two ways: expands new extension and merges original extension；Above two extension all along with the change of physical database server, can relate to the merging of physical data, fractionation simultaneously；The buffer memory of data base's switching route extending transversely is also required to lose efficacy, reload.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610100449.4A CN105760510A (en) | 2016-02-24 | 2016-02-24 | Database horizontal extension method of software business system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610100449.4A CN105760510A (en) | 2016-02-24 | 2016-02-24 | Database horizontal extension method of software business system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105760510A true CN105760510A (en) | 2016-07-13 |
Family
ID=56330253
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610100449.4A Pending CN105760510A (en) | 2016-02-24 | 2016-02-24 | Database horizontal extension method of software business system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105760510A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106446268A (en) * | 2016-10-19 | 2017-02-22 | 中国工商银行股份有限公司 | Database lateral extension system and method |
| CN106603617A (en) * | 2016-08-31 | 2017-04-26 | 重庆车杰盟科技有限公司 | Method for distributed data access |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101464892A (en) * | 2008-12-31 | 2009-06-24 | 中兴通讯股份有限公司 | Login method and device for dynamic database |
| US20100125618A1 (en) * | 2008-11-17 | 2010-05-20 | Hewlett-Packard Development Company, L.P. | Integrated soa deployment and management system and method for software services |
| CN102930062A (en) * | 2012-11-30 | 2013-02-13 | 南京富士通南大软件技术有限公司 | Rapid horizontal extending method for databases |
| CN103970907A (en) * | 2014-05-28 | 2014-08-06 | 浪潮电子信息产业股份有限公司 | Method for dynamically expanding database cluster |
| CN104462435A (en) * | 2014-12-15 | 2015-03-25 | 同方知网数字出版技术股份有限公司 | Lateral extension method of distributed database |
| CN105138638A (en) * | 2015-08-24 | 2015-12-09 | 浪潮通用软件有限公司 | Database distribution method based on application layer |
-
2016
- 2016-02-24 CN CN201610100449.4A patent/CN105760510A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100125618A1 (en) * | 2008-11-17 | 2010-05-20 | Hewlett-Packard Development Company, L.P. | Integrated soa deployment and management system and method for software services |
| CN101464892A (en) * | 2008-12-31 | 2009-06-24 | 中兴通讯股份有限公司 | Login method and device for dynamic database |
| CN102930062A (en) * | 2012-11-30 | 2013-02-13 | 南京富士通南大软件技术有限公司 | Rapid horizontal extending method for databases |
| CN103970907A (en) * | 2014-05-28 | 2014-08-06 | 浪潮电子信息产业股份有限公司 | Method for dynamically expanding database cluster |
| CN104462435A (en) * | 2014-12-15 | 2015-03-25 | 同方知网数字出版技术股份有限公司 | Lateral extension method of distributed database |
| CN105138638A (en) * | 2015-08-24 | 2015-12-09 | 浪潮通用软件有限公司 | Database distribution method based on application layer |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106603617A (en) * | 2016-08-31 | 2017-04-26 | 重庆车杰盟科技有限公司 | Method for distributed data access |
| CN106446268A (en) * | 2016-10-19 | 2017-02-22 | 中国工商银行股份有限公司 | Database lateral extension system and method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10521396B2 (en) | Placement policy | |
| CN102591970B (en) | Distributed key-value query method and query engine system | |
| CN103905537A (en) | System for managing industry real-time data storage in distributed environment | |
| US8112659B2 (en) | Reducing recovery time for business organizations in case of disasters | |
| US8543621B2 (en) | Database partitioning by virtual partitions | |
| CN102541990B (en) | Database redistribution method and system utilizing virtual partitions | |
| CN103067433B (en) | A kind of data migration method of distributed memory system, equipment and system | |
| JP2023532947A (en) | Data transfer method, proxy server, storage medium and electronic device | |
| CN104050250A (en) | Distributed key-value query method and query engine system | |
| US20160364407A1 (en) | Method and Device for Responding to Request, and Distributed File System | |
| US20140108358A1 (en) | System and method for supporting transient partition consistency in a distributed data grid | |
| CN105933376A (en) | Data manipulation method, server and storage system | |
| CN107665246B (en) | Dynamic data migration method based on graph database and graph database cluster | |
| CN104050015A (en) | Mirror image storage and distribution system for virtual machines | |
| CN105516284B (en) | A kind of method and apparatus of Cluster Database distributed storage | |
| CN102194009A (en) | Database hosting method and database hosting platform system | |
| CN103198153A (en) | Metadata clustering management method and module applied to distributed file system | |
| CN110727738B (en) | Global routing system based on data fragmentation, electronic equipment and storage medium | |
| TW201248418A (en) | Distributed caching and cache analysis | |
| CN105045929A (en) | MPP architecture based distributed relational database | |
| CN104410531B (en) | The system architecture method of redundancy | |
| CN104184812A (en) | Multi-point data transmission method based on private cloud | |
| CN104254839A (en) | Systems and methods for partitioning of singly linked lists for allocation memory elements | |
| CN105069152A (en) | Data processing method and apparatus | |
| CN104410666A (en) | Method and system for implementing heterogeneous storage resource management under cloud computing |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160713 |