CN107657458A - List acquisition methods and device - Google Patents
List acquisition methods and device Download PDFInfo
- Publication number
- CN107657458A CN107657458A CN201610711579.1A CN201610711579A CN107657458A CN 107657458 A CN107657458 A CN 107657458A CN 201610711579 A CN201610711579 A CN 201610711579A CN 107657458 A CN107657458 A CN 107657458A
- Authority
- CN
- China
- Prior art keywords
- list
- database
- memory database
- request
- place
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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
- G06Q30/00—Commerce
- G06Q30/01—Customer relationship services
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
Abstract
The invention discloses a kind of list acquisition methods, this method includes：Receive the service request that operator attendance is sent, the service request includes the type of service of request, and determine whether the service request is that list obtains request according to the type of service, and in the case where the service request is list acquisition request, target list will be read from memory database and feed back to operator attendance, wherein, memory database is used for the list for storing pending client.The invention also discloses the device that a kind of list obtains, because memory database has the advantages of processing speed is fast, make it possible to quickly read target list from memory database and feed back to operator attendance, in the case of a large amount of operator attendances simultaneously acquisition request list, also the probability that different operator attendances gets identical list can be effectively reduced, the probability to cause confusion is obtained to reduce list.
Description
Technical field
The present invention relates to communication technical field, more particularly to a kind of list acquisition methods and device.
Background technology
Dangerous industry is being produced, in order to develop potential customers, it will usually collect the list of potential customers, and the list is distributed to
Telemarketing system, telephonic communication is carried out by the seat personnel in telemarketing system and client, to realize the popularization of business.
At present, in telemarketing system, management server is after the list of client for sale is obtained, by these names
Singly it is stored in the oracle database of management server, operator attendance, can be to pipe after the processing of a list is completed
The list that reason server please look for novelty, management server upon receipt of the request, will read one from oracle database
New list, and feed back to corresponding operator attendance.
However, because in telemarketing system, the quantity of operator attendance is general all larger, for example, operator attendance at present
Scale all more than 1,000, under this scale, often there is that a large amount of operator attendances are concurrent to be obtained to management server
New list, however, the processing speed due to oracle database in itself is slower, if management server receives a large amount of people's work areas
The concurrent request of seat, then the situation that different operator attendances gets identical list is will appear from, cause list to obtain chaotic, give people
The work of work area seat has undesirable effect.
The above is only used for auxiliary and understands technical scheme, does not represent and recognizes that the above is existing skill
Art.
The content of the invention
In view of this, the present invention provides a kind of list acquisition methods and device, it is intended to which solution is based in the prior art
When oracle database realizes that list obtains, different operator attendances easily get identical list, and list, which obtains, easily to be occurred
The problem of chaotic.
To achieve the above object, a kind of list acquisition methods provided by the invention, methods described include：
The service request that operator attendance is sent is received, the service request includes the type of service of request；
Determine whether the service request is that list obtains request according to the type of service；
If it is determined that the service request, which is list, obtains request, then target list is read from memory database and is fed back to
The operator attendance, the memory database are used for the list for storing pending client.
Preferably, methods described also includes：
If it is determined that the service request, which is not list, obtains request, then the service request is entered based on oracle database
Row processing, and to the operator attendance feedback processing result, the memory database in the oracle database with preserving phase
The list of same pending client.
Preferably, it is described that the service request is handled based on oracle database and anti-to the operator attendance
Also include after the step of presenting result：
After the result is fed back into the operator attendance, the name that will be changed in the oracle database
Single situation of change is preserved into the single-row table of first place, and the single-row table of first place is used to preserve name in the oracle database
Single situation of change；
Memory database described in the first place list list update is based at interval of the first preset duration, and is emptied described
The single-row table of first place, it is synchronous between the oracle database and memory database to realize.
Preferably, after described the step of target list is read from memory database and feeds back to the operator attendance also
Including：
Deletion and the destination name list identical list from the oracle database, to realize the oracle data
It is synchronous between storehouse and the memory database.
Preferably, after described the step of target list is read from memory database and feeds back to the operator attendance also
Including：
The target list of reading is preserved into the single-row table of second place, the single-row table of second place is used to preserve from institute
State the list read in memory database；
Delete what is included with the single-row table of the second place from the oracle database at interval of the second preset duration
List identical list, and the single-row table of the second place is emptied, to realize the oracle database and the memory database
Between synchronization.
To achieve the above object, invention additionally discloses a kind of list acquisition device, described device to include：
Receiving module, for receiving the service request of operator attendance transmission, the service request includes the service class of request
Type；
Determining module, for determining whether the service request is that list obtains request according to the type of service；
Read feedback module, for if it is determined that the service request be list obtain request, then read from memory database
Take target list and feed back to the operator attendance, the memory database is used for the list for storing pending client.
Preferably, described device also includes：
Feedback module is handled, for if it is determined that the service request, which is not list, obtains request, then based on oracle data
Storehouse is handled the service request, and to the operator attendance feedback processing result, the memory database with it is described
The list of the pending client of identical is preserved in oracle database.
Preferably, described device also includes：
First preserving module, for after the result is fed back into the operator attendance, by the oracle numbers
Preserved according to the situation of change of the list to be changed in storehouse into the single-row table of first place, the single-row table of first place is used to preserve institute
State the situation of change of list in oracle database；
Renewal empties module, for being based on internal memory described in the first place list list update at interval of the first preset duration
Database, and the single-row table of the first place is emptied, it is synchronous between the oracle database and memory database to realize.
Preferably, described device also includes：
Removing module, for the deletion from the oracle database and the destination name list identical list, to realize
It is synchronous between the oracle database and the memory database.
Preferably, described device also includes：
Second preserving module, for after the target list is fed back into the operator attendance, by described in reading
Target list is preserved into the single-row table of second place, and the single-row table of second place is used to preserve what is read from the memory database
List；
Deletion empties module, for being deleted at interval of the second preset duration from the oracle database and described the
The list identical list that two list lists include, and the single-row table of the second place is emptied, to realize the oracle database
It is synchronous between the memory database.
The present invention provides a kind of list acquisition methods, and this method includes：Receive the service request that operator attendance is sent, the industry
Business type of service of the request bag containing request, and determine whether the service request is that list obtains request according to the type of service, and
It is in the case that list obtains request, target list will to be read from memory database and feed back to people's work area in the service request
Seat, wherein, memory database is used for the list for storing pending client.Because memory database has fast excellent of processing speed
Point, enabling target list is quickly read from memory database and feeds back to operator attendance, even in a large amount of operator attendances
Simultaneously in the case of acquisition request list, the probability that different operator attendances gets identical list also can be effectively reduced, with
Reduce list and obtain the probability to cause confusion.
Brief description of the drawings
Fig. 1 is the schematic flow sheet of list acquisition methods in first embodiment of the invention；
Fig. 2 is the schematic flow sheet of list acquisition methods in second embodiment of the invention；
Fig. 3 is the schematic flow sheet of the addition step of second embodiment shown in Fig. 2 of the present invention；
Fig. 4 is the schematic flow sheet of list acquisition methods in third embodiment of the invention；
Fig. 5 is the schematic flow sheet of list acquisition methods in fourth embodiment of the invention；
Fig. 6 is the schematic diagram of the functional module of list acquisition device in fifth embodiment of the invention；
Fig. 7 is the schematic diagram of the functional module of list acquisition device in sixth embodiment of the invention；
Fig. 8 is the schematic diagram of the functional module of list acquisition device in seventh embodiment of the invention.
The realization, functional characteristics and advantage of the object of the invention will be described further referring to the drawings in conjunction with the embodiments.
Embodiment
It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, it is not intended to limit the present invention.
Because in the prior art, when realizing that list obtains based on oracle database, different operator attendances are easily got
Identical list, list are obtained and easily caused confusion.
In order to solve the above problems, the present invention proposes a kind of list acquisition methods, in the method, the name of pending client
Singly it is stored in memory database, because memory database has the advantages of processing speed is fast so that obtained receiving list
After request, target list can be quickly read from memory database and feeds back to operator attendance, even in a large amount of people's work areas
Seat in the case of acquisition request list, also can effectively reduce the probability that different operator attendances gets identical list simultaneously,
The probability to cause confusion is obtained to reduce list.
Referring to Fig. 1, be the schematic flow sheet of list acquisition methods in first embodiment of the invention, the list acquisition methods
Including：
Step 101, the service request that operator attendance is sent is received, the service request includes the type of service of request；
Step 102, determine according to the type of service whether the service request is that list obtains request；It is if it is determined that described
Service request is that list obtains request, then performs step 103；
Step 103, read target list from memory database and feed back to the operator attendance, the memory database
For storing the list of pending client.
In embodiments of the present invention, service server and operator attendance are included in telemarketing system, wherein, business service
Device is used to manage operator attendance, and the operator attendance can carry out telephonic communication between client, to develop potential customers.
Wherein, service server is after the list of potential customers is got, using the list of the potential customers as waiting to locate
The list of reason client is stored in memory database, and the memory database is the database of service server.Telemarketing system
In operator attendance when needing to handle new list, new list can be obtained from service server, and according in the list
Telephone number dialing customer phone, with realize to potential customers business promote.
Wherein, memory database is exactly that data are placed on to the database directly operated in internal memory as its name suggests, relative to magnetic
Disk, the reading and writing data speed of internal memory will be several orders of magnitude higher, and saving the data in internal memory can compared to the access from disk
It is greatly enhanced the performance of application.And the processing speed of data by memory database is significantly faster than oracle database.Wherein, it is interior
Deposit data storehouse is preferably TimesTen databases.
In embodiments of the present invention, above-mentioned list acquisition methods are applied to list acquisition device (referred to as：Acquisition device),
And the acquisition device is the part in the service server in telemarketing system.
In embodiments of the present invention, acquisition device receives the service request that operator attendance is sent, and the service request includes please
The type of service asked, wherein, operator attendance can ask multiple business to service server, and each service request all will be by
The acquisition device of service server receives.
Wherein, type of service can be that list obtains business, list inquiry business, list statistical service, list analysis industry
Business, list rearrangement business etc..
In embodiments of the present invention, acquisition device, will be according to this after the service request of operator attendance transmission is received
The type of service included in service request determines whether the service request is that list obtains request, wherein, if in the service request
Comprising type of service obtain business for list, then can determine that the service request obtains request for list, and it is determined that the industry
In the case that business request obtains request for list, acquisition device will read target list from memory database and feed back to artificial
Attend a banquet.
Wherein, target list can be determined based on the rule pre-set, if for example, the rule pre-set is
It is random to obtain, then can one list of random read take is as target list from memory database, if the rule that pre-sets
Sequentially to obtain, then can from memory database according to list put in order read foremost a list as target
List, in actual applications, it can need to set the rule for determining target list according to specific, not limit herein.
In embodiments of the present invention, acquisition device receives the service request that operator attendance is sent, and the service request includes please
The type of service asked, and determine whether the service request is that list obtains request according to the type of service, and in the service request
In the case of obtaining request for list, target list will be read from memory database and feed back to operator attendance, wherein, internal memory
Database is used for the list for storing pending client.Because memory database has the advantages of processing speed is fast, enabling from
Target list is quickly read in memory database and feeds back to operator attendance, even in a large amount of operator attendances while acquisition request name
In the case of list, the probability that different operator attendances gets identical list also can be effectively reduced, is obtained out with reducing list
Existing chaotic probability.
Referring to Fig. 2, be the schematic flow sheet of list acquisition methods in second embodiment of the invention, the list acquisition methods
Including：
Step 201, the service request that operator attendance is sent is received, the service request includes the type of service of request；
Step 202, determine according to the type of service whether the service request is that list obtains request；It is if it is determined that described
Service request is that list obtains request, then performs step 203；If it is determined that the service request, which is not list, obtains request, then hold
Row step 204；
Step 203, read target list from memory database and feed back to the operator attendance, the memory database
For storing the list of pending client；
Step 204, based on oracle database the service request is handled, and at the operator attendance feedback
Manage result, the memory database and the list that the pending client of identical is preserved in the oracle database.
It should be noted that step 201 in second embodiment shown in Fig. 2 of the present invention to step 203 respectively with shown in Fig. 1
The content that step 101 describes to step 103 in first embodiment is similar, does not repeat herein.
It is understood that relative to first embodiment shown in Fig. 1, the distinctive points of second embodiment shown in Fig. 2 are in detail
Thin describe in service request is not the processing mode in the case that list obtains request.
In embodiments of the present invention, in service server in addition to memory database, oracle database is also set up, and
Memory database is used for the acquisition for realizing list, and oracle database is used to realize other work(in addition to the acquisition of list
Energy.
Oracle database and memory database is set mainly to consider：In the prior art, oracle is used alone
Do not only existed during database different people work area seat get identical list probability it is higher, list is obtained and easily caused confusion
Problem, it there is also due to different operator attendances while obtaining identical list cause the resource of oracle database occupied,
Cause the functional disabled problem of institute of service server.In order to solve previous problem, the first reality shown in Fig. 1 may be referred to
Example is applied, memory database is used in service server, because the processing speed of memory database is very fast, even in a large amount of artificial
Attend a banquet the situation of concurrent request list, business can be handled quickly, and reduced different operator attendances and obtained identical list simultaneously
Probability, also reduce list and obtain the problem of causing confusion.However, due to consideration that internal storage data is laid out in service server
The cost in storehouse is higher, substitutes oracle database completely using memory database at present and reality, and internal memory is used only
Latter problem may also occurs in database, and the probability only to go wrong is smaller.In this case, it is possible to as schemed
Embodiment shown in 2, memory database and oracle database are laid out simultaneously in service server, on the one hand can reduce industry
The improvement cost of business server, even if (different operator attendances obtain identical name simultaneously the problem of another aspect above-mentioned small probability
Single probability) when occurring, service server is only that the function that list obtains can not use, and other function service servers can be with
Realized based on oracle database, have no effect on the use of other functions.
In embodiments of the present invention, will if the service request that acquisition device determines to receive, which is not list, obtains request
The service request is handled based on oracle database, and to operator attendance feedback processing result, if for example, the business please
Ask and asked for service inquiry, then the information of the list of correlation can be inquired about from oracle database, and feed back to operator attendance,
In another example if the service request is asked for business modification, the information of corresponding list can be changed in oracle database,
And after modification is completed, successfully modified response is fed back to operator attendance.
In embodiments of the present invention, by setting the memory database with processing speed the advantages of fast, enabling from
Target list is quickly read in memory database and feeds back to operator attendance, even in a large amount of operator attendances while acquisition request name
In the case of list, the probability that different operator attendances gets identical list also can be effectively reduced, is obtained out with reducing list
Existing chaotic probability.In addition, by being laid out memory database and oracle database simultaneously, can effectively reduce to enter system
Row transformation and the cost built, and even if there is the small probability event that different operator attendances get identical list, can also lead to
Other functions of oracle database realization in addition to list obtains are crossed, have no effect on the use of other functions.
Based on second embodiment shown in Fig. 2, referring to Fig. 3, the addition step for second embodiment shown in Fig. 2 of the present invention
Schematic flow sheet, after the step 204 in having performed second embodiment shown in Fig. 2, also following steps will be executed for acquisition device：
Step 301, after the result is fed back into the operator attendance, will occur in the oracle database
The situation of change of the list of change is preserved into the single-row table of first place, and the single-row table of first place is used to preserve the oracle numbers
According to the situation of change of list in storehouse；
Step 302, at interval of the first preset duration memory database described in the first place list list update is based on, and
The single-row table of the first place is emptied, it is synchronous between the oracle database and memory database to realize.
In embodiments of the present invention, acquisition device, will after the service request for receiving non-list acquisition request has been handled
The situation of change of the list to be changed in oracle database is preserved into the single-row table of first place, and the single-row table of the first place is used for
Preserve the situation of change of list in oracle database.
Wherein, the situation of change of list can be that list is deleted, list is changed etc., if list is deleted, then
Preserve the deleted list in the single-row table of first place, and labeled as being deleted, if list is changed, then this first
The data before the list modification that this is changed and amended data are preserved in list list.
In embodiments of the present invention, in order to realize that oracle database is synchronous with memory database, to ensure the two
Data in database are identical, and acquisition device will be based on the first place list list update internal memory number at interval of the first preset duration
According to storehouse, for example, for having the list of deleted mark in the single-row table of first place, then this is found from memory database
List, and deleting, in another example, then can be with for the list before the modification that is preserved in the single-row table of first place and amended list
Determine that list is changed, then the list before the modification is found in memory database, and search using amended name single pair
To list modify, with realize be based on first place list list update memory database, realize memory database and oracle
Synchronization between database.And after the update is complete, acquisition device will empty the single-row table of the first place.
Wherein, the first preset duration can be 5s, 10s, 30s, 60s etc., in actual applications, can be according to specific
Need set, do not limit herein.
In embodiments of the present invention, it is not that list obtains the processing of request and completion to the service request in service request
In the case of, acquisition device preserves the situation of change for the list that change is sent in oracle database into the single-row table of first place,
And the first place list list update memory database is based at interval of the first preset duration, and the single-row table of the first place is emptied,
It is synchronous between oracle database and memory database to realize.
It is that list obtains request in service request, and target list is being fed back into people based on first embodiment shown in Fig. 1
In the case of work area seat, in order to realize that memory database is synchronous with oracle database, referring to Fig. 4, being the present invention the 3rd
The schematic flow sheet of list acquisition methods in embodiment, in the method, acquisition device is in first embodiment shown in Fig. 1 is performed
Step 101 to step 103 after, also following steps will be executed：
Step 401, deletion and the destination name list identical list from the oracle database, with described in realization
It is synchronous between oracle database and the memory database.
In embodiments of the present invention, acquisition device will be deleted from oracle database with destination name list identical list,
It is synchronous between oracle database and memory database to realize.
Or
Referring to Fig. 5, being the schematic flow sheet of list acquisition methods in fourth embodiment of the invention, in the method, obtain
Taking device, also following steps will be executed after step 101 to the step 103 in performing first embodiment shown in Fig. 1：
Step 501, the target list of reading preserved into the single-row table of second place, the single-row table of second place is used for
Preserve the list read from the memory database；
Step 502, delete from the oracle database at interval of the second preset duration it is single-row with the second place
The list identical list that table includes, and empty the single-row table of the second place, with realize the oracle database with it is described interior
Synchronization between deposit data storehouse.
In embodiments of the present invention, after acquisition device gives destination name single-shot to operator attendance, by the target of reading
List is preserved into the single-row table of second place, and the single-row table of the second place is used to preserve the list read from memory database, and often
It is spaced the second preset duration and the list identical list included with the single-row table of the second place is deleted from oracle database, and
The single-row table of the second place is emptied, it is synchronous between oracle database and memory database to realize.
Referring to Fig. 6, being the schematic diagram of the functional module of list acquisition device in fifth embodiment of the invention, the list obtains
Device is taken to include：Receiving module 601, determining module 602 and reading feedback module 603.
Receiving module 601, for receiving the service request of operator attendance transmission, the service request includes the business of request
Type；
Determining module 602, for determining whether the service request is that list obtains request according to the type of service；
Feedback module 603 is read, for if it is determined that the service request, which is list, obtains request, then from memory database
Read target list and feed back to the operator attendance, the memory database is used for the list for storing pending client.
In embodiments of the present invention, service server and operator attendance are included in telemarketing system, wherein, business service
Device is used to manage operator attendance, and the operator attendance can carry out telephonic communication between client, to develop potential customers.
Wherein, service server is after the list of potential customers is got, using the list of the potential customers as waiting to locate
The list of reason client is stored in memory database, and the memory database is the database of service server.Telemarketing system
In operator attendance when needing to handle new list, new list can be obtained from service server, and according in the list
Telephone number dialing customer phone, with realize to potential customers business promote.
Wherein, memory database is exactly that data are placed on to the database directly operated in internal memory as its name suggests, relative to magnetic
Disk, the reading and writing data speed of internal memory will be several orders of magnitude higher, and saving the data in internal memory can compared to the access from disk
It is greatly enhanced the performance of application.And the processing speed of data by memory database is significantly faster than oracle database.Wherein, it is interior
Deposit data storehouse is preferably TimesTen databases.
In embodiments of the present invention, above-mentioned list acquisition device (is referred to as：Acquisition device) it is in telemarketing system
A part in service server.
In embodiments of the present invention, the receiving module 601 in acquisition device receives the service request that operator attendance is sent, should
Service request includes the type of service of request, wherein, operator attendance can ask multiple business, and each to service server
Service request will all be received by the acquisition device of service server.
Wherein, type of service can be that list obtains business, list inquiry business, list statistical service, list analysis industry
Business, list rearrangement business etc..
In embodiments of the present invention, after the service request of operator attendance transmission is received, determining module 602 is by basis
The type of service included in the service request determines whether the service request is that list obtains request, wherein, if the service request
In the type of service that includes obtain business for list, then can determine that the service request obtains request for list, and it is determined that should
Service request is in the case that list obtains request, and target list will be read simultaneously from memory database by reading feedback module 603
Feed back to operator attendance.
Wherein, target list can be determined based on the rule pre-set, if for example, the rule pre-set is
It is random to obtain, then can one list of random read take is as target list from memory database, if the rule that pre-sets
Sequentially to obtain, then can from memory database according to list put in order read foremost a list as target
List, in actual applications, it can need to set the rule for determining target list according to specific, not limit herein.
In embodiments of the present invention, acquisition device receives the service request that operator attendance is sent, and the service request includes please
The type of service asked, and determine whether the service request is that list obtains request according to the type of service, and in the service request
In the case of obtaining request for list, target list will be read from memory database and feed back to operator attendance, wherein, internal memory
Database is used for the list for storing pending client.Because memory database has the advantages of processing speed is fast, enabling from
Target list is quickly read in memory database and feeds back to operator attendance, even in a large amount of operator attendances while acquisition request name
In the case of list, the probability that different operator attendances gets identical list also can be effectively reduced, is obtained out with reducing list
Existing chaotic probability.
Referring to Fig. 7, be the schematic diagram of the functional module of list acquisition device in sixth embodiment of the invention, the device bag
Include receiving module 601 in the 5th embodiment as shown in Figure 6, determining module 602 and read feedback module 603, and with shown in Fig. 6
Content described in embodiment is similar, does not repeat herein.
In embodiments of the present invention, the acquisition device also includes：
Feedback module 701 is handled, for if it is determined that the service request, which is not list, obtains request, then based on oracle numbers
The service request is handled according to storehouse, and to the operator attendance feedback processing result, the memory database with it is described
The list of the pending client of identical is preserved in oracle database.
In embodiments of the present invention, in service server in addition to memory database, oracle database is also set up, and
Memory database is used for the acquisition for realizing list, and oracle database is used to realize other work(in addition to the acquisition of list
Energy.
Oracle database and memory database is set mainly to consider：In the prior art, oracle is used alone
Do not only existed during database different people work area seat get identical list probability it is higher, list is obtained and easily caused confusion
Problem, it there is also due to different operator attendances while obtaining identical list cause the resource of oracle database occupied,
Cause the functional disabled problem of institute of service server.In order to solve previous problem, the first reality shown in Fig. 6 may be referred to
Example is applied, memory database is used in service server, because the processing speed of memory database is very fast, even in a large amount of artificial
Attend a banquet the situation of concurrent request list, business can be handled quickly, and reduced different operator attendances and obtained identical list simultaneously
Probability, also reduce list and obtain the problem of causing confusion.However, due to consideration that internal storage data is laid out in service server
The cost in storehouse is higher, substitutes oracle database completely using memory database at present and reality, and internal memory is used only
Latter problem may also occurs in database, and the probability only to go wrong is smaller.In this case, it is possible to as schemed
Embodiment shown in 7, memory database and oracle database are laid out simultaneously in service server, on the one hand can reduce industry
The improvement cost of business server, even if (different operator attendances obtain identical name simultaneously the problem of another aspect above-mentioned small probability
Single probability) when occurring, service server is only that the function that list obtains can not use, and other function service servers can be with
Realized based on oracle database, have no effect on the use of other functions.
In embodiments of the present invention, if the service request that acquisition device determines to receive, which is not list, obtains request, locate
Reason feedback module 701 will be handled the service request based on oracle database, and to operator attendance feedback processing result,
If for example, the service request is asked for service inquiry, the information of the list of correlation can be inquired about from oracle database, and
Operator attendance is fed back to, in another example, if the service request is asked for business modification, phase can be changed in oracle database
The information for the list answered, and after modification is completed, successfully modified response is fed back to operator attendance.
In embodiments of the present invention, by setting the memory database with processing speed the advantages of fast, enabling from
Target list is quickly read in memory database and feeds back to operator attendance, even in a large amount of operator attendances while acquisition request name
In the case of list, the probability that different operator attendances gets identical list also can be effectively reduced, is obtained out with reducing list
Existing chaotic probability.In addition, by being laid out memory database and oracle database simultaneously, can effectively reduce to enter system
Row transformation and the cost built, and even if there is the small probability event that different operator attendances get identical list, can also lead to
Other functions of oracle database realization in addition to list obtains are crossed, have no effect on the use of other functions.
Further, the acquisition device also includes：
First preserving module 702, for after the result is fed back into the operator attendance, by the oracle
The situation of change of the list to be changed in database is preserved into the single-row table of first place, and the single-row table of first place is used to preserve
The situation of change of list in the oracle database；
Renewal empties module 703, for being based at interval of the first preset duration described in the first place list list update
Memory database, and the single-row table of the first place is emptied, it is same between the oracle database and memory database to realize
Step.
In embodiments of the present invention, after the service request for receiving non-list acquisition request has been handled, first preserves mould
Block 702 preserves the situation of change of the list to be changed in oracle database into the single-row table of first place, first list
List is used for the situation of change for preserving list in oracle database.
Wherein, the situation of change of list can be that list is deleted, list is changed etc., if list is deleted, then
Preserve the deleted list in the single-row table of first place, and labeled as being deleted, if list is changed, then this first
The data before the list modification that this is changed and amended data are preserved in list list.
In embodiments of the present invention, in order to realize that oracle database is synchronous with memory database, to ensure the two
Data in database are identical, and renewal, which empties module 703, to be based on the single-row table of the first place more at interval of the first preset duration
New memory database, for example, for having the list of deleted mark in the single-row table of first place, then from memory database
The list is found, and is deleted, in another example, for the list before the modification that is preserved in the single-row table of first place and amended name
It is single, then it can determine that list is changed, then the list before the modification be found in memory database, and utilize amended name
The list that single pair is found is modified, and is based on first place list list update memory database to realize, is realized memory database
It is synchronous between oracle database.And after the update is complete, acquisition device will empty the single-row table of the first place.
Wherein, the first preset duration can be 5s, 10s, 30s, 60s etc., in actual applications, can be according to specific
Need set, do not limit herein.
In embodiments of the present invention, it is not that list obtains the processing of request and completion to the service request in service request
In the case of, acquisition device preserves the situation of change for the list that change is sent in oracle database into the single-row table of first place,
And the first place list list update memory database is based at interval of the first preset duration, and the single-row table of the first place is emptied,
It is synchronous between oracle database and memory database to realize.
Referring to Fig. 8, being the schematic diagram of the functional module of list acquisition device in seventh embodiment of the invention, the acquisition fills
Put including the receiving module 601 in the 5th embodiment as shown in Figure 6, determining module 602 and read feedback module 603, and and Fig. 6
Content described in shown 5th embodiment is similar, does not repeat herein.
The acquisition device also includes：
Removing module 801, for the deletion from the oracle database and the destination name list identical list, with reality
It is existing synchronous between the oracle database and the memory database.
And/or；
Second preserving module 802, for after the target list is fed back into the operator attendance, by the institute of reading
State target list to preserve into the single-row table of second place, the single-row table of second place is used to preserve to be read from the memory database
List；
Deletion empties module 803, for being deleted at interval of the second preset duration from the oracle database and institute
The list identical list that the single-row table of second place includes is stated, and empties the single-row table of the second place, to realize the oracle numbers
According to synchronous between storehouse and the memory database.
In embodiments of the present invention, removing module 801 will be deleted and destination name list identical name from oracle database
It is single, it is synchronous between oracle database and memory database to realize.
Or in embodiments of the present invention, will after the second preserving module 802 gives destination name single-shot to operator attendance
The target list read is preserved into the single-row table of second place, and the single-row table of the second place is used to preserve to be read from memory database
List, and by deletion empty module 803 at interval of the second preset duration deleted from oracle database with the second place
The list identical list that single-row table includes, and the single-row table of the second place is emptied, to realize oracle database and internal storage data
Synchronization between storehouse.
Through the above description of the embodiments, those skilled in the art can be understood that above-described embodiment side
Method can add the mode of required general hardware platform to realize by software, naturally it is also possible to by hardware, but in many cases
The former is more preferably embodiment.Based on such understanding, technical scheme is substantially done to prior art in other words
Going out the part of contribution can be embodied in the form of software product, and the computer software product is stored in a storage medium
In (such as ROM/RAM, magnetic disc, CD), including some instructions to cause a station terminal equipment (can be mobile phone, computer, clothes
Be engaged in device, air conditioner, or network equipment etc.) method that performs each embodiment of the present invention.
The preferred embodiments of the present invention are these are only, are not intended to limit the scope of the invention, it is every to utilize this hair
The equivalent structure or equivalent flow conversion that bright specification and accompanying drawing content are made, or directly or indirectly it is used in other related skills
Art field, is included within the scope of the present invention.
Claims (10)
1. a kind of list acquisition methods, it is characterised in that methods described includes：
The service request that operator attendance is sent is received, the service request includes the type of service of request；
Determine whether the service request is that list obtains request according to the type of service；
If it is determined that the service request, which is list, obtains request, then target list is read from memory database and is fed back to described
Operator attendance, the memory database are used for the list for storing pending client.
2. according to the method for claim 1, it is characterised in that methods described also includes：
If it is determined that the service request be not list obtain request, then based on oracle database to the service request at
Reason, and to the operator attendance feedback processing result, the memory database in the oracle database with preserving identical
The list of pending client.
3. according to the method for claim 2, it is characterised in that described that the service request is entered based on oracle database
Row processing, and also include to after the step of the operator attendance feedback processing result：
After the result is fed back into the operator attendance, by the list to be changed in the oracle database
Situation of change is preserved into the single-row table of first place, and the single-row table of first place is used to preserve list in the oracle database
Situation of change；
Memory database described in the first place list list update is based at interval of the first preset duration, and empties described first
List list, it is synchronous between the oracle database and memory database to realize.
4. according to the method described in claims 1 to 3 any one, it is characterised in that described that mesh is read from memory database
Entitling list and the step of feed back to the operator attendance after also include：
From the oracle database delete with the destination name list identical list, with realize the oracle database with
Synchronization between the memory database.
5. according to the method described in claims 1 to 3 any one, it is characterised in that described that mesh is read from memory database
Entitling list and the step of feed back to the operator attendance after also include：
The target list of reading is preserved into the single-row table of second place, the single-row table of second place is used to preserve from described interior
The list read in deposit data storehouse；
The list included with the single-row table of the second place is deleted from the oracle database at interval of the second preset duration
Identical list, and the single-row table of the second place is emptied, to realize between the oracle database and the memory database
Synchronization.
6. a kind of list acquisition device, it is characterised in that described device includes：
Receiving module, for receiving the service request of operator attendance transmission, the service request includes the type of service of request；
Determining module, for determining whether the service request is that list obtains request according to the type of service；
Read feedback module, for if it is determined that the service request be list obtain request, then mesh is read from memory database
Entitling list simultaneously feeds back to the operator attendance, and the memory database is used for the list for storing pending client.
7. device according to claim 6, it is characterised in that described device also includes：
Feedback module is handled, for if it is determined that the service request, which is not list, obtains request, then based on oracle database pair
The service request is handled, and to the operator attendance feedback processing result, the memory database and the oracle
The list of the pending client of identical is preserved in database.
8. device according to claim 7, it is characterised in that described device also includes：
First preserving module, for after the result is fed back into the operator attendance, by the oracle database
In the situation of change of list that changes preserve into the single-row table of first place, the single-row table of first place is used to preserving described
The situation of change of list in oracle database；
Renewal empties module, for being based on internal storage data described in the first place list list update at interval of the first preset duration
Storehouse, and the single-row table of the first place is emptied, it is synchronous between the oracle database and memory database to realize.
9. according to the device described in claim 6 to 8 any one, it is characterised in that described device also includes：
Removing module, for the deletion from the oracle database and the destination name list identical list, with described in realization
It is synchronous between oracle database and the memory database.
10. according to the device described in claim 6 to 8 any one, it is characterised in that described device also includes：
Second preserving module, for after the target list is fed back into the operator attendance, by the target of reading
List is preserved into the single-row table of second place, and the single-row table of second place is used to preserve the name read from the memory database
It is single；
Deletion empties module, for being deleted at interval of the second preset duration from the oracle database and the second place
The list identical list that single-row table includes, and the single-row table of the second place is emptied, to realize the oracle database and institute
State the synchronization between memory database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610711579.1A CN107657458A (en) | 2016-08-23 | 2016-08-23 | List acquisition methods and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610711579.1A CN107657458A (en) | 2016-08-23 | 2016-08-23 | List acquisition methods and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107657458A true CN107657458A (en) | 2018-02-02 |
Family
ID=61127540
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610711579.1A Pending CN107657458A (en) | 2016-08-23 | 2016-08-23 | List acquisition methods and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107657458A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110457539A (en) * | 2019-06-10 | 2019-11-15 | 平安科技（深圳）有限公司 | List data processing method, device, electric terminal and storage medium |
| CN111159142A (en) * | 2018-11-07 | 2020-05-15 | 马上消费金融股份有限公司 | Data processing method and device |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1737768A (en) * | 2004-08-20 | 2006-02-22 | 中兴通讯股份有限公司 | Method and apparatus for internal memory data base synchronous data |
| CN1777215A (en) * | 2004-11-15 | 2006-05-24 | 中兴通讯股份有限公司 | Telephone automatic external-calling system and method |
| CN101833585A (en) * | 2010-05-19 | 2010-09-15 | 中兴通讯股份有限公司 | Database server operation control system, method and device |
| CN103065238A (en) * | 2012-12-20 | 2013-04-24 | 北京讯鸟软件有限公司 | Pre-preparation method for list information trend through internal memory |
| CN103853727A (en) * | 2012-11-29 | 2014-06-11 | 深圳中兴力维技术有限公司 | Method and system for improving large data volume query performance |
-
2016
- 2016-08-23 CN CN201610711579.1A patent/CN107657458A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1737768A (en) * | 2004-08-20 | 2006-02-22 | 中兴通讯股份有限公司 | Method and apparatus for internal memory data base synchronous data |
| CN1777215A (en) * | 2004-11-15 | 2006-05-24 | 中兴通讯股份有限公司 | Telephone automatic external-calling system and method |
| CN101833585A (en) * | 2010-05-19 | 2010-09-15 | 中兴通讯股份有限公司 | Database server operation control system, method and device |
| CN103853727A (en) * | 2012-11-29 | 2014-06-11 | 深圳中兴力维技术有限公司 | Method and system for improving large data volume query performance |
| CN103065238A (en) * | 2012-12-20 | 2013-04-24 | 北京讯鸟软件有限公司 | Pre-preparation method for list information trend through internal memory |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111159142A (en) * | 2018-11-07 | 2020-05-15 | 马上消费金融股份有限公司 | Data processing method and device |
| CN110457539A (en) * | 2019-06-10 | 2019-11-15 | 平安科技（深圳）有限公司 | List data processing method, device, electric terminal and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107943841A (en) | Stream data processing method, system and computer-readable recording medium | |
| CN101102565B (en) | A processing method, device and equipment of user data in communication terminal | |
| CN106933836B (en) | Data storage method and system based on sub-tables | |
| CN102833298A (en) | Distributed repeated data deleting system and processing method thereof | |
| CN107888787B (en) | Method and device for processing media access request | |
| CN108460041A (en) | The treating method and apparatus of data | |
| CN107833164A (en) | Law business online service system | |
| CN100483411C (en) | Information searching method and device in relation ship data bank | |
| CN105224532A (en) | Data processing method and device | |
| CN103701653B (en) | The processing method of a kind of interface hot plug configuration data and network configuration server | |
| CN107832323A (en) | A kind of distributed implementation system and method based on chart database | |
| CN105426307A (en) | Local area network product test resource sharing method and system | |
| CN105119763A (en) | RIA-based Web network management client big data rapid export method and system | |
| CN104933202A (en) | Method and device for data extraction, transformation and ETL loading | |
| CN105468346A (en) | Timing event management method, storage method, execution method and corresponding apparatus | |
| CN107657458A (en) | List acquisition methods and device | |
| CN102737061B (en) | Distributed ticket query management system and method | |
| CN111414361A (en) | Label data storage method, device, equipment and readable storage medium | |
| CN107403012A (en) | A kind of method for interchanging data and device | |
| WO2012129854A1 (en) | Method and device for summarizing after calling | |
| CN103092768A (en) | Method and device of data processing in application system | |
| CN109800265B (en) | Data loading method, device, equipment and computer readable storage medium | |
| CN102170476B (en) | Cloud computing method and device based on cloud node autonomic learning | |
| CN106657674A (en) | Conversation data batch processing method and terminal | |
| CN104348983A (en) | Method and system for communication record management |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180202 |