Data processing method and device, electronic equipment and storage medium

Abstract

The present disclosure provides a data processing method, device, electronic equipment and storage medium. The data processing method comprises: in response to determining that the function calculation type of a database table is a first type, converting an associated field into a target parameter, and reading row reference information recorded by the associated field according to the target parameter; in response to determining that the function calculation type of a database table is a second type, converting an associated field into the target parameter, and reading index column information recorded by the associated field according to the target parameter. The method of the present disclosure can make the associated field behave as a row reference when participating in chain calling, and can also degenerate into the value of the index cell of the associated record when participating in ordinary function calculation.

Description

Technical Field

[0001] This disclosure relates to the field of computer technology, and more particularly to a data processing method, apparatus, electronic device, and storage medium. Background Technology

[0002] In database table formula calculations, related fields are converted into the values ​​of the index cells of the associated records for calculation. This calculation rule is simple to implement, but it loses the information carried by the records stored in the related fields. The information stored in related fields is essentially row references to multiple records, which can be used to read information from specified columns in these row references and participate in complex formula calculations. Summary of the Invention

[0003] This summary section is provided to briefly introduce the concepts, which will be described in detail in the detailed description section below. This summary section is not intended to identify key or essential features of the claimed technical solution, nor is it intended to limit the scope of the claimed technical solution.

[0004] This disclosure provides a data processing method, apparatus, electronic device, and storage medium.

[0005] The following technical solution is adopted in this disclosure.

[0006] In some embodiments, this disclosure provides a data processing method, including:

[0007] In response to determining that the function calculation type of the database table is a first type, the associated field is converted into a target parameter, and the row reference information of the associated field record is read according to the target parameter;

[0008] In response to determining that the function calculation type of the database table is the second type, the associated field is converted into the target parameter, and the index column information of the associated field record is read according to the target parameter.

[0009] In some embodiments, this disclosure provides a data processing apparatus, including:

[0010] The first processing module is used to convert the associated field into a target parameter in response to determining that the function calculation type of the database table is a first type, and to read the row reference information of the associated field record according to the target parameter;

[0011] The second processing module is used to convert the associated field into the target parameter in response to determining that the function calculation type of the database table is the second type, and to read the index column information of the associated field record according to the target parameter.

[0012] In some embodiments, this disclosure provides an electronic device, including: at least one memory and at least one processor;

[0013] The memory is used to store program code, and the processor is used to call the program code stored in the memory to execute the above method.

[0014] In some embodiments, this disclosure provides a computer-readable storage medium for storing program code that, when run by a processor, causes the processor to perform the methods described above.

[0015] The data processing method provided in this disclosure, in response to determining that the function calculation type of the database table is a first type, converts the associated field into a target parameter and reads the row reference information of the associated field record according to the target parameter; in response to determining that the function calculation type of the database table is a second type, converts the associated field into the target parameter and reads the index column information of the associated field record according to the target parameter. This method allows the associated field to behave as a row reference when participating in chained calls, and to degenerate into the value of the index cell of the associated record when participating in ordinary function calculations. Attached Figure Description

[0016] The above and other features, advantages, and aspects of the embodiments of this disclosure will become more apparent from the accompanying drawings and the following detailed description. Throughout the drawings, the same or similar reference numerals denote the same or similar elements. It should be understood that the drawings are schematic, and elements are not necessarily drawn to scale.

[0017] Figure 1 This is one of the flowcharts of the data processing method according to an embodiment of this disclosure.

[0018] Figure 2 This is the second flowchart of the data processing method according to an embodiment of this disclosure.

[0019] Figure 3 This is the third flowchart of the data processing method according to an embodiment of this disclosure.

[0020] Figure 4 This is one of the schematic diagrams illustrating the effect of the data processing method in the embodiments of this disclosure.

[0021] Figure 5 This is the second schematic diagram illustrating the effect of the data processing method according to an embodiment of this disclosure.

[0022] Figure 6 This is the third schematic diagram illustrating the effect of the data processing method in this embodiment of the disclosure.

[0023] Figure 7 This is a schematic diagram of the structure of an electronic device according to an embodiment of the present disclosure. Detailed Implementation

[0024] Embodiments of this disclosure will now be described in more detail with reference to the accompanying drawings. While some embodiments of this disclosure are shown in the drawings, it should be understood that this disclosure can be implemented in various forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided to provide a more thorough and complete understanding of this disclosure. It should be understood that the accompanying drawings and embodiments of this disclosure are for illustrative purposes only and are not intended to limit the scope of protection of this disclosure.

[0025] It should be understood that the various steps described in the method embodiments of this disclosure can be performed in sequence and / or in parallel. Furthermore, method embodiments may include additional steps and / or omit the steps shown. The scope of this disclosure is not limited in this respect.

[0026] The term "comprising" and its variations as used herein are open-ended inclusion, meaning "including but not limited to". The term "based on" means "at least partially based on". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments". Relevant definitions of other terms will be given in the description below. The term "in response to" and related terms refer to a signal or event being affected to some extent by another signal or event, but not necessarily completely or directly. If event x occurs "in response to" event y, then x may be directly or indirectly responsive to y. For example, the occurrence of y may ultimately lead to the occurrence of x, but there may be other intermediate events and / or conditions. In other cases, y may not necessarily lead to the occurrence of x, and x may occur even if y has not yet occurred. Furthermore, the term "in response to" can also mean "at least partially responsive to".

[0027] The term "determine" broadly encompasses a wide variety of actions, including acquisition, calculation, computation, processing, derivation, investigation, search (e.g., searching in a table, database, or other data structure), discovery, and similar actions; it may also include receiving (e.g., receiving information), accessing (e.g., accessing data in memory), parsing, selecting, choosing, building, and similar actions, etc. Definitions for other terms will be provided below.

[0028] It should be noted that the concepts of "first" and "second" mentioned in this disclosure are used only to distinguish different devices, modules or units, and are not used to limit the order of functions performed by these devices, modules or units or their interdependencies.

[0029] It should be noted that the use of the word "a" in this disclosure is illustrative rather than restrictive, and those skilled in the art should understand that it should be understood as "one or more" unless otherwise expressly indicated in the context.

[0030] The names of messages or information exchanged between multiple devices in the embodiments of this disclosure are for illustrative purposes only and are not intended to limit the scope of such messages or information.

[0031] The solutions provided by the embodiments of this disclosure will be described in detail below with reference to the accompanying drawings.

[0032] like Figure 1 As shown, Figure 1 This is a flowchart of a data processing method according to an embodiment of the present disclosure, which includes the following steps.

[0033] Step S01: In response to determining that the function calculation type of the database table is the first type, the associated field is converted into the target parameter, and the row reference information of the associated field record is read according to the target parameter;

[0034] Step S02: In response to determining that the function calculation type of the database table is the second type, the associated field is converted into the target parameter, and the index column information of the associated field record is read according to the target parameter.

[0035] In some embodiments, the association field is divided into one-way association and two-way association, which stores one or more records from the associated table. A record, also called a data row, is an ordered collection of related data in the data table.

[0036] In some embodiments, associated field information is needed to read row reference information or index column information during formula processing. How to select different reading methods for different operations, and how to degenerate reading row reference information into reading index column information during ordinary function calculations, are pressing technical problems that need to be solved. The data processing method provided in this disclosure provides, on the one hand, the ability to read the value of a specified column in the record associated with the associated field, and on the other hand, the ability to read the value of an index column in the record associated with the associated field. Specifically, when the associated field participates in special function calculations such as chained calls, it manifests as a row reference to read the value of a specified column; when participating in ordinary function calculations, it manifests as an index column reference to read the value of an index column. For example, when the associated field participates in the formula calculation of [associated field].[text], the associated field is converted into a target parameter that wraps the associated table identifier ID (Identity document) and the set of stored record IDs. Then, the target parameter is passed into the internal logic of special operators such as chained calls, and the result of reading the row reference information of the associated field record is output. For example, when a related field is used in the formula [related field] + [related field], the related field is first converted into a target parameter, and then the target parameter is converted into the value of the index column and passed into the internal logic of the ordinary operator to read the value of the index column of the related field record. Chained calls allow you to call other functions after calling one, which greatly reduces the amount of code, especially in large projects. The target parameter can be a RecordCollectionVar.

[0037] The data processing method provided in this disclosure, in response to determining that the function calculation type of the database table is a first type, converts the associated field into a target parameter and reads the row reference information of the associated field record according to the target parameter; in response to determining that the function calculation type of the database table is a second type, converts the associated field into the target parameter and reads the index column information of the associated field record according to the target parameter. The method of this disclosure allows the associated field to behave as a row reference when participating in chained calls, and to degenerate into the value of the index cell of the associated record when participating in ordinary function calculations. It is evident that the method of this disclosure can demonstrate the ability to read information from associated fields in function calculations of database tables, while related technologies only apply the ability to read information from associated fields to special fields, without implementing this ability in the formula.

[0038] In some embodiments, the step of converting the associated field into a target parameter in response to determining that the function calculation type of the database table is a first type includes:

[0039] When a function calculation call to determine a database table invokes the first preset operator, the associated fields are converted into target parameters.

[0040] In some embodiments, given the different behavior of the associated field in the [associated field].[text] formula and the [associated field]+[associated field] formula when dealing with different operators, this disclosure provides corresponding operator parameter conversion logic. For example... Figure 2 As shown, for formulas containing special operators, such as [related fields].[text], the related fields are first converted into target parameters, and then the target parameters are directly passed to the internal logic of the special operators that can process them for calculation. The target parameter can be a RecordCollectionVar.

[0041] In some embodiments, the step of converting the associated field into the target parameter in response to determining that the function calculation type of the database table is a second type includes:

[0042] When a function calculation call to determine a database table invokes a second preset operator, the associated field is converted into the target parameter.

[0043] In some embodiments, such as Figure 2 As shown, for formulas containing ordinary operators such as [related field] + [related field], the related field is first converted into a target parameter, and then the target parameter is converted into the value of the indexed column and passed into the internal logic of the ordinary operator for calculation. The target parameter can be RecordCollectionVar.

[0044] In some embodiments, reading the row reference information of the associated field record according to the target parameter includes:

[0045] Based on the calculation logic of the target parameter and the first preset operator, the row reference information of the associated field record is read.

[0046] In some embodiments, for formulas containing the special operator "." such as [related field].[text], the related field is first converted into a target parameter, and then the target parameter is directly passed to the internal logic of the special operator that can process the target parameter for calculation. Figure 4 As shown, the chained call of related fields performs a normal calculation. The text column in the image includes: apple, pear, apple. The related fields include: apple, pear, (apple, pear, apple). The function calculation formula is [related1].[text]. The data reference can be selected as [text], [related2], or [multiple selection]. The calculation logic is: read the collection of all cells under the selected column in the image, which can be used for formula calculation. The target parameter can be RecordCollectionVar.

[0047] In some embodiments, reading the index column information of the associated field record according to the target parameter includes:

[0048] Based on the calculation logic of the target parameter and the second preset operator, the index column information of the associated field record is read.

[0049] In some embodiments, for formulas containing ordinary operators, such as [related field] + [related field], the related field is first converted into a target parameter, and then the target parameter is converted into the value of the indexed column and passed into the internal logic of the ordinary operator for calculation. The target parameter can be RecordCollectionVar.

[0050] In some embodiments, the target parameter includes the sub-table associated with the associated field and the records stored in the associated field.

[0051] In some embodiments, the associated field stores the records of the associated table. During the formula calculation process, it cannot be directly converted into the value of the index cell to participate in the calculation, otherwise the information of other columns of the associated record will be lost. Therefore, how to design a new data structure to store the associated field information in order to ensure that no information is lost during the entire formula calculation process has become an urgent technical problem to be solved.

[0052] In some embodiments, when participating in formula calculations, the information stored in the associated field cannot be reduced to the value of the index column of the stored record, but should carry complete information. The content stored in the associated field includes the referenced sub-table and the records of the associated sub-table. Furthermore, the attribute of the target parameter converted from the associated field is a set of the ID of the associated sub-table and the IDs of the stored records. The target parameter can be RecordCollectionVar.

[0053] In some embodiments, it also includes:

[0054] In response to determining that the reference type of the associated field is a first type, the target parameter is converted into a reference to the table associated with the associated field, wherein the associated table is the table containing the selected column of the associated field;

[0055] Based on the calculation logic of the first preset operator, the reference of the associated table and the reference of the selected column of the associated field are compared. If the reference of the associated table intersects with the reference of the selected column of the associated field, the reference result of the selected column of the associated field is output.

[0056] In some embodiments, chaining formulas using related fields is equivalent to a query, and the query results need to be plotted in a database table using the style of the target column, i.e., a 'as-is' reference. Therefore, how to pass the style of the target column during the calculation process of querying the target column through related fields becomes a problem that urgently needs to be solved.

[0057] In some embodiments, such as Figure 3 As shown, to support the on-the-fly referencing of formulas in chained calls of related fields, the calculation results of these formulas in the inference on-the-fly referencing scenario (i.e., prediction mode) need to be modified. The design incorporates internal logic for special operators such as chained calls. In prediction mode, the target parameter is converted into a reference to the associated table for calculation. The associated table is the table containing the selected columns of the related fields. The calculation logic of the chained call operator for the table reference and the reference to the selected columns of the related fields determines whether the two references intersect; if they intersect, the latter is returned. The target parameter can be a RecordCollectionVar.

[0058] In some embodiments, it also includes:

[0059] In response to determining that the reference type of the associated field is the second type and that the output reference result is the reference result of the selected column of the associated field, the value of the selected column of the associated field is read and the value of the selected column of the associated field is drawn using the rendering style of the selected column of the associated field.

[0060] In some embodiments, taking the [Associated Field].[Multiple Selection] formula as an example, in the prediction mode, the internal logic of the chained call operator transforms the target parameter obtained from reading the associated field to obtain a reference to the associated table, and then calculates the reference to the selected column (multiple selection column). In the normal calculation mode, the internal logic of the chained call operator reads the value of the selected column from the record where the target parameter is stored. After obtaining the result of the formula in prediction mode as a reference to the selected column, the rendering layer uses the drawing effect of the multiple selection column to render the normal calculation result of the formula. Figure 5 As shown, linked field chaining supports on-the-fly referencing. The text columns in the image include: apple, pear, apple; the linked fields include: apple, pear, apple; the function calculation formula is [Link 1].[Multiple Selection]; data referencing can be selected as [Text], [Link 2], or [Multiple Selection]; the calculation logic is: read the collection of all cells under the selected column in the image, which can be used for formula calculation. Furthermore, as... Figure 6 As shown in the figure, this disclosure also provides a method for chaining related fields and combining them with other functions. The text columns in the figure include: apple, pear, apple; the related fields include: apple, pear, (apple, pear, apple); the function calculation formula is [Related1].FILTER(CurrentValue.[Text]=[Text]).[Multiple Selection]; the data reference can be selected as [Text], [Related2], or [Multiple Selection]; the calculation logic is: read the collection of all cells under the selected column in the figure, which can be used for formula calculation. The target parameter can be RecordCollectionVar.

[0061] In some embodiments, the associated field is a record of a cell in the database table, which is associated with one or more records in another database table for referencing records in the other database table.

[0062] In some embodiments, the related field is equivalent to the primary key of a data table, serving as a link between multiple tables. For example, consider the following two related tables: Student table (id, name) and Elective table (id, kecheng). If you want to retrieve all three pieces of information (id, name, kecheng) together, you would need to use id to connect the Student table and the Elective table, as one table cannot meet the user's query requirements.

[0063] In some embodiments, the first preset operator is a chained call operator. Chained calls refer to operations that continuously call class methods using "." or "->". For example, `[association field].[text]` contains a chained call operator.

[0064] In some embodiments, the first preset operator includes, but is not limited to, special operators such as chained calls.

[0065] In some embodiments, the second preset operator is an operator.

[0066] In some embodiments, operators connect operands in an expression, specifying the operations to be performed on the operands. Common operations include mathematical calculations, comparison operations, bitwise operations, and logical operations. Using operators allows for more flexible manipulation of data in a table. Common operator types include arithmetic operators, comparison operators, logical operators, and bitwise operators. For example, `[related field] + [related field]` includes an operator.

[0067] In some embodiments, when the function calculation type is a first type, the calculation logic includes a first associated field, a first preset operator, and a text field.

[0068] In some embodiments, when the function calculation type is the second type, the calculation logic includes a first associated field, a second preset operator, and a second associated field.

[0069] In some embodiments, the reference data for the function calculation includes a first associated field, a second associated field, and a text field. For example, the formula for the function calculation is [associated field 1] + [associated field 2], or [associated field] + [text], or [associated field 1].[associated field 2], or [associated field].[text].

[0070] This disclosure also provides a data processing apparatus, including:

[0071] The first processing module is used to convert the associated field into a target parameter in response to determining that the function calculation type of the database table is a first type, and to read the row reference information of the associated field record according to the target parameter;

[0072] The second processing module is used to convert the associated field into the target parameter in response to determining that the function calculation type of the database table is the second type, and to read the index column information of the associated field record according to the target parameter.

[0073] In some embodiments, the first processing module is specifically used for:

[0074] When a function calculation call to determine a database table invokes the first preset operator, the associated fields are converted into target parameters.

[0075] In some embodiments, the second processing module is specifically used for:

[0076] When a function calculation call to determine a database table invokes a second preset operator, the associated field is converted into the target parameter.

[0077] In some embodiments, the first processing module is further configured to:

[0078] Based on the calculation logic of the target parameter and the first preset operator, the row reference information of the associated field record is read.

[0079] In some embodiments, the second processing module is further configured to:

[0080] Based on the calculation logic of the target parameter and the second preset operator, the index column information of the associated field record is read.

[0081] In some embodiments, the target parameter includes the sub-table associated with the associated field and the records stored in the associated field.

[0082] In some embodiments, it further includes: a third processing module;

[0083] The third processing module is used to convert the target parameter into a reference to the table associated with the associated field in response to determining that the reference type of the associated field is the first type, wherein the associated table is the table where the selected column of the associated field is located;

[0084] Based on the calculation logic of the first preset operator, the reference of the associated table and the reference of the selected column of the associated field are compared. If the reference of the associated table intersects with the reference of the selected column of the associated field, the reference result of the selected column of the associated field is output.

[0085] In some embodiments, the third processing module is further specifically used for:

[0086] In response to determining that the reference type of the associated field is the second type and that the output reference result is the reference result of the selected column of the associated field, the value of the selected column of the associated field is read and the value of the selected column of the associated field is drawn using the rendering style of the selected column of the associated field.

[0087] In some embodiments, the associated field is a record of a cell in the database table, which is associated with one or more records in another database table for referencing records in the other database table.

[0088] In some embodiments, the first preset operator is a chained call operator.

[0089] In some embodiments, the second preset operator is an operator.

[0090] In some embodiments, when the function calculation type is a first type, the calculation logic includes a first associated field, a first preset operator, and a text field.

[0091] In some embodiments, when the function calculation type is the second type, the calculation logic includes a first associated field, a second preset operator, and a second associated field.

[0092] For embodiments of the apparatus, since they basically correspond to the method embodiments, relevant details can be found in the descriptions of the method embodiments. The apparatus embodiments described above are merely illustrative, and the modules described as separate modules may or may not be separate. Some or all of the modules can be selected to achieve the purpose of this embodiment according to actual needs. Those skilled in the art can understand and implement this without any creative effort.

[0093] The methods and apparatus of this disclosure have been described above based on embodiments and application examples. Furthermore, this disclosure also provides an electronic device and a computer-readable storage medium, which are described below.

[0094] The following is for reference. Figure 7The figure illustrates a structural schematic of an electronic device (e.g., a terminal device or server) 800 suitable for implementing embodiments of the present disclosure. The terminal device in the embodiments of the present disclosure may include, but is not limited to, mobile terminals such as mobile phones, laptops, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), in-vehicle terminals (e.g., in-vehicle navigation terminals), and fixed terminals such as digital TVs and desktop computers. The electronic device shown in the figure is merely an example and should not be construed as limiting the functionality and scope of the embodiments of the present disclosure.

[0095] Electronic device 800 may include a processing device (e.g., a central processing unit, a graphics processing unit, etc.) 801, which can perform various appropriate actions and processes according to a program stored in read-only memory (ROM) 802 or a program loaded from storage device 808 into random access memory (RAM) 803. RAM 803 also stores various programs and data required for the operation of electronic device 800. The processing device 801, ROM 802, and RAM 803 are interconnected via bus 804. Input / output (I / O) interface 805 is also connected to bus 804.

[0096] Typically, the following devices can be connected to I / O interface 805: input devices 806 including, for example, touchscreens, touchpads, keyboards, mice, cameras, microphones, accelerometers, gyroscopes, etc.; output devices 807 including, for example, liquid crystal displays (LCDs), speakers, vibrators, etc.; storage devices 808 including, for example, magnetic tapes, hard disks, etc.; and communication devices 809. Communication device 809 allows electronic device 800 to communicate wirelessly or wiredly with other devices to exchange data. Although an electronic device 800 with various devices is shown in the figure, it should be understood that it is not required to implement or possess all the devices shown. More or fewer devices may be implemented or possessed alternatively.

[0097] In particular, according to embodiments of this disclosure, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, embodiments of this disclosure include a computer program product comprising a computer program carried on a computer-readable medium, the computer program containing program code for performing the methods shown in the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network via a communication device 809, or installed from a storage device 808, or installed from a ROM 802. When the computer program is executed by a processing device 801, it performs the functions defined in the methods of embodiments of this disclosure.

[0098] It should be noted that the computer-readable medium described in this disclosure can be a computer-readable signal medium or a computer-readable storage medium, or any combination thereof. A computer-readable storage medium can be, for example,—but not limited to—an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of a computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination thereof. In this disclosure, a computer-readable storage medium can be any tangible medium containing or storing a program that can be used by or in connection with an instruction execution system, apparatus, or device. In this disclosure, a computer-readable signal medium can include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code. Such propagated data signals can take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. A computer-readable signal medium can be any computer-readable medium other than a computer-readable storage medium, which can send, propagate, or transmit a program for use by or in connection with an instruction execution system, apparatus, or device. The program code contained on the computer-readable medium can be transmitted using any suitable medium, including but not limited to: wires, optical fibers, RF (radio frequency), etc., or any suitable combination thereof.

[0099] In some implementations, clients and servers can communicate using any currently known or future-developed network protocol such as HTTP (Hypertext Transfer Protocol) and can interconnect with digital data communication (e.g., communication networks) of any form or medium. Examples of communication networks include local area networks (“LANs”), wide area networks (“WANs”), the Internet (e.g., the Internet of Things), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future-developed networks.

[0100] The aforementioned computer-readable medium may be included in the aforementioned electronic device; or it may exist independently and not assembled into the electronic device.

[0101] The aforementioned computer-readable medium carries one or more programs, which, when executed by the electronic device, cause the electronic device to perform the methods of the present disclosure.

[0102] Computer program code for performing the operations of this disclosure can be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, and C++, and conventional procedural programming languages ​​such as the "C" language or similar programming languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a standalone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving remote computers, the remote computer can 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 can be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0103] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of this disclosure. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those indicated in the drawings. For example, two consecutively indicated blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, can be implemented using a dedicated hardware-based system that performs the specified function or operation, or using a combination of dedicated hardware and computer instructions.

[0104] The units described in the embodiments of this disclosure can be implemented in software or hardware. The names of the units are not, in some cases, intended to limit the specific unit.

[0105] The functions described above in this document can be performed, at least in part, by one or more hardware logic components. For example, exemplary types of hardware logic components that can be used, without limitation, include: Field Programmable Gate Arrays (FPGAs), Application-Specific Integrated Circuits (ASICs), Application Standard Products (ASSPs), System-on-Chip (SoCs), Complex Programmable Logic Devices (CPLDs), and so on.

[0106] In the context of this disclosure, a machine-readable medium can be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, apparatus, or device. A machine-readable medium can be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium can be, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any suitable combination of the foregoing. More specific examples of machine-readable storage media include electrical connections based on one or more wires, portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing.

[0107] According to one or more embodiments of this disclosure, a data processing method is provided, comprising:

[0108] In response to determining that the function calculation type of the database table is a first type, the associated field is converted into a target parameter, and the row reference information of the associated field record is read according to the target parameter;

[0109] In response to determining that the function calculation type of the database table is the second type, the associated field is converted into the target parameter, and the index column information of the associated field record is read according to the target parameter.

[0110] According to one or more embodiments of this disclosure, a method is provided in which, in response to determining that the function calculation type of a database table is a first type, an associated field is converted into a target parameter, including:

[0111] When a function calculation call to determine a database table invokes the first preset operator, the associated fields are converted into target parameters.

[0112] According to one or more embodiments of this disclosure, a method is provided in which, in response to determining that the function calculation type of a database table is a second type, an associated field is converted into the target parameter, comprising:

[0113] When a function calculation call to determine a database table invokes a second preset operator, the associated field is converted into the target parameter.

[0114] According to one or more embodiments of this disclosure, a data processing method is provided, wherein reading row reference information of the associated field record according to the target parameter includes:

[0115] Based on the calculation logic of the target parameter and the first preset operator, the row reference information of the associated field record is read.

[0116] According to one or more embodiments of this disclosure, a data processing method is provided, wherein reading the index column information of the associated field record according to the target parameter includes:

[0117] Based on the calculation logic of the target parameter and the second preset operator, the index column information of the associated field record is read.

[0118] According to one or more embodiments of this disclosure, a data processing method is provided, wherein the target parameter includes a sub-table associated with the associated field and records stored in the associated field.

[0119] According to one or more embodiments of this disclosure, a data processing method is provided, further comprising:

[0120] In response to determining that the reference type of the associated field is a first type, the target parameter is converted into a reference to the table associated with the associated field, wherein the associated table is the table containing the selected column of the associated field;

[0121] Based on the calculation logic of the first preset operator, the reference of the associated table and the reference of the selected column of the associated field are compared. If the reference of the associated table intersects with the reference of the selected column of the associated field, the reference result of the selected column of the associated field is output.

[0122] According to one or more embodiments of this disclosure, a data processing method is provided, further comprising:

[0123] In response to determining that the reference type of the associated field is the second type and that the output reference result is the reference result of the selected column of the associated field, the value of the selected column of the associated field is read and the value of the selected column of the associated field is drawn using the rendering style of the selected column of the associated field.

[0124] According to one or more embodiments of this disclosure, a data processing method is provided, wherein the associated field is a record of a cell in a database table, and the cell is associated with one or more records in another database table for referencing records in the other database table.

[0125] According to one or more embodiments of this disclosure, a data processing method is provided, wherein the first preset operator is a chained call operator.

[0126] According to one or more embodiments of this disclosure, a data processing method is provided, wherein the second preset operator is an operator.

[0127] According to one or more embodiments of this disclosure, a data processing method is provided, wherein when the function calculation type is a first type, the calculation logic includes a first associated field, a first preset operator, and a text field.

[0128] According to one or more embodiments of this disclosure, a data processing method is provided, wherein when the function calculation type is a second type, the calculation logic includes a first associated field, a second preset operator, and a second associated field.

[0129] According to one or more embodiments of this disclosure, a data processing apparatus is provided, comprising:

[0130] The first processing module is used to convert the associated field into a target parameter in response to determining that the function calculation type of the database table is a first type, and to read the row reference information of the associated field record according to the target parameter;

[0131] The second processing module is used to convert the associated field into the target parameter in response to determining that the function calculation type of the database table is the second type, and to read the index column information of the associated field record according to the target parameter.

[0132] According to one or more embodiments of the present disclosure, an electronic device is provided, including: at least one memory and at least one processor;

[0133] The at least one memory is used to store program code, and the at least one processor is used to call the program code stored in the at least one memory to execute the method described in any one of the above.

[0134] According to one or more embodiments of the present disclosure, a computer-readable storage medium is provided for storing program code that, when executed by a processor, causes the processor to perform the methods described above.

[0135] The above description is merely a preferred embodiment of this disclosure and an explanation of the technical principles employed. Those skilled in the art should understand that the scope of this disclosure is not limited to technical solutions formed by specific combinations of the above-described technical features, but should also cover other technical solutions formed by arbitrary combinations of the above-described technical features or their equivalents without departing from the above-described concept. For example, technical solutions formed by substituting the above features with (but not limited to) technical features disclosed in this disclosure that have similar functions.

[0136] Furthermore, while the operations are described in a specific order, this should not be construed as requiring these operations to be performed in the specific order shown or in sequential order. In certain environments, multitasking and parallel processing may be advantageous. Similarly, while several specific implementation details are included in the above discussion, these should not be construed as limiting the scope of this disclosure. Certain features described in the context of individual embodiments may also be implemented in combination in a single embodiment. Conversely, various features described in the context of a single embodiment may also be implemented individually or in any suitable sub-combination in multiple embodiments.

[0137] Although the subject matter has been described using language specific to structural features and / or methodological logic, it should be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or actions described above. Rather, the specific features and actions described above are merely illustrative examples of implementing the claims.

Claims

1. A data processing method, characterized by, The method comprises the following steps: In response to determining that the function calculation type of the database table is a first type, converting the associated field into a target parameter, and reading the row reference information of the associated field record according to the target parameter; In response to determining that the function calculation type of the database table is a second type, converting the associated field into the target parameter, and reading the index column information of the associated field record according to the target parameter; The first type is that the function calculation of the database table calls the function calculation of the chain call operator; and the second type is that the function calculation of the database table calls the function calculation of the operator.

2. The method of claim 1, wherein, The step of converting the associated field into the target parameter in response to determining that the function calculation type of the database table is the first type comprises the following steps: In response to determining that the function calculation of the database table calls the first preset operator, converting the associated field into the target parameter.

3. The method of claim 1, wherein, The step of converting the associated field into the target parameter in response to determining that the function calculation type of the database table is the second type comprises the following steps: In response to determining that the function calculation of the database table calls the second preset operator, converting the associated field into the target parameter.

4. The method of claim 2, wherein, The step of reading the row reference information of the associated field record according to the target parameter comprises the following steps: According to the calculation logic of the target parameter and the first preset operator, the row reference information of the associated field record is read.

5. The method of claim 3, wherein, The step of reading the index column information of the associated field record according to the target parameter comprises the following steps: According to the calculation logic of the target parameter and the second preset operator, the index column information of the associated field record is read.

6. The method of claim 1, wherein, The target parameter comprises a sub-table associated with the associated field and a record stored in the associated field.

7. The method of claim 4, wherein, The method further comprises the following steps: In response to determining that the reference type of the associated field is a first type, converting the target parameter into a reference of a table associated with the associated field, the table being a table in which a selected column of the associated field is located; According to the calculation logic of the first preset operator, the reference of the associated table and the reference of the selected column of the associated field are compared, and if the reference of the associated table intersects with the reference of the selected column of the associated field, the reference result of the selected column of the associated field is output.

8. The method of claim 7, wherein, The method further comprises the following steps: In response to determining that the reference type of the associated field is a second type and the output reference result is the reference result of the selected column of the associated field, reading the value of the selected column of the associated field, and drawing the value of the selected column of the associated field by using the rendering style of the selected column of the associated field.

9. The method of claim 1, wherein, The associated field is a record of a cell in the database table, the cell being associated with one or more records in another database table, and being used for referencing the records in the other database table.

10. The method of claim 2, wherein, The first preset operator is a chain call operator.

11. The method of claim 3, wherein, The second preset operator is an operator.

12. The method of claim 2, wherein, When the function calculation type is the first type, the calculation logic comprises a first associated field, a first preset operator and a text field.

13. The method of claim 3, wherein, When the function calculation type is the second type, the calculation logic comprises a first associated field, a second preset operator and a second associated field.

14. A data processing apparatus, characterized by The method comprises the following steps: The first processing module is configured to, in response to determining that the function calculation type of the database table is a first type, convert the associated field into a target parameter, and read row reference information of the associated field record according to the target parameter. The second processing module is configured to, in response to determining that the function calculation type of the database table is a second type, convert the associated field into the target parameter, and read index column information of the associated field record according to the target parameter. The first type is a function calculation type in which a function calculation of the database table calls a chain call operator; and the second type is a function calculation type in which a function calculation of the database table calls an operation operator.

15. An electronic device, comprising: at least one memory and at least one processor; wherein the at least one memory is configured to store program code, and the at least one processor is configured to invoke the program code stored in the at least one memory to execute the method in any one of claims 1 to 13.

16. A computer readable storage medium configured to store program code, which when executed by a computer device, causes the computer device to execute the method in any one of claims 1 to 13.

Images