CN107862031A - Method for processing business, device and server - Google Patents
Method for processing business, device and server Download PDFInfo
- Publication number
- CN107862031A CN107862031A CN201711066527.4A CN201711066527A CN107862031A CN 107862031 A CN107862031 A CN 107862031A CN 201711066527 A CN201711066527 A CN 201711066527A CN 107862031 A CN107862031 A CN 107862031A
- Authority
- CN
- China
- Prior art keywords
- data
- data area
- database
- production database
- mentioned
- 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
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
-
- 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
- G06F16/24534—Query rewriting; Transformation
- G06F16/24549—Run-time optimisation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application proposes a kind of method for processing business, device and server, wherein, above-mentioned method for processing business includes：Receive Operational Visit request；Determine that the Operational Visit asks the scope of data to be visited according to Operational Visit request；Contrast the data area that the data area to be visited preserves with Production database；If the data area to be visited is included in the data area that the Production database preserves, Operational Visit request is diverted to the Production database.The application can realize that different Operational Visit requests accesses different databases, improve the fluency of Operational Visit, and the data area preserved by defining Production database, the data volume in Production database is efficiently controlled, it ensure that the efficient data of Production database accesses, improve the execution efficiency of business.
Description
Technical field
The application is related to technical field of data processing, more particularly to a kind of method for processing business, device and server.
Background technology
With the progressively development of operation system, substantial amounts of data are have accumulated by operation for many years, among these historical data
Larger scale is occupied, is much the data infrequently accessed in these historical datas, that is to say, that enter when to Recent data
During the operation such as row inquiry and/or modification, due to the presence of a large amount of historical datas, the data manipulations such as the inquiry of whole system can be caused
Hydraulic performance decline, had a strong impact on the speed of service of existing business system.
In existing correlation technique, there are two kinds substantially to the technical scheme of historical data processing：One kind be by it is useless (or not
Often use) historical data move in another database, reduce the data volume of Production database；Another kind is to pass through subregion
Technology, partition management is carried out to data, lifts data access efficiency.
But for the first scheme, only comprising access in the recent period, frequently data, historical data are divided in Production database
From into another database, access and operation of the operation system to historical data are required to be connected to historical data base, for needing
The operation of all data is accessed, then needs two databases of connection to carry out data manipulation, processing is relatively complicated.
For second scheme, an only Production database, all data are stored in Production database, due to
Actual data volume is not reduced, data is carried out into subregion simply by partitioning technique, but do not dropped really in the program
The data volume of low Production database, for the invalid data manipulation of subregion, the performance of data manipulation, overall data storehouse can not be lifted
Management and O＆M it is complex.
The content of the invention
The application is intended to one of technical problem at least solving in correlation technique to a certain extent.
Therefore, first purpose of the application is to propose a kind of method for processing business, to realize different Operational Visits
Request accesses different databases, improves the fluency of Operational Visit, and the data preserved by defining Production database
Scope, the data volume in Production database is efficiently controlled, ensure that the efficient data of Production database accesses, improve industry
The execution efficiency of business.
Second purpose of the application is to propose a kind of business processing device.
The 3rd purpose of the application is to propose a kind of server.
The 4th purpose of the application is to propose a kind of non-transitorycomputer readable storage medium.
For the above-mentioned purpose, the application first aspect embodiment proposes a kind of method for processing business, including：Reception business
Access request；Determine that the Operational Visit asks the scope of data to be visited according to Operational Visit request；Described in contrast
The data area that data area to be visited preserves with Production database；If the data area to be visited is included in described
In the data area that Production database preserves, then Operational Visit request is diverted to the Production database.
, please according to above-mentioned Operational Visit after receiving Operational Visit request in the method for processing business of the embodiment of the present application
The scope for determining that above-mentioned Operational Visit asks data to be visited is sought, contrasts above-mentioned data area to be visited and Production database
The data area of preservation, if above-mentioned data area to be visited is included in the data area that above-mentioned Production database preserves,
The request of above-mentioned Operational Visit is then diverted to above-mentioned Production database, the Operational Visit request so as to realize different accesses not
Same database, the fluency of Operational Visit is improved, and the data area preserved by defining Production database, effectively
The data volume in Production database is controlled, ensure that the efficient data of Production database accesses, improve business performs effect
Rate.
For the above-mentioned purpose, the application second aspect embodiment proposes a kind of business processing device, including：Receive mould
Block, for receiving Operational Visit request；Determining module, the Operational Visit request for being received according to the receiving module determine institute
State the scope that Operational Visit asks data to be visited；Contrast module, for contrasting the to be visited of the determining module determination
The data area that data area preserves with Production database；Diverter module, for being included in when the data area to be visited
When in the data area that the Production database preserves, Operational Visit request is diverted to the Production database.
In the business processing device of the embodiment of the present application, after receiving module receives Operational Visit request, determining module root
Determine that above-mentioned Operational Visit asks the scope of data to be visited according to the request of above-mentioned Operational Visit, contrast module contrast is above-mentioned to be waited to visit
The data area that the data area asked preserves with Production database, if above-mentioned data area to be visited is included in above-mentioned production
In the data area that database preserves, then the request of above-mentioned Operational Visit is diverted to above-mentioned Production database by diverter module, so as to
It can realize that different Operational Visit requests accesses different databases, improve the fluency of Operational Visit, and pass through boundary
Determine the data area of Production database preservation, efficiently controlled the data volume in Production database, ensure that Production database
Efficient data access, improve the execution efficiency of business.
For the above-mentioned purpose, the application third aspect embodiment proposes a kind of server, including memory, processor and
It is stored in the computer program that can be run on the memory and on the processor, computer described in the computing device
During program, method as described above is realized.
To achieve these goals, the application fourth aspect embodiment proposes a kind of computer-readable storage of non-transitory
Medium, is stored thereon with computer program, and the computer program realizes method as described above when being executed by processor.
To achieve these goals, the aspect embodiment of the application the 5th proposes a kind of computer program product, when described
When instruction in computer program product is by computing device, method as described above is performed.
The aspect and advantage that the application adds will be set forth in part in the description, and will partly become from the following description
Obtain substantially, or recognized by the practice of the application.
Brief description of the drawings
The above-mentioned and/or additional aspect of the application and advantage will become from the following description of the accompanying drawings of embodiments
Substantially and it is readily appreciated that, wherein：
Fig. 1 is the flow chart of the application method for processing business one embodiment；
Fig. 2 is the schematic diagram for Operational Visit request shunt one embodiment in the application method for processing business；
Fig. 3 is the flow chart of another embodiment of the application method for processing business；
Fig. 4 is the flow chart of the application method for processing business further embodiment；
Fig. 5 is the structural representation of the application business processing device one embodiment；
Fig. 6 is the structural representation of the application server one embodiment.
Embodiment
Embodiments herein is described below in detail, the example of the embodiment is shown in the drawings, wherein from beginning to end
Same or similar label represents same or similar element or the element with same or like function.Below with reference to attached
The embodiment of figure description is exemplary, it is intended to for explaining the application, and it is not intended that limitation to the application.
Fig. 1 is the flow chart of the application method for processing business one embodiment, as shown in figure 1, above-mentioned method for processing business
It can include：
Step 101, Operational Visit request is received.
Step 102, determine that above-mentioned Operational Visit asks the scope of data to be visited according to the request of above-mentioned Operational Visit.
Step 103, the data area that above-mentioned data area to be visited preserves with Production database is contrasted.
Step 104, if above-mentioned data area to be visited is included in the data area that above-mentioned Production database preserves,
The request of above-mentioned Operational Visit is then diverted to above-mentioned Production database.
Further, after step 103, can also include：
Step 105, if above-mentioned data area to be visited is not included in the data area that above-mentioned Production database preserves
In, then the request of above-mentioned Operational Visit is diverted to standby database, saved historical data in above-mentioned standby database and above-mentioned life
Produce the data in database.
Wherein, above-mentioned steps 104 select an execution with step 105.
In the present embodiment, increase data access layer, after receiving Operational Visit request, in data access layer according to above-mentioned
Operational Visit request determines that above-mentioned Operational Visit asks the scope of data to be visited, then contrasts above-mentioned data model to be visited
The data area preserved with Production database is enclosed, if above-mentioned data area to be visited preserves included in above-mentioned Production database
Data area in, then by above-mentioned Operational Visit request be diverted to above-mentioned Production database；If above-mentioned data model to be visited
Enclose and be not included in the data area that above-mentioned Production database preserves, then the request of above-mentioned Operational Visit is diverted to preliminary data
Storehouse.
It should be noted that in the present embodiment, only above-mentioned data area to be visited is completely contained in above-mentioned production number
In the data area preserved according to storehouse, above-mentioned Operational Visit can just be asked to be diverted to above-mentioned Production database；If above-mentioned wait to visit
The data area asked only partly falls into the data area that above-mentioned Production database preserves, and just asks to shunt by above-mentioned Operational Visit
To standby database.
The present embodiment carries out the operation in more storehouses, the integration of data using unified data access layer to data, allows series of strata
System operates multiple storehouses as one database of operation, can be asked by data access layer according to Operational Visit, selects business
The concrete database that access request accesses.As shown in Fig. 2 Fig. 2 be the application method for processing business in Operational Visit is asked into
The schematic diagram of row shunting one embodiment.
In above-mentioned method for processing business, after receiving Operational Visit request, determined according to the request of above-mentioned Operational Visit above-mentioned
Operational Visit asks the scope of data to be visited, contrasts the data that above-mentioned data area to be visited preserves with Production database
Scope, if above-mentioned data area to be visited is included in the data area that above-mentioned Production database preserves, by above-mentioned industry
Business access request is diverted to above-mentioned Production database, and the Operational Visit request so as to realize different accesses different data
Storehouse, the fluency of Operational Visit is improved, and the data area preserved by defining Production database, efficiently control life
The data volume in database is produced, ensure that the efficient data of Production database accesses, improve the execution efficiency of business.
Fig. 3 is the flow chart of another embodiment of the application method for processing business, as shown in figure 3, real shown in the application Fig. 1
Apply in example, before step 103, can also include：
Step 301, rule is preserved according to predetermined data, determines the data area that Production database preserves.
Wherein, above-mentioned predetermined data preserve rule and can included：The time range of data and the attribute-bit of data it
One or combination.
Specifically, can be by limiting the time ranges of data, to determine Production database for the time range of data
The data area of preservation, for example, limit the time range of data as the data of the first half of current point in time, then can be true
The data area preserved in fixed above-mentioned Production database is the data within the first half of current point in time；
For the attribute-bit of data, for example, business characteristic is carried in the attribute-bit of above-mentioned data, as acting on behalf thing
Whether there are various states in item data, wherein the attribute-bit handled or terminated, it is possible to be stored in as division data
A data in Production database preserve rule, such as：It is that attribute-bit is to have handled that above-mentioned predetermined data, which preserve rule,
Data, then can determine that the data area that above-mentioned Production database preserves is that attribute-bit is the data handled；
In addition, above-mentioned predetermined data preserve the combination that rule can also be both the above rule, such as：Hospital is often right
Leave hospital and reached the data of more than three months and filed, be classified as historical data, this is exactly by the time range and category of data
Property identifies both rules and combined.
Certainly above-mentioned predetermined data preserve rule and are not limited in both the above rule and its combination, and the present embodiment is to upper
Predetermined data preservation rule is stated to be not construed as limiting.
Further, after step 301, can also include：
Step 302, the data that will not belong in the data area that above-mentioned Production database preserves are preserved to standby database.
In the present embodiment, it is determined that after the data area that above-mentioned Production database preserves, above-mentioned life can be will not belong to
Data in the data area that production database preserves are preserved to standby database, that is to say, that in the present embodiment, above-mentioned standby number
Saved historical data and the data that are preserved in above-mentioned Production database according to storehouse, it is standby so as to when Production database goes wrong
Database can completely take over the data access request of operation system, play disaster tolerance effect.
In Fig. 3, performed before step 101 with step 301 and step 302 to exemplify.
Fig. 4 is the flow chart of the application method for processing business further embodiment, as shown in figure 4, real shown in the application Fig. 1
Apply in example, after step 104, can also include：
Step 401, by database copy function, by the data syn-chronization in above-mentioned Production database to above-mentioned preliminary data
Storehouse.
In the present embodiment, it can be realized by database copy function in above-mentioned Production database and above-mentioned standby database
Data real-time synchronization, so as to play a part of disaster tolerance, when Production database goes wrong, standby database (bag
Containing whole creation datas and historical data) data access request of operation system can be completely taken over, play disaster tolerance effect.
That is, in the present embodiment, after above-mentioned Operational Visit request has been handled, it is necessary to by above-mentioned Production database
The above-mentioned Operational Visit of middle processing please look for novelty caused data, above-mentioned standby database is synchronized to, so as to play the work of disaster tolerance
With.
In addition, in the present embodiment, the account of user regularly or periodically can also be replicated to above-mentioned life using non-data
Produce in database, the data of the data area preserved beyond above-mentioned Production database carry out deletion action.Wherein, using non-data
The account for replicating user carries out deletion action, is in order to avoid deletion data operation is copied to backup database, causes data
Missing, the account that above-mentioned non-data replicates user can be database system management person's account.
The method for processing business that the embodiment of the present application provides, the data area preserved by defining Production database, effectively
Ground controls the data volume in Production database, ensure that the efficient data of Production database accesses, improving Operational Visit please
The execution efficiency asked；Realized by database copy function by the data syn-chronization of Production database to standby database, can be with
Play a part of disaster tolerance, when Production database goes wrong, standby database (includes whole creation datas and historical data)
The Operational Visit request of operation system can be completely taken over, plays disaster tolerance effect.Solves different business by data access layer
Access request accesses the problem of disparate databases, it is achieved thereby that the fluency of Operational Visit.
And realize timing or historical data removing periodically is carried out to Production database, and data can be ensured
Clear operation is not duplicated to backup database.
Fig. 5 is the structural representation of the application business processing device one embodiment, the business processing dress in the present embodiment
Server can be used as by putting, or a part for server realizes the method for processing business that the embodiment of the present application provides.Such as Fig. 5 institutes
Show, above-mentioned business processing device can include：Receiving module 51, determining module 52, contrast module 53 and diverter module 54；
Receiving module 51, for receiving Operational Visit request；
Determining module 52, the Operational Visit request for being received according to receiving module 51 determine that above-mentioned Operational Visit request is treated
The scope of the data of access；
Contrast module 53, what the data area to be visited for contrasting the determination of determining module 52 preserved with Production database
Data area；
Diverter module 54, for being included in the data model of above-mentioned Production database preservation when above-mentioned data area to be visited
When enclosing middle, the request of above-mentioned Operational Visit is diverted to above-mentioned Production database.
Further, diverter module 54, it is additionally operable to when above-mentioned data area to be visited is not included in above-mentioned creation data
When in the data area that storehouse preserves, the request of above-mentioned Operational Visit is diverted to standby database, preserved in above-mentioned standby database
Data in historical data and above-mentioned Production database.
In the present embodiment, increase data access layer, after receiving module 51 receives Operational Visit request, determining module 52
Determine that above-mentioned Operational Visit asks the scope of data to be visited according to the request of above-mentioned Operational Visit in data access layer, it is then right
Above-mentioned data area to be visited and the data area of Production database preservation are contrasted than module 53, if above-mentioned number to be visited
It is included according to scope in the data area that above-mentioned Production database preserves, then above-mentioned Operational Visit is asked to shunt by diverter module 54
To above-mentioned Production database；If above-mentioned data area to be visited is not included in the data area that above-mentioned Production database preserves
In, then the request of above-mentioned Operational Visit is diverted to standby database by diverter module 54.
It should be noted that in the present embodiment, only above-mentioned data area to be visited is completely contained in above-mentioned production number
In the data area preserved according to storehouse, diverter module 54 can just ask above-mentioned Operational Visit to be diverted to above-mentioned Production database；Such as
The above-mentioned data area to be visited of fruit only partly falls into the data area that above-mentioned Production database preserves, and diverter module 54 just will
Above-mentioned Operational Visit request is diverted to standby database.
The present embodiment carries out the operation in more storehouses, the integration of data using unified data access layer to data, allows series of strata
System operates multiple storehouses as one database of operation, can be asked by data access layer according to Operational Visit, selects business
The concrete database that access request accesses, as shown in Figure 2.
In the present embodiment, determining module 52, it is additionally operable to preserve rule according to predetermined data, determines that Production database preserves
Data area.
Wherein, above-mentioned predetermined data preserve rule and can included：The time range of data and the attribute-bit of data it
One or combination.
Specifically, can be by limiting the time ranges of data, to determine Production database for the time range of data
The data area of preservation, for example, limit the time range of data as the data of the first half of current point in time, it is determined that mould
The data area that block 52 can determine to preserve in above-mentioned Production database is the data within the first half of current point in time；
For the attribute-bit of data, for example, business characteristic is carried in the attribute-bit of above-mentioned data, as acting on behalf thing
Whether there are various states in item data, wherein the attribute-bit handled or terminated, it is possible to be stored in as division data
A data in Production database preserve rule, such as：It is that attribute-bit is to have handled that above-mentioned predetermined data, which preserve rule,
Data, it is determined that module 52 can determine that the data area that above-mentioned Production database preserves is that attribute-bit is the number handled
According to；
In addition, above-mentioned predetermined data preserve the combination that rule can also be both the above rule, such as：Hospital is often right
Leave hospital and reached the data of more than three months and filed, be classified as historical data, this is exactly by the time range and category of data
Property identifies both rules and combined.
Certainly above-mentioned predetermined data preserve rule and are not limited in both the above rule and its combination, and the present embodiment is to upper
Predetermined data preservation rule is stated to be not construed as limiting.
Further, above-mentioned business processing device can also include：Preserving module 55；
Preserving module 55, the data in data area for will not belong to above-mentioned Production database preservation are preserved to standby
Database.
In the present embodiment, after the data area that determining module 52 determines that above-mentioned Production database preserves, preserving module
55 data that can be will not belong in the data area that above-mentioned Production database preserves are preserved to standby database, that is to say, that
In the present embodiment, above-mentioned standby database saves historical data and the data that are preserved in above-mentioned Production database, so as to when production
When database goes wrong, standby database can completely take over the data access request of operation system, play disaster tolerance effect.
Further, above-mentioned business processing device can also include：
Synchronization module 56, for by database copy function, by the data syn-chronization in above-mentioned Production database to above-mentioned
Standby database.
In the present embodiment, synchronization module 56 can be realized by database copy function above-mentioned Production database with it is above-mentioned standby
It is standby when Production database goes wrong so as to play a part of disaster tolerance with the real-time synchronization of the data in database
Database (including whole creation datas and historical data) can completely take over the data access request of operation system, play disaster tolerance
Effect.
That is, in the present embodiment, after above-mentioned Operational Visit request has been handled, synchronization module 56 needs will be above-mentioned
Above-mentioned Operational Visit is handled in Production database please look for novelty caused data, be synchronized to above-mentioned standby database, so as to rise
To the effect of disaster tolerance.
In addition, in the present embodiment, above-mentioned business processing device can also include：
Removing module 57, the account of user is replicated to above-mentioned Production database for timing or periodically using non-data
In, the data of the data area preserved beyond above-mentioned Production database carry out deletion action.Wherein, removing module 57 uses non-number
Deletion action is carried out according to the account for replicating user, is in order to avoid deletion data operation is copied to backup database, causes to count
According to missing, the account that above-mentioned non-data replicates user can be database system management person's account.
In above-mentioned business processing device, after receiving module 51 receives Operational Visit request, determining module 52 is according to above-mentioned
Operational Visit request determines that above-mentioned Operational Visit asks the scope of data to be visited, and contrast module 53 contrasts above-mentioned to be visited
The data area that data area preserves with Production database, if above-mentioned data area to be visited is included in above-mentioned creation data
In the data area that storehouse preserves, then the request of above-mentioned Operational Visit is diverted to above-mentioned Production database by diverter module 54, so as to
Different databases is accessed with the Operational Visit request for realizing different, improves the fluency of Operational Visit, and by defining
The data area that Production database preserves, has efficiently controlled the data volume in Production database, ensure that Production database
Efficient data accesses, and improves the execution efficiency of business.
The business processing device that the embodiment of the present application provides, the data area preserved by defining Production database, effectively
Ground controls the data volume in Production database, ensure that the efficient data of Production database accesses, improving Operational Visit please
The execution efficiency asked；Realized by database copy function by the data syn-chronization of Production database to standby database, can be with
Play a part of disaster tolerance, when Production database goes wrong, standby database (includes whole creation datas and historical data)
The Operational Visit request of operation system can be completely taken over, plays disaster tolerance effect.Solves different business by data access layer
Access request accesses the problem of disparate databases, it is achieved thereby that the fluency of Operational Visit.
And realize timing or historical data removing periodically is carried out to Production database, and data can be ensured
Clear operation is not duplicated to backup database.
Fig. 6 is the structural representation of the application server one embodiment, and above-mentioned server can include memory, processing
Device and the computer program that can be run on above-mentioned memory and on above-mentioned processor is stored in, the above-mentioned above-mentioned meter of computing device
During calculation machine program, the method for processing business that the embodiment of the present application provides is realized.
Fig. 6 shows the block diagram suitable for being used for the exemplary servers 12 for realizing the application embodiment.The clothes that Fig. 6 is shown
Business device 12 is only an example, should not bring any restrictions to the function and use range of the embodiment of the present application.
As shown in fig. 6, server 12 is showed in the form of universal computing device.The component of server 12 can be included but not
It is limited to：One or more processor or processing unit 16, system storage 28, connection different system component (including system
Memory 28 and processing unit 16) bus 18.
Bus 18 represents the one or more in a few class bus structures, including memory bus or Memory Controller,
Peripheral bus, graphics acceleration port, processor or the local bus using any bus structures in a variety of bus structures.Lift
For example, these architectures include but is not limited to industry standard architecture (Industry Standard
Architecture；Hereinafter referred to as：ISA) bus, MCA (Micro Channel Architecture；Below
Referred to as：MAC) bus, enhanced isa bus, VESA (Video Electronics Standards
Association；Hereinafter referred to as：VESA) local bus and periphery component interconnection (Peripheral Component
Interconnection；Hereinafter referred to as：PCI) bus.
Server 12 typically comprises various computing systems computer-readable recording medium.These media can be it is any being capable of being serviced
The usable medium that device 12 accesses, including volatibility and non-volatile media, moveable and immovable medium.
System storage 28 can include the computer system readable media of form of volatile memory, such as arbitrary access
Memory (Random Access Memory；Hereinafter referred to as：RAM) 30 and/or cache memory 32.Server 12 can be with
Further comprise other removable/nonremovable, volatile/non-volatile computer system storage mediums.Only as an example,
Storage system 34 can be used for reading and writing immovable, non-volatile magnetic media, and (Fig. 6 do not show, commonly referred to as " hard drive
Device ").Although not shown in Fig. 6, it can provide for being driven to the disk that may move non-volatile magnetic disk (such as " floppy disk ") read-write
Dynamic device, and to removable anonvolatile optical disk (such as：Compact disc read-only memory (Compact Disc Read Only
Memory；Hereinafter referred to as：CD-ROM), digital multi read-only optical disc (Digital Video Disc Read Only
Memory；Hereinafter referred to as：DVD-ROM) or other optical mediums) read-write CD drive.In these cases, each driving
Device can be connected by one or more data media interfaces with bus 18.Memory 28 can include at least one program and produce
Product, the program product have one group of (for example, at least one) program module, and it is each that these program modules are configured to perform the application
The function of embodiment.
Program/utility 40 with one group of (at least one) program module 42, such as memory 28 can be stored in
In, such program module 42 includes --- but being not limited to --- operating system, one or more application program, other programs
Module and routine data, the realization of network environment may be included in each or certain combination in these examples.Program mould
Block 42 generally performs function and/or method in embodiments described herein.
Server 12 can also be logical with one or more external equipments 14 (such as keyboard, sensing equipment, display 24 etc.)
Letter, can also enable a user to the equipment communication interacted with the server 12 with one or more, and/or with causing the server
12 any equipment (such as network interface card, the modem etc.) communications that can be communicated with one or more of the other computing device.
This communication can be carried out by input/output (I/O) interface 22.Also, server 12 can also pass through network adapter 20
With one or more network (such as LAN (Local Area Network；Hereinafter referred to as：LAN), wide area network (Wide
Area Network；Hereinafter referred to as：WAN) and/or public network, for example, internet) communication.As shown in fig. 6, network adapter
20 are communicated by bus 18 with other modules of server 12.It should be understood that although not shown in Fig. 6, server can be combined
12 use other hardware and/or software module, include but is not limited to：Microcode, device driver, redundant processing unit, outside
Disk drive array, disk array (Redundant Arrays of Independent Disks；Hereinafter referred to as：RAID) system
System, tape drive and data backup storage system etc..
Processing unit 16 is stored in program in system storage 28 by operation, so as to perform various function application and
Data processing, such as realize the method for processing business that the embodiment of the present application provides.
The application also provides a kind of non-transitorycomputer readable storage medium, is stored thereon with computer program, above-mentioned
The method for processing business that the embodiment of the present application provides is realized when computer program is executed by processor.
Above-mentioned non-transitorycomputer readable storage medium can use appointing for one or more computer-readable media
Meaning combination.Computer-readable medium can be computer-readable signal media or computer-readable recording medium.Computer can
Read storage medium and for example may be-but not limited to-the system of electricity, magnetic, optical, electromagnetic, infrared ray or semiconductor, device
Or device, or any combination above.The more specifically example (non exhaustive list) of computer-readable recording medium includes：
Electrical connection, portable computer diskette, hard disk, random access memory (RAM), read-only storage with one or more wires
Device (Read Only Memory；Hereinafter referred to as：ROM), erasable programmable read only memory (Erasable
Programmable Read Only Memory；Hereinafter referred to as：EPROM) or flash memory, optical fiber, portable compact disc are read-only deposits
Reservoir (CD-ROM), light storage device, magnetic memory device or above-mentioned any appropriate combination.In this document, computer
Readable storage medium storing program for executing can be any includes or the tangible medium of storage program, the program can be commanded execution system, device
Either device use or in connection.
Computer-readable signal media can include in a base band or as carrier wave a part propagation data-signal,
Wherein carry computer-readable program code.The data-signal of this propagation can take various forms, including --- but
It is not limited to --- electromagnetic signal, optical signal or above-mentioned any appropriate combination.Computer-readable signal media can also be
Any computer-readable medium beyond computer-readable recording medium, the computer-readable medium can send, propagate or
Transmit for by instruction execution system, device either device use or program in connection.
The program code included on computer-readable medium can be transmitted with any appropriate medium, including --- but it is unlimited
In --- wireless, electric wire, optical cable, RF etc., or above-mentioned any appropriate combination.
Can with one or more programming languages or its combination come write for perform the application operation computer
Program code, described program design language include object oriented program language-such as Java, Smalltalk, C++,
Also include conventional procedural programming language-such as " C " language or similar programming language.Program code can be with
Fully perform, partly perform on the user computer on the user computer, the software kit independent as one performs, portion
Divide and partly perform or performed completely on remote computer or server on the remote computer on the user computer.
It is related in the situation of remote computer, remote computer can pass through the network of any kind --- including LAN (Local
Area Network；Hereinafter referred to as：) or wide area network (Wide Area Network LAN；Hereinafter referred to as：WAN) it is connected to user
Computer, or, it may be connected to outer computer (such as passing through Internet connection using ISP).
The embodiment of the present application also provides a kind of computer program product, when the instruction in above computer program product by
When managing device execution, the method for processing business of the embodiment of the present application offer can be performed.
In the description of this specification, reference term " one embodiment ", " some embodiments ", " example ", " specifically show
The description of example " or " some examples " etc. means specific features, structure, material or the spy for combining the embodiment or example description
Point is contained at least one embodiment or example of the application.In this manual, to the schematic representation of above-mentioned term not
Identical embodiment or example must be directed to.Moreover, specific features, structure, material or the feature of description can be with office
Combined in an appropriate manner in one or more embodiments or example.In addition, in the case of not conflicting, the skill of this area
Art personnel can be tied the different embodiments or example and the feature of different embodiments or example described in this specification
Close and combine.
The terms "and/or", only a kind of incidence relation for describing affiliated partner, expression may have three kinds of passes
System, for example, A and/or B, can be represented：Individualism A, while A and B be present, these three situations of individualism B.In addition, herein
Middle character "/", it is a kind of relation of "or" to typically represent forward-backward correlation object.
In addition, term " first ", " second " are only used for describing purpose, and it is not intended that instruction or hint relative importance
Or the implicit quantity for indicating indicated technical characteristic.Thus, define " first ", the feature of " second " can be expressed or
Implicitly include at least one this feature.In the description of the present application, " multiple " are meant that at least two, such as two, three
It is individual etc., unless otherwise specifically defined.
Any process or method described otherwise above description in flow chart or herein is construed as, and represents to include
Module, fragment or the portion of the code of the executable instruction of one or more the step of being used to realize custom logic function or process
Point, and the scope of the preferred embodiment of the application includes other realization, wherein can not press shown or discuss suitable
Sequence, including according to involved function by it is basic simultaneously in the way of or in the opposite order, carry out perform function, this should be by the application
Embodiment person of ordinary skill in the field understood.
Expression or logic and/or step described otherwise above herein in flow charts, for example, being considered use
In the order list for the executable instruction for realizing logic function, may be embodied in any computer-readable medium, for
Instruction execution system, device or equipment (such as computer based system including the system of processor or other can be held from instruction
The system of row system, device or equipment instruction fetch and execute instruction) use, or combine these instruction execution systems, device or set
It is standby and use.For the purpose of this specification, " computer-readable medium " can any can be included, store, communicate, propagate or pass
Defeated program is for instruction execution system, device or equipment or the dress used with reference to these instruction execution systems, device or equipment
Put.The more specifically example (non-exhaustive list) of computer-readable medium includes following：Electricity with one or more wiring
Connecting portion (electronic installation), portable computer diskette box (magnetic device), random access memory (Random Access
Memory；Hereinafter referred to as：RAM), read-only storage (Read Only Memory；Hereinafter referred to as：ROM), erasable editable
Read memory (Erasable Programmable Read Only Memory；Hereinafter referred to as：EPROM) or flash memory,
Fiber device, and portable optic disk read-only storage (Compact Disc Read Only Memory；Hereinafter referred to as：CD-
ROM).In addition, computer-readable medium, which can even is that, to print the paper or other suitable media of described program thereon, because
Can then to enter edlin, interpretation or suitable with other if necessary for example by carrying out optical scanner to paper or other media
Mode is handled electronically to obtain described program, is then stored in computer storage.
It should be appreciated that each several part of the application can be realized with hardware, software, firmware or combinations thereof.Above-mentioned
In embodiment, software that multiple steps or method can be performed in memory and by suitable instruction execution system with storage
Or firmware is realized.Such as, if realized with hardware with another embodiment, following skill well known in the art can be used
Any one of art or their combination are realized：With the logic gates for realizing logic function to data-signal from
Logic circuit is dissipated, the application specific integrated circuit with suitable combinational logic gate circuit, programmable gate array (Programmable
Gate Array；Hereinafter referred to as：PGA), field programmable gate array (Field Programmable Gate Array；Below
Referred to as：FPGA) etc..
Those skilled in the art are appreciated that to realize all or part of step that above-described embodiment method carries
Suddenly it is that by program the hardware of correlation can be instructed to complete, described program can be stored in a kind of computer-readable storage medium
In matter, the program upon execution, including one or a combination set of the step of embodiment of the method.
In addition, each functional unit in each embodiment of the application can be integrated in a processing module, can also
That unit is individually physically present, can also two or more units be integrated in a module.Above-mentioned integrated mould
Block can both be realized in the form of hardware, can also be realized in the form of software function module.The integrated module is such as
Fruit is realized in the form of software function module and as independent production marketing or in use, can also be stored in a computer
In read/write memory medium.
Storage medium mentioned above can be read-only storage, disk or CD etc..Although have been shown and retouch above
Embodiments herein is stated, it is to be understood that above-described embodiment is exemplary, it is impossible to be interpreted as the limit to the application
System, one of ordinary skill in the art can be changed to above-described embodiment, change, replace and become within the scope of application
Type.
Claims (10)
- A kind of 1. method for processing business, it is characterised in that including：Receive Operational Visit request；Determine that the Operational Visit asks the scope of data to be visited according to Operational Visit request；Contrast the data area that the data area to be visited preserves with Production database；If the data area to be visited is included in the data area that the Production database preserves, by the business Access request is diverted to the Production database.
- 2. according to the method for claim 1, it is characterised in that the contrast data area to be visited and production number After the data area preserved according to storehouse, in addition to：If the data area to be visited is not included in the data area that the Production database preserves, by the industry Business access request is diverted to standby database, is saved historical data in the standby database and the number in the Production database According to.
- 3. according to the method for claim 1, it is characterised in that the contrast data area to be visited and production number Before the data area preserved according to storehouse, in addition to：Rule is preserved according to predetermined data, determines the data area that Production database preserves；The predetermined data preserve rule Then include：One of the time range of data and the attribute-bit of data or combination.
- 4. according to the method for claim 3, it is characterised in that it is described to preserve rule according to predetermined data, it is determined that production After the data area that database preserves, in addition to：The data that will not belong in the data area that the Production database preserves are preserved to standby database.
- 5. according to the method for claim 2, it is characterised in that described that Operational Visit request is diverted to the production After database, in addition to：By database copy function, by the data syn-chronization in the Production database to the standby database.
- 6. according to the method described in claim 1-5 any one, it is characterised in that also include：Timing periodically replicates the account of user in the Production database using non-data, beyond the creation data The data for the data area that storehouse preserves carry out deletion action.
- A kind of 7. business processing device, it is characterised in that including：Receiving module, for receiving Operational Visit request；Determining module, the Operational Visit request for being received according to the receiving module determine that the Operational Visit request is to be visited Data scope；Contrast module, the data preserved for contrasting the data area to be visited that the determining module determines with Production database Scope；Diverter module, for being included in when the data area to be visited in the data area that the Production database preserves When, Operational Visit request is diverted to the Production database.
- 8. a kind of server, it is characterised in that including memory, processor and be stored on the memory and can be at the place The computer program run on reason device, described in the computing device during computer program, realize as any in claim 1-6 Described method.
- 9. a kind of non-transitorycomputer readable storage medium, is stored thereon with computer program, it is characterised in that the calculating The method as described in any in claim 1-6 is realized when machine program is executed by processor.
- 10. a kind of computer program product, it is characterised in that when the instruction in the computer program product is by computing device When, perform the method as described in any in claim 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711066527.4A CN107862031A (en) | 2017-11-02 | 2017-11-02 | Method for processing business, device and server |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711066527.4A CN107862031A (en) | 2017-11-02 | 2017-11-02 | Method for processing business, device and server |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107862031A true CN107862031A (en) | 2018-03-30 |
Family
ID=61700611
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711066527.4A Pending CN107862031A (en) | 2017-11-02 | 2017-11-02 | Method for processing business, device and server |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107862031A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108830470A (en) * | 2018-06-01 | 2018-11-16 | 北京金山数字娱乐科技有限公司 | A kind of method and device of account processing |
| CN109597724A (en) * | 2018-09-18 | 2019-04-09 | 北京微播视界科技有限公司 | Service stability measurement method, device, computer equipment and storage medium |
| CN109614386A (en) * | 2018-09-28 | 2019-04-12 | 阿里巴巴集团控股有限公司 | Data processing method, device, server and computer readable storage medium |
| CN110837592A (en) * | 2019-11-08 | 2020-02-25 | 京东数字科技控股有限公司 | Method, apparatus and computer readable storage medium for data archiving |
| CN112486966A (en) * | 2020-11-26 | 2021-03-12 | 中国国家铁路集团有限公司 | Expired data cleaning method and device and electronic equipment |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060235904A1 (en) * | 2005-04-14 | 2006-10-19 | Rajesh Kapur | Method for preserving access to system in case of disaster |
| CN102663110A (en) * | 2012-04-17 | 2012-09-12 | 苏州风采信息技术有限公司 | Method for optimizing outpatient process database |
| CN103617161A (en) * | 2013-09-26 | 2014-03-05 | 金蝶软件（中国）有限公司 | Data storing method and device for SAAS mode |
| CN106293995A (en) * | 2015-05-15 | 2017-01-04 | 中芯国际集成电路制造(上海)有限公司 | The data backup system of manufacturing execution system and method |
| CN106776837A (en) * | 2016-11-25 | 2017-05-31 | 国云科技股份有限公司 | A kind of method of the security real-time deal association analysis based on MongoDB |
-
2017
- 2017-11-02 CN CN201711066527.4A patent/CN107862031A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060235904A1 (en) * | 2005-04-14 | 2006-10-19 | Rajesh Kapur | Method for preserving access to system in case of disaster |
| CN102663110A (en) * | 2012-04-17 | 2012-09-12 | 苏州风采信息技术有限公司 | Method for optimizing outpatient process database |
| CN103617161A (en) * | 2013-09-26 | 2014-03-05 | 金蝶软件（中国）有限公司 | Data storing method and device for SAAS mode |
| CN106293995A (en) * | 2015-05-15 | 2017-01-04 | 中芯国际集成电路制造(上海)有限公司 | The data backup system of manufacturing execution system and method |
| CN106776837A (en) * | 2016-11-25 | 2017-05-31 | 国云科技股份有限公司 | A kind of method of the security real-time deal association analysis based on MongoDB |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108830470A (en) * | 2018-06-01 | 2018-11-16 | 北京金山数字娱乐科技有限公司 | A kind of method and device of account processing |
| CN108830470B (en) * | 2018-06-01 | 2023-05-02 | 北京金山数字娱乐科技有限公司 | Account processing method and device |
| CN109597724A (en) * | 2018-09-18 | 2019-04-09 | 北京微播视界科技有限公司 | Service stability measurement method, device, computer equipment and storage medium |
| CN109597724B (en) * | 2018-09-18 | 2022-11-04 | 北京微播视界科技有限公司 | Service stability measuring method, device, computer equipment and storage medium |
| CN109614386A (en) * | 2018-09-28 | 2019-04-12 | 阿里巴巴集团控股有限公司 | Data processing method, device, server and computer readable storage medium |
| CN109614386B (en) * | 2018-09-28 | 2023-09-22 | 创新先进技术有限公司 | Data processing method, device, server and computer readable storage medium |
| CN110837592A (en) * | 2019-11-08 | 2020-02-25 | 京东数字科技控股有限公司 | Method, apparatus and computer readable storage medium for data archiving |
| CN110837592B (en) * | 2019-11-08 | 2021-01-26 | 京东数字科技控股有限公司 | Method, apparatus and computer readable storage medium for data archiving |
| CN112486966A (en) * | 2020-11-26 | 2021-03-12 | 中国国家铁路集团有限公司 | Expired data cleaning method and device and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107862031A (en) | Method for processing business, device and server | |
| CN105205014B (en) | A kind of date storage method and device | |
| CN104516678B (en) | Method and apparatus for data storage | |
| CN105264482B (en) | Low cost storage to the data seldom read | |
| CN109062512A (en) | A kind of distributed storage cluster, data read-write method, system and relevant apparatus | |
| US20110099135A1 (en) | System, method and computer program product for evaluating a storage policy based on simulation | |
| CN107610702A (en) | Terminal device standby wakeup method, apparatus and computer equipment | |
| CN110737401B (en) | Method, apparatus and computer program product for managing redundant array of independent disks | |
| EP3657337B1 (en) | Method, apparatus, device and storage medium for accessing static random access memory | |
| CN111062858A (en) | Efficient rendering-ahead method, device and computer storage medium | |
| US11068418B2 (en) | Determining memory access categories for tasks coded in a computer program | |
| US11036635B2 (en) | Selecting resources to make available in local queues for processors to use | |
| CN105095095A (en) | Computer system and data reading and writing method | |
| CN107423894A (en) | The task measures and procedures for the examination and approval, device and computer equipment | |
| CN107291950A (en) | Form data update method, device and computer equipment | |
| CN107391295A (en) | The processing method and processing device of application exception | |
| CN108089822A (en) | Management method, system, equipment and the storage medium of storage chip | |
| US10204060B2 (en) | Determining memory access categories to use to assign tasks to processor cores to execute | |
| US11226778B2 (en) | Method, apparatus and computer program product for managing metadata migration | |
| CN107451271A (en) | A kind of Hash table processing method, device, equipment and storage medium | |
| CN112748849A (en) | Method, apparatus and computer program product for storing data | |
| CN110780821A (en) | Optimization method and device of distributed storage system, server and storage medium | |
| CN113408070B (en) | Engine parameter determining method, device, equipment and storage medium | |
| CN107301220A (en) | Method, device, equipment and the storage medium of data-driven view | |
| CN109347899A (en) | The method of daily record data is written in distributed memory system |
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: 20180330 |