CN113377804A - Data processing method and device, storage medium and electronic equipment - Google Patents

Data processing method and device, storage medium and electronic equipment Download PDF

Info

Publication number
CN113377804A
CN113377804A CN202110732710.3A CN202110732710A CN113377804A CN 113377804 A CN113377804 A CN 113377804A CN 202110732710 A CN202110732710 A CN 202110732710A CN 113377804 A CN113377804 A CN 113377804A
Authority
CN
China
Prior art keywords
target
variable
key
data
business
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN202110732710.3A
Other languages
Chinese (zh)
Other versions
CN113377804B (en
Inventor
闫新兴
王鹏
李家豪
朴银权
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Sankuai Online Technology Co Ltd
Original Assignee
Beijing Sankuai Online Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Beijing Sankuai Online Technology Co Ltd filed Critical Beijing Sankuai Online Technology Co Ltd
Priority to CN202110732710.3A priority Critical patent/CN113377804B/en
Publication of CN113377804A publication Critical patent/CN113377804A/en
Application granted granted Critical
Publication of CN113377804B publication Critical patent/CN113377804B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2433Query languages
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The specification discloses a data processing method, a data processing device, a storage medium and electronic equipment. By generating a unique identifier for a target variable and using the generated identifier as a key in a target table, each key included in the target table is associated with the target variable when the target table is generated, and thus, when a data processing request for the target table is received, data information in the target table can be processed by the correspondence between the target variable and the identifier.

Description

Data processing method and device, storage medium and electronic equipment
Technical Field
The present disclosure relates to the field of computer technologies, and in particular, to a data processing method and apparatus, a storage medium, and an electronic device.
Background
Currently, databases are widely used for storing and managing a large amount of data.
Generally, a user to which a database is directed is a technical user familiar with the database Language, that is, an administrator of the database, and due to the technical threshold of the database Language, when a business user unfamiliar with the database Language needs to process data information in the database, for example, to visualize data of a certain business, the technical user needs to be informed of the need of the user, and the technical user writes a statement such as a Structured Query Language (SQL) to process the data.
How to reduce the difficulty of processing data by a service user who is not familiar with database language is an urgent problem to be solved.
Disclosure of Invention
The present specification provides a data processing method and apparatus to partially solve the above problems in the prior art.
The technical scheme adopted by the specification is as follows:
the present specification provides a data processing method including:
determining a target variable;
generating a unique identifier for each target variable in a predetermined generation mode, and establishing a corresponding relation between the generated identifier and the target variable;
generating a target table by taking the identifier corresponding to each target variable as a key; providing a data processing inlet for processing data in a target table according to the corresponding relation between each key and a target variable in the target table;
determining keys contained in a source table acquired in advance, and filling data contained in the source table into a target table according to the corresponding relation between each key in the source table and each key in the target table;
in response to the received data processing request, taking a target variable contained in the data processing request as a request variable, and determining a request operation executed on the request variable;
and processing the data information which takes the identifier corresponding to the request variable as a key in the target table according to the corresponding relation between the request variable and the identifier.
Optionally, generating a unique identifier for the target variable in a predetermined generation manner, specifically including:
judging whether the target variable is a preset specified basic variable or not;
if yes, determining the identifier of the specified basic variable according to the specified basic variable;
if not, determining the identifier of the target variable according to the identifier corresponding to the specified basic variable which is logically associated with the target variable.
Optionally, the target variables include business data variables and condition variables, where the business data variables include a first business data variable and a second business data variable;
judging whether the target variable is a preset specified basic variable, specifically comprising:
if the target variable is a first business data variable or a condition variable, judging that the target variable is a specified basic variable;
and if the target variable is the second business data variable, judging that the target variable is a non-specified basic variable.
Optionally, filling the data included in the source table into the target table according to the correspondence between each key in the source table and each key in the target table, specifically including:
taking the key contained in the target table as a target key and taking the key contained in the source table as a source key;
for each target key, taking a source key with the same identifier as the target key as a source key corresponding to the target key; or, for each target key, using a source key having a logical association with the target key as a source key corresponding to the target key;
and filling the data information corresponding to the target key in the target table with the data information corresponding to the source key corresponding to the target key in the source table.
Optionally, determining the target variable specifically includes:
determining a service scene;
determining each target variable under the service scene; dividing the service scene into a plurality of service processes;
for each business process, selecting a target variable related to the business process from the target variables in the business scene as a target variable corresponding to the business process;
generating a target table by taking the identifier corresponding to each target variable as a key, wherein the method specifically comprises the following steps:
and generating a target table corresponding to the business process by taking the identifier corresponding to each target variable corresponding to the business process as a key.
Optionally, determining each target variable in the service scenario specifically includes:
determining a business data variable and a condition variable under the business scene as each target variable under the business scene;
selecting a target variable related to the business process from the target variables in the business scene as a target variable corresponding to the business process, and specifically comprising the following steps:
selecting a business data variable generated in the business process from the business data variables in the business scene;
selecting a condition variable used for organizing a business data variable generated in the business process from the condition variables in the business scene;
and taking the selected business data variable generated in the business process and the condition variable used for organizing the business data variable generated in the business process as the target variable corresponding to the business process.
Optionally, generating the target table by using the identifier corresponding to each target variable as a key, specifically including:
acquiring a generation template for generating a data table, wherein the generation template at least comprises a placeholder to be filled;
and replacing the placeholders in the generated template by identifiers corresponding to the target variables, and obtaining the generated target table according to the replaced generated template.
The present specification provides a data processing apparatus comprising:
the variable determining module is used for determining a target variable;
the identification corresponding module is used for generating a unique identifier for each target variable in a predetermined generation mode and establishing a corresponding relation between the generated identifier and the target variable;
the generating module is used for generating a target table by taking the identifier corresponding to each target variable as a key; providing a data processing inlet for processing data in a target table according to the corresponding relation between each key and a target variable in the target table;
the data filling module is used for determining keys contained in a source table acquired in advance and filling data contained in the source table into the target table according to the corresponding relation between the keys in the source table and the keys in the target table;
the request response module is used for responding to the received data processing request, taking a target variable contained in the data processing request as a request variable and determining a request operation executed on the request variable;
and the data processing module is used for processing the data information which takes the identifier corresponding to the request variable as a key in the target table according to the corresponding relation between the request variable and the identifier.
The present specification provides a computer-readable storage medium storing a computer program which, when executed by a processor, implements the above-described data processing method.
The present specification provides an electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the above data processing method when executing the program.
The technical scheme adopted by the specification can achieve the following beneficial effects:
in the data processing method provided in the present specification, by generating a unique identifier for a target variable and using the generated identifier as a key in a target table, each key included in the generation of the target table corresponds to the target variable, and thus, when a data processing request for the target table is received, data information in the target table can be processed by the correspondence relationship between the target variable and the identifier.
Drawings
The accompanying drawings, which are included to provide a further understanding of the specification and are incorporated in and constitute a part of this specification, illustrate embodiments of the specification and together with the description serve to explain the specification and not to limit the specification in a non-limiting sense. In the drawings:
FIG. 1 is a flow chart of a data processing method in the present specification;
FIG. 2A is a schematic diagram of an input interface for a target variable in the present specification;
FIG. 2B is a schematic diagram of an input interface for another target variable in this specification;
FIG. 3 is a schematic diagram of a design interface of a bus matrix according to the present disclosure;
FIG. 4 is a schematic diagram of a data processing apparatus provided herein;
fig. 5 is a schematic structural diagram of an electronic device provided in this specification.
Detailed Description
The present specification provides a data processing method in which data as a processing target is stored in a database.
The database is oriented to two types of users: the technical users and the business users, wherein, the data definition, the data manipulation and the data control of the data in the database are taken as the standard by taking whether the users have the mode of writing the database statements (hereinafter, SQL statements are taken as examples), the users capable of performing the data definition, the data manipulation and the data control of the data in the database by writing the SQL statements are taken as the technical users, and the users incapable of performing the data definition, the data manipulation and the data control of the data in the database by writing the SQL statements are taken as the business users.
Usually, the technical user can manage the database by inputting the SQL statements, that is, the existing database only includes an interface for inputting the SQL statements provided for the technical user. In the embodiment of the present specification, besides the interface for inputting the SQL statement, the present specification is further configured to provide a data processing entry for a business user, and the user may input a data processing request through the data processing entry to manage data information in the database through the data processing request.
In an embodiment of this specification, the data processing entry may be a Graphical User Interface (GUI), in which case, the data processing entry may include a plurality of interactive controls for inputting a data processing request, and of course, the data processing entry may also be a search Interface including a plurality of search boxes, so that a User may input a search condition in a search box. It will be appreciated that the data processing portal may be presented to the user in any conventional manner, and the description is not intended to be limiting. For brevity, the following part of this specification takes the data processing portal as an example of a GUI.
Then, in response to the received data processing request, mapping a request operation to be executed on a target variable in the data processing request to data in the database according to a corresponding relationship between the target variable to be processed contained in the data processing request and a key in the database, thereby implementing processing on the data in the database.
It can be seen that, before the data processing entry is used to process the data in the database, a corresponding relationship needs to be established between the target variable of the data processing entry and the key in the database.
Since the data to be processed is determined according to the keys in the database when the data in the database is processed, it is easy for those skilled in the art to think that the database and the data processing entries may be respectively constructed first, and after the constructed database and the data processing entries are obtained, a corresponding relationship is manually established for the interactive controls characterizing the target variables in the keys and the data processing entries one by one, so that the operation performed by the user on the interactive controls characterizing the target variables through the data processing entries can be mapped to the data under the corresponding keys in the database through the corresponding relationship, thereby implementing the processing of the data in the database.
However, the efficiency of establishing the corresponding relationship by adopting the above method is low, and the accuracy of binding is difficult to ensure by manually binding the target variable and the key.
In order to make the objects, technical solutions and advantages of the present disclosure more clear, the technical solutions of the present disclosure will be clearly and completely described below with reference to the specific embodiments of the present disclosure and the accompanying drawings. It is to be understood that the embodiments described are only a few embodiments of the present disclosure, and not all embodiments. All other embodiments obtained by a person of ordinary skill in the art based on the embodiments in the present specification without any creative effort belong to the protection scope of the present specification.
Embodiments of the present disclosure provide a data processing method, which establishes a corresponding relationship between a target variable and a key in a database to be constructed in a process of constructing a database, and avoids the above disadvantages caused by binding the target variable and the key in the database one by one after the database is constructed.
The technical solutions provided by the embodiments of the present description are described in detail below with reference to the accompanying drawings.
Fig. 1 is a schematic flow chart of a data processing method in this specification, which specifically includes the following steps:
s100: a target variable is determined.
The database can store the original record data generated in the business process of the actual scene in a specific structural organization, so that the information which is hidden in the original record data and has an intrinsic rule can be found and extracted.
In order to enable the constructed database to adapt to services in different scenarios, before step S100 is executed, a service scenario that yields raw recorded data may be analyzed to determine concepts involved in a service field, such as "customer", "salesman", "goods", "order form", and the like in a service sales process, generally speaking, a service user may propose service concepts in which the service user is interested according to his understanding of data on services, and in the perspective of the service user, the service concepts proposed by the service user can describe the operation of services understood by the service user, so that the determined concepts with service meanings are referred to as service metadata.
Next, a target variable of the database to be constructed may be determined according to the service metadata, and in an embodiment of the present description, the determined service metadata may be directly used as the target variable.
The target variables are the concept and meaning of the keys contained in the data table, wherein the target variables may include business data variables and condition variables according to an understanding of the business concept. The business data variable is data generated in a business, and may be used to measure a situation of the business, for example, the business data variable may be a sales quantity of a commodity in the business sales process, and when a business event in the real world occurs, record data generated by the business event (i.e., the business data variable) is generated accordingly. In an embodiment of the present specification, the business data variables may be organized by the condition variables, for example, storage, screening, display, and the like, so as to obtain structured business data variables, so as to obtain an internal association between the business data variables and each data item under each condition variable. Still taking the sales business process as an example, the condition variable may be a brand of a commodity, and at this time, the number of sales of the commodity may be queried with the brand of the commodity as a constraint, that is, the business data variable may be filtered with the brand of the commodity as a condition.
In other definitions, business data variables are also called facts and condition variables are also called dimensions.
S102: and generating a unique identifier for each target variable in a predetermined generation mode, and establishing a corresponding relation between the generated identifier and the target variable.
In the embodiment of the present specification, after determining the service metadata describing the service field and determining the target variables corresponding to the keys in the database according to the service metadata, the association between the target variables needs to be determined. Depending on the specific meaning of the target variables, the association between the target variables may include constraints between business data variables, or which condition variables may be used to observe which business data variables, etc., and thereafter, the generation of the target table may be implemented on the physical medium, for example, the database may be stored in SQL form, according to the determined association between the target variables.
In an embodiment of this specification, an input interface of a target variable may be provided in advance, and at this time, the determined target variable may be input to the input interface of the target variable, so that a unique identifier is generated for each target variable in a predetermined generation manner, and a correspondence between the generated identifier and the target variable is established, for example, the specification provides the following two manners:
firstly, identifiers can be determined for each target variable independently, and used as the identifiers of the target variables, for example, the identifiers are determined for the target variables according to business meanings represented by the target variables, in an embodiment of the present specification, texts or translated english texts of the determined target variables can be used as the identifiers of the target variables;
secondly, the target variable may be divided into a designated basic variable and a non-designated basic variable in advance, identifiers are determined for the designated basic variable by adopting any one of the above manners independently, the designated basic variable having a logical association with the non-designated basic variable is used as a designated basic variable corresponding to the non-designated basic variable, and an identifier is generated for each non-designated basic variable according to the identifier corresponding to the designated basic variable corresponding to the non-designated basic variable.
In addition, the identifiers generated for the target variables in any of the above-described manners are different for every two target variables. When the identifier is generated for the non-specified basic variable in the second manner, the generated identifier of the non-specified basic variable may be formed by identifiers corresponding to the non-specified basic variables, and when the non-specified basic variable corresponds to a plurality of specified basic variables, the generated identifier for the non-specified basic variable may be formed by identifiers of the specified basic variables corresponding to the non-specified basic variables in a specified arrangement manner.
Moreover, the logical association between the non-specified basic variable and the specified basic variable at least includes: the non-specified basic variable is a result of a calculation based on the specified basic variable, and the non-specified basic variable is one of results of a logical operation of at least two specified basic variables.
In this embodiment, in accordance with the manner of determining the identifier of the target variable independently, the input interface of the target variable may include an input box for inputting the target variable and an input box for inputting the identifier corresponding to the input target variable, and the input interface of the target variable may establish a corresponding relationship between the received target variable and the received identifier in response to the target variable and the identifier input by the user at the input interface of the target variable. For example only, when the identifier of the target variable is determined independently, the input interface of the target variable may include the prompt words "identifier" and "target variable" as shown in fig. 2A, and correspond to input boxes into which characters can be input, respectively, so that the user can input corresponding information into the input boxes.
In addition, in accordance with the manner of generating the corresponding identifier for the unspecified basic variable according to the identifier corresponding to the specified basic variable having the logical association with the unspecified basic variable, the input interface of the target variable may further include an interaction control for selecting the specified basic variable, the user may implement the input of the target variable by selecting the specified basic variable at the input interface of the target variable, the input interface of the target variable may respond to the input of the user, and the identifier of the unspecified basic variable input by the user at the input interface of the target variable may be determined according to the identifier of each specified basic variable selected by the user. Of course, the input interface of the target variable may further include an interactive control for inputting the logical association between the non-specified basic variable and each specified basic variable, for example, the average number of the basic target variables may be used as the input non-specified basic variable by inputting a calculation formula, or the non-specified basic variable may be input as a logical expression of the specified basic variable by inputting a boolean formula
For example only, when an identifier corresponding to a specified basic variable having a logical association with a non-specified basic variable generates a corresponding identifier for the non-specified basic variable, the present specification provides an input interface of a target variable as shown in fig. 2B, where the input interface includes prompt words "identifier", "target variable 1", "target variable 2", and several input boxes, in this case, a user may select or input target variable 1 and target variable 2 in the input boxes, and when the target variable 2 is a condition variable, a variable item under the condition variable 2 may be selected through the input boxes, so that the target variable 1 is filtered through the target variable 2, and at this time, the input target variable may be considered as the target variable 1 filtered through the target variable 2. Then, according to the designated basic target variable associated with the non-designated basic target variable input by the user, an identifier may be directly generated for the non-designated basic target variable, as shown in fig. 2B, and the identifier may be formed by splicing the target variable 1 and the target variable 2.
In this embodiment of the present specification, the input interfaces of the target variable may exist on the same interface at the same time, or may exist on two child interfaces of the same parent interface respectively, and are switched according to the interactive control included in the parent interface.
In an embodiment of this specification, the condition variables and at least some of the business data variables may be divided into designated basic variables, and the rest of the business data variables may be divided into non-designated basic variables, where the business data variables divided into the designated basic variables are first business data variables, and the business data variables divided into the non-designated basic variables are second business data variables.
The first business data variable may be a measurement concept that is inseparable in the process of expressing a business, for example, a sales quantity of a commodity in the business sales process, and the second business data variable may be a business data variable that is obtained by performing statistical operation on the first business data variable and is established on the first business data variable, for example, a monthly average sales quantity of a commodity in the business sales process, or a business data variable that is obtained when a certain environment where the first business data variable is located is described by some condition variable, for example, a sales quantity of a commodity with a commodity unit price greater than 100, or it may be understood that the second business data variable is a business data variable obtained by screening the first business data variable by using the condition variable at this time. In the embodiment of the present specification, part of the second business data variables may also be used as the specified basic variables.
S104: generating a target table by taking the identifier corresponding to each target variable as a key; and providing a data processing inlet for processing the data in the target table according to the corresponding relation between each key and the target variable in the target table.
In the embodiment of the present specification, the target table is a table in the database, and the key of the target table is determined, that is, it may be considered that the structural organization of the database for data storage is determined.
In an embodiment of the present specification, the generated target table may include a fact table and a dimension table, where the fact table is generally used to store data keyed by an identifier corresponding to a business data variable, so as to measure a business event occurring in reality, and the dimension table stores data describing the business event in the fact table through a condition variable. In addition, the fact table can also store an external key for establishing an index relation with the dimension table through storing a corresponding main key in the dimension table.
In this embodiment, the generated target table may include a fact table and a dimension table, where an identifier determined for a business data variable may be used as a key in the fact table, and an identifier determined for a condition variable may be used as a key in the dimension table, so as to obtain the target table. In addition, since the condition variables may be degenerated into the fact table, the generated target table may also include only the fact table.
In this embodiment of the present specification, a generation template for generating a Data table may be obtained in advance, the generation template is a database statement, for example, the generation template may be written by using a database schema Definition Language (DDL) in an SQL Language, the generation template at least includes placeholders to be filled, after an identifier corresponding to each target variable is determined, the corresponding placeholder may be replaced by each identifier, and the target table is obtained according to the replaced generation template. Any existing database generation template may be used as the generation template described in this specification, and this specification does not limit this.
S106: and determining keys contained in a source table acquired in advance, and filling data contained in the source table into the target table according to the corresponding relation between each key in the source table and each key in the target table.
The source table may be a raw record data table of the business event.
In an embodiment of the present specification, data is populated from a pre-fetched source table into a pass-through destination table. Specifically, the key included in the target table may be used as a target key, the key included in the source table may be used as a source key, and for each target key, a corresponding relationship between the target key and at least one source key is established, so that the value of the target key is determined according to the value of the source key corresponding to the target key, and is filled into the target table. In the following, the present specification exemplarily provides two ways of establishing the correspondence between the target key and the source key:
first, for each target key, the source key with the same identifier as the target key is used as the source key corresponding to the target key, but of course, the source key with the same concept as the target key may also be used as the source key corresponding to the target key.
Second, for each target key, the source key having a logical association with the target key is used as the source key corresponding to the target key, wherein the source key having a logical association with the target key may include one of a calculation result that the value of the target key is based on the value of the source key corresponding to the target key and a logical operation result that the value of the target key is based on the value of the source key corresponding to the target key.
After the source key corresponding to the target key is determined in any of the above manners, the value of each target key may be filled according to the value of the source key corresponding to each target key, for example, the value of the source key corresponding to the target key may be directly used as the value of the target key, or the value of the source key corresponding to the target key may be calculated and used as the value of the target key, which is not limited in this specification.
S108: in response to a received data processing request, a target variable included in the data processing request is taken as a request variable, and a request operation performed on the request variable is determined.
S110: and processing the data information which takes the identifier corresponding to the request variable as a key in the target table according to the corresponding relation between the request variable and the identifier.
As described above, in the embodiments of the present specification, a user may input a data processing request in a data processing portal through a terminal to manage data information in a database by the data processing request. The data processing method provided by the specification comprises a first execution main body used for generating a target table, a second execution main body used for receiving a data processing request and mapping a request variable and a request operation in the data processing request to the target table, and a third execution main body used for processing data in the target table according to the data processing request mapped to the target table. The first execution main body, the second execution main body and the third execution main body may all be servers or terminals, which is not limited in this specification, and the first execution main body, the second execution main body and the third execution main body may all be the same execution main body, any two of the execution main bodies may be the same execution main body, or three different execution main bodies.
Because the corresponding relation is established between the key in the target table generated in the above manner and the target variable, after the data processing entry receives the data processing request input by the user, the request operation performed on the target variable as the request variable included in the data processing request can be mapped to the data information under the corresponding key in the target table through the corresponding relation, thereby realizing the effect of processing the data in the target table.
The data processing request input by the user includes a target variable to be processed as a request variable and a request operation to be executed on the request variable, at this time, from the user perspective, the target variable input by the interactive control on the data processing entry is service metadata, but after the target table is generated in the above manner, the target variable is the concept of a key corresponding to the target variable.
Through the corresponding relation between the target variable and the corresponding identifier, the request operation to be executed on the request variable in the data processing request can be mapped to the data under the corresponding key in the target table, so that the data in the target table can be processed.
In an embodiment of the present specification, target variables included in a data processing entry may not all directly have a correspondence relationship with key identifiers in a target table, and for target variables having a logical association with other target variables, a request operation performed on the target variable may be mapped to data in the target table by key identifiers corresponding to other target variables having a logical association with the target variable. In this case, the key identifier corresponding to another target variable having a logical association with the target variable may be referred to as the key identifier corresponding to the target variable.
For example, the service data variable C is a service data variable B constrained by the condition variable a, and at this time, the service data variable C has a logical association with the condition variable a and the service data variable B, and if the service data variable C does not directly correspond to a key in the target table, and the condition variable a and the service data variable B respectively correspond to keys in the target table, the request operation performed on the service data variable C can be mapped to data under the key corresponding to the condition variable a and the service data variable B in the target table through the logical association between the service data variable C and the condition variable a and the service data variable B.
Based on the method described above in fig. 1, by generating a unique identifier for a target variable and using the generated identifier as a key in a target table, each key included in the target table generation corresponds to the target variable, so that when a data processing request for the target table is received, data information in the target table can be processed by the correspondence between the target variable and the identifier.
In addition, in order to describe a complex service, an overall scene of the service is generally divided into a plurality of service processes, wherein each service process is a specific link executed in the overall service scene, and taking the service scene of online sales as an example, in an embodiment of the present specification, the overall service scene of online sales may be divided into a series of service processes of browsing goods, adding to a shopping cart, placing orders, shipping, and receiving goods to complete the series of service processes.
In an embodiment of this specification, for each business process, any one of the above manners may be adopted to generate a corresponding target table for the business process, where the target table at least includes a fact table, and a business data variable corresponding to the business process is stored in the fact table, and generally speaking, the business data variable corresponding to the business process is a variable for measuring the business data generated by the business process, such as the business data generated by the business process. In addition, the target table corresponding to the business process may further include at least one dimension table, where the dimension table stores the condition variables related to the business process, and of course, the condition variables related to the business process are the condition variables that organize the business data variables corresponding to the business process.
In an embodiment of this specification, a business data variable may only correspond to one business process, and a condition variable may observe business data variables of several business processes at the same time, so that the condition variable may correspond to several business processes. After the business process, the business data variables, and the condition variables are determined, a unique business process corresponding to the business data variable may be determined for each business data variable, and a corresponding business process may be selected for the condition variable.
In order to keep the key consistency of the condition variables in the target table generated by each business process, the business process can be selected for the condition variables by designing a bus matrix, namely, whether each pair of business process and condition variable corresponds to each other is determined. Fig. 3 is a design interface of a bus matrix exemplarily provided by this specification, in which whether there is a correspondence between each pair of business processes and condition variables is represented in a form of a table, and according to the above example, an entire business scenario of online sales is divided into a series of business processes of browsing commodities, adding to shopping carts, placing orders, delivering shipments, and completing receiving, where a first column includes the business processes in the business scenario, and a first row includes the condition variables in the business scenario of online sales: goods, orders, merchants, couriers and users, and each business process and each condition variable can be represented by symbols of corresponding positions of tables, wherein when a certain condition variable is not a condition variable related to a certain business process, a hollow circle symbol can be filled at the intersection position of the condition variable and the business process, and when a certain condition variable is a condition variable related to a certain business process, a hook symbol can be filled in the hollow circle at the intersection position of the condition variable and the business process, taking the courier as an example, in the two business processes of browsing goods and adding to a shopping cart, since the mailing of the goods is not generated, the salesman's condition variable is not related, and in the two business processes of delivering and receiving, since the mailing of the goods needs to be completed by the courier, therefore, the business process of delivery and receipt involves a condition variable of the courier. In an embodiment of the present specification, a user may determine a designed condition variable for each business process by checking a symbol indicating a correspondence between a business process and a condition variable. Of course, besides the hollow circle and the check symbol, any symbol may be used to represent the corresponding relationship between the business process and the condition variable, which is not limited in this specification.
In an embodiment of this specification, when processing Data information in a target table according to a Data processing request, a Data processing template for processing Data in a database may be obtained in advance, the generated template is a database statement, for example, the Data processing template may be written in a database model Manipulation Language (DML) in SQL Language, the Data processing template may include at least placeholders to be filled, in response to the received Data processing request, a DML statement for replacing a placeholder may be determined according to a target variable and a request operation included in the Data processing request, and the replaced Data processing template is output as a Data processing statement. Then, the user may input the obtained data processing statement into the database interface to process the data in the target table, and of course, the data processing platform may also process the data in the target table by the data processing statement, generate a display interface of the data processing result according to the executed data processing result, and display the display interface to the user.
Taking the request operation to be executed as an example of query, the DML statement for querying the data in the target table can be generated in the above manner, and input into the SQL statement interface, and the obtained query result is displayed in the above display interface.
When the request operation to be executed is to visualize a certain business data variable by a certain condition variable, the DML sentences which are arranged in descending order of the brands according to the sales quantity of the commodities of each brand can be input into the SQL sentence interface, so that the internal association between the sales quantity of the commodities and the brands can be observed.
Based on the same idea, the data processing method provided above for one or more embodiments of the present specification further provides a corresponding data processing apparatus, as shown in fig. 4.
Fig. 4 is a schematic diagram of a data processing apparatus provided in the present specification, the apparatus including: the device comprises a variable determining module, an identification corresponding module, a generating module, a data filling module, a request responding module and a data processing module, wherein:
a variable determination module 400 for determining a target variable;
an identifier correspondence module 402, configured to generate, for each target variable, a unique identifier for the target variable in a predetermined generation manner, and establish a correspondence between the generated identifier and the target variable;
a generating module 404, configured to generate a target table by using identifiers corresponding to target variables as keys; providing a data processing inlet for processing data in a target table according to the corresponding relation between each key and a target variable in the target table;
a data filling module 406, configured to determine keys included in a source table obtained in advance, and fill data included in the source table into a target table according to a correspondence between each key in the source table and each key in the target table;
a request response module 408, configured to, in response to the received data processing request, take a target variable included in the data processing request as a request variable, and determine a request action performed on the request variable;
and a data processing module 210, configured to process, according to the correspondence between the request variable and the identifier, the data information in the target table that uses the identifier corresponding to the request variable as a key according to the request action.
Optionally, the identifier corresponding module 402 is specifically configured to determine whether the target variable is a preset specified basic variable; if yes, determining the identifier of the specified basic variable according to the specified basic variable; if not, determining the identifier of the target variable according to the identifier corresponding to the specified basic variable which is logically associated with the target variable.
Optionally, the target variables include business data variables and condition variables, where the business data variables include a first business data variable and a second business data variable; the identifier corresponding module 402 is specifically configured to, if the target variable is a first service data variable or a condition variable, determine that the target variable is a specified basic variable; and if the target variable is the second business data variable.
Optionally, the data padding module 406 is specifically configured to use a key included in the target table as a target key, and use a key included in the source table as a source key; for each target key, taking a source key with the same identifier as the target key as a source key corresponding to the target key; or, for each target key, using a source key having a logical association with the target key as a source key corresponding to the target key; and filling the data information corresponding to the target key in the target table with the data information corresponding to the source key corresponding to the target key in the source table.
Optionally, the variable determining module 400 is specifically configured to determine a service scenario; determining each target variable under the service scene; dividing the service scene into a plurality of service processes; for each business process, selecting a target variable related to the business process from the target variables in the business scene as a target variable corresponding to the business process; the generating module 404 is specifically configured to generate a target table corresponding to the business process by using the identifier corresponding to each target variable corresponding to the business process as a key.
Optionally, the variable determining module 400 is specifically configured to determine a service data variable and a condition variable in the service scenario as each target variable in the service scenario; selecting a business data variable generated in the business process from the business data variables in the business scene; selecting a condition variable used for organizing a business data variable generated in the business process from the condition variables in the business scene; and taking the selected business data variable generated in the business process and the condition variable used for organizing the business data variable generated in the business process as the target variable corresponding to the business process.
Optionally, the generating module 404 is specifically configured to obtain a generating template for generating a data table, where the generating template at least includes a placeholder to be filled; and replacing the placeholders in the generated template by identifiers corresponding to the target variables, and obtaining the generated target table according to the replaced generated template.
The present specification also provides a computer-readable storage medium storing a computer program operable to execute the above-described data processing method.
The present specification also provides a schematic structural diagram of the electronic device shown in fig. 5. As shown in fig. 5, at the hardware level, the electronic device includes a processor, an internal bus, a memory, and a non-volatile memory, but may also include hardware required for other services. The processor reads the corresponding computer program from the nonvolatile memory into the memory and then runs the computer program to realize the data processing method.
Of course, besides the software implementation, the present specification does not exclude other implementations, such as logic devices or a combination of software and hardware, and the like, that is, the execution subject of the following processing flow is not limited to each logic unit, and may be hardware or logic devices.
In the 90 s of the 20 th century, improvements in a technology could clearly distinguish between improvements in hardware (e.g., improvements in circuit structures such as diodes, transistors, switches, etc.) and improvements in software (improvements in process flow). However, as technology advances, many of today's process flow improvements have been seen as direct improvements in hardware circuit architecture. Designers almost always obtain the corresponding hardware circuit structure by programming an improved method flow into the hardware circuit. Thus, it cannot be said that an improvement in the process flow cannot be realized by hardware physical modules. For example, a Programmable Logic Device (PLD), such as a Field Programmable Gate Array (FPGA), is an integrated circuit whose Logic functions are determined by programming the Device by a user. A digital system is "integrated" on a PLD by the designer's own programming without requiring the chip manufacturer to design and fabricate application-specific integrated circuit chips. Furthermore, nowadays, instead of manually making an Integrated Circuit chip, such Programming is often implemented by "logic compiler" software, which is similar to a software compiler used in program development and writing, but the original code before compiling is also written by a specific Programming Language, which is called Hardware Description Language (HDL), and HDL is not only one but many, such as abel (advanced Boolean Expression Language), ahdl (alternate Hardware Description Language), traffic, pl (core universal Programming Language), HDCal (jhdware Description Language), lang, Lola, HDL, laspam, hardward Description Language (vhr Description Language), vhal (Hardware Description Language), and vhigh-Language, which are currently used in most common. It will also be apparent to those skilled in the art that hardware circuitry that implements the logical method flows can be readily obtained by merely slightly programming the method flows into an integrated circuit using the hardware description languages described above.
The controller may be implemented in any suitable manner, for example, the controller may take the form of, for example, a microprocessor or processor and a computer-readable medium storing computer-readable program code (e.g., software or firmware) executable by the (micro) processor, logic gates, switches, an Application Specific Integrated Circuit (ASIC), a programmable logic controller, and an embedded microcontroller, examples of which include, but are not limited to, the following microcontrollers: ARC 625D, Atmel AT91SAM, Microchip PIC18F26K20, and Silicone Labs C8051F320, the memory controller may also be implemented as part of the control logic for the memory. Those skilled in the art will also appreciate that, in addition to implementing the controller as pure computer readable program code, the same functionality can be implemented by logically programming method steps such that the controller is in the form of logic gates, switches, application specific integrated circuits, programmable logic controllers, embedded microcontrollers and the like. Such a controller may thus be considered a hardware component, and the means included therein for performing the various functions may also be considered as a structure within the hardware component. Or even means for performing the functions may be regarded as being both a software module for performing the method and a structure within a hardware component.
The systems, devices, modules or units illustrated in the above embodiments may be implemented by a computer chip or an entity, or by a product with certain functions. One typical implementation device is a computer. In particular, the computer may be, for example, a personal computer, a laptop computer, a cellular telephone, a camera phone, a smartphone, a personal digital assistant, a media player, a navigation device, an email device, a game console, a tablet computer, a wearable device, or a combination of any of these devices.
For convenience of description, the above devices are described as being divided into various units by function, and are described separately. Of course, the functions of the various elements may be implemented in the same one or more software and/or hardware implementations of the present description.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include forms of volatile memory in a computer readable medium, Random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.
Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
As will be appreciated by one skilled in the art, embodiments of the present description may be provided as a method, system, or computer program product. Accordingly, the description may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the description may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
This description may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular tasks or implement particular abstract data types. The specification may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage devices.
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the system embodiment, since it is substantially similar to the method embodiment, the description is simple, and for the relevant points, reference may be made to the partial description of the method embodiment.
The above description is only an example of the present specification, and is not intended to limit the present specification. Various modifications and alterations to this description will become apparent to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present specification should be included in the scope of the claims of the present specification.

Claims (10)

1. A data processing method, comprising:
determining a target variable;
generating a unique identifier for each target variable in a predetermined generation mode, and establishing a corresponding relation between the generated identifier and the target variable;
generating a target table by taking the identifier corresponding to each target variable as a key; providing a data processing inlet for processing data in a target table according to the corresponding relation between each key and a target variable in the target table;
determining keys contained in a source table acquired in advance, and filling data contained in the source table into a target table according to the corresponding relation between each key in the source table and each key in the target table;
in response to the received data processing request, taking a target variable contained in the data processing request as a request variable, and determining a request operation executed on the request variable;
and processing the data information which takes the identifier corresponding to the request variable as a key in the target table according to the corresponding relation between the request variable and the identifier.
2. The method of claim 1, wherein generating a unique identifier for the target variable in a predetermined generation manner includes:
judging whether the target variable is a preset specified basic variable or not;
if yes, determining the identifier of the specified basic variable according to the specified basic variable;
if not, determining the identifier of the target variable according to the identifier corresponding to the specified basic variable which is logically associated with the target variable.
3. The method of claim 2, wherein target variables comprise business data variables and condition variables, wherein the business data variables comprise first business data variables and second business data variables;
judging whether the target variable is a preset specified basic variable, specifically comprising:
if the target variable is a first business data variable or a condition variable, judging that the target variable is a specified basic variable;
and if the target variable is the second business data variable, judging that the target variable is a non-specified basic variable.
4. The method according to claim 1, wherein filling data contained in the source table into the target table according to the correspondence between each key in the source table and each key in the target table specifically comprises:
taking the key contained in the target table as a target key and taking the key contained in the source table as a source key;
for each target key, taking a source key with the same identifier as the target key as a source key corresponding to the target key; or, for each target key, using a source key having a logical association with the target key as a source key corresponding to the target key;
and filling the data information corresponding to the target key in the target table with the data information corresponding to the source key corresponding to the target key in the source table.
5. The method of claim 1, wherein determining the target variable specifically comprises:
determining a service scene;
determining each target variable under the service scene; dividing the service scene into a plurality of service processes;
for each business process, selecting a target variable related to the business process from the target variables in the business scene as a target variable corresponding to the business process;
generating a target table by taking the identifier corresponding to each target variable as a key, wherein the method specifically comprises the following steps:
and generating a target table corresponding to the business process by taking the identifier corresponding to each target variable corresponding to the business process as a key.
6. The method of claim 5, wherein determining the target variables in the service scenario specifically comprises:
determining a business data variable and a condition variable under the business scene as each target variable under the business scene;
selecting a target variable related to the business process from the target variables in the business scene as a target variable corresponding to the business process, and specifically comprising the following steps:
selecting a business data variable generated in the business process from the business data variables in the business scene;
selecting a condition variable used for organizing a business data variable generated in the business process from the condition variables in the business scene;
and taking the selected business data variable generated in the business process and the condition variable used for organizing the business data variable generated in the business process as the target variable corresponding to the business process.
7. The method of claim 1, wherein generating the target table using the identifier corresponding to each target variable as a key specifically comprises:
acquiring a generation template for generating a data table, wherein the generation template at least comprises a placeholder to be filled;
and replacing the placeholders in the generated template by identifiers corresponding to the target variables, and obtaining the generated target table according to the replaced generated template.
8. A data processing apparatus, characterized in that the apparatus specifically comprises:
the variable determining module is used for determining a target variable;
the identification corresponding module is used for generating a unique identifier for each target variable in a predetermined generation mode and establishing a corresponding relation between the generated identifier and the target variable;
the generating module is used for generating a target table by taking the identifier corresponding to each target variable as a key; providing a data processing inlet for processing data in a target table according to the corresponding relation between each key and a target variable in the target table;
the data filling module is used for determining keys contained in a source table acquired in advance and filling data contained in the source table into the target table according to the corresponding relation between the keys in the source table and the keys in the target table;
the request response module is used for responding to the received data processing request, taking a target variable contained in the data processing request as a request variable and determining a request operation executed on the request variable;
and the data processing module is used for processing the data information which takes the identifier corresponding to the request variable as a key in the target table according to the corresponding relation between the request variable and the identifier.
9. A computer-readable storage medium, characterized in that the storage medium stores a computer program which, when executed by a processor, implements the method of any of the preceding claims 1 to 7.
10. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of any of claims 1 to 7 when executing the program.
CN202110732710.3A 2021-06-30 2021-06-30 Data processing method and device, storage medium and electronic equipment Active CN113377804B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110732710.3A CN113377804B (en) 2021-06-30 2021-06-30 Data processing method and device, storage medium and electronic equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110732710.3A CN113377804B (en) 2021-06-30 2021-06-30 Data processing method and device, storage medium and electronic equipment

Publications (2)

Publication Number Publication Date
CN113377804A true CN113377804A (en) 2021-09-10
CN113377804B CN113377804B (en) 2022-08-26

Family

ID=77580051

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110732710.3A Active CN113377804B (en) 2021-06-30 2021-06-30 Data processing method and device, storage medium and electronic equipment

Country Status (1)

Country Link
CN (1) CN113377804B (en)

Citations (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20110154253A1 (en) * 2009-12-21 2011-06-23 Matthias Lehr Process field extensibility for business objects
WO2016049350A1 (en) * 2014-09-28 2016-03-31 Alibaba Group Holding Limited Method and apparatus for determining media information associated with data stored in storage device
CN108021400A (en) * 2017-11-29 2018-05-11 腾讯科技(深圳)有限公司 Data processing method and device, computer-readable storage medium and equipment
CN109241026A (en) * 2018-07-18 2019-01-18 阿里巴巴集团控股有限公司 The method, apparatus and system of data management
US20190188198A1 (en) * 2017-12-19 2019-06-20 Fujitsu Limited Query generation method, query generation apparatus, and computer-readable recording medium
CN110222045A (en) * 2019-04-23 2019-09-10 平安科技(深圳)有限公司 A kind of data sheet acquisition methods, device and computer equipment, storage medium
CN110704721A (en) * 2019-10-10 2020-01-17 秒针信息技术有限公司 Client data processing method and device, terminal equipment and readable storage medium
CN111061733A (en) * 2019-12-10 2020-04-24 北京明略软件系统有限公司 Data processing method and device, electronic equipment and computer readable storage medium
CN111095195A (en) * 2018-03-15 2020-05-01 欧姆龙株式会社 Controller, control method, and control program
CN112685030A (en) * 2020-12-31 2021-04-20 北京三快在线科技有限公司 Method, device, storage medium and electronic equipment for generating service code
EP3819793A2 (en) * 2020-06-30 2021-05-12 Beijing Baidu Netcom Science Technology Co., Ltd. Query method, apparatus, electronic device and storage medium

Patent Citations (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20110154253A1 (en) * 2009-12-21 2011-06-23 Matthias Lehr Process field extensibility for business objects
WO2016049350A1 (en) * 2014-09-28 2016-03-31 Alibaba Group Holding Limited Method and apparatus for determining media information associated with data stored in storage device
CN108021400A (en) * 2017-11-29 2018-05-11 腾讯科技(深圳)有限公司 Data processing method and device, computer-readable storage medium and equipment
US20190188198A1 (en) * 2017-12-19 2019-06-20 Fujitsu Limited Query generation method, query generation apparatus, and computer-readable recording medium
CN111095195A (en) * 2018-03-15 2020-05-01 欧姆龙株式会社 Controller, control method, and control program
CN109241026A (en) * 2018-07-18 2019-01-18 阿里巴巴集团控股有限公司 The method, apparatus and system of data management
CN110222045A (en) * 2019-04-23 2019-09-10 平安科技(深圳)有限公司 A kind of data sheet acquisition methods, device and computer equipment, storage medium
CN110704721A (en) * 2019-10-10 2020-01-17 秒针信息技术有限公司 Client data processing method and device, terminal equipment and readable storage medium
CN111061733A (en) * 2019-12-10 2020-04-24 北京明略软件系统有限公司 Data processing method and device, electronic equipment and computer readable storage medium
EP3819793A2 (en) * 2020-06-30 2021-05-12 Beijing Baidu Netcom Science Technology Co., Ltd. Query method, apparatus, electronic device and storage medium
CN112685030A (en) * 2020-12-31 2021-04-20 北京三快在线科技有限公司 Method, device, storage medium and electronic equipment for generating service code

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
YUNKAI LIU 等: "《Graph Data Warehouse: Steps to Integrating Graph Databases Into the Traditional Conceptual Structure of a Data Warehouse》", 《IEEE》 *
谷俊: "异构数据库之间数据标准化工具的设计与实现", 《情报科学》 *

Also Published As

Publication number Publication date
CN113377804B (en) 2022-08-26

Similar Documents

Publication Publication Date Title
CN106557486A (en) A kind of storage method and device of data
US8510341B2 (en) System, method and structures for a reusable custom-defined nestable compound data type for construction of database objects
TWI682335B (en) Data object display method and device
US9495475B2 (en) Method of representing an XML schema definition and data within a relational database management system using a reusable custom-defined nestable compound data type
US20100131570A1 (en) Methods and structures for utilizing reusable custom-defined nestable compound data types to permit product variations within an exisitng taxonomy
CN107622080B (en) Data processing method and equipment
CN112015739A (en) Data verification and data query method and device
CN113535817B (en) Feature broad table generation and service processing model training method and device
CN111767499A (en) Page configuration method and device
CN108846069B (en) Document execution method and device based on markup language
CN108255471B (en) System configuration item configuration device, method and equipment based on configuration suite
CN111046052B (en) Method, device and equipment for storing operation records in database
CN113835692A (en) Dictionary data processing method and device, electronic equipment and computer storage medium
US9773003B2 (en) Computer implemented system and method for investigative data analytics
CN108241620B (en) Query script generation method and device
US10241899B2 (en) Test input information search device and method
CN113377804B (en) Data processing method and device, storage medium and electronic equipment
CN111026963A (en) Data query method and device, and configuration information setting method and device
US9230022B1 (en) Customizable result sets for application program interfaces
EP2887240A1 (en) Electronic product information display system
CN112800030B (en) Method and device for managing component data of flow and computer readable storage medium
CN112419073A (en) Information display method and device
CN112015702A (en) Message file name processing method, device and equipment
CN114692581A (en) Electronic form sub-table display method, device, equipment and storage medium
CN114282510B (en) Document generation method and device, storage medium and electronic equipment

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant