CN101894348B - Self-expanded online transaction system and implementing method thereof - Google Patents

Self-expanded online transaction system and implementing method thereof Download PDF

Info

Publication number
CN101894348B
CN101894348B CN201010234191.XA CN201010234191A CN101894348B CN 101894348 B CN101894348 B CN 101894348B CN 201010234191 A CN201010234191 A CN 201010234191A CN 101894348 B CN101894348 B CN 101894348B
Authority
CN
China
Prior art keywords
data
sublist
tables
transaction
service manager
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.)
Active
Application number
CN201010234191.XA
Other languages
Chinese (zh)
Other versions
CN101894348A (en
Inventor
杨明玮
谌鹏飞
马俊辉
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Haining hi tech Zone Science and Innovation Center Co., Ltd
Original Assignee
ZTE Corp
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by ZTE Corp filed Critical ZTE Corp
Priority to CN201010234191.XA priority Critical patent/CN101894348B/en
Publication of CN101894348A publication Critical patent/CN101894348A/en
Priority to PCT/CN2010/080316 priority patent/WO2012009934A1/en
Application granted granted Critical
Publication of CN101894348B publication Critical patent/CN101894348B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/30Monitoring
    • G06F11/34Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
    • G06F11/3409Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment
    • G06F11/3428Benchmarking
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/06Asset management; Financial planning or analysis

Abstract

The invention discloses a self-expanded online transaction system and an implementing method thereof. The system comprises a service processor, a running monitor, a service manager and a data structure generator, wherein the service processor is used for invoking a specified database running program according to an invoke rule informed by a service manager and operating a subtable of a data table; the running monitor is used for monitoring the running condition of the system, acquiring running information in the running process of the system and sending the running information to the service manager; the service manager is used for judging whether transaction traffic exceeds a preset threshold according to the received running information which is sent by the running monitor, if so, the data structure generator is invoked and generates a new invoke rule to inform the service processor; and the data structure generator is used for establishing the subtable of the data table in a database after being invoked, and generating the database running program of the subtable. The system establishes the subtable of the data table automatically according to the online transaction traffic, can dynamically adapt to the increase of the traffic without shutdown maintenance, and improves operation efficiency.

Description

A kind of online transaction system and its implementation from expansion
Technical field
The present invention relates to value-added telecom services field, more particularly, relate to a kind of online transaction system and its implementation from expansion.
Background technology
Along with the development of computing machine and mechanics of communication, the use of ecommerce is day by day universal, and on-line transaction is as the Core Feature of ecommerce, and the requirement of real-time and concurrency is very high.For large-scale on-line transaction, the session obstruction and the processing time delay that in order to reduce concurrent operations, cause, generally can carry out Data Segmentation, according to service feature, tables of data split into a plurality of sublists, to improve the readwrite performance of database integral body.
At present; in existing online transaction system; traditional Data Segmentation must just be determined the quantity of sublist in the planning and design stage; if need again to do Data Segmentation in system operational process; operation that must the Break-Up System new planning of laying equal stress on; this just causes the extendability of system very poor; cannot adapt to the growth of portfolio; increased the stop time of maintainability; improved the cost of operation; reduced the availability rank of system, inside the plan or hang-up all can cause damage in business.
In sum; in prior art, there is following technical matters: do not have at present a kind of system or method can solve well the scalability problem of online transaction system; along with the growth of portfolio, increased the stop time that brings maintainability and a series of problem such as availability reduction.
Summary of the invention
The technical matters that the present invention solves is to provide a kind of online transaction system and its implementation from expansion, can solve well the scalability problem of online transaction system.
For solving the problems of the technologies described above, the invention provides a kind of online transaction system from expansion, described system comprises:
Operational processor, for calling the database manipulation program of appointment according to the calling rule of Service Manager notice, operates the sublist of tables of data;
Running monitor for the ruuning situation of supervisory system, is collected operation information and sends to Service Manager in system operational process;
Service Manager, the operation information for sending according to the running monitor that receives, judges whether transaction business amount exceeds predetermined threshold, if so, calling data structure generator, and generate new calling rule and notify to operational processor;
Data structure generator after called, create the sublist of tables of data, and generates the database manipulation program of described sublist in database.
Wherein, described data structure generator further comprises tables of data template and Code Template, wherein:
Tables of data template, for providing the general statement of the sublist of setting up tables of data;
Code Template, for providing the general statement of building database running program;
Described data structure generator is used for, and generates the data definition statement that creates described sublist, and generate described database manipulation program according to described Code Template according to described tables of data template.
Wherein, described tables of data comprises user account tables of data and transaction log table, and described database manipulation program comprises storing process;
Described Service Manager is further used for, and by sending structural adjustment request message, calls described data structure generator, the quantity of the sublist of specify creation user account tables of data and transaction log table in described structural adjustment request message; And, according to the structural adjustment response message of described data structure generator, generate described new calling rule, wherein, described calling rule is, by the interval under user ID value and user ID, the mould of transaction log sublist quantity is determined to invoked storing process title jointly;
Described data structure generator is further used for, and according to described structural adjustment request message, creates the user account tables of data of specified quantity and the sublist of transaction log table; According to the syntagmatic of the sublist of described user account tables of data and transaction log table, generate storing process, and repartition the interval of user ID value, to described Service Manager, return and represent whether successfully structural adjustment response message of structural adjustment operation, and the quantity of the interval of described user ID value and described transaction log table is included in described structural adjustment response message and sends to described Service Manager.
Wherein, described database template and described Code Template also for, the transaction log table name indicating in described general statement by special tag claims and user account tables of data title;
Described data structure generator also for, the mode of using determined value to replace label generates the data definition statement that creates described sublist, and described storing process.
Wherein, described Service Manager is further used for, and judges transaction business amount exceed after predetermined threshold according to described operation information, judges whether transaction business amount exceeds power system capacity scope, if exceed power system capacity scope, transmitted traffic control message is to operational processor;
Described operational processor is further used for, and while receiving described flow control messages, according to predefined flow control parameter, Partial Online transaction request is returned to replying of refusal processing.
The present invention also provides a kind of implementation method of the online transaction system from expansion, and described method comprises:
The ruuning situation of supervisory system, according to the operation information of collecting in system operational process, judge whether transaction business amount exceeds predetermined threshold, if so, in database, create the sublist of tables of data, generate the database manipulation program of described sublist, and generate new calling rule;
According to described new calling rule, call the database manipulation program of appointment, the described sublist creating is operated.
Further, described tables of data comprises user account tables of data and transaction log table, and described database manipulation program comprises storing process;
Create after the sublist of user account tables of data and transaction log table, according to the syntagmatic of the sublist of described user account tables of data and transaction log table, generate storing process, and repartition the interval of user ID value, generate new calling rule.
Further, described calling rule is by according to the interval under user ID value and user ID, the mould of transaction log sublist quantity being determined to invoked storing process title jointly.
Further, according to the transaction business amount in described operation information, determine the quantity of the sublist that creates user account tables of data and transaction log table.
Further, described method also comprises:
According to described operation information, judging transaction business amount exceeds after predetermined threshold, judge again whether transaction business amount exceeds power system capacity scope, if exceed power system capacity scope, according to predefined flow control parameter, Partial Online transaction request is returned to replying of refusal processing.
Compared with prior art, the present invention at least has following features: the automatic expansion of submeter encapsulates by the operation of underlying database, to service layer, be transparent, the foundation of sublist is without the modification of upper-layer service logic, and this has just farthest reduced the complicacy of system maintenance; Secondly, sublist is to set up according to the portfolio of on-line transaction is automatic, dynamically adapts to the growth of portfolio, without shutting down, safeguards, this has just greatly improved the efficiency of runing, and has reduced the cost of operation; In addition,, in the situation that not revising the original processing logic of operational processor, just can operate the sublist of the core data table of new expansion, dynamically to adapt to increasing of portfolio; Finally, the storing process code of the transaction processing relevant to sublist is automatically to produce, and without manual, safeguards storing process, and this has just reduced the possibility of makeing mistakes, and has farthest improved the availability of system.
Accompanying drawing explanation
Fig. 1 is the composition structural representation of the online transaction system of expansion certainly of the embodiment of the present invention;
Fig. 2 is the schematic flow sheet of the implementation method of the online transaction system of expansion certainly of the embodiment of the present invention.
Embodiment
The object of the invention is to, a kind of online transaction system from expansion is provided, this system mainly comprises:
Operational processor, the nucleus module of online transaction system, for realizing the processing logic of on-line transaction, operation user account, and record transaction log.In addition, operational processor calls the database manipulation program of appointment according to the calling rule of Service Manager notice.
Running monitor, the operation conditions of supervisory system is collected operation information in the operational process of online transaction system, comprises transaction business amount, customer volume, abnormal volume etc., and sends operation information to Service Manager.
Service Manager, in online transaction system for the coordination master control of each module.Service Manager receives the operation information of running monitor, judge whether transaction business amount surpasses the threshold values of appointment, and when portfolio surpasses the threshold values of appointment, calling data structure generator produces sublist and the corresponding database manipulation program of core data table, produces new calling rule informing business processor simultaneously.
Data structure generator, for carrying out the establishment of sublist and the corresponding database manipulation program of tables of data.Data structure generator, according to the fractionation rule of tables of data, generates the sublist of building the data definition statement of table and creating core data table in database by tables of data template, then by the database manipulation program of Code Template generating run sublist.
Tables of data template, provides the general statement of the sublist of setting up core data table, and data structure generator generates the data definition statement of building table according to tables of data template.
Wherein, described general statement comprises self-defining tag statement and data definition statement.Data definition statement is comprised of stsndard SQL (Structured Query Language (SQL)), can in Database Systems, directly carry out.General statement is owing to having used self-defining tag statement, and this statement can not directly be carried out in Database Systems; And self-defining tag statement has defined tables of data title, therefore self-defining tag statement need to be replaced with to real tables of data title, thereby general statement is converted to database definition statement, and the data definition statement after conversion could be carried out in Database Systems.
Code Template, provides the general statement of building database running program, and data structure generator is according to Code Template generating database running program.
Database, the data storage for online transaction system, comprises and stores the tables of data of user account information and the tables of data of transaction log.
Another object of the present invention is to, a kind of implementation method of the online transaction system from expansion is provided, the method adopts following technical scheme:
The ruuning situation of supervisory system, according to the operation information of collecting in system operational process, judge whether transaction business amount exceeds predetermined threshold, if so, in database, create the sublist of tables of data, generate the database manipulation program of described sublist, and generate new calling rule;
According to described new calling rule, call the database manipulation program of appointment, the described sublist creating is operated.
In conjunction with aforesaid online transaction system, above-mentioned implementation method specifically comprises:
In the operational process of online transaction system, running monitor is collected the operation informations such as portfolio, customer volume and abnormal volume, and operation information is sent to Service Manager;
Service Manager receives the operation information of running monitor, judges whether transaction business amount surpasses the threshold values of appointment; When portfolio surpasses the threshold values of appointment, Service Manager sends structural adjustment request message to data structure generator;
Data structure generator receives the structural adjustment request message of Service Manager, according to the fractionation rule of tables of data, by tables of data template, generate the sublist of building the data definition statement of table and creating core data table in database, then by the database manipulation program of Code Template generating run sublist; After creating sublist and database manipulation program and completing, data structure generator sends structural adjustment response message to Service Manager;
Service Manager receives the structural adjustment response message of data structure generator, produces new calling rule, and this calling rule is sent to operational processor according to response message;
Operational processor receives the notification message of calling rule, calls the database manipulation program of appointment according to calling rule, to carry out the processing logic of transaction data, operates newly-increased sublist.
Clearer for what the object, technical solutions and advantages of the present invention were expressed, below with reference to accompanying drawing and preferred embodiment, the present invention is done to further description.
As shown in Figure 1, the online transaction system of expansion certainly of the embodiment of the present invention comprises: operational processor 101, running monitor 102, Service Manager 103, data structure generator 104, tables of data template 105, Code Template 106 and database 107, wherein:
Operational processor 101: for realizing the processing logic of on-line transaction, the user account tables of data of operating database 107, and Transaction Information is recorded in to transaction log table in database 107.This operational processor 101 receives the calling rule notification message that Service Manager 103 sends, first according to user ID, determine the interval that ID value is affiliated, and calculate the mould of user ID to transaction log sublist quantity, according to above two numerical value, in calling rule, search storing process title, then in database 107, call this storing process, in the situation that do not revise the processing logic of this operational processor 101, just can operate in the user account tables of data of new expansion in database 107 and the sublist of transaction log table; The flow control notification message that this operational processor 101 also sends for receiving Service Manager 103, according to flow control parameter, returns to replying of refusal processing to the request of Partial Online transaction, to guarantee the normal operation of online transaction system.
Running monitor 102, be mainly used in the operation conditions of monitoring business processor 101 and database 107, in system operational process, collect operation information, comprise transaction business amount, customer volume, abnormal volume etc., and send operation information notification message to Service Manager 103.
Service Manager 103, realize the coordination master control of each module, receive the operation information notification message of running monitor 102, judge whether transaction business amount surpasses the threshold values of appointment, when portfolio surpasses the threshold values of appointment, Service Manager 103 judges whether to do flow control and processes: if portfolio surpasses power system capacity scope, Service Manager 103 transmitted traffics are controlled notification message to operational processor 101, if portfolio is within the scope of power system capacity, the first calling data structure generator 104 of Service Manager 103 for example, to produce the transaction log table of specified quantity (can specify by structural adjustment request message the quantity of sublist) and the sublist of user account tables of data, simultaneously according to the storing process of these sublists of syntagmatic generating run of the multi-to-multi of user account tables of data and transaction log table, then repartition the interval of user ID value, according to the quantity of the interval quantity of user ID value and transaction log sublist, produce new calling rule, and send calling rule notification message to operational processor 101.
Wherein, calling rule is, by the interval under user ID value and user ID, the mould of transaction log sublist quantity is determined to invoked storing process title jointly.Because variation has all occurred for the interval of user ID value and the quantity of transaction log sublist, therefore original calling rule needs to upgrade, and according to the syntagmatic of the multi-to-multi of user account tables of data and transaction log table, resets calling rule.
; user account tables of data records the user account information in certain user ID value interval; system is the quantity delivery to transaction log sublist by ID value; the result of modulo operation is to be more than or equal to 0 and be less than the quantity of transaction log sublist; therefore; system can be determined a sublist of transaction log table according to the result of modulo operation, and the transaction log that the user account of this ID value is produced is write in this sublist.
According to above method, for the user account in an ID value interval, although its ID value is continuous, but the result of modulo operation is different, this just causes the transaction log of these user accounts to be recorded in different transaction log sublists, thus the corresponding a plurality of transaction log sublists of user account tables of data.On the other hand, user account for different I D value, if the result of above modulo operation is identical, the transaction log of these user accounts is recorded in identical transaction log sublist, thus the corresponding a plurality of user account data sublists of transaction log table.
Storing process need to operate a user account tables of data and a transaction log table simultaneously, therefore, for each user account data sublist, needs the storing process of generation and transaction log sublist equal number.
More than describe Service Manager and generated a plurality of storing processs according to the syntagmatic of the multi-to-multi of user account tables of data and transaction log table, and reset the concrete operations of calling rule.In embodiment of the present invention, the sublist quantity of supposing the newly-increased transaction log table of each system extension is A1, the sublist quantity of account data table of Adding User is B1, before expansion, the sublist quantity of former transaction log table is A0, before expansion, the sublist quantity of original subscriber's account data table is B0, after expansion, newly-increased storing process quantity is A1* (B0+B1)+A0*B1, and the interval of user ID value is reclassified as B0+B1.
Data structure generator 104, for the sublist of transaction log table and user account tables of data and the establishment that operates the storing process of these sublists.Data structure generator 104 receives the structural adjustment request message of Service Manager 103, according to the split result of tables of data, first by tables of data template 105, generate the data definition statement of building table, and in database 107, create the newly-increased sublist of transaction log table and user account tables of data, then the storing process code by Code Template 106 generating run sublists create storing process in database 107, finally send structural adjustment response message to Service Manager 103, in structural adjustment response message, except comprising, represent the whether successful state of structural adjustment operation, the relevant information that also comprises the storing process of generation, user ID block information, and the quantity of transaction log table etc.
Tables of data template 105, the general statement of the sublist of setting up transaction log table and user account tables of data is provided, transaction log table name in statement claims to indicate by special tag with the variable part such as user account tables of data title, and data structure generator 104 is used mode that determined values replace labels to generate the data definition statement of building table according to tables of data template 105.
Code Template 106, the general statement of the storing process of the sublist of setting up operation user account tables of data and transaction log table is provided, transaction log table name in statement claims to indicate by special tag with the variable part such as user account tables of data title, and the mode that data structure generator 104 is used determined values to replace labels according to Code Template 106 generates storing process code.
Wherein, tables of data template 105 and Code Template 106 can be located at the functional module in data structure generator 104, can be also independent functional modules.
Database 107, the data storage for online transaction system, comprises and stores the tables of data of user account information and the tables of data of transaction log, and the storing process of function data table (FDT).
As shown in Figure 2, be the idiographic flow schematic diagram of the implementation method of the online transaction system of expansion certainly of the embodiment of the present invention, this flow process mainly comprises the following steps:
Step 201, running monitor is collected the operation informations such as portfolio, customer volume and abnormal volume, and operation information is sent to Service Manager by operation information notification message;
Step 202, Service Manager receives the operation information notification message of running monitor, judges whether transaction business amount surpasses the threshold values of appointment; When portfolio surpasses the threshold values of appointment, Service Manager judges whether to do flow control and processes; If portfolio surpasses power system capacity scope, Service Manager transmitted traffic is controlled notification message to operational processor; If portfolio is within the scope of power system capacity, Service Manager sends structural adjustment request message to data structure generator;
Step 203, data structure generator receives the structural adjustment request message of Service Manager, according to the fractionation rule of tables of data, by tables of data template, generate and build the data definition statement of table and in database, create user account tables of data and the sublist of transaction log table, then by Code Template, generate the storing process code of accessing operation sublist and in database, create this storing process; After creating the sublist of user account tables of data and transaction log table and storing process and completing, data structure generator sends structural adjustment response message to Service Manager;
Step 204, Service Manager receives the structural adjustment response message of data structure generator, produces new call stored procedure rule, and this calling rule is sent to operational processor by calling rule notification message according to response message;
Step 205, operational processor receives the calling rule notification message of Service Manager, calls the storing process of appointment according to calling rule, to carry out the processing logic of transaction data, operates the sublist of Add User account data table and transaction log table; Or operational processor receives the flow control notification message of Service Manager, according to flow control parameter, the request of Partial Online transaction is returned to replying of refusal processing, to guarantee the normal operation of online transaction system.
Compared to prior art, the system of the embodiment of the present invention and the beneficial effect of method thereof, specifically comprise following aspect:
First, the modification that can cause transaction business logic of cutting apart with respect to tables of data in prior art scheme, the present invention has introduced the automatic expansion of submeter and the encapsulation of underlying database operation, cutting apart of tables of data is transparent to service layer, the foundation of sublist is without the modification of upper-layer service logic, and this has just farthest reduced the complicacy of system maintenance;
Second, with respect to tables of data in prior art scheme, again cut apart the operation suspension that can cause online transaction system, in the present invention, sublist is automatically to set up according to the portfolio of on-line transaction, system can dynamically adapt to the growth of portfolio, without shutting down, safeguard that the efficiency that this has just greatly improved operation has reduced the cost of runing;
The 3rd, with respect to causing the manual of database manipulation code again cutting apart of tables of data in prior art scheme, revise, the present invention is by automatically producing the storing process code relevant to sublist, do not safeguard by hand storing process, this has just reduced revises the possibility of makeing mistakes, and has farthest improved the availability of system.
These are only preferred case study on implementation of the present invention; be not limited to the present invention; the present invention also can have other various embodiments; in the situation that not deviating from spirit of the present invention and essence thereof; those of ordinary skill in the art can make according to the present invention various corresponding changes and distortion, but these corresponding changes and distortion all should belong to the protection domain of the appended claim of the present invention.
One of ordinary skill in the art will appreciate that all or part of step in said method can come instruction related hardware to complete by program, described program can be stored in computer-readable recording medium, as ROM (read-only memory), disk or CD etc.Alternatively, all or part of step of above-described embodiment also can realize with one or more integrated circuit.Correspondingly, each the module/unit in above-described embodiment can adopt the form of hardware to realize, and also can adopt the form of software function module to realize.The present invention is not restricted to the combination of the hardware and software of any particular form.

Claims (7)

1. from an online transaction system for expansion, it is characterized in that, described system comprises:
Operational processor, for calling the database manipulation program of appointment according to the calling rule of Service Manager notice, operates the sublist of tables of data;
Running monitor for the ruuning situation of supervisory system, is collected operation information and sends to Service Manager in system operational process;
Service Manager, the operation information for sending according to the running monitor that receives, judges whether transaction business amount exceeds predetermined threshold, if so, calling data structure generator, and generate new calling rule and notify to operational processor;
Data structure generator after called, create the sublist of tables of data, and generates the database manipulation program of described sublist in database;
Described tables of data comprises user account tables of data and transaction log table, and described database manipulation program comprises storing process;
Described Service Manager is further used for, and by sending structural adjustment request message, calls described data structure generator, the quantity of the sublist of specify creation user account tables of data and transaction log table in described structural adjustment request message; And, according to the structural adjustment response message of described data structure generator, generate described new calling rule, wherein, described calling rule is, by the interval under user ID value and user ID, the mould of transaction log sublist quantity is determined to invoked storing process title jointly;
Described data structure generator is further used for, and according to described structural adjustment request message, creates the user account tables of data of specified quantity and the sublist of transaction log table; According to the syntagmatic of the sublist of described user account tables of data and transaction log table, generate storing process, and repartition the interval of user ID value, to described Service Manager, return and represent whether successfully structural adjustment response message of structural adjustment operation, and the quantity of the interval of described user ID value and described transaction log table is included in described structural adjustment response message and sends to described Service Manager.
2. the system as claimed in claim 1, is characterized in that, described data structure generator further comprises tables of data template and Code Template, wherein:
Tables of data template, for providing the general statement of the sublist of setting up tables of data;
Code Template, for providing the general statement of building database running program;
Described data structure generator is used for, and generates the data definition statement that creates described sublist, and generate described database manipulation program according to described Code Template according to described tables of data template.
3. system as claimed in claim 2, is characterized in that,
Described database template and described Code Template also for, the transaction log table name indicating in described general statement by special tag claims and user account tables of data title;
Described data structure generator also for, the mode of using determined value to replace label generates the data definition statement that creates described sublist, and described storing process.
4. system as claimed in claim 1 or 2, is characterized in that,
Described Service Manager is further used for, according to described operation information, judging transaction business amount exceeds after predetermined threshold, judge whether transaction business amount exceeds power system capacity scope, if exceed power system capacity scope, transmitted traffic control message is to operational processor;
Described operational processor is further used for, and while receiving described flow control messages, according to predefined flow control parameter, Partial Online transaction request is returned to replying of refusal processing.
5. from an implementation method for the online transaction system of expanding, it is characterized in that, described method comprises:
The ruuning situation of supervisory system, according to the operation information of collecting in system operational process, judge whether transaction business amount exceeds predetermined threshold, if so, in database, create the sublist of tables of data, generate the database manipulation program of described sublist, and generate new calling rule;
According to described new calling rule, call the database manipulation program of appointment, the described sublist creating is operated;
Described tables of data comprises user account tables of data and transaction log table, and described database manipulation program comprises storing process;
Create after the sublist of user account tables of data and transaction log table, according to the syntagmatic of the sublist of described user account tables of data and transaction log table, generate storing process, and repartition the interval of user ID value, generate new calling rule; Described calling rule is by according to the interval under user ID value and user ID, the mould of transaction log sublist quantity being determined to invoked storing process title jointly.
6. method as claimed in claim 5, is characterized in that,
According to the transaction business amount in described operation information, determine the quantity of the sublist that creates user account tables of data and transaction log table.
7. method as claimed in claim 5, is characterized in that, described method also comprises:
According to described operation information, judging transaction business amount exceeds after predetermined threshold, judge again whether transaction business amount exceeds power system capacity scope, if exceed power system capacity scope, according to predefined flow control parameter, Partial Online transaction request is returned to replying of refusal processing.
CN201010234191.XA 2010-07-20 2010-07-20 Self-expanded online transaction system and implementing method thereof Active CN101894348B (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
CN201010234191.XA CN101894348B (en) 2010-07-20 2010-07-20 Self-expanded online transaction system and implementing method thereof
PCT/CN2010/080316 WO2012009934A1 (en) 2010-07-20 2010-12-27 Self-expanded online transaction system and implementation method thereof

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201010234191.XA CN101894348B (en) 2010-07-20 2010-07-20 Self-expanded online transaction system and implementing method thereof

Publications (2)

Publication Number Publication Date
CN101894348A CN101894348A (en) 2010-11-24
CN101894348B true CN101894348B (en) 2014-04-09

Family

ID=43103532

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201010234191.XA Active CN101894348B (en) 2010-07-20 2010-07-20 Self-expanded online transaction system and implementing method thereof

Country Status (2)

Country Link
CN (1) CN101894348B (en)
WO (1) WO2012009934A1 (en)

Families Citing this family (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101894348B (en) * 2010-07-20 2014-04-09 中兴通讯股份有限公司 Self-expanded online transaction system and implementing method thereof
CN102682044A (en) * 2011-04-14 2012-09-19 天脉聚源(北京)传媒科技有限公司 Method for splitting tables for PHP MYSQL database
CN102236560A (en) * 2011-08-01 2011-11-09 苏州万图明电子软件有限公司 New software module development method
CN105095393B (en) * 2015-06-30 2018-11-16 努比亚技术有限公司 A kind of date storage method and device
CN105677761A (en) * 2015-12-30 2016-06-15 国网信息通信产业集团有限公司 Data sharding method and system
CN107767236A (en) * 2017-11-14 2018-03-06 北京小度信息科技有限公司 A kind of order method for pushing, device, server and computer-readable recording medium
CN107943584A (en) * 2017-11-15 2018-04-20 中国银行股份有限公司 The processing method and processing device of batch transaction request
CN110109986B (en) * 2018-01-16 2023-08-11 阿里巴巴集团控股有限公司 Task processing method, system, server and task scheduling system
CN108712350B (en) * 2018-06-05 2022-04-05 中国农业银行股份有限公司 Flow control method and device capable of automatically regulating and controlling in real time based on custom rule
CN110046153B (en) * 2018-11-19 2023-09-05 创新先进技术有限公司 Account fund checking method, device and equipment
CN110059306A (en) * 2019-04-11 2019-07-26 北京字节跳动网络技术有限公司 Processing method, device, equipment and the computer readable storage medium of online table
CN110825739B (en) * 2019-10-30 2021-07-16 京东数字科技控股有限公司 Table building statement generation method, device, equipment and storage medium

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5467270A (en) * 1991-01-29 1995-11-14 Nec Corporation System and method for POS based fuzzy theory utilizing data extraction
CN1851737A (en) * 2005-10-14 2006-10-25 华为技术有限公司 User individual business realizing system and method
CN101510204A (en) * 2009-03-02 2009-08-19 南京航空航天大学 Abnormal enquiry and monitor method based on target condition association rule database

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH04305741A (en) * 1991-04-02 1992-10-28 Nec Corp Data base input/output control system
UA74345C2 (en) * 1999-09-08 2005-12-15 Слоан-Кеттерінг Інстітьют Фо Кансер Рісерч Means for cell differentiation and inhibitors of histone deacetylase and methods for their use
US20030099192A1 (en) * 2001-11-28 2003-05-29 Stacy Scott Method and system for a switched virtual circuit with virtual termination
CN101295267B (en) * 2008-05-30 2013-01-16 中兴通讯股份有限公司 Queue management method and apparatus, computer system and computer readable medium
CN101894348B (en) * 2010-07-20 2014-04-09 中兴通讯股份有限公司 Self-expanded online transaction system and implementing method thereof

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5467270A (en) * 1991-01-29 1995-11-14 Nec Corporation System and method for POS based fuzzy theory utilizing data extraction
CN1851737A (en) * 2005-10-14 2006-10-25 华为技术有限公司 User individual business realizing system and method
CN101510204A (en) * 2009-03-02 2009-08-19 南京航空航天大学 Abnormal enquiry and monitor method based on target condition association rule database

Also Published As

Publication number Publication date
CN101894348A (en) 2010-11-24
WO2012009934A1 (en) 2012-01-26

Similar Documents

Publication Publication Date Title
CN101894348B (en) Self-expanded online transaction system and implementing method thereof
CN102467411B (en) Workflow processing and workflow agent method, device and system
CN108287756A (en) A kind of method and device of processing task
CN101873334A (en) State-driven executable service flow execution method
CN100385973C (en) Business information processing system and method
CN105471662A (en) Cloud server and virtual network strategy centralized control system and method
CN108647081A (en) Empty machine resource automatic distribution system based on order
CN111460038A (en) Quasi-real-time data synchronization method and device
CN108984156A (en) A kind of software auto generating method and system for exempting from code development based on template
CN114201294A (en) Task processing method, device and system, electronic equipment and storage medium
CN102510407A (en) Method and system for reading and writing microblog
CN110519354A (en) A kind of distributed objects storage system and its method for processing business and storage medium
CN101179450B (en) Network performance monitoring method and system and master control veneer and service veneer thereof
CN103051478B (en) A kind of Large Copacity telecom network management system and and methods for using them is set
EP2348676B1 (en) Method for accessing magnanimity data of intelligent network service database and system and device thereof
US10691364B2 (en) Method for exchanging data between engineering tools of an engineering system, and engineering system for carrying out the method
CN105933396B (en) A kind of each canalization interface of collaboration realizes the method and system of long flow
CN106447249A (en) Watt-hour meter asset abnormal condition alarm method based on turnover cabinet
CN1921412B (en) System and method of circuit shearing and connecting
CN110519403A (en) A kind of gateway down-hanging device management method and system
CN110007901A (en) A kind of development system collecting regimental wind-powered electricity generation monitor supervision platform and its operation method and development approach
CN113793213B (en) Method and device for implementing decision mode of asynchronous credit wind control breakpoint continuous operation
CN109933568A (en) A kind of industry big data platform system and its querying method
CN107133040A (en) A kind of standardized product service apparatus and business module extend method of replacing
CN109426947B (en) Enterprise information interaction system based on tree-shaped virtual node network

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant
TR01 Transfer of patent right

Effective date of registration: 20191217

Address after: 314400 No.11, Weisan Road, Nongfa District, Chang'an Town, Haining City, Jiaxing City, Zhejiang Province

Patentee after: Haining hi tech Zone Science and Innovation Center Co., Ltd

Address before: 518057 Nanshan District Guangdong high tech Industrial Park, South Road, science and technology, ZTE building, Ministry of Justice

Patentee before: ZTE Communications Co., Ltd.

TR01 Transfer of patent right