WO2019019697A1 - 数值资源回退方法、装置、服务器和存储介质 - Google Patents
数值资源回退方法、装置、服务器和存储介质 Download PDFInfo
- Publication number
- WO2019019697A1 WO2019019697A1 PCT/CN2018/082480 CN2018082480W WO2019019697A1 WO 2019019697 A1 WO2019019697 A1 WO 2019019697A1 CN 2018082480 W CN2018082480 W CN 2018082480W WO 2019019697 A1 WO2019019697 A1 WO 2019019697A1
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- resource
- batch number
- receipt
- transfer
- batch
- 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.)
- Ceased
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/08—Payment architectures
- G06Q20/085—Payment architectures involving remote charge determination or related payment systems
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/08—Insurance
Definitions
- the application relates to a numerical resource fallback method, device, server and storage medium.
- Some numerical resources are distributed through banks. Users can collect numerical resources in different places. For example, users can collect survival funds in different places. Survival gold refers to the amount, method and duration agreed by the insurance company according to the contract. The amount paid by the policy beneficiary. Since the numerical resources collected from different places are transferred by the remote organization, and the foreign institutions usually do not belong to the organization of the company linked to the numerical resources, only the receipt number of the numerical resource transfer is recorded in the database. When the value resource collection error occurs, and the received value resource needs to be rolled back, it can only be rolled back according to the receipt number. Each time a value resource is returned, it is necessary to wait for the business to be returned before the next value resource can be rolled back. The inventor realized that if it is necessary to back up a dozen numerical resources, a large amount of time is wasted, and the numerical resource back-off is inefficient.
- a numerical resource fallback method apparatus, server, and storage medium are provided.
- a numerical resource fallback method includes:
- the value resource is rolled back from the first account to the second account according to the receipt number.
- a numerical resource fallback device includes:
- a receiving module configured to receive a value resource backoff request
- a batch number obtaining module configured to obtain a backed batch number according to the numerical resource back request
- the fallback module is configured to roll back the value resource from the first account to the second account according to the receipt number.
- a server comprising a memory and one or more processors having stored therein computer readable instructions, the computer readable instructions being executed by the one or more processors such that the one or more The processor performs the following steps:
- the value resource is rolled back from the first account to the second account according to the receipt number.
- One or more non-transitory computer readable storage mediums storing computer readable instructions, when executed by one or more processors, cause the one or more processors to perform the following steps:
- the value resource is rolled back from the first account to the second account according to the receipt number.
- FIG. 1 is a block diagram of a server in accordance with one or more embodiments.
- FIG. 2 is a flow diagram of a method for numerical resource fallback in accordance with one or more embodiments.
- FIG. 3 is a flow diagram of determining a receipt number that matches a batch number in accordance with one or more embodiments.
- FIG. 4 is a flow diagram of a database and a data table corresponding to a batch number in accordance with one or more embodiments.
- FIG. 5 is a flow diagram of performing numerical resource fallback in accordance with one or more embodiments.
- FIG. 6 is a flow diagram of changing numerical resource plan transfer table data based on a rollback record in accordance with one or more embodiments.
- FIG. 7 is a block diagram of a numerical resource fallback device in accordance with one or more embodiments.
- Figure 8 is a block diagram of a determination module in accordance with one or more embodiments.
- FIG. 9 is a block diagram of a query unit in accordance with one or more embodiments.
- FIG. 10 is a block diagram of a fallback module in accordance with one or more embodiments.
- Figure 11 is a block diagram of a numerical resource fallback device in another embodiment.
- FIG. 12 is an application environment diagram of a numerical resource fallback method in accordance with one or more embodiments.
- first may be referred to as a second client
- second client may be referred to as a first client, without departing from the scope of the present application.
- Both the first client and the second client are clients, but they are not the same client.
- the numerical resource fallback method provided by the present application can be applied to an application environment as shown in FIG.
- the terminal 10 and the server 12 communicate via a network.
- the server 12 receives the numerical resource fallback request, obtains the backed batch number according to the numerical resource back request, parses the batch number, and determines a receipt number matching the batch number in the database; The receipt number rolls back the value resource from the first account to the second account.
- the terminal 10 can be, but is not limited to, various personal computers, notebook computers, smart phones, tablets, and portable wearable devices, and the server 12 can be implemented by a stand-alone server or a server cluster composed of a plurality of servers.
- FIG. 1 is a block diagram of a server in one embodiment.
- the server includes a processor, memory, and network interface connected by a system bus.
- the memory of the server includes a non-volatile storage medium and an internal memory.
- the non-volatile storage medium may be a non-transitory computer readable storage medium.
- the server's non-volatile storage medium stores an operating system, a database, and computer readable instructions.
- a data table is stored in the database, and the data table stores information such as records of numerical resource transfer of each batch.
- the computer readable instructions are used to implement a numerical resource fallback method applicable to a server provided in the embodiments of the present application.
- the server's processor is used to provide computing and control capabilities that support the operation of the entire server.
- the internal memory of the server provides a cached operating environment for operating systems and computer readable instructions in a non-volatile storage medium.
- the server's network interface is used to communicate with other computer devices, such as receiving numeric resource fallback requests.
- the server can be implemented with a stand-alone server or a server cluster consisting of multiple servers. It will be understood by those skilled in the art that the structure shown in FIG. 1 is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the server to which the solution of the present application is applied. Specifically, the server may include a ratio. More or fewer components are shown in the figures, or some components are combined, or have different component arrangements.
- a numerical resource fallback method is provided.
- the method is applied to the server shown in FIG. 12 or FIG. 1 as an example, and includes the following steps:
- Step S210 receiving a numerical resource fallback request.
- the value resource back-off operation can be performed by the terminal, and the value resource back-off refers to the state before the value resource is returned to the transfer.
- the user can trigger the value resource back-off operation by triggering the value resource back button on the value resource back-off page of the terminal, or transfer the value resource.
- the mechanism sends information to perform a numerical resource rollback operation, and the terminal sends a numerical resource fallback request to the server according to the received numerical resource fallback operation.
- Step S220 Acquire a batch number of the backoff according to the value resource back request.
- the numerical resource has a corresponding batch number when the transfer is performed, and the numerical resource belonging to the same batch number can be transferred in multiple times, and one batch number can include one or more receipt numbers, belonging to the same batch. Each receipt number of the minor number can correspond to the numerical resource that is transferred at different time points under the batch number.
- the server receives the value resource back-off request sent by the terminal, and obtains the batch number corresponding to the value resource that needs to be rolled back from the value resource back-off request.
- step S230 the batch number is parsed, and the receipt number matching the batch number is determined in the database.
- the batch number can be generated according to certain setting conditions, the number of digits of the batch number is agreed in the setting condition, and the meaning of each character in the batch number, wherein the character can be Includes numbers, letters or symbols.
- the setting condition can stipulate that the batch number is a total of 16 digits, wherein the first digit of the batch number is a letter, which is used to indicate the type corresponding to the numerical resource, such as life insurance, pension insurance, etc.;
- the fifth digit is a number, which is used to indicate the relevant department number, such as the A department of Shenzhen City, Guangdong province, and the B department of Guangzhou City, Guangdong province; the last 11 digits of the batch number are numbers, which are used to indicate the sequence corresponding to the batch number.
- the batch number can be other composition formats.
- the server analyzes the batch number, divides the batch number according to the set conditions, and can first query the corresponding database according to the divided batch number, and find the corresponding data table in the database, and then from the data table.
- the respective receipt numbers matching the batch number are determined, and the receipt number matching the batch number may be one or more, determined by the number of times the numerical resource is transferred under the batch number.
- Step S240 the value resource is rolled back from the first account to the second account according to the receipt number.
- the numerical resources corresponding to the respective receipt numbers may be rolled back from the first account to the second account at one time, wherein the first account refers to the value received when the numerical resource is transferred.
- the object of the resource, the second account is an object that performs a numerical resource transfer operation, for example, the numerical resource is transferred from the insurance company account to the user's personal account, and when the rollback is performed, the numerical resource is returned from the user's personal account to the insurance company account.
- the user's personal account is the first account and the insurance company account is the second account.
- the user may also roll back only the numeric resource of a single receipt number in a certain batch number.
- the server may obtain the batch number and the receipt according to the numerical resource fallback request. No. The server queries the corresponding numerical resource transfer record stored in the data table of the database according to the batch number and the receipt number, and returns the numerical resource from the first account to the second account according to the value resource transfer record.
- the above-mentioned numerical resource fallback method receives a numerical resource fallback request, obtains a backed batch number according to the numerical resource fallback request, and determines each receipt number matching the batch number, according to each receipt number matching the batch number
- the value resource is rolled back from the first account to the second account, and multiple numerical resources can be rolled back at the same time in batches, thereby reducing the backoff time and effectively improving the efficiency of the numerical resource fallback.
- step S230 parses the batch number and determines a receipt number matching the batch number in the database, including the following steps:
- step S302 the batch number is parsed, and the analysis result is obtained.
- the server can analyze the batch number, divide the batch number according to the set conditions, obtain the department number and serial number included in the batch number, and find the receipt number matching the batch number according to the department number and the serial number.
- the batch number is "E260100000227727”
- the server analyzes the batch number, and after dividing according to the set conditions, "E", "2601”, and "0000227727” are respectively obtained, wherein "E” represents a numerical resource corresponding to The type is life insurance; the second to fifth digit 2601 indicates the relevant department number, representing the life insurance department of Shenzhen, Guangdong province; the last 11 digits are serial numbers.
- Step S304 querying the database corresponding to the batch number according to the analysis result, and obtaining a data table corresponding to the batch number in the database.
- the server may first query the corresponding database according to the divided batch number, and find the corresponding data table in the database, and then determine the respective receipt numbers matching the batch number from the data table.
- step S304 queries the database corresponding to the batch number according to the parsing result, and obtains a data table corresponding to the batch number in the database, including the following steps:
- Step S402 querying a database corresponding to the department number.
- a plurality of databases may be included, and each database may correspond to one or more departments, and the database stores the transfer information of the numerical resources of the relevant departments.
- the server can query the database corresponding to the department number included in the batch number according to the correspondence between the pre-established database and the department number.
- Step S404 reading a serial number value interval corresponding to each data table in the database.
- Each database may store a data table, and each data table may correspond to a different serial number value interval, and the data table stores a numerical resource transfer record with a batch number located in a corresponding serial number value interval. For example, if the serial number value corresponding to the a data table in the A database is [0, 100000], the numerical resource transfer records containing the batch number with the serial number between 0 and 100000 are stored in the a data table.
- Step S406 the serial number is compared with the read numerical interval of each serial number, and the data table corresponding to the serial number value interval in which the serial number is located is obtained.
- the serial number value interval corresponding to each data table in the corresponding database can be read, and the serial number included in the batch number and each serial number read are read.
- the numerical interval is compared one by one, and the numerical range of the serial number in which the serial number is located is determined, thereby obtaining a data table corresponding to the determined numerical range of the serial number, in which all receipt numbers matching the batch number are stored in the data table.
- Numerical resource transfer record For example, the serial number contained in the batch number "E260100000227727" is "00000227727", which falls within the serial number value range [200000, 300000], and can be obtained from the data table with the serial number value interval [200000, 300000]. All receipt numbers matched by the batch number "E260100000227727", and related numerical resource transfer records.
- step S306 the receipt number matching the batch number is determined from the data table.
- the batch number can be parsed, the corresponding database is found according to the department number obtained by the parsing, and the data table corresponding to the batch number in the database is determined according to the serial number, and is in the corresponding data table. Obtaining the receipt number matching the batch number can improve the query speed of the receipt number, thereby effectively improving the efficiency of numerical resource rollback.
- step S240 returns the value resource from the first account to the second account according to the receipt number, including the following steps:
- Step S502 obtaining a first transfer record of the receipt number matching the batch number in the numerical resource actual transfer table.
- the data table in the database may include a numerical resource plan transfer table and a numerical resource actual transfer table, wherein the numerical resource plan transfer table stores the to-be-transferred record of the numerical resource and the corresponding transfer information, and the numerical resource actual transfer table stores the value.
- the actual transfer of information For example, when an insurance company needs to transfer a numerical resource to a user's personal account, the value resource resource transfer table may be first generated in the numerical resource plan transfer table, and the server performs numerical resource transfer according to the to-be-transferred record, and allocates the transferred batch number.
- the numerical resource under one batch number can be transferred in multiple times, and the unique receipt number for each numerical resource transfer can be allocated, when each time value is transferred After successful, the corresponding transfer status is updated in the actual transfer table of the numeric resource.
- the server may obtain, in the numerical resource actual transfer table, a first transfer record of the receipt number matching the batch number, wherein the first transfer record stores actual transfer information of each receipt number under the batch number, which may include the batch number Information such as receipt number, transfer status, transfer amount, and object receiving numerical resources.
- the first transfer record obtained from the numerical resource actual transfer table can be as shown in Table 1.
- the assigned batch number is “E260100000227727”, and is divided into 4 times for transfer. Each time the numerical resource transfer can correspond to a unique receipt number, as shown in Table 1, the The first 3 times of the batch value resource has been transferred, and the 4th time value resource has not been transferred.
- Step S504 determining the transfer status of each receipt number one by one according to the first transfer record.
- the server may determine whether the transfer status of each receipt number in the first transfer record is transferred or not, and the statistical transfer status is The total resource amount corresponding to the transferred receipt number. For example, as shown in Table 1, the receipt number matching the batch number "E260100000227727" is 4, wherein the transfer status of the first 3 receipt numbers is transferred, and the transfer status of the 4th receipt number is untransferred. , the total resource amount of the receipt number whose transfer status is transferred is 3,500.
- step S506 the statistical transfer status is the total resource quota corresponding to the transferred receipt number.
- Step S508 extracting a numerical resource matching the total resource quota from the first account, and rolling back to the second account.
- the server may extract the numerical resource matching the total resource quota of the statistics from the first account, and roll back to the second account, and perform unified rollback on the numerical resources of the plurality of receipt numbers in the same batch.
- the first transfer record of the receipt number matching the batch number may be obtained from the numerical resource actual transfer table, and the numerical resources of the plurality of receipt numbers in the same batch are unified according to the first transfer record. Roll back, reduce the back-off time, and effectively improve the efficiency of numerical resource rollback.
- the method further includes the following steps:
- Step S602 generating a back-off record corresponding to the receipt number whose transfer status is transferred in the numerical resource actual transfer table.
- the rollback record may be generated in the actual transfer table of the value resource, and the rollback record and the receipt for the rollback operation are generated.
- the number has a one-to-one correspondence, and the rollback record may include information such as a batch number, a receipt number, a refund amount, a rolled back account, and a backoff time.
- the server performs rollback according to the first transfer record of Table 1, and generates a rollback record in the actual transfer table of the numerical resources as shown in Table 2.
- Step S604 obtaining a second transfer record of the receipt number matching the batch number in the numerical resource plan transfer table.
- the server may obtain a second transfer record of the receipt number matching the batch number in the numerical resource plan table, wherein the second transfer record stores the transfer information of the numerical resource related to the batch number, which may include the batch number , receipt number, transfer amount, valid flag, etc., wherein the valid flag is used to indicate whether the transfer record of the receipt number is valid.
- the valid flag is used to indicate whether the transfer record of the receipt number is valid.
- a valid flag bit of 1 indicates valid, and a valid flag bit of 0 indicates invalid, but is not limited thereto, and other characters may be used for representation. It can be seen from Table 3 that the transfer amount of the receipt number "123456" and "345678" under the batch number "E260100000227727” is 1200, and the transfer quota in Table 1 is 1000, indicating that the transfer amount of the numerical resource is incorrect. The user can perform a numerical resource rollback operation through the terminal.
- Step S608 invalidating the valid flag position of the receipt number corresponding to the rollback record in the second transfer record, and generating a corresponding record to be transferred, and setting the receipt number of the record to be transferred to be empty.
- the server may invalidate the valid flag position of the corresponding receipt number in the second transfer record according to the rollback record generated in the actual transfer table of the numerical resource.
- the receipt number in Table 3 is The valid flag positions of "123456", "234567", and "345678" are invalid.
- the server can simultaneously generate corresponding records to be transferred.
- the information to be transferred can include only the batch number, the amount to be transferred, and the like, and the batch number in the record to be transferred can be set to be empty, wherein the amount to be transferred can be the second.
- the total amount of resources in the transfer record is set to be invalid.
- the to-be-transfer quota for generating the record to be transferred corresponding to Table 3 is 4900, and the receipt number for the rollback is “123456”, “234567”, “ 345678”, and the sum of the transferable amounts of the untransferred receipt number "456789".
- the batch number assigned in the value resource plan table may be filled in the record to be transferred, and the information such as the receipt number and the valid flag of the receipt number is updated at the same time.
- the data in the numerical resource plan table can be returned to the numerical resource transfer according to the back-off record, the data consistency is ensured, the numerical resource transfer is facilitated, and the error caused by the numerical resource rollback is reduced. Effectively improve the efficiency of numerical resource rollback.
- FIGS. 2-6 are sequentially displayed as indicated by the arrows, these steps are not necessarily performed in the order indicated by the arrows. Except as explicitly stated herein, the execution of these steps is not strictly limited, and the steps may be performed in other orders. Moreover, at least some of the steps in FIGS. 2-6 may include a plurality of sub-steps or stages, which are not necessarily performed at the same time, but may be executed at different times, these sub-steps or stages The order of execution is not necessarily performed sequentially, but may be performed alternately or alternately with at least a portion of other steps or sub-steps or stages of other steps.
- a numerical resource fallback device 700 including a receiving module 710, a batch number obtaining module 720, a determining module 730, and a fallback module 740.
- the receiving module 710 is configured to receive a value resource backoff request.
- the batch number obtaining module 720 is configured to obtain a backed batch number according to the value resource back request.
- a determination module 730 is configured to parse the batch number and determine a receipt number that matches the batch number in the database.
- the fallback module 740 is configured to roll back the value resource from the first account to the second account according to the receipt number.
- the numerical resource back-off device receives the numerical resource fallback request, obtains the returned batch number according to the numerical resource fallback request, and determines each receipt number matching the batch number, according to each receipt number matching the batch number
- the value resource is rolled back from the first account to the second account, and multiple numerical resources can be rolled back at the same time in batches, thereby reducing the backoff time and effectively improving the efficiency of the numerical resource fallback.
- the determining module 730 includes a parsing unit 732, a query unit 734, and a determining unit 736.
- the parsing unit 732 is configured to parse the batch number to obtain an analysis result.
- the parsing unit 732 is further configured to parse the batch number to obtain the department number and serial number of the batch number.
- the query unit 734 is configured to query the database corresponding to the batch number according to the parsing result, and obtain a data table corresponding to the batch number in the database.
- the query unit 734 includes a database query sub-unit 902, a read sub-unit 904, and a comparison sub-unit 906.
- the database query subunit 902 is configured to query a database corresponding to the department number.
- the reading subunit 904 is configured to read a serial number value interval corresponding to each data table in the database.
- the comparison sub-unit 906 is configured to compare the serial number with each of the read serial number value intervals, and obtain a data table corresponding to the serial number value interval in which the serial number is located.
- the determining unit 736 is configured to determine, from the data table, a receipt number that matches the batch number.
- the batch number can be parsed, the corresponding database is found according to the department number obtained by the parsing, and the data table corresponding to the batch number in the database is determined according to the serial number, and is in the corresponding data table. Obtaining the receipt number matching the batch number can improve the query speed of the receipt number, thereby effectively improving the efficiency of numerical resource rollback.
- the data table includes a numerical resource actual transfer table and a numerical resource plan transfer table.
- the fallback module 740 includes a record acquisition unit 742, a state determination unit 744, a statistics unit 746, and a fallback unit 748.
- the record obtaining unit 742 is configured to obtain a first transfer record of the receipt number matching the batch number in the numerical resource actual transfer table.
- the status determining unit 744 is configured to determine the transfer status of each receipt number one by one according to the first transfer record.
- the statistic unit 746 is configured to calculate the total resource quota corresponding to the transferred receipt number.
- the fallback unit 748 is configured to extract a numeric resource that matches the total resource quota from the first account, and roll back to the second account.
- the first transfer record of the receipt number matching the batch number may be obtained from the numerical resource actual transfer table, and the numerical resources of the plurality of receipt numbers in the same batch are unified according to the first transfer record. Roll back, reduce the back-off time, and effectively improve the efficiency of numerical resource rollback.
- the value resource back-off device 700 includes a receiving module 710, a batch number obtaining module 720, a determining module 730, and a fallback module 740, and a first generating module.
- the record acquisition module and the second generation module are included in the value resource back-off device 700.
- the first generation module 750 is configured to generate, in the numerical resource actual transfer table, a rollback record corresponding to the receipt number whose transfer status is transferred.
- the record acquisition module 760 is configured to obtain a second transfer record of the receipt number matching the batch number in the numerical resource plan transfer table.
- the second generation module 770 is configured to invalidate the valid flag position of the receipt number corresponding to the rollback record in the second transfer record, and generate a corresponding record to be transferred, and set the receipt number of the record to be transferred to be empty.
- the data in the numerical resource plan table can be returned to the numerical resource transfer according to the back-off record, the data consistency is ensured, the numerical resource transfer is facilitated, and the error caused by the numerical resource rollback is reduced. Effectively improve the efficiency of numerical resource rollback.
- each of the above-described numerical resource fallback devices may be implemented in whole or in part by software, hardware, and combinations thereof.
- Each of the above modules may be embedded in or independent of the processor in the computer device, or may be stored in a memory in the computer device in a software form, so that the processor invokes the operations corresponding to the above modules.
- a computer device comprising a memory and one or more processors having stored therein computer readable instructions, the computer readable instructions being executed by one or more processors such that one or more processors implement any of the present application
- the steps of the numerical resource fallback method provided in the embodiment are not limited to:
- One or more non-transitory computer readable storage mediums storing computer readable instructions, when executed by one or more processors, cause one or more processors to be implemented in any one embodiment of the present application. The steps provided for the numeric resource fallback method.
- Non-volatile memory can include read only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM), or flash memory.
- Volatile memory can include random access memory (RAM) or external cache memory.
- RAM is available in a variety of formats, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronization chain.
- SRAM static RAM
- DRAM dynamic RAM
- SDRAM synchronous DRAM
- DDRSDRAM double data rate SDRAM
- ESDRAM enhanced SDRAM
- Synchlink DRAM SLDRAM
- Memory Bus Radbus
- RDRAM Direct RAM
- DRAM Direct Memory Bus Dynamic RAM
- RDRAM Memory Bus Dynamic RAM
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Finance (AREA)
- Databases & Information Systems (AREA)
- General Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Technology Law (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
| 批次号 | 收据号 | 转移额度 | 接收账户 | 转移状态 |
| E260100000227727 | 123456 | 1000 | X | 已转移 |
| E260100000227727 | 234567 | 1500 | X | 已转移 |
| E260100000227727 | 345678 | 1000 | X | 已转移 |
| E260100000227727 | 456789 | 1000 | X | 未转移 |
| 批次号 | 收据号 | 回退额度 | 回退账户 | 回退时间 |
| E260100000227727 | 123456 | 1000 | Y | 2017-7-1 |
| E260100000227727 | 234567 | 1500 | Y | 2017-7-1 |
| E260100000227727 | 345678 | 1000 | Y | 2017-7-1 |
| 批次号 | 收据号 | 应转移额度 | 接收账户 | 有效标志位 |
| E260100000227727 | 123456 | 1200 | X | 1 |
| E260100000227727 | 234567 | 1500 | X | 1 |
| E260100000227727 | 345678 | 1200 | X | 1 |
| E260100000227727 | 456789 | 1000 | X | 0 |
Claims (20)
- 一种数值资源回退方法,包括:接收数值资源回退请求;根据所述数值资源回退请求获取回退的批次号;解析所述批次号,在数据库中确定与所述批次号匹配的收据号;及根据所述收据号将数值资源从第一账户回退至第二账户。
- 根据权利要求1所述的方法,其特征在于,所述解析所述批次号,在数据库中确定与所述批次号匹配的收据号,包括:解析所述批次号,得到解析结果;根据所述解析结果查询与所述批次号对应的数据库,并在所述数据库中得到与所述批次号对应的数据表;及从所述数据表中确定与所述批次号匹配的收据号。
- 根据权利要求2所述的方法,其特征在于,所述解析所述批次号,得到解析结果,包括:解析所述批次号,得到所述批次号的部门编号及序列号;所述根据所述解析结果查询与所述批次号对应的数据库,并在所述数据库中得到与所述批次号对应的数据表,包括:查询与所述部门编号对应的数据库;读取所述数据库中各个数据表对应的序列号数值区间;及将所述序列号与读取的各个序列号数值区间进行一一比对,并获取序列号所处的序列号数值区间对应的数据表。
- 根据权利要求2所述的方法,其特征在于,所述数据表包括数值资源实际转移表;所述根据所述收据号将数值资源从第一账户回退至第二账户,包括:在所述数值资源实际转移表中获取与所述批次号匹配的收据号的第一转移记录;根据所述第一转移记录逐一确定各个收据号的转移状态;统计转移状态为已转移的收据号对应的总资源额度;及从第一账户提取与所述总资源额度匹配的数值资源,并回退至第二账户。
- 根据权利要求4所述的方法,其特征在于,所述数据表还包括数值资源计划转移 表;在所述从第一账户提取与所述总资源额度匹配的数值资源,并回退至第二账户之后,所述方法还包括:在所述数值资源实际转移表中生成与所述转移状态为已转移的收据号对应的回退记录;在所述数值资源计划转移表中获取与所述批次号匹配的收据号的第二转移记录;及将所述第二转移记录中与所述回退记录对应的收据号的有效标志位置为无效,并生成相应的待转移记录,将所述待转移记录的收据号置为空。
- 一种数值资源回退装置,包括:接收模块,用于接收数值资源回退请求;批次号获取模块,用于根据所述数值资源回退请求获取回退的批次号;确定模块,用于解析所述批次号,在数据库中确定与所述批次号匹配的收据号;及回退模块,用于根据所述收据号将数值资源从第一账户回退至第二账户。
- 根据权利要求6所述的装置,其特征在于,所述确定模块,包括:解析单元,用于解析所述批次号,得到解析结果;查询单元,用于根据所述解析结果查询与所述批次号对应的数据库,并在所述数据库中得到与所述批次号对应的数据表;及确定单元,用于从所述数据表中确定与所述批次号匹配的收据号。
- 根据权利要求7所述的装置,其特征在于,所述解析单元,还用于解析所述批次号,得到所述批次号的部门编号及序列号;所述查询单元,包括:数据库查询子单元,用于查询与所述部门编号对应的数据库;读取子单元,用于读取所述数据库中各个数据表对应的序列号数值区间;及比对子单元,用于将所述序列号与读取的各个序列号数值区间进行一一比对,并获取序列号所处的序列号数值区间对应的数据表。
- 根据权利要求7所述的装置,其特征在于,所述数据表包括数值资源实际转移表及数值资源计划转移表;所述回退模块,包括:记录获取单元,用于在所述数值资源实际转移表中获取与所述批次号匹配的收据号的第一转移记录;状态确定单元,用于根据所述第一转移记录逐一确定各个收据号的转移状态;统计单元,用于统计转移状态为已转移的收据号对应的总资源额度;及回退单元,用于从第一账户提取与所述总资源额度匹配的数值资源,并回退至第二账户。
- 根据权利要求9所述的装置,其特征在于,还包括:第一生成模块,用于在所述数值资源实际转移表中生成与所述转移状态为已转移的收据号对应的回退记录;记录获取模块,用于在所述数值资源计划转移表中获取与所述批次号匹配的收据号的第二转移记录;及第二生成模块,用于将所述第二转移记录中与所述回退记录对应的收据号的有效标志位置为无效,并生成相应的待转移记录,将所述待转移记录的收据号置为空。
- 一种服务器,包括存储器和一个或多个处理器,所述存储器中储存有计算机可读指令,所述计算机可读指令被所述一个或多个处理器执行时,使得所述一个或多个处理器执行以下步骤:接收数值资源回退请求;根据所述数值资源回退请求获取回退的批次号;解析所述批次号,在数据库中确定与所述批次号匹配的收据号;及根据所述收据号将数值资源从第一账户回退至第二账户。
- 根据权利要求11所述的服务器,其特征在于,所述解析所述批次号,在数据库中确定与所述批次号匹配的收据号,包括:解析所述批次号,得到解析结果;根据所述解析结果查询与所述批次号对应的数据库,并在所述数据库中得到与所述批次号对应的数据表;及从所述数据表中确定与所述批次号匹配的收据号。
- 根据权利要求12所述的服务器,其特征在于,所述解析所述批次号,得到解析结果,包括:解析所述批次号,得到所述批次号的部门编号及序列号;所述根据所述解析结果查询与所述批次号对应的数据库,并在所述数据库中得到与所 述批次号对应的数据表,包括:查询与所述部门编号对应的数据库;读取所述数据库中各个数据表对应的序列号数值区间;及将所述序列号与读取的各个序列号数值区间进行一一比对,并获取序列号所处的序列号数值区间对应的数据表。
- 根据权利要求12所述的服务器,其特征在于,所述数据表包括数值资源实际转移表;所述根据所述收据号将数值资源从第一账户回退至第二账户,包括:在所述数值资源实际转移表中获取与所述批次号匹配的收据号的第一转移记录;根据所述第一转移记录逐一确定各个收据号的转移状态;统计转移状态为已转移的收据号对应的总资源额度;及从第一账户提取与所述总资源额度匹配的数值资源,并回退至第二账户。
- 根据权利要求14所述的服务器,其特征在于,所述数据表还包括数值资源计划转移表;所述计算机可读指令被所述处理器执行时,使得所述处理器在执行所述从第一账户提取与所述总资源额度匹配的数值资源,并回退至第二账户之后,还执行以下步骤:在所述数值资源实际转移表中生成与所述转移状态为已转移的收据号对应的回退记录;在所述数值资源计划转移表中获取与所述批次号匹配的收据号的第二转移记录;及将所述第二转移记录中与所述回退记录对应的收据号的有效标志位置为无效,并生成相应的待转移记录,将所述待转移记录的收据号置为空。
- 一个或多个存储有计算机可读指令的非易失性计算机可读存储介质,所述计算机可读指令被一个或多个处理器执行时,使得所述一个或多个处理器执行以下步骤:接收数值资源回退请求;根据所述数值资源回退请求获取回退的批次号;解析所述批次号,在数据库中确定与所述批次号匹配的收据号;及根据所述收据号将数值资源从第一账户回退至第二账户。
- 根据权利要求16所述的存储介质,其特征在于,所述解析所述批次号,在数据库中确定与所述批次号匹配的收据号,包括:解析所述批次号,得到解析结果;根据所述解析结果查询与所述批次号对应的数据库,并在所述数据库中得到与所述批次号对应的数据表;及从所述数据表中确定与所述批次号匹配的收据号。
- 根据权利要求17所述的存储介质,其特征在于,所述解析所述批次号,得到解析结果,包括:解析所述批次号,得到所述批次号的部门编号及序列号;所述根据所述解析结果查询与所述批次号对应的数据库,并在所述数据库中得到与所述批次号对应的数据表,包括:查询与所述部门编号对应的数据库;读取所述数据库中各个数据表对应的序列号数值区间;及将所述序列号与读取的各个序列号数值区间进行一一比对,并获取序列号所处的序列号数值区间对应的数据表。
- 根据权利要求17所述的存储介质,其特征在于,所述数据表包括数值资源实际转移表;所述根据所述收据号将数值资源从第一账户回退至第二账户,包括:在所述数值资源实际转移表中获取与所述批次号匹配的收据号的第一转移记录;根据所述第一转移记录逐一确定各个收据号的转移状态;统计转移状态为已转移的收据号对应的总资源额度;及从第一账户提取与所述总资源额度匹配的数值资源,并回退至第二账户。
- 根据权利要求19所述的存储介质,其特征在于,所述数据表还包括数值资源计划转移表;所述计算机可读指令被所述处理器执行时,使得所述处理器在执行所述从第一账户提取与所述总资源额度匹配的数值资源,并回退至第二账户之后,还执行以下步骤:在所述数值资源实际转移表中生成与所述转移状态为已转移的收据号对应的回退记录;在所述数值资源计划转移表中获取与所述批次号匹配的收据号的第二转移记录;及将所述第二转移记录中与所述回退记录对应的收据号的有效标志位置为无效,并生成相应的待转移记录,将所述待转移记录的收据号置为空。
Applications Claiming Priority (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710629161.0A CN108256839B (zh) | 2017-07-28 | 2017-07-28 | 数值资源回退方法、装置、服务器及存储介质 |
| CN201710629161.0 | 2017-07-28 |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| WO2019019697A1 true WO2019019697A1 (zh) | 2019-01-31 |
Family
ID=62722197
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| PCT/CN2018/082480 Ceased WO2019019697A1 (zh) | 2017-07-28 | 2018-04-10 | 数值资源回退方法、装置、服务器和存储介质 |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN108256839B (zh) |
| WO (1) | WO2019019697A1 (zh) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111192036B (zh) * | 2019-08-01 | 2023-06-20 | 腾讯科技(深圳)有限公司 | 账号资源更新方法、装置、计算机设备以及存储介质 |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103578029A (zh) * | 2012-07-31 | 2014-02-12 | Ncr公司 | 货币跟踪 |
| CN104036595A (zh) * | 2013-03-08 | 2014-09-10 | 乐金信世股份有限公司 | 用于手续费收退款的金融自动化设备、方法和系统 |
| US20150019277A1 (en) * | 2012-10-02 | 2015-01-15 | DRW Legal Lumping Enterprises, Inc. | Method and system for automating lumping services management |
-
2017
- 2017-07-28 CN CN201710629161.0A patent/CN108256839B/zh active Active
-
2018
- 2018-04-10 WO PCT/CN2018/082480 patent/WO2019019697A1/zh not_active Ceased
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103578029A (zh) * | 2012-07-31 | 2014-02-12 | Ncr公司 | 货币跟踪 |
| US20150019277A1 (en) * | 2012-10-02 | 2015-01-15 | DRW Legal Lumping Enterprises, Inc. | Method and system for automating lumping services management |
| CN104036595A (zh) * | 2013-03-08 | 2014-09-10 | 乐金信世股份有限公司 | 用于手续费收退款的金融自动化设备、方法和系统 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108256839B (zh) | 2020-11-24 |
| CN108256839A (zh) | 2018-07-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111177302B (zh) | 业务单据处理方法、装置、计算机设备和存储介质 | |
| CN108734453B (zh) | 区块链数据处理方法、装置、计算机设备和存储介质 | |
| CN111274252B (zh) | 一种区块链的数据上链方法、装置、存储介质和服务器 | |
| CN110727727B (zh) | 一种数据库的统计方法及装置 | |
| CN113468226A (zh) | 一种业务处理方法、装置、电子设备和存储介质 | |
| CN106874320A (zh) | 分布式流式数据处理的方法和装置 | |
| CN104104717A (zh) | 投放渠道数据统计方法及装置 | |
| CN112506486A (zh) | 搜索系统建立方法、装置、电子设备及可读存储介质 | |
| WO2020140662A1 (zh) | 数据表填补方法、装置、计算机设备和存储介质 | |
| WO2022179377A1 (zh) | 一种raid 5校验值的更新方法、装置和介质 | |
| WO2019100853A1 (zh) | 分页查询方法及装置和电子设备 | |
| CN110795475A (zh) | 报表生成方法、装置、计算机设备和存储介质 | |
| CN116783588A (zh) | 用于大元数据管理的列技术 | |
| CN111414427B (zh) | 一种适用于准实时服务的数据处理方法及装置 | |
| CN115525652A (zh) | 用户访问数据处理方法及装置 | |
| WO2019033741A1 (zh) | 投资产品的资源处理方法、装置、存储介质和计算机设备 | |
| CN111259053A (zh) | 一种账单查询的方法及装置 | |
| CN110555021A (zh) | 数据存储方法、查询方法及相关装置 | |
| CN107451301B (zh) | 实时投递账单邮件的处理方法、装置、设备和存储介质 | |
| CN104424325A (zh) | 数据查询方法和装置 | |
| CN116303657B (zh) | 群体画像生成方法、装置、计算机设备和存储介质 | |
| CN111046240B (zh) | 网关流量统计方法、装置、计算机设备和存储介质 | |
| CN115098738B (zh) | 业务数据的提取方法、装置、存储介质及电子设备 | |
| CN115185573A (zh) | 应用配置信息的配置方法、装置、计算机设备和存储介质 | |
| WO2019019697A1 (zh) | 数值资源回退方法、装置、服务器和存储介质 |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| 121 | Ep: the epo has been informed by wipo that ep was designated in this application |
Ref document number: 18838886 Country of ref document: EP Kind code of ref document: A1 |
|
| NENP | Non-entry into the national phase |
Ref country code: DE |
|
| 122 | Ep: pct application non-entry in european phase |
Ref document number: 18838886 Country of ref document: EP Kind code of ref document: A1 |
|
| 32PN | Ep: public notification in the ep bulletin as address of the adressee cannot be established |
Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC , EPO FORM 1205A DATED 05.08.2020. |
|
| 122 | Ep: pct application non-entry in european phase |
Ref document number: 18838886 Country of ref document: EP Kind code of ref document: A1 |