CN115587575A

CN115587575A - Data table creation method, target data query method, device and equipment

Info

Publication number: CN115587575A
Application number: CN202211178035.5A
Authority: CN
Inventors: 余刚; 丁诗璟; 沈文俊; 高明; 万聪; 刘维安; 袁园; 欧阳明; 李亮; 沈冰华; 姚琛; 谢传聪; 苏蜜; 陈思广; 李华峰; 周婉月; 杨蓓蓓; 吕明; 龚正; 张政
Original assignee: China Construction Bank Corp; CCB Finetech Co Ltd
Current assignee: China Construction Bank Corp; CCB Finetech Co Ltd
Priority date: 2022-09-26
Filing date: 2022-09-26
Publication date: 2023-01-10

Abstract

The disclosure provides a data table creating method, a target data query device and equipment, which can be applied to the technical field of big data. The method comprises the following steps: in response to detecting a configuration operation performed on a predetermined page, acquiring configuration data for the predetermined page; according to the configuration data, creating table structure information of a data table to be created, wherein the table structure information comprises a plurality of fields, and each field comprises a field name; acquiring at least one service data, wherein each service data comprises a data identifier and a data value corresponding to the data identifier; and for each service data, under the condition that the data identification in the service data is matched with the first field name in the plurality of fields, creating table content information of the data table to be created according to the data value in the service data and the field corresponding to the first field name.

Description

Data table creation method, target data query method, device and equipment

Technical Field

The present disclosure relates to the field of big data, and in particular, to a data table creating method, a target data querying method, a data table creating apparatus, a target data querying apparatus, an electronic device, a computer-readable storage medium, and a computer program product.

Background

A user can relate to a plurality of service systems in the process of handling a service, and data among the service systems are isolated from each other. When a user needs to query data generated in each system in the process of handling a business, the user needs to log in a plurality of systems respectively and query under different menus, and the query process is complicated.

Therefore, it is necessary to access service data of different systems into one data system so that a user can query all data related to one service by using the data system.

Disclosure of Invention

In view of the above, the present 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.

According to an aspect of the present disclosure, there is provided a data table creation method including: in response to detecting a configuration operation performed on a predetermined page, acquiring configuration data for the predetermined page; according to the configuration data, creating table structure information of a data table to be created, wherein the table structure information comprises a plurality of fields, and each field comprises a field name; acquiring at least one service data, wherein each service data comprises a data identifier and a data value corresponding to the data identifier; and for each service data, under the condition that the data identification in the service data is determined to be matched with a first field name in the fields, creating table content information of the data table to be created according to the data value in the service data and the field corresponding to the first field name.

According to another embodiment of the present disclosure, the configuration data includes a service class identifier, a configuration field name, and a configuration attribute corresponding to the configuration field name; the creating of the table structure information of the data table to be created according to the configuration data comprises: in response to the fact that the table name in the established table structure information is detected to be inconsistent with the service type identification, establishing first table structure information; wherein, the table name in the first table structure information is consistent with the service type 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.

According to another embodiment of the present disclosure, the configuration data includes a service class identifier, a configuration field name, and a configuration attribute corresponding to the configuration field name; the creating of the table structure information of the data table to be created according to the configuration data comprises: in response to detecting that the table name of the second table structure information is consistent with the service class 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 the event that it is determined that the second table structure information does not include the second field name, adding a target field in the second table structure information; and 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.

According to another embodiment of the present disclosure, the creating table structure information of the data table to be created according to the configuration data further includes: replacing a field attribute corresponding to the second field name with the configuration attribute if it is determined that the second table structure information includes the second field name.

According to another embodiment of the present disclosure, the number of table structure information that has been created is at least two; the creating table content information of the data table to be created according to the data value in the service data and the field corresponding to the first field name under the condition that the data identifier in the service data is determined to be matched with the first field name in the plurality of fields comprises: determining table structure information with a table name consistent with the service class identifier in the created at least two pieces of table structure information as target table structure information; and under the condition that the data identification in the service data is determined to be matched with 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 service data and the field corresponding to the first field name.

According to another embodiment of the present disclosure, the configuration data includes a set of service system identifiers, and the service data includes identifiers of service systems; the method further comprises the following steps: triggering an operation of creating table content information of a data table in response to detecting that the set of business system identifications includes an identification of the business system.

Another aspect of the present disclosure provides a target data query method, including: 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.

Another aspect of the present disclosure provides a data table creating apparatus, including a first obtaining module, a first creating module, a second obtaining module, and a second creating module. The first acquisition module is used for acquiring configuration data aiming at a preset page in response to detecting a configuration operation executed aiming at the preset page; the first creating module is used for creating table structure information of a data table to be created according to the configuration data, the table structure information comprises a plurality of fields, and each field comprises a field name; the second acquisition module is used for acquiring at least one service data, and each service data comprises a data identifier and a data value corresponding to the data identifier; the second creating module is used for creating table content information of the data table to be created according to a data value in the service data and a field corresponding to a first field name under the condition that the data identification in the service data is matched with the first field name in the fields according to each service data.

Another aspect of the present disclosure provides a target data query apparatus, including a query module and an output module. The query module is used for responding to a received query request and querying target data in a data table according to the query request; the output module is used for outputting the target data; wherein the data table is created using the data table creation method described above.

Another aspect of the present disclosure provides an electronic device including: one or more processors; memory 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 above-described method.

Another aspect of the present disclosure also provides a computer-readable storage medium having stored thereon executable instructions that, when executed by a processor, cause the processor to perform the above-described method.

Another aspect of the disclosure also provides a computer program product comprising a computer program which, when executed by a processor, implements the above method.

According to the data table creating method, device, equipment, medium and program product provided by the present disclosure, when data sent by a service system changes, for example, the upstream service system increases some fields, and for example, the upstream service system modifies types and field lengths of some fields. The object can modify the structure information of the data table on line according to actual requirements to modify the structure of the data table. Compared with the prior art, the technical scheme provided by the embodiment of the disclosure supports each service system to modify the issued data, does not need to modify a data processing program, can add and modify the table structure information of the data table on line, and can take effect in real time, so that the flexibility and convenience of accessing data from the service system are improved.

Drawings

The foregoing and other objects, features and advantages of the disclosure will be apparent from the following description of embodiments of the disclosure, which proceeds with reference to the accompanying drawings, in which:

FIG. 1 schematically illustrates an application scenario diagram of a data table creation method and/or a target data query method according to an embodiment of the present disclosure;

FIG. 2 schematically illustrates a flow chart of a data table creation method according to an embodiment of the present disclosure;

FIG. 3 schematically illustrates a flow diagram for creating table structure information according to an embodiment of the disclosure;

FIG. 4 schematically shows a schematic diagram of configuration data according to an embodiment of the disclosure;

FIG. 5 schematically shows a schematic diagram of configuration data according to another embodiment of the present disclosure;

FIG. 6 schematically illustrates a flow diagram of a target data query method according to an embodiment of the disclosure;

FIG. 7 is a block diagram schematically illustrating a structure of a data table creating apparatus according to an embodiment of the present disclosure;

FIG. 8 is a block diagram schematically illustrating a target data querying device according to an embodiment of the present disclosure; and

FIG. 9 schematically illustrates a block diagram of an electronic device adapted to implement a data table creation method and/or a target data query method in accordance with an embodiment of the present disclosure.

Detailed Description

Hereinafter, embodiments of the present disclosure will be described with reference to the accompanying drawings. It should be understood that these descriptions are illustrative only and are not intended to limit the scope of the present disclosure. In the following detailed description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the embodiments of the disclosure. It may be evident, however, that one or more embodiments may be practiced without these specific details. Moreover, in the following description, descriptions of well-known structures and techniques are omitted so as to not unnecessarily obscure the concepts of the present disclosure.

The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the disclosure. The terms "comprises," "comprising," and the like, as used herein, specify the presence of stated features, steps, operations, and/or components, but do not preclude the presence or addition of one or more other features, steps, operations, or components.

All terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art unless otherwise defined. It is noted that the terms used herein should be interpreted as having a meaning that is consistent with the context of this specification and should not be interpreted in an idealized or overly formal sense.

Where a convention analogous to "at least one of A, B, and C, etc." is used, in general such a construction is intended in the sense one having skill in the art would understand the convention (e.g., "a system having at least one of A, B, and C" would include but not be limited to systems that have A alone, B alone, C alone, A and B together, A and C together, B and C together, and/or A, B, and C together, etc.).

In the technical scheme of the disclosure, the data acquisition, collection, storage, use, processing, transmission, provision, disclosure, application and other processing are all in accordance with the regulations of relevant laws and regulations, necessary security measures are taken, and the public order and good custom are not violated.

The business data represents data with business purposes generated by each business system in the transaction process.

Access data means that data generated by a plurality of service systems is imported into a centralized system.

In some technical solutions, a pre-agreed table structure may be adopted to implement data access. For example, a table structure is defined in advance in the data system, and the table structure may include: the fields in the data table and the format of each field, and the downstream data system develops the corresponding data processing program in advance. When accessing data, the upstream service system issues data according to the agreed field sequence and format, and the downstream data system imports the data by using a data processing program.

It can be seen that the above technical solution requires the table structure to be defined in advance and the data processing program to be developed separately. When data sent by an upstream service system changes, for example, the upstream service system adds some fields, and for example, the upstream service system modifies types and field lengths of some fields, and a downstream data system needs to modify a data processing program in a matching manner. Therefore, the flexibility of accessing data is poor.

Fig. 1 schematically illustrates an application scenario diagram of a data table creation method and/or a target data query method according to an embodiment of the present disclosure.

As shown in fig. 1, an application scenario 100 according to this embodiment may include

terminal devices

101, 102, 103, a network 104 and a server 105. Network 104 is the medium used to provide communication links between

terminal devices

101, 102, 103 and server 105. Network 104 may include various connection types, such as wired, wireless communication links, or fiber optic cables, among others.

The user may use the

terminal devices

101, 102, 103 to interact with the server 105 via the network 104 to receive or send messages or the like. The

terminal devices

101, 102, 103 may have installed thereon various communication client applications, such as shopping-like applications, web browser applications, search-like applications, instant messaging tools, mailbox clients, social platform software, etc. (by way of example only).

The

terminal devices

101, 102, 103 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smart phones, tablet computers, laptop portable computers, desktop computers, and the like.

The server 105 may be a server providing various services, such as a background management server (for example only) providing support for websites browsed by users using the

terminal devices

101, 102, 103. The background management server may analyze and perform other processing on the received data such as the user request, and feed back a processing result (e.g., a data table generated according to the configuration operation and the service data, or target data determined according to the query request, and the like) to the terminal device.

It should be noted that the data table creation method and/or the target data query method provided by the embodiments of the present disclosure may be generally executed by the server 105. Accordingly, the data table creation device and/or the target data query device provided by the embodiments of the present disclosure may be generally disposed in the server 105. The data table creation method and/or the target data query method provided by the embodiments of the present disclosure may also be executed by a server or a server cluster that is different from the server 105 and is capable of communicating with the

terminal devices

101, 102, 103 and/or the server 105. Correspondingly, the data table creating device and/or the target data querying device provided by the embodiment of the present disclosure may also be disposed in a server or a server cluster different from the server 105 and capable of communicating with the

terminal devices

101, 102, 103 and/or the server 105.

It should be understood that the number of terminal devices, networks, and servers in fig. 1 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.

The data table creation method of the disclosed embodiment will be described in detail below with fig. 2 to 5 based on the scenario described in fig. 1.

FIG. 2 schematically shows a flow chart of a data table creation method according to an embodiment of the disclosure.

As shown in fig. 2, the data table creation method 200 of this embodiment includes operations S210 to S240.

In operation S210, in response to detecting a configuration operation performed with respect to a predetermined page, configuration data for the predetermined page is acquired.

For example, the predetermined page may be a human-machine interaction interface. The configuration operation may be that the object clicks a save button in a predetermined page, and the object may be a user.

For example, the configuration data may include the number of fields in the table, the field name of each field, and field attributes for each field, which may include data type, field length, and the like.

In practical applications, the object may determine the configuration data according to data issued by an upstream service system. For example, the data sent by the service system includes serial numbers, account numbers and amounts, and the configuration data may include three field names, where the three field names are "serial numbers", "account numbers" and "amounts", respectively, and in addition, types corresponding to the three data may be configured as character strings.

In operation S220, table structure information of a data table to be created is created according to configuration data, the table structure information including a plurality of fields, each field including a field name.

For example, the number of fields contained in the data table, the field name of each field, and the field attribute of each field are determined according to the data in the configuration data.

For example, if the data issued by the service system includes serial number, account number and amount, and the configuration data may include three field names of "serial number", "account number" and "amount", the type corresponding to each data is a character string. A table building statement may be generated from the configuration data, three fields are automatically created by the table building statement, the field names of the three fields are "serial number", "account number", and "amount", respectively, and the field type of each field is a character string, whereby table structure information may be obtained.

In operation S230, at least one service data is acquired, each service data including a data identification and a data value corresponding to the data identification.

For example, the upstream service system may send data that needs to be accessed to the device for executing the data table creation method.

For example, the format of the service data may be a Json format, which is simple, general, and flexible. For example, the traffic data may include { flow number: 001, amount: 100, in the service data, "serial number" and "amount" are data identifiers, "001" is a data value corresponding to the data identifier "serial number," and "100" is a data value corresponding to the data identifier "amount.

In operation S240, for each service data, in case that it is determined that the data identifier in the service data matches a first field name in the plurality of fields, table content information of the data table to be created is created according to the data value in the service data and the field corresponding to the first field name.

For example, the data label "serial number" may be matched to each of the three field names (the three field names refer to "serial number", "account number", and "amount"), and the data label "amount" may be matched to each of the three field names.

For example, processing may determine that the data identification "water number" matches the field name "water number", then table content may be created from the data value "001" and the field A corresponding to the field name "water number", e.g., "001" as the field content of field A and written to field A.

For another example, the process may determine that the data identification "amount" matches the field name "amount", and may create table contents from the data value "100" and the field B corresponding to the field name "amount", e.g., "100" as the field contents of field B and written to field B.

It is to be understood that, for convenience of distinguishing from other field names, the field name to be matched is referred to as a first field name, which may be a field name of any one of the fields.

It can be seen that the data table includes table structure information and table content information, the table structure information is determined according to configuration data input by the object in a predetermined page, the table content data is determined according to data received from the service system, the process of creating the table content data may include writing field content in the structure, and after creating the table structure information and the table content information, the data table storing the data may be obtained.

According to the technical scheme provided by the embodiment of the disclosure, when data sent by a service system changes, for example, some fields are added by the upstream service system, and for example, the type and the field length of some fields are modified by the upstream service system. The object can modify the structure information of the data table on line according to actual requirements to modify the structure of the data table. Compared with the prior art, the technical scheme provided by the embodiment of the disclosure supports each service system to modify the issued data, does not need to modify a data processing program, can add and modify the table structure information of the data table on line, and the added and modified table structure information can take effect in real time, so that the flexibility and convenience of accessing data from the service system are improved.

As shown in fig. 3, the method 320 for creating the table structure information of the data table to be created according to the configuration data may include operations S321 to S325.

In operation S321, it is determined whether the table name in the created table structure information coincides with the service class identification in the configuration data. If not, perform operation S322; if so, operation S323 is performed.

For example, the configuration data includes a service class identification, a configuration field name, and a configuration attribute corresponding to the configuration field name. The business categories may include, for example, personal loans, corporate loans, credit card repayment, and the like. The configuration field name indicates the field name that needs to be included in the data table. The configuration attributes may represent attributes of the field contents of the field, such as field type, field length, and the like.

For example, the inconsistency between the table name and the service class identifier in the created table structure information may indicate that: and temporarily not creating a corresponding data table aiming at the service type identifier, wherein the configuration operation is a new data table.

For example, the table name in the created table structure information consistent with the service class identifier may indicate that: a corresponding data table is created for the service class identifier, and this configuration operation is to modify the created data table, where the modification content may include, for example, adding a field in the data table, modifying a field attribute, and the like.

In operation S322, first table structure information is newly created.

It is to be understood that the present operation is a newly added data table, and the table structure information of the newly added data table is referred to as first table structure information for the sake of distinguishing from other data tables.

For example, in the new creation process, the service class identifier is created as a table name in the first table structure information, the configuration field name is created as a field name in the first table structure information, and the configuration attribute is created as a field attribute in the first table structure information. It can be seen that, through the above creation operation, the table name in the first table structure information is consistent with the service class 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.

In operation S323, it is determined 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 created table structure information. If not, perform operation S324; if so, operation S325 is performed.

It is to be understood that the second field name may be a field name of any field in the second table structure information, and for convenience of distinguishing from other field names, a field name in the second table structure information that is consistent with the configuration field name is referred to as a second field name.

For example, the second table structure information excluding the second field name may indicate that: the field corresponding to the second field name creation is not created for the time being, and this configuration operation is a new field.

For example, the second table structure information including the second field name may indicate that: a field corresponding to the second field name creation is created, and the configuration operation is to modify the created field, and the modification content may include, for example, modifying a field attribute.

In operation S324, a target field is added in the second table structure information.

It is understood that the present operation is to modify the created data table, and the modified content is the added field. For the sake of distinguishing from other fields, the added field is referred to as a target field.

For example, during creation, a configuration field name may be created as the field name of the target field and a configuration attribute may be created as the field attribute of the target field. It can be seen that, through the above creation operation, 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.

In operation S325, the field attribute corresponding to the second field name is replaced with the configuration attribute.

It will be appreciated that the present operation is to modify the created data table, and that the modification is to modify the field properties of the existing fields, such as modifying the field length and the field type.

For example, the second field name originally has a field length of 100, and the modified second field has a field length of 200.

According to another embodiment of the present disclosure, the number of the created table structure information is at least two, and accordingly, the operation of creating the table content information of the data table according to the field where the data value and the first field name are located in the service data in the case that it is determined that the data identifier in the service data matches the first field name in the plurality of fields may include the following operations: and determining the table structure information with the table name consistent with the service type identification in the created at least two table structure information as target table structure information. And then, under the condition that the data identification in the service data is matched with 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 service data and the field corresponding to the first field name.

For example, when at least two pieces of table structure information have been created, the field names of the same name may be included in different pieces of table structure information, for example, both pieces of table structure information include the "number" field name. In order to avoid writing a data value into an incorrect data table, a target table can be determined according to a table name and a service class identifier, and then the data identifier is matched with a field name in the structure information of the target table, so that the effect of accurately writing data is achieved.

According to another embodiment of the present disclosure, in the process of determining the target table structure information, the target business system may be determined from the multiple business systems, the data table structure information corresponding to the target business system may be determined as candidate table structure information, and then the target table structure information may be determined from the candidate table structure information.

For example, data of a plurality of service systems may be accessed, each service system may include a plurality of service classes, and each service class may correspond to one data table. In this case, the service class identifier may represent a service system to which the service class belongs. For example, if the identity of the first service system is S1 and the first service system includes 20 service classes, the "number of the service system identifying the service class" may be used as the identity of the service class, for example, the identity of the fifth service class in the first service system may be "S1_05".

For example, the service data may further include a source identifier indicating the service system of the service data and the service class, for example, the source label "S1_01" may indicate that the service data is from the first service class in the first service system.

For example, the first service system includes 20 service classes, the second service system includes 30 service classes, and the total of the two service systems is 50 data tables. When the source identifier in the service data is "S1_05", table structure information of 20 data tables corresponding to the first service system may be determined as candidate table structure information. And then determines the data table structure information corresponding to the fifth service class among the 20 candidate table structure information as the target table structure information.

By determining the target table structure information in the mode, the target table structure information does not need to be determined from the 20 data table structure information corresponding to the second service system, so that the data processing amount is reduced, and the data processing efficiency is improved.

According to another embodiment of the present disclosure, the configuration data includes a set of service system identifications, and the service data includes an identification of the service system. Correspondingly, the method further comprises the following operations: determining whether the service system identifier set comprises the identifier of the service system, if so, triggering the operation of creating the table content information of the data table; if not, the operation of creating the table content information of the data table is not required to be triggered.

For example, the corresponding relationship between the data table structure information and the service system and the service category may be pre-established during configuration, so after the data table is created, the service system corresponding to the created data table may be determined, and the identities of these service systems constitute a service system identity set.

For example, the set of business system identifications excluding the identification of the business system may represent: the data table corresponding to the service system is not created temporarily, the acquired service data cannot be created as the content information of the data table, and the data identification of the service data does not need to be matched with the field name in the created data table, so that the process is saved, and the processing efficiency is improved.

The following describes a data table creating method provided by the present disclosure with reference to specific embodiments.

First, the user may define the number of the service system and the name of the service system using a predetermined page, and the service system is configured on the predetermined page, so as to allow access to the data of the service system.

As shown in fig. 4, fig. 4 schematically shows a schematic diagram of configuration data according to an embodiment of the present disclosure. The user can use the predetermined page to define the configuration data of the accessed service system, the configuration data can include the service category identification, the name of the configuration field and the configuration attribute corresponding to the name of the configuration field, the configuration attribute can include the field type and the field length, and can also include setting whether the field name is the query field and whether desensitization is performed.

Then, the user clicks a save button on a predetermined page, an SQL statement for creating a table is automatically generated, and the table-creating statement is used to create corresponding data table structure information. The table index may also be defined according to whether a field is queried or not. For example, according to the configuration data shown in fig. 4, a data table having a table name of S1_01 may be created, the data table including four fields, the field name of the first field being ID _1, the field type being varchar2, the maximum character length being 50, and the field name ID _1 being an index of the data table. The field name of the second field is ID _2, the field type is varchar2, the maximum character length is 100, and the field name ID _2 is the index of the data table. The field name of the third field is ID _3, the field type is number, and the field name ID _3 is an index of the data table. The field name of the fourth field is ID _4, the field type is varchar2, the maximum character length is 50, and the field name ID _4 is not an index of the data table.

In some embodiments, the table building statement may specifically be an SQL statement, for example, the generated SQL statement is as follows:

Create table S1_01

(

ID_1 varchar2(50)，

ID_2 varchar2(100)，

ID_3 number，

ID_4 varchar2(50)

)；

Create index S1_01_idx_01 on S1_01(ID_1)；

Create index S1_01_idx_02 on S1_01(ID_2)；

Create index S1_01idx_03 on S1_01(ID_3)；

as shown in fig. 5, fig. 5 schematically shows a schematic diagram of configuration data according to another embodiment of the present disclosure. The user can also add or modify fields through the predetermined page. For example: and adding a 'name' field, and modifying the field length of the 'second name' field to 200.

Next, after the user adds or modifies a field, the user clicks a hold button of a predetermined page to automatically generate a statement for modifying the table, for example, the maximum character length of the second field in the data table "S1_01" may be modified to 200 according to the configuration data shown in fig. 5. A field may be further added to the data table "S1_01", the field name of the added field is "name", the field type is varchar2, and the maximum character length is 200.

In some embodiments, the modification table statement may specifically be an SQL statement, for example, the modification table statement is as follows:

Alter table S1_01 add NAME varchar2(200)；

Alter table S1_01 modify ID_2 varchar2(200)；

in addition, the user can define the viewing authority of the access data, for example, the user with a predetermined role is allowed to inquire the newly added service category data.

In the process of data access, the service system can access service data in a Json format in a mode of an Http interface, an API jar package, an SDK (software development kit) and a terminal-of-day file.

Taking the access of the loan data as an example, the data in the Json format may include identification data, for example, the identification data is "Type": "S1_01", wherein the data name is "Type", and the data value is "S1_01". The data in Json format may also include service data, for example, service data is "ID _1": "123456", where the data identification is "ID _1" and the data value is "123456".

In some embodiments, specific examples of Json format data are as follows:

{“Type”：“S1_01”，

“ID_1”：“123456”，

“ID_2”：“987654”，

“ID_3”：“100”，

“ID_4”：“147852”

}

the method comprises the steps of determining target data table structure information from a plurality of data tables according to a source identifier 'Type' in service data, matching a data identifier in Json data with a configuration field name configured by a preset page, and writing a data value corresponding to the data identifier into the data tables as field content corresponding to the field name in matching. And if the certain data identifier is not successfully matched with all the field names in the data table, indicating that the data value corresponding to the data identifier does not need to be accessed in the data table.

In addition, when the service system has a newly added field, a data identifier and a data value can be directly added in the Json data issued by the service system. For example, on the basis of the original Json data, a new service data is added to the Json data newly issued by the service system, for example, the new service data is "NAME": "zhang san", wherein the data identification is "NAME" and the data value is "zhang san".

In some embodiments, specific examples of Json format data after business system update are as follows:

{“Type”：“S1_01”，

“ID_1”：“123456”，

“ID_2”：“987654”，

“ID_3”：“100”，

“ID_4”：“147852”，

"NAME": 'Zhang three',

}

for example, when matched data table of personal loan data and Json data both contain "NAME", the field value of "NAME" is stored in the database to realize data storage

After the data table is created in the above manner, the accessed data can be queried. For example, a role of the post is obtained according to the post of the login user, and the query authority of the role is determined, wherein the query authority indicates which business system data can be queried by the role. In the query interface, the system identifier that the user has the authority to query can be displayed, and a predefined query field can be displayed. When a user enters a query condition and clicks on a query, the target query data may be displayed. In addition, when the target query data is displayed, all field values or the field values after desensitization can be displayed according to preset desensitization attributes.

FIG. 6 schematically shows a flow diagram of a target data query method according to an embodiment of the disclosure.

As shown in fig. 6, the target data query method 600 of this embodiment includes operations S610 to S620.

In operation S610, in response to receiving the query request, the target data is queried in the data table according to the query request.

For example, the data table is created using the data table creation method described above.

In operation S620, target data is output.

According to the technical scheme provided by the embodiment of the disclosure, after the service data of a plurality of upstream service systems are accessed, all data related to the same service can be inquired by using the database in which the data table is stored.

Based on the data table creating method, the disclosure also provides a data table creating device. The apparatus will be described in detail below with reference to fig. 7.

Fig. 7 schematically shows a block diagram of the structure of a data table creating apparatus according to an embodiment of the present disclosure.

As shown in fig. 7, the data table creating apparatus 700 of this embodiment includes a first obtaining module 710, a first creating module 720, a second obtaining module 730, and a second creating module 740.

The first obtaining module 710 is configured to obtain configuration data for a predetermined page in response to detecting a configuration operation performed for the predetermined page. In an embodiment, the first obtaining module 710 may be configured to perform the operation S210 described above, which is not described herein again.

The first creating module 720 is configured to create table structure information of the data table to be created according to the configuration data, where the table structure information includes a plurality of fields, and each field includes a field name. In an embodiment, the first creating module 720 may be configured to perform the operation S220 described above, and is not described herein again.

The second obtaining module 730 is configured to obtain at least one service data, where each service data includes a data identifier and a data value corresponding to the data identifier. In an embodiment, the second obtaining module 730 may be configured to perform the operation S230 described above, which is not described herein again.

The second creating module 740 is configured to, for each service data, create table content information of the data table to be created according to the data value in the service data and the field corresponding to the first field name, when it is determined that the data identifier in the service data matches the first field name in the plurality of fields. In an embodiment, the second creating module 740 may be configured to perform the operation S240 described above, and is not described herein again.

According to another embodiment of the present disclosure, the configuration data includes a service class identifier, a configuration field name, and a configuration attribute corresponding to the configuration field name; the first creating module comprises a creating submodule and is used for creating first table structure information in response to the fact that the table name in the created table structure information is not consistent with the service class identification; the table name in the first table structure information is consistent with the service type 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.

According to another embodiment of the present disclosure, the configuration data includes a service class identifier, a configuration field name, and a configuration attribute corresponding to the configuration field name. The first creating module comprises a first determining submodule and an adding submodule. The first determining submodule is used for determining whether the second table structure information comprises a second field name consistent with the configuration field name or not in response to the fact that the table name of the second table structure information is detected to be consistent with the service class identifier; wherein the second table structure information is one of the created table structure information. The adding submodule is configured to add a target field in the second table structure information if it is determined that the second table structure information does not include the second field name. The field name of the target field is consistent with the field name of the configuration field, and the field attribute of the target field is consistent with the configuration attribute.

According to another embodiment of the present disclosure, the first creating module further includes a replacing submodule for replacing a field attribute corresponding to the second field name with the configuration attribute in a case where it is determined that the second table structure information includes the second field name.

According to another embodiment of the present disclosure, the number of table structure information that has been created is at least two. The second creating module includes a second determining submodule and a creating submodule. The second determining submodule is used for determining the table structure information with the table name consistent with the service type identification in the created at least two pieces of table structure information as the target table structure information. The creating submodule is used for creating table content information corresponding to the target table structure information according to a data value in the service data and a field corresponding to the first field name under the condition that the data identification in the service data is determined to be matched with the first field name in the target table structure information.

According to another embodiment of the present disclosure, the configuration data includes a set of service system identifications, and the service data includes an identification of the service system. The apparatus also includes a triggering module for triggering an operation of creating the table content information of the data table in response to detecting that the set of business system identifications includes an identification of a business system.

Based on the target data query method, the disclosure also provides a target data query device. The apparatus will be described in detail below with reference to fig. 8.

Fig. 8 schematically shows a block diagram of a target data querying device according to an embodiment of the present disclosure.

As shown in fig. 8, the target data querying device 800 of this embodiment includes a querying module 810 and an output module 820.

The query module 810 is configured to, in response to receiving the query request, 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 an embodiment, the query module 810 may be configured to perform the operation S610 described above, which is not described herein again.

The output module 820 is used for outputting the target data. In an embodiment, the output module 820 may be configured to perform the operation S620 described above, which is not described herein again.

According to the embodiment of the present disclosure, any plurality of the first obtaining module 710, the first creating module 720, the second obtaining module 730, the second creating module 740, the querying module 810 and the outputting module 820 may be combined into one module to be implemented, or any one of them may be split into a plurality of modules. Alternatively, at least part of the functionality of one or more of these modules may be combined with at least part of the functionality of other modules and implemented in one module. According to an embodiment of the present disclosure, at least one of the first obtaining module 710, the first creating module 720, the second obtaining module 730, the second creating module 740, the querying module 810 and the outputting module 820 may be at least partially implemented as a hardware circuit, 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 a package, an Application Specific Integrated Circuit (ASIC), or may be implemented by hardware or firmware in any other reasonable manner of integrating or packaging a circuit, or implemented by any one of three implementations of software, hardware and firmware, or by a suitable combination of any of them. Alternatively, at least one of the first obtaining module 710, the first creating module 720, the second obtaining module 730, the second creating module 740, the querying module 810, and the outputting module 820 may be at least partially implemented as a computer program module that, when executed, may perform a corresponding function.

As shown in fig. 9, an electronic apparatus 900 according to an embodiment of the present disclosure includes a processor 901 which can perform various appropriate actions and processes in accordance with 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. Processor 901 can include, for example, a general purpose microprocessor (e.g., a CPU), an instruction set processor and/or related chipset(s) and/or a special purpose microprocessor (e.g., an Application Specific Integrated Circuit (ASIC)), and/or the like. The processor 901 may also include on-board memory for caching purposes. The processor 901 may comprise a single processing unit or a plurality of processing units for performing the different actions of the method flows according to embodiments of the present disclosure.

In the RAM 903, various programs and data necessary for the operation of the electronic apparatus 900 are stored. The processor 901, the ROM 902, and the RAM 903 are connected to each other through a bus 904. The processor 901 performs various operations of the method flows according to the embodiments of the present disclosure by executing programs in the ROM 902 and/or the RAM 903. Note that the programs may also be stored in one or more memories other than the ROM 902 and the RAM 903. The processor 901 may also perform various operations of the method flows according to embodiments of the present disclosure by executing programs stored in the one or more memories.

Electronic device 900 may also include input/output (I/O) interface 905, input/output (I/O) interface 905 also connected to bus 904, according to an embodiment of the present disclosure. The electronic device 900 may also include one or more of the following components connected to the I/O interface 905: an input portion 906 including a keyboard, a mouse, and the like; an output section 907 including components such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage portion 908 including a hard disk and the like; and a communication section 909 including a network interface card such as a LAN card, a modem, or the like. The communication section 909 performs communication processing via a network such as the internet. The drive 910 is also connected to the I/O interface 905 as necessary. A removable medium 911 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 910 as necessary, so that a computer program read out therefrom is mounted into the storage section 908 as necessary.

The present disclosure also provides a computer-readable storage medium, which may be contained in the apparatus/device/system described in the above embodiments; or may exist separately and not be assembled into the device/apparatus/system. The computer-readable storage medium carries one or more programs which, when executed, implement a method according to an embodiment of the disclosure.

According to embodiments of the present disclosure, the computer-readable storage medium may be a non-volatile computer-readable storage medium, which may include, for example but is not limited to: a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. For example, according to embodiments of the present disclosure, a computer-readable storage medium may include the ROM 902 and/or RAM 903 described above and/or one or more memories other than the ROM 902 and RAM 903.

Embodiments of the present disclosure also include a computer program product comprising a computer program containing program code for performing the method illustrated by the flow chart. When the computer program product runs in a computer system, the program code is used for causing the computer system to realize the item recommendation method provided by the embodiment of the disclosure.

The computer program performs the above-described functions defined in the system/apparatus of the embodiments of the present disclosure when executed by the processor 901. The above described systems, devices, modules, units, etc. may be implemented by computer program modules according to embodiments of the present disclosure.

In one embodiment, the computer program may be hosted on a tangible storage medium such as an optical storage device, a magnetic storage device, and the like. In another embodiment, the computer program may also be transmitted, distributed in the form of a signal on a network medium, and downloaded and installed through the communication section 909 and/or installed from the removable medium 911. The computer program containing program code may be transmitted using any suitable network medium, including but not limited to: wireless, wired, etc., or any suitable combination of the foregoing.

In such an embodiment, the computer program may be downloaded and installed from a network via the communication section 909 and/or installed from the removable medium 911. The computer program, when executed by the processor 901, performs the above-described functions defined in the system of the embodiment of the present disclosure. The above described systems, devices, apparatuses, modules, units, etc. may be implemented by computer program modules according to embodiments of the present disclosure.

In accordance with embodiments of the present disclosure, program code for executing computer programs provided by embodiments of the present disclosure may be written in any combination of one or more programming languages, and in particular, these computer programs may be implemented using high level procedural and/or object oriented programming languages, and/or assembly/machine languages. The programming language includes, but is not limited to, programming languages such as Java, C + +, python, the "C" language, or the like. The program code may execute entirely on the user's computing device, partly on the user's device, partly on a remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., through the internet using an internet service provider).

The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

It will be appreciated by a person skilled in the art that various combinations or/and combinations of features recited in the various embodiments of the disclosure and/or in the claims may be made, even if such combinations or combinations are not explicitly recited in the disclosure. In particular, various combinations and/or combinations of the features recited in the various embodiments of the present disclosure and/or the claims may be made without departing from the spirit and teachings of the present disclosure. All such combinations and/or associations are within the scope of the present disclosure.

The embodiments of the present disclosure have been described above. However, these examples are for illustrative purposes only and are not intended to limit the scope of the present disclosure. Although the embodiments are described separately above, this does not mean that the measures in the embodiments cannot be used in advantageous combination. The scope of the disclosure is defined by the appended claims and equivalents thereof. Various alternatives and modifications can be devised by those skilled in the art without departing from the scope of the disclosure, and these alternatives and modifications are intended to fall within the scope of the disclosure.

Claims

1. A data table creation method, comprising:

in response to detecting a configuration operation performed on a predetermined page, acquiring configuration data for the predetermined page;

according to the configuration data, creating table structure information of a data table to be created, wherein the table structure information comprises a plurality of fields, and each field comprises a field name;

acquiring at least one service data, wherein each service data comprises a data identifier and a data value corresponding to the data identifier; and

and for each service data, under the condition that the data identification in the service data is matched with the first field name in the fields, creating table content information of the data table to be created according to the data value in the service data and the field corresponding to the first field name.

2. The method of claim 1, wherein the configuration data comprises a traffic class identification, a configuration field name, and a configuration attribute corresponding to the configuration field name; the creating of the table structure information of the data table to be created according to the configuration data comprises:

in response to the fact that the table name in the established table structure information is detected to be inconsistent with the service type identification, establishing first table structure information;

wherein, the table name in the first table structure information is consistent with the service type 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.

3. The method of claim 1, wherein the configuration data comprises a traffic class identifier, a configuration field name, and a configuration attribute corresponding to the configuration field name; the creating of the table structure information of the data table to be created according to the configuration data comprises:

in response to detecting that the table name of second table structure information is consistent with the service class 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

adding a target field in the second table structure information if it is determined that the second table structure information does not include the second field name;

and 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.

4. The method of claim 3, wherein the creating table structure information of the data table to be created according to the configuration data further comprises:

replacing a field attribute corresponding to the second field name with the configuration attribute if it is determined that the second table structure information includes the second field name.

5. The method of claim 1, wherein the number of table structure information created is at least two; the creating table content information of the data table to be created according to the data value in the service data and the field corresponding to the first field name under the condition that the data identification in the service data is determined to be matched with the first field name in the plurality of fields comprises:

determining table structure information with a table name consistent with the service class identifier in the created at least two pieces of table structure information as target table structure information; and

and under the condition that the data identification in the service data is matched with 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 service data and the field corresponding to the first field name.

6. The method of claim 5, wherein the configuration data comprises a set of business system identifications, the business data comprising an identification of a business system; the method further comprises the following steps:

triggering an operation of creating table content information of a data table in response to detecting that the set of business system identifications includes an identification of the business system.

7. 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 method according to one of claims 1 to 6.

8. A data table creation apparatus comprising:

the device comprises a first acquisition module, a second acquisition module and a third acquisition module, wherein the first acquisition module is used for responding to the detection of the configuration operation executed aiming at a preset page and acquiring the configuration data aiming at the preset page;

the first establishing module is used for establishing table structure information of a data table to be established according to the configuration data, wherein the table structure information comprises a plurality of fields, and each field comprises a field name;

the second acquisition module is used for acquiring at least one service data, and each service data comprises a data identifier and a data value corresponding to the data identifier; and

and a second creating module, configured to, for each piece of service data, create table content information of the to-be-created data table according to a data value in the piece of service data and a field corresponding to a first field name in the plurality of fields, when it is determined that a data identifier in the piece of service data matches the first field name in the plurality of fields.

9. A target data querying device, comprising:

the query module is used for responding to a received query request and querying target data in a data table according to the query request; and

an output module for outputting the target data;

10. 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 recited in any of claims 1-7.

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

12. A computer program product comprising a computer program which, when executed by a processor, implements the method according to any one of claims 1 to 7.