A method and device for obtaining comprehensive arrangement data of multiple columns of data

Abstract

The purpose of this application is to provide a method and device for obtaining comprehensive arrangement data of multiple columns of data, specifically including: obtaining sorting request information about one or more target column identification information in the multiple columns of data, wherein the multiple columns of data include multiple row identification information corresponding thereto, and the sorting request information includes sorting rule information corresponding to the one or more target list information; determining the row-column mapping relationship between the multiple row identification information and the one or more target column identification information based on the sorting rule information, and determining the sorted row identification sequence based on the sorting rule information and the row-column mapping relationship; determining the corresponding comprehensive arrangement data based on the row identification sequence and the row data corresponding to the multiple row identification information. This application optimizes the sorting of multiple columns of data and determines the corresponding comprehensive arrangement data, thereby achieving convenient and fast column data sorting, improving data processing efficiency, and providing users with a good user experience.

Description

[0001] This application is a divisional application of CN 202111627860.4 (A method and device for obtaining comprehensive arrangement data of multiple columns of data, filing date: December 28, 2021) Technical Field

[0002] The present application relates to the field of communications, and in particular to a technology for obtaining comprehensive arrangement data of multiple columns of data. Background Art

[0003] When searching a list, it is usually necessary to sort the results, and even to sort multiple columns. Existing relational databases have the advantages of a unified format (mainly referring to unified table headers) and easy querying, and are widely used in various industries. Currently, most companies store their business data in relational databases. The indexing mechanism provided by the database is well optimized for querying and sorting single tables or raw data. However, in reality, data may be stored in multiple tables, and it may even be necessary to calculate results from multiple tables and then sort the resulting sequence. For such complex scenarios, simply using simple SQL splicing to implement query sorting cannot meet actual business needs. Summary of the Invention

[0004] One purpose of the present application is to provide a method and device for obtaining comprehensive arrangement data of multiple columns of data.

[0005] According to one aspect of the present application, a method for obtaining comprehensive arrangement data of multiple columns of data is provided, wherein the method comprises:

[0006] Obtaining sorting request information regarding one or more target column identification information in a plurality of columns of data, wherein the plurality of columns of data includes a plurality of row identification information corresponding thereto, and the sorting request information includes sorting rule information corresponding to the one or more target column identification information;

[0007] In response to the sorting request information, determining a row-column mapping relationship between the plurality of row identification information and the one or more target column identification information according to the sorting rule information, and determining a sorted row identification sequence according to the sorting rule information and the row-column mapping relationship;

[0008] Corresponding comprehensive arrangement data is determined according to the row identification sequence and the row data corresponding to the plurality of row identification information.

[0009] According to another aspect of the present application, a device for obtaining comprehensive arrangement data of multiple columns of data is provided, wherein the device includes:

[0010] a module configured to obtain sorting request information regarding one or more target column identification information in a plurality of columns of data, wherein the plurality of columns of data includes a plurality of row identification information corresponding thereto, and the sorting request information includes sorting rule information corresponding to the one or more target column identification information;

[0011] Module 12 is configured to respond to the sorting request information, determine a row-column mapping relationship between the plurality of row identification information and the one or more target column identification information according to the sorting rule information, and determine a sorted row identification sequence according to the sorting rule information and the row-column mapping relationship;

[0012] A third module is used to determine corresponding comprehensive arrangement data according to the row identification sequence and the row data corresponding to the multiple row identification information.

[0013] According to one aspect of the present application, a computer device is provided, wherein the device includes:

[0014] processor; and

[0015] A memory arranged to store computer executable instructions, which when executed cause the processor to perform the steps of any of the methods described above.

[0016] According to one aspect of the present application, a computer-readable storage medium is provided, on which a computer program / instruction is stored, characterized in that when the computer program / instruction is executed, the system performs the steps of any of the methods described above.

[0017] According to one aspect of the present application, a computer program product is provided, comprising a computer program / instruction, wherein the computer program / instruction implements the steps of any of the above methods when executed by a processor.

[0018] Compared with the existing technology, this application optimizes the sorting of multiple columns of data, determines the corresponding comprehensive arrangement data, realizes convenient and fast column data sorting, improves data processing efficiency, and brings a good user experience. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] Other features, objects and advantages of the present application will become more apparent upon reading the detailed description of non-limiting embodiments made with reference to the following drawings:

[0020] Figure 1 A flow chart of a method for obtaining comprehensive arrangement data of multiple columns of data according to one embodiment of the present application is shown;

[0021] Figure 2 Showing functional modules of a computer device according to another embodiment of the present application;

[0022] Figure 3 An exemplary system is shown that can be used to implement the various embodiments described in this application.

[0023] The same or similar reference numerals in the drawings represent the same or similar components. DETAILED DESCRIPTION

[0024] The present application is described in further detail below with reference to the accompanying drawings.

[0025] In a typical configuration of the present application, the terminal, the device of the service network and the trusted party all include one or more processors (eg, a central processing unit (CPU)), an input / output interface, a network interface and a memory.

[0026] Memory may include non-permanent storage in a computer-readable medium, random access memory (RAM) and / or non-volatile memory, such as read-only memory (ROM) or flash memory. Memory is an example of a computer-readable medium.

[0027] Computer-readable media include permanent and non-permanent, removable and non-removable media that can be used to store information by any method or technology. Information can be computer-readable instructions, data structures, program modules, or other data. Examples of computer storage media include, but are not limited to, phase-change memory (PCM), programmable random access memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, compact disc read-only memory (CD-ROM), digital versatile disc (DVD) or other optical storage, magnetic cassettes, magnetic tape disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device.

[0028] The devices referred to in this application include but are not limited to user devices, network devices, or devices formed by integrating user devices and network devices through a network. The user devices include but are not limited to any mobile electronic product that can interact with a user (for example, through a touchpad), such as a smartphone, a tablet computer, etc. The mobile electronic product can use any operating system, such as the Android operating system, the iOS operating system, etc. Among them, the network device includes an electronic device that can automatically perform numerical calculations and information processing according to pre-set or stored instructions, and its hardware includes but is not limited to a microprocessor, an application specific integrated circuit (ASIC), a programmable logic device (PLD), a field programmable gate array (FPGA), a digital signal processor (DSP), an embedded device, etc. The network device includes but is not limited to a computer, a network host, a single network server, a set of multiple network servers, or a cloud composed of multiple servers; here, the cloud is composed of a large number of computers or network servers based on cloud computing, wherein cloud computing is a type of distributed computing, a virtual supercomputer composed of a group of loosely coupled computers. The network includes but is not limited to the Internet, a wide area network, a metropolitan area network, a local area network, a VPN network, a wireless self-organizing network (Ad Hoc network), etc. Preferably, the device may also be a program running on the user device, the network device, or a device formed by integrating the user device and the network device, the network device and the touch terminal, or the network device and the touch terminal via a network.

[0029] Of course, those skilled in the art should understand that the above-mentioned devices are only examples, and other existing or future devices that are applicable to this application should also be included in the scope of protection of this application and are included here by reference.

[0030] In the description of the present application, “plurality” means two or more, unless otherwise clearly defined.

[0031] Figure 1A method for obtaining comprehensive arrangement data of multiple columns of data according to one aspect of the present application is shown, which is applied to a computer device, wherein the method includes steps S101, S102, and S103. In step S101, sorting request information about one or more target column identification information in the multiple columns of data is obtained, wherein the multiple columns of data include multiple row identification information corresponding thereto, and the sorting request information includes sorting rule information corresponding to the one or more target list information; in step S102, in response to the sorting request information, the row-column mapping relationship between the multiple row identification information and the one or more target column identification information is determined according to the sorting rule information, and the sorted row identification sequence is determined according to the sorting rule information and the row-column mapping relationship; in step S103, the corresponding comprehensive arrangement data is determined according to the row identification sequence and the row data corresponding to the multiple row identification information. The computer device is a user device, a network device, or a device formed by integrating a user device and a network device through a network. The user device includes but is not limited to any mobile electronic product that can perform human-computer interaction with the user (for example, human-computer interaction through a touchpad), such as a smart phone, a tablet computer, a personal computer, etc.; the network device includes but is not limited to a computer, a network host, a single network server, a set of multiple network servers, or a cloud composed of multiple servers. The execution of this solution can be completed locally on the user device (such as a user terminal, etc.), or the user device sends data to the network device for processing, and the network device returns the processing result (such as comprehensive arrangement data, etc.) to the user device, etc. Here, this application takes the local processing of the user device as an example to illustrate the following embodiments. Those skilled in the art should understand that these embodiments are also applicable to network devices, integrated devices of user devices and network devices, etc.

[0032] Specifically, in step S101, sorting request information about one or more target column identification information in multi-column data is obtained, wherein the multi-column data includes multiple row identification information corresponding thereto, and the sorting request information includes sorting rule information corresponding to the one or more target list information. For example, a user holds a user device (for example, a personal computer, etc.), and a corresponding spreadsheet application (for example, Excel, etc.) is installed on the personal computer. Multiple columns of data are stored through the spreadsheet application, wherein each column of the multiple columns of data includes corresponding column identification information, and each row of data includes corresponding row identification information, that is, the multiple columns of data include a corresponding initial row identification sequence, and the initial row identification sequence includes a column of row identification information for identifying each row of data in the multiple columns of data, and the initial row identification sequence is not included in the target column identification information used to determine the sorting order; a specific example is shown in Table 1 below, wherein the corresponding column data includes two column data corresponding to "student number" and "name", and each row of data has a corresponding row identification information, such as "10001" and "10002" contained in the "student number" column data, and the set of row identification information constitutes the initial row identification sequence in the multiple columns of data. In other words, the initial row identification sequence in the multiple columns of data includes all row identification information of the multiple columns of data.

[0033] Student ID Name 10001 Student A 10002 Student B

[0034] Table 1

[0035] In some cases, the user device can obtain the user's sorting operation on multiple columns of data and generate corresponding sorting request information. For example, a sorting control is set in the corresponding table application, and the user can enable the sorting function by touching the sorting control. Of course, the user can set the corresponding sorting requirements when starting the sorting function, such as setting the target column identification information to be sorted, and the arrangement rules of each target column identification information (for example, positive order or reverse order, etc.); in other cases, there is corresponding column sorting information between the corresponding target column identification information, and the column sorting information is used to indicate the column sorting order between multiple target column identification information. Wherein, the target column identification information includes indication information for identifying the data type of the corresponding column data in the multiple columns of data, such as the "name" described in Table 1.

[0036] Here, the multiple columns of data include tabular data composed of multiple column data corresponding to multiple column identification information stored in the same table, wherein the number of column data corresponding to the multiple column identification information may be the same or different. In other words, the data corresponding to the multiple column identification information corresponding to the initial row identification sequence may contain null values. In other cases, the corresponding multiple columns of data may be directly entered in the same table, or synthesized based on multiple columns of data from multiple tables. For example, in some embodiments, the method further includes step S104 (not shown), in which the tabular data corresponding to multiple tables are obtained, wherein each tabular data includes at least two column data, and the at least two column data include column data corresponding to the multiple row identification information; the multiple columns of data are generated based on the tabular data corresponding to the multiple tables. For example, the multiple columns of data stored on the user device side are generated from the tabular data corresponding to multiple tables. Specifically, in addition to the data shown in Table 1, the column data shown in Table 2 may also be included. The computer device generates the corresponding multiple columns of data based on the combination of the column data shown in Table 1 and the column data shown in Table 2, specifically as shown in Table 3; wherein the data in Table 2 are as follows:

[0037] Student ID score suject 10001 98 Language 10002 92 English 10002 80 Language 10001 93 English

[0038] Table 2

[0039] The data in Table 3 are as follows:

[0040] Student ID Name Chinese language scores English scores 10001 Student A 98 93 10002 Student B 80 92

[0041] Table 3

[0042] Wherein, each of the multiple table data includes at least two column data, and at least the two column data include a table row identification sequence corresponding to a row identification information, the arrangement order of the row identification information in the corresponding table row identification sequence is different from the corresponding initial row identification sequence, and the row identification information in each table row identification sequence includes all row identification information in the initial row identification sequence, which is used to integrate the relevant data of the same row identification information in the multiple table data into the corresponding key (for example, the row and column number of the corresponding multiple column data, etc.) when integrating into multiple column data. When integrating the column data in the multiple table data, it can be to directly merge the multiple column data, or to generate one or more new column identification information based on the corresponding column data, and then integrate the new one or more column data and merge them into the corresponding multiple column data, and the integration order of the multiple table data can be random, or specified by the user, or integrated according to a preset order (for example, in sequence according to the table serial number, etc.).

[0043] The sorting rule information includes the data sorting order of the column data in the corresponding one or more target column identification information, and the data sorting order includes sequential or reverse order, etc. Sequential refers to from small to large, from front to back, etc., and the corresponding reverse order refers to from large to small, from back to front, etc. In some cases, when the number of corresponding target column identification information includes multiple, the sorting rule information also includes column sorting information of the order of sorting of the multiple target column identification information, for example, sorting the "Chinese scores" first, and then sorting according to the "English scores" to determine the primary and secondary order of the corresponding sorting, etc. In some embodiments, the one or more target column identification information includes multiple target column identification information, and the sorting rule information includes column sorting information of the multiple target column identification information and data sorting information of each target column identification information. For example, the column sorting information is used to indicate the sorting order of each target column identification information in multiple target column identification information, wherein the target column identification information of the main order is used to indicate the column data for the first data sorting information, and the corresponding second-level target column identification information is used to indicate that the multiple columns of data sorted according to the target column identification information of the main order are sorted again according to the corresponding second-level target column identification information, and the data sorted by the second-level target column identification information includes the parallel data in the multiple columns of data after the target column identification information of the main order is sorted, etc.

[0044] In step S102, in response to the sorting request information, a row-column mapping relationship between the plurality of row identification information and the one or more target column identification information is determined based on the sorting rule information, and a sorted row identification sequence is determined based on the sorting rule information and the row-column mapping relationship. For example, in response to the sorting request information, the computer device determines a row-column mapping relationship between the column data in the corresponding target column identification information and the row identification of each column data based on the sorting rule information, and then combines the one or more row-column mapping relationships based on the sorting rule information to determine a final sorted row identification sequence.

[0045] In some embodiments, the data format of the row-column mapping relationship includes a key-value pair format. For example, the data format corresponding to the row-column mapping relationship includes, but is not limited to, a key-value pair data format, such as json (JavaScript Object Notation), jwt (Json web token), map storage, etc. Among them, the JSON data structure includes a collection of "key / value" pairs (A collection of name / value pairs). In different languages, it is understood as an object (Object), a record (Records), a structure (struct), a dictionary (dictionary), a hash table (hash table), a keyed list (keyed list), or an associative array (associative array), etc. The JSON data structure also includes an ordered list of values ​​(An ordered list of values), which is understood as data (array) in most languages. The specific manifestation is that by enclosing the string in double quotes, arrays and objects can be nested in the array, for example,

[0046]

[0047] In some cases, the corresponding sorting rule information can also be represented by the above data format.

[0048]

[0049] Among them, col represents the target column identification information corresponding to the to-be-sorted column, ord represents the data sorting information of the column data to which the target column identification information belongs, and desc represents that the data sorting information is in descending order.

[0050] The corresponding row-column mapping relationship can be expressed as,

[0051]

[0052] Among them, the column data in the target column identification information has corresponding row identification information, and the row identification information corresponding to one column data can be one or more. Here, the column data corresponding to the target column identification information serves as the key information to be sorted, and the corresponding row identification information serves as the value information corresponding to the sorted key. In some cases, when the column data is the same, the orderliness of the corresponding row identification is not guaranteed, that is, randomness may occur when there are multiple data identifications. However, in actual scenarios, it is usually hoped that multiple requests will obtain consistent results. To ensure the consistency of the results, after sorting the current target column identification information, the row identification information can be appended for positive / reverse order, or further arranged on the current basis based on other target column identification information until there is no situation where one column data corresponds to multiple row identification information.

[0053] In some embodiments, in step S102, in response to the sorting request information, the row-column mapping relationship corresponding to each column identification information is obtained based on the data sorting information of each target column identification information in the multiple target column identification information, thereby obtaining multiple row-column mapping relationships; the sorted row identification sequence is determined based on the multiple row-column mapping relationships and the column sorting information. For example, the row-column mapping relationship is used to indicate the mapping relationship between the sorted column data and the corresponding row identification information in the target column identification information determined according to a predetermined sorting rule, which is specifically manifested as the correspondence between the key as the column data and the value of the row identification corresponding to the key, etc. The computer device obtains the row-column mapping relationship of each target column identification information in the multiple target column identification information, and then determines the final row identification sequence based on the multiple row-column mapping relationships, for example, by combining the multiple row-column mapping relationships, and determining the row identification sequence based on the combination result, etc., wherein the combination order can be random, determined based on a preset rule, or specified by the user.

[0054] In some embodiments, the determining of the sorted row identification sequence based on the multiple row-column mapping relationships and the column sorting information includes: combining the row-column mapping relationship corresponding to the first column identification information with the row-column mapping relationship corresponding to the subsequent column identification information according to the column sorting information, until the row-column mapping relationship corresponding to the last column identification information in the column sorting information is combined, and determining the combined row-column mapping relationship after each column identification information is combined; determining the sorted row identification sequence based on the combined row-column mapping relationship. For example, we use Col1, Col2…Coln to represent the different multiple target column identification information (Column) in the sorting requirements, and use Ord1, Ord2…Ordn to refer to the order requirements (orderBy, i.e., positive or reverse order) of the column sorting information in the sorting rule order, CIR1, CIR2…CIR1 refer to the row-column mapping relationship between Col and Id, OrdR1, OrdR2…OrdRn refer to the results obtained by sorting Col1-Coln, and OrdRn is the final row identification sequence. We can calculate the final row identification sequence through the following steps:

[0055] 1) Obtaining CIR groups in multiple columns of data, for example, using column data of each column in the multiple columns of data as key information and corresponding row identification information as corresponding value information to obtain the CIR group corresponding to each column;

[0056] 2) Determine the corresponding CIR1 based on the target column identification information contained in Col1, process CIR1 based on Ord1, and obtain OrdR1 (the first sort is special and does not need to be combined with other sorts, only the forward or reverse order is sufficient);

[0057] 3) Determine the corresponding CIR2 based on the target column identifier information contained in Col2. Pre-sort CIR2 (same as step 2, sort CIR2 in ascending or descending order based on Ord2). Then combine the pre-sorted results of CIR1 and CIR2 to obtain OrdR2 (combine each key in OrdR1 with each key in CIR2, intersect their values, and determine the corresponding transition row identifier sequence).

[0058] 4) Repeat step 3 to perform combinatorial sorting on Col3 to Coln to obtain the final transition row identifier sequence.

[0059] In the above combination process, multiple target column identification information are combined in sequence. If all keys / values ​​are combined, a large amount of calculation will be generated. Here, we can perform certain optimizations to ensure the accuracy of the calculation while improving the calculation efficiency. Specifically, for example, when combining the keys one by one, if there is only one value (that is, the array has only one element, or the array length is 1), it can be skipped (one element does not need to be sorted). For example, in some embodiments, the row-column mapping relationship corresponding to the first column identification information and the row-column mapping relationship corresponding to the subsequent column identification information are combined in sequence according to the column sorting information, including: determining the corresponding repeated row and column data from the row and column mapping relationship corresponding to the first column identification information according to the column sorting information, and combining the repeated row and column data according to the row and column mapping relationship corresponding to the subsequent column identification information.

[0060] For example, each key is combined, and the intersection of their values ​​is taken. Finally, the combined values ​​are filtered to be empty arrays, i.e., the corresponding combined values ​​are removed. Furthermore, when null values ​​are encountered during the combination process, they can be directly ignored, eliminating the performance loss caused by the final filtering of null values. In some embodiments, determining the sorted row identifier sequence based on the combined row-column mapping relationship includes: removing the null values ​​in the combined row-column mapping relationship, thereby obtaining the sorted row identifier sequence.

[0061] In step S103, the corresponding comprehensive arrangement data is determined based on the row identification sequence and the row data corresponding to the plurality of row identification information. For example, the computer device fills the data of each row with the column identification information according to the order of each row identification information in the row identification sequence based on the final sorting, thereby generating the final comprehensive arrangement data.

[0062] For example, for multiple columns of data containing the corresponding column identification information of "rights holder" and "undertaker", the corresponding initial row identification information is the sorting sequence number of each row of data, such as 1, 2, 3...7, etc.

[0063]

[0064]

[0065] According to Ord2, OrdR1 and CIR2, OrdR2 and Ord1 are in ascending order. There is no need to pre-process CIR2. You can directly combine CIR2 and OrdR1 to sort them.

[0066]

[0067]

[0068] Among them, the corresponding final row identifier sequence is: 6, 4, 3 / 7, 1 / 5, 2; in some cases, we can arrange the parallel data in sequence order to ensure the consistency of the sorting results, thereby expressing the row identifier sequence as: 6, 4, 3, 7, 1, 5, 2.

[0069] In some embodiments, the method further includes step S105 (not shown), in which a paging request for the comprehensive arrangement data is obtained, wherein the paging request includes corresponding paging interval information; in response to the paging request, the comprehensive arrangement data is paging-processed according to the paging interval information to obtain corresponding multi-page arrangement data. For example, after the computer device determines the comprehensive arrangement data according to the sorting rule information, it can also perform relevant operations on the comprehensive arrangement data to obtain the data desired by the user. For example, the computer device can determine the paging request for the comprehensive arrangement data based on the user operation, wherein the paging request includes corresponding paging interval information, wherein the paging interval information includes the number of rows of row data contained in each page after the corresponding paging. Here, the paging request can be obtained after the comprehensive arrangement data is sorted, or it can be obtained together with the sorting, so that the computer device can directly perform the corresponding paging operation during the sorting process and determine the multi-page arrangement data after the paging. The computer device paging-processes the comprehensive arrangement data according to the paging interval information (for example, three per page, etc.), and determines the corresponding multi-page arrangement data in a format of three rows of data per page.

[0070] In some embodiments, the method further includes step S106 (not shown), in which a request for obtaining a value for the paging arrangement data is obtained, wherein the request for obtaining a value includes the corresponding number of pages to be obtained; in response to the request for obtaining a value, the page data corresponding to the obtained value page is determined from the multi-page arrangement data. For example, based on the paging operation, the user can also perform a value operation on the data of a specific page in the multi-page arrangement data, thereby separately obtaining a certain page of data in the multi-page arrangement data. For example, according to the requirement of "three second pages per page", the element may fall into "Rightholder 2" or "Rightholder 1". In this case, "Rightholder 3" can be ignored, and OrdR1 can be simplified as follows:

[0071]

[0072] Among them, there are three elements in "Rights Holder 1". Since the order of these three elements cannot be determined, one of them cannot be partially ignored. It can only be ignored when it is divided in subsequent sorting.

[0073] In some embodiments, the target column identification information includes, but is not limited to, case handler information; rights holder information; case filing time information; and case trial time information. For example, the multi-column sorting information is used to determine a case statistics system, which includes multiple columns of data. The corresponding column identification information for the multiple columns of data includes, but is not limited to, case handler information, rights holder information, case filing time information, and case trial time information. The case handler information indicates the person handling the case, the rights holder information indicates the holder of the case's claims, the corresponding case filing time information indicates the time the case was accepted, and the case trial time indicates the time of the first or second instance trial, etc.

[0074] The above mainly introduces the various embodiments of the present application for obtaining comprehensive arrangement data of multiple columns of data. In addition, the present application also provides a device capable of implementing the above embodiments. Figure 2 Make an introduction.

[0075] Figure 2 A computer device for obtaining comprehensive arrangement data of multiple columns of data according to one aspect of the present application is shown, wherein the device includes a first module 101, a second module 102, and a third module 103. The first module 101 is used to obtain sorting request information regarding one or more target column identification information in the multiple columns of data, wherein the multiple columns of data include multiple row identification information corresponding thereto, and the sorting request information includes sorting rule information corresponding to the one or more target list information; the first module 102 is used to determine, in response to the sorting request information, a row-column mapping relationship between the multiple row identification information and the one or more target column identification information based on the sorting rule information, and determine a sorted row identification sequence based on the sorting rule information and the row-column mapping relationship; and the third module 103 is used to determine corresponding comprehensive arrangement data based on the row identification sequence and the row data corresponding to the multiple row identification information.

[0076] Here, the Figure 2 The specific implementations of the modules 101, 102, and 103 shown are similar to those described above. Figure 1 The illustrated embodiments of step S101 , step S102 , and step S103 are the same or similar, and thus are not described in detail but are incorporated herein by reference.

[0077] In some embodiments, the device also includes a fourth module (not shown) for obtaining tabular data corresponding to multiple tables, wherein each tabular data includes at least two column data, and the at least two column data include column data corresponding to the multiple row identification information; and the multiple column data are generated based on the tabular data corresponding to the multiple tables.

[0078] In some embodiments, the one or more target column identification information includes multiple target column identification information, and the sorting rule information includes column sorting information of the multiple target column identification information and data sorting information of each target column identification information.

[0079] In some implementations, the data format of the row-column mapping relationship includes a lightweight data exchange format.

[0080] In some embodiments, module 102 is used to respond to the sorting request information, obtain the row-column mapping relationship corresponding to each column identification information according to the data sorting information of each target column identification information in the multiple target column identification information, thereby obtaining multiple row-column mapping relationships; determine the sorted row identification sequence according to the multiple row-column mapping relationships and the column sorting information.

[0081] In some embodiments, determining the sorted row identification sequence based on the multiple row-column mapping relationships and the column sorting information includes: combining the row-column mapping relationship corresponding to the first column identification information with the row-column mapping relationships corresponding to the subsequent column identification information in sequence according to the column sorting information, until combining to the row-column mapping relationship corresponding to the last column identification information in the column sorting information, to determine the combined row-column mapping relationship after the combination of each column identification information; and determining the sorted row identification sequence based on the combined row-column mapping relationship.

[0082] In some embodiments, the row-column mapping relationship corresponding to the first column identification information and the row-column mapping relationship corresponding to the subsequent column identification information are combined in sequence according to the column sorting information, including: determining the corresponding repeated row and column data from the row-column mapping relationship corresponding to the first column identification information in sequence according to the column sorting information, and combining the repeated row and column data with the row and column mapping relationship corresponding to the subsequent column identification information.

[0083] In some implementations, determining the sorted row identifier sequence according to the combined row-column mapping relationship includes: removing null values ​​in the combined row-column mapping relationship, thereby obtaining the sorted row identifier sequence.

[0084] In some embodiments, the device further includes a module (not shown) for obtaining a paging request regarding the comprehensive arrangement data, wherein the paging request includes corresponding paging interval information; in response to the paging request, the comprehensive arrangement data is paging-processed according to the paging interval information to obtain corresponding multi-page arrangement data.

[0085] In some embodiments, the device further includes a module (not shown) for obtaining a value request regarding the paging arrangement data, wherein the value request includes a corresponding value page number; and in response to the value request, determining page data corresponding to the value page from the multiple pages of arrangement data.

[0086] In some embodiments, the target column identification information includes but is not limited to: information of the person in charge; information of the right holder; information of the case filing time; and information of the case trial time.

[0087] Here, the specific implementations corresponding to the four modules to the six modules are the same as or similar to the embodiments of the aforementioned steps S104 to S106, and thus are not described in detail and are included herein by reference.

[0088] In addition to the methods and devices described in the above embodiments, the present application also provides a computer-readable storage medium, which stores computer code. When the computer code is executed, the method described in any of the above items is executed.

[0089] The present application also provides a computer program product. When the computer program product is executed by a computer device, the method described in any one of the preceding items is executed.

[0090] The present application also provides a computer device, comprising:

[0091] one or more processors;

[0092] a memory for storing one or more computer programs;

[0093] When the one or more computer programs are executed by the one or more processors, the one or more processors are caused to implement the method as described in any one of the preceding items.

[0094] Figure 3 shows an exemplary system that can be used to implement the various embodiments described in this application;

[0095] like Figure 3 In some embodiments, the system 300 can function as any of the aforementioned devices in the various embodiments described. In some embodiments, the system 300 may include one or more computer-readable media (e.g., system memory or NVM / storage device 320) having instructions and one or more processors (e.g., processor(s) 305) coupled to the one or more computer-readable media and configured to execute the instructions to implement the modules and thereby perform the actions described herein.

[0096] For one embodiment, system control module 310 may include any suitable interface controller to provide any suitable interface to at least one of processor(s) 305 and / or any suitable device or component in communication with system control module 310 .

[0097] The system control module 310 may include a memory controller module 330 to provide an interface to the system memory 315. The memory controller module 330 may be a hardware module, a software module, and / or a firmware module.

[0098] System memory 315 can be used, for example, to load and store data and / or instructions for system 300. For one embodiment, system memory 315 can include any suitable volatile memory, such as a suitable DRAM. In some embodiments, system memory 315 can include double data rate type four synchronous dynamic random access memory (DDR4 SDRAM).

[0099] For one embodiment, system control module 310 may include one or more input / output (I / O) controllers to provide interfaces to NVM / storage device 320 and communication interface(s) 325 .

[0100] For example, NVM / storage 320 may be used to store data and / or instructions. NVM / storage 320 may include any suitable non-volatile memory (e.g., flash memory) and / or may include any suitable non-volatile storage device(s) (e.g., one or more hard disk drives (HDDs), one or more compact disk (CD) drives, and / or one or more digital versatile disk (DVD) drives).

[0101] NVM / storage device 320 may include storage resources that are physically part of the device on which system 300 is installed, or it may be accessible to the device without being part of the device. For example, NVM / storage device 320 may be accessed over a network via communication interface(s) 325.

[0102] Communication interface(s) 325 may provide an interface for system 300 to communicate over one or more networks and / or with any other suitable devices. System 300 may wirelessly communicate with one or more components of a wireless network in accordance with any of one or more wireless network standards and / or protocols.

[0103] For one embodiment, at least one of the processor(s) 305 may be packaged together with the logic of one or more controllers of the system control module 310 (e.g., the memory controller module 330). For one embodiment, at least one of the processor(s) 305 may be packaged together with the logic of one or more controllers of the system control module 310 to form a system-in-package (SiP). For one embodiment, at least one of the processor(s) 305 may be integrated on the same die with the logic of one or more controllers of the system control module 310. For one embodiment, at least one of the processor(s) 305 may be integrated on the same die with the logic of one or more controllers of the system control module 310 to form a system-on-chip (SoC).

[0104] In various embodiments, system 300 may be, but is not limited to, a server, a workstation, a desktop computing device, or a mobile computing device (e.g., a laptop computing device, a handheld computing device, a tablet computer, a netbook, etc.). In various embodiments, system 300 may have more or fewer components and / or a different architecture. For example, in some embodiments, system 300 includes one or more cameras, a keyboard, a liquid crystal display (LCD) screen (including a touchscreen display), a non-volatile memory port, multiple antennas, a graphics chip, an application-specific integrated circuit (ASIC), and a speaker.

[0105] It should be noted that the application can be implemented in software and / or a combination of software and hardware, for example, can be implemented using an application specific integrated circuit (ASIC), a general purpose computer or any other similar hardware device. In one embodiment, the software program of the application can be executed by a processor to realize the steps or functions described above. Similarly, the software program of the application (including relevant data structures) can be stored in a computer-readable recording medium, for example, a RAM memory, a magnetic or optical drive or a floppy disk and similar devices. In addition, some steps or functions of the application can be implemented using hardware, for example, as a circuit that cooperates with a processor to perform each step or function.

[0106] In addition, a part of the present application may be applied as a computer program product, such as a computer program instruction, which, when executed by a computer, can call or provide the method and / or technical solution according to the present application through the operation of the computer. Those skilled in the art should understand that the form in which the computer program instruction exists in a computer-readable medium includes but is not limited to a source file, an executable file, an installation package file, etc. Accordingly, the way in which the computer program instruction is executed by the computer includes but is not limited to: the computer directly executes the instruction, or the computer compiles the instruction and then executes the corresponding compiled program, or the computer reads and executes the instruction, or the computer reads and installs the instruction and then executes the corresponding installed program. Here, the computer-readable medium can be any available computer-readable storage medium or communication medium that can be accessed by the computer.

[0107] Communication media include media by which communication signals containing, for example, computer-readable instructions, data structures, program modules, or other data are transmitted from one system to another. Communication media may include guided transmission media such as cables and wires (e.g., fiber optic, coaxial, etc.) and wireless (unguided transmission) media capable of propagating energy waves, such as acoustic, electromagnetic, RF, microwave, and infrared. Computer-readable instructions, data structures, program modules, or other data may be embodied as, for example, a modulated data signal in a wireless medium such as a carrier wave or similar mechanism such as that embodied as part of spread spectrum technology. The term "modulated data signal" refers to a signal that has one or more of its characteristics changed or set in such a manner as to encode information in the signal. Modulation may be analog, digital, or a hybrid modulation technique.

[0108] By way of example and not limitation, computer-readable storage media may include volatile and non-volatile, removable and non-removable media implemented in any method or technology for storage of information such as computer-readable instructions, data structures, program modules or other data. For example, computer-readable storage media include, but are not limited to, volatile memory, such as random access memory (RAM, DRAM, SRAM); and non-volatile memory, such as flash memory, various read-only memories (ROM, PROM, EPROM, EEPROM), magnetic and ferromagnetic / ferroelectric memories (MRAM, FeRAM); and magnetic and optical storage devices (hard disks, magnetic tapes, CDs, DVDs); or other media now known or later developed that can store computer-readable information / data for use by a computer system.

[0109] Here, according to one embodiment of the present application, a device is included, which includes a memory for storing computer program instructions and a processor for executing the program instructions, wherein, when the computer program instructions are executed by the processor, the device is triggered to run the methods and / or technical solutions based on the aforementioned multiple embodiments of the present application.

[0110] It is obvious to those skilled in the art that the present application is not limited to the details of the above-mentioned exemplary embodiments, and that the present application can be implemented in other specific forms without departing from the spirit or basic characteristics of the present application. Therefore, from any point of view, the embodiments should be regarded as exemplary and non-restrictive, and the scope of the present application is defined by the appended claims rather than the above description, and it is intended that all changes that fall within the meaning and scope of the equivalent elements of the claims are included in the present application. Any figure mark in the claims should not be regarded as limiting the claims involved. In addition, it is obvious that the word "comprising" does not exclude other units or steps, and the singular does not exclude the plural. Multiple units or devices stated in the device claim can also be implemented by one unit or device through software or hardware. Words such as first and second are used to indicate names and do not indicate any particular order.

Claims

1. A method for obtaining comprehensive arrangement data of multiple columns of data, wherein: The method includes: Obtaining tabular data corresponding to a plurality of tables, wherein each tabular data includes at least two columns of data, the at least two columns of data including a table row identification sequence corresponding to a row identification information, the row identification information in each table row identification sequence including all row identification information in an initial row identification sequence, and integrating related data of the same row identification information in the plurality of tabular data into corresponding keys when integrating the plurality of columns of data; and generating a plurality of columns of data based on the tabular data corresponding to the plurality of tables; Obtaining sort request information regarding multiple target column identification information in multiple columns of data, wherein the multiple columns of data include multiple row identification information corresponding thereto, the sort request information includes sort rule information corresponding to the multiple target column identification information, the sort rule information includes a data sorting order of column data corresponding to the multiple target column identification information, and the sort rule information also includes column sorting information of the multiple target column identification information and data sorting information of each target column identification information; In response to the sorting request information, obtaining a row-column mapping relationship corresponding to each target column identification information according to data sorting information of each target column identification information in the plurality of target column identification information, thereby obtaining a plurality of row-column mapping relationships; Combining the row-column mapping relationship corresponding to the first column identification information with the row-column mapping relationships corresponding to the subsequent column identification information according to the column sorting information, until the row-column mapping relationship corresponding to the last column identification information in the column sorting information is reached, and determining the combined row-column mapping relationship after the respective column identification information are combined; Determine a sorted row identifier sequence according to the combined row-column mapping relationship; Corresponding comprehensive arrangement data is determined according to the row identification sequence and the row data corresponding to the plurality of row identification information.

2. The method according to claim 1, wherein The data format of the row-column mapping relationship includes a key-value pair data format.

3. The method according to claim 1, wherein The combining, in sequence according to the column sorting information, the row-column mapping relationship corresponding to the first column identification information with the row-column mapping relationships corresponding to the subsequent column identification information includes: The corresponding repeated row and column data are determined from the row and column mapping relationship corresponding to the first column identification information according to the column sorting information, and are combined according to the repeated row and column data and the row and column mapping relationship corresponding to the subsequent column identification information.

4. The method according to claim 1 or 3, wherein Determining a sorted row identifier sequence according to the combined row-column mapping relationship includes: The null values ​​in the combined row-column mapping relationship are removed to obtain a sorted row identifier sequence.

5. The method according to claim 1, wherein The method further comprises: Obtaining a paging request for the comprehensive arrangement data, wherein the paging request includes corresponding paging interval information; In response to the paging request, the comprehensive arrangement data is paging-processed according to the paging interval information to obtain corresponding multiple pages of arrangement data.

6. The method according to claim 5, wherein: The method further comprises: Obtaining a request for obtaining a value of the plurality of pages of arranged data, wherein the request includes a corresponding number of pages for obtaining a value; In response to the value request, page data corresponding to the value page number is determined from the multiple pages of arrangement data.

7. The method according to claim 1, wherein The target column identification information includes at least one of the following: Organizer information; Rights holder information; Case filing time information; Case hearing time information.

8. A device for obtaining comprehensive arrangement data of multiple columns of data, wherein: The device includes: Module 14 is configured to obtain table data corresponding to a plurality of tables, wherein each table data includes at least two columns of data, the at least two columns of data including a table row identification sequence corresponding to a row identification information, the row identification information in each table row identification sequence including all row identification information in an initial row identification sequence, and to integrate related data with the same row identification information in the plurality of table data into corresponding keys when integrating the plurality of columns of data; and to generate the plurality of columns of data based on the table data corresponding to the plurality of tables; a module configured to obtain sorting request information regarding a plurality of target column identification information in a plurality of columns of data, wherein the plurality of columns of data include a plurality of row identification information corresponding thereto, the sorting request information includes sorting rule information corresponding to the plurality of target column identification information, the sorting rule information includes a data sorting order of the column data corresponding to the plurality of target column identification information, the sorting rule information also includes column sorting information of the plurality of target column identification information and data sorting information of each target column identification information; Module one or two is configured to obtain, in response to the sorting request information, a row-column mapping relationship corresponding to each target column identification information according to data sorting information of each target column identification information in the plurality of target column identification information, thereby obtaining a plurality of row-column mapping relationships; Combining the row-column mapping relationship corresponding to the first column identification information with the row-column mapping relationships corresponding to the subsequent column identification information according to the column sorting information, until the row-column mapping relationship corresponding to the last column identification information in the column sorting information is reached, and determining the combined row-column mapping relationship after the respective column identification information are combined; Determine a sorted row identifier sequence according to the combined row-column mapping relationship; A third module is used to determine corresponding comprehensive arrangement data according to the row identification sequence and the row data corresponding to the multiple row identification information.

9. A computer device, wherein: The device includes: processor; and A memory arranged to store computer executable instructions which, when executed, cause the processor to perform the steps of the method as claimed in any one of claims 1 to 7.

10. A computer-readable storage medium having a computer program / instruction stored thereon, characterized in that: The computer program / instructions, when executed, cause the system to perform the steps of the method as claimed in any one of claims 1 to 7.

11. A computer program product comprising a computer program / instructions, characterized in that When the computer program / instructions are executed by a processor, the steps of the method according to any one of claims 1 to 7 are implemented.

Images