CN102841906A - Integrated transaction processing system and transaction processing method - Google Patents

Integrated transaction processing system and transaction processing method Download PDF

Info

Publication number
CN102841906A
CN102841906A CN2011101737990A CN201110173799A CN102841906A CN 102841906 A CN102841906 A CN 102841906A CN 2011101737990 A CN2011101737990 A CN 2011101737990A CN 201110173799 A CN201110173799 A CN 201110173799A CN 102841906 A CN102841906 A CN 102841906A
Authority
CN
China
Prior art keywords
commodity
transaction data
original
adjustment
information
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.)
Granted
Application number
CN2011101737990A
Other languages
Chinese (zh)
Other versions
CN102841906B (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.)
Alibaba Group Holding Ltd
Original Assignee
Alibaba Group Holding Ltd
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 Alibaba Group Holding Ltd filed Critical Alibaba Group Holding Ltd
Priority to CN201110173799.0A priority Critical patent/CN102841906B/en
Publication of CN102841906A publication Critical patent/CN102841906A/en
Application granted granted Critical
Publication of CN102841906B publication Critical patent/CN102841906B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention provides an integrated transaction processing system and a transaction processing method, which aims at solving the problem of the existing transaction processing system that the computational processing is scattered. The system comprises one or more application subsystems, and the system also comprises an original database, an information adjusting database and a computing engine, wherein the original database is used for storing the original transaction data needed by each application subsystem; the information adjusting database is used for storing adjusting configuration information for adjusting the original transaction data; the computing engine is used for calling the adjusting configuration information from the information adjusting database and computing the adjusted transaction data; and each application subsystem is used for directly acquiring the original transaction data from the original database and/or acquiring the adjusted transaction data through the computing engine according to the application requirement. Due to the adoption of the integrated transaction processing system and the transaction processing method, the problem of the inconsistent computing result caused by the scattered computation in the prior art can be solved, and the computing pressure of the transaction data born by each application subsystem can be reduced.

Description

A kind of transaction processing system of integration and transaction processing method
Technical field
The application relates to the network data processing technology, particularly relates to a kind of transaction processing system and transaction processing method of integration.
Background technology
In practical application, there is a kind of transaction processing system as shown in Figure 1:
Said transaction processing system comprises a plurality of application subsystems, and the application subsystem 1 shown in figure is to application subsystem N, and each application subsystem realizes professional a kind of application processes.Said transaction processing system also comprises raw data base, is used for storing each application subsystem at the required various original transaction data of applicable procedures.In addition, computing module is set respectively in each application subsystem, the computing module 1 shown in figure is to computing module N.Said computing module is used for the adjustment configuration information according to affiliated application subsystem, adjusts calculating to using the required original transaction data of subsystem.
In the transaction processing process, each application subsystem meeting basis is the needs of application processes separately, perhaps from raw data base, directly call required original transaction data with dealing with; Perhaps call adjustment configuration information separately, and utilize computing module separately to carry out the adjustment calculating of original transaction data, transaction data is with dealing with after the adjustment that will calculate then.
Can be found out that by above-mentioned system shown in Figure 1 and application corresponding processing procedure in the existing this transaction processing system, each application subsystem is all accomplished the adjustment of transaction data separately and calculated, this brings inconvenience with regard to the management of giving each application subsystem.
For example, in some business processing flow, need the several application subsystem to adopt identical adjustment strategy that identical original transaction data is adjusted calculating respectively, and respectively result of calculation is returned to the user.If the calculating of certain application subsystem makes mistakes in computation process; The inconsistent problem of this several application subsystem result of calculation will appear; The different application subsystem result of calculation that returns to the user also the problem of inconsequent can occur so, and then causes business processing to be made mistakes.In addition, bear other business processing work again, will increase the calculating pressure of application subsystem undoubtedly because each application subsystem is promptly born the evaluation work of original transaction data.
In addition, the inconvenience of this management also is embodied in following aspect: adjust configuration information if change or increase, just need in a plurality of application subsystems that are suitable for this adjustment strategy, change respectively or increase, the workload that expends is big.
In a word, the problem that the described this transaction processing system of prior art exists computing to disperse need be solved.
Summary of the invention
The application provides a kind of transaction processing system and transaction processing method of integration, to solve the problem that present transaction processing system exists computing to disperse.
In order to address the above problem, the application discloses a kind of transaction processing system of integration, comprises one or more application subsystems, also comprises:
Raw data base is used to store the required original transaction data of each application subsystem;
Information adjustment database is used to store the adjustment configuration information that is used for adjusting original transaction data;
Computing engines is used for adjusting configuration information and calculating adjusted transaction data from said information adjustment data base call;
Each application subsystem is used for directly obtaining original transaction data from said raw data base according to application separately is required, and/or, obtain adjusted transaction data through said computing engines.
Preferably, said system also comprises: cache subsystem is used for the adjusted transaction data that the said computing engines of buffer memory calculates.
Preferably, said computing engines comprises:
The caching query module; Be used for when any application subsystem is obtained adjusted transaction data through computing engines; Inquire about the adjusted transaction data that whether has said application subsystem required in the said cache subsystem, and according to Query Result trigger data acquisition module or adjustment computing module;
Data acquisition module is used for when said cache subsystem has the required adjusted transaction data of said application subsystem, directly obtaining from cache subsystem, and returning to said application subsystem;
The adjustment computing module; Be used for when said cache subsystem does not have the required adjusted transaction data of said application subsystem; Adjust configuration information and calculate adjusted transaction data from said information adjustment data base call; Then adjusted transaction data is returned to said application subsystem, and deposit said cache subsystem in.
Wherein, the adjustment configuration information in all or part of original transaction data in the said raw data base and the said information adjustment database carries out man-to-man relationship maps through Data Identification.
Preferably, said original transaction data comprises the original pricing information of commodity sign ID, merchandise news and commodity; Said adjustment configuration information comprises commodity sign ID, advertising campaign sign ID, advertising campaign type, discount, movable promotional price, movable Start Date and activity end date; Said adjusted transaction data comprises commodity sign ID and commercial promotions pricing information.
Preferably, said advertising campaign type comprises that commodity give a discount and the adjustment commodity price;
Said computing engines comprises:
The Activity Type judge module is used for judging according to the advertising campaign type that said adjustment configuration information is set, and when said advertising campaign type is the commodity discounting, triggers the discount computing module; When said advertising campaign type is the adjustment commodity price, the trigger price adjusting module;
The discount computing module is used for the discount that the original price of commodity is set according to said adjustment configuration information is calculated, and the commodity price after obtaining giving a discount also returns to application subsystem;
The price adjustment module is used for reading the movable promotional price that said adjustment configuration information sets and returns to application subsystem.
Preferably; Said computing engines also comprises: the activity availability judge module; The movable Start Date and the activity end date that are used for setting according to said adjustment configuration information judge whether advertising campaign is effective, when activity is effective, trigger said Activity Type judge module; When activity is invalid, from said raw data base, obtains the original price of commodity and return to application subsystem.
Preferably; Said application subsystem comprises: commodity management system; Be used for being provided with the merchandise news and the original pricing information of commodity of said raw data base, also be used for being provided with advertising campaign type, discount, movable promotional price, movable Start Date and the activity end date of said information adjustment database.
Preferably; Said application subsystem comprises: the commodity displaying system, be used for according to the commodity displaying request, and judge through inquiring about said information adjustment database whether the commodity that will show participate in advertising campaign; If participate in, then obtain commercial promotions pricing information and displaying through said computing engines; If have neither part nor lot in, then directly from said raw data base, obtain original pricing information of commodity and displaying.
Preferably; Said application subsystem comprises: ordering system, be used for according to the commodity request of placing an order, and judge through inquiring about said information adjustment database whether the commodity in the order participate in advertising campaign; If participate in, then obtain the commercial promotions pricing information and place an order through said computing engines; If have neither part nor lot in, obtain the original pricing information of commodity in the then direct said raw data base and place an order.
The application also provides a kind of transaction processing method of integration, comprising:
The original transaction data that each application subsystem is required stores raw data base into;
Store the adjustment configuration information that is used for adjusting original transaction data into information adjustment database;
When each application subsystem need be obtained original transaction data, then obtain from said raw data base;
When each application subsystem need be obtained adjusted transaction data; Then call computing engines; Said computing engines obtains corresponding adjustment configuration information from information adjustment database; And calculate adjusted transaction data, then said adjusted transaction data is distributed to each application subsystem that needs.
Preferably, said method also comprises: application subsystem is carried out buffer memory with the adjusted transaction data that computing engines calculates; When any application subsystem need be obtained adjusted transaction data, whether inquiry earlier had the said adjusted transaction data of buffer memory, if then directly obtain the adjusted transaction data of buffer memory; If, do not call computing engines again.
Wherein, the adjustment configuration information in all or part of original transaction data in the said raw data base and the said information adjustment database carries out man-to-man relationship maps through Data Identification.
Preferably, said original transaction data comprises the original pricing information of commodity sign ID, merchandise news and commodity; Said adjustment configuration information comprises commodity sign ID, advertising campaign sign ID, advertising campaign type, discount, movable promotional price, movable Start Date and activity end date; Said adjusted transaction data comprises commodity sign ID and commercial promotions pricing information.
Preferably, if the original transaction data of certain bar in the raw data base matches the identical data sign in the information adjustment database through Data Identification, then call computing engines and calculate adjusted transaction data; If the original transaction data of certain bar in the raw data base can't match the identical data sign in the information adjustment database through Data Identification, then obtain original transaction data from said raw data base.
Compared with prior art, the application comprises following advantage:
At first; The application proposes a kind of transaction processing system of integration, and this system comprises one or more application subsystems, be used to store the raw data base of original transaction data, be used to store the information adjustment database and the computing engines of the adjustment configuration information of original transaction data; Said computing engines is used for from information adjustment data base call adjustment configuration information and calculates adjusted transaction data; And each application subsystem can directly be obtained original transaction data from said raw data base according to application separately is required, perhaps obtains adjusted transaction data through said computing engines.
Hence one can see that; Said computing engines combines the computing function that is arranged on the computing module in each application subsystem in the prior art; And from each application subsystem, separate, when each application subsystem need be obtained adjusted transaction data, all be to obtain through said computing engines; Promptly all be to unifiedly calculate by computing engines; And result of calculation returned to the application subsystem that needs, therefore can avoid in the prior art owing to disperse to calculate the inconsistent problem of result of calculation that causes, and can reduce the calculating pressure of the transaction data that each application subsystem bears.
And the maintenance and management of total system also is convenient in the integration of this system, when changing or increase the adjustment configuration information, gets final product through resetting information adjustment database, need not each application subsystem is provided with, thereby has promoted the scalability of system.
Secondly; The transaction processing system of the said integration of the application also comprises cache subsystem, is used for the adjusted transaction data that the said computing engines of buffer memory calculates for the first time, when computing engines once more when application subsystem is returned adjusted transaction data; Can directly obtain from said cache subsystem; Need not double counting again, therefore this integration has also improved the travelling speed of transaction processing system, has promoted system performance.
Certainly, arbitrary product of enforcement the application not necessarily need reach above-described all advantages simultaneously.
Description of drawings
Fig. 1 is a kind of transaction processing system structural drawing of the prior art;
Fig. 2 is the structural drawing of the transaction processing system of the said a kind of integration of the application embodiment;
Fig. 3 is the structural drawing of the said a kind of electronic trading system of the application embodiment;
Fig. 4 is the said promotional price computing engines of a application embodiment structural drawing;
Fig. 5 is that the said seller of the application embodiment issues commodity and the process flow diagram of participating in advertising campaign;
Fig. 6 is the process flow diagram of the said buyer's browse commodities of the application embodiment;
Fig. 7 is the calculation flow chart of the said promotional price computing engines of the application embodiment;
Fig. 8 is the said buyer of the application embodiment process flow diagram that places an order.
Embodiment
For above-mentioned purpose, the feature and advantage that make the application can be more obviously understandable, the application is done further detailed explanation below in conjunction with accompanying drawing and embodiment.
The application proposes a kind of transaction processing system of integration, can solve the problem of disperseing calculating in the prior art.Through embodiment the said system of the application is elaborated below.
With reference to Fig. 2, be the structural drawing of the transaction processing system of the said a kind of integration of the application embodiment.
The transaction processing system of said integration comprises one or more application subsystem 21, raw data base 22, information adjustment database 23 and computing engines 24, wherein:
Raw data base 22 is used to store the required original transaction data of each application subsystem 21;
Information adjustment database 23 is used to store the adjustment configuration information that is used for adjusting original transaction data;
Computing engines 24 is used for calling the adjustment configuration information and calculating adjusted transaction data from said information adjustment database 23;
Each application subsystem 21 is used for directly obtaining original transaction data from said raw data base 22 according to application separately is required, and/or, obtain adjusted transaction data through said computing engines 24.
Wherein, Said " and/or " being meant: each application subsystem 21 can be according to application need separately; Perhaps obtain original transaction data from raw data base 22; Perhaps obtain adjusted transaction data, perhaps obtain original transaction data and adjusted transaction data simultaneously through said computing engines 24.
In above-mentioned transaction processing system, the adjustment configuration information in all or part of original transaction data in the said raw data base 22 and the said information adjustment database 23 carries out man-to-man relationship maps through Data Identification.For example; The all corresponding data ID of the original transaction data of each bar in the said raw data base 22; Also corresponding data ID of each bar adjustment configuration information in the said information adjustment database 23; Like this, if the original transaction data of certain bar can match the adjustment configuration information with identical data ID through data ID, then represent to adjust to this original transaction data; Opposite; If the original transaction data of certain bar can't match the adjustment configuration information with identical data ID through data ID; The adjustment configuration information of this original transaction data is not set in the then expression information adjustment database 23, and this original transaction data can not be adjusted.
Each application subsystem 21 basis is the situation of business processing separately, obtains original transaction data if desired, then directly reads from raw data base 22; Obtaining adjusted transaction data if desired, then call computing engines 24, called the adjustment configuration information and adjusted calculating by computing engines 24, is that adjusted transaction data returns to the application subsystem 21 of calling it with result of calculation.Certainly; The original transaction data of certain bar need be adjusted in information corresponding adjustment configuration information is set in the database 23, and application subsystem 21 just can be in needs gets access to through computing engines 24 adjusts the transaction data after the calculating to said original transaction data.
Said computing engines 24 at first according to the data ID of application subsystem 21 requests, obtains the adjustment configuration information that is associated with this data ID from information adjustment database 23 in concrete computation process; Then this adjustment configuration information is analyzed, original transaction data is adjusted calculating according to the adjustment strategy that analyzes.Certainly, the adjustment configuration information is different, and the computing method of computing engines 24 are also different.
In addition, preferred, the transaction processing system of said integration can also comprise:
Cache subsystem 25 is used for the adjusted transaction data that the said computing engines 24 of buffer memory calculates.
Accordingly, said computing engines 24 further can comprise:
Caching query module 241; Be used for when any application subsystem 21 is obtained adjusted transaction data through computing engines 24; Inquire about the adjusted transaction data that whether has said application subsystem 21 required in the said cache subsystem 25, and according to Query Result trigger data acquisition module 242 or adjustment computing module 243;
Data acquisition module 242 is used for when said cache subsystem 25 has the required adjusted transaction data of said application subsystem 21, directly obtaining from cache subsystem 25, and returning to said application subsystem 21;
Adjustment computing module 243; Be used for when said cache subsystem 25 does not have the required adjusted transaction data of said application subsystem 21; Call the adjustment configuration information and calculate adjusted transaction data from said information adjustment database 23; Then adjusted transaction data is returned to said application subsystem 21, and deposit said cache subsystem 25 in.
In sum, transaction processing system and the described transaction processing system of prior art with above-mentioned integration contrasts as follows:
First; The transaction processing system of said integration is incorporated into the computing function that is arranged on the computing module in each application subsystem in the prior art in the computing engines; And said computing engines separated from each application subsystem; When each application subsystem need be obtained adjusted transaction data; All being to obtain through said computing engines, promptly all is to be unifiedly calculated by computing engines, and result of calculation is returned to the application subsystem that needs; Therefore can avoid in the prior art owing to disperse to calculate the inconsistent problem of result of calculation that causes, and can reduce the calculating pressure that evaluation work produced that application subsystem is born the transaction data adjustment.
Second; The maintenance and management of total system also is convenient in the integration of said transaction processing system, when changing or increase the adjustment configuration information, gets final product through resetting information adjustment database; Need not each application subsystem is provided with, thereby promoted the scalability of whole transaction processing system.
The 3rd; The adjusted transaction data that the transaction processing system of said integration comes the said computing engines of buffer memory to calculate for the first time through cache subsystem; When computing engines once more when application subsystem is returned adjusted transaction data, can directly obtain from said cache subsystem, need not double counting again; Therefore this integration has also improved the travelling speed of transaction processing system, has promoted system performance.
In addition, based on the transaction processing system shown in Fig. 2 embodiment, the application also provides a kind of transaction processing method embodiment of integration.The transaction processing method of said integration can be realized following flow process based on said transaction processing system:
The first step, the transaction data pretreatment stage mainly comprises the processing of following two steps:
The original transaction data that each application subsystem is required stores raw data base into;
Store the adjustment configuration information that is used for adjusting original transaction data into information adjustment database;
In second step, in the transaction processing stage, mainly comprise the processing of following two kinds of situation:
When each application subsystem need be obtained original transaction data, then obtain from said raw data base;
When each application subsystem need be obtained adjusted transaction data; Then call computing engines; Said computing engines obtains corresponding adjustment configuration information from information adjustment database; And calculate adjusted transaction data, then said adjusted transaction data is distributed to each application subsystem that needs.
Wherein, the adjustment configuration information in all or part of original transaction data in the said raw data base and the said information adjustment database carries out man-to-man relationship maps through Data Identification.
If the original transaction data of certain bar in the raw data base matches the identical data sign in the information adjustment database through Data Identification, then call computing engines and calculate adjusted transaction data; If the original transaction data of certain bar in the raw data base can't match the identical data sign in the information adjustment database through Data Identification, then obtain original transaction data from said raw data base.
Preferably, said transaction processing method can also comprise:
Application subsystem is carried out buffer memory with the adjusted transaction data that computing engines calculates;
When any application subsystem need be obtained adjusted transaction data, whether inquiry earlier had the said adjusted transaction data of buffer memory, if then directly obtain the adjusted transaction data of buffer memory; If, do not call computing engines again.
By on can know; The transaction processing method of the said integration adjusted transaction data that each application subsystem is required is all unified in computing engines, to calculate; Therefore can avoid in the prior art owing to disperse to calculate the inconsistent problem of result of calculation that causes, and can reduce the calculating pressure that evaluation work produced that application subsystem is born the transaction data adjustment.And the use of said buffer memory can also be avoided the double counting of computing engines, thereby improves transaction processing efficient.
Based on above-mentioned content embodiment illustrated in fig. 2, be well understood to the application's content more in order to make those skilled in the art, be example below with the electronic transaction, system shown in Figure 2 is applied in the commercial promotions calculation of price in the electronic transaction describes.
In network trading based on ecommerce; Especially in the wholesale e-commerce website of small amount; Because online transaction and wholesale singularity; The seller after electronic trading system, can participate in some commercial promotions activities of electronic trading system in merchandise news of issue, such as the participation activity commodity is given a discount, bought how many prices commodity directly subtract, the VIP buyer plays activities such as how many discounts; Thereby impel the buyer to buy turnover, credit rating and popularity that commodity promote the seller, and impel the purchase that places an order of more over-bought man.
In order to realize above-mentioned commercial promotions; When said electronic trading system can be participated in various advertising campaign to the commodity of seller's issue; Commodity to each participation activity carry out the promotion setting; Carry out promotional price and calculate participating in movable commodity through the promotional price computing engines then, when making each application need commercial promotions price of electronic trading system, directly call said promotional price computing engines and calculate and get final product.Be elaborated through electronic trading system shown in Figure 3 below.
With reference to Fig. 3, be the structural drawing of the said a kind of electronic trading system of the application embodiment.
Said electronic trading system can comprise a plurality of application subsystems, and respectively as seller's commodity management system 311, commodity displaying system 312 and the ordering system 313 shown in the figure, certainly, said application subsystem can also comprise other application system.Said electronic trading system also comprises promotional price computing engines 32, commercial promotions price caching system 33, merchandising database 34 and activity commodity sales promotion database 35.
Wherein:
Store original transaction data in the said merchandising database 34, comprised the original pricing information of commodity sign ID, merchandise news and commodity;
Store the price adjustment configuration information in the said activity commodity sales promotion database 35, comprised information such as commodity sign ID, advertising campaign sign ID, advertising campaign type, discount, movable promotional price, movable Start Date and activity end date;
Said promotional price computing engines 32 is used for calling according to each application subsystem; Utilize the price adjustment configuration information of storage in the activity commodity sales promotion database 35 that the original price of commodity is adjusted calculating; And obtain adjusted transaction data, comprise commodity sign ID and commercial promotions pricing information;
Said commercial promotions price caching system 33 is used for the commercial promotions pricing information that promotional price computing engines 32 calculates gained is for the first time carried out buffer memory; When said promotional price computing engines 32 once more when application subsystem is returned identical commercial promotions pricing information; Can directly obtain, need not to carry out double counting from said commercial promotions price caching system 33;
Said seller's commodity management system 311 is used for being provided with the merchandise news and the original pricing information of commodity of said merchandising database 34, also is used for being provided with advertising campaign type, discount, movable promotional price, movable Start Date and the whole configuration information of activity end date style of equal value of said activity commodity sales promotion database 35;
Said commodity displaying system 312 is used for according to the commodity displaying request; Judge through inquiring about said activity commodity sales promotion database 35 whether the commodity that will show participate in advertising campaign; If participate in, then obtain commercial promotions pricing information and displaying through said promotional price computing engines 32; If have neither part nor lot in, then directly from said merchandising database 34, obtain original pricing information of commodity and displaying;
Said ordering system 313 is used for according to the commodity request of placing an order; Judge through inquiring about said activity commodity sales promotion database 35 whether the commodity in the order participate in advertising campaign; If participate in, then obtain the commercial promotions pricing information and place an order through said promotional price computing engines 32; If have neither part nor lot in, then directly said stating obtained the original pricing information of commodity and placed an order in the merchandising database 34.
Need to prove that above-mentioned commercial promotions price caching system 33 is preferred systems that are provided with, can reduce the double counting number of times of promotional price computing engines 32, improve the travelling speed of whole electronic trading system.Accordingly, with reference to promotional price computing engines structural drawing shown in Figure 4, said promotional price computing engines 32 further can comprise:
Caching query module 41; Be used for when any application subsystem is obtained adjusted transaction data through promotional price computing engines 32; Inquire about whether the required adjusted transaction data of said application subsystem is arranged in the said commercial promotions price caching system 33, and according to Query Result trigger data acquisition module 42 or adjustment computing module 43;
Data acquisition module 42 is used for when said commercial promotions price caching system 33 has the required adjusted transaction data of said application subsystem, directly obtaining from commodity promotional price caching system 33, and returning to said application subsystem;
Adjustment computing module 43; Be used for when said commercial promotions price caching system 33 does not have the required adjusted transaction data of said application subsystem; Call the price adjustment configuration information and calculate adjusted transaction data from said activity commodity sales promotion database 35; Then adjusted transaction data is returned to said application subsystem, and deposit said commercial promotions price caching system 33 in.
Based on above-mentioned electronic trading system, in practical application, the advertising campaign type of the most often using comprises two types basically, and one type is that commodity give a discount, as common buyer beat how many discounts, the VIP buyer beats how many discounts etc.; Also have one type to be directly to adjust commodity price, as being new promotional price, or buying commodity and directly subtract how many prices or the like the original price adjustment of commodity.Certainly, also have a variety of advertising campaign types in the practical application, but the calculation of price that the various advertising campaign types of foundation are carried out all is to accomplish through said promotional price computing engines 32.
Based on different advertising campaign types, with reference to shown in Figure 4, the adjustment computing module 43 in the said promotional price computing engines 32 further can comprise:
Activity Type judge module 44 is used for judging according to the advertising campaign type that said price adjustment configuration information is set, and when said advertising campaign type is the commodity discounting, triggers discount computing module 45; When said advertising campaign type is the adjustment commodity price, trigger price adjusting module 46;
Discount computing module 45 is used for the discount that the original price of commodity is set according to said price adjustment configuration information is calculated, and the commodity price after obtaining giving a discount also returns to application subsystem;
Price adjustment module 46 is used for reading the movable promotional price that said price adjustment configuration information sets and returns to application subsystem.
In addition, with reference to shown in Figure 4, the adjustment computing module 43 in the said promotional price computing engines 32 can also comprise:
Activity availability judge module 47, the movable Start Date and the activity end date that are used for setting according to said price adjustment configuration information judge whether advertising campaign is effective, when activity is effective, trigger said Activity Type judge module 44; When activity is invalid, from said merchandising database 34, obtains the original price of commodity and return to application subsystem.
Describe below in conjunction with the principle of work of the transaction flow in the practical application above-mentioned Fig. 3 and electronic trading system shown in Figure 4.
In the electronic transaction of reality, at first the seller accomplishes the issue commodity, the original price of commodity is set, selects commodity to participate in advertising campaign, the commodity price promotion (rule is included on the original price of commodity and gives a discount, changes original price into new modes such as promotional price) of participating in advertising campaign is set.
Then, buyer's browse commodities, said electronic trading system judge that whether commodity that the buyer browses are the commodity of the participation sales promotion that is provided with of seller, if the promotional price that then calculates commodity through the promotional price computing engines is showed.
Equally, when the buyer carries out when done through network the commodity of browsing, said electronic trading system judges also whether the commodity that place an order are commodity sales promotion, is that the promotional price that then calculates by the promotional price computing engines places an order.
Electronic trading system realizes that the mode of above-mentioned transaction flow comprises following three aspects:
1, realizes the flow process that the seller issues commodity and participates in advertising campaign through seller's commodity management system
With reference to Fig. 5, be that the said seller of the application embodiment issues commodity and the process flow diagram of participating in advertising campaign.
1.1 the seller is provided with merchandising database through seller's commodity management system, accomplishes the issue of merchandise news, said merchandise news comprises: information such as trade name, commodity classification, commodity picture, descriptor, freight charges;
1.2 the seller is provided with merchandising database through seller's commodity management system; Completion is provided with the original pricing information of the commodity of issue; The original pricing information of said commodity comprises: information such as commercial specification, minimum minimum quantity of an order, maximum minimum quantity of an order, commodity price; Wherein each specification can be provided with many (limit 5 in this example, can adjust as required) according to the minimum quantity of an order scope, carries out original price such as the commodity to a mp3 and is set to:
Figure BDA0000071122440000131
Table 1
The merchandise news and the original pricing information of commodity of seller's issue all deposit in the merchandising database, and the information in the merchandising database comprises: commodity sign ID, trade name, commodity classification, commodity picture, descriptor, freight charges and original pricing information;
1.3 the seller selects commodity to participate in advertising campaign through seller's commodity management system;
1.4 the seller is provided with activity commodity sales promotion database through seller's commodity management system, the commodity of accomplishing selected participation advertising campaign carry out the promotional price setting.
The promotional price setting is usually included on the original price of commodity and gives a discount, changes original price into new modes such as promotional price.
Commodity such as to top mp3 can be provided with as follows:
The mode that participation advertising campaign on Christmas gives a discount by original price is set to make a call to 4 foldings;
Participate in the original price of advertising campaign on New Year's Day and be set to new promotional price, as follows:
Figure BDA0000071122440000141
Table 2
The seller select to participate in advertising campaign the commercial promotions price setting and deposit in the activity commodity sales promotion database.
Information in the activity commodity sales promotion database comprises: information such as commodity sign ID, movable sign ID, advertising campaign type (referring to still change original price into new price by the discount setting), discount, movable promotional price, movable Start Date, activity end date.If the advertising campaign type is by the discount setting, then the discount value is deposited in the discount field in the activity commodity sales promotion database; If the advertising campaign type is to change original price into new price, then new price is deposited in the movable promotional price field.
Need to prove that activity commodity sales promotion database also can replace with other data storage method in this example, such as key-value engine, NoSql, document storage system etc.No matter realize, can come identification access, and then can solve storage and access performance problem that the magnanimity commodity are participated in sales promotion with commodity sign ID through which kind of data storage method.
2, realize the flow process of buyer's browse commodities through commodity displaying system, promotional price computing engines and commercial promotions price caching system
With reference to Fig. 6, be the process flow diagram of the said buyer's browse commodities of the application embodiment.
2.1 the buyer asks browse commodities, the commodity displaying system obtains merchandise news and the original price of commodity according to commodity sign ID from merchandising database;
2.2 the commodity displaying system is according to commodity sign ID access activity commodity sales promotion database; Check whether these commodity are the commodity of participating in sales promotion; If do not obtain corresponding informance from activity commodity sales promotion database; Then be judged as the commodity that are not to participate in advertising campaign, show by the original price of commodity; If can obtain corresponding informance from activity commodity sales promotion database, then being judged as is the commodity of participating in advertising campaign, calculates the commercial promotions price and shows then through calling the promotional price computing engines.
The calculation process of commercial promotions calculation of price engine is as shown in Figure 7.
With reference to Fig. 7, be the calculation flow chart of the said promotional price computing engines of the application embodiment.
A. commercial promotions calculation of price engine elder generation commodity in use sign ID access products promotional price caching system if the promotional price information of these commodity is arranged in the commercial promotions price caching system, then directly takes out and returns to caller;
If the promotional price information of these commodity not in the commercial promotions price caching system b.; Then judge according to the term of validity (movable Start Date and activity end date) of advertising campaign whether activity is effective; If activity is expired, then directly return the original price of commodity;
If c. the activity of this commodity participation is also effective; Then judge it is to carry out sales promotion by discount; Still carry out sales promotion by the promotional price that resets fully, if carry out sales promotion by discount, then by formula: original price * (1-discount) obtains promotional price; The mp3 commodity that are provided with such as the front by the discount sales promotion then promotional price be: original price * (1-0.4), that is:
Figure BDA0000071122440000151
Table 3
If, then return by the promotional price sales promotion that resets fully:
Figure BDA0000071122440000152
Table 4
D. deposit in the into commercial promotions price caching system as sign for the commercial promotions price commodity in use ID that calculates at every turn; Be convenient to call next time; The expired time of commercial promotions price caching system cache information can be provided with as the case may be, such as 30 minutes.
3, realize single process under the buyer through ordering system, promotional price computing engines and commercial promotions price caching system
With reference to Fig. 8, be the said buyer of the application embodiment process flow diagram that places an order.
3.1 buyer's request places an order, ordering system obtains merchandise news and the original price of commodity according to commodity sign ID from merchandising database;
3.2 ordering system is according to commodity sign ID access activity commodity sales promotion database; Check whether these commodity are the commodity of participating in sales promotion; If do not obtain corresponding informance from activity commodity sales promotion database, then be judged as the commodity that are not to participate in advertising campaign, place an order by the original price of commodity; If can obtain corresponding informance from activity commodity sales promotion database, decision logic is the same during then with commodity displaying, calls the promotional price computing engines and carries out the commercial promotions calculation of price, and place an order with promotional price.
The calculation process of commercial promotions calculation of price engine is as shown in Figure 7, is not described in detail in this.
Because the commodity displaying system has called the promotional price computing engines and has calculated the commercial promotions price in the process of buyer's browse commodities; And deposited commercial promotions price caching system in; Therefore under the buyer in the single process; Can directly obtain the commercial promotions price by the promotional price computing engines, need not double counting from commodity promotional price caching system.
In sum, the calculating of promotional price all is distributed in commodity displaying system and the ordering system and carries out in the prior art, and promptly commodity displaying system and ordering system all calculate promotional price respectively; And the buyer browses commodity and calculates promotional price from the promotional price computing engines when placing an order among the application embodiment; Thereby the advertising campaign product price need be dispersed in use in separately the process of computing concentrate on a place and handle, satisfied the commercial promotions calculation of price unified, be convenient to performance optimization, promote user experience, be convenient to administer and maintain.
The foregoing description is to be that example describes with the commercial promotions calculation of price in the electronic transaction, but also can be applied in concrete the application during other use, and it is similar to the aforementioned embodiment that it implements principle, so repeat no more.
More than to the transaction processing system and the transaction processing method of a kind of integration that the application provided; Carried out detailed introduction; Used concrete example among this paper the application's principle and embodiment are set forth, the explanation of above embodiment just is used to help to understand the application's method and core concept thereof; Simultaneously, for one of ordinary skill in the art, according to the application's thought, the part that on embodiment and range of application, all can change, in sum, this description should not be construed as the restriction to the application.

Claims (15)

1. the transaction processing system of an integration comprises one or more application subsystems, it is characterized in that, also comprises:
Raw data base is used to store the required original transaction data of each application subsystem;
Information adjustment database is used to store the adjustment configuration information that is used for adjusting original transaction data;
Computing engines is used for adjusting configuration information and calculating adjusted transaction data from said information adjustment data base call;
Each application subsystem is used for directly obtaining original transaction data from said raw data base according to application separately is required, and/or, obtain adjusted transaction data through said computing engines.
2. system according to claim 1 is characterized in that, also comprises:
Cache subsystem is used for the adjusted transaction data that the said computing engines of buffer memory calculates.
3. system according to claim 2 is characterized in that, said computing engines comprises:
The caching query module; Be used for when any application subsystem is obtained adjusted transaction data through computing engines; Inquire about the adjusted transaction data that whether has said application subsystem required in the said cache subsystem, and according to Query Result trigger data acquisition module or adjustment computing module;
Data acquisition module is used for when said cache subsystem has the required adjusted transaction data of said application subsystem, directly obtaining from cache subsystem, and returning to said application subsystem;
The adjustment computing module; Be used for when said cache subsystem does not have the required adjusted transaction data of said application subsystem; Adjust configuration information and calculate adjusted transaction data from said information adjustment data base call; Then adjusted transaction data is returned to said application subsystem, and deposit said cache subsystem in.
4. system according to claim 1 is characterized in that:
Adjustment configuration information in all or part of original transaction data in the said raw data base and the said information adjustment database carries out man-to-man relationship maps through Data Identification.
5. according to the arbitrary described system of claim 1 to 4, it is characterized in that:
Said original transaction data comprises the original pricing information of commodity sign ID, merchandise news and commodity;
Said adjustment configuration information comprises commodity sign ID, advertising campaign sign ID, advertising campaign type, discount, movable promotional price, movable Start Date and activity end date;
Said adjusted transaction data comprises commodity sign ID and commercial promotions pricing information.
6. system according to claim 5 is characterized in that:
Said advertising campaign type comprises that commodity give a discount and the adjustment commodity price;
Said computing engines comprises:
The Activity Type judge module is used for judging according to the advertising campaign type that said adjustment configuration information is set, and when said advertising campaign type is the commodity discounting, triggers the discount computing module; When said advertising campaign type is the adjustment commodity price, the trigger price adjusting module;
The discount computing module is used for the discount that the original price of commodity is set according to said adjustment configuration information is calculated, and the commodity price after obtaining giving a discount also returns to application subsystem;
The price adjustment module is used for reading the movable promotional price that said adjustment configuration information sets and returns to application subsystem.
7. system according to claim 6 is characterized in that, said computing engines also comprises:
The activity availability judge module, the movable Start Date and the activity end date that are used for setting according to said adjustment configuration information judge whether advertising campaign is effective, when activity is effective, trigger said Activity Type judge module; When activity is invalid, from said raw data base, obtains the original price of commodity and return to application subsystem.
8. system according to claim 5 is characterized in that, said application subsystem comprises:
Commodity management system; Be used for being provided with the merchandise news and the original pricing information of commodity of said raw data base, also be used for being provided with advertising campaign type, discount, movable promotional price, movable Start Date and the activity end date of said information adjustment database.
9. system according to claim 5 is characterized in that, said application subsystem comprises:
The commodity displaying system is used for according to the commodity displaying request, judges through inquiring about said information adjustment database whether the commodity that will show participate in advertising campaign, if participate in, then obtains commercial promotions pricing information and displaying through said computing engines; If have neither part nor lot in, then directly from said raw data base, obtain original pricing information of commodity and displaying.
10. system according to claim 5 is characterized in that, said application subsystem comprises:
Ordering system is used for according to the commodity request of placing an order, and judges through inquiring about said information adjustment database whether the commodity in the order participate in advertising campaign, if participation is then obtained the commercial promotions pricing information through said computing engines and placed an order; If have neither part nor lot in, obtain the original pricing information of commodity in the then direct said raw data base and place an order.
11. the transaction processing method of an integration is characterized in that, comprising:
The original transaction data that each application subsystem is required stores raw data base into;
Store the adjustment configuration information that is used for adjusting original transaction data into information adjustment database;
When each application subsystem need be obtained original transaction data, then obtain from said raw data base;
When each application subsystem need be obtained adjusted transaction data; Then call computing engines; Said computing engines obtains corresponding adjustment configuration information from information adjustment database; And calculate adjusted transaction data, then said adjusted transaction data is distributed to each application subsystem that needs.
12. method according to claim 11 is characterized in that, also comprises:
Application subsystem is carried out buffer memory with the adjusted transaction data that computing engines calculates;
When any application subsystem need be obtained adjusted transaction data, whether inquiry earlier had the said adjusted transaction data of buffer memory, if then directly obtain the adjusted transaction data of buffer memory; If, do not call computing engines again.
13. method according to claim 11 is characterized in that:
Adjustment configuration information in all or part of original transaction data in the said raw data base and the said information adjustment database carries out man-to-man relationship maps through Data Identification.
14., it is characterized in that according to the arbitrary described method of claim 11 to 13:
Said original transaction data comprises the original pricing information of commodity sign ID, merchandise news and commodity;
Said adjustment configuration information comprises commodity sign ID, advertising campaign sign ID, advertising campaign type, discount, movable promotional price, movable Start Date and activity end date;
Said adjusted transaction data comprises commodity sign ID and commercial promotions pricing information.
15. method according to claim 13; It is characterized in that:, then call computing engines and calculate adjusted transaction data if the original transaction data of certain bar in the raw data base matches the identical data sign in the information adjustment database through Data Identification; If the original transaction data of certain bar in the raw data base can't match the identical data sign in the information adjustment database through Data Identification, then obtain original transaction data from said raw data base.
CN201110173799.0A 2011-06-24 2011-06-24 The transaction processing system of a kind of integration and transaction processing method Active CN102841906B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201110173799.0A CN102841906B (en) 2011-06-24 2011-06-24 The transaction processing system of a kind of integration and transaction processing method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201110173799.0A CN102841906B (en) 2011-06-24 2011-06-24 The transaction processing system of a kind of integration and transaction processing method

Publications (2)

Publication Number Publication Date
CN102841906A true CN102841906A (en) 2012-12-26
CN102841906B CN102841906B (en) 2016-12-07

Family

ID=47369279

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201110173799.0A Active CN102841906B (en) 2011-06-24 2011-06-24 The transaction processing system of a kind of integration and transaction processing method

Country Status (1)

Country Link
CN (1) CN102841906B (en)

Cited By (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104391698A (en) * 2014-11-06 2015-03-04 中国建设银行股份有限公司 Event project generation and price calculation methods and devices
CN104794138A (en) * 2014-01-22 2015-07-22 深圳市沃信科技有限公司 Method, device and system for determining database transaction result
CN105303417A (en) * 2015-12-07 2016-02-03 北京京东尚科信息技术有限公司 Goods automatic ordering system and method
CN106096992A (en) * 2016-05-27 2016-11-09 乐视控股(北京)有限公司 The changing method of commodity price and system
CN106250243A (en) * 2016-08-11 2016-12-21 中国银行股份有限公司 The processing method and processing device of banking system based on poll tupe application
CN107730288A (en) * 2016-08-11 2018-02-23 凡学(上海)教育科技有限公司 A kind of electric business promotion wholesale price management platform and management method
CN107767209A (en) * 2017-09-21 2018-03-06 武汉蜕变人工智能科技有限公司 A kind of automatic price quoting method and system
CN107977848A (en) * 2016-10-21 2018-05-01 浙江银泰电子商务有限公司 promotion rule generation method and promotion rule generation system
CN108133346A (en) * 2017-12-28 2018-06-08 创新无限信息技术(武汉)股份有限公司 The method and system that the setting of bom inventories uploading system is sold by group
CN108228790A (en) * 2017-12-29 2018-06-29 北京奇虎科技有限公司 Push the methods of exhibiting and device of picture
CN109032690A (en) * 2018-06-20 2018-12-18 南京万米信息技术有限公司 A kind of method and apparatus of dynamic processing marketing data
CN109118269A (en) * 2018-07-12 2019-01-01 北京金山云网络技术有限公司 Configuration method, device, electronic equipment and the storage medium of commercial activities rule
CN109656987A (en) * 2018-10-12 2019-04-19 深圳壹账通智能科技有限公司 Data integration method, device, equipment and storage medium
CN110390595A (en) * 2019-07-30 2019-10-29 腾讯科技(深圳)有限公司 A kind of information processing system, method, server and storage medium

Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6457006B1 (en) * 1999-07-20 2002-09-24 Primentia, Inc. System and method for organizing data
CN1372217A (en) * 2001-02-08 2002-10-02 国际商业机器公司 System and method for providing consumer collected service
CN1378664A (en) * 1999-09-15 2002-11-06 爱德华·A·德夫林 Method and system for redeem product marketing rebates
CN1461444A (en) * 1999-07-20 2003-12-10 英门迪亚公司 System and method for organizing data
CN1828527A (en) * 2005-02-28 2006-09-06 微软公司 Platform for data services across disparate application frameworks
CN1967485A (en) * 2006-06-20 2007-05-23 华为技术有限公司 Method and system for realizing J2EE application
CN101147146A (en) * 2005-03-31 2008-03-19 瑞士银行股份有限公司 Computer network system for constructing, synchronizing and/or managing a second database from/with a first database, and methods therefore
CN101615283A (en) * 2008-06-26 2009-12-30 吉市有限公司 Sell the method for bulk discounts product and the media that the program of this method carried out in record

Patent Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6457006B1 (en) * 1999-07-20 2002-09-24 Primentia, Inc. System and method for organizing data
CN1461444A (en) * 1999-07-20 2003-12-10 英门迪亚公司 System and method for organizing data
CN1378664A (en) * 1999-09-15 2002-11-06 爱德华·A·德夫林 Method and system for redeem product marketing rebates
CN1372217A (en) * 2001-02-08 2002-10-02 国际商业机器公司 System and method for providing consumer collected service
CN1828527A (en) * 2005-02-28 2006-09-06 微软公司 Platform for data services across disparate application frameworks
CN101147146A (en) * 2005-03-31 2008-03-19 瑞士银行股份有限公司 Computer network system for constructing, synchronizing and/or managing a second database from/with a first database, and methods therefore
CN1967485A (en) * 2006-06-20 2007-05-23 华为技术有限公司 Method and system for realizing J2EE application
CN101615283A (en) * 2008-06-26 2009-12-30 吉市有限公司 Sell the method for bulk discounts product and the media that the program of this method carried out in record

Cited By (18)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104794138B (en) * 2014-01-22 2018-08-24 深圳市沃信科技有限公司 A kind of database transaction result confirmation method, apparatus and system
CN104794138A (en) * 2014-01-22 2015-07-22 深圳市沃信科技有限公司 Method, device and system for determining database transaction result
CN104391698A (en) * 2014-11-06 2015-03-04 中国建设银行股份有限公司 Event project generation and price calculation methods and devices
CN105303417A (en) * 2015-12-07 2016-02-03 北京京东尚科信息技术有限公司 Goods automatic ordering system and method
CN106096992A (en) * 2016-05-27 2016-11-09 乐视控股(北京)有限公司 The changing method of commodity price and system
CN106250243A (en) * 2016-08-11 2016-12-21 中国银行股份有限公司 The processing method and processing device of banking system based on poll tupe application
CN107730288A (en) * 2016-08-11 2018-02-23 凡学(上海)教育科技有限公司 A kind of electric business promotion wholesale price management platform and management method
CN106250243B (en) * 2016-08-11 2019-06-25 中国银行股份有限公司 The processing method and processing device of banking system application based on poll tupe
CN107977848A (en) * 2016-10-21 2018-05-01 浙江银泰电子商务有限公司 promotion rule generation method and promotion rule generation system
CN107767209A (en) * 2017-09-21 2018-03-06 武汉蜕变人工智能科技有限公司 A kind of automatic price quoting method and system
CN108133346A (en) * 2017-12-28 2018-06-08 创新无限信息技术(武汉)股份有限公司 The method and system that the setting of bom inventories uploading system is sold by group
CN108228790A (en) * 2017-12-29 2018-06-29 北京奇虎科技有限公司 Push the methods of exhibiting and device of picture
CN108228790B (en) * 2017-12-29 2021-09-28 北京奇虎科技有限公司 Display method and device of pushed pictures
CN109032690A (en) * 2018-06-20 2018-12-18 南京万米信息技术有限公司 A kind of method and apparatus of dynamic processing marketing data
CN109118269A (en) * 2018-07-12 2019-01-01 北京金山云网络技术有限公司 Configuration method, device, electronic equipment and the storage medium of commercial activities rule
CN109656987A (en) * 2018-10-12 2019-04-19 深圳壹账通智能科技有限公司 Data integration method, device, equipment and storage medium
CN110390595A (en) * 2019-07-30 2019-10-29 腾讯科技(深圳)有限公司 A kind of information processing system, method, server and storage medium
CN110390595B (en) * 2019-07-30 2024-03-29 腾讯科技(深圳)有限公司 Information processing system, method, server and storage medium

Also Published As

Publication number Publication date
CN102841906B (en) 2016-12-07

Similar Documents

Publication Publication Date Title
CN102841906A (en) Integrated transaction processing system and transaction processing method
JP7105700B2 (en) Time-division recommendation method and apparatus for service target
US10460286B2 (en) Inventory management system and method thereof
KR101049889B1 (en) Web site operation method and online system to receive and target advertisements for keyword groups based on behavioral analysis through search
JP5818980B2 (en) Supplementary product recommendations based on pay-for-performance information
US20100280879A1 (en) Gift incentive engine
US20120059706A1 (en) Methods and Apparatus for Transforming User Data and Generating User Lists
Kaur et al. E-commerce in india: A review
US20100280913A1 (en) Gift credit matching engine
US20140297377A1 (en) Systems And Methods For Dynamically Generating Digital Advertisements
US10754889B2 (en) Computer system and method for dynamically generating an image from digital content items
CN103577999A (en) Online shopping mall system
CN108600323B (en) Multi-center data sharing system and using method thereof
JP5925113B2 (en) Advertisement providing system and advertisement providing method for providing integrated electronic commerce market
US8738445B2 (en) Computerized systems and methods for anonymous collaborative auctions
CN108733685B (en) Object interaction, browsing, searching and configuration method and device
WO2019047630A1 (en) Marketing system, advertising gift recommendation method and sales sharing system
JP2018521435A (en) System and method for accurate marketing by sharing data, gifts and logistics
US9715708B2 (en) Computerized systems and methods for anonymous collaborative auctions
TW201537489A (en) The system and method of personal webpage combined with bonus marketing
KATOLE A study of problems & prospects of internet retailing in India
US20140067464A1 (en) Facilitating introductions between buyers and automobile dealers
KR20100030782A (en) Apparatus and method for an electronic commerce using entertainer brand
KR20140015734A (en) Fashion web-collection social network service system based on internet shopping mall service
JP7339686B2 (en) Gift smart matching method, system and recording medium based on space station

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
REG Reference to a national code

Ref country code: HK

Ref legal event code: DE

Ref document number: 1175275

Country of ref document: HK

C14 Grant of patent or utility model
GR01 Patent grant
REG Reference to a national code

Ref country code: HK

Ref legal event code: GR

Ref document number: 1175275

Country of ref document: HK