WO2017114243A1 - 一种卡号数据的处理方法及装置 - Google Patents

一种卡号数据的处理方法及装置 Download PDF

Info

Publication number
WO2017114243A1
WO2017114243A1 PCT/CN2016/111143 CN2016111143W WO2017114243A1 WO 2017114243 A1 WO2017114243 A1 WO 2017114243A1 CN 2016111143 W CN2016111143 W CN 2016111143W WO 2017114243 A1 WO2017114243 A1 WO 2017114243A1
Authority
WO
WIPO (PCT)
Prior art keywords
card number
table group
card
expiration time
information
Prior art date
Application number
PCT/CN2016/111143
Other languages
English (en)
French (fr)
Inventor
刘宾
伍剑钊
傅宜生
史桂枝
Original Assignee
中国银联股份有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 中国银联股份有限公司 filed Critical 中国银联股份有限公司
Priority to US16/067,246 priority Critical patent/US10922680B2/en
Publication of WO2017114243A1 publication Critical patent/WO2017114243A1/zh

Links

Images

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/23—Updating
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q20/00—Payment architectures, schemes or protocols
    • G06Q20/30—Payment architectures, schemes or protocols characterised by the use of specific devices or networks
    • G06Q20/34—Payment architectures, schemes or protocols characterised by the use of specific devices or networks using cards, e.g. integrated circuit [IC] cards or magnetic cards
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • 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/21—Design, administration or maintenance of databases
    • G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
    • 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/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2282—Tablespace storage structures; Management thereof
    • 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/23—Updating
    • G06F16/2365—Ensuring data consistency and integrity
    • 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
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q20/00—Payment architectures, schemes or protocols
    • G06Q20/08—Payment architectures
    • G06Q20/10—Payment architectures specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
    • G06Q20/108—Remote banking, e.g. home banking

Definitions

  • the present invention relates to the field of the Internet, and in particular, to a method and an apparatus for processing card number data.
  • the bank card number includes the card BIN (Bank Identification Number) value, the serial number and the check digit.
  • the card BIN 101 is a card issuing bank identification code, which is mainly used to identify the card issuing institution and card type information;
  • the serial number 102 is a random number sequence other than the card BIN value and the check digit, and is mainly used for distinguishing.
  • each bank card entity corresponds to a unique serial number;
  • the check digit 103 is mainly used to verify the legality of the card number.
  • the table storage card number and related data are mainly performed in accordance with the chronological order of the serial number.
  • the card number data can only be transferred or cleaned one by one, resulting in low efficiency and high cost of cleaning and maintenance.
  • the existing card number data processing method has low cleaning and maintenance efficiency and high cost.
  • the invention provides a method and a device for processing card number data, which are used to solve the problem that the card number data processing method in the prior art has low cleaning and maintenance efficiency and high cost.
  • the embodiment of the invention provides a method for processing card number data, including:
  • the table group is composed of multiple card number storage tables, each table The group corresponds to an expiration time, and the failure time corresponding to all the card numbers in the table group is the same as the expiration time corresponding to the table group, and the card number information includes a card number and data associated with the card number;
  • the card number includes a serial number assigned when the card number is generated
  • the method further includes:
  • the method before determining the card group corresponding to the card number according to the expiration time corresponding to the card number, the method further includes:
  • the table group storage control table determining, according to the mapping relationship between the time information and the table group, the table group corresponding to the time information, and storing the mapping relationship between the time information and the table group in the table group storage control table; wherein the time information includes multiple expiration times, each The expiration time corresponds to a table group;
  • the table group corresponding to the expiration time is queried in the table group storage control table, and the table group corresponding to the expiration time is cleared.
  • the card number includes: assigning a service segment number according to the service information when the card number is generated;
  • the method further includes:
  • the embodiment of the invention further provides a processing device for card number data, comprising:
  • a determining module configured to determine, according to a failure time corresponding to the card number, a table group corresponding to the card number, and place the card number information corresponding to the card number in at least one card number storage table of the table group; wherein the table group is configured by multiple card numbers Each of the table groups corresponds to one expiration time, and the expiration time corresponding to all the card numbers in the table group is the same as the expiration time corresponding to the table group, and the card number information includes a card number and data associated with the card number;
  • the cleaning module is configured to clean all the card number information in the table group after the expiration time corresponding to a table group is reached.
  • the card number includes a serial number assigned when the card number is generated
  • the determining module is further configured to:
  • the determining module is further configured to:
  • the table group storage control table determining, according to the mapping relationship between the time information and the table group, the table group corresponding to the time information, and storing the mapping relationship between the time information and the table group in the table group storage control table; wherein the time information includes multiple expiration times, each The expiration time corresponds to a table group;
  • the table group corresponding to the expiration time is queried in the table group storage control table, and the table group corresponding to the expiration time is cleared.
  • the card number includes: assigning a service segment number according to the service information when the card number is generated;
  • the cleaning module is further configured to:
  • the determining module is further configured to:
  • An embodiment of the present invention further provides an electronic device, including: a transceiver, a processor, a memory, and a bus interface, wherein a processor, a memory, and a transceiver are connected through a bus interface;
  • the memory is configured to store one or more executable programs, and may store data used by the processor when performing operations;
  • the processor is configured to read a program in the memory, and execute the following method: determining, according to a failure time corresponding to the card number, a table group corresponding to the card number, and placing the card number information corresponding to the card number in the table group a card number storage table; wherein the table group is composed of a plurality of card number storage tables, each table group corresponding to an expiration time, and the failure time corresponding to all the card numbers in the table group is the same as the expiration time corresponding to the table group,
  • the card number information includes a card number and data associated with the card number; after the expiration time corresponding to a table group is reached, all the card number information in the table group is cleaned.
  • the transceiver is configured to send and receive data used by the processor when performing an operation
  • the bus interface is for providing an interface.
  • the card number includes a serial number assigned when the card number is generated
  • the processor is further configured to:
  • the processor is further configured to:
  • the table group corresponding to the expiration time is queried in the table group storage control table, and the table group corresponding to the expiration time is cleared.
  • the card number includes a service segment number allocated according to service information when the card number is generated;
  • the processor is further configured to:
  • the processor is further configured to:
  • the embodiment of the present invention provides a method and a device for processing card number data.
  • the table group corresponding to the card number is determined according to the expiration time corresponding to the card number, and the card number information corresponding to the card number is placed in at least one card number storage table of the table group.
  • the table group is composed of a plurality of card number storage tables, each table group corresponding to one expiration time, and all the card numbers in the table group corresponding to the expiration time is the same as the expiration time corresponding to the table group, and the card number information includes the card number and Data associated with the card number; after the expiration time corresponding to a table group is reached, all card number information in the table group is cleaned.
  • the method and device for processing the card number data provided by the embodiment of the present invention, by classifying and storing the card number information, performing cleaning operations on all the card number information having the same expiration time in the table group, thereby improving the cleaning and maintenance efficiency of the card number data processing method and reducing Maintenance costs.
  • FIG. 1 is a schematic diagram of a card number composition provided by the prior art
  • FIG. 2 is a schematic flowchart of a method for processing card number data according to an embodiment of the present invention
  • FIG. 3 is a schematic diagram of a card number composition according to an embodiment of the present invention.
  • FIG. 4 is a flowchart of a method for clearing card number data according to an embodiment of the present invention.
  • FIG. 5 is a flowchart of a method for querying and updating a card number data according to an embodiment of the present invention
  • FIG. 6 is a schematic structural diagram of a device for processing card number data according to an embodiment of the present disclosure
  • FIG. 7 is a structural diagram of a device for processing card number data according to an embodiment of the present invention.
  • FIG. 8 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
  • FIG. 2 is a schematic flowchart showing a method for processing card number data according to an embodiment of the present invention, including:
  • Step 201 Determine the table group corresponding to the card number according to the expiration time corresponding to the card number, and place the card number information corresponding to the card number in at least one card number storage table of the table group.
  • Step 202 After the expiration time corresponding to a table group is reached, all the card number information in the table group is cleaned.
  • the table group is composed of a plurality of card number storage tables, each table group corresponding to one expiration time, and the expiration time corresponding to all the card numbers in the table group is the same as the expiration time corresponding to the table group, and the card number information includes the card number and the data associated with the card number. .
  • the system first determines the table group corresponding to the time information according to the mapping relationship between the time information and the table group, and stores the mapping relationship between the time information and the table group in the table group storage control table;
  • Each table group includes a plurality of card number storage tables, and the time information includes a plurality of expiration times, and each expiration time corresponds to one table group.
  • the unit of the expiration time includes, but is not limited to, seconds, minutes, hours, and days, weeks, months, and years. It should be noted that the expiration time in the embodiment of the present invention may be a time point or a time period.
  • the system generates a table group from October 1, 2015 to October 1, 2016.
  • the expiration time is in units of days, that is, 365 table groups are generated, and the expiration time of each table group corresponds to one day in 365 days.
  • the table group may include a plurality of card number storage tables. If the failure time is October 1, 2015, the corresponding table group is G20151001. If the table group G20151001 includes 100 card number storage tables, the card number storage table in the table group G20151001 can be allocated from G2015100100 to G2015100199, and according to the system storage space, Allocate the corresponding memory space for each card number storage table.
  • the system when the user binds the credit card to the online bank, enter the valid date corresponding to the credit card, for example, on October 1, 2015, the system generates the card number according to the set rule, and looks for the expiration time in the table group storage control table as 2015. If the corresponding table group on the first day of the month is G20151001, the related data corresponding to the card number is stored in a card number storage table in the table group G20151001.
  • the table group corresponding to the expiration time is queried in the table group storage control table, and the table group corresponding to the expiration time is cleared. For example, when the expiration time arrives on October 1, 2015, the table group G20151001 is cleaned up, that is, the card number in all the card number storage tables in the table group and the data associated with the card number are cleared.
  • FIG. 3 is a schematic diagram of a card number composition according to an embodiment of the present invention. As shown in FIG. 3, the card number includes five parts, a card BIN 301, a service segment number 302, a segment number 303, a serial number 304, and a check digit 305.
  • the card BIN 301 is a card issuing bank identification code, which is mainly used to identify the card issuing institution and card type information.
  • the card BIN 301 consists of 6 digits. It starts with the number "4" and belongs to the VISA (Visa) card organization. The number "5" starts with the MasterCard card organization, with the numbers "9", "62” and " The beginning of 60" belongs to China UnionPay. For example, a card with a card BIN value of 622575 belongs to China Merchants Bank Credit Card.
  • the service number includes a service segment number 302 and a segment internal number 303.
  • the service segment number 302 is generated based on the service information, and the service segment number 302 can be composed of 2 to 6 digits.
  • the card is divided into a Puka, a gold card, and a credit card, and the service segment number 302 of the Puka card may be set to 1000, the service segment number of the gold card is 1001, and the service segment number of the credit card is 1002. .
  • the serial number 303 in the segment is classified according to the service development condition for the same service according to the different expiration time, and the serial number 303 in the segment may be composed of 2 to 4 digits. For example, if the expiration time is 01 on October 1, 2015, the serial number 303 is 01, and the expiration time is 0. The corresponding serial number 303 in the segment on October 2, 2015 is 02, and the invalidation time is October 1, 2015. The business number of the gold card is 100101, and the invalidation time is October 2, 2015. The corresponding Puka business number is 10002.
  • the service segment number and the serial number in the segment can be changed according to the development of the business. For example, a serial number in a two-digit segment cannot satisfy the business requirement, and the serial number in the segment can be increased to three digits.
  • the service segment number with the highest priority in the same service number can be generated first.
  • the serial number 304 is a random number sequence, and the serial number 304 can be composed of 3 to 6 digits, which is assigned by the card number distribution system, and is mainly used to distinguish different card number entities of the same card BIN value; in addition, according to the setting rule of the serial number 303 (For example, the time at which the serial number 304 is assigned), it is determined that the card number corresponds to the stored card number storage table number.
  • the check digit 305 is mainly used to verify the legality of the card number, and the check digit is 1 bit, and the number before the check digit can be calculated by the Luhn algorithm.
  • step 201 after determining the table group corresponding to the card number according to the expiration time corresponding to the card number, determining the card number storage table in the table group corresponding to the card number according to the table group and the serial number, and storing the card number information in the determined card number storage table.
  • the table group corresponding to the card number with the expiration time of October 1, 2015 is G20151001
  • the serial number assigned when the card number is generated is 200102, according to the serial number 200102.
  • the allocation time is such that the card number corresponds to the first card number storage table in the table group G20151001, and thus the card number information is stored in the card number storage table G2015100100.
  • step 202 after the expiration time corresponding to a table group is reached, the table group corresponding to the expiration time is determined; according to the mapping relationship between the service segment number and the table group, all the service segment numbers corresponding to the table group are determined; and all the determined services are recovered. Segment number.
  • the card number A represents a card in the personal gold card
  • the service segment number is 100101
  • the card number B represents a card in the business card
  • the service segment number is 100003. If the expiration date corresponding to the card A and the card B is October 1, 2010, the service segment number 1001 and the service segment number 1000 are simultaneously cleaned when the table group G20151001 is cleaned up according to the mapping relationship between the service segment number and the table group.
  • the memory space of the card number storage table in the cleaned table group can be released to store the newly generated card number data, and the cleared service segment number can be recycled for the allocation of the service segment number of the newly generated card.
  • the service segment number and the serial number corresponding to the card number to be queried are determined first; and the service segment number is determined according to the mapping relationship between the service segment number and the table group.
  • the table group; according to the serial number, the card number storage table of the storage card number is obtained from the determined table group; and the data associated with the card number is obtained from the determined card number storage table.
  • the card number A when querying the card number A, first determine the service segment number and the serial number in the card number. If the service segment number is 1001, the serial number is 200102. Then, according to the mapping relationship between the service segment number 1001 and the table group, the table group corresponding to the card number A is G20151001, and then the card number A corresponding to the card number storage table is G2015100100 according to the serial number 200102. Finally, in the card number storage table G2015100100, the data associated with the card number A, such as the account amount, etc., is queried.
  • the embodiment of the present invention provides a method for processing card number data, and determining a table group corresponding to the card number according to the expiration time corresponding to the card number, and placing the card number information corresponding to the card number in at least one card number storage table of the table group;
  • the card group is composed of a plurality of card number storage tables, each table group corresponding to one expiration time, and the expiration time corresponding to all the card numbers in the table group is the same as the expiration time corresponding to the table group, and the card number information includes the card number and the card number.
  • the method for processing the card number data provided by the embodiment of the invention can improve the cleaning and maintenance efficiency of the card number data processing method and reduce the maintenance this.
  • FIG. 4 is a flowchart of a method for clearing card number data according to an embodiment of the present invention. As shown in FIG. 4, the method includes:
  • Step 401 After the expiration time corresponding to a table group is reached, query the table group corresponding to the expiration time in the table group storage control table, and clear the table group corresponding to the expiration time.
  • the table group G20151001 is cleaned up, that is, the card number in all the card number storage tables in the table group and the data associated with the card number are cleared.
  • Step 402 Determine, according to the mapping relationship between the service segment number and the table group, all the service segment numbers corresponding to the table group; and recover all the determined service segment numbers.
  • the card number A represents a card in the personal gold card
  • the service segment number is 1001
  • the card number B represents a card in the business card
  • the service segment number is 1000. If the expiration date corresponding to the card A and the card B is October 1, 2010, the service segment number 1001 and the service segment number 1000 are simultaneously cleaned when the table group G20151001 is cleaned up according to the mapping relationship between the service segment number and the table group.
  • the memory space of the card number storage table in the cleaned table group can be released to store the newly generated card number data, and the cleared service segment number can be used for the allocation of the service segment number of the newly generated card.
  • FIG. 5 is a flowchart of a card number data query update method according to an embodiment of the present invention. As shown in FIG. 5, the method includes:
  • Step 501 Determine a service segment number and a serial number corresponding to the card number to be queried;
  • Step 502 Determine, according to the mapping relationship between the service segment number and the table group, the table group corresponding to the service segment number.
  • Step 503 Obtain a card number storage table of the storage card number from the determined table group according to the serial number;
  • Step 504 Obtain data associated with the card number from the determined card number storage table.
  • the card number A when querying the card number A, first determine the service segment number and the serial number in the card number. If the service segment number is 1001, the serial number is 200102. Then, according to the mapping relationship between the service segment number 1001 and the table group, the table group corresponding to the card number A is G20151001, and then the card number A corresponding to the card number storage table is G2015100100 according to the serial number 200102. Finally in the card number storage table In G2015100100, query the data associated with card number A, such as the account amount.
  • FIG. 6 is a schematic structural diagram of a device for processing card number data according to an embodiment of the present invention, including:
  • the determining module 601 is configured to determine, according to the expiration time corresponding to the card number, a table group corresponding to the card number, and place the card number information corresponding to the card number in at least one card number storage table of the table group; wherein the table group is stored by multiple card numbers
  • the table composition, each table group corresponding to one expiration time, the failure time corresponding to all the card numbers in the table group is the same as the expiration time corresponding to the table group, and the card number information includes a card number and data associated with the card number;
  • the cleaning module 602 is configured to perform a cleaning operation on all the card number information in the table group after the expiration time corresponding to a table group is reached.
  • the card number includes a serial number assigned when the card number is generated
  • the determining module 601 is further configured to:
  • the determining module 601 is further configured to:
  • the table group storage control table determining, according to the mapping relationship between the time information and the table group, the table group corresponding to the time information, and storing the mapping relationship between the time information and the table group in the table group storage control table; wherein the time information includes multiple expiration times, each The expiration time corresponds to a table group;
  • the table group corresponding to the expiration time is queried in the table group storage control table, and the table group corresponding to the expiration time is cleared.
  • the card number includes: assigning a service segment number according to the service information when the card number is generated;
  • the cleaning module 602 is further configured to:
  • the table group corresponding to the expiration time is determined; and the service segment numbers corresponding to the table group are determined according to the mapping relationship between the service segment number and the table group; All business segment numbers.
  • the determining module 601 is further configured to:
  • the embodiment of the present invention provides a device for processing card number data, which determines a table group corresponding to the card number according to the expiration time corresponding to the card number, and places the card number information corresponding to the card number in at least one card number storage table of the table group;
  • the card group is composed of a plurality of card number storage tables, each table group corresponding to one expiration time, and the expiration time corresponding to all the card numbers in the table group is the same as the expiration time corresponding to the table group, and the card number information includes the card number and the card number.
  • the device for processing card number data provided by the embodiment of the invention can improve the cleaning and maintenance efficiency of the card number data processing method and reduce the maintenance cost.
  • FIG. 7 is a structural diagram of a device for processing card number data according to an embodiment of the present invention, including: a table group storage control table 701, a card number storage table 702, and a card number segment allocation control table 703.
  • the system first determines the table group corresponding to the time information according to the mapping relationship between the time information and the table group, and stores the mapping relationship between the time information and the table group in the table group storage control table 701; wherein the time information includes Multiple failure times, each failure time corresponds to a table group.
  • the units of expiration time include, but are not limited to, seconds, minutes, hours, and days, weeks, months, and years.
  • Each of the table groups includes at least one card number storage table 702, and each card number storage table 702 is allocated a corresponding memory space for storing card number information.
  • the table group G20151001 whose failure time is corresponding to October 1, 2015 is obtained. If the table group G20151001 includes 100 card number storage tables 702, the card number storage table 702 in the table group G20151001 can be obtained from G2015100100 is assigned to G2015100199, and corresponding memory space is allocated for each card number storage table 702 according to the system storage space.
  • the failure time corresponding to the card number input by the user is obtained, and according to the expiration time corresponding to the card number, the table group corresponding to the expiration time is queried according to the table group storage control table 701, and the card number information corresponding to the card number is placed in the table group.
  • the card number is stored in the table 702.
  • the valid date corresponding to the credit card is input, for example, on October 1, 2015
  • the system generates the card number according to the set rule, and the invalidation time is 2015 according to the table group storage control table 701. If the corresponding table group on October 1 is G20151001, the related data corresponding to the card number is stored in a card number storage table 702 in the table group G20151001.
  • the table group storage control table 701 queries the table group corresponding to the expiration time, and clears the table group corresponding to the expiration time. For example, when the expiration time arrives on October 1, 2015, the table group G20151001 is cleaned up, that is, the card number in all the card number storage tables 702 in the table group and the data associated with the card number are cleared.
  • the card number segment allocation control table 703 is used to store the card BIN, the allocation of the service segment number, and the mapping relationship between the service segment number and the table group.
  • the service segment number and the serial number corresponding to the card number to be queried are determined first; the mapping relationship between the service segment number and the table group in the control table 703 is determined according to the card number segment, and the table corresponding to the service segment number is determined.
  • the group obtains the card number storage table 702 from the determined table group according to the serial number; and obtains the data associated with the card number from the card number storage table 702.
  • the card number A when querying the card number A, first according to the service segment number and the serial number in the card number, if the service segment number is 100101, the serial number is 200102. According to the mapping relationship between the service segment number 100101 and the table group in the card number segment control table 703, the table group corresponding to the card number A is obtained as G20151001, and then the card number A corresponding to the card number storage table 702 is G2015100100 according to the serial number 200102. In the card number storage table 702G2015100100, the data associated with the card number A, such as the account amount, etc., is queried.
  • an embodiment of the present invention further provides an electronic device, as shown in FIG. 8, including: a transceiver 801, a processor 802, a memory 803, and a bus interface 804, wherein the processor 802, the memory 803, and the transceiver 801 is connected by a bus interface 804;
  • the memory 803 is configured to store one or more executable programs, and may store data used by the processor 802 when performing operations, and may specifically store information including card number information, a table group corresponding to the card number, and a card number storage table. .
  • the processor 802 is configured to read a program in the memory, and perform the following method: determining, according to an expiration time corresponding to the card number, a table group corresponding to the card number, and placing the card number information corresponding to the card number in the table group At least one card number storage table; wherein the table group is composed of a plurality of card number storage tables, each table group corresponding to one expiration time, and the failure time corresponding to all the card numbers in the table group is the same as the expiration time corresponding to the table group,
  • the card number information includes a card number and data associated with the card number; after the expiration time corresponding to a table group is reached, all the card number information in the table group is cleaned.
  • the transceiver 801 is configured to send and receive data used by the processor 802 when performing an operation
  • the bus interface 804 is configured to provide an interface.
  • the card number includes a serial number assigned when the card number is generated
  • the processor 802 is further configured to:
  • processor 802 is further configured to:
  • the table group corresponding to the expiration time is queried in the table group storage control table, and the table group corresponding to the expiration time is cleared.
  • the card number includes a service segment number allocated according to service information when the card number is generated;
  • the processor 802 is further configured to:
  • processor 802 is further configured to:
  • An embodiment of the present invention provides an electronic device, which determines a table group corresponding to a card number according to a failure time corresponding to a card number, and places the card number information corresponding to the card number in at least one card number storage table of the table group; It is composed of a plurality of card number storage tables, each table group corresponding to one expiration time, and all the card numbers in the table group corresponding to the expiration time is the same as the expiration time corresponding to the table group, and the card number information includes the card number and the data associated with the card number. After the expiration time corresponding to a table group is reached, all the card number information in the table group is cleaned.
  • the electronic device provided by the embodiment of the invention can improve the cleaning and maintenance efficiency of the card number data processing method and reduce the maintenance cost.
  • the computer program instructions can also be stored in a computer readable memory that can direct a computer or other programmable data processing device to operate in a particular manner, such that instructions stored in the computer readable memory produce an article of manufacture including an instruction system.
  • the system implements the functions specified in one or more blocks of a flow or a flow and/or block diagram of a flowchart.
  • These computer program instructions can also be loaded onto a computer or other programmable data processing device such that a series of operational steps are performed on a computer or other programmable device to produce computer-implemented processing for execution on a computer or other programmable device.
  • the instructions provide steps for implementing the functions specified in one or more of the flow or in a block or blocks of a flow diagram.

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Accounting & Taxation (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Finance (AREA)
  • General Business, Economics & Management (AREA)
  • Strategic Management (AREA)
  • Computer Networks & Wireless Communication (AREA)
  • Microelectronics & Electronic Packaging (AREA)
  • Software Systems (AREA)
  • Quality & Reliability (AREA)
  • Economics (AREA)
  • Development Economics (AREA)
  • Computational Linguistics (AREA)
  • Computer Security & Cryptography (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

一种卡号数据的处理方法及装置，根据卡号对应的失效时间，确定卡号对应的表组，将所述卡号对应的卡号信息置于所述表组的至少一个卡号存储表中（201）；其中表组由多个卡号存储表组成，每个表组对应一个失效时间，表组中的所有卡号对应的失效时间与所述表组对应的失效时间相同，所述卡号信息包括卡号和与卡号关联的数据；在一个表组对应的失效时间达到后，将所述表组中所有的卡号信息进行清理操作（202）。提供的卡号数据的处理方法及装置，能够提高卡号数据处理方法清理维护效率、降低维护成本。

Description

一种卡号数据的处理方法及装置
本申请要求在2015年12月29日提交中国专利局、申请号为201511019374.9、发明名称为“一种脱机消费的方法及装置”的中国专利申请的优先权，其全部内容通过引用结合在本申请中。
技术领域
本发明涉及互联网领域，尤其涉及一种卡号数据的处理方法及装置。
背景技术
在金融交易中，银行卡卡号包括卡BIN(Bank Identification Number，银行标识代码)值、流水号和校验位三个部分。如图1所示，其中，卡BIN 101是发卡银行识别码，主要用于识别发卡机构和卡类型信息；流水号102是除卡BIN值和校验位以外的随机数字序列，主要用于区分相同卡BIN值的不同卡实体，每张银行卡实体对应唯一的序列号；校验位103主要用于验证卡号的合法性。
随着计算机和网络应用的日益广泛，以及不同领域的业务种类的日益丰富，对包含海量卡号数据的数据库进行分表，并针对各个分表进行查询操作变得越来越重要。目前，在卡号数据量比较大的情况下，为了提高卡号存储、查询以及更新的效率，主要按照流水号的时间顺序进行分表存储卡号及相关数据。然而，在卡号数据生命周期结束时，卡号数据只能逐一进行转移或清理，导致清理维护效率低、成本高。
综上所述，现有的卡号数据处理方法的清理维护效率低、成本高。
发明内容
本发明提供一种卡号数据的处理方法及装置，用以解决现有技术中卡号数据处理方法清理维护效率低、成本高的问题。
本发明实施例提供一种卡号数据的处理方法，包括：
根据卡号对应的失效时间，确定卡号对应的表组，将所述卡号对应的卡号信息置于所述表组的至少一个卡号存储表中；其中表组由多个卡号存储表组成，每个表组对应一个失效时间，表组中的所有卡号对应的失效时间与所述表组对应的失效时间相同，所述卡号信息包括卡号和与卡号关联的数据；
在一个表组对应的失效时间达到后，将所述表组中所有的卡号信息进行清理操作。
可选的，所述卡号包括生成所述卡号时分配的流水号；
所述根据卡号对应的失效时间，确定卡号对应的表组之后，还包括：
根据所述表组和所述流水号，确定所述卡号对应的表组中的卡号存储表，将所述卡号信息存储在所述确定的卡号存储表中。
可选的，所述根据卡号对应的失效时间，确定卡号对应的表组之前，还包括：
根据时间信息与表组的映射关系，确定时间信息对应的表组，将所述时间信息与表组的映射关系存储在表组存储控制表中；其中，时间信息中包括多个失效时间，每个失效时间对应一个表组；
所述在一个表组对应的失效时间达到后，将所述表组中所有的卡号信息进行清理操作，包括：
在一个表组对应的失效时间达到后，在表组存储控制表中查询所述失效时间对应的表组，并清除所述失效时间对应的表组。
可选的，所述卡号包括生成所述卡号时根据业务信息分配业务段号；
所述在一个表组对应的失效时间达到后，将所述表组中所有的卡号信息进行清理操作，还包括：
在一个表组对应的失效时间达到后，确定所述失效时间对应的表组；
根据业务段号和表组的映射关系，确定所述表组对应的所有业务段号；
回收确定的所有业务段号。
可选的，所述方法还包括：
确定需要查询的卡号对应的业务段号和流水号；
根据所述业务段号和表组的映射关系，确定所述业务段号对应的表组；
根据所述流水号，从确定的所述表组中获取存储所述卡号的卡号存储表；
从确定的所述卡号存储表中获取所述卡号关联的数据。
本发明实施例还提供一种卡号数据的处理装置，包括：
确定模块：用于根据卡号对应的失效时间，确定卡号对应的表组，将所述卡号对应的卡号信息置于所述表组的至少一个卡号存储表中；其中表组由多个卡号存储表组成，每个表组对应一个失效时间，表组中的所有卡号对应的失效时间与所述表组对应的失效时间相同，所述卡号信息包括卡号和与卡号关联的数据；
清理模块：用于在一个表组对应的失效时间达到后，将所述表组中所有的卡号信息进行清理操作。
可选的，所述卡号包括生成所述卡号时分配的流水号；
所述确定模块，还用于：
根据所述表组和所述流水号，确定所述卡号对应的表组中的卡号存储表，将所述卡号信息存储在所述确定的卡号存储表中。
可选的，所述确定模块，还用于：
根据时间信息与表组的映射关系，确定时间信息对应的表组，将所述时间信息与表组的映射关系存储在表组存储控制表中；其中，时间信息中包括多个失效时间，每个失效时间对应一个表组；
所述在一个表组对应的失效时间达到后，将所述表组中所有的卡号信息进行清理操作，包括：
在一个表组对应的失效时间达到后，在表组存储控制表中查询所述失效时间对应的表组，并清除所述失效时间对应的表组。
可选的，所述卡号包括生成所述卡号时根据业务信息分配业务段号；
所述清理模块，还用于：
在一个表组对应的失效时间达到后，确定所述失效时间对应的表组；根 据业务段号和表组的映射关系，确定所述表组对应的所有业务段号；回收确定的所有业务段号。
可选的，所述确定模块还用于：
确定需要查询的卡号对应的业务段号和流水号；根据所述业务段号和表组的映射关系，确定所述业务段号对应的表组；根据所述流水号，从确定的所述表组中获取存储所述卡号的卡号存储表；从确定的所述卡号存储表中获取所述卡号关联的数据。
本发明实施例还提供一种电子设备，包括：收发机、处理器、存储器、总线接口，其中处理器、存储器与收发机之间通过总线接口连接；
所述存储器，用于存储一个或多个可执行程序，可以存储所述处理器在执行操作时所使用的数据；
所述处理器，用于读取所述存储器中的程序，执行下列方法：根据卡号对应的失效时间，确定卡号对应的表组，将所述卡号对应的卡号信息置于所述表组的至少一个卡号存储表中；其中表组由多个卡号存储表组成，每个表组对应一个失效时间，所述表组中的所有卡号对应的失效时间与所述表组对应的失效时间相同，所述卡号信息包括卡号和与卡号关联的数据；在一个表组对应的失效时间达到后，将所述表组中所有的卡号信息进行清理操作。
所述收发机，用于发送和接收所述处理器在执行操作时所使用的数据；
所述总线接口，用于提供接口。
可选的，所述卡号包括生成所述卡号时分配的流水号；
所述处理器，还用于：
根据所述表组和所述流水号，确定所述卡号对应的表组中的卡号存储表，将所述卡号信息存储在所述确定的卡号存储表中。
可选的，所述处理器，还用于：
根据时间信息与所述表组的映射关系，确定所述时间信息对应的表组，将所述时间信息与所述表组的映射关系存储在表组存储控制表中；其中，所述时间信息中包括多个失效时间，每个失效时间对应一个表组；
在一个表组对应的失效时间达到后，在表组存储控制表中查询所述失效时间对应的表组，并清除所述失效时间对应的表组。
可选的，所述卡号包括生成所述卡号时根据业务信息分配的业务段号；
所述处理器，还用于：
在一个表组对应的失效时间达到后，确定所述失效时间对应的表组；
根据业务段号和表组的映射关系，确定所述表组对应的所有业务段号；
回收确定的所有业务段号。
可选的，所述处理器，还用于：
确定需要查询的卡号对应的业务段号和流水号；
根据所述业务段号和所述表组的映射关系，确定所述业务段号对应的表组；
根据所述流水号，从确定的所述表组中获取存储所述卡号的卡号存储表；
从确定的所述卡号存储表中获取所述卡号关联的数据。
本发明实施例提供了一种卡号数据的处理方法及装置，根据卡号对应的失效时间，确定卡号对应的表组，将所述卡号对应的卡号信息置于所述表组的至少一个卡号存储表中；其中表组由多个卡号存储表组成，每个表组对应一个失效时间，表组中的所有卡号对应的失效时间与所述表组对应的失效时间相同，所述卡号信息包括卡号和与卡号关联的数据；在一个表组对应的失效时间达到后，将所述表组中所有的卡号信息进行清理操作。本发明实施例提供的卡号数据的处理方法及装置，通过对卡号信息进行分类储存，对表组中具有相同失效时间的所有的卡号信息进行清理操作，提高了卡号数据处理方法清理维护效率、降低了维护成本。
附图说明
为了更清楚地说明本发明实施例中的技术方案，下面将对实施例描述中所需要使用的附图作简要介绍，显而易见地，下面描述中的附图仅仅是本发明的一些实施例，对于本领域的普通技术人员来讲，在不付出创造性劳动性 的前提下，还可以根据这些附图获得其他的附图。
图1为现有技术提供的一种卡号组成示意图；
图2为本发明实施例提供的一种卡号数据的处理方法流程示意图；
图3为本发明实施例提供的一种卡号组成示意图；
图4为本发明实施例提供的一种卡号数据清除方法流程图；
图5为本发明实施例提供的一种卡号数据查询更新方法流程图；
图6为本发明实施例提供的一种卡号数据的处理装置结构示意图；
图7为本发明实施例提供的一种卡号数据的处理装置结构图；
图8为本发明实施例提供的一种电子设备结构示意图。
具体实施方式
为了使本发明的目的、技术方案和优点更加清楚，下面将结合附图对本发明作进一步地详细描述，显然，所描述的实施例仅仅是本发明一部份实施例，而不是全部的实施例。基于本发明中的实施例，本领域普通技术人员在没有做出创造性劳动前提下所获得的所有其它实施例，都属于本发明保护的范围。
图2例性的示出了本发明实施例提供的一种卡号数据的处理方法流程示意图，包括：
步骤201：根据卡号对应的失效时间，确定卡号对应的表组，将卡号对应的卡号信息置于表组的至少一个卡号存储表中。
步骤202：在一个表组对应的失效时间达到后，将表组中所有的卡号信息进行清理操作。
其中，表组由多个卡号存储表组成，每个表组对应一个失效时间，表组中的所有卡号对应的失效时间与表组对应的失效时间相同，卡号信息包括卡号和与卡号关联的数据。
具体地，系统首先根据时间信息与表组的映射关系，确定时间信息对应的表组，将所述时间信息与表组的映射关系存储在表组存储控制表中；其中， 每个表组内部包括多张卡号存储表，时间信息包括多个失效时间，每个失效时间对应一个表组。失效时间的单位包括但不限于秒、分钟、小时以及日、周、月份、年份，需要说明的是，本发明实施例中的失效时间可以为时间点，也可以为时间段。
例如，系统生成2015年10月1日至2016年10月1日的表组，失效时间以日为单位，即生成365个表组，每个表组的失效时间对应365天中的一天，每个表组可以包括多张卡号存储表。如失效时间为2015年10月1日对应的表组为G20151001，若表组G20151001包括100张卡号存储表，则表组G20151001中的卡号存储表可以从G2015100100分配至G2015100199，并根据系统存储空间，为每张卡号存储表分配相应的内存空间。
需要说明的是，在数据量非常大或需要按照较小的时间单位再划分等特殊情况下，相同的失效时间也可以对应不同的表组。
具体地，在交易发生时，获取用户输入的卡号对应的失效时间，查找表组存储控制表中该失效时间对应的表组，将卡号对应的卡号信息置于所述表组的至少一个卡号存储表中。
例如，用户将信用卡绑定网上银行时，输入信用卡对应的有效日期，例如为2015年10月1日，系统按设定规则生成卡号，并查找表组存储控制表中的失效时间为2015年10月1日对应的表组为G20151001，则将该卡号对应的相关数据存入表组G20151001中的一张卡号存储表中。
在一个表组对应的失效时间达到后，在表组存储控制表中查询所述失效时间对应的表组，并清除所述失效时间对应的表组。例如，当失效时间2015年10月1日到达，则清理表组G20151001，即清理表组内所有卡号存储表中的卡号及与卡号关联的数据。
进一步地，卡号由一串数字组成，图3为本发明实施例提供的一种卡号组成示意图。如图3所示，卡号包括五部分，卡BIN 301、业务段号302、段内序号303、流水号304、校验位305。
卡BIN 301是发卡银行识别码，主要用于识别发卡机构和卡类型信息。 卡BIN 301由6位数字组成，以数字“4”开头属于VISA(维萨)卡组织，以数字“5”开头属于MasterCard(万事达卡)卡组织，以数字“9”、“62”以及“60”开头属于中国银联。例如，卡BIN值为622575的卡属于招商银行信用卡。
本发明实施例中，业务号包括业务段号302和段内序号303。业务段号302根据业务信息生成，业务段号302可以由2～6位数字组成。例如，根据业务信息将卡分为普卡、金卡、贷记卡，则可以设置普卡的业务段号302为1000，金卡的业务段号为1001，贷记卡的业务段号为1002。
段内序号303为根据业务发展情况对同一个业务按失效时间不同而进行的分类，段内序号303可以由2到4位数字组成。例如，若失效时间为2015年10月1日对应的段内序号303为01，失效时间为2015年10月2日对应的段内序号303为02，则得到失效时间为2015年10月1日的金卡的业务号为100101，失效时间为2015年10月2日对应的普卡的业务号为100002。
需要说明的是，业务段号和段内序号可以根据业务发展的情况进行变更。例如，两位数的段内序号不能满足业务需求，可以将段内序号增加至3位数。此外，在生成卡号时，还需要保存业务段号和表组的映射关系，以便进行卡号信息的查询、更新和清理操作。在生成卡号时，可以优先生成同一业务号内优先级高的业务段号。
流水号304为随机数字序列，流水号304可以由3至6数字组成，由卡号分配系统自行赋值，主要用于区分相同卡BIN值的不同卡号实体；此外，可以根据流水号303的设定规则(例如分配流水号304的时间)，确定出卡号对应存储的卡号存储表号。
校验位305主要用于验证卡号的合法性，校验位为1位，可以通过Luhn算法将校验位之前的数字进行计算得出。
在步骤201中，根据卡号对应的失效时间，确定卡号对应的表组之后，再据表组和流水号，确定卡号对应的表组中的卡号存储表，将卡号信息存储在确定的卡号存储表中。例如，失效时间为2015年10月1日的卡号对应的表组为G20151001，生成卡号时分配的流水号为200102，根据流水号为200102 的分配时间，得到卡号对应为表组G20151001中的第一张卡号存储表，因此将该卡号信息存储在卡号存储表G2015100100中。
在步骤202中，在一个表组对应的失效时间达到后，确定失效时间对应的表组；根据业务段号和表组的映射关系，确定表组对应的所有业务段号；回收确定的所有业务段号。
例如，卡号A代表个人金卡中的一张卡，业务段号为100101，卡号B代表商务普卡中的一张卡，业务段号为100003。若卡A和卡B对应的失效日期都为2010年10月1日，则根据业务段号和表组的映射关系，在清理表组G20151001时，同时清理业务段号1001和业务段号1000。已清理的表组中的卡号存储表的内存空间可以释放以便存储新生成的卡号数据，已清理的业务段号可以回收利用，用于新生成卡的业务段号的分配。
进一步地，在本发明实施例中，对卡号进行查询和变更操作时，首先确定需要查询的卡号对应的业务段号和流水号；根据业务段号和表组的映射关系，确定业务段号对应的表组；根据流水号，从确定的表组中获取存储卡号的卡号存储表；从确定的卡号存储表中获取卡号关联的数据。
例如，在对卡号A进行查询时，首先确定卡号中的业务段号和流水号，若业务段号为1001，流水号为200102。然后根据业务段号1001与表组的映射关系，得到卡号A对应的表组为G20151001，接着根据流水号200102，得到卡号A对应为卡号存储表为G2015100100。最后，在卡号存储表G2015100100中，查询卡号A关联的数据，如账户金额等。
本发明实施例提供了一种卡号数据的处理方法，根据卡号对应的失效时间，确定卡号对应的表组，将所述卡号对应的卡号信息置于所述表组的至少一个卡号存储表中；其中表组由多个卡号存储表组成，每个表组对应一个失效时间，表组中的所有卡号对应的失效时间与所述表组对应的失效时间相同，所述卡号信息包括卡号和与卡号关联的数据；在一个表组对应的失效时间达到后，将所述表组中所有的卡号信息进行清理操作。本发明实施例提供的卡号数据的处理方法，能够提高卡号数据处理方法清理维护效率、降低维护成 本。
下面通过卡号数据的清除过程对本发明实施例的卡号数据的处理方法进行详细说明。图4为本发明实施例提供的一种卡号数据清除方法流程图，如图4所示，包括：
步骤401：在一个表组对应的失效时间达到后，在表组存储控制表中查询所述失效时间对应的表组，并清除所述失效时间对应的表组。
例如，当失效时间2015年10月1日到达，则清理表组G20151001，即清理表组内所有卡号存储表中的卡号及与卡号关联的数据。
步骤402：根据业务段号和表组的映射关系，确定表组对应的所有业务段号；回收确定的所有业务段号。
例如，卡号A代表个人金卡中的一张卡，业务段号为1001，卡号B代表商务普卡中的一张卡，业务段号为1000。若卡A和卡B对应的失效日期都为2010年10月1日，则根据业务段号和表组的映射关系，在清理表组G20151001时，同时清理业务段号1001和业务段号1000。已清理的表组中的卡号存储表的内存空间可以释放以便存储新生成的卡号数据，已清理的业务段号可以用于新生成卡的业务段号的分配。
下面通过卡号数据的查询更新过程对本发明实施例的卡号数据的处理方法进行详细说明。图5为本发明实施例提供的一种卡号数据查询更新方法流程图，如图5所示，包括：
步骤501：确定需要查询的卡号对应的业务段号和流水号；
步骤502：根据业务段号和表组的映射关系，确定业务段号对应的表组；
步骤503：根据流水号，从确定的表组中获取存储卡号的卡号存储表；
步骤504：从确定的卡号存储表中获取卡号关联的数据。
例如，在对卡号A进行查询时，首先确定卡号中的业务段号和流水号，若业务段号为1001，流水号为200102。然后根据业务段号1001与表组的映射关系，得到卡号A对应的表组为G20151001，接着根据流水号200102，得到卡号A对应为卡号存储表为G2015100100。最后在卡号存储表 G2015100100中，查询卡号A关联的数据，如账户金额等。
基于同样的发明构思，本发明实施例还提供一种卡号数据的处理装置，如图6所示，为本发明实施例提供的一种卡号数据的处理装置结构示意图，包括：
确定模块601：用于根据卡号对应的失效时间，确定卡号对应的表组，将所述卡号对应的卡号信息置于所述表组的至少一个卡号存储表中；其中表组由多个卡号存储表组成，每个表组对应一个失效时间，表组中的所有卡号对应的失效时间与所述表组对应的失效时间相同，所述卡号信息包括卡号和与卡号关联的数据；
清理模块602：用于在一个表组对应的失效时间达到后，将所述表组中所有的卡号信息进行清理操作。
可选的，所述卡号包括生成所述卡号时分配的流水号；
所述确定模块601，还用于：
根据所述表组和所述流水号，确定所述卡号对应的表组中的卡号存储表，将所述卡号信息存储在所述确定的卡号存储表中。
可选的，所述确定模块601，还用于：
根据时间信息与表组的映射关系，确定时间信息对应的表组，将所述时间信息与表组的映射关系存储在表组存储控制表中；其中，时间信息中包括多个失效时间，每个失效时间对应一个表组；
所述在一个表组对应的失效时间达到后，将所述表组中所有的卡号信息进行清理操作，包括：
在一个表组对应的失效时间达到后，在表组存储控制表中查询所述失效时间对应的表组，并清除所述失效时间对应的表组。
可选的，所述卡号包括生成所述卡号时根据业务信息分配业务段号；
所述清理模块602，还用于：
在一个表组对应的失效时间达到后，确定所述失效时间对应的表组；根据业务段号和表组的映射关系，确定所述表组对应的所有业务段号；回收确 定的所有业务段号。
可选的，所述确定模块601还用于：
确定需要查询的卡号对应的业务段号和流水号；根据所述业务段号和表组的映射关系，确定所述业务段号对应的表组；根据所述流水号，从确定的所述表组中获取存储所述卡号的卡号存储表；从确定的所述卡号存储表中获取所述卡号关联的数据。
本发明实施例提供了一种卡号数据的处理装置，根据卡号对应的失效时间，确定卡号对应的表组，将所述卡号对应的卡号信息置于所述表组的至少一个卡号存储表中；其中表组由多个卡号存储表组成，每个表组对应一个失效时间，表组中的所有卡号对应的失效时间与所述表组对应的失效时间相同，所述卡号信息包括卡号和与卡号关联的数据；在一个表组对应的失效时间达到后，将所述表组中所有的卡号信息进行清理操作。本发明实施例提供的卡号数据的处理装置，能够提高卡号数据处理方法清理维护效率、降低维护成本。
下面通过具体的应用场景对本发明实施例中的卡号数据的处理装置进行详细说明。如图7为本发明实施例提供的一种卡号数据的处理装置结构图，包括：表组存储控制表701、卡号存储表702、卡号段分配控制表703。
具体地，系统首先根据时间信息与表组的映射关系，确定时间信息对应的表组，将所述时间信息与表组的映射关系存储在表组存储控制表701中；其中，时间信息中包括多个失效时间，每个失效时间对应一个表组。失效时间的单位包括但不限于秒、分钟、小时以及日、周、月份、年份。其中，每个表组包含至少一个卡号存储表702，每个卡号存储表702分配了相应的内存空间以便存储卡号信息。
例如，根据表组存储控制表701，得到失效时间为2015年10月1日对应的表组G20151001，若表组G20151001包括100张卡号存储表702，则表组G20151001中的卡号存储表702可以从G2015100100分配至G2015100199，并根据系统存储空间，为每张卡号存储表702分配相应的内存空间。
在交易发生时，获取用户输入的卡号对应的失效时间，根据卡号对应的失效时间，根据表组存储控制表701查询该失效时间对应的表组，将卡号对应的卡号信息置于所述表组的卡号存储表702中。
例如，用户将信用卡绑定网上银行时，输入信用卡对应的有效日期，例如为2015年10月1日，系统按设定规则生成卡号，并根据表组存储控制表701查询到失效时间为2015年10月1日对应的表组为G20151001，则将该卡号对应的相关数据存入表组G20151001中的一张卡号存储表702中。
在一个表组对应的失效时间达到后，在表组存储控制表701中查询失效时间对应的表组，并清除失效时间对应的表组。例如，当失效时间2015年10月1日到达，则清理表组G20151001，即清理表组内所有卡号存储表702中的卡号及与卡号关联的数据。
卡号段分配控制表703表用来存储卡BIN、业务段号的分配情况，以及业务段号和表组的映射关系。在对卡号进行查询和变更操作时，首先确定需要查询的卡号对应的业务段号和流水号；根据卡号段分配控制表703中业务段号和表组的映射关系，确定业务段号对应的表组；根据流水号，从确定的表组中获取卡号存储表702；从卡号存储表702中获取卡号关联的数据。
例如，在对卡号A进行查询时，首先根据卡号中的业务段号和流水号，若业务段号为100101，流水号为200102。根据卡号段分配控制表703中业务段号100101与表组的映射关系，得到卡号A对应的表组为G20151001，然后根据流水号200102，得到卡号A对应为卡号存储表702为G2015100100。在卡号存储表702G2015100100中，查询卡号A关联的数据，如账户金额等。
基于同样的发明构思，本发明实施例还提供一种电子设备，如图8所示，包括：收发机801、处理器802、存储器803、总线接口804，其中处理器802、存储器803与收发机801之间通过总线接口804连接；
所述存储器803，用于存储一个或多个可执行程序，可以存储所述处理器802在执行操作时所使用的数据，具体可以存储包括卡号信息、卡号对应的表组以及卡号存储表等信息。
所述处理器802，用于读取所述存储器中的程序，执行下列方法：根据卡号对应的失效时间，确定卡号对应的表组，将所述卡号对应的卡号信息置于所述表组的至少一个卡号存储表中；其中表组由多个卡号存储表组成，每个表组对应一个失效时间，所述表组中的所有卡号对应的失效时间与所述表组对应的失效时间相同，所述卡号信息包括卡号和与卡号关联的数据；在一个表组对应的失效时间达到后，将所述表组中所有的卡号信息进行清理操作。
所述收发机801，用于发送和接收所述处理器802在执行操作时所使用的数据；
所述总线接口804，用于提供接口。
可选的，所述卡号包括生成所述卡号时分配的流水号；
所述处理器802，还用于：
根据所述表组和所述流水号，确定所述卡号对应的表组中的卡号存储表，将所述卡号信息存储在所述确定的卡号存储表中。
可选的，所述处理器802，还用于：
根据时间信息与所述表组的映射关系，确定所述时间信息对应的表组，将所述时间信息与所述表组的映射关系存储在表组存储控制表中；其中，所述时间信息中包括多个失效时间，每个失效时间对应一个表组；
在一个表组对应的失效时间达到后，在表组存储控制表中查询所述失效时间对应的表组，并清除所述失效时间对应的表组。
可选的，所述卡号包括生成所述卡号时根据业务信息分配的业务段号；
所述处理器802，还用于：
在一个表组对应的失效时间达到后，确定所述失效时间对应的表组；
根据业务段号和表组的映射关系，确定所述表组对应的所有业务段号；
回收确定的所有业务段号。
可选的，所述处理器802，还用于：
确定需要查询的卡号对应的业务段号和流水号；
根据所述业务段号和所述表组的映射关系，确定所述业务段号对应的表 组；
根据所述流水号，从确定的所述表组中获取存储所述卡号的卡号存储表；
从确定的所述卡号存储表中获取所述卡号关联的数据。
本发明实施例提供了一种电子设备，根据卡号对应的失效时间，确定卡号对应的表组，将所述卡号对应的卡号信息置于所述表组的至少一个卡号存储表中；其中表组由多个卡号存储表组成，每个表组对应一个失效时间，表组中的所有卡号对应的失效时间与所述表组对应的失效时间相同，所述卡号信息包括卡号和与卡号关联的数据；在一个表组对应的失效时间达到后，将所述表组中所有的卡号信息进行清理操作。本发明实施例提供的电子设备，能够提高卡号数据处理方法清理维护效率、降低维护成本。
本发明是参照根据本发明实施例的方法、设备(系统)、和计算机程序产品的流程图和/或方框图来描述的。应理解可由计算机程序指令实现流程图和/或方框图中的每一流程和/或方框、以及流程图和/或方框图中的流程和/或方框的结合。可提供这些计算机程序指令到通用计算机、专用计算机、嵌入式处理机或其他可编程数据处理设备的处理器以产生一个机器，使得通过计算机或其他可编程数据处理设备的处理器执行的指令产生用于实现在流程图一个流程或多个流程和/或方框图一个方框或多个方框中指定的功能的系统。
这些计算机程序指令也可存储在能引导计算机或其他可编程数据处理设备以特定方式工作的计算机可读存储器中，使得存储在该计算机可读存储器中的指令产生包括指令系统的制造品，该指令系统实现在流程图一个流程或多个流程和/或方框图一个方框或多个方框中指定的功能。
这些计算机程序指令也可装载到计算机或其他可编程数据处理设备上，使得在计算机或其他可编程设备上执行一系列操作步骤以产生计算机实现的处理，从而在计算机或其他可编程设备上执行的指令提供用于实现在流程图一个流程或多个流程和/或方框图一个方框或多个方框中指定的功能的步骤。
尽管已描述了本发明的优选实施例，但本领域内的技术人员一旦得知了基本创造性概念，则可对这些实施例作出另外的变更和修改。所以，所附权利要求意欲解释为包括优选实施例以及落入本发明范围的所有变更和修改。
显然，本领域的技术人员可以对本发明进行各种改动和变型而不脱离本发明的精神和范围。这样，倘若本发明的这些修改和变型属于本发明权利要求及其等同技术的范围之内，则本发明也意图包含这些改动和变型在内。

Claims (15)

  1. 一种卡号数据的处理方法，其特征在于，包括：
    根据卡号对应的失效时间，确定卡号对应的表组，将所述卡号对应的卡号信息置于所述表组的至少一个卡号存储表中；其中表组由多个卡号存储表组成，每个表组对应一个失效时间，所述表组中的所有卡号对应的失效时间与所述表组对应的失效时间相同，所述卡号信息包括卡号和与卡号关联的数据；
    在一个表组对应的失效时间达到后，将所述表组中所有的卡号信息进行清理操作。
  2. 如权利要求1所述的方法，其特征在于，所述卡号包括生成所述卡号时分配的流水号；
    所述根据卡号对应的失效时间，确定卡号对应的表组之后，还包括：
    根据所述表组和所述流水号，确定所述卡号对应的表组中的卡号存储表，将所述卡号信息存储在所述确定的卡号存储表中。
  3. 如权利要求2所述的方法，其特征在于，所述根据卡号对应的失效时间，确定卡号对应的表组之前，还包括：
    根据时间信息与所述表组的映射关系，确定所述时间信息对应的表组，将所述时间信息与所述表组的映射关系存储在表组存储控制表中；其中，所述时间信息中包括多个失效时间，每个失效时间对应一个表组；
    所述在一个表组对应的失效时间达到后，将所述表组中所有的卡号信息进行清理操作，包括：
    在一个表组对应的失效时间达到后，在表组存储控制表中查询所述失效时间对应的表组，并清除所述失效时间对应的表组。
  4. 如权利要求2所述的方法，其特征在于，所述卡号包括生成所述卡号时根据业务信息分配的业务段号；
    所述在一个表组对应的失效时间达到后，将所述表组中所有的卡号信息 进行清理操作，还包括：
    在一个表组对应的失效时间达到后，确定所述失效时间对应的表组；
    根据业务段号和表组的映射关系，确定所述表组对应的所有业务段号；
    回收确定的所有业务段号。
  5. 如权利要求4所述的方法，其特征在于，所述方法还包括：
    确定需要查询的卡号对应的业务段号和流水号；
    根据所述业务段号和所述表组的映射关系，确定所述业务段号对应的表组；
    根据所述流水号，从确定的所述表组中获取存储所述卡号的卡号存储表；
    从确定的所述卡号存储表中获取所述卡号关联的数据。
  6. 一种卡号数据的处理装置，其特征在于，包括：
    确定模块：用于根据卡号对应的失效时间，确定卡号对应的表组，将所述卡号对应的卡号信息置于所述表组的至少一个卡号存储表中；其中表组由多个卡号存储表组成，每个表组对应一个失效时间，所述表组中的所有卡号对应的失效时间与所述表组对应的失效时间相同，所述卡号信息包括卡号和与卡号关联的数据；
    清理模块：用于在一个表组对应的失效时间达到后，将所述表组中所有的卡号信息进行清理操作。
  7. 如权利要求6所述的装置，其特征在于，所述卡号包括生成所述卡号时分配的流水号；
    所述确定模块，还用于：
    根据所述表组和所述流水号，确定所述卡号对应的表组中的卡号存储表，将所述卡号信息存储在所述确定的卡号存储表中。
  8. 如权利要求7所述的装置，其特征在于，所述确定模块，还用于：
    根据时间信息与所述表组的映射关系，确定所述时间信息对应的表组，将所述时间信息与所述表组的映射关系存储在表组存储控制表中；其中，所述时间信息中包括多个失效时间，每个失效时间对应一个表组；
    所述在一个表组对应的失效时间达到后，将所述表组中所有的卡号信息进行清理操作，包括：
    在一个表组对应的失效时间达到后，在表组存储控制表中查询所述失效时间对应的表组，并清除所述失效时间对应的表组。
  9. 如权利要求7所述的装置，其特征在于，所述卡号包括生成所述卡号时根据业务信息分配的业务段号；
    所述清理模块，还用于：
    在一个表组对应的失效时间达到后，确定所述失效时间对应的表组；根据业务段号和表组的映射关系，确定所述表组对应的所有业务段号；回收确定的所有业务段号。
  10. 如权利要求9所述的装置，其特征在于，所述确定模块还用于：
    确定需要查询的卡号对应的业务段号和流水号；根据所述业务段号和所述表组的映射关系，确定所述业务段号对应的表组；根据所述流水号，从确定的所述表组中获取存储所述卡号的卡号存储表；从确定的所述卡号存储表中获取所述卡号关联的数据。
  11. 一种电子设备，其特征在于，包括：收发机、处理器、存储器、总线接口，其中处理器、存储器与收发机之间通过总线接口连接；
    所述存储器，用于存储一个或多个可执行程序，可以存储所述处理器在执行操作时所使用的数据；
    所述处理器，用于读取所述存储器中的程序，执行下列方法：根据卡号对应的失效时间，确定卡号对应的表组，将所述卡号对应的卡号信息置于所述表组的至少一个卡号存储表中；其中表组由多个卡号存储表组成，每个表组对应一个失效时间，所述表组中的所有卡号对应的失效时间与所述表组对应的失效时间相同，所述卡号信息包括卡号和与卡号关联的数据；在一个表组对应的失效时间达到后，将所述表组中所有的卡号信息进行清理操作；
    所述收发机，用于发送和接收所述处理器在执行操作时所使用的数据；
    所述总线接口，用于提供接口。
  12. 如权利要求11所述的电子设备，其特征在于，所述卡号包括生成所述卡号时分配的流水号；
    所述处理器，还用于：
    根据所述表组和所述流水号，确定所述卡号对应的表组中的卡号存储表，将所述卡号信息存储在所述确定的卡号存储表中。
  13. 如权利要求12所述的电子设备，其特征在于，所述处理器，还用于：
    根据时间信息与所述表组的映射关系，确定所述时间信息对应的表组，将所述时间信息与所述表组的映射关系存储在表组存储控制表中；其中，所述时间信息中包括多个失效时间，每个失效时间对应一个表组；
    在一个表组对应的失效时间达到后，在表组存储控制表中查询所述失效时间对应的表组，并清除所述失效时间对应的表组。
  14. 如权利要求12所述的电子设备，其特征在于，所述卡号包括生成所述卡号时根据业务信息分配的业务段号；
    所述处理器，还用于：
    在一个表组对应的失效时间达到后，确定所述失效时间对应的表组；
    根据业务段号和表组的映射关系，确定所述表组对应的所有业务段号；
    回收确定的所有业务段号。
  15. 如权利要求14所述的电子设备，其特征在于，所述处理器，还用于：
    确定需要查询的卡号对应的业务段号和流水号；
    根据所述业务段号和所述表组的映射关系，确定所述业务段号对应的表组；
    根据所述流水号，从确定的所述表组中获取存储所述卡号的卡号存储表；
    从确定的所述卡号存储表中获取所述卡号关联的数据。
PCT/CN2016/111143 2015-12-29 2016-12-20 一种卡号数据的处理方法及装置 WO2017114243A1 (zh)

Priority Applications (1)

Application Number Priority Date Filing Date Title
US16/067,246 US10922680B2 (en) 2015-12-29 2016-12-20 Method of processing card number data and device

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201511019374.9A CN105930331B (zh) 2015-12-29 2015-12-29 一种卡号数据的处理方法及装置
CN201511019374.9 2015-12-29

Publications (1)

Publication Number Publication Date
WO2017114243A1 true WO2017114243A1 (zh) 2017-07-06

Family

ID=56840054

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2016/111143 WO2017114243A1 (zh) 2015-12-29 2016-12-20 一种卡号数据的处理方法及装置

Country Status (3)

Country Link
US (1) US10922680B2 (zh)
CN (1) CN105930331B (zh)
WO (1) WO2017114243A1 (zh)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105930331B (zh) * 2015-12-29 2018-12-28 中国银联股份有限公司 一种卡号数据的处理方法及装置
KR102005554B1 (ko) 2018-08-09 2019-07-30 주식회사 센스톤 공카드를 이용한 금융거래제공방법 및 시스템
CN113240515A (zh) * 2021-06-17 2021-08-10 中国银行股份有限公司 借记卡信息处理方法及系统

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6575361B1 (en) * 1999-08-19 2003-06-10 E-2 Interactive, Inc. System and method for managing stored-value card data
CN102521704A (zh) * 2011-07-12 2012-06-27 武汉华工安鼎信息技术有限责任公司 一种基于rfid的涉密载体智能监控系统及其监控方法
CN102630083A (zh) * 2012-02-29 2012-08-08 中国工商银行股份有限公司 利用移动终端进行卡操作的系统及方法
CN105930331A (zh) * 2015-12-29 2016-09-07 中国银联股份有限公司 一种卡号数据的处理方法及装置

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7200619B2 (en) * 2002-05-31 2007-04-03 International Business Machines Corporation Method and process to optimize correlation of replicated with extracted data from disparate data sources
US7100821B2 (en) * 2003-05-15 2006-09-05 Mehran Randall Rasti Charge card and debit transactions using a variable charge number
TWI332664B (en) * 2007-06-13 2010-11-01 Phison Electronics Corp Data accessing system, controller and store device having the same and operation method thereof
US20100174845A1 (en) * 2009-01-05 2010-07-08 Sergey Anatolievich Gorobets Wear Leveling for Non-Volatile Memories: Maintenance of Experience Count and Passive Techniques
US8745094B2 (en) * 2010-03-01 2014-06-03 Protegrity Corporation Distributed tokenization using several substitution steps

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6575361B1 (en) * 1999-08-19 2003-06-10 E-2 Interactive, Inc. System and method for managing stored-value card data
CN102521704A (zh) * 2011-07-12 2012-06-27 武汉华工安鼎信息技术有限责任公司 一种基于rfid的涉密载体智能监控系统及其监控方法
CN102630083A (zh) * 2012-02-29 2012-08-08 中国工商银行股份有限公司 利用移动终端进行卡操作的系统及方法
CN105930331A (zh) * 2015-12-29 2016-09-07 中国银联股份有限公司 一种卡号数据的处理方法及装置

Also Published As

Publication number Publication date
US20190012658A1 (en) 2019-01-10
CN105930331B (zh) 2018-12-28
CN105930331A (zh) 2016-09-07
US10922680B2 (en) 2021-02-16

Similar Documents

Publication Publication Date Title
US10956911B2 (en) System and method of managing data injection into an executing data processing system
CN110390586A (zh) 对账方法、装置和服务器
CN107451918B (zh) 资产数据管理方法及装置
WO2017114243A1 (zh) 一种卡号数据的处理方法及装置
US20200020045A1 (en) Systems and methods for extracting information from a transaction description
US11003648B2 (en) Systems and methods for use in loading data from backup databases to task databases
US20150088752A1 (en) Methods, apparatus, systems and computer readable mediums for anonymized identification of payment card accounts belonging to a same entity
CN107491563A (zh) 面向账期结算的数据处理方法及系统
WO2018192931A1 (en) Delivery versus payment mechanism
CN111026758B (zh) 电子券发放方法和装置
US10262358B2 (en) Merchant continuity correction using cardholder loyalty information
CN111159183A (zh) 报表生成方法、电子装置及计算机可读存储介质
CN105138656A (zh) 一种处理数据的方法及装置
CN109472680A (zh) 一种账务处理方法及系统
US20150073863A1 (en) Method and System for Linking Browsing History to Proprietary Transaction Data
RU2016107383A (ru) Система и способ вознаграждения за лояльность
CN107092700A (zh) 一种基于大数据量下批量导入数据的方法及装置
CN105469303A (zh) 一种针对中小企业的征信方法
CN112581277A (zh) 一种数据处理方法及装置
CN104318476B (zh) 一种信息处理方法和装置
US11176174B2 (en) Systems and methods for database replication
JP2019074874A (ja) 名寄せシステムおよびプログラム
JP2017167843A (ja) 取引明細管理システムおよび取引明細管理方法
CN107783838A (zh) 客户信息查询方法和装置
CN106971339A (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: 16881032

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: 16881032

Country of ref document: EP

Kind code of ref document: A1