Coal selling and purchasing line fast matching system based on big data platform

Abstract

The application relates to a coal sale and purchase route fast matching system based on a big data platform, and belongs to the technical field of coal buying and selling. The application comprises a bottom-layer database, wherein the bottom-layer database comprises a geographic coordinate database, a coal index database and a historical logistics database; the geographic coordinate database comprises geographic coordinates of coal sources, stations and coal terminal; the coal index database comprises coal source quality indexes provided by the coal sources and coal source quality indexes required by the coal terminal; and the historical logistics database comprises logistics transportation data of the coal sources to a terminal by steam transportation or fire transportation. A data processing module is used for matching steam transportation or fire transportation logistics transportation data in the historical logistics database in the geographic coordinate database, and determining recommended coal sources or recommended coal terminals. The application can solve the problem that coal mine enterprises, trade enterprises and coal enterprises cannot quickly and accurately lock potential purchase or sale objects due to limited data.

Description

Technical Field

[0001] This application belongs to the field of coal trading technology, and specifically relates to a coal sales and procurement line rapid matching system based on a big data platform. Background Art

[0002] When developing coal sales channels, existing coal mining companies or trading companies, as well as coal-using companies (thermal power plants, cement plants, steel mills, etc.), develop procurement channels. The methods they use include: contacting familiar customers by phone or WeChat to communicate about supply and demand; sending supply or demand in WeChat and QQ groups and waiting for customers to contact them; sending business teams to visit and negotiate with various regions and companies; checking railway batch cars, coal trading platforms, and online freight platform data. The above methods have the disadvantages of limited number of acquaintances and narrow procurement and sales channels. If acquaintances do not have corresponding procurement needs or suitable supply sources, the probability of successful procurement and sales is low. The efficiency is greatly reduced; most of the customers contacted in WeChat groups or QQ groups are intermediary traders, rather than coal mines or coal-using enterprises. Intermediate traders purchase at low prices and sell at high prices, which will increase downstream procurement costs and reduce coal mine sales profits; where the business team will conduct research and which enterprises to select for research are difficult to determine, and the information obtained is vague and limited, resulting in a long research time, many detours, and reduced research effectiveness; the routes covered by railway wholesale vehicles, coal trading platforms, and online freight platforms are limited, and the transaction parties are mostly intermediary trading enterprises, not real coal sources and terminal enterprises. Summary of the Invention

[0003] To this end, this application provides a coal sales and procurement route rapid matching system based on a big data platform, which is used to solve the problem in the existing technology that coal mining enterprises, trading enterprises and coal-using enterprises are unable to quickly and accurately lock in potential procurement or sales targets due to limited data.

[0004] To achieve the above objectives, this application adopts the following technical solutions:

[0005] A coal sales and procurement line rapid matching system based on a big data platform, the system comprising:

[0006] An underlying database, comprising: a geographic coordinate database, a coal index database, and a historical logistics database;

[0007] The geographic coordinate database includes the geographic coordinates of coal sources, platforms and coal-using terminals;

[0008] The coal index database includes coal source quality indicators that can be provided by coal sources and coal source quality indicators required by coal-using terminals;

[0009] The historical logistics database includes logistics transportation data of coal source supplied to a terminal by truck or rail;

[0010] Data processing module: matches the truck or rail transport data in the historical logistics database with the geographic coordinate database to determine the recommended coal source, or the recommended coal-using terminal, or the coal source within a certain range of the shipping platform, or the coal-using terminal within a certain range of the arrival platform;

[0011] Result output module: Based on the query content input by the user, it outputs the recommended coal source calculated by the data processing module, or the recommended coal-using terminal, or the coal source within a certain range of the shipping platform, or the coal-using terminal within a certain range of the arrival platform.

[0012] Furthermore, the data processing module matches the road or rail logistics transportation data in the historical logistics database in the geographic coordinate database, including: matching the shipper and consignee in the rail logistics transportation data in the geographic coordinate database; if the shipper or consignee can be matched to the coal source or coal-using terminal, the rail transportation route is set as a recommended route; a coal source that can provide the same or similar coal quality indicators within a certain range of the determined coal source is used as a recommended coal source; or, other coal-using terminals with the same required coal quality indicators within a certain range of the determined coal-using terminal are used as recommended coal-using terminals; the transportation route between the recommended coal source and the recommended coal-using terminal uses the recommended route.

[0013] Furthermore, if the shipper or consignee of the rail logistics transport data cannot be matched to a coal source or coal-using terminal, determine the coal source within a certain range of the shipping platform of the rail transport route, and the coal-using terminal within a certain range of the arrival platform, and use the rail transport route as the recommended supply and demand route for the coal source within a certain range of the shipping platform and the coal-using terminal within a certain range of the arrival platform.

[0014] Furthermore, the data processing module matches the road or rail logistics transportation data in the historical logistics database with the geographic coordinate database, and also includes: matching the starting point coordinates of the road logistics transportation data with the gathering point coordinates in the geographic coordinate database, using the coal source within a certain distance of the starting point coordinates as the recommended coal source for the road logistics transportation route, using the coal-using terminal within a certain range of the gathering point coordinates as the recommended coal-using terminal for the road logistics transportation route, and using the road logistics transportation route as the recommended coal source and the recommended coal-using terminal. Recommended supply and demand route.

[0015] Furthermore, the data processing module also includes preprocessing the underlying database data, and the preprocessing includes: unifying the coordinates of each coal source and coal-using terminal in the geographic coordinate database into the same coordinate system, and standardizing and unifying the names of the coal sources and coal-using terminals that appear in the underlying database.

[0016] Furthermore, the data processing module is also used to automatically sort the recommended supply and demand routes between the recommended coal sources and the recommended coal-using terminals, and the sorting method adopts historical logistics volume sorting or logistics cost sorting.

[0017] Furthermore, the historical logistics volume sorting includes: sorting according to the historical logistics volume of the recommended supply and demand routes, with routes with large historical logistics volumes being ranked higher and routes with low historical logistics volumes being ranked lower.

[0018] Furthermore, the logistics cost ranking includes: establishing a road and rail logistics cost model, and calculating the road transportation cost according to the road and rail logistics cost model through the formula: per-kilometer freight coefficient × number of kilometers, wherein the per-kilometer freight coefficient is provided with a dynamic value by the logistics operation team, and the road and rail logistics cost model is based on the rail transportation data provided by the China Railway 95306 website to calculate the rail transportation cost. The lower the cost of the road or rail transportation, the higher the ranking, and the higher the cost of the road or rail transportation, the lower the ranking.

[0019] Furthermore, it also includes a user terminal, through which the coal source or coal user terminal inputs a query instruction to obtain the output content of the result output module.

[0020] This application adopts the above technical solution, which has at least the following beneficial effects:

[0021] This application establishes an underlying database to analyze road or rail logistics transportation data. For coal source users, it provides other recommended coal-using terminals. For coal-using terminal customers, it provides other recommended coal sources for coal-using terminals. This application provides diversified choices for coal sources and coal-using terminals, breaks through the limitations of acquaintance networks, broadens the boundaries of supply and demand channel matching, reduces intermediate trade links, and realizes direct connection from coal sources to terminal enterprises.

[0022] It should be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the present application. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without any creative work.

[0024] Figure 1 This is a system diagram illustrating a coal sales and procurement route rapid matching system based on a big data platform according to an exemplary embodiment;

[0025] Figure 2 This is a process architecture diagram of a coal sales and procurement line rapid matching system based on a big data platform according to an exemplary embodiment;

[0026] In the attached figure: 1- underlying database, 101- geographic coordinate database, 102- coal index database, 103- historical logistics database, 2- data processing module, 3- result output module. DETAILED DESCRIPTION

[0027] To make the purpose, technical solutions, and advantages of this application more clear, the technical solutions of this application will be described in detail below. Obviously, the embodiments described are only some of the embodiments of this application, rather than all of them. Based on the embodiments in this application, all other implementation methods obtained by ordinary technicians in this field without making any creative work are within the scope of protection of this application.

[0028] See also Figure 1 , Figure 1 This is a system diagram illustrating a fast matching system for coal sales and purchase routes based on a big data platform according to an exemplary embodiment. The system is applied in the field of coal trading technology and includes:

[0029] The underlying database 1 includes a geographic coordinate database 101, a coal index database 102, and a historical logistics database 103;

[0030] The geographic coordinate database 101 includes the geographic coordinates of coal sources, platforms and coal-using terminals;

[0031] The coal index database 102 includes coal source quality indicators that can be provided by coal sources and coal source quality indicators required by coal-using terminals;

[0032] The historical logistics database 103 includes logistics transportation data of coal sources supplied to a terminal by truck or rail;

[0033] Data processing module 2: matches the truck or rail transport data in the historical logistics database 103 with the geographic coordinate database 101 to determine a recommended coal source, or a recommended coal-using terminal, or a coal source within a certain range of the shipping platform, or a coal-using terminal within a certain range of the arrival platform;

[0034] Result output module 3: outputs the recommended coal source calculated by data processing module 2, or the recommended coal-using terminal, or the coal source within a certain range of the shipping platform, or the coal-using terminal within a certain range of the arrival platform, according to the query content input by the user;

[0035] Specifically, the present application constructs a geographic coordinate database 101 through the geographic coordinates of upstream coal sources (coal mines, coal washing plants), freight stations and downstream coal-using terminals (power plants, cement plants, chemical plants, paper mills), and establishes a coal index database 102 by collecting coal source quality indicators that can be provided by coal mines or coal washing plants, such as calorific value, sulfur content, etc., as well as coal indicators burned by coal-using terminal boilers. By collecting logistics data of coal supplied by coal mines or coal washing plants to a certain terminal in the form of road or rail transportation, where the collection channels include transaction platform retention, logistics platform retention, manual collection, etc., after the underlying database 1 is established, the data in the underlying database 1 is standardized, and the road or rail transportation logistics transportation data in the historical logistics database 103 is matched in the geographic coordinate database 101 to generate each determined The user can enter the name of the coal source or the coal-using terminal to view other recommended coal sources or coal-using terminals, thereby providing users with diversified choices. Alternatively, the user can enter the name of the shipping platform or the receiving platform to obtain the coal sources near the shipping platform and the coal-using terminals near the receiving platform. This application provides users with diversified choices, both for the coal source and the coal-using terminal, thereby avoiding the situation in the prior art where the coal-using terminal can only purchase coal mines or the coal source can only sell coal mines to the coal-using terminal through introductions from acquaintances or online chats such as QQ groups and WeChat groups. First, the middlemen who do sales on the Internet usually increase costs, and there is a risk of being defrauded, and the communication efficiency is also low. In addition, due to the limited social circle, the procurement and sales channels are undoubtedly restricted.

[0036] Specifically, the establishment of the underlying database 1 includes:

[0037] The geographic coordinate database consists of the following steps: first, a list of all coal mines, coal washing plants, freight stations, and coal-using enterprises in my country, along with their geographic locations, is collected from sources including but not limited to publicly available information from relevant national authorities, industry websites, Qichacha, and manual collection. Secondly, the geographic coordinates of coal mines, coal washing plants, freight stations, and coal-using enterprises are determined by combining publicly available geographic coordinate information from relevant national authorities, map data from Baidu and Amap, and manual review. Manual review is required to determine the coordinates of the query object, as it is not possible to directly locate the coordinates of the query object within the existing geographic coordinate system. Instead, the coordinates of the query object are determined within a satellite map, taking into account the province, city, district, county, town, village, and the appearance of the coal mine, station, and coal-using terminal. For example, after determining the name of the village where a thermal power plant is located, the geographic coordinates of the plant's essential equipment, such as the cooling tower and chimney, are then combined to determine its location.

[0038] The coal index database includes coal quality indicators provided by coal sources and those required by coal users, including but not limited to coal calorific value, sulfur content, and moisture content. This database is primarily collected through online coal trading platforms, coal-related websites, corporate bidding websites, and manual telephone collection.

[0039] The historical logistics database includes logistics and transportation data for coal delivered to a specific terminal via road or rail transport. Road transport logistics and transportation data is provided by vehicle monitoring and operation companies. This data includes the coordinates of the starting point and gathering point for a specific vehicle type, as well as the number of vehicles gathered during a specified time period. Coordinate analysis requires close integration with the geographic coordinate database. Rail transport logistics and transportation data is basic coal shipment data from railway bureaus nationwide in recent years. This data includes the shipping platform, arrival platform, shipper name, consignee name, and shipment quantity.

[0040] Furthermore, the data processing module 2 matches the road or rail logistics data in the historical logistics database 103 with the geographic coordinate database 101, including: matching the shipper and consignee in the rail logistics data with the geographic coordinate database 101; if the shipper or consignee can be matched with a coal source or a coal-using terminal, setting the rail transportation route as a recommended route; using a coal source with the same or similar coal quality index within a certain range of the determined coal source as the recommended coal source, or using other coal-using terminals with the same required coal quality index within a certain range of the determined coal-using terminal as the recommended coal-using terminal; and using the recommended route as the transportation route between the recommended coal source and the recommended coal-using terminal;

[0041] Specifically, as attached Figure 2 As shown, after the underlying database 1 is established, the data processing module 2 matches the shipper name and the consignee name in the rail logistics transportation data in the geographic coordinate database 101. If one party can be matched in the geographic coordinate database 101, it means that the supply and demand relationship of the rail logistics transportation route is clear. The geographic coordinate database 101 is searched for other coal sources or coal-using terminals with the same or similar characteristics within a certain range of the determined coal source or coal-using terminal. The coal source quality index of the determined coal source or coal-using terminal is searched in the coal index database 102. The coal sources or coal-using terminals within a certain range are screened. The remaining ones are the recommended coal sources or recommended coal-using terminals for the determined coal source or coal-using terminal. The transportation route between the multiple recommended coal sources or recommended coal-using terminals is the rail transportation route. The detailed determination process is as follows: coal sources with similar indicators within 5 kilometers around the coal source are used as intelligent recommended coal sources, and terminals with similar indicators within 5 kilometers around the terminal are used as intelligent recommended terminals; 0-2 kilometers are key coal-using terminals, and 2-5 kilometers are other coal-using terminals.

[0042] Among them, the judgment criteria for similar indicators are: based on the calorific value of coal, calorific value ≤4700K is regarded as a 4500K variety, 4700K<calorific value ≤5200K is regarded as a 5000K variety, 5200K<calorific value ≤5700K is regarded as a 5500K variety, and calorific value >5700K is regarded as a 5800K variety.

[0043] Furthermore, if neither the shipper nor the consignee of the rail transport logistics data can be matched to a coal source or coal-consuming terminal, the coal source within a certain range of the shipping platform of the rail transport route and the coal-consuming terminal within a certain range of the arrival platform are determined, and the rail transport route is used as a recommended supply and demand route for the coal source within a certain range of the shipping platform and the coal-consuming terminal within a certain range of the arrival platform;

[0044] Specifically, because in the rail logistics transportation data, the shipper or the consignee may be a trader, in this case, the coal source within a certain range of the shipping platform and the coal-using terminal within a certain range of the arrival platform of the rail transportation route are determined, and the rail transportation route is used as the recommended supply and demand route between the coal source within a certain range of the shipping platform and the coal-using terminal within a certain range of the arrival platform. The detailed determination method is: match the coal source within 50 kilometers of the shipping platform and the coal-using terminal within 50 kilometers of the arrival platform, and use the rail transportation route as the recommended supply and demand route between the coal source and the coal-using terminal.

[0045] Furthermore, the data processing module 2 matches the automobile or rail transportation data in the historical logistics database 103 with the geographic coordinate database 101, further comprising: matching the starting point coordinates of the automobile transportation data with the gathering point coordinates in the geographic coordinate database 101, using the coal sources within a certain distance of the starting point coordinates as the recommended coal sources for the automobile transportation route, using the coal-using terminals within a certain range of the gathering point coordinates as the recommended coal-using terminals for the automobile transportation route, and using the automobile transportation route as the recommended supply and demand route for the recommended coal sources and the recommended coal-using terminals;

[0046] Specifically, in addition to rail transportation, coal sources are also shipped to coal-using terminals by road transportation. The road transportation logistics data includes information such as vehicle type, starting point coordinates, gathering point coordinates, and gathering times. Matching is performed in the geographic coordinate database 101 based on the starting point coordinates and the gathering point coordinates. If the starting point coordinates are ≤5 kilometers away from the coordinates of a certain coal source in the geographic coordinate database 101, the coal source is used as the recommended coal source for the road transportation route. If the gathering point coordinates are ≤5 kilometers away from the coordinates of a certain coal-using terminal in the geographic coordinate database 101, the coal-using terminal is used as the recommended coal-using terminal for the road transportation route. Among them, the coal-using terminals within 0-2 kilometers are key coal-using terminals, and the coal-using terminals within 2-5 kilometers are other coal-using terminals. The road transportation data route is used as the recommended supply and demand route between the recommended coal source and the recommended coal-using terminal.

[0047] Furthermore, the data processing module 2 further includes preprocessing the data in the underlying database 1, wherein the preprocessing includes: unifying the coordinates of each coal source and coal-using terminal in the geographic coordinate database 101 into the same coordinate system, and standardizing and unifying the names of the coal sources and coal-using terminals appearing in the underlying database 1;

[0048] Specifically, in order to facilitate the calculation of the physical distance between two points and prepare for freight calculation, all coordinates are unified into the same coordinate system. In order to avoid misleading recommendation results due to multiple names for one entity, naming standards are formulated for all coal sources and coal-using terminals (a total of more than 15,000) to ensure that the names point to uniqueness.

[0049] Furthermore, the data processing module 2 is further configured to automatically sort the recommended supply and demand routes between the recommended coal sources and the recommended coal-using terminals, wherein the sorting method adopts historical logistics volume sorting or logistics cost sorting;

[0050] Specifically, since the costs of various recommended supply and demand routes are different, different recommended routes need to be sorted. This application provides two sorting methods: sorting by historical logistics volume or sorting by logistics cost.

[0051] Furthermore, the historical logistics volume ranking includes: ranking according to the historical logistics volume of the recommended supply and demand routes, with routes with large historical logistics volumes being ranked higher and routes with low historical logistics volumes being ranked lower;

[0052] Specifically, the larger the transport volume of the recommended supply and demand route, the more mature and cost-effective the supply and demand route is. Therefore, routes with large transport volumes are ranked higher, which helps users screen out better recommended supply and demand routes.

[0053] Furthermore, the logistics cost ranking includes: establishing a road transport and rail transport logistics cost model, and calculating the road transport cost according to the road transport and rail transport logistics cost model by using the formula: per-kilometer freight coefficient × number of kilometers, wherein the per-kilometer freight coefficient is provided by a dynamic value by the logistics operation team, and the road transport and rail transport logistics cost model is based on rail transport data provided by the China Railway 95306 website to calculate the rail transport cost, wherein the lower the road transport or rail transport cost, the higher the ranking, and the higher the road transport or rail transport cost, the lower the ranking;

[0054] Specifically, for the sorting method based on logistics cost, a road and rail logistics cost model is first established. In the present invention, the road transportation cost is calculated based on the freight coefficient per kilometer × the number of kilometers, where the freight coefficient per kilometer is provided with a dynamic value by a mature logistics operation team; the rail logistics cost is calculated based on the data provided by the China Railway 95306 website, and it is shown that the lower the logistics cost, the higher the recommended ranking.

[0055] Furthermore, it also includes a user terminal, through which the coal source or coal user terminal inputs a query instruction to obtain output content of the result output module;

[0056] Specifically, the coal source end or the coal-using terminal uses the user end, which can be a website, APP, etc. By inputting the instructions to be queried on the user end, such as a coal mine, a station, a terminal, etc., the user end retrieves the recommended coal source or recommended coal-using terminal output by the result output module 3, as well as the corresponding logistics routes, cost composition and other information.

[0057] It can be understood that the same or similar parts of the above embodiments can be referenced to each other, and the contents not described in detail in some embodiments can refer to the same or similar contents in other embodiments.

[0058] It should be noted that, in the description of this application, the terms "first," "second," etc. are used for descriptive purposes only and should not be understood as indicating or implying relative importance. In addition, in the description of this application, unless otherwise specified, the meaning of "plurality" or "multiple" is at least two.

[0059] It should be understood that when an element is referred to as being "fixed to" or "disposed on" another element, it can be directly on the other element or there may be an intermediate element at the same time; when an element is referred to as being "connected to" another element, it can be directly connected to the other element or there may be an intermediate element at the same time. In addition, the "connection" used here may include wireless connection; the wording "and / or" used includes any unit and all combinations of one or more associated listed items.

[0060] Any process or method description in a flowchart or otherwise described herein may be understood to represent a module, segment or portion of code comprising one or more executable instructions for implementing the steps of a specific logical function or process, and the scope of the preferred embodiments of the present application includes alternative implementations in which functions may be performed out of the order shown or discussed, including performing functions in a substantially simultaneous manner or in the reverse order depending on the functions involved, which should be understood by those skilled in the art to which the embodiments of the present application belong.

[0061] It should be understood that various parts of the present application can be implemented using hardware, software, firmware, or a combination thereof. In the above embodiments, multiple steps or methods can be implemented using software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented using hardware, as in another embodiment, any one of the following technologies known in the art or a combination thereof can be used to implement: a discrete logic circuit having a logic gate circuit for implementing a logic function on a data signal, an application-specific integrated circuit having a suitable combination of logic gate circuits, a programmable gate array (PGA), a field programmable gate array (FPGA), etc.

[0062] Those skilled in the art will understand that all or part of the steps in the method of the above embodiment can be completed by instructing related hardware through a program, and the program can be stored in a computer-readable storage medium. When the program is executed, it includes one or a combination of the steps of the method embodiment.

[0063] In addition, the functional units in the various embodiments of the present application may be integrated into a processing module, or each unit may exist physically separately, or two or more units may be integrated into a module. The above-mentioned integrated module may be implemented in the form of hardware or in the form of a software functional module. If the integrated module is implemented in the form of a software functional module and sold or used as an independent product, it may also be stored in a computer-readable storage medium.

[0064] The storage medium mentioned above can be a read-only memory, a magnetic disk or an optical disk, etc.

[0065] Throughout this specification, reference to terms such as "one embodiment," "some embodiments," "examples," "specific examples," or "some examples" means that a specific feature, structure, material, or characteristic described in conjunction with that embodiment or example is included in at least one embodiment or example of the present application. In this specification, schematic representations of the above terms do not necessarily refer to the same embodiment or example. Furthermore, the specific features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.

[0066] Although the embodiments of the present application have been shown and described above, it can be understood that the above embodiments are exemplary and cannot be understood as limitations on the present application. Ordinary technicians in this field can change, modify, replace and modify the above embodiments within the scope of the present application.

Claims

1. A coal sales and procurement line rapid matching system based on a big data platform, characterized by: The system comprises: An underlying database, comprising: a geographic coordinate database, a coal index database, and a historical logistics database; The geographic coordinate database includes the geographic coordinates of coal sources, platforms and coal-using terminals; The coal index database includes coal source quality indicators that can be provided by coal sources and coal source quality indicators required by coal-using terminals; The historical logistics database includes logistics transportation data of coal source supplied to a terminal by truck or rail; Data processing module: Matching the road or rail transport data in the historical logistics database with the geographic coordinate database to determine the recommended coal source, or determine the recommended coal terminal, or determine the coal source within a certain range of the shipping platform, or determine the coal terminal within a certain range of the arrival platform; the data processing module matches the road or rail transport data in the historical logistics database with the geographic coordinate database, including: matching the shipper and consignee in the rail transport data with the geographic coordinate database; if the shipper or consignee can be matched to the coal source or coal terminal, setting the rail transport route corresponding to the shipper and consignee as the recommended route , coal sources that can provide the same or similar coal quality indicators within a certain range of the determined coal source are recommended as coal sources, or other coal-consuming terminals with the same required coal quality indicators within a certain range of the determined coal-consuming terminal are recommended as coal-consuming terminals, and the transportation route between the recommended coal source and the recommended coal-consuming terminal uses the recommended route; if neither the shipper nor the consignee of the rail logistics transportation data can be matched to a coal source or a coal-consuming terminal, the coal sources within a certain range of the shipping platform of the rail transportation route and the coal-consuming terminals within a certain range of the arrival platform are determined, and the rail transportation route is used as the recommended supply and demand route for the coal sources within the certain range of the shipping platform and the coal-consuming terminals within the certain range of the arrival platform; Result output module: Based on the query content input by the user, it outputs the recommended coal source calculated by the data processing module, or the recommended coal-using terminal, or the coal source within a certain range of the shipping platform, or the coal-using terminal within a certain range of the arrival platform.

2. A coal sales and purchase line fast matching system based on a big data platform according to claim 1, characterized in that: The data processing module matches the road or rail logistics transportation data in the historical logistics database with the geographic coordinate database, and also includes: matching the starting point coordinates of the road logistics transportation data with the gathering point coordinates in the geographic coordinate database, using the coal source within a certain distance of the starting point coordinates as the recommended coal source for the road logistics transportation route, using the coal-using terminal within a certain range of the gathering point coordinates as the recommended coal-using terminal for the road logistics transportation route, and using the road logistics transportation route as the recommended supply and demand route for the recommended coal source and the recommended coal-using terminal.

3. The coal sales and purchase line fast matching system based on big data platform according to claim 1 is characterized in that: The data processing module also includes preprocessing the underlying database data, which includes: unifying the coordinates of each coal source and coal-using terminal in the geographic coordinate database into the same coordinate system, and standardizing and unifying the names of the coal sources and coal-using terminals that appear in the underlying database.

4. A coal sales and purchase line fast matching system based on a big data platform according to claim 1 or 2, characterized in that: The data processing module is further configured to automatically sort the recommended supply and demand routes between the recommended coal sources and the recommended coal-using terminals, wherein the automatic sorting method adopts historical logistics volume sorting or logistics cost sorting.

5. A coal sales and purchase line fast matching system based on a big data platform according to claim 4, characterized in that: The historical logistics volume sorting includes: sorting according to the historical logistics volume of the recommended supply and demand routes, with the routes with large historical logistics volumes being ranked higher and the routes with low historical logistics volumes being ranked lower.

6. A coal sales and purchase line fast matching system based on a big data platform according to claim 4, characterized in that: The logistics cost ranking includes: establishing a road and rail logistics cost model, and calculating the road transportation cost according to the road and rail logistics cost model through the formula: per-kilometer freight coefficient × number of kilometers, wherein the per-kilometer freight coefficient is provided with a dynamic value by the logistics operation team. The road and rail logistics cost model is based on the rail transportation data provided by the China Railway 95306 website to calculate the rail transportation cost. The lower the cost of the road or rail transportation, the higher the ranking, and the higher the cost of the road or rail transportation, the lower the ranking.

7. The coal sales and purchase line fast matching system based on big data platform according to claim 1 is characterized in that: It also includes a user terminal, through which the coal source or coal user terminal inputs a query instruction to obtain the output content of the result output module.

Images