CN115859370B - Transaction data processing method, device, computer equipment and storage medium - Google Patents
Transaction data processing method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN115859370B CN115859370B CN202310192851.XA CN202310192851A CN115859370B CN 115859370 B CN115859370 B CN 115859370B CN 202310192851 A CN202310192851 A CN 202310192851A CN 115859370 B CN115859370 B CN 115859370B
- Authority
- CN
- China
- Prior art keywords
- transaction data
- data
- database
- transaction
- management server
- 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.)
- Active
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to the technical field of data processing, and provides a transaction data processing method, a transaction data processing device, computer equipment and a storage medium, wherein the transaction data processing method comprises the following steps of: acquiring transaction data; classifying the transaction data to obtain first transaction data of a first class and second transaction data of a second class; creating a designated folder associated with the transaction data in a database, and creating a first data table and a second data table in the designated folder; storing the first transaction data into a first data table in the designated folder in a database; and storing the second transaction data into a second data table in the specified folder in a database. According to the invention, the first transaction data and the second transaction data which are obtained by classifying the transaction data are respectively stored, so that the defect that no distinction processing is performed on the transaction data at present is overcome, the disorder of the data is effectively avoided, and the risk of leakage of a large number of data sets is avoided.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method and apparatus for processing transaction data, a computer device, and a storage medium.
Background
In each large transaction platform, a large amount of transaction data is related, wherein the transaction data generally comprises product information of transaction, transaction account information, transaction amount and the like; wherein the privacy of part of the information is high, disclosure should be avoided, and part of the information does not relate to the privacy; at present, transaction data is not distinguished, but all the transaction data are associated and stored in a corresponding database, so that the data are easy to be disordered and are easy to leak in a large amount.
Disclosure of Invention
The invention mainly aims to provide a transaction data processing method, a device, computer equipment and a storage medium, which aim to solve the defect that no distinction processing is carried out on transaction data at present.
In order to achieve the above object, the present invention provides a transaction data processing method, including the following steps:
acquiring transaction data;
classifying the transaction data to obtain first transaction data of a first class and second transaction data of a second class;
creating a designated folder associated with the transaction data in a database, and creating a first data table and a second data table in the designated folder;
storing the first transaction data into a first data table in the designated folder in a database; and storing the second transaction data into a second data table in the specified folder in a database.
Further, the step of creating a designated folder in the database associated with the transaction data includes:
acquiring source attributes of the transaction data and data quantity of the transaction data;
extracting the characteristics of the source attributes to obtain characteristic characters;
digitally encoding the data quantity to obtain an encoded number;
acquiring a connection symbol corresponding to the source attribute matching of the transaction data;
acquiring a random number;
the characteristic characters, the connection symbols, the coding numbers and the random numbers are sequentially connected in series to obtain serial characters;
creating a folder, and taking the concatenated character as the file name of the folder to obtain the specified folder.
Further, the step of extracting the features of the source attribute to obtain the feature character includes:
acquiring Chinese characters corresponding to the source attributes; wherein, the Chinese characters comprise a plurality of Chinese characters;
acquiring the pinyin of each Chinese character and acquiring the initial of the corresponding pinyin; wherein each of the initials is capitalized;
and concatenating initial letters of the corresponding pinyin of each Chinese character to obtain the characteristic characters.
Further, the step of digitally encoding the data amount to obtain an encoded number includes:
processing the data volume according to a preset processing mode to obtain a data number meeting a preset specification;
judging whether the digital length of the data number exceeds a preset length;
if the character exceeds the lower case character corresponding to the characteristic character, acquiring the lower case characteristic character; wherein, the characters in the characteristic characters are English characters;
obtaining a standard digital coding table; wherein, the digital coding table comprises mapping relations between each coding character and sequence numbers; wherein, the sequence number is 1-32; the coding characters comprise lowercase English characters and numbers;
deleting all coded characters corresponding to the lowercase character in the standard digital coding table, and leaving a plurality of blank positions; shifting all the coded characters following the blank position forward to leave a blank position at the end of the standard digital code table;
acquiring a symbol corresponding to each character in the lowercase characteristic characters from a database;
inserting symbols corresponding to each character in the lowercase characteristic characters into blank positions left at the tail of the standard digital coding table according to the sequence of the lowercase characteristic characters to obtain a new digital coding table;
and carrying out coding processing on the data digits based on the new digit coding table to obtain the coded digits.
Further, the database is a database on a management server;
the step of storing the first transaction data in a first data table in the designated folder in a database includes:
desensitizing the first transaction data to obtain desensitized transaction data;
forging the first transaction data to obtain forged transaction data;
encrypting the first transaction data by adopting a first encryption mode to obtain first encrypted data;
encrypting the desensitized transaction data by adopting a second encryption mode to obtain second encrypted data;
encrypting the fake transaction data by adopting a third encryption mode to obtain third encrypted data;
transmitting the first encrypted data, the second encrypted data and the third encrypted data to the management server at the same time; the management server only stores a decryption mode corresponding to the first encryption mode, is used for decrypting the first encrypted data to obtain the first transaction data, and stores the first transaction data into a first data table in the designated folder in a database of the management server.
Further, the database is a database on a management server;
the step of storing the first transaction data in a first data table in the designated folder in a database includes:
desensitizing the first transaction data to obtain desensitized transaction data;
forging the first transaction data to obtain forged transaction data;
randomly ordering the desensitized transaction data, counterfeit transaction data, and the first transaction data;
according to the sorting, the desensitized transaction data, the fake transaction data and the first transaction data are sent to the management server according to preset intervals; wherein a trigger signal is sent while the first transaction data is sent; the management server is provided with a signal trigger, and only when the signal trigger receives the trigger signal, the management server acquires the first transaction data which are simultaneously transmitted and stores the first transaction data into a first data table in the designated folder in a database; when the management server does not receive the trigger signal, acquiring the desensitization transaction data and the counterfeit transaction data, and storing the desensitization transaction data and the counterfeit transaction data into a preset recovery folder; and deleting the desensitized transaction data and the counterfeit transaction data in the recovery folder after the preset time.
The invention also provides a transaction data processing device, which comprises:
an acquisition unit configured to acquire transaction data;
the classification unit is used for classifying the transaction data to obtain first classified transaction data and second classified transaction data;
a creation unit for creating a specified folder associated with the transaction data in a database, and creating a first data table and a second data table in the specified folder;
a storage unit, configured to store the first transaction data into a first data table in the specified folder in a database; and storing the second transaction data into a second data table in the specified folder in a database.
Further, the database is a database on a management server;
the storage unit stores the first transaction data into a first data table in the designated folder in a database, and specifically includes:
desensitizing the first transaction data to obtain desensitized transaction data;
forging the first transaction data to obtain forged transaction data;
encrypting the first transaction data by adopting a first encryption mode to obtain first encrypted data;
encrypting the desensitized transaction data by adopting a second encryption mode to obtain second encrypted data;
encrypting the fake transaction data by adopting a third encryption mode to obtain third encrypted data;
transmitting the first encrypted data, the second encrypted data and the third encrypted data to the management server at the same time; the management server only stores a decryption mode corresponding to the first encryption mode, is used for decrypting the first encrypted data to obtain the first transaction data, and stores the first transaction data into a first data table in the designated folder in a database of the management server.
The invention also provides a computer device comprising a memory and a processor, the memory having stored therein a computer program, the processor implementing the steps of any of the methods described above when the computer program is executed.
The invention also provides a computer readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of the method of any of the preceding claims.
The invention provides a transaction data processing method, a device, a computer device and a storage medium, which comprise the following steps: acquiring transaction data; classifying the transaction data to obtain first transaction data of a first class and second transaction data of a second class; creating a designated folder associated with the transaction data in a database, and creating a first data table and a second data table in the designated folder; storing the first transaction data into a first data table in the designated folder in a database; and storing the second transaction data into a second data table in the specified folder in a database. According to the invention, the first transaction data and the second transaction data which are obtained by classifying the transaction data are respectively stored, so that the defect that no distinction processing is performed on the transaction data at present is overcome, the disorder of the data is effectively avoided, and the risk of leakage of a large number of data sets is avoided.
Drawings
FIG. 1 is a diagram showing steps of a method for processing transaction data according to an embodiment of the present invention;
FIG. 2 is a block diagram of a transaction data processing device according to an embodiment of the present invention;
fig. 3 is a block diagram schematically illustrating a structure of a computer device according to an embodiment of the present invention.
The achievement of the objects, functional features and advantages of the present invention will be further described with reference to the accompanying drawings, in conjunction with the embodiments.
Detailed Description
The present invention will be described in further detail with reference to the drawings and examples, in order to make the objects, technical solutions and advantages of the present invention more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention.
Referring to fig. 1, in one embodiment of the present invention, a method for processing transaction data is provided, including the following steps:
step S1, transaction data are obtained;
step S2, classifying the transaction data to obtain first classified transaction data and second classified transaction data;
step S3, creating a designated folder associated with the transaction data in a database, and creating a first data table and a second data table in the designated folder;
step S4, storing the first transaction data into a first data table in the designated folder in a database; and storing the second transaction data into a second data table in the specified folder in a database.
In this embodiment, the above scheme is applied to classifying transaction data generated in the transaction process, and according to the classification result, different types of transaction data are respectively stored under different lists, so that not only is data mess avoided, but also the risk of simultaneous leakage of a large amount of data caused by storing all data under the same list can be avoided.
As described in the above step S1, transaction data generated in the transaction process in the transaction platform is obtained, where the transaction data includes various information such as transaction account number, transaction commodity, transaction time, transaction amount, etc. Different information has different privacy classes. The transaction data may be classified according to privacy classes. Classifying the transaction data to obtain first classified transaction data and second classified transaction data as described in the step S2; in this embodiment, the above transaction data may be classified according to the privacy level, for example, the privacy level of the transaction account number, the transaction commodity, and the transaction amount is high, and thus classified into one type (first classification), and the privacy level of the transaction time is low, and may be classified into another type (second classification).
In order to store the classified transaction data correspondingly, a designated folder associated with the transaction data is created in a database, and a first data table and a second data table are created in the designated folder, as described in the step S3; further, as described in the above step S4, the first transaction data is stored in a first data table in the designated folder in the database; and storing the second transaction data into a second data table in the designated folder in the database, so that different types of data are stored in different lists, data disorder is avoided, and the risk of simultaneous leakage of a large amount of data caused by storing all data in the same list is avoided.
In one embodiment, the step S3 of creating a specified folder associated with the transaction data in the database includes:
step S31, obtaining source attribute of the transaction data and data quantity of the transaction data; the source attribute refers to a platform from which transaction data is derived, and the transaction data refers to an overall data amount of the data.
Step S32, extracting the characteristics of the source attributes to obtain characteristic characters;
step S33, carrying out digital coding on the data quantity to obtain coded numbers;
step S34, obtaining a connection symbol corresponding to the source attribute matching of the transaction data; the corresponding relation between the source attribute and the connection symbol is stored in the database, different source attributes correspond to different connection symbols, and the corresponding source attribute can be represented based on the connection symbols.
Step S35, a random number is obtained; the random numbers are typically numbers in the range of 1-10.
Step S36, the characteristic characters, the connection symbols, the coding numbers and the random numbers are sequentially connected in series to obtain serial characters; the serial characters can represent various characteristics of the transaction data, and when the serial characters are used as names of designated folders, various attributes of the transaction data can be expressed through the names of the folders.
Step S37, creating a folder, and taking the concatenated characters as file names of the folder to obtain the specified folder.
In this embodiment, when the specified folder is created, it needs to be associated with the transaction data, specifically, in the above manner, according to the source attribute of the transaction data and the data amount of the transaction data, a corresponding concatenated character is generated as the file name of the specified folder.
In an embodiment, the step S32 of extracting the features of the source attribute to obtain a feature character includes:
acquiring Chinese characters corresponding to the source attributes; wherein, the Chinese characters comprise a plurality of Chinese characters; for example, the source attribute is the Beijing Dong shopping platform, and the corresponding Chinese characters are Beijing Dong shopping.
Acquiring the pinyin of each Chinese character and acquiring the initial of the corresponding pinyin; wherein each of the initials is capitalized; for example, pinyin of Jingdong is jingdonggouwu, and the corresponding initial is JDGW.
And concatenating initial letters of the corresponding pinyin of each Chinese character to obtain the characteristic characters. It will be appreciated that the letters in the character features described above are different from each other, and duplicate letters are deleted if the same letters appear.
In one embodiment, the step S33 of digitally encoding the data amount to obtain an encoded number includes:
processing the data volume according to a preset processing mode to obtain a data number meeting a preset specification; the preset processing mode comprises the steps of converting the data quantity into preset units and removing the numbers after decimal places.
Judging whether the digital length of the data number exceeds a preset length;
if the character exceeds the lower case character corresponding to the characteristic character, acquiring the lower case characteristic character; wherein, the characters in the characteristic characters are English characters; for example, in one embodiment, the feature character is TBGW, and the corresponding lowercase feature character is TBGW.
Obtaining a standard digital coding table; wherein, the digital coding table comprises mapping relations between each coding character and sequence numbers; wherein, the sequence number is 1-32; the coding characters comprise lowercase English characters and numbers; in one embodiment, the standard number code table is a general code table, which includes 32 code characters corresponding to the sequence numbers 1-32, respectively, and the code characters include 26 lowercase english characters and 6 digits.
Since the standard digital code table is a general code table, if the standard digital code table is directly used for coding, the code table is easy to be decoded, so that the code table needs to be rearranged in the embodiment, the specific code table in the embodiment is obtained, and the safety of data is enhanced.
Specifically, deleting all coded characters corresponding to the lowercase character in the standard digital coding table, and leaving a plurality of blank positions; shifting all the coded characters following the blank position forward to leave a blank position at the end of the standard digital code table;
acquiring a symbol corresponding to each character in the lowercase characteristic characters from a database; the symbols can be any symbols, and the corresponding relation between the lower-case English characters and the symbols is stored in a database.
Inserting symbols corresponding to each character in the lowercase characteristic characters into blank positions left at the tail of the standard digital coding table according to the sequence of the lowercase characteristic characters to obtain a new digital coding table;
and carrying out coding processing on the data digits based on the new digit coding table to obtain the coded digits. The new digital code table cannot be easily decoded, and when the coded digital code is decoded, the data digital is obtained by only generating the corresponding digital code table according to the mode and performing inverse coding.
In one embodiment, the database is a database on a management server;
the step of storing the first transaction data in a first data table in the designated folder in a database includes:
desensitizing the first transaction data to obtain desensitized transaction data;
forging the first transaction data to obtain forged transaction data;
encrypting the first transaction data by adopting a first encryption mode to obtain first encrypted data;
encrypting the desensitized transaction data by adopting a second encryption mode to obtain second encrypted data;
encrypting the fake transaction data by adopting a third encryption mode to obtain third encrypted data;
transmitting the first encrypted data, the second encrypted data and the third encrypted data to the management server at the same time; the management server only stores a decryption mode corresponding to the first encryption mode, is used for decrypting the first encrypted data to obtain the first transaction data, and stores the first transaction data into a first data table in the designated folder in a database of the management server.
In this embodiment, in order to enhance the security of the first transaction data, the first transaction data is subjected to desensitization processing, so as to obtain desensitized transaction data; forging the first transaction data to obtain forged transaction data; simultaneously, the first transaction data, the desensitization transaction data and the counterfeit transaction data are respectively encrypted by adopting different encryption modes, and the encrypted data are sent to a management server; since the management server only stores the decryption method corresponding to the first encryption method, it can only decrypt the first encrypted data to obtain the first transaction data, and store the first transaction data in the first data table in the designated folder in the database of the management server. In contrast, the second encrypted data and the third encrypted data cannot be decrypted, so that the management server may not need to store the second encrypted data and the third encrypted data, and may choose to discard or delete the second encrypted data and the third encrypted data. If an illegal user wants to acquire the first transaction data, the illegal user needs to decrypt the first transaction data, and different decryption modes are needed for the three encrypted data, so that decryption difficulty is increased; meanwhile, even if all data can be decrypted, the three data are obtained, and an illegal user cannot directly obtain real transaction data from the three data; when an illegal user acquires the desensitized transaction data and the counterfeit transaction data, the possibility of using the desensitized transaction data and the counterfeit transaction data as real data is higher, and the real first transaction data is easy to ignore. By the method, the safety of the transaction data is improved, and the difficulty of cracking the transaction data by illegal users is increased.
In one embodiment, the database is a database on a management server;
the step of storing the first transaction data in a first data table in the designated folder in a database includes:
desensitizing the first transaction data to obtain desensitized transaction data;
forging the first transaction data to obtain forged transaction data;
randomly ordering the desensitized transaction data, counterfeit transaction data, and the first transaction data;
according to the sorting, the desensitized transaction data, the fake transaction data and the first transaction data are sent to the management server according to preset intervals; wherein a trigger signal is sent while the first transaction data is sent; the management server is provided with a signal trigger, and only when the signal trigger receives the trigger signal, the management server acquires the first transaction data which are simultaneously transmitted and stores the first transaction data into a first data table in the designated folder in a database; when the management server does not receive the trigger signal, acquiring the desensitization transaction data and the counterfeit transaction data, and storing the desensitization transaction data and the counterfeit transaction data into a preset recovery folder; and deleting the desensitized transaction data and the counterfeit transaction data in the recovery folder after the preset time.
In this embodiment, through the form of the trigger information, the management server may be prompted to receive and store by sending the trigger signal while sending the real first transaction data; the above-mentioned triggering signal is not sent for the above-mentioned desensitization trade data and false trade data, and the management server can know that it is false data, and can be directly deleted without saving; or storing the file into a preset recovery folder; and deleting the desensitized transaction data and the counterfeit transaction data in the recovery folder after the preset time.
In an embodiment, the storing the first transaction data in a first data table in the designated folder in a database; after the step of storing the second transaction data in the second data table in the designated folder in the database, the method further includes:
s5, carrying out hash operation on the first data table to obtain a first hash value;
step S6, storing the first hash value to the appointed position of the second list, and carrying out hash operation on the second list added with the first hash value to obtain a second hash value;
and step S7, storing the second hash value to the appointed position of the first list.
In this embodiment, based on the first hash value and the second hash value, the security of the data in the first list and the second list may be checked; it will be appreciated that if the data in the first list and the second list are tampered, the corresponding hash value will also change. When verifying whether the data in the first list and the second list are tampered, deleting the second hash value stored in the first list, and performing hash calculation to obtain a first verification hash value; verifying whether the first verification hash value is the same as a first hash value stored in a second list, and if so, not falsifying the first list; if not, tampering occurs. Carrying out hash calculation on the second list to obtain a second verification hash value, judging whether the second verification hash value is the same as the second hash value stored in the first list, and if so, not falsifying; if not, tampering occurs.
Referring to fig. 2, in an embodiment of the present invention, there is further provided a transaction data processing apparatus, including:
an acquisition unit configured to acquire transaction data;
the classification unit is used for classifying the transaction data to obtain first classified transaction data and second classified transaction data;
a creation unit for creating a specified folder associated with the transaction data in a database, and creating a first data table and a second data table in the specified folder;
a storage unit, configured to store the first transaction data into a first data table in the specified folder in a database; and storing the second transaction data into a second data table in the specified folder in a database.
In one embodiment, the database is a database on a management server;
the storage unit stores the first transaction data into a first data table in the designated folder in a database, and specifically includes:
desensitizing the first transaction data to obtain desensitized transaction data;
forging the first transaction data to obtain forged transaction data;
encrypting the first transaction data by adopting a first encryption mode to obtain first encrypted data;
encrypting the desensitized transaction data by adopting a second encryption mode to obtain second encrypted data;
encrypting the fake transaction data by adopting a third encryption mode to obtain third encrypted data;
transmitting the first encrypted data, the second encrypted data and the third encrypted data to the management server at the same time; the management server only stores a decryption mode corresponding to the first encryption mode, is used for decrypting the first encrypted data to obtain the first transaction data, and stores the first transaction data into a first data table in the designated folder in a database of the management server.
In this embodiment, for specific implementation of each unit in the above embodiment of the apparatus, please refer to the description in the above embodiment of the method, and no further description is given here.
Referring to fig. 3, in an embodiment of the present invention, there is further provided a computer device, which may be a server, and an internal structure thereof may be as shown in fig. 3. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the computer is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The database of the computer device is used to store the corresponding data in this embodiment. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a method of processing transaction data.
It will be appreciated by those skilled in the art that the architecture shown in fig. 3 is merely a block diagram of a portion of the architecture in connection with the present inventive arrangements and is not intended to limit the computer devices to which the present inventive arrangements are applicable.
An embodiment of the present invention also provides a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, implements a method of processing transaction data. It is understood that the computer readable storage medium in this embodiment may be a volatile readable storage medium or a nonvolatile readable storage medium.
In summary, the method, the device, the computer device and the storage medium for processing transaction data provided in the embodiments of the present invention include: acquiring transaction data; classifying the transaction data to obtain first transaction data of a first class and second transaction data of a second class; creating a designated folder associated with the transaction data in a database, and creating a first data table and a second data table in the designated folder; storing the first transaction data into a first data table in the designated folder in a database; and storing the second transaction data into a second data table in the specified folder in a database. According to the invention, the first transaction data and the second transaction data which are obtained by classifying the transaction data are respectively stored, so that the defect that no distinction processing is performed on the transaction data at present is overcome, the disorder of the data is effectively avoided, and the risk of leakage of a large number of data sets is avoided.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium provided by the present invention and used in embodiments may include non-volatile and/or volatile memory. The nonvolatile 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. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), dual speed data rate SDRAM (SSRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), memory bus direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), among others.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, apparatus, article, or method that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, apparatus, article, or method. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, apparatus, article or method that comprises the element.
The foregoing description is only of the preferred embodiments of the present invention and is not intended to limit the scope of the invention, and all equivalent structures or equivalent processes using the descriptions and drawings of the present invention or direct or indirect application in other related technical fields are included in the scope of the present invention.
Claims (9)
1. A method of processing transaction data, comprising the steps of:
acquiring transaction data;
classifying the transaction data to obtain first transaction data of a first class and second transaction data of a second class;
creating a designated folder associated with the transaction data in a database, and creating a first data table and a second data table in the designated folder;
storing the first transaction data into a first data table in the designated folder in a database; storing the second transaction data into a second data table in the designated folder in a database;
the database is a database on a management server;
the step of storing the first transaction data in a first data table in the designated folder in a database includes:
desensitizing the first transaction data to obtain desensitized transaction data;
forging the first transaction data to obtain forged transaction data;
randomly ordering the desensitized transaction data, counterfeit transaction data, and the first transaction data;
according to the sorting, the desensitized transaction data, the fake transaction data and the first transaction data are sent to the management server according to preset intervals; wherein a trigger signal is sent while the first transaction data is sent; the management server is provided with a signal trigger, and only when the signal trigger receives the trigger signal, the management server acquires the first transaction data which are simultaneously transmitted and stores the first transaction data into a first data table in the designated folder in a database; when the management server does not receive the trigger signal, acquiring the desensitization transaction data and the counterfeit transaction data, and storing the desensitization transaction data and the counterfeit transaction data into a preset recovery folder; and deleting the desensitized transaction data and the counterfeit transaction data in the recovery folder after the preset time.
2. The method of processing transaction data according to claim 1, wherein the step of creating a designated folder in a database associated with the transaction data includes:
acquiring source attributes of the transaction data and data quantity of the transaction data;
extracting the characteristics of the source attributes to obtain characteristic characters;
digitally encoding the data quantity to obtain an encoded number;
acquiring a connection symbol corresponding to the source attribute matching of the transaction data;
acquiring a random number;
the characteristic characters, the connection symbols, the coding numbers and the random numbers are sequentially connected in series to obtain serial characters;
creating a folder, and taking the concatenated character as the file name of the folder to obtain the specified folder.
3. The method of claim 2, wherein the step of extracting features from the source attribute to obtain feature characters comprises:
acquiring Chinese characters corresponding to the source attributes; wherein, the Chinese characters comprise a plurality of Chinese characters;
acquiring the pinyin of each Chinese character and acquiring the initial of the corresponding pinyin; wherein each of the initials is capitalized;
and concatenating initial letters of the corresponding pinyin of each Chinese character to obtain the characteristic characters.
4. The method of processing transaction data according to claim 2, wherein the step of digitally encoding the data quantity to obtain an encoded number includes:
processing the data volume according to a preset processing mode to obtain a data number meeting a preset specification;
judging whether the digital length of the data number exceeds a preset length;
if the character exceeds the lower case character corresponding to the characteristic character, acquiring the lower case characteristic character; wherein, the characters in the characteristic characters are English characters;
obtaining a standard digital coding table; wherein, the digital coding table comprises mapping relations between each coding character and sequence numbers; wherein, the sequence number is 1-32; the coding characters comprise lowercase English characters and numbers;
deleting all coded characters corresponding to the lowercase character in the standard digital coding table, and leaving a plurality of blank positions; shifting all the coded characters following the blank position forward to leave a blank position at the end of the standard digital code table;
acquiring a symbol corresponding to each character in the lowercase characteristic characters from a database;
inserting symbols corresponding to each character in the lowercase characteristic characters into blank positions left at the tail of the standard digital coding table according to the sequence of the lowercase characteristic characters to obtain a new digital coding table;
and carrying out coding processing on the data digits based on the new digit coding table to obtain the coded digits.
5. The method of claim 1, wherein the database is a database on a management server;
the step of storing the first transaction data in a first data table in the designated folder in a database includes:
desensitizing the first transaction data to obtain desensitized transaction data;
forging the first transaction data to obtain forged transaction data;
encrypting the first transaction data by adopting a first encryption mode to obtain first encrypted data;
encrypting the desensitized transaction data by adopting a second encryption mode to obtain second encrypted data;
encrypting the fake transaction data by adopting a third encryption mode to obtain third encrypted data;
transmitting the first encrypted data, the second encrypted data and the third encrypted data to the management server at the same time; the management server only stores a decryption mode corresponding to the first encryption mode, is used for decrypting the first encrypted data to obtain the first transaction data, and stores the first transaction data into a first data table in the designated folder in a database of the management server.
6. A transaction data processing device, comprising:
an acquisition unit configured to acquire transaction data;
the classification unit is used for classifying the transaction data to obtain first classified transaction data and second classified transaction data;
a creation unit for creating a specified folder associated with the transaction data in a database, and creating a first data table and a second data table in the specified folder;
a storage unit, configured to store the first transaction data into a first data table in the specified folder in a database; storing the second transaction data into a second data table in the designated folder in a database;
the database is a database on a management server;
the storage unit stores the first transaction data into a first data table in the designated folder in a database, including:
desensitizing the first transaction data to obtain desensitized transaction data;
forging the first transaction data to obtain forged transaction data;
randomly ordering the desensitized transaction data, counterfeit transaction data, and the first transaction data;
according to the sorting, the desensitized transaction data, the fake transaction data and the first transaction data are sent to the management server according to preset intervals; wherein a trigger signal is sent while the first transaction data is sent; the management server is provided with a signal trigger, and only when the signal trigger receives the trigger signal, the management server acquires the first transaction data which are simultaneously transmitted and stores the first transaction data into a first data table in the designated folder in a database; when the management server does not receive the trigger signal, acquiring the desensitization transaction data and the counterfeit transaction data, and storing the desensitization transaction data and the counterfeit transaction data into a preset recovery folder; and deleting the desensitized transaction data and the counterfeit transaction data in the recovery folder after the preset time.
7. The transaction data processing device of claim 6, wherein the database is a database on a management server;
the storage unit stores the first transaction data into a first data table in the designated folder in a database, and specifically includes:
desensitizing the first transaction data to obtain desensitized transaction data;
forging the first transaction data to obtain forged transaction data;
encrypting the first transaction data by adopting a first encryption mode to obtain first encrypted data;
encrypting the desensitized transaction data by adopting a second encryption mode to obtain second encrypted data;
encrypting the fake transaction data by adopting a third encryption mode to obtain third encrypted data;
transmitting the first encrypted data, the second encrypted data and the third encrypted data to the management server at the same time; the management server only stores a decryption mode corresponding to the first encryption mode, is used for decrypting the first encrypted data to obtain the first transaction data, and stores the first transaction data into a first data table in the designated folder in a database of the management server.
8. A computer device comprising a memory and a processor, the memory having stored therein a computer program, characterized in that the processor, when executing the computer program, implements the steps of the method of any of claims 1 to 5.
9. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310192851.XA CN115859370B (en) | 2023-03-02 | 2023-03-02 | Transaction data processing method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310192851.XA CN115859370B (en) | 2023-03-02 | 2023-03-02 | Transaction data processing method, device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115859370A CN115859370A (en) | 2023-03-28 |
| CN115859370B true CN115859370B (en) | 2023-05-02 |
Family
ID=85659755
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310192851.XA Active CN115859370B (en) | 2023-03-02 | 2023-03-02 | Transaction data processing method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115859370B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116132527B (en) * | 2023-04-13 | 2023-06-16 | 深圳柯赛标识智能科技有限公司 | System and method for managing indication board and data processing server |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115221173A (en) * | 2022-07-26 | 2022-10-21 | 佟波 | Highway design chart generation method and system |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7529408B2 (en) * | 2005-02-23 | 2009-05-05 | Ichannex Corporation | System and method for electronically processing document images |
| US8442881B2 (en) * | 2010-08-20 | 2013-05-14 | Aashirvad Holdings Llc | Systems and methods of processing and classifying a financial transaction |
| US9703855B1 (en) * | 2013-04-15 | 2017-07-11 | Ca, Inc. | System and method for classifying content with a web service |
| CN107784039A (en) * | 2016-08-31 | 2018-03-09 | 阿里巴巴集团控股有限公司 | A kind of data load method, apparatus and system |
| CN109669933B (en) * | 2018-12-10 | 2023-10-27 | 平安科技（深圳）有限公司 | Transaction data intelligent processing method and device and computer readable storage medium |
| CN109871699A (en) * | 2019-01-28 | 2019-06-11 | 中国平安财产保险股份有限公司 | Method, apparatus, computer equipment and the storage medium of tables of data safe handling |
| CN113407287A (en) * | 2021-06-29 | 2021-09-17 | 中国平安人寿保险股份有限公司 | Method, device and equipment for quickly generating visual page and storage medium |
-
2023
- 2023-03-02 CN CN202310192851.XA patent/CN115859370B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115221173A (en) * | 2022-07-26 | 2022-10-21 | 佟波 | Highway design chart generation method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115859370A (en) | 2023-03-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN116484437B (en) | Asset information management method and device and computer equipment | |
| CN111008923A (en) | Watermark embedding method, watermark extracting method, watermark embedding device, watermark extracting device and watermark extracting equipment | |
| CN110662184A (en) | Information pushing method and device, computer equipment and storage medium | |
| CN112380833B (en) | Similar text searching method and device for sentence-by-sentence comparison | |
| CN111756522A (en) | Data processing method and system | |
| CN115859370B (en) | Transaction data processing method, device, computer equipment and storage medium | |
| CN111984987A (en) | Method, device, system and medium for desensitization and reduction of electronic medical record | |
| US20150379524A1 (en) | Method and system for authenticating physical items | |
| CN116627272A (en) | Touch control method and device and computer equipment | |
| CN116680673B (en) | Identity verification method and device for display and computer equipment | |
| CN115567212A (en) | File processing method and device, computer equipment and computer readable storage medium | |
| CN113254986B (en) | Data processing method, device and computer readable storage medium | |
| CN106411888B (en) | Signature document encryption device and method | |
| US11522715B2 (en) | Methods for processing and verifying a document | |
| CN114637985A (en) | Android application login counterfeiting identification method based on multi-environment parameters | |
| CN109145645B (en) | Method for protecting short message verification code in android mobile phone | |
| CN112307491A (en) | Character display method, device, electronic device and computer readable storage medium | |
| CN116235169A (en) | Digital watermarking of text data | |
| Kazmi et al. | Unihach: unicode and hash function supported with counting and frequency recurrence of Arabic characters for Quranic text watermarking | |
| CN116126998B (en) | File homology checking method and system | |
| CN113204794B (en) | Transaction record safe storage method, device, equipment and storage medium | |
| CN115686380B (en) | File storage method, device, computer equipment and storage medium | |
| CN116992406A (en) | Page watermark acquisition method and device, computer equipment and readable storage medium | |
| CN117113930A (en) | Data conversion method and device and computer equipment | |
| CN118364517B (en) | Block chain-based sales contract certification method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |