Disclosure of Invention
The invention mainly aims to provide a database establishing method and a database establishing device of a transaction security platform, and aims to solve the problem that a database needs to be established for calling in order to intensively provide transaction items with security services for buyers.
In order to achieve the above object, the present invention provides a database establishing method for a transaction assurance platform, comprising:
acquiring transaction item information for providing support service, wherein the transaction item information comprises transaction item parameters and support types;
and establishing a matching relation between the transaction item parameters and the guarantee types, and establishing a database according to the matching relation.
Preferably, the transaction support platform comprises a setting interface, the setting interface comprises a transaction item information uploading port, and the transaction item information uploading port has a preset format;
the database establishing method comprises the following specific steps:
when transaction item information is received from the transaction item information uploading port, performing word segmentation on the transaction item information according to the preset format to form a transaction item feature word string with a position sequence, wherein the position sequence corresponds to the table item information of the database;
similarity calculation is carried out on the transaction item feature word string and a feature word library of the table item information of the database, and the feature word with the highest similarity is recommended to the setting interface, wherein the table item information comprises transaction item parameters and guarantee types;
and when receiving confirmation information made by the setting interface based on the recommendation of the characteristic words, adding the recommended characteristic words to corresponding table item information in the database to form a transaction item record.
Preferably, the database establishing method includes:
when modification information made by the setting interface based on recommendation of the feature words is received, storing the unmodified feature words in a first cache, performing similarity calculation on the modification information and the feature word library again, and recommending the feature words with the highest similarity to the setting interface again;
and when receiving confirmation information made by the setting interface based on the re-recommendation of the feature words, adding the re-recommended feature words and the feature words stored in the first cache to corresponding table information in the database to form a transaction item record.
Preferably, the transaction item information includes a transaction item securing contract, which contains the information of the securing type.
Preferably, the safeguard type includes at least one of a guarantee effect, a guarantee fund, a guarantee refund, and a guarantee refund.
Preferably, the transaction item information is from any one or more of input from a merchant when the merchant is stationed on the current platform, or data injection from or data capture from other platforms other than the current platform.
In order to achieve the above object, the present invention provides a database establishing apparatus for a transaction assurance platform, comprising:
the information acquisition module is used for acquiring transaction item information for providing support service, wherein the transaction item information comprises transaction item parameters and support types;
and the matching module is used for establishing a matching relation between the transaction item parameters and the guarantee types and establishing a database according to the matching relation.
Preferably, the transaction support platform comprises a setting interface, the setting interface comprises a transaction item information uploading port, and the transaction item information uploading port has a preset format;
the information acquisition module is specifically used for segmenting the transaction item information according to the preset format to form a transaction item feature word string with a position sequence when the transaction item information is received from the transaction item information uploading port, wherein the position sequence corresponds to the table item information of the database;
similarity calculation is carried out on the transaction item feature word string and a feature word library of the table item information of the database, and the feature word with the highest similarity is recommended to the setting interface, wherein the table item information comprises transaction item parameters and guarantee types;
the matching module is specifically configured to, when receiving confirmation information made by the setting interface based on recommendation of the feature words, add the recommended feature words to corresponding entry information in the database to form a transaction item record.
Preferably, the matching module comprises a modification unit and a matching unit;
the modifying unit is used for storing unmodified feature words in a first cache when modifying information based on recommendation of the feature words in the setting interface is received, carrying out similarity calculation on the modifying information and the feature word library again, and recommending the feature words with the highest similarity to the setting interface again;
and the matching unit is used for adding the re-recommended characteristic words and the characteristic words stored in the first cache to corresponding table item information in the database to form a transaction item record when receiving confirmation information made by the re-recommendation of the characteristic words based on the setting interface.
Preferably, the database building device further comprises an external information importing module for completing the entries in the database by receiving the manner provided by a merchant, manually adding, searching in the internet or importing from an external data source.
According to the technical scheme, the information of the transaction items with the guarantee service is acquired, the matching relation between the transaction item parameters and the guarantee types is established, so that the database is established, the guarantee types of the transaction items can be clearly displayed by calling the database, and a buyer can conveniently purchase the transaction items with the guarantee service required by the buyer.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
Referring to fig. 1, fig. 1 is a database establishment method of a transaction assurance platform according to a first embodiment of the present invention. In this embodiment, the database establishment method of the transaction assurance platform includes:
step S100, transaction item information for providing support service is acquired, wherein the transaction item information comprises transaction item parameters and support types.
Specifically, the transaction item may be a target of transaction, such as a physical commodity, a virtual commodity, various services, a bidding item, various commercial items, and various staged sub-commercial items thereof, as long as both parties of the transaction achieve a demand relationship. The transaction item information comes from any one or more of the input of the merchant when the merchant is resident on the current platform, or the data injection of other platforms except the current platform or the data capture of the other platforms. The transaction item parameters include transaction item attributes, transaction item pictures, and transaction item prices. The guarantee type includes at least one of guarantee effect, guarantee fund, guarantee refund and guarantee return goods. The transaction item information comprises a transaction item security contract, a security type is written in the transaction item security contract, the security type is captured in a character recognition mode, and the security type is matched with transaction item parameters corresponding to the transaction item security contract.
Several applicable scenarios for safeguard types are described below:
the merchant agent avoids the need for stock that could otherwise be sold and the risk of pressing down on the stock is avoided by either a warranty return or a warranty cost for any one or more of these contracts.
The success of some educational tutoring courses and intellectual development courses is often staged, and the security of the effect can lead the buyer to pay money but not worry about the effect.
And step S200, establishing a matching relation between the transaction item parameters and the guarantee types, and establishing a database according to the matching relation.
In particular, databases are of many types, such as the simplest tables that store various data, large database systems that enable mass data storage. Databases are generally classified into hierarchical databases, network databases, and relational databases. While different databases are related and organized in different data structures. Data structures refer to the organizational form of data or the relationship between data. The database established by the invention mainly aims at quickly screening the guarantee types and the corresponding transaction items. Commonly used database systems include relational databases (e.g., Oracle, DB2, SQLServer, MySQL, etc.) and non-relational databases (e.g., Redis, MongoDB, HBase, etc.). The invention particularly establishes the database of the transaction guarantee platform based on the database systems.
According to the technical scheme, the information of the transaction items with the guarantee service is acquired, the matching relation between the transaction item parameters and the guarantee types is established, so that the database is established, the guarantee types of the transaction items can be clearly displayed by calling the database, and a buyer can conveniently purchase the transaction items with the guarantee service required by the buyer.
Referring to fig. 2, a second embodiment of the database establishment method of the transaction support platform according to the present invention is a first embodiment of the database establishment method of the transaction support platform according to the present invention, where the transaction support platform includes a setting interface, the setting interface includes a transaction item information uploading port, and the transaction item information uploading port has a preset format.
Specifically, the preset format of the transaction item information uploading port is a name of the transaction item information and an input box and/or a file link following the name, wherein the name of the transaction item information is consistent with the table entry information of the database.
The database establishing method comprises the following specific steps:
step S110, when the transaction item information is received from the transaction item information uploading port, performing word segmentation on the transaction item information according to the preset format to form a transaction item feature word string having a position sequence, where the position sequence corresponds to the entry information of the database.
Specifically, the table item information of the database includes a shop name, a shop identifier, a transaction item attribute, a transaction item description, a transaction item model, a transaction item picture, a transaction item price, and a guarantee type, which are sequentially set from the first item to the next item. When a seller correspondingly fills adidas, white shoes and 599 in an input box of a shop name, a trade item attribute, a trade item price and a guarantee type of a setting interface, returns are guaranteed due to various problems such as quality, favor and the like, and a shop identifier and a trade item picture upload corresponding picture files through a link, a server receives the trade item information from a trade item information upload port, performs word segmentation on the trade item information, and forms a trade item characteristic word string of adidas/pic 1/white shoes// DB1758/pic2/599, returns are guaranteed due to various problems such as quality, favor and the like, wherein the trade item is described as empty. And establishing a matching relation between the transaction item parameters and the guarantee types through the transaction item feature word strings.
And step S120, calculating the similarity between the transaction item feature word string and the feature word library of the item information of the database, and recommending the feature word with the highest similarity to the setting interface, wherein the item information comprises transaction item parameters and guarantee types.
Specifically, in order to facilitate conditional screening of the transaction support platform, a unified recognition word is established for each entry in the database, and the recognition word is also a feature lexicon, and transaction items under the same condition can be recognized according to any word in the feature lexicon. For example, the feature lexicon of the transaction item attribute is shoes, clothes, hats, cosmetics and the like, then the feature lexicon of the transaction item feature word string is compared with the feature lexicon to obtain the feature word with the highest similarity as the shoes, and then the feature lexicon of the guarantee type is the guarantee effect, the guarantee fund, the guarantee refund and the guarantee refund, for example, the feature lexicon of the guarantee type is the guarantee refund, then the feature word with the highest similarity as the guarantee refund is compared with the feature lexicon to obtain the feature word with the highest similarity as the guarantee refund. It should be noted that the feature word library is divided into a first-level word and a second-level word, the second-level word is a synonym of the first-level word, when the feature word string falls into the second-level word, the corresponding first-level word is recommended, for example, the goods to be saved is the first-level word, the corresponding second-level word is renewed, and when the feature word string is renewed, the goods to be saved is recommended to the setting interface.
Further, as for the item information, the transaction item feature word string in the text format is only set without the feature word library, the similarity calculation is not carried out, the comparison of the text formats is only carried out, if the text format is correct, the original information is directly returned to the setting interface for confirmation, and if the text format is wrong, the item is returned to error. For example, the entry information corresponding to the transaction item identifier, the transaction item picture, the transaction item price, the transaction item description and the transaction item model has no feature thesaurus, but the corresponding entry information is set in a text format, the text formats of the transaction item identifier and the transaction item picture are jpg, png, tiff and the like, the text format of the transaction item price is a numerical value, the text format of the transaction item description is a character, and the text format of the transaction item model is a character.
Step S210, when receiving confirmation information made by the setting interface based on the recommendation of the feature words, adding the recommended feature words to corresponding table information in the database to form a transaction item record.
Specifically, for an example that the characteristic word string of the transaction item is adidas/pic 1/white shoes// DB1758/pic 2/599/return goods are guaranteed due to various problems such as quality and preference, the characteristic word string recommended to the setting interface is adidas/pic 1/shoes// DB1758/pic 2/599/return goods for insurance. In another example, the trading project feature word string is American/pic 3/energy-saving refrigerator/T.ABT sterilization, multi-temperature multi-control, no defrosting/BCD-525 WKPZM (E)/pic 4/3201/three months cannot be reasonably renewed, and then the feature word string recommended to the setting interface is American/pic 3/refrigerator/T.ABT sterilization, multi-temperature multi-control, no defrosting/BCD-525 WKPZM (E)/pic 4/3201/goods retention and return. The seller does not modify the feature word string recommended to the setting interface, and after directly confirming the feature word string, the feature word string is correspondingly recorded under each item information of the database to form a transaction item record, wherein the table in the database is as follows:
in this embodiment, by segmenting the transaction item information and comparing the transaction item feature word strings formed after the segmentation, uniform recognition words under the table item information in the database are obtained, so that a transaction item record is established, the database is called for a transaction guarantee platform, and preparation is made for displaying transaction items under different guarantee types.
Referring to fig. 3, a third embodiment of the database establishment method of the transaction support platform of the present invention is shown, and the database establishment method includes:
step S211, when receiving modification information made by the setting interface based on recommendation of the feature words, storing the unmodified feature words in a first cache, performing similarity calculation on the modification information and the feature word library again, and recommending the feature words with the highest similarity to the setting interface again;
step S212, when receiving confirmation information made by the setting interface based on re-recommendation of feature words, adding the re-recommended feature words and the feature words stored in the first cache to corresponding entry information in the database to form a transaction item record.
For example, if the feature word string of the transaction project is congbean/pic 5/full-energy fuel-lipid tablet/weight control, and the feature word string of the setting interface is congbean/pic 5/full-energy fuel-lipid tablet/weight control, and the feature word string of the setting interface is congbean/pic 6/255 c/invalid refund, and the feature word string of the one month loses more than 3 catties/pic 6/error/refund, at this time, the buyer modifies the recommended feature word, modifies "error" to "255", modifies "refund" to "protect effect", and then the unmodified feature word string "congbean/pic 5/full-lipid tablet/weight control, and the one month loses more than 3 catties/pic 6" is stored in each corresponding entry in the first cache, compares the 255/protect effect with the corresponding recommended feature word library, and the feature word string of the setting interface is 255/protect effect again, if the seller confirms the two characteristic words at this time, the unmodified word in the first cache and the confirmed word are added to the corresponding table entry in the database to form a transaction item record.
In this embodiment, the first cache is established in advance, and the unmodified feature words are placed in the first cache instead of being directly placed in the database, so that the number of times of accessing the database can be reduced, and only after the feature word string is completely confirmed, a record of a transaction item is added to the database. In this way, the updating efficiency of the database can be improved, because the efficiency of accessing the cache is higher than that of accessing the database.
Referring to fig. 4, an embodiment of the database establishment apparatus of the transaction assurance platform according to the present invention includes:
the information acquiring module 100 is configured to acquire transaction item information for providing a support service, where the transaction item information includes transaction item parameters and a support type.
Specifically, the transaction item information is from any one or more of the following input when the merchant is stationed on the current platform, or data injection from or data capture from other platforms other than the current platform. The transaction item parameters include transaction item attributes, transaction item pictures, and transaction item prices. The guarantee type includes at least one of guarantee effect, guarantee fund, guarantee refund and guarantee return goods.
Several applicable scenarios for safeguard types are described below:
the merchant agent avoids the need for stock that could otherwise be sold and the risk of pressing down on the stock is avoided by either a warranty return or a warranty cost for any one or more of these contracts.
The success of some educational tutoring courses and intellectual development courses is often staged, and the security of the effect can lead the buyer to pay money but not worry about the effect.
And the matching module 200 is used for establishing a matching relationship between the transaction item parameters and the guarantee types and establishing a database according to the matching relationship.
According to the technical scheme, the information of the transaction items with the guarantee service is acquired, the matching relation between the transaction item parameters and the guarantee types is established, so that the database is established, the guarantee types of the transaction items can be clearly displayed by calling the database, and a buyer can conveniently purchase the transaction items with the guarantee service required by the buyer.
Further, the transaction support platform comprises a setting interface, the setting interface comprises a transaction item information uploading port, and the transaction item information uploading port has a preset format.
Specifically, the preset format of the transaction item information uploading port is a name of the transaction item information and an input box and/or a file link following the name, wherein the name of the transaction item information is consistent with the table entry information of the database.
The information obtaining module 100 is specifically configured to, when transaction item information is received from the transaction item information uploading port, perform word segmentation on the transaction item information according to the preset format to form a transaction item feature word string having a position sequence, where the position sequence corresponds to the entry information of the database.
Specifically, the table item information of the database includes a shop name, a shop identifier, a transaction item attribute, a transaction item description, a transaction item model, a transaction item picture, a transaction item price, and a guarantee type, which are sequentially set from the first item to the next item. When a seller correspondingly fills adidas, white shoes and 599 in an input box of a shop name, a trade item attribute, a trade item price and a guarantee type of a setting interface, returns are guaranteed due to various problems such as quality, favor and the like, and a shop identifier and a trade item picture upload corresponding picture files through a link, a server receives the trade item information from a trade item information upload port, performs word segmentation on the trade item information, and forms a trade item characteristic word string of adidas/pic 1/white shoes// DB1758/pic2/599, returns are guaranteed due to various problems such as quality, favor and the like, wherein the trade item is described as empty. And establishing a matching relation between the transaction item parameters and the guarantee types through the transaction item feature word strings.
And performing similarity calculation on the transaction item feature word string and a feature word library of the table information of the database, and recommending the feature word with the highest similarity to the setting interface, wherein the table information comprises transaction item parameters and guarantee types.
Specifically, in order to facilitate conditional screening of the transaction support platform, a unified recognition word is established for each entry in the database, and the recognition word is also a feature lexicon, and transaction items under the same condition can be recognized according to any word in the feature lexicon. For example, the feature lexicon of the transaction item attribute is shoes, clothes, hats, cosmetics and the like, then the feature lexicon of the transaction item feature word string is compared with the feature lexicon to obtain the feature word with the highest similarity as the shoes, and then the feature lexicon of the guarantee type is the guarantee effect, the guarantee fund, the guarantee refund and the guarantee refund, for example, the feature lexicon of the guarantee type is the guarantee refund, then the feature word with the highest similarity as the guarantee refund is compared with the feature lexicon to obtain the feature word with the highest similarity as the guarantee refund. It should be noted that the feature word library is divided into a first-level word and a second-level word, the second-level word is a synonym of the first-level word, when the feature word string falls into the second-level word, the corresponding first-level word is recommended, for example, the goods to be saved is the first-level word, the corresponding second-level word is renewed, and when the feature word string is renewed, the goods to be saved is recommended to the setting interface.
Further, as for the item information, the transaction item feature word string in the text format is only set without the feature word library, the similarity calculation is not carried out, the comparison of the text formats is only carried out, if the text format is correct, the original information is directly returned to the setting interface for confirmation, and if the text format is wrong, the item is returned to error. For example, the entry information corresponding to the transaction item identifier, the transaction item picture, the transaction item price, the transaction item description and the transaction item model has no feature thesaurus, but the corresponding entry information is set in a text format, the text formats of the transaction item identifier and the transaction item picture are jpg, png, tiff and the like, the text format of the transaction item price is a numerical value, the text format of the transaction item description is a character, and the text format of the transaction item model is a character.
The matching module 200 is specifically configured to, when receiving confirmation information that is made based on recommendation of feature words by the setting interface, add the recommended feature words to corresponding entry information in the database to form a transaction item record.
Specifically, for an example that the characteristic word string of the transaction item is adidas/pic 1/white shoes// DB1758/pic 2/599/return goods are guaranteed due to various problems such as quality and preference, the characteristic word string recommended to the setting interface is adidas/pic 1/shoes// DB1758/pic 2/599/return goods for insurance. In another example, the trading project feature word string is American/pic 3/energy-saving refrigerator/T.ABT sterilization, multi-temperature multi-control, no defrosting/BCD-525 WKPZM (E)/pic 4/3201/three months cannot be reasonably renewed, and then the feature word string recommended to the setting interface is American/pic 3/refrigerator/T.ABT sterilization, multi-temperature multi-control, no defrosting/BCD-525 WKPZM (E)/pic 4/3201/goods retention and return. The seller does not modify the feature word string recommended to the setting interface, and after directly confirming the feature word string, the feature word string is correspondingly recorded under each item information of the database to form a transaction item record, wherein the table in the database is as follows:
in this embodiment, by segmenting the transaction item information and comparing the transaction item feature word strings formed after the segmentation, uniform recognition words under the table item information in the database are obtained, so that a transaction item record is established, the database is called for a transaction guarantee platform, and preparation is made for displaying transaction items under different guarantee types.
The matching module 200 comprises a modification unit 211 and a matching unit 212;
the modifying unit 211 is configured to, when receiving modification information that is made based on recommendation of feature words by the setting interface, store unmodified feature words in a first cache, perform similarity calculation between the modification information and the feature word library again, and recommend the feature words with the highest similarity to the setting interface again;
the matching unit 212 is configured to, when receiving confirmation information that the setting interface makes a re-recommendation based on the feature words, add the re-recommended feature words and the feature words stored in the first cache to corresponding entry information in the database to form a transaction item record.
For example, if the feature word string of the transaction project is congbean/pic 5/full-energy fuel-lipid tablet/weight control, and the feature word string of the setting interface is congbean/pic 5/full-energy fuel-lipid tablet/weight control, and the feature word string of the setting interface is congbean/pic 6/255 c/invalid refund, and the feature word string of the one month loses more than 3 catties/pic 6/error/refund, at this time, the buyer modifies the recommended feature word, modifies "error" to "255", modifies "refund" to "protect effect", and then the unmodified feature word string "congbean/pic 5/full-lipid tablet/weight control, and the one month loses more than 3 catties/pic 6" is stored in each corresponding entry in the first cache, compares the 255/protect effect with the corresponding recommended feature word library, and the feature word string of the setting interface is 255/protect effect again, if the seller confirms the two characteristic words at this time, the unmodified word in the first cache and the confirmed word are added to the corresponding table entry in the database to form a transaction item record.
In this embodiment, the first cache is established in advance, and the unmodified feature words are placed in the first cache instead of being directly placed in the database, so that the number of times of accessing the database can be reduced, and only after the feature word string is completely confirmed, a record of a transaction item is added to the database. In this way, the updating efficiency of the database can be improved, because the efficiency of accessing the cache is higher than that of accessing the database.
The database building apparatus further includes an external information importing module 300 for completing entries in the database by receiving merchant-provided entries, manually adding entries, searching the internet, or importing entries from external data sources.
In the description herein, references to the description of the term "one embodiment," "another embodiment," or "first through xth embodiments," etc., mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the invention. In this specification, the schematic representations of the terms used above do not necessarily refer to the same embodiment or example. Furthermore, the particular features, structures, materials, method steps, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.
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, method, article, or apparatus 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, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal (such as a mobile phone, a computer, a server, an air conditioner, or a network device) to execute the method according to the embodiments of the present invention.
While the present invention has been described with reference to the embodiments shown in the drawings, the present invention is not limited to the embodiments, which are illustrative and not restrictive, and it will be apparent to those skilled in the art that various changes and modifications can be made therein without departing from the spirit and scope of the invention as defined in the appended claims.