A method and system for retrieving different data sources and data structures based on paging aggregation

Abstract

The present invention discloses a method and system for retrieval of different data sources and data structures based on paging aggregation, wherein the method includes: obtaining audio retrieval information of online car-hailing orders; obtaining page parameters for paging retrieval, and converting the query range into corresponding data coordinates based on the page parameters and the database structure of each data source; transmitting the data coordinates to the databases corresponding to different data sources respectively, so as to intercept the data for paging retrieval respectively; based on the results of the paging retrieval, obtaining the returned data from the databases of each data source respectively; aggregating the returned data from each data source, and sorting the returned data based on the sorting conditions to obtain the aggregated data; and performing accurate data filtering on the aggregated data based on the query conditions to obtain the final retrieval data. The present invention can realize the retrieval of multiple voice files in online car-hailing by aggregating multiple databases for paging, so as to make the retrieval more intuitive and efficient.

Description

Technical Field

[0001] The present invention relates to the technical field of paging aggregate retrieval of audio files in online ride-hailing services, and in particular to a method and system for paging aggregate retrieval of different data sources and data structures. Background Art

[0002] With the rapid development of the internet, my country's network coverage has greatly increased, and people's lifestyles have inevitably become more connected. Among these, ride-hailing services, which integrate the internet, have gradually become part of people's lives. Ride-hailing, short for online taxi booking services, refers to the operation of providing non-cruising taxi booking services by building a service platform based on internet technology, connecting qualified vehicles and drivers, and integrating supply and demand information.

[0003] With the development of online ride-hailing services, the means of resolving disputes have become increasingly mature. The trip recordings and the voice communications between drivers and passengers in online ride-hailing services are important evidence for resolving disputes in online ride-hailing services. After the online ride-hailing service is completed, they need to be uploaded to the Internet and then stored in different data sources so that they can be obtained when online ride-hailing disputes occur as evidence for resolving disputes.

[0004] When it is necessary to obtain recordings of the online ride-hailing process from the data source and accurately retrieve the key parts, the existing technology requires operators to search from three different locations, which increases the operator's workload and reduces the efficiency of retrieval and dispute resolution. Summary of the Invention

[0005] In order to overcome the technical defect of the above-mentioned prior art in low efficiency in retrieving and calling online car-hailing recording data, the present invention provides a method and system for retrieving different data sources and data structures based on paging aggregation.

[0006] In order to solve the above problems, the present invention is implemented according to the following technical solutions:

[0007] In a first aspect, the present invention discloses a method for searching different data sources and data structures based on paging aggregation, which specifically includes the following steps:

[0008] Obtaining audio search information for online ride-hailing orders, where the audio search information includes query conditions and query scope;

[0009] Obtain page parameters for paginated search and convert the query range into corresponding data coordinates based on the page parameters and the database structure of each data source, where the data source types include those used to store travel recordings, voice messages, and phone calls;

[0010] The data coordinates are transmitted to the databases corresponding to different data sources respectively, so as to intercept the data and perform page retrieval;

[0011] Based on the paging search results, the returned data is obtained from the database of each data source;

[0012] Aggregate the returned data from each data source and sort the returned data based on the sorting conditions to obtain aggregated data;

[0013] Based on the query conditions, the aggregated data is accurately filtered to obtain the specified part of the trip recording, voice information and / or phone call corresponding to the online ride-hailing order as the final retrieval data.

[0014] As a preferred embodiment of the present invention, the data coordinates are transmitted to databases corresponding to different data sources respectively, so as to intercept the data and perform paged retrieval respectively, which specifically includes:

[0015] Transfer data coordinates to the database corresponding to each data source;

[0016] Based on the data coordinates, data is intercepted from the database to obtain the data source, data structure and corresponding online car-hailing order number;

[0017] Based on the page parameters, the data is filled into the paginated search pages to form several pages to be searched. Each row of the page to be searched includes the data source, data structure and corresponding online car-hailing order number corresponding to the data;

[0018] The pages containing data that match the query conditions are retained and extracted separately after the paging search is completed to form the paging search results.

[0019] As a preferred embodiment of the present invention, aggregating the returned data from each data source specifically includes:

[0020] Based on the paged search results, the corresponding data is obtained from the database of each data source in turn to form the return data;

[0021] The returned data includes trip recordings, voice messages, and phone call data from the entire service process of the target online ride-hailing order.

[0022] After obtaining the return data from different data sources, the aggregation engine is started and the return data from each data source is transmitted to the aggregation engine respectively;

[0023] Perform aggregation decision hit judgment, execute the aggregation function corresponding to the hit aggregation decision, and aggregate the data of each page of returned data to obtain preliminary aggregated data.

[0024] As a preferred embodiment of the present invention, the sorting of the returned data based on the sorting condition specifically includes:

[0025] Based on the hit aggregation decision, obtain the corresponding sorting conditions;

[0026] Obtain the data source information and timestamp fields of the trip recordings, voice information, and phone call data in the preliminary aggregated data respectively;

[0027] Re-sort the preliminary aggregated data based on sorting conditions, data source information, and timestamp fields;

[0028] The "data source-time" pairing information of the data is extracted to serve as the retrieval title of the data, thereby forming aggregated data with the retrieval title.

[0029] As a preferred embodiment of the present invention, the accurate data filtering of aggregated data based on query conditions specifically includes:

[0030] Extracting specific search information from the query conditions, the specific search information including the voice type and the occurrence time period;

[0031] Based on the specific search information, the voice type is converted into the corresponding data source to form several "data source-time" pairing information;

[0032] Based on the "data source-time" pairing information and the search title in the aggregated data, hit matching is performed to perform data screening, and several hit data are intercepted separately, that is, the specified parts of the trip recordings, voice messages and / or phone calls corresponding to the online ride-hailing orders are obtained, and the extracted parts are returned as the final search data.

[0033] As a preferred embodiment of the present invention, the page parameters for paging search are obtained, and based on the page parameters and the database structure of each data source, the query range is converted into corresponding data coordinates, specifically including:

[0034] Obtaining page parameters preset in the paging search, wherein the page parameters include the page number and page size of the paging search range;

[0035] Based on the query range and page parameters, the data coordinates of the query range in the database structure corresponding to each data source are calculated respectively, so as to intercept the data for page search from each database, narrow the scope and reduce the search volume of page search;

[0036] Based on the calculation formulas startIndex=(pageNum-1)*pageSize and endIndex=startIndex+pageSize, the data coordinates of different data sources are calculated respectively. The data coordinates include the starting coordinates and the ending coordinates.

[0037] Wherein, the startIndex is the starting point coordinate, the pageNum is the page number, the pageSize is the page size, and the endIndex is the end point coordinate.

[0038] In a second aspect, the present invention further discloses a system for searching different data sources and data structures based on paging and aggregation, comprising a search and acquisition module, a coordinate conversion module, a paging search module, a data return module, an aggregation sorting module, and a data filtering module, wherein:

[0039] A search and acquisition module, which is used to obtain audio search information of online ride-hailing orders, wherein the audio search information includes query conditions and query scope;

[0040] A coordinate conversion module, which is used to obtain page parameters for paginated search and convert the query range into corresponding data coordinates based on the page parameters and the database structure of each data source. The types of data sources include those used to store travel recordings, voice information, and phone calls;

[0041] A page search module is used to transmit data coordinates to databases corresponding to different data sources to intercept data for page search;

[0042] The data return module is used to obtain the returned data from the database of each data source based on the paging search results;

[0043] An aggregation and sorting module is used to aggregate the returned data from various data sources and sort the returned data based on sorting conditions to obtain aggregated data;

[0044] The data filtering module is used to accurately filter the aggregated data based on the query conditions to obtain the specified part of the trip recording, voice information and / or telephone call corresponding to the online car-hailing order as the final retrieval data.

[0045] As a preferred embodiment of the present invention, the paging retrieval module specifically performs the following when running:

[0046] Transfer data coordinates to the database corresponding to each data source;

[0047] Based on the data coordinates, data is intercepted from the database to obtain the data source, data structure and corresponding online car-hailing order number;

[0048] Based on the page parameters, the data is filled into the paginated search pages to form several pages to be searched. Each row of the page to be searched includes the data source, data structure and corresponding online car-hailing order number corresponding to the data;

[0049] The pages containing data that match the query conditions are retained and extracted separately after the paging search is completed to form the paging search results.

[0050] As a preferred embodiment of the present invention, the aggregation sorting module specifically performs the following when running:

[0051] Based on the paged search results, the corresponding data is obtained from the database of each data source in turn to form the return data;

[0052] The returned data includes trip recordings, voice messages, and phone call data from the entire service process of the target online ride-hailing order.

[0053] After obtaining the return data from different data sources, the aggregation engine is started and the return data from each data source is transmitted to the aggregation engine respectively;

[0054] Perform aggregate decision hit judgment, execute the aggregate function corresponding to the hit aggregate decision, and aggregate the data of each page of returned data to obtain preliminary aggregate data;

[0055] Based on the hit aggregation decision, obtain the corresponding sorting conditions;

[0056] Obtain the data source information and timestamp fields of the trip recordings, voice information, and phone call data in the preliminary aggregated data respectively;

[0057] Re-sort the preliminary aggregated data based on sorting conditions, data source information, and timestamp fields;

[0058] The "data source-time" pairing information of the data is extracted to serve as the retrieval title of the data, thereby forming aggregated data with the retrieval title.

[0059] As a preferred embodiment of the present invention, when the data filtering module is running, it specifically performs the following steps:

[0060] Extracting specific search information from the query conditions, the specific search information including the voice type and the occurrence time period;

[0061] Based on the specific search information, the voice type is converted into the corresponding data source to form several "data source-time" pairing information;

[0062] Based on the "data source-time" pairing information and the search title in the aggregated data, hit matching is performed to perform data screening, and several hit data are intercepted separately, that is, the specified parts of the trip recordings, voice messages and / or phone calls corresponding to the online ride-hailing orders are obtained, and the extracted parts are returned as the final search data.

[0063] Compared with the prior art, the present invention has the following beneficial effects:

[0064] The method of the present invention for retrieving different data sources and data structures based on paging aggregation converts the query range into data coordinates to obtain a cut-off range that is compatible with the database structure of each data source, ensuring that the content to be retrieved is within the range. After the data is cut off, paging retrieval is performed to achieve a fast and efficient retrieval process after limiting the smaller range. The results of the paging retrieval are aggregated and sorted to make the data integrated and orderly, which facilitates the subsequent accurate data acquisition steps. The operator only needs to perform data filtering operations on the aggregated and sorted data to obtain the final retrieval data to return data for resolving disputes and problems in online car-hailing. The operator does not need to search and obtain data from multiple data sources separately, which can significantly improve the efficiency of data retrieval, thereby improving the service quality and the experience of both drivers and passengers.

[0065] In addition, the present invention can also accurately obtain recording data of different data structures from different data sources, and can accurately obtain data of precise time periods in one or more of travel recordings, voice information and telephone calls, so as to efficiently and accurately obtain the most important recording information. BRIEF DESCRIPTION OF THE DRAWINGS

[0066] The specific embodiments of the present invention will be further described in detail below with reference to the accompanying drawings, wherein:

[0067] Figure 1 It is a flow chart of the method for searching different data sources and data structures based on paging aggregation of the present invention;

[0068] Figure 2 It is a structural diagram of the system of the present invention based on paging aggregation retrieval of different data sources and data structures;

[0069] For detailed explanation of the specific contents of the drawings, please refer to the contents described in the specific implementation methods. DETAILED DESCRIPTION

[0070] The preferred embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although preferred embodiments of the present disclosure are shown in the accompanying drawings, it should be understood that the present disclosure can be implemented in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided to make the present disclosure more thorough and complete, and to fully convey the scope of the present disclosure to those skilled in the art.

[0071] As used herein, the term "including" and its variations represent open inclusion, i.e., "including but not limited to." Unless otherwise stated, the term "or" means "and / or." The term "based on" means "based at least in part on." The terms "an example embodiment" and "an embodiment" mean "at least one example embodiment." The term "another embodiment" means "at least one additional embodiment." The terms "first," "second," etc. may refer to different or the same objects. Other explicit and implicit definitions may also be included below.

[0072] The access device and server can be connected directly or indirectly via wired or wireless communication. The access device can be a terminal or a server. The target application is running on the access device. The target application is an application program capable of initiating data requests to the server, such as a social networking application, a payment application, or a gaming application. The server can be an application server providing services for the target application, or a proxy server distinct from the application server corresponding to the target application. The server is responsible for identifying whether each access device is a malicious device and intercepting data packets from malicious devices. When the server is a proxy server, the proxy server forwards data packets that are not from malicious devices to the application server. The terminal can be a desktop terminal or a mobile terminal. Mobile terminals can be, but are not limited to, smartphones, tablets, laptops, desktop computers, smart speakers, smart watches, etc. The server can be a standalone physical server, a server cluster or distributed system consisting of multiple physical servers, or a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, CDN, and big data and artificial intelligence platforms.

[0073] Example 1

[0074] like Figure 1 As shown, in a first aspect, the present invention discloses a method for searching different data sources and data structures based on paging aggregation, which specifically includes the following steps:

[0075] Step S1: Acquire audio retrieval information of an online car-hailing order, wherein the audio retrieval information includes query conditions and query scope.

[0076] Step S2: Obtain page parameters for paging retrieval, and convert the query range into corresponding data coordinates based on the page parameters and the database structure of each data source, where the types of data sources include data sources for storing travel recordings, voice information, and telephone calls.

[0077] Specifically, in this embodiment, converting the query range into corresponding data coordinates includes:

[0078] Obtaining page parameters preset in paging search, the page parameters including the page number and page size of the paging search range; calculating the data coordinates of the query range in the database structure corresponding to each data source based on the query range and the page parameters, so as to intercept data for paging search from each database, narrow the scope and reduce the search volume of the paging search; calculating the data coordinates of different data sources based on the calculation formulas startIndex=(pageNum-1)*pageSize and endIndex=startIndex+pageSize, the data coordinates including the starting point coordinate and the ending point coordinate; wherein, startIndex is the starting point coordinate, pageNum is the page number, pageSize is the page size, and endIndex is the ending point coordinate.

[0079] The present invention calculates the interception range of each database based on the page parameters of the page search to obtain data coordinates that are compatible with the database. The data coordinates can be used to quickly intercept data from each data source for page search.

[0080] Step S3: Transmitting the data coordinates to databases corresponding to different data sources respectively, so as to intercept the data and perform page retrieval.

[0081] Specifically, it includes transmitting the data coordinates to the database corresponding to each data source; based on the data coordinates, intercepting data from the database, intercepting the data source, data structure and corresponding online car-hailing order number of the data; filling the data into the page of paginated search based on the page parameters to form several pages to be searched, and each row of the page to be searched includes the data source, data structure and corresponding online car-hailing order number corresponding to the data; retaining the pages containing data that hit the query conditions, and extracting them separately after the paginated search is completed to form the paginated search results.

[0082] Step S4: Based on the paged search results, the returned data is obtained from the database of each data source.

[0083] Step S5: Aggregate the returned data from each data source, and sort the returned data based on a sorting condition to obtain aggregated data.

[0084] Specifically, aggregation includes: based on the paginated retrieval results, obtaining corresponding data from the database of each data source in turn to form return data; the return data includes the trip recording, voice information and telephone call data of the target online car-hailing order throughout the service process; after obtaining the return data from different data sources, starting the aggregation engine and transmitting the return data of each data source to the aggregation engine respectively; performing aggregation decision hit judgment, executing the aggregation function corresponding to the hit aggregation decision, and aggregating the data of each page of the return data to obtain preliminary aggregated data.

[0085] Sorting includes: obtaining corresponding sorting conditions based on the hit aggregation decision; obtaining the data source information and timestamp fields generated by the travel recordings, voice information and telephone call data in the preliminary aggregated data respectively; re-sorting the preliminary aggregated data based on the sorting conditions, data source information and timestamp fields; extracting the "data source-time" pairing information of the data as the retrieval title of the data, thereby forming aggregated data with the retrieval title.

[0086] The present invention aggregates data from multiple data sources into a single overall data through data aggregation, and then makes the internal structure of the aggregated data more orderly through a sorting step. The data sorted based on the data generation time can be better divided during retrieval, which can significantly improve the retrieval efficiency and ensure the data integrity in the data extraction step after the retrieval. The present invention applies aggregation and sorting to the management and retrieval of online car-hailing recording data, thereby achieving accurate, complete and efficient retrieval.

[0087] Step S6: Accurately filter the aggregated data based on the query conditions to obtain the specified part of the trip recording, voice information and / or telephone call corresponding to the online car-hailing order as the final retrieval data.

[0088] Specifically, it includes extracting specific search information from the query conditions, and the specific search information includes the voice type and the time period of occurrence; based on the specific search information, converting the voice type into the corresponding data source to form a number of "data source-time" pairing information; based on the "data source-time" pairing information, matching with the search title in the aggregated data to perform data screening, and intercepting a number of hit data respectively, that is, obtaining the specified part of the travel recording, voice information and / or telephone call corresponding to the online car-hailing order, extracting them separately and returning them as the final search data.

[0089] The party making the retrieval request can obtain the final retrieval data returned and resolve problems and disputes related to online ride-hailing orders by analyzing the final retrieval data.

[0090] When a problem or dispute arises with an online ride-hailing order, the user files a complaint or appeal, marking the exact online ride-hailing order number and the specific time period when the incident occurred. Through the method disclosed in the present invention for retrieving different data sources and data structures based on paging aggregation, the recording data from each data source containing the full recording file of the online ride-hailing order can be first obtained, and a paging search can be performed to obtain roughly adapted paging search results, thereby performing a rough screening with lower consumption. Then, through aggregation and sorting, and accurate data filtering, a one-time accurate data retrieval and call can be achieved, significantly reducing the retrieval workload while making the retrieval more efficient and accurate.

[0091] In summary, the method of the present invention for retrieving different data sources and data structures based on paging aggregation creatively converts the query range into data coordinates to obtain a cut-off range that is compatible with the database structure of each data source, ensuring that the content to be retrieved is within the range, and performing paging retrieval after intercepting the data to achieve a fast and efficient retrieval process after limiting the smaller range. The results of the paging retrieval are aggregated and sorted to make the data integrated and orderly, which facilitates the subsequent accurate data acquisition steps. The operator only needs to perform data filtering operations on the aggregated and sorted data to obtain the final retrieval data to return data for resolving disputes and problems in online car-hailing. The operator does not need to search and obtain data from multiple data sources separately, which can significantly improve the efficiency of data retrieval, thereby improving service quality and the experience of both drivers and passengers.

[0092] In addition, the present invention can also accurately obtain recording data of different data structures from different data sources, and can accurately obtain data of precise time periods in one or more of travel recordings, voice information and telephone calls, so as to efficiently and accurately obtain the most important recording information.

[0093] For other steps of the method for paging-based aggregation retrieval of different data sources and data structures described in this embodiment, refer to the prior art.

[0094] Example 2

[0095] like Figure 2 As shown, in a second aspect, the present invention further discloses a system for paging and aggregate retrieval of different data sources and data structures, comprising a retrieval module M1, a coordinate conversion module M2, a paging retrieval module M3, a data return module M4, an aggregate sorting module M5, and a data filtering module M6, wherein:

[0096] The retrieval acquisition module M1 is used to obtain audio retrieval information of online car-hailing orders, and the audio retrieval information includes query conditions and query scope.

[0097] The coordinate conversion module M2 is used to obtain page parameters for paginated retrieval and convert the query range into corresponding data coordinates based on the page parameters and the database structure of each data source, where the types of data sources include those used to store travel recordings, voice information, and telephone calls.

[0098] The page search module M3 is used to transmit the data coordinates to the databases corresponding to different data sources respectively, so as to intercept the data and perform page search respectively.

[0099] The data return module M4 is used to obtain return data from the database of each data source based on the paged search results.

[0100] The aggregation and sorting module M5 is used to aggregate the returned data from various data sources and sort the returned data based on sorting conditions to obtain aggregated data.

[0101] The data filtering module M6 is used to accurately filter the aggregated data based on the query conditions to obtain the specified part of the travel recording, voice information and / or telephone call corresponding to the online car-hailing order as the final retrieval data.

[0102] As a preferred embodiment of the present invention, the paging retrieval module M3 specifically performs the following operations when running:

[0103] The data coordinates are transferred to the database corresponding to each data source; based on the data coordinates, data is intercepted from the database to intercept the data source, data structure and corresponding online car-hailing order number of the data; based on the page parameters, the data is filled into the page of the paginated search to form several pages to be searched, and each row of the page to be searched includes the data source, data structure and corresponding online car-hailing order number corresponding to the data; the pages containing data that hit the query conditions are retained, and after the paginated search is completed, they are extracted separately to form the paginated search results.

[0104] When the aggregation sorting module M5 is running, it specifically performs the following operations:

[0105] Based on the paginated search results, the corresponding data is obtained from the database of each data source in turn to form the return data; the return data includes the travel recordings, voice information and telephone call data of the target online car-hailing order throughout the service process; after obtaining the return data from different data sources, the aggregation engine is started, and the return data of each data source is respectively transmitted to the aggregation engine; the aggregation decision hit judgment is performed, the aggregation function corresponding to the hit aggregation decision is executed, and the data of each page of the returned data is aggregated to obtain preliminary aggregated data; based on the hit aggregation decision, the corresponding sorting conditions are obtained; the data source information and timestamp fields generated by the travel recordings, voice information and telephone call data in the preliminary aggregated data are respectively obtained; based on the sorting conditions, data source information and timestamp fields, the preliminary aggregated data is re-sorted; the "data source-time" pairing information of the data is extracted as the retrieval title of the data, thereby forming aggregated data with the retrieval title.

[0106] When the data filtering module M6 is running, it specifically performs the following operations:

[0107] Extract specific search information from the query conditions, including the voice type and the time period of occurrence; based on the specific search information, convert the voice type into the corresponding data source to form several "data source-time" pairing information; perform hit matching with the search title in the aggregated data based on the "data source-time" pairing information to perform data screening, and intercept several hit data respectively, that is, obtain the specified parts of the trip recording, voice information and / or telephone call corresponding to the online car-hailing order, extract them separately and return them as the final search data.

[0108] To sum up, when the system for paging-based aggregate retrieval of different data sources and data structures described in the embodiment of the present invention is running, all the steps of the method for paging-based aggregate retrieval of different data sources and data structures described in Example 1 can be executed, thereby achieving the technical effect of paging retrieval to improve retrieval efficiency and retrieval accuracy, and reduce retrieval workload.

[0109] For other structures of the system based on paging aggregation retrieval of different data sources and data structures described in this embodiment, please refer to the prior art.

[0110] Example 3

[0111] The present invention also discloses an electronic device, at least one processor, and a memory communicatively connected to the at least one processor, wherein the memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor. When the at least one processor executes the instructions, the following steps are specifically implemented: obtaining audio retrieval information of an online car-hailing order, the audio retrieval information including query conditions and query range; obtaining page parameters for paginated retrieval, and converting the query range into corresponding data coordinates based on the page parameters and the database structure of each data source, wherein the type of data source includes a data source for storing travel recordings, voice information, and telephone calls; transmitting the data coordinates to the databases corresponding to different data sources respectively to intercept data for paginated retrieval; based on the paginated retrieval results, obtaining return data from the databases of each data source respectively; aggregating the return data from each data source, and sorting the return data based on the sorting conditions to obtain aggregated data; performing accurate data filtering on the aggregated data based on the query conditions to obtain the specified part of the travel recordings, voice information and / or telephone calls corresponding to the online car-hailing order as the final retrieval data.

[0112] Example 4

[0113] The present invention also discloses a storage medium storing a computer program. When the computer program is executed by a processor, it specifically implements the following steps: obtaining audio retrieval information of an online car-hailing order, wherein the audio retrieval information includes query conditions and a query range; obtaining page parameters for paginated retrieval, and converting the query range into corresponding data coordinates based on the page parameters and the database structure of each data source, wherein the types of data sources include data sources for storing travel recordings, voice information, and telephone calls; transmitting the data coordinates to databases corresponding to different data sources respectively, so as to intercept data separately for paginated retrieval; based on the paginated retrieval results, obtaining return data from the database of each data source respectively; aggregating the return data from each data source, and sorting the return data based on the sorting conditions to obtain aggregated data; and performing accurate data filtering on the aggregated data based on the query conditions to obtain a specified part of the travel recording, voice information, and / or telephone call corresponding to the online car-hailing order as the final retrieval data.

[0114] The present disclosure may be a method, an apparatus, a system and / or a computer program product. The computer program product may include a computer-readable storage medium carrying computer-readable program instructions for executing various aspects of the present disclosure.

[0115] A computer-readable storage medium can be a tangible device that can hold and store instructions for use by an instruction execution device. A computer-readable storage medium can be, for example, but not limited to, an electrical storage device, a magnetic storage device, an optical storage device, an electromagnetic storage device, a semiconductor storage device, or any suitable combination thereof. More specific examples (a non-exhaustive list) of computer-readable storage media include: a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a static random access memory (SRAM), a portable compact disc read-only memory (CD-ROM), a digital versatile disk (DVD), a memory stick, a floppy disk, a mechanical encoding device, such as a punch card or a raised structure in a groove on which instructions are stored, and any suitable combination thereof. As used herein, a computer-readable storage medium is not to be construed as a transient signal per se, such as a radio wave or other freely propagating electromagnetic wave, an electromagnetic wave propagating through a waveguide or other transmission medium (e.g., a light pulse through a fiber optic cable), or an electrical signal transmitted through an electrical wire.

[0116] The computer-readable program instructions described herein can be downloaded from a computer-readable storage medium to each computing / processing device, or downloaded to an external computer or external storage device via a network, such as the Internet, a local area network, a wide area network, and / or a wireless network. The network can include copper transmission cables, fiber optic transmission, wireless transmission, routers, firewalls, switches, gateway computers, and / or edge servers. The network adapter card or network interface in each computing / processing device receives the computer-readable program instructions from the network and forwards the computer-readable program instructions to be stored in the computer-readable storage medium in each computing / processing device.

[0117] The computer program instructions for performing the operations of the present disclosure may be assembly instructions, instruction set architecture (ISA) instructions, machine instructions, machine-dependent instructions, microcode, firmware instructions, state setting data, or source code or object code written in any combination of one or more programming languages, including object-oriented programming languages ​​such as Smalltalk, C++, Java, and conventional procedural programming languages ​​such as "C" language or similar programming languages. Computer-readable program instructions may be executed entirely on a user's computer, partially on a user's computer, as an independent software package, partially on a user's computer, partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer via any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., utilizing an Internet service provider to connect via the Internet). In some embodiments, an electronic circuit, such as a programmable logic circuit, a field programmable gate array (FPGA), or a programmable logic array (PLA), may be personalized by utilizing the state information of the computer-readable program instructions. The electronic circuit may execute the computer-readable program instructions, thereby realizing various aspects of the present disclosure.

[0118] Various aspects of the present disclosure are described herein with reference to flowcharts and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the present disclosure. It should be understood that each block of the flowcharts and / or block diagrams, and combinations of blocks in the flowcharts and / or block diagrams, can be implemented by computer-readable program instructions.

[0119] These computer-readable program instructions can be provided to a processing unit of a general-purpose computer, a special-purpose computer, or other programmable data processing device, thereby producing a machine such that when these instructions are executed by the processing unit of the computer or other programmable data processing device, a device is generated that implements the functions / actions specified in one or more blocks in the flowchart and / or block diagram. These computer-readable program instructions can also be stored in a computer-readable storage medium, where these instructions cause the computer, programmable data processing device, and / or other device to operate in a specific manner. Thus, the computer-readable medium storing the instructions comprises an article of manufacture that includes instructions for implementing various aspects of the functions / actions specified in one or more blocks in the flowchart and / or block diagram.

[0120] Computer-readable program instructions may also be loaded onto a computer, other programmable data processing apparatus, or other device so that a series of operational steps are performed on the computer, other programmable data processing apparatus, or other device to produce a computer-implemented process, thereby causing the instructions executed on the computer, other programmable data processing apparatus, or other device to implement the functions / actions specified in one or more blocks in the flowchart and / or block diagram.

[0121] The flow charts and block diagrams in the accompanying drawings show the possible architecture, functions and operations of the systems, methods and computer program products according to multiple embodiments of the present disclosure. In this regard, each box in the flow chart or block diagram can represent a part of a module, program segment or instruction, and a part of the above-mentioned module, program segment or instruction includes one or more executable instructions for realizing the prescribed logical function. In some alternative implementations, the functions marked in the box can also occur in an order different from that marked in the accompanying drawings. For example, two consecutive boxes can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram and / or flow chart, and the combination of the boxes in the block diagram and / or flow chart can be implemented with a special hardware-based system that performs the prescribed function or action, or can be implemented with a combination of special hardware and computer instructions.

[0122] The embodiments of the present disclosure have been described above. The above description is exemplary, not exhaustive, and is not limited to the disclosed embodiments. Many modifications and variations will be apparent to those skilled in the art without departing from the scope and spirit of the described embodiments. The terminology used herein is selected to best explain the principles of the embodiments, practical applications, or improvements to the technology in the market, or to enable other persons skilled in the art to understand the embodiments disclosed herein.

Claims

1. A method for retrieving different data sources and data structures based on paging aggregation, characterized in that: include: Acquire audio search information of online car-hailing orders, where the audio search information includes a search condition and a search range; Obtain page parameters for paginated retrieval, and convert the query range into corresponding data coordinates based on the page parameters and the database structure of each data source, where the types of data sources include data sources for storing trip recordings, voice information, and telephone calls; The data coordinates are transmitted to the databases corresponding to different data sources respectively, so as to intercept the data for paging retrieval respectively, including: Transmit data coordinates to the database corresponding to each data source; Based on the data coordinates, data is intercepted from the database to obtain the data source, data structure and corresponding online car-hailing order number; Based on the page parameters, the data is filled into the pages of the paginated search to form a number of pages to be searched, and each row of the page to be searched includes the data source, data structure and corresponding online car-hailing order number corresponding to the data; The pages containing the data matching the query condition are retained, and after the paging search is completed, they are extracted to form the paging search results; Based on the paginated search results, the returned data is obtained from the database of each data source respectively; Aggregate the returned data from each data source and sort the returned data based on the sorting conditions to obtain aggregated data; The aggregating the returned data from each data source specifically includes: based on the paging search results, sequentially acquiring corresponding data from the database of each data source to form returned data; the returned data includes the trip recording, voice information and telephone call data of the target online car-hailing order during the entire service process; after acquiring the returned data from different data sources, starting the aggregation engine, and transmitting the returned data from each data source to the aggregation engine respectively; performing aggregation decision hit judgment, executing the aggregation function corresponding to the hit aggregation decision, and aggregating data on each page of the returned data to obtain preliminary aggregated data; The sorting of the returned data based on the sorting condition specifically includes: obtaining the corresponding sorting condition based on the hit aggregation decision; respectively obtaining the data source information and timestamp field generated by the travel recording, voice information and telephone call data in the preliminary aggregated data; re-sorting the preliminary aggregated data based on the sorting condition, the data source information and the timestamp field; extracting the "data source-time" pairing information of the data as the search title of the data, thereby forming aggregated data with the search title; Based on the query conditions, the aggregated data is accurately filtered to obtain the specified part of the trip recording, voice information and / or telephone call corresponding to the online car-hailing order as the final retrieval data.

2. The method for retrieving different data sources and data structures based on paging aggregation according to claim 1 is characterized in that: The accurate data filtering of the aggregated data based on the query conditions specifically includes: Extracting specific search information from the query conditions, the specific search information including the voice type and the occurrence time period; Based on the specific search information, the voice type is converted into the corresponding data source to form a number of "data source-time" pairing information; Based on the "data source-time" pairing information and the search title in the aggregated data, a hit match is performed to perform data screening, and several hit data are intercepted separately, that is, the specified parts of the trip recordings, voice messages and / or telephone calls corresponding to the online car-hailing orders are obtained, and the extracted parts are returned as the final search data.

3. The method for retrieving different data sources and data structures based on paging aggregation according to claim 1 is characterized in that: The page parameters of the paging search are obtained, and based on the page parameters and the database structure of each data source, the query range is converted into corresponding data coordinates, specifically including: Obtaining page parameters preset in the paging search, wherein the page parameters include the page number and page size of the paging search range; Based on the query range and page parameters, the data coordinates of the query range in the database structure corresponding to each data source are calculated respectively, so as to intercept the data for paging retrieval from each database, narrow the range and reduce the retrieval amount of paging retrieval; Based on the calculation formulas startIndex=(pageNum-1)*pageSize and endIndex=startIndex+pageSize, the data coordinates of different data sources are calculated respectively, and the data coordinates include the starting point coordinates and the end point coordinates; Wherein, the startIndex is the starting point coordinate, the pageNum is the page number, the pageSize is the page size, and the endIndex is the end point coordinate.

4. A system for retrieving different data sources and data structures based on paging aggregation, characterized in that: include: A search and acquisition module, which is used to obtain audio search information of online car-hailing orders, wherein the audio search information includes a search condition and a search range; A coordinate conversion module, which is used to obtain page parameters for paginated retrieval, and convert the query range into corresponding data coordinates based on the page parameters and the database structure of each data source, where the types of data sources include data sources for storing trip recordings, voice information, and telephone calls; The paging retrieval module is used to transmit the data coordinates to the databases corresponding to different data sources respectively, so as to intercept the data respectively for paging retrieval; when the paging retrieval module is running, it specifically executes: Transmit data coordinates to the database corresponding to each data source; Based on the data coordinates, data is intercepted from the database to obtain the data source, data structure and corresponding online car-hailing order number; Based on the page parameters, the data is filled into the pages of the paginated search to form a number of pages to be searched, and each row of the page to be searched includes the data source, data structure and corresponding online car-hailing order number corresponding to the data; The pages containing the data matching the query condition are retained, and after the paging search is completed, they are extracted to form the paging search results; The data return module is used to obtain the returned data from the database of each data source based on the paging search results; An aggregation and sorting module is used to aggregate the returned data from various data sources and sort the returned data based on sorting conditions to obtain aggregated data; When the aggregation sorting module is running, it specifically performs the following steps: Based on the paged search results, corresponding data is obtained from the database of each data source in turn to form return data; The returned data includes the trip recording, voice messages, and phone call data of the target online ride-hailing order throughout the service process; After obtaining the return data from different data sources, the aggregation engine is started and the return data from each data source is transmitted to the aggregation engine respectively; Perform aggregate decision hit judgment, execute the aggregate function corresponding to the hit aggregate decision, and aggregate the data of each page of returned data to obtain preliminary aggregate data; Based on the hit aggregation decision, obtain the corresponding sorting condition; Respectively obtain the data source information and timestamp fields of the trip recording, voice information and telephone call data in the preliminary aggregated data; Re-sort the preliminary aggregated data based on sorting conditions, data source information, and timestamp fields; Extract the "data source-time" pairing information of the data as the search title of the data, thereby forming aggregated data with the search title The data filtering module is used to accurately filter the aggregated data based on the query conditions to obtain the specified part of the trip recording, voice information and / or telephone call corresponding to the online car-hailing order as the final retrieval data.

5. The system for searching different data sources and data structures based on paging aggregation according to claim 4 is characterized in that: When the data filtering module is running, it specifically executes: Extracting specific search information from the query conditions, the specific search information including the voice type and the occurrence time period; Based on the specific search information, the voice type is converted into the corresponding data source to form a number of "data source-time" pairing information; Based on the "data source-time" pairing information and the search title in the aggregated data, a hit match is performed to perform data screening, and several hit data are intercepted separately, that is, the specified parts of the trip recordings, voice messages and / or telephone calls corresponding to the online car-hailing orders are obtained, and the extracted parts are returned as the final search data.

Images