Data table creation methods, target data query methods, devices and equipment

Abstract

This disclosure provides a method for creating a data table, a method for querying target data, an apparatus, and a device, which can be applied in the field of big data technology. The method includes: in response to detecting a configuration operation performed on a predetermined page, obtaining configuration data for the predetermined page; creating table structure information of a data table to be created based on the configuration data, the table structure information including multiple fields, each field including a field name; obtaining at least one piece of business data, each piece of business data including a data identifier and a data value corresponding to the data identifier; and for each piece of business data, if it is determined that the data identifier in the business data matches a first field name among the multiple fields, creating table content information of the data table to be created based on the data value in the business data and the field corresponding to the first field name.

Description

Technical Field

[0001] This disclosure relates to the field of big data, and in particular to a data table creation method, a target data query method, a data table creation device, a target data query device, an electronic device, a computer-readable storage medium, and a computer program product. Background Technology

[0002] When a user completes a transaction, multiple business systems are involved, and the data between these systems is isolated from each other. When it is necessary to query the data generated in each system during the user's transaction, it is necessary to log in to each system separately and query under different menus, which is a rather cumbersome process.

[0003] Therefore, it is necessary to integrate business data from different systems into a single data system so that users can use this system to query all data related to a single business transaction. Summary of the Invention

[0004] In view of the above problems, this disclosure provides a data table creation method, a target data query method, a data table creation apparatus, a target data query apparatus, an electronic device, a computer-readable storage medium, and a computer program product.

[0005] According to one aspect of this disclosure, a method for creating a data table is provided, comprising: in response to detecting a configuration operation performed on a predetermined page, acquiring configuration data for the predetermined page; creating table structure information of a data table to be created based on the configuration data, the table structure information including multiple fields, each field including a field name; acquiring at least one piece of business data, each piece of business data including a data identifier and a data value corresponding to the data identifier; and for each piece of business data, if it is determined that the data identifier in the business data matches a first field name among the multiple fields, creating table content information of the data table to be created based on the data value in the business data and the field corresponding to the first field name.

[0006] According to another embodiment of this disclosure, the configuration data includes a business category identifier, a configuration field name, and a configuration attribute corresponding to the configuration field name; the step of creating table structure information of the data table to be created based on the configuration data includes: in response to detecting that the table name in the already created table structure information is inconsistent with the business category identifier, creating a new first table structure information; wherein, the table name in the first table structure information is consistent with the business category identifier, the field name in the first table structure information is consistent with the configuration field name, and the field attribute in the first table structure information is consistent with the configuration attribute.

[0007] According to another embodiment of this disclosure, the configuration data includes a business category identifier, a configuration field name, and a configuration attribute corresponding to the configuration field name; the step of creating table structure information of the data table to be created based on the configuration data includes: in response to detecting that the table name of the second table structure information is consistent with the business category identifier, determining whether the second table structure information includes a second field name consistent with the configuration field name; wherein, the second table structure information is one of the table structure information that has been created; and if it is determined that the second table structure information does not include the second field name, adding a target field to the second table structure information; wherein, the field name of the target field is consistent with the configuration field name, and the field attribute of the target field is consistent with the configuration attribute.

[0008] According to another embodiment of this disclosure, the step of creating the table structure information of the data table to be created based on the configuration data further includes: when it is determined that the second table structure information includes the second field name, replacing the field attribute corresponding to the second field name with the configuration attribute.

[0009] According to another embodiment of this disclosure, the number of created table structure information is at least two; when it is determined that the data identifier in the business data matches the first field name among the plurality of fields, creating the table content information of the data table to be created based on the data value in the business data and the field corresponding to the first field name includes: determining the table structure information whose table name matches the business category identifier among the at least two created table structure information as the target table structure information; and when it is determined that the data identifier in the business data matches the first field name in the target table structure information, creating the table content information corresponding to the target table structure information based on the data value in the business data and the field corresponding to the first field name.

[0010] According to another embodiment of this disclosure, the configuration data includes a set of business system identifiers, and the business data includes the identifiers of the business systems; the method further includes: in response to detecting that the set of business system identifiers includes the identifiers of the business systems, triggering an operation to create table content information of a data table.

[0011] Another aspect of this disclosure provides a target data query method, comprising: in response to receiving a query request, querying target data in a data table according to the query request; and outputting the target data; wherein the data table is created using the data table creation method described above.

[0012] Another aspect of this disclosure provides a data table creation apparatus, including a first acquisition module, a first creation module, a second acquisition module, and a second creation module. The first acquisition module is configured to acquire configuration data for the predetermined page in response to detecting a configuration operation performed on the predetermined page; the first creation module is configured to create table structure information of a data table to be created based on the configuration data, the table structure information including multiple fields, each field including a field name; the second acquisition module is configured to acquire at least one piece of business data, each piece of business data including a data identifier and a data value corresponding to the data identifier; the second creation module is configured to, for each piece of business data, if it is determined that the data identifier in the business data matches a first field name among the multiple fields, create table content information of the data table to be created based on the data value in the business data and the field corresponding to the first field name.

[0013] Another aspect of this disclosure provides a target data query apparatus, including a query module and an output module. The query module is used to query target data in a data table in response to receiving a query request; the output module is used to output the target data; wherein the data table is created using the data table creation method described above.

[0014] Another aspect of this disclosure provides an electronic device, including: one or more processors; and a memory for storing one or more programs, wherein when the one or more programs are executed by the one or more processors, the one or more processors perform the methods described above.

[0015] Another aspect of this disclosure provides a computer-readable storage medium having executable instructions stored thereon, which, when executed by a processor, cause the processor to perform the methods described above.

[0016] Another aspect of this disclosure provides a computer program product, including a computer program that, when executed by a processor, implements the above-described method.

[0017] According to the data table creation method, apparatus, device, medium, and program products provided in this disclosure, when the data issued by the business system changes—for example, if the upstream business system adds some fields or modifies the type and length of some fields—the object can modify the table structure information online according to actual needs to modify the data table structure. Compared with the prior art, the technical solution provided by the embodiments of this disclosure supports modification of the issued data by various business systems without modifying the data processing program. It allows for online addition and modification of the table structure information, and the added and modified table structure information takes effect in real time, thus improving the flexibility and convenience of accessing data from the business system. Attached Figure Description

[0018] The foregoing contents, as well as other objects, features, and advantages of this disclosure, will become clearer from the following description of embodiments with reference to the accompanying drawings, in which:

[0019] Figure 1 This illustration schematically depicts an application scenario of a data table creation method and / or a target data query method according to embodiments of the present disclosure.

[0020] Figure 2 A flowchart illustrating a data table creation method according to an embodiment of the present disclosure is shown schematically.

[0021] Figure 3 A flowchart illustrating the creation of table structure information according to an embodiment of the present disclosure is shown schematically;

[0022] Figure 4 A schematic diagram illustrating configuration data according to an embodiment of the present disclosure is shown.

[0023] Figure 5 A schematic diagram illustrating configuration data according to another embodiment of this disclosure is shown.

[0024] Figure 6 A flowchart illustrating a target data query method according to an embodiment of the present disclosure is shown schematically;

[0025] Figure 7 This schematic diagram illustrates a structural block diagram of a data table creation apparatus according to an embodiment of the present disclosure;

[0026] Figure 8 A schematic diagram illustrating the structure of a target data query apparatus according to an embodiment of the present disclosure is shown; and

[0027] Figure 9 A block diagram schematically illustrates an electronic device suitable for implementing a data table creation method and / or a target data query method according to embodiments of the present disclosure. Detailed Implementation

[0028] The embodiments of the present disclosure will now be described with reference to the accompanying drawings. However, it should be understood that these descriptions are exemplary only and are not intended to limit the scope of the disclosure. In the following detailed description, numerous specific details are set forth to provide a thorough understanding of the embodiments of the present disclosure for ease of explanation. However, it will be apparent that one or more embodiments may be practiced without these specific details. Furthermore, descriptions of well-known structures and techniques are omitted in the following description to avoid unnecessarily obscuring the concepts of the present disclosure.

[0029] The terminology used herein is for the purpose of describing particular embodiments only and is not intended to limit this disclosure. The terms “comprising,” “including,” etc., as used herein indicate the presence of the stated features, steps, operations, and / or components, but do not exclude the presence or addition of one or more other features, steps, operations, or components.

[0030] All terms used herein (including technical and scientific terms) have the meanings commonly understood by those skilled in the art, unless otherwise defined. It should be noted that the terms used herein are to be interpreted in a manner consistent with the context of this specification, and not in an idealized or overly rigid way.

[0031] When using expressions such as "at least one of A, B, and C", they should generally be interpreted in accordance with the meaning that is commonly understood by a person skilled in the art (e.g., "a system having at least one of A, B, and C" should include, but is not limited to, a system having A alone, a system having B alone, a system having C alone, a system having A and B, a system having A and C, a system having B and C, and / or a system having A, B, and C, etc.).

[0032] In the technical solution disclosed herein, the acquisition, collection, storage, use, processing, transmission, provision, disclosure, and application of data all comply with the provisions of relevant laws and regulations, necessary confidentiality measures have been taken, and they do not violate public order and good morals.

[0033] Business data refers to data generated by various business systems during the transaction process that has business applications.

[0034] Access data means importing data generated by multiple business systems into a centralized system.

[0035] In some technical solutions, data access can be achieved by pre-defining table structures. For example, the table structure can be pre-defined in the data system, including information such as the fields in the table and the format of each field. The downstream data system also pre-develops corresponding data processing programs. When accessing data, the upstream business system sends data according to the agreed field order and format, and the downstream data system imports the data using its data processing program.

[0036] As can be seen, the above technical solution requires pre-defining the table structure and developing a separate data processing program. When the data issued by the upstream business system changes—for example, if the upstream business system adds some fields, or modifies the type or length of some fields—the downstream data system needs to modify its data processing program accordingly. Therefore, the flexibility of data access is poor.

[0037] Figure 1The illustration shows an application scenario of the data table creation method and / or target data query method according to embodiments of the present disclosure.

[0038] like Figure 1 As shown, application scenario 100 according to this embodiment may include terminal devices 101, 102, and 103, a network 104, and a server 105. Network 104 serves as a medium for providing a communication link between terminal devices 101, 102, and 103 and server 105. Network 104 may include various connection types, such as wired or wireless communication links, or fiber optic cables, etc.

[0039] Users can use terminal devices 101, 102, and 103 to interact with server 105 via network 104 to receive or send messages, etc. Various communication client applications can be installed on terminal devices 101, 102, and 103, such as shopping applications, web browser applications, search applications, instant messaging tools, email clients, social media platform software, etc. (for example only).

[0040] Terminal devices 101, 102, and 103 can be various electronic devices with displays and web browsing capabilities, including but not limited to smartphones, tablets, laptops, and desktop computers.

[0041] Server 105 can be a server that provides various services, such as a backend management server that supports websites browsed by users using terminal devices 101, 102, and 103 (for example only). The backend management server can analyze and process data such as received user requests, and feed back the processing results (such as data tables generated based on configuration operations and business data, or target data determined based on query requests) to the terminal devices.

[0042] It should be noted that the data table creation method and / or target data query method provided in the embodiments of this disclosure can generally be executed by server 105. Correspondingly, the data table creation device and / or target data query device provided in the embodiments of this disclosure can generally be located in server 105. The data table creation method and / or target data query method provided in the embodiments of this disclosure can also be executed by a server or server cluster that is different from server 105 and capable of communicating with terminal devices 101, 102, 103 and / or server 105. Correspondingly, the data table creation device and / or target data query device provided in the embodiments of this disclosure can also be located in a server or server cluster that is different from server 105 and capable of communicating with terminal devices 101, 102, 103 and / or server 105.

[0043] It should be understood that Figure 1The number of terminal devices, networks, and servers shown is merely illustrative. Depending on implementation needs, any number of terminal devices, networks, and servers can be included.

[0044] The following will be based on Figure 1 The described scene, through Figures 2-5 The data table creation method of the disclosed embodiments will be described in detail.

[0045] Figure 2 A flowchart illustrating a data table creation method according to an embodiment of the present disclosure is shown schematically.

[0046] like Figure 2 As shown, the data table creation method 200 of this embodiment includes operations S210 to S240.

[0047] In operation S210, in response to detecting a configuration operation performed on a predetermined page, configuration data for the predetermined page is obtained.

[0048] For example, the reservation page can be a human-computer interaction interface. The configuration operation can be an object clicking the save button on the reservation page, and the object can be a user.

[0049] For example, configuration data can include the number of fields in the table, the field name of each field, and the field attributes of each field. Field attributes can include data type, field length, etc.

[0050] In practical applications, an object can determine its configuration data based on the data sent by the upstream business system. For example, if the data sent by the business system includes a transaction number, account number, and amount, the configuration data can include three field names: "Transaction Number," "Account Number," and "Amount." In addition, the data types corresponding to the above three data items can be configured as strings.

[0051] In operation S220, based on the configuration data, the table structure information of the data table to be created is generated. The table structure information includes multiple fields, and each field includes a field name.

[0052] For example, the number of fields in the data table, the field name of each field, and the field attributes of each field can be determined based on the data in the configuration data.

[0053] For example, if the data issued by the business system includes a transaction number, account number, and amount, and the configuration data can include three field names: "Transaction Number," "Account Number," and "Amount," with each field being a string, then a table creation statement can be generated based on this configuration data. This statement will automatically create three fields named "Transaction Number," "Account Number," and "Amount," with each field being a string. This will provide the table structure information.

[0054] In operation S230, at least one piece of business data is acquired, each piece of business data including a data identifier and a data value corresponding to the data identifier.

[0055] For example, upstream business systems can send the data that needs to be accessed to the device used to execute the data table creation method.

[0056] For example, business data can be in JSON format, which is simple, universal, and flexible. For instance, business data could include {Transaction Number: 001, Amount: 100}, where "Transaction Number" and "Amount" are data identifiers, "001" is the data value corresponding to the "Transaction Number," and "100" is the data value corresponding to the "Amount."

[0057] In operation S240, for each piece of business data, if it is determined that the data identifier in the business data matches the name of the first field among multiple fields, the table content information of the data table to be created is created based on the data value in the business data and the field corresponding to the name of the first field.

[0058] For example, the data identifier "serial number" can be matched with the three field names mentioned above (the three field names refer to "serial number", "account number" and "amount") respectively, and the data identifier "amount" can also be matched with the three field names mentioned above respectively.

[0059] For example, if the data identifier "serial number" can be determined to match the field name "serial number" after processing, then the table content can be created based on the data value "001" and the field A corresponding to the field name "serial number". For example, "001" can be used as the field content of field A and written into field A.

[0060] For example, if the data identifier "Amount" can be determined to match the field name "Amount" after processing, the table content can be created based on the data value "100" and the field B corresponding to the field name "Amount". For example, "100" can be used as the field content of field B and written into field B.

[0061] Understandably, in order to easily distinguish it from other field names, the matching field name is designated as the first field name, which can be the field name of any of the multiple fields.

[0062] As can be seen, a data table includes table structure information and table content information. The table structure information is determined based on the configuration data entered by the object on the predefined page, while the table content data is determined by the data received from the business system. The process of creating table content data can include writing field content into the structure. After creating the table structure information and table content information, a data table containing the data can be obtained.

[0063] According to the technical solution provided in this disclosure, when the data issued by the business system changes—for example, the upstream business system adds some fields, or the upstream business system modifies the type and length of some fields—the object can modify the table structure information online according to actual needs to modify the structure of the data table. Compared with the prior art, the technical solution provided in this disclosure supports modification of the issued data by various business systems without modifying the data processing program. It allows for online addition and modification of the table structure information, and the added and modified table structure information takes effect in real time, thus improving the flexibility and convenience of accessing data from the business system.

[0064] like Figure 3 As shown, the method 320 for creating the table structure information of the data table to be created based on the configuration data may include operations S321 to S325.

[0065] In operation S321, determine whether the table name in the created table structure information matches the business category identifier in the configuration data. If they do not match, proceed to operation S322; if they match, proceed to operation S323.

[0066] For example, configuration data includes a business category identifier, configuration field names, and corresponding configuration attributes. Business categories could include, for example, personal loans, corporate loans, and credit card repayments. Configuration field names represent the names of the fields that need to be included in the data table. Configuration attributes can represent the properties of the field content, such as field type and field length.

[0067] For example, if the table name in the created table structure information is inconsistent with the business category identifier, it means that no corresponding data table has been created for this business category identifier yet, and this configuration operation is to add a new data table.

[0068] For example, if the table name in the created table structure information matches the business category identifier, it means that a corresponding data table has been created for that business category identifier. This configuration operation is to modify the created data table. The modifications may include adding fields to the data table or modifying field attributes.

[0069] In operation S322, create the first table structure information.

[0070] It is understandable that this operation involves adding a new data table. To easily distinguish it from other data tables, the table structure information of this newly added data table will be referred to as the first table structure information.

[0071] For example, during the creation process, the business category identifier is created as the table name in the first table structure information, the configuration field name is created as the field name in the first table structure information, and the configuration attribute is created as the field attribute in the first table structure information. It can be seen that after the above creation operations, the table name in the first table structure information is consistent with the business category identifier, the field names in the first table structure information are consistent with the configuration field names, and the field attributes in the first table structure information are consistent with the configuration attributes.

[0072] In operation S323, determine whether the second table structure information includes a second field name that matches the configured field name; wherein, the second table structure information is one of the table structure information that has been created. If it does not include it, then execute operation S324; if it does include it, then execute operation S325.

[0073] It is understandable that the second field name can be the name of any field in the second table structure information. In order to distinguish it from other field names, the field name in the second table structure information that is consistent with the configuration field name is called the second field name.

[0074] For example, if the second table structure information does not include the second field name, it can mean that a field corresponding to the second field name has not yet been created, and this configuration operation is to add a new field.

[0075] For example, the second table structure information, including the second field name, can indicate that a field corresponding to this second field name has been created, and this configuration operation is to modify the created field. The modification content may include, for example, modifying the field attributes.

[0076] In operation S324, add the target field to the second table structure information.

[0077] As is understandable, this operation modifies an existing data table, specifically by adding a new field. To distinguish it from other fields, this newly added field will be referred to as the target field.

[0078] For example, during the creation process, the configuration field name can be created as the target field's field name, and the configuration attribute can be created as the target field's field attribute. It can be seen that after the above creation operations, the target field's field name is consistent with the configuration field name, and the target field's field attribute is consistent with the configuration attribute.

[0079] In operation S325, the field attribute corresponding to the second field name is replaced using the configuration attribute.

[0080] It is understandable that this operation modifies an existing data table, and the modifications are made to the field attributes of existing fields, such as changing the field length and field type.

[0081] For example, the original length of the second field name was 100, and the modified length of the second field is 200.

[0082] According to another embodiment of this disclosure, the number of created table structure information is at least two. Accordingly, the operation of creating table content information of the data table based on the data value in the business data and the field where the first field name is located, when it is determined that the data identifier in the business data matches the first field name among multiple fields, can include the following operations: First, determine the table structure information whose table name matches the business category identifier from the at least two created table structure information as the target table structure information. Then, when it is determined that the data identifier in the business data matches the first field name in the target table structure information, create table content information corresponding to the target table structure information based on the data value in the business data and the field corresponding to the first field name.

[0083] For example, when at least two table structures have been created, different table structures may contain field names with the same name, such as both table structures including a "Quantity" field. To avoid writing data values ​​to the wrong table, you can first determine the target table based on the table name and business category identifier, and then match the data identifier with the field names in the target table structure information, thereby achieving accurate data writing.

[0084] According to another embodiment of this disclosure, in the process of determining the target table structure information, the target business system can be determined from multiple business systems first, and the data table structure information corresponding to the target business system can be determined as candidate table structure information, and then the target table structure information can be determined from the candidate table structure information.

[0085] For example, data from multiple business systems can be accessed, and each business system can include multiple business categories, with each business category corresponding to a data table. In this case, the business category identifier can reflect the business system to which that business category belongs. For example, if the identifier of the first business system is S1, and the first business system includes 20 business categories, then "the identifier of the business system and the business category number" can be used as the identifier of the business category. For example, the identifier of the fifth business category in the first business system can be "S1_05".

[0086] For example, business data may also include a source identifier that indicates the business system and business category of the business data. For example, a source identifier of “S1_01” may indicate that the business data comes from the first business category in the first business system.

[0087] For example, the first business system includes 20 business categories, and the second business system includes 30 business categories, totaling 50 data tables. When the source identifier in the business data is "S1_05", the table structure information corresponding to the 20 data tables in the first business system can be identified as candidate table structure information. Then, the table structure information corresponding to the fifth business category among the 20 candidate table structure information can be identified as the target table structure information.

[0088] This method of determining the target table structure information eliminates the need to derive it from the structure information of 20 data tables corresponding to the second business system, thereby reducing the amount of data processing and improving data processing efficiency.

[0089] According to another embodiment of this disclosure, the configuration data includes a set of business system identifiers, and the business data includes the identifiers of the business systems. Accordingly, the above method further includes the following operation: determining whether the set of business system identifiers includes the identifiers of the business systems; if so, triggering the operation of creating table content information of the data table; if not, then it is not necessary to trigger the operation of creating table content information of the data table.

[0090] For example, during configuration, the correspondence between data table structure information and business systems and business categories can be established in advance. Therefore, after creating a data table, the business system corresponding to the created data table can be determined, and the identifiers of these business systems constitute a set of business system identifiers.

[0091] For example, the fact that the business system identifier set does not include the business system identifier can indicate that: no data table corresponding to the business system has been created yet, so the acquired business data cannot be created as data table content information, and there is no need to match the data identifier of the business data with the field names of the already created data table, thereby saving processes and improving processing efficiency.

[0092] The following describes the data table creation method provided in this disclosure in conjunction with specific embodiments.

[0093] First, users can use the reservation page to define the business system number and name. Only after configuring the business system on the reservation page can access to the data of that business system be allowed.

[0094] like Figure 4 As shown, Figure 4 The illustration shows a schematic diagram of configuration data according to an embodiment of the present disclosure. Users can use a predefined page to define configuration data for the accessed business system. The configuration data may include a business category identifier, configuration field names, and configuration attributes corresponding to the configuration field names. The configuration attributes may include field type and field length, and may also include setting whether the field name is a query field and whether it is anonymized.

[0095] Then, the user clicks the save button on the reservation page, automatically generating the SQL statement to create the table. This statement is then used to create the corresponding table structure. Table indexes can also be defined based on whether a field is queried. For example, based on... Figure 4 The configuration data shown allows the creation of a data table named S1_01. This table includes four fields: The first field is named ID_1, with a varchar2 type and a maximum character length of 50. ID_1 is the index of this data table. The second field is named ID_2, with a varchar2 type and a maximum character length of 100. ID_2 is also the index of this data table. The third field is named ID_3, with a number type and is also the index of this data table. The fourth field is named ID_4, with a varchar2 type and a maximum character length of 50. ID_4 is not an index of this data table.

[0096] In some embodiments, the table creation statement can specifically be an SQL statement, for example, the generated SQL statement is as follows:

[0097] Create table S1_01 (

[0099] ID_1 varchar2(50),

[0100] ID_2 varchar2(100),

[0101] ID_3 number,

[0102] ID_4 varchar2(50) );

[0104] Create index S1_01_idx_01 on S1_01(ID_1);

[0105] Create index S1_01_idx_02 on S1_01(ID_2);

[0106] Create index S1_01idx_03 on S1_01(ID_3);

[0107] like Figure 5 As shown, Figure 5 A schematic diagram illustrating configuration data according to another embodiment of this disclosure is shown. Users can also add or modify fields via a predefined page. For example, adding a "Name" field and changing the field length of the "Second Name" field to 200.

[0108] Next, after the user adds or modifies a field, clicking the "Save" button on the reservation page will automatically generate the statement to modify the table, for example, according to... Figure 5 The configuration data shown allows you to modify the maximum character length of the second field in the data table "S1_01" to 200. You can also add a new field to the data table "S1_01" with the field name "Name", field type varchar2, and maximum character length of 200.

[0109] In some embodiments, the table modification statement can specifically be an SQL statement, for example, the table modification statement is as follows:

[0110] Alter table S1_01 add NAME varchar2(200);

[0111] Alter table S1_01 modify ID_2 varchar2(200);

[0112] In addition, users can define viewing permissions for accessed data, such as defining that users with predefined roles are allowed to query the data of the newly added business categories mentioned above.

[0113] During the data access process, business systems can access business data in JSON format via HTTP interfaces, API JAR packages, SDKs (Software Development Kits), and end-of-day files.

[0114] Taking access to personal loan data as an example, JSON format data can include identifier data, such as “Type”: “S1_01”, where the data name is “Type” and the data value is “S1_01”. JSON format data can also include business data, such as “ID_1”: “123456”, where the data identifier is “ID_1” and the data value is “123456”.

[0115] In some embodiments, specific examples of JSON format data are as follows:

[0116] {"Type": "S1_01",

[0117] "ID_1": "123456"

[0118] "ID_2": "987654"

[0119] "ID_3": "100"

[0120] "ID_4": "147852"

[0121] }

[0122] The target data table structure information can be determined from multiple data tables based on the source identifier "Type" in the business data. Then, the data identifier in the JSON data is matched with the configuration field names configured on the predefined page. If a match is found, the data value corresponding to that data identifier is written to the data table as the field content corresponding to that field name. If a data identifier does not match any field names in the data table, it means that the data table does not need to access the data value corresponding to that data identifier.

[0123] Furthermore, when a new field is added to the business system, the data identifier and data value can be directly added to the JSON data issued by the business system. For example, based on the existing JSON data, the business system can issue a new JSON data containing a new business data, such as "NAME": "Zhang San", where the data identifier is "NAME" and the data value is "Zhang San".

[0124] In some embodiments, a specific example of the updated JSON format data from the business system is as follows:

[0125] {"Type": "S1_01",

[0126] "ID_1": "123456"

[0127] "ID_2": "987654"

[0128] "ID_3": "100"

[0129] "ID_4": "147852"

[0130] "NAME": "Zhang San"

[0131] }

[0132] For example, when both the personal loan information table and the JSON data contain "NAME", the value of the "NAME" field is stored in the database to save the data.

[0133] After creating the data table using the above method, the accessed data can be queried. For example, based on the logged-in user's job title, the role of that role can be determined, and the query permissions for that role can be identified. Query permissions indicate which business systems the role can query data from. The query interface can display the identifiers of the systems the user has permission to query, as well as predefined query fields. When the user enters query conditions and clicks "query," the target query data can be displayed. Furthermore, when displaying the target query data, depending on whether a pre-set anonymization attribute is used, all field values ​​can be displayed, or only anonymized field values ​​can be displayed.

[0134] Figure 6 A flowchart illustrating a target data query method according to an embodiment of the present disclosure is shown schematically.

[0135] like Figure 6 As shown, the target data query method 600 of this embodiment includes operations S610 to S620.

[0136] In operation S610, in response to receiving a query request, the target data is retrieved from the data table according to the query request.

[0137] For example, the data table was created using the data table creation method described above.

[0138] When operating the S620, output the target data.

[0139] According to the technical solution provided in the embodiments of this disclosure, after accessing the business data of multiple upstream business systems, a database storing data tables can be used to query all data related to the same business.

[0140] Based on the above-described data table creation method, this disclosure also provides a data table creation apparatus. The following will be combined with... Figure 7 The device is described in detail.

[0141] Figure 7 A schematic block diagram of a data table creation apparatus according to an embodiment of the present disclosure is shown.

[0142] like Figure 7 As shown, the data table creation device 700 of this embodiment includes a first acquisition module 710, a first creation module 720, a second acquisition module 730, and a second creation module 740.

[0143] The first acquisition module 710 is used to acquire configuration data for the predetermined page in response to detecting a configuration operation performed on the predetermined page. In one embodiment, the first acquisition module 710 may be used to perform the operation S210 described above, which will not be repeated here.

[0144] The first creation module 720 is used to create table structure information of the data table to be created based on the configuration data. The table structure information includes multiple fields, each of which includes a field name. In one embodiment, the first creation module 720 can be used to perform the operation S220 described above, which will not be repeated here.

[0145] The second acquisition module 730 is used to acquire at least one piece of business data, each piece of business data including a data identifier and a data value corresponding to the data identifier. In one embodiment, the second acquisition module 730 can be used to perform the operation S230 described above, which will not be repeated here.

[0146] The second creation module 740 is used to, for each piece of business data, create table content information of the data table to be created based on the data value in the business data and the field corresponding to the first field name, provided that the data identifier in the business data matches the first field name among multiple fields. In one embodiment, the second creation module 740 can be used to perform the operation S240 described above, which will not be repeated here.

[0147] According to another embodiment of this disclosure, the configuration data includes a business category identifier, a configuration field name, and a configuration attribute corresponding to the configuration field name; the first creation module includes a creation submodule, used to create a new first table structure information in response to detecting that the table name in the already created table structure information is inconsistent with the business category identifier; wherein, the table name in the first table structure information is consistent with the business category identifier, the field name in the first table structure information is consistent with the configuration field name, and the field attribute in the first table structure information is consistent with the configuration attribute.

[0148] According to another embodiment of this disclosure, the configuration data includes a business category identifier, a configuration field name, and configuration attributes corresponding to the configuration field name. The first creation module includes a first determination submodule and an addition submodule. The first determination submodule is used to determine whether the second table structure information includes a second field name that matches the configuration field name in response to detecting that the table name of the second table structure information matches the business category identifier; wherein, the second table structure information is one of the already created table structure information. The addition submodule is used to add a target field to the second table structure information if it is determined that the second table structure information does not include the second field name. The target field's field name matches the configuration field name, and the target field's field attributes match the configuration attributes.

[0149] According to another embodiment of this disclosure, the first creation module further includes a replacement submodule, which is used to replace the field attribute corresponding to the second field name with a configuration attribute when it is determined that the second table structure information includes the second field name.

[0150] According to another embodiment of this disclosure, the number of created table structure information is at least two. The second creation module includes a second determining submodule and a creation submodule. The second determining submodule is used to determine the table structure information whose table name matches the business category identifier from the at least two created table structure information as the target table structure information. The creation submodule is used to create table content information corresponding to the target table structure information based on the data value in the business data and the field corresponding to the first field name, when it is determined that the data identifier in the business data matches the first field name in the target table structure information.

[0151] According to another embodiment of this disclosure, the configuration data includes a set of business system identifiers, and the business data includes identifiers of the business systems. The apparatus further includes a triggering module, configured to trigger an operation to create table content information of a data table in response to detecting that the set of business system identifiers includes identifiers of the business systems.

[0152] Based on the above-described target data query method, this disclosure also provides a target data query device. The following will be combined with... Figure 8 The device is described in detail.

[0153] Figure 8 A schematic block diagram of a target data query apparatus according to an embodiment of the present disclosure is shown.

[0154] like Figure 8 As shown, the target data query device 800 of this embodiment includes a query module 810 and an output module 820.

[0155] The query module 810 is used to respond to a received query request and query the target data in the data table according to the query request; wherein the data table is created using the data table creation method described above. In one embodiment, the query module 810 can be used to perform the operation S610 described above, which will not be repeated here.

[0156] The output module 820 is used to output the target data. In one embodiment, the output module 820 can be used to perform the operation S620 described above, which will not be repeated here.

[0157] According to embodiments of this disclosure, any plurality of modules among the first acquisition module 710, the first creation module 720, the second acquisition module 730, the second creation module 740, the query module 810, and the output module 820 can be combined into one module, or any one of these modules can be split into multiple modules. Alternatively, at least part of the functionality of one or more of these modules can be combined with at least part of the functionality of other modules and implemented in one module. According to embodiments of this disclosure, at least one of the first acquisition module 710, the first creation module 720, the second acquisition module 730, the second creation module 740, the query module 810, and the output module 820 can be at least partially implemented as hardware circuitry, such as a field-programmable gate array (FPGA), a programmable logic array (PLA), a system-on-a-chip, a system-on-a-substrate, a system-on-package, an application-specific integrated circuit (ASIC), or implemented in hardware or firmware by any other reasonable means of integrating or packaging the circuitry, or implemented in any one of the three implementation methods of software, hardware, and firmware, or in a suitable combination of any of these. Alternatively, at least one of the first acquisition module 710, the first creation module 720, the second acquisition module 730, the second creation module 740, the query module 810, and the output module 820 may be implemented at least partially as a computer program module, which can perform corresponding functions when the computer program module is run.

[0158] Figure 9 A block diagram schematically illustrates an electronic device suitable for implementing a data table creation method and / or a target data query method according to embodiments of the present disclosure.

[0159] like Figure 9 As shown, an electronic device 900 according to an embodiment of the present disclosure includes a processor 901, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 902 or a program loaded from a storage portion 908 into a random access memory (RAM) 903. The processor 901 may include, for example, a general-purpose microprocessor (e.g., a CPU), an instruction set processor and / or an associated chipset and / or a special-purpose microprocessor (e.g., an application-specific integrated circuit (ASIC)), etc. The processor 901 may also include onboard memory for caching purposes. The processor 901 may include a single processing unit or multiple processing units for performing different actions of the method flow according to an embodiment of the present disclosure.

[0160] RAM 903 stores various programs and data required for the operation of electronic device 900. Processor 901, ROM 902, and RAM 903 are interconnected via bus 904. Processor 901 performs various operations of the method flow according to embodiments of the present disclosure by executing programs in ROM 902 and / or RAM 903. It should be noted that the programs may also be stored in one or more memories other than ROM 902 and RAM 903. Processor 901 may also perform various operations of the method flow according to embodiments of the present disclosure by executing programs stored in said one or more memories.

[0161] According to embodiments of this disclosure, the electronic device 900 may further include an input / output (I / O) interface 905, which is also connected to a bus 904. The electronic device 900 may also include one or more of the following components connected to the I / O interface 905: an input section 906 including a keyboard, mouse, etc.; an output section 907 including a cathode ray tube (CRT), liquid crystal display (LCD), etc., and a speaker, etc.; a storage section 908 including a hard disk, etc.; and a communication section 909 including a network interface card such as a LAN card, modem, etc. The communication section 909 performs communication processing via a network such as the Internet. A drive 910 is also connected to the I / O interface 905 as needed. A removable medium 911, such as a disk, optical disk, magneto-optical disk, semiconductor memory, etc., is installed on the drive 910 as needed so that computer programs read from it can be installed into the storage section 908 as needed.

[0162] This disclosure also provides a computer-readable storage medium, which may be included in the device / apparatus / system described in the above embodiments; or it may exist independently and not assembled into the device / apparatus / system. The computer-readable storage medium carries one or more programs that, when executed, implement the method according to the embodiments of this disclosure.

[0163] According to embodiments of this disclosure, the computer-readable storage medium may be a non-volatile computer-readable storage medium, such as including, but not limited to: portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination thereof. In this disclosure, the computer-readable storage medium may be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device. For example, according to embodiments of this disclosure, the computer-readable storage medium may include ROM 902 and / or RAM 903 and / or one or more memories other than ROM 902 and RAM 903 described above.

[0164] Embodiments of this disclosure also include a computer program product comprising a computer program containing program code for performing the methods shown in the flowchart. When the computer program product is run on a computer system, the program code is used to cause the computer system to implement the item recommendation method provided in the embodiments of this disclosure.

[0165] When the computer program is executed by the processor 901, it performs the functions defined in the system / apparatus of this disclosure embodiments. According to embodiments of this disclosure, the systems, apparatuses, modules, units, etc., described above can be implemented by computer program modules.

[0166] In one embodiment, the computer program may rely on a tangible storage medium such as an optical storage device or a magnetic storage device. In another embodiment, the computer program may also be transmitted and distributed in the form of signals over a network medium, and downloaded and installed via the communication section 909, and / or installed from a removable medium 911. The program code contained in the computer program can be transmitted using any suitable network medium, including but not limited to: wireless, wired, etc., or any suitable combination thereof.

[0167] In such an embodiment, the computer program can be downloaded and installed from a network via the communication section 909, and / or installed from the removable medium 911. When the computer program is executed by the processor 901, it performs the functions defined in the system of this disclosure embodiment. According to embodiments of this disclosure, the systems, devices, apparatuses, modules, units, etc., described above can be implemented by computer program modules.

[0168] According to embodiments of this disclosure, program code for executing the computer programs provided in embodiments of this disclosure can be written in any combination of one or more programming languages. Specifically, these computational programs can be implemented using high-level procedural and / or object-oriented programming languages, and / or assembly / machine languages. Programming languages ​​include, but are not limited to, languages ​​such as Java, C++, Python, "C", or similar programming languages. The program code can execute entirely on the user's computing device, partially on the user's device, partially on a remote computing device, or entirely on a remote computing device or server. In cases involving remote computing devices, the remote computing device can be connected to the user's computing device via any type of network, including a local area network (LAN) or a wide area network (WAN), or it can be connected to an external computing device (e.g., via the Internet using an Internet service provider).

[0169] 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 a block diagram or flowchart, and combinations of blocks in a block diagram or flowchart, may 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.

[0170] Those skilled in the art will understand that the features described in the various embodiments and / or claims of this disclosure can be combined or combined in various ways, even if such combinations or combinations are not explicitly described in this disclosure. In particular, the features described in the various embodiments and / or claims of this disclosure can be combined or combined in various ways without departing from the spirit and teachings of this disclosure. All such combinations and / or combinations fall within the scope of this disclosure.

[0171] The embodiments of this disclosure have been described above. However, these embodiments are for illustrative purposes only and are not intended to limit the scope of this disclosure. Although various embodiments have been described above, this does not mean that the measures in the various embodiments cannot be used advantageously in combination. The scope of this disclosure is defined by the appended claims and their equivalents. Various substitutions and modifications can be made by those skilled in the art without departing from the scope of this disclosure, and all such substitutions and modifications should fall within the scope of this disclosure.

Claims

1. A method for creating a data table, comprising: obtaining configuration data for a predetermined page in response to detecting a configuration operation performed for the predetermined page; the configuration data comprising a business category identifier, a configuration field name, and a configuration attribute corresponding to the configuration field name; creating table structure information of a to-be-created data table according to the configuration data, comprising: in response to detecting that a table name in the created table structure information is inconsistent with the business category identifier, newly creating first table structure information; wherein the table name in the first table structure information is consistent with the business category identifier, the field name in the first table structure information is consistent with the configuration field name, and the field attribute in the first table structure information is consistent with the configuration attribute; the table structure information comprises a plurality of fields, and each field comprises a field name; obtaining at least one business data, each business data comprising a data identifier and a data value corresponding to the data identifier; and for each business data, in a case where the data identifier in the business data is determined to match a first field name in the plurality of fields, creating table content information of the to-be-created data table according to the data value in the business data and a field corresponding to the first field name, comprising: determining, as target table structure information, table structure information in which the table name is consistent with the business category identifier among the at least two created table structure information; in a case where the data identifier in the business data is determined to match the first field name in the target table structure information, creating table content information corresponding to the target table structure information according to the data value in the business data and the field corresponding to the first field name.

2. The method of claim 1, wherein, the creating table structure information of the to-be-created data table according to the configuration data comprises: in response to detecting that a table name of second table structure information is consistent with the business category identifier, determining whether the second table structure information comprises a second field name consistent with the configuration field name; wherein the second table structure information is one of the created table structure information; and in a case where the second table structure information is determined not to comprise the second field name, adding a target field in the second table structure information; wherein the field name of the target field is consistent with the configuration field name, and the field attribute of the target field is consistent with the configuration attribute.

3. The method of claim 2, wherein, the creating table structure information of the to-be-created data table according to the configuration data further comprises: in a case where the second table structure information is determined to comprise the second field name, replacing a field attribute corresponding to the second field name with the configuration attribute.

4. The method of claim 1, wherein, the configuration data comprises a business system identifier set, and the business data comprises an identifier of a business system; the method further comprises: in response to detecting that the business system identifier set comprises the identifier of the business system, triggering an operation of creating table content information of a data table. 5.A method for querying target data, comprising: in response to receiving a query request, querying target data in a data table according to the query request; and outputting the target data. ​ The data table is created by the method according to any one of claims 1-4.

6. A data table creation apparatus, comprising: a first obtaining module configured to, in response to detecting a configuration operation performed on a predetermined page, obtain configuration data for the predetermined page; the configuration data comprising a service category identifier, a configuration field name, and a configuration attribute corresponding to the configuration field name; a first creating module configured to create table structure information of a to-be-created data table according to the configuration data, including: in response to detecting that a table name in the created table structure information is inconsistent with the service category identifier, newly creating first table structure information; wherein the table name in the first table structure information is consistent with the service category identifier, the field name in the first table structure information is consistent with the configuration field name, and the field attribute in the first table structure information is consistent with the configuration attribute; the table structure information comprises a plurality of fields, and each field comprises a field name; a second obtaining module configured to obtain at least one service data, each service data comprising a data identifier and a data value corresponding to the data identifier; and a second creating module configured to, for each service data, create table content information of the to-be-created data table according to a data value in the service data and a field corresponding to a first field name in the service data in a case where the data identifier in the service data matches the first field name, including: determining, from at least two created table structure information, table structure information in which a table name is consistent with the service category identifier as target table structure information; and creating table content information corresponding to the target table structure information according to the data value in the service data and the field corresponding to the first field name in the target table structure information in a case where the data identifier in the service data matches the first field name in the target table structure information.

7. A target data query apparatus, comprising: a querying module configured to, in response to receiving a query request, query target data in a data table according to the query request; and an output module configured to output the target data; wherein the data table is created by the method according to any one of claims 1-4.

8. An electronic device, comprising: one or more processors; a storage device for storing one or more programs, wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to perform the method according to any one of claims 1-5.

9. A computer-readable storage medium having stored thereon executable instructions that, when executed by a processor, cause the processor to perform the method according to any one of claims 1-5.

10. A computer program product comprising a computer program that, when executed by a processor, implements the method according to any one of claims 1-5. ​

Images