CN117453774A - Cross-platform information joint query method and device, electronic equipment and storage medium - Google Patents
Cross-platform information joint query method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN117453774A CN117453774A CN202311781341.2A CN202311781341A CN117453774A CN 117453774 A CN117453774 A CN 117453774A CN 202311781341 A CN202311781341 A CN 202311781341A CN 117453774 A CN117453774 A CN 117453774A
- Authority
- CN
- China
- Prior art keywords
- query
- field information
- information
- platform
- cross
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 43
- 238000004590 computer program Methods 0.000 claims description 10
- 230000003993 interaction Effects 0.000 abstract description 15
- 238000012545 processing Methods 0.000 abstract description 11
- 230000004044 response Effects 0.000 abstract description 10
- 238000001514 detection method Methods 0.000 description 11
- 238000013475 authorization Methods 0.000 description 10
- 238000004891 communication Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 5
- 230000008569 process Effects 0.000 description 5
- 238000001914 filtration Methods 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 238000013500 data storage Methods 0.000 description 2
- 238000003745 diagnosis Methods 0.000 description 2
- 239000000463 material Substances 0.000 description 2
- 230000000007 visual effect Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000036541 health Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000002035 prolonged effect Effects 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000033772 system development Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2471—Distributed queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
- G06F16/24578—Query processing with adaptation to user needs using ranking
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Fuzzy Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to the technical field of computers, and provides a cross-platform information joint query method, a device, electronic equipment and a storage medium, wherein the method comprises the following steps: acquiring inquiry field information; matching the first stored field information based on the query field information; if the matching is successful, based on the query field information, carrying out information query on the capacity pool storage system to obtain first target field information; based on the query field information and the first target field information, carrying out information query in the data platform center to obtain second target field information; based on the second target field information, a cross-platform query result is determined. The cross-platform information joint query method provided by the embodiment of the invention can avoid generating a large amount of network interaction through joint query between two platforms, reduce the processing pressure of a server and the query pressure of a database, also can meet the complex query and display requirements of a service system, and improve the query performance and the query response efficiency, thereby improving the user satisfaction.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a cross-platform information joint query method, a device, an electronic device, and a storage medium.
Background
As the enterprise scale expands, different cloud software systems are owned, and data storage between the different systems is relatively independent, so that it is difficult to perform data interaction and use through the different systems. Even if data can be queried from different systems, a large amount of network interaction can be generated due to huge data query amount, so that the database is stressed greatly, and the response time of an interface is prolonged; on the other hand, only a very simple query function is developed, the query performance is not high, the service use is affected, and the query response efficiency is low.
Disclosure of Invention
The embodiment of the invention provides a cross-platform information joint query method, a device, electronic equipment and a storage medium, which are used for solving the problems of low query performance and low query response efficiency of a system.
In a first aspect, an embodiment of the present invention provides a cross-platform information joint query method, including:
acquiring inquiry field information;
matching the first stored field information based on the query field information; the first storage field information is field information stored in a database in the capacity pool storage system;
If the matching is successful, carrying out information query on the capacity pool storage system based on the query field information to obtain first target field information;
based on the query field information and the first target field information, carrying out information query in a data platform center to obtain second target field information; the data platform center is used for storing basic information of the vehicle;
and determining a cross-platform query result based on the second target field information.
In one embodiment, the determining the cross-platform query result based on the second target field information includes:
sorting the second target field information in a descending order to obtain second query sorting field information;
paging the second query ordering field information to obtain a first paging result;
and determining a cross-platform query result based on first field information of a first page in the first paging result.
In one embodiment, the determining the cross-platform query result based on the first field information of the first page in the first paging result includes:
based on the first field information, carrying out information query on the capacity pool storage system to obtain first home page field information;
And splicing the first field information and the first home page field information to obtain the cross-platform query result.
In one embodiment, the performing information query in a data platform center based on the query field information and the first target field information to obtain second target field information includes:
correlating the query field information with the first target field information to obtain target query field information;
and carrying out information query in a data platform center according to the target query field information to obtain second target field information.
In one embodiment, after said matching the first stored field information based on said query field information, further comprising:
if the matching fails, carrying out information query on the data platform center based on the query field information to obtain third target field information;
sorting the third target field information in a descending order to obtain third query sorting field information;
paging the third query ordering field information to obtain a second paging result;
and determining the cross-platform query result based on second field information of the first page in the second page splitting result.
In one embodiment, the determining the cross-platform query result based on the second field information of the first page in the second split result includes:
based on the second field information, carrying out information query on the capacity pool storage system to obtain second home page field information;
and splicing the second field information and the second home page field information to obtain the cross-platform query result.
In one embodiment, after the matching is successful, further comprising:
acquiring user login account information;
determining user-bound tenant information based on the user login account information;
based on the query field information and the tenant information, carrying out information query on the capacity pool storage system to obtain fourth target field information;
based on the query field information and the fourth target field information, carrying out information query in the data platform center to obtain fifth target field information;
and determining the cross-platform query result based on the fifth target field information.
In a second aspect, an embodiment of the present invention provides a cross-platform information joint query apparatus, including:
the device comprises an acquisition module, a processing module and a processing module, wherein the acquisition module is used for receiving a device diagnosis task and acquiring device information of target devices in the device diagnosis task in a target time period; the equipment information comprises data reporting information and equipment connection state information;
The first detection module is used for detecting the report information of the target equipment based on the data report information to obtain a first detection result;
the second detection module is used for detecting the offline state of the target equipment based on the equipment connection state information to obtain a second detection result;
the third detection module is used for carrying out connection state switching detection on the target equipment based on the equipment connection state information to obtain a third detection result;
and the determining module is used for determining the health degree detection result of the target equipment based on the first detection result, the second detection result and the third detection result.
In a third aspect, an embodiment of the present invention provides an electronic device, including a processor and a memory storing a computer program, where the processor implements the cross-platform information joint query method according to the first aspect when executing the program.
In a fourth aspect, an embodiment of the present invention provides a storage medium, where the storage medium is a computer readable storage medium, including a computer program, where the computer program when executed by a processor implements the cross-platform information joint query method according to the first aspect.
According to the cross-platform information joint query method, the device, the electronic equipment and the storage medium, based on the acquired query field information, the first target field information is filtered and queried in the capacity pool storage system, the information to be queried and the network interface interaction times are reduced, further, based on the filtered small batch information, the second target field information is filtered and queried in the data platform center, the cross-platform query result is determined by maximally reducing the field information after the query information, the information joint query between the two platforms is realized, a large number of network interactions can be avoided, the server processing pressure and the database query pressure can be reduced, the complex query and display requirements of a service system can be met, the query performance and the query response efficiency are improved, and the user satisfaction is improved.
Drawings
In order to more clearly illustrate the invention or the technical solutions of the prior art, the following description will briefly explain the drawings used in the embodiments or the description of the prior art, and it is obvious that the drawings in the following description are some embodiments of the invention, and other drawings can be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flow diagram of a cross-platform information joint query method provided by an embodiment of the present invention;
FIG. 2 is a flowchart of an overall scheme of a cross-platform information joint query method provided by an embodiment of the invention;
FIG. 3 is a schematic diagram of functional modules of an embodiment of a cross-platform information joint query device according to the present invention;
fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the present invention more apparent, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is apparent that the described embodiments are some embodiments of the present invention, but not all embodiments. In the description of the present specification, a description referring to terms "one embodiment," "some embodiments," "examples," "specific examples," or "some examples," etc., means 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 embodiments of the present invention. In this specification, schematic representations of the above terms are not necessarily directed to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, the different embodiments or examples described in this specification and the features of the different embodiments or examples may be combined and combined by those skilled in the art without contradiction. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
The cross-platform information joint query method, the device, the electronic equipment and the storage medium provided by the invention are described in detail below by combining the embodiments.
Fig. 1 is a flow chart of a cross-platform information joint query method provided by an embodiment of the invention. Referring to fig. 1, an embodiment of the present invention provides a cross-platform information joint query method, which may include:
step 100, acquiring inquiry field information;
step 200, based on the query field information, matching first storage field information;
step 300, if the matching is successful, carrying out information query on the capacity pool storage system based on the query field information to obtain first target field information;
step 400, based on the query field information and the first target field information, performing information query in a data platform center to obtain second target field information;
step 500, determining a cross-platform query result based on the second target field information.
It should be noted that, the cross-platform information joint query method provided by the embodiment of the invention is realized based on the cross-platform information joint query device, the cross-platform information joint query method is applied to a transport pool storage system and a data platform center, the transport pool storage system is a cloud software system (Software as a Service, saaS) responsible for managing and monitoring transport vehicle information, the database in the transport pool storage system stores field information such as region, weChat authorization and positioning authorization, the data platform center is a unified management platform of transport vehicle basic information, each service platform can use platform information, and the consistency and universality of the transport vehicle basic information are ensured, and the database in the data platform center stores field information such as license plate numbers, driver mobile phone numbers, vehicle lengths, vehicle types, vehicle cooperation times and the like. The vehicle query page of the capacity pool storage system can be used for filtering and returning results through various conditions, and the capacity pool storage system can also be used for filtering and returning the results through an interface externally provided by the data platform center, so that the cross-platform information joint query method is described by taking the capacity pool storage system as an execution main body.
Specifically, when a user needs to schedule a transport vehicle, the user logs in a user account through a terminal device in a transport pool storage system, and further, after the user logs in successfully, the user inputs query field information in a search box of a vehicle query page of the transport pool storage system so as to realize cross-platform information joint query.
It should be noted that, the field information stored in the database in the capacity pool storage system and the field information stored in the database in the data platform center are not identical, the field information stored in the database in the capacity pool storage system includes but is not limited to regional field information, weChat authorization field information, positioning authorization field information and license plate number field information, and the field information stored in the database in the data platform center includes but is not limited to license plate number field information, driver mobile phone number field information, length field information, vehicle type field information and vehicle cooperation number field information. The license plate number field information is stored in the capacity pool storage system and the data platform center in the embodiment of the invention, that is, the license plate number field information can be used for associating the capacity pool storage system with the data platform center to realize cross-platform information joint query, but the license plate number field information is stored in the capacity pool storage system and the data platform center in the same way, and the same field information can be converted into other field information according to actual conditions.
It should be further noted that, the query field information input by the user may only include field information stored in the database in the capacity pool storage system, may only include field information stored in the database in the data platform center, or may also include field information stored in the database in the capacity pool storage system and field information stored in the database in the data platform center, but for different query field information, different query modes may be adopted, so after the capacity pool storage system obtains the query field information, the query field information needs to be matched with the field information stored in the database in the capacity pool storage system.
Further, the capacity pool storage system obtains query field information, and further, the capacity pool storage system matches first storage field information based on the query field information, wherein the first storage field information is field information stored by a database in the capacity pool storage system. It will thus be appreciated that the capacity pool storage system matches regional field information, weChat authorization field information, location authorization field information, and license plate number field information based on the query field information.
Further, if the matching is successful, determining query conditions according to query field information by the capacity pool storage system, and further, performing full information query on the capacity pool storage system according to the query conditions by the capacity pool storage system to obtain first target field information, wherein the query conditions are used for screening and filtering information to obtain information meeting the conditions, and the query conditions are preset according to the field information stored in the database in the process of system development; the first target field information refers to license plate number field information of the vehicle to which the field information conforming to the query condition belongs.
It should be noted that, in the capacity pool storage system, each vehicle corresponds to a license plate number field information, a region field information, a WeChat authorization field information and a positioning authorization field information, and the region field information, the WeChat authorization field information, the positioning authorization field information and the license plate number field information of each vehicle are associated and bound, so that the capacity pool storage system queries other field information of the vehicle to which the capacity pool storage system belongs according to the license plate number field information in the query process.
It can be understood that the capacity pool storage system determines the query condition according to the query field information, and further, the capacity pool storage system screens the field information meeting the query condition according to the query condition in the capacity pool storage system, determines the license plate number field information of the vehicle to which the capacity pool storage system belongs according to the field information meeting the query condition, and returns the license plate number field information.
In one embodiment, the query field information is "region a", the capacity pool storage system matches the region field information of the capacity pool storage system according to the query field information "region a", further, the capacity pool storage system determines the region query condition according to the query field information "region a", performs a full-scale information query on the capacity pool storage system according to the region query condition, determines the region B "of the region a and the region C" of the region a according to the region query condition, determines the license plate number field information of the vehicle to which the region B "of the region a belongs as" license plate number D ", determines the license plate number field information of the vehicle to which the region C" of the region a belongs as "license plate number E", and returns the license plate number D "and the license plate number E.
Further, the capacity pool storage system determines query conditions according to the query field information and the first target field information, and further, the capacity pool storage system queries information in the data platform center according to the query conditions to obtain second target field information, wherein the second target field information refers to all field information of vehicles in the data platform center, which belongs to the field information meeting the query conditions.
It should be noted that, in the data platform center, each vehicle corresponds to a license plate number field information, a driver mobile phone number field information, a length field information, a vehicle type field information and a vehicle cooperation number field information, and the driver mobile phone number field information, the length field information, the type field information, the vehicle cooperation number field information and the license plate number field information of each vehicle are associated and bound, so that the capacity pool storage system queries other field information of the vehicle to which the capacity pool storage system belongs according to the license plate number field information in the query process.
It can be understood that the capacity pool storage system determines the query condition according to the query field information and the first target field information, and further, the capacity pool storage system screens the field information meeting the query condition in the data platform center according to the query condition, determines all the field information of the vehicle in the data platform center according to the field information meeting the query condition, and returns all the field information of the vehicle in the data platform center.
Further, the capacity pool storage system determines a cross-platform query result based on the second target field information. It should be noted that the returned cross-platform query result is a data bar, and each data bar includes all field information queried by each vehicle based on the cross-platform information joint query process.
According to the cross-platform information joint query method provided by the embodiment of the invention, based on the acquired query field information, the first target field information is filtered and queried in the capacity pool storage system, the information to be queried and the network interface interaction times are reduced, the second target field information is filtered and queried in the data platform center based on the filtered small batch information, the cross-platform query result is determined by maximally reducing the field information after the query information, the information joint query between the two platforms is realized, a large amount of network interaction can be avoided, the server processing pressure and the database query pressure can be reduced, the complex query and display requirements of a service system can be met, the query performance and the query response efficiency are improved, and the user satisfaction is improved.
Further, based on the query field information and the first target field information in step 400, performing information query in a data platform center to obtain second target field information, including:
Correlating the query field information with the first target field information to obtain target query field information;
and carrying out information query in a data platform center according to the target query field information to obtain second target field information.
Specifically, the capacity pool storage system correlates the query field information with the first target field information to obtain target query field information.
In one embodiment, the query field information is "regional a phone number B", and the first target field information is "license plate number C", so that the capacity pool storage system associates the query field information with the first target field information to obtain the target query field information as "regional a phone number B license plate number C".
Further, the capacity pool storage system determines query conditions according to the target query field information, and further, the capacity pool storage system queries information according to preset batches in the data platform center according to the query conditions to obtain second target field information, wherein the preset batches are set according to actual conditions.
It should be noted that, the returned first target field information, that is, the license plate number field information of the vehicle to which the field information meeting the query condition belongs may return 1000 license plates, if the information query is performed in the data platform center at one time, the query pressure will be increased, so that the query pressure of the words to the data platform center can be reduced by performing batch information query on the 1000 license plates according to the preset batch.
It can be understood that the capacity pool storage system determines the query condition according to the target query field information, further, the capacity pool storage system screens the field information meeting the query condition according to the preset batch in the data platform center according to the query condition, determines all the field information of the vehicle in the data platform center according to the field information meeting the query condition, and returns all the field information of the vehicle in the data platform center.
It should be noted that, if the query field information only includes field information stored in the database of the capacity pool storage system, the capacity pool storage system queries the information according to the preset batch at the data platform center based on the target query field information, and the returned information is all the field information of the vehicle to which the first target field information belongs at the data platform center.
In an embodiment, the preset batch is 1, the target query field information is "area a mobile phone number B license plate number C", the capacity pool storage system determines a mobile phone number query condition and a license plate number query condition according to the target query field information "area a mobile phone number B license plate number C", performs information query in the data platform center according to the mobile phone number query condition and the license plate number query condition, determines field information "mobile phone number B" and "license plate number C" which meet the mobile phone number query condition and the license plate number query condition, and determines that all field information of vehicles to which the field information "mobile phone number B" and "license plate number C" belong in the data platform center are "mobile phone number B", "license plate number C", "license plate length D", "vehicle type E", "vehicle cooperation number F", and returns "mobile phone number B", "license plate number C", "vehicle length D", "vehicle type E", "vehicle cooperation number F".
According to the embodiment of the invention, the query field information and the first target field information are associated to obtain the target query field information, the information query is carried out in the data platform center according to the target query field information to obtain the second target field information, and the query is carried out based on the associated and bound target query field information, so that the query can be carried out based on a plurality of field information at the same time, the accuracy and the efficiency of the query are improved, the complex query and display requirements of a service system can be met, and the user satisfaction is improved.
Further, based on the second target field information of step 500, determining a cross-platform query result includes:
sorting the second target field information in a descending order to obtain second query sorting field information;
paging the second query ordering field information to obtain a first paging result;
and determining a cross-platform query result based on first field information of a first page in the first paging result.
Specifically, the capacity pool storage system performs descending order sorting on the second target field information according to the vehicle cooperation times field information in the second target field information to obtain second query sorting field information. It should be noted that, the second query ranking field information includes a plurality of data pieces, and each data piece includes field information queried by each vehicle in the data platform center.
Further, the capacity pool storage system pages the second query ordering field information to obtain a first paging result. It should be noted that, in an embodiment, each page of the paged result obtained after paging may store 30 pieces of data with a size smaller than or equal to 30 pieces of data, if it is the last page, the number of pieces of data may be smaller than 30 pieces, that is, the first page of the paged result stores 1 st to 30 pieces of data of the second query ranking field information, the second page stores 31 st to 60 th pieces of data of the second query ranking field information, and so on, pushing to, and the last page stores 30 pieces of data of the inverse of the second query ranking field information.
Further, the capacity pool storage system determines a cross-platform query result based on first field information of a top page in the first paging result.
According to the embodiment of the invention, the second target field information is subjected to descending order to obtain the second query ordering field information, the second query ordering field information is subjected to paging to obtain the first paging result, the cross-platform query result is determined based on the first field information of the first page in the first paging result, the ordering of the returned information is realized through the number of vehicle cooperation times, so that the returned result is closer to the user selection, the requirements and preferences of the user can be better met, the user can conveniently and rapidly query the familiar and trusted transportation vehicle, the experience and the user satisfaction of the user system are improved, meanwhile, only a small amount of data is needed for each page after paging, and the information query is performed through a small amount of data, so that a large amount of network interaction is avoided, and the processing pressure of the server and the query pressure of the database are reduced.
Further, the determining a cross-platform query result based on the first field information of the first page in the first paging result includes:
based on the first field information, carrying out information query on the capacity pool storage system to obtain first home page field information;
and splicing the first field information and the first home page field information to obtain the cross-platform query result.
Specifically, the capacity pool storage system performs information query on the capacity pool storage system based on the first field information to obtain first home page field information, wherein the first home page field information comprises all field information except license plate number field information of a home page vehicle in the capacity pool storage system.
It can be understood that the capacity pool storage system determines the query condition according to the license plate number field information in the first field information of the front page in the first paging result, further, the capacity pool storage system screens the field information meeting the query condition in the capacity pool storage system according to the query condition, determines all the field information except the license plate number field information in the capacity pool storage system of the front page vehicle according to the field information meeting the query condition, and returns all the field information except the license plate number field information in the capacity pool storage system of the front page vehicle.
In an embodiment, the license plate number field information in the first field information of the first vehicle in the home page is "license plate number a", the fortune pool storage system determines a license plate number query condition according to the "license plate number a", and according to the license plate number query condition, the information query is performed in the fortune pool storage system, and it is determined that all the field information except the license plate number field information which meets the license plate number query condition is "region B", "WeChat C" and "location D".
It should be noted that, the default of the embodiment of the present invention is to return all relevant field information of the front page vehicle, and when the user wants to query all relevant field information of the nth page vehicle, the capacity pool storage system queries and returns all relevant field information of the nth page vehicle according to the above manner.
Further, the capacity pool storage system splices the first field information and the first home page field information to obtain a cross-platform query result.
In an embodiment, the first field information is "mobile phone number a", "license plate number B", "vehicle length C", "vehicle type D", "vehicle cooperation number E", and the first home page field information is "region F", "WeChat G", "location H", so that the capacity pool storage system splices the first field information and the first home page field information, and the obtained cross-platform query result is "mobile phone number a license plate number B vehicle length C vehicle type D vehicle cooperation number E region F WeChat G location H".
According to the embodiment of the invention, based on the first field information, information inquiry is carried out on the capacity pool storage system to obtain first home page field information, the first field information and the first home page field information are spliced to obtain cross-platform inquiry results, information inquiry is carried out on screened small batch data obtained after paging, a large amount of network interaction can be avoided, the processing pressure of a server and the inquiry pressure of a database are reduced, complex inquiry and display requirements of a service system can be met, inquiry performance and inquiry response efficiency are improved, and meanwhile, the cross-platform inquiry results obtained through field information splicing are output in a page visual mode, so that a user can conveniently and comprehensively check and know vehicle information, and user system experience and user satisfaction are improved.
Further, after the matching of the first stored field information based on the query field information, the method further includes:
if the matching fails, carrying out information query on the data platform center based on the query field information to obtain third target field information;
sorting the third target field information in a descending order to obtain third query sorting field information;
Paging the third query ordering field information to obtain a second paging result;
and determining the cross-platform query result based on second field information of the first page in the second page splitting result.
Specifically, if the matching fails, determining a query condition according to the query field information by the capacity pool storage system, and further, performing full-quantity information query on the data platform center by the capacity pool storage system according to the query condition to obtain third target field information, wherein the third target field information refers to all field information of vehicles in the data platform center, which belongs to the field information meeting the query condition.
Further, the capacity pool storage system performs descending order sorting on the third target field information according to the vehicle cooperation times field information in the third target field information to obtain third query sorting field information. It should be noted that, the third query ranking field information includes a plurality of data pieces, and each data piece includes field data queried by each vehicle in the data platform center.
Further, the capacity pool storage system pages the third query ordering field information to obtain a second page splitting result, and further, the capacity pool storage system determines a cross-platform query result based on second field information of a first page in the second page splitting result.
According to the embodiment of the invention, after matching fails, information inquiry is performed in a data platform center based on inquiry field information to obtain third target field information, descending order is performed on the third target field information, sorting is performed again to obtain a second sorting result, a cross-platform inquiry result is determined based on the second field information of the first page in the second sorting result, sorting of returned information is realized through vehicle cooperation times, so that the returned result is closer to user selection, the requirements and preferences of users can be better met, users can conveniently and quickly inquire familiar and trusted transportation vehicles, user system experience and user satisfaction are improved, meanwhile, information inquiry is performed through a small amount of data of each page after sorting, a large amount of network interaction is avoided, and server processing pressure and database inquiry pressure are reduced.
Further, the determining the cross-platform query result based on the second field information of the first page in the second page splitting result includes:
based on the second field information, carrying out information query on the capacity pool storage system to obtain second home page field information;
And splicing the second field information and the second home page field information to obtain the cross-platform query result.
Specifically, the capacity pool storage system performs information query on the capacity pool storage system based on the second field information to obtain second home page field information, wherein the second home page field information comprises all field information except license plate number field information of the home page vehicle in the capacity pool storage system.
It can be understood that the fortune pool storage system determines the query condition according to the license plate number field information in the second field information of the first page in the second page splitting result, and further, the fortune pool storage system screens the field information meeting the query condition in the fortune pool storage system according to the query condition, determines all the field information except the license plate number field information in the fortune pool storage system of the first page vehicle according to the field information meeting the query condition, and returns all the field information except the license plate number field information in the fortune pool storage system of the first page vehicle.
Further, the capacity pool storage system splices the second field information and the second home page field information to obtain a cross-platform query result.
According to the embodiment of the invention, based on the second field information, information inquiry is carried out on the capacity pool storage system to obtain second home page field information, the second field information and the second home page field information are spliced to obtain cross-platform inquiry results, information inquiry is carried out on screened small batch data obtained after paging, a large amount of network interaction can be avoided, the processing pressure of a server and the inquiry pressure of a database are reduced, complex inquiry and display requirements of a service system can be met, inquiry performance and inquiry response efficiency are improved, and meanwhile, the cross-platform inquiry results obtained through field information splicing are output in a page visual mode, so that a user can conveniently and comprehensively check and know vehicle information, and user system experience and user satisfaction are improved.
Further, after the matching is successful, the method further comprises:
acquiring user login account information;
determining user-bound tenant information based on the user login account information;
based on the query field information and the tenant information, carrying out information query on the capacity pool storage system to obtain fourth target field information;
based on the query field information and the fourth target field information, carrying out information query in the data platform center to obtain fifth target field information;
And determining the cross-platform query result based on the fifth target field information.
Specifically, after the capacity pool storage system successfully matches the first storage field information, the capacity pool storage system acquires user login account information and determines user-bound tenant information based on the user login account information, wherein the tenant is a party b providing transport vehicle resources, and a contractual agreement relationship may exist between the user and the tenant, so that the user can automatically filter vehicle information provided by the tenant which has no cooperative relationship with the user in the process of inquiring vehicles.
Further, the capacity pool storage system determines a query condition according to the query field information and the tenant information, and further, the capacity pool storage system queries the total information in the capacity pool storage system according to the query condition to obtain fourth target field information, wherein the fourth target field information refers to license plate number field information of a vehicle to which the field information meeting the query condition belongs.
It can be understood that the capacity pool storage system determines the query condition according to the query field information, and further, the capacity pool storage system screens the field information meeting the query condition according to the query condition in the capacity pool storage system, determines the license plate number field information of the vehicle to which the capacity pool storage system belongs according to the field information meeting the query condition, and returns the license plate number field information.
Further, the capacity pool storage system correlates the query field information with fourth target field information to obtain fourth target query field information.
Further, the capacity pool storage system determines a query condition according to the fourth target query field information, and further, the capacity pool storage system queries information in the data platform center according to the query condition and a preset batch to obtain fifth target field information, wherein the fifth target field information refers to all field information of vehicles in the data platform center, which belongs to the field information meeting the query condition.
It can be understood that the capacity pool storage system determines the query condition according to the fifth target query field information, further, the capacity pool storage system screens the field information meeting the query condition in the data platform center according to the query condition, determines all the field information of the vehicle in the data platform center according to the field information meeting the query condition, and returns all the field information of the vehicle in the data platform center.
Further, the capacity pool storage system performs descending order sorting on the fifth target field information according to the vehicle cooperation times field information in the fifth target field information to obtain fifth inquiry sorting field information. It should be noted that, the fifth query ranking field information includes a plurality of data pieces, and each data piece includes field information queried by each vehicle in the data platform center.
Further, the capacity pool storage system performs paging on the fifth query ordering field information to obtain a third paging result, and further performs information query on the capacity pool storage system based on third field information of a front page in the third paging result to obtain third front page field information, wherein the third front page field information comprises all field information except license plate number field information of a front page vehicle in the capacity pool storage system.
It can be understood that the capacity pool storage system determines the query condition according to the license plate number field information in the third field information of the front page in the third paging result, further, the capacity pool storage system screens the field information meeting the query condition in the capacity pool storage system according to the query condition, determines all the field information except the license plate number field information in the capacity pool storage system of the front page vehicle according to the field information meeting the query condition, and returns all the field information except the license plate number field information in the capacity pool storage system of the front page vehicle.
Further, the capacity pool storage system splices the third field information and the third home page field information to obtain a cross-platform query result.
According to the embodiment of the invention, based on the acquired query field information and tenant information, the fourth target field information is filtered and queried in the capacity pool storage system, the interaction times of information to be queried and a network interface are reduced, the fifth target field information is filtered and queried in the data platform center based on the filtered small batch information, the cross-platform query result is determined by maximally reducing the field information after the query information, the information joint query between two platforms is realized, a large amount of network interactions can be avoided, the processing pressure of a server and the query pressure of a database are reduced, the complex query and display requirements of a service system can be met, the query performance and the query response efficiency are improved, and the user satisfaction is improved.
Further, referring to fig. 2, fig. 2 is a flowchart of an overall scheme of a cross-platform information joint query method provided by the embodiment of the present invention, so that the overall flow of the cross-platform information joint query method provided by the present invention can be understood as follows:
when the user needs to dispatch the transport vehicle, the user logs in the user account number through the terminal equipment in the transport capacity pool storage system, and further, after the user logs in successfully, the user inputs query field information in a search box of a vehicle query page of the transport capacity pool storage system.
Further, the capacity pool storage system obtains query field information, and further, the capacity pool storage system matches the first storage field information based on the query field information.
Further, if the matching is successful, the capacity pool storage system determines a query condition according to the query field information, and further, the capacity pool storage system queries the capacity pool storage system for the total information according to the query condition to obtain first target field information.
Further, the capacity pool storage system correlates the query field information with the first target field information to obtain target query field information.
Further, the capacity pool storage system determines query conditions according to the target query field information, and further, the capacity pool storage system queries information according to preset batches in the data platform center according to the query conditions to obtain second target field information.
Further, the capacity pool storage system performs descending order sorting on the second target field information according to the vehicle cooperation times field information in the second target field information to obtain second query sorting field information.
Further, the capacity pool storage system performs paging on the second query ordering field information to obtain a first paging result, and further, performs information query on the capacity pool storage system based on the first field information to obtain first top page field information.
Further, the capacity pool storage system splices the first field information and the first home page field information to obtain a cross-platform query result.
Further, if the matching fails, the capacity pool storage system determines a query condition according to the query field information, and further, the capacity pool storage system queries the total information in the data platform center according to the query condition to obtain third target field information.
Further, the capacity pool storage system performs descending order sorting on the third target field information according to the vehicle cooperation times field information in the third target field information to obtain third query sorting field information.
Further, the capacity pool storage system pages the third query ordering field information to obtain a second page division result, and further, the capacity pool storage system queries information in the capacity pool storage system based on the second field information to obtain second top page field information.
Further, the capacity pool storage system splices the second field information and the second home page field information to obtain a cross-platform query result.
Furthermore, the invention also provides a cross-platform information joint query device.
Referring to fig. 3, fig. 3 is a schematic diagram of functional modules of an embodiment of a cross-platform information joint query device according to the present invention.
The cross-platform information joint query device comprises:
an obtaining module 310, configured to obtain query field information;
a matching module 320, configured to match the first storage field information based on the query field information; the first storage field information is field information stored in a database in the capacity pool storage system;
a first query module 330, configured to query the capacity pool storage system for information based on the query field information if the matching is successful, to obtain first target field information;
a second query module 340, configured to query information in a data platform center based on the query field information and the first target field information, to obtain second target field information; the data platform center is used for storing basic information of the vehicle;
a determining module 350, configured to determine a cross-platform query result based on the second target field information.
According to the cross-platform information joint query device provided by the embodiment of the invention, based on the acquired query field information, the first target field information is filtered and queried in the capacity pool storage system, the information to be queried and the network interface interaction times are reduced, the second target field information is filtered and queried in the data platform center based on the filtered small batch information, the cross-platform query result is determined by maximally reducing the field information after the query information, the information joint query between the two platforms is realized, a large amount of network interaction can be avoided, the processing pressure of a server and the query pressure of a database are reduced, the complex query and display requirements of a service system can be met, the query performance and the query response efficiency are improved, and the user satisfaction is improved.
In one embodiment, the second query module 340 is further configured to:
correlating the query field information with the first target field information to obtain target query field information;
and carrying out information query in a data platform center according to the target query field information to obtain second target field information.
In one embodiment, the determining module 350 is further configured to:
sorting the second target field information in a descending order to obtain second query sorting field information;
paging the second query ordering field information to obtain a first paging result;
and determining a cross-platform query result based on first field information of a first page in the first paging result.
In one embodiment, the determining module 350 is further configured to:
based on the first field information, carrying out information query on the capacity pool storage system to obtain first home page field information;
and splicing the first field information and the first home page field information to obtain the cross-platform query result.
In one embodiment, the cross-platform information joint query apparatus is further configured to:
if the matching fails, carrying out information query on the data platform center based on the query field information to obtain third target field information;
Sorting the third target field information in a descending order to obtain third query sorting field information;
paging the third query ordering field information to obtain a second paging result;
and determining the cross-platform query result based on second field information of the first page in the second page splitting result.
In one embodiment, the cross-platform information joint query apparatus is further configured to:
based on the second field information, carrying out information query on the capacity pool storage system to obtain second home page field information;
and splicing the second field information and the second home page field information to obtain the cross-platform query result.
In one embodiment, the cross-platform information joint query apparatus is further configured to:
acquiring user login account information;
determining user-bound tenant information based on the user login account information;
based on the query field information and the tenant information, carrying out information query on the capacity pool storage system to obtain fourth target field information;
based on the query field information and the fourth target field information, carrying out information query in the data platform center to obtain fifth target field information;
And determining the cross-platform query result based on the fifth target field information.
Fig. 4 illustrates a physical schematic diagram of an electronic device, as shown in fig. 4, which may include: processor 410, communication interface (Communication Interface) 420, memory 430 and communication bus 440, wherein processor 410, communication interface 420 and memory 430 communicate with each other via communication bus 440. Processor 410 may invoke a computer program in memory 430 to perform the steps of a cross-platform information federation query method, including, for example:
acquiring inquiry field information;
matching the first stored field information based on the query field information; the first storage field information is field information stored in a database in the capacity pool storage system;
if the matching is successful, carrying out information query on the capacity pool storage system based on the query field information to obtain first target field information;
based on the query field information and the first target field information, carrying out information query in a data platform center to obtain second target field information; the data platform center is used for storing basic information of the vehicle;
And determining a cross-platform query result based on the second target field information.
Further, the logic instructions in the memory 430 described above may be implemented in the form of software functional units and may be stored in a computer-readable storage medium when sold or used as a stand-alone product. Based on this understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
In another aspect, an embodiment of the present invention further provides a medium, where the medium is a computer readable storage medium, where the computer readable storage medium stores a computer program, where the computer program is configured to cause a processor to execute the steps of the method provided in the foregoing embodiments, where the method includes:
Acquiring inquiry field information;
matching the first stored field information based on the query field information; the first storage field information is field information stored in a database in the capacity pool storage system;
if the matching is successful, carrying out information query on the capacity pool storage system based on the query field information to obtain first target field information;
based on the query field information and the first target field information, carrying out information query in a data platform center to obtain second target field information; the data platform center is used for storing basic information of the vehicle;
and determining a cross-platform query result based on the second target field information.
The computer readable storage medium may be any available medium or data storage device that can be accessed by a processor including, but not limited to, magnetic memory (e.g., floppy disks, hard disks, magnetic tape, magneto-optical disks (MOs), etc.), optical memory (e.g., CD, DVD, BD, HVD, etc.), and semiconductor memory (e.g., ROM, EPROM, EEPROM, nonvolatile memory (NAND FLASH), solid State Disk (SSD)), etc.
The apparatus embodiments described above are merely illustrative, wherein the elements illustrated as separate elements may or may not be physically separate, and the elements shown as elements may or may not be physical elements, may be located in one place, or may be distributed over a plurality of network elements. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment. Those of ordinary skill in the art will understand and implement the present invention without undue burden.
From the above description of the embodiments, it will be apparent to those skilled in the art that the embodiments may be implemented by means of software plus necessary general hardware platforms, or of course may be implemented by means of hardware. Based on this understanding, the foregoing technical solution may be embodied essentially or in a part contributing to the prior art in the form of a software product, which may be stored in a computer readable storage medium, such as ROM/RAM, a magnetic disk, an optical disk, etc., including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the method described in the respective embodiments or some parts of the embodiments.
Finally, it should be noted that: the above embodiments are only for illustrating the technical solution of the present invention, and are not limiting; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention.
Claims (10)
1. The cross-platform information joint query method is characterized by being applied to a capacity pool storage system, and comprises the following steps:
acquiring inquiry field information;
matching the first stored field information based on the query field information; the first storage field information is field information stored in a database in the capacity pool storage system;
if the matching is successful, carrying out information query on the capacity pool storage system based on the query field information to obtain first target field information;
based on the query field information and the first target field information, carrying out information query in a data platform center to obtain second target field information; the data platform center is used for storing basic information of the vehicle;
and determining a cross-platform query result based on the second target field information.
2. The method for cross-platform information joint query as claimed in claim 1, wherein said determining a cross-platform query result based on said second target field information comprises:
sorting the second target field information in a descending order to obtain second query sorting field information;
paging the second query ordering field information to obtain a first paging result;
And determining a cross-platform query result based on first field information of a first page in the first paging result.
3. The method for cross-platform information joint query as claimed in claim 2, wherein said determining a cross-platform query result based on the first field information of the top page in the first paging result comprises:
based on the first field information, carrying out information query on the capacity pool storage system to obtain first home page field information;
and splicing the first field information and the first home page field information to obtain the cross-platform query result.
4. The method for cross-platform information joint query as claimed in claim 1, wherein said performing information query in a data platform center based on the query field information and the first target field information to obtain second target field information includes:
correlating the query field information with the first target field information to obtain target query field information;
and carrying out information query in a data platform center according to the target query field information to obtain second target field information.
5. The cross-platform information federation query method of claim 1, further comprising, after said matching the first stored field information based on the query field information:
If the matching fails, carrying out information query on the data platform center based on the query field information to obtain third target field information;
sorting the third target field information in a descending order to obtain third query sorting field information;
paging the third query ordering field information to obtain a second paging result;
and determining the cross-platform query result based on second field information of the first page in the second page splitting result.
6. The method for cross-platform information joint query as claimed in claim 5, wherein said determining the cross-platform query result based on the second field information of the top page in the second split result comprises:
based on the second field information, carrying out information query on the capacity pool storage system to obtain second home page field information;
and splicing the second field information and the second home page field information to obtain the cross-platform query result.
7. The cross-platform information joint query method according to any one of claims 1 to 6, further comprising, after successful matching:
acquiring user login account information;
determining user-bound tenant information based on the user login account information;
Based on the query field information and the tenant information, carrying out information query on the capacity pool storage system to obtain fourth target field information;
based on the query field information and the fourth target field information, carrying out information query in the data platform center to obtain fifth target field information;
and determining the cross-platform query result based on the fifth target field information.
8. The cross-platform information joint query device is characterized by being applied to a capacity pool storage system, and comprises:
the acquisition module is used for acquiring the information of the query field;
the matching module is used for matching the first storage field information based on the query field information; the first storage field information is field information stored in a database in the capacity pool storage system;
the first query module is used for carrying out information query on the capacity pool storage system based on the query field information if the matching is successful, so as to obtain first target field information;
the second query module is used for carrying out information query in the data platform center based on the query field information and the first target field information to obtain second target field information; the data platform center is used for storing basic information of the vehicle;
And the determining module is used for determining a cross-platform query result based on the second target field information.
9. An electronic device comprising a processor and a memory storing a computer program, wherein the processor implements the cross-platform information joint query method of any one of claims 1 to 7 when executing the computer program.
10. A storage medium, the storage medium being a computer readable storage medium comprising a computer program, wherein the computer program when executed by a processor implements the cross-platform information joint query method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311781341.2A CN117453774A (en) | 2023-12-22 | 2023-12-22 | Cross-platform information joint query method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311781341.2A CN117453774A (en) | 2023-12-22 | 2023-12-22 | Cross-platform information joint query method and device, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117453774A true CN117453774A (en) | 2024-01-26 |
Family
ID=89591431
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311781341.2A Pending CN117453774A (en) | 2023-12-22 | 2023-12-22 | Cross-platform information joint query method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117453774A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| TW200923696A (en) * | 2007-11-28 | 2009-06-01 | Inventec Besta Co Ltd | Search device and method with crossing database |
| CN102081669A (en) * | 2011-01-24 | 2011-06-01 | 哈尔滨工业大学 | Hierarchical retrieval method for multi-source remote sensing resource heterogeneous databases |
| US20180137185A1 (en) * | 2016-11-17 | 2018-05-17 | Sap Se | Asynchronous Database Transaction Handling |
| CN116633603A (en) * | 2023-05-11 | 2023-08-22 | 北京汇通天下物联科技有限公司 | Cross-platform service access method, device, equipment and storage medium |
| CN116628027A (en) * | 2023-05-24 | 2023-08-22 | 中国建设银行股份有限公司 | Cross-database query method, apparatus, device, medium and computer program product |
-
2023
- 2023-12-22 CN CN202311781341.2A patent/CN117453774A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| TW200923696A (en) * | 2007-11-28 | 2009-06-01 | Inventec Besta Co Ltd | Search device and method with crossing database |
| CN102081669A (en) * | 2011-01-24 | 2011-06-01 | 哈尔滨工业大学 | Hierarchical retrieval method for multi-source remote sensing resource heterogeneous databases |
| US20180137185A1 (en) * | 2016-11-17 | 2018-05-17 | Sap Se | Asynchronous Database Transaction Handling |
| CN116633603A (en) * | 2023-05-11 | 2023-08-22 | 北京汇通天下物联科技有限公司 | Cross-platform service access method, device, equipment and storage medium |
| CN116628027A (en) * | 2023-05-24 | 2023-08-22 | 中国建设银行股份有限公司 | Cross-database query method, apparatus, device, medium and computer program product |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110471949B (en) | Data blood margin analysis method, device, system, server and storage medium | |
| CN109995677B (en) | Resource allocation method, device and storage medium | |
| CN110956269B (en) | Method, device, equipment and computer storage medium for generating data model | |
| CN109309596B (en) | Pressure testing method and device and server | |
| CN109543891B (en) | Method and apparatus for establishing capacity prediction model, and computer-readable storage medium | |
| CN111522728A (en) | Method for generating automatic test case, electronic device and readable storage medium | |
| CN112581018B (en) | Method, system, device and storage medium for managing process tasks | |
| CN110515795B (en) | Big data component monitoring method and device and electronic equipment | |
| CN109740129B (en) | Report generation method, device and equipment based on blockchain and readable storage medium | |
| CN111078551A (en) | Full link testing method, device and system and computer readable storage medium | |
| CN111026709B (en) | Data processing method and device based on cluster access | |
| CN111125240B (en) | Distributed transaction realization method and device, electronic equipment and storage medium | |
| CN108647102B (en) | Service request processing method and device of heterogeneous system and electronic equipment | |
| CN113065887A (en) | Resource processing method, resource processing device, computer equipment and storage medium | |
| CN110928941B (en) | Data fragment extraction method and device | |
| CN117453774A (en) | Cross-platform information joint query method and device, electronic equipment and storage medium | |
| CN116841653A (en) | Execution method and device of operation and maintenance job, processor and electronic equipment | |
| CN112597119A (en) | Method and device for generating processing log and storage medium | |
| CN114564501A (en) | Database data storage and query methods, devices, equipment and medium | |
| CN112631905A (en) | Execution process data management method and device, computer equipment and storage medium | |
| CN111061543A (en) | Multi-tenant workflow engine service method, device and server | |
| CN111225075A (en) | Configuration method and device for Internet of things directional access service | |
| CN114818645B (en) | Automatic report generation method, device, equipment and medium based on data body | |
| CN112732664B (en) | Evidence extraction method, device, electronic equipment and storage medium | |
| CN109919808B (en) | Trademark intelligent declaration method, medium, computer equipment 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 |