CN114168109A - Data processing method and device, electronic equipment and storage medium - Google Patents
Data processing method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN114168109A CN114168109A CN202111489424.5A CN202111489424A CN114168109A CN 114168109 A CN114168109 A CN 114168109A CN 202111489424 A CN202111489424 A CN 202111489424A CN 114168109 A CN114168109 A CN 114168109A
- Authority
- CN
- China
- Prior art keywords
- speech
- data table
- application programming
- normalized expression
- programming interface
- 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.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/10—Requirements analysis; Specification techniques
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/955—Retrieval from the web using information identifiers, e.g. uniform resource locators [URL]
- G06F16/9566—URL specific, e.g. using aliases, detecting broken or misspelled links
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/20—Natural language analysis
- G06F40/279—Recognition of textual entities
- G06F40/284—Lexical analysis, e.g. tokenisation or collocates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/40—Processing or translation of natural language
- G06F40/58—Use of machine translation, e.g. for multi-lingual retrieval, for server-side translation for client devices or for real-time translation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/38—Creation or generation of source code for implementing user interfaces
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/40—Transformation of program code
- G06F8/41—Compilation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Databases & Information Systems (AREA)
- Human Computer Interaction (AREA)
- Data Mining & Analysis (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The present disclosure relates to a data processing method, apparatus, electronic device, and storage medium. The data processing method includes the steps of acquiring a first part of speech used for building a data table, wherein the first part of speech can be information input by a user, normalizing the first part of speech into a second part of speech, namely normalizing the input information into standard information, generating a target data table based on the second part of speech, and then generating at least one application programming interface according to the target data table, wherein the application programming interface can be used for editing the target data table, for example, the part of speech can be added, the part of speech can be deleted, the part of speech can be modified and the like in the target data table through the application programming interface. The method provided by the disclosure can normalize the information input by the user into standard information, and generate the application programming interface with normalization based on the standard information, wherein the normalization application programming interface has stronger compatibility, and is convenient for maintaining and integrating the application programming interface subsequently.
Description
Technical Field
The present disclosure relates to the field of data processing technologies, and in particular, to a data processing method and apparatus, an electronic device, and a storage medium.
Background
At present, a data system development process generally includes steps of database development, backend interface development, front-end interface construction and the like. In the process of developing a database, technicians usually define parts of speech and data types thereof related in each project according to personal habits; when the development of the back-end interface and the construction of the front-end user interface are carried out, the target function is realized by writing a large amount of codes by using the self-defined word classes and the data types thereof.
However, in the database development process, a related developer needs to write a large number of table building sentences on a development platform, and names, styles and data types of parts of speech in the sentences are defined according to the habits of the developer. The development mode easily causes the data format of the peripheral system to be non-uniform, the data specification among project groups is non-uniform, the development of a rear-end interface, the construction of a front-end interface and the maintenance and integration of a system are inconvenient, and the development mode is not flexible.
In the development process of the backend Interface, a large amount of code is still needed to be written for developing an Application Programming Interface (API) in the prior art, so that two main problems exist in the development process of the backend Interface: first, there is no uniform specification for the word classes and domain definitions in the database, so the data is irregular when the application programming interface is developed. When the front-end interface and the rear-end interface need to be developed in a matched mode, mapping and unification of data information on two sides are needed, operation is complex, a large amount of manpower and material resources need to be consumed, the whole development process is poor in standardization, low in automation degree and poor in user experience.
Disclosure of Invention
In order to solve the above technical problem or at least partially solve the above technical problem, the present disclosure provides a data processing method, an apparatus, an electronic device, and a storage medium, which can normalize a first part of speech input by a user into a standard part of speech, generate a data table based on the standard part of speech, and generate an application programming interface with normativity according to the data table.
In a first aspect, an embodiment of the present disclosure provides a data processing method, including:
acquiring a first part of speech for constructing a data table;
normalizing the first part of speech into a second part of speech, and generating a target data table based on the second part of speech;
generating at least one application programming interface for editing the target data table based on the target data table, wherein different application programming interfaces correspond to different editing functions;
and editing the target data table in response to the calling operation of the at least one application programming interface.
Optionally, the method further comprises:
and generating a functional interface corresponding to the application programming interface based on the at least one application programming interface.
Optionally, normalizing the first part of speech to the second part of speech includes:
inquiring the corresponding relation between the pre-configured part of speech normalized expression and at least one non-normalized expression, and determining the part of speech normalized expression matched with the first part of speech;
and normalizing the first part of speech into a second part of speech based on the part of speech normalized expression matched with the first part of speech.
Optionally, querying a correspondence between a pre-configured part of speech normalized expression and at least one non-normalized expression, and determining the part of speech normalized expression matched with the first part of speech includes:
and if the target non-normalized expression is matched with the first part of speech, determining that the part of speech normalized expression matched with the first part of speech is the part of speech normalized expression corresponding to the target non-normalized expression.
Optionally, querying a correspondence between a pre-configured part of speech normalized expression and at least one non-normalized expression, and determining the part of speech normalized expression matched with the first part of speech includes:
if any non-normalized expression is not inquired to be matched with the first part of speech, determining a first basic part of speech and a first root word in the first part of speech;
if the normalized root word in any part of speech normalized expression is matched with the first root word, determining that the part of speech normalized expression matched with the first part of speech is composed of a first basic part of speech and the normalized root word;
and if the normalized basic word class in any word class normalized expression is matched with the first basic word class, determining that the word class normalized expression matched with the first word class is composed of the normalized basic word class and the first root word.
Optionally, the generating the target data table based on the second part of speech includes:
determining a second basic word class and a second root word in the second word class;
determining a target domain corresponding to the second root word based on a corresponding relation between the pre-configured root word and the domain;
and generating a target data table based on the second word class and the target domain.
Optionally, the generating at least one application programming interface for editing the target data table based on the target data table includes:
for any editing function, determining the name of a target data table and the name of a database storing the target data table as output parameters of the editing function;
determining each second part of speech included in the target data table as an input parameter of the editing function;
and generating an application programming interface corresponding to the editing function based on the output parameters, the input parameters and the preset editing logic corresponding to the editing function.
Optionally, generating a functional interface corresponding to the application programming interface based on at least one application programming interface includes:
responding to the operation of a button control in the configuration canvas, and displaying a property configuration interface, wherein a plurality of services are displayed in the property configuration interface, and each service corresponds to an application programming interface;
in response to the operation of selecting the target service, associating the button control with the application programming interface corresponding to the target service;
after the association is completed, displaying a component library, wherein the component library comprises a plurality of components, and each component corresponds to one parameter of an application programming interface corresponding to the target service;
in response to the dragging operation of any component in the component library, dropping the component at the position, where the dragging operation is finished, in the canvas;
and in response to the operation of triggering the interface generation, generating a functional interface of the application programming interface corresponding to the target service based on the canvas.
In a second aspect, an embodiment of the present disclosure provides a data processing apparatus, including:
the acquisition module is used for acquiring a first part of speech for constructing a data table;
the first generation module is used for normalizing the first part of speech into a second part of speech and generating a target data table based on the second part of speech;
the second generation module is used for generating at least one application programming interface for editing the target data table based on the target data table, and different application programming interfaces correspond to different editing functions;
and the response module is used for responding to the calling operation of at least one application programming interface and editing the target data table.
In a third aspect, an embodiment of the present disclosure provides an electronic device, including:
a memory;
a processor; and
a computer program;
wherein the computer program is stored in the memory and configured to be executed by the processor to implement the data processing method as described above.
In a fourth aspect, the disclosed embodiments provide a computer-readable storage medium, on which a computer program is stored, which, when executed by a processor, implements the steps of the data processing method as described above.
The embodiment of the disclosure provides a data processing method and device, electronic equipment and a storage medium. The data processing method comprises the steps of acquiring a first part of speech used for building a data table, wherein the first part of speech can be information input by a user, normalizing the first part of speech into a second part of speech, namely normalizing the input information into standard information, generating a target data table based on the second part of speech, and then generating at least one application programming interface according to the target data table, wherein the application programming interface can be used for editing the target data table, for example, the part of speech can be added, the part of speech can be deleted, the part of speech can be modified, the part of speech can be inquired, and the like in the target data table through the application programming interface. The method provided by the disclosure can standardize the information input by the user into standard information, the application programming interface generated by the data table generated based on the standard information also has normativity and strong compatibility, the subsequent maintenance and integration of the application programming interface are facilitated, the method is flexible, the processing speed is high, and the user experience is improved.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present disclosure and together with the description, serve to explain the principles of the disclosure.
In order to more clearly illustrate the embodiments or technical solutions in the prior art of the present disclosure, the drawings used in the description of the embodiments or prior art will be briefly described below, and it is obvious for those skilled in the art that other drawings can be obtained according to the drawings without inventive exercise.
Fig. 1 is a schematic flow chart of a data processing method according to an embodiment of the present disclosure;
fig. 2 is a schematic diagram of an application scenario provided by the embodiment of the present disclosure;
FIG. 3 is a schematic diagram of a functional interface provided by an embodiment of the present disclosure;
FIG. 4 is a schematic diagram of a front-end interface provided by an embodiment of the present disclosure;
fig. 5 is a schematic flow chart of a data processing method according to an embodiment of the present disclosure;
fig. 6 is a schematic flow chart of a data processing method according to an embodiment of the present disclosure;
fig. 7 is a schematic structural diagram of a data processing apparatus according to an embodiment of the present disclosure;
fig. 8 is a schematic structural diagram of an electronic device according to an embodiment of the present disclosure.
Detailed Description
In order that the above objects, features and advantages of the present disclosure may be more clearly understood, aspects of the present disclosure will be further described below. It should be noted that the embodiments and features of the embodiments of the present disclosure may be combined with each other without conflict.
In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present disclosure, but the present disclosure may be practiced in other ways than those described herein; it is to be understood that the embodiments disclosed in the specification are only a few embodiments of the present disclosure, and not all embodiments.
In view of the above technical problems, embodiments of the present disclosure provide a data processing method, which is described in detail by one or more embodiments below, and when describing the data processing method, terms and concepts related to the method are introduced preferentially.
Metadata (Metadata), also called intermediary data and relay data, is data describing data (about data) or structural data (structured data) for providing information about a certain resource, and is mainly information describing data attribute (property) for supporting functions such as indicating storage location, history data, resource search, file record, and the like.
And managing metadata, namely performing standardized definition and management on parts of speech, roots of words and domains.
Root of a word, normalized noun. Such as name, type, and number, etc.
And the part of speech consists of a basic part of speech and a root word. Such as user name, user type, item label, etc., the user may understand the base part of speech.
The field defines the type of the part of speech and the number of characters (length) that can be stored, and the field can also be called field type in the file system and refers to the basic unit that can not be distinguished in the data. For example, it may be described by data type binary, character, string, etc.
The data item, which is composed of parts of speech and domains, is a basic attribute feature of the data table.
And the data table is composed of at least one data item.
Fig. 1 is a schematic flow chart of a data processing method according to an embodiment of the present disclosure, which specifically includes the following steps S110 to S140 shown in fig. 1:
and S110, acquiring a first part of speech for constructing the data table.
As shown in fig. 2, fig. 2 is a schematic diagram of an application scenario provided in the embodiment of the present disclosure. The data processing method in the present disclosure may be executed by the terminal 21 or the server 20. In a possible implementation manner, the terminal 21 is configured with a metadata management platform, and the server 20 may be a server corresponding to the metadata management platform. The terminal 21 obtains a first part of speech input by a user through the metadata management platform, normalizes the first part of speech, sends a second part of speech normalized by the first part of speech to the server 20, and the server 20 generates an application programming interface according to the second part of speech. In another possible implementation manner, the server 20 is configured with a metadata management platform, obtains a first part of speech input by a user through the metadata management platform, normalizes the first part of speech, and then generates an application programming interface according to a second part of speech normalized by the first part of speech. The method for implementing data processing by the terminal 21 is the same as that of the server 20, and will not be described herein. It is understood that the application scenario shown in fig. 2 is only an illustrative illustration and is not particularly limited. In addition, the present embodiment also does not specifically limit the metadata management platform, and for example, the metadata management platform may be a platform capable of receiving and normalizing data. The data processing method will be described below by taking the server 20 as an example.
Understandably, the server 20 obtains a first part of speech for constructing the data table, where the first part of speech may be information input by the user on the metadata management platform, and for example, the first part of speech may be a user name, or a user name, etc.
S120, normalizing the first part of speech into a second part of speech, and generating a target data table based on the second part of speech.
At present, in the database development process, that is, in the data management process, related developers need to compile a large number of table building statements on a development platform, names, styles and data types of word classes in the table building statements are defined according to habits of the developers, and data specifications among project groups are not uniform, that is, the table building statements compiled based on each project cannot be used in a related manner, the names of the word classes and word roots in the statements are different, interface development is not facilitated by a backend based on a table building language, and maintenance and integration among interfaces are not flexible.
It can be understood that, on the basis of the above S110, in order to solve the above problem, the metadata management platform provided in the embodiment of the present disclosure normalizes the acquired first part of speech to generate a second part of speech, that is, normalizes the information input by the user, and the metadata management platform can automatically convert the input information into standard and normative information according to the specification set in the platform. The specification set in the platform can be set by the user according to the requirement, and the specification can be used for directly specifying the information input by the user into standard English information, or can be used for translating the input Chinese information (a first word class) into English and specifying the translated English into standard English (a second word class) information. For example, the input Chinese information is a User Name, the User Name is translated into an English User Name, and then the User Name is normalized into Ur _ nm, wherein the Ur _ nm is called a second part of speech, the part of speech is composed of a basic part of speech and a root of speech, the Ur is the basic part of speech, and the nm is the root of speech; for example, the input information is User _ Name or User _ Name, and the input information is directly normalized into a second part of speech Ur _ nm; for another example, the input information is a Currency Code, the Currency Code is translated into english, wherein the english in the Currency is Currency, the english in the Code is Code, standard english information (a second part of speech) corresponding to the Currency Code is determined according to the translated english, the second part of speech of the standard part of speech of the first part of speech Currency Code may be CcyCd, wherein Ccy is a basic word, and Cd is a root word.
Optionally, the generating the target data table based on the second part of speech in S120 specifically includes: determining a second basic word class and a second root word in the second word class; determining a target domain corresponding to the second root word based on a corresponding relation between the pre-configured root word and the domain; and generating a target data table based on the second word class and the target domain.
Understandably, the metadata management platform determines a second basic word class and a second root word in the normalized second word class, for example, in the normalized second word class Ur _ nm, Ur is the second basic word class, and nm is the second root word; and then, based on the corresponding relation between the pre-configured root word and the domain, determining a target domain corresponding to the second root word, namely a second root word matching domain, wherein the domain defines the data type, the value range, the display mode of the control and the data content judgment rule corresponding to the second part of speech. For example, the data type in the domain corresponding to the second root nm may be a character string, and may further include a length of the character string, a display mode of the component, and the like, where the display mode may be a pull-down selection mode or an input mode; and forming a data item according to the second part of speech and the target domain, and generating a data table from the data item. It is understood that, a user may input a plurality of first parts of speech at a time on the metadata management platform, determine a data item corresponding to each first part of speech, and generate a data table according to the plurality of data items, that is, the data table includes at least one data item, and the number of input first parts of speech is not limited.
For example, referring to table 1, table 1 is a table of a plurality of data items composed of a second part of speech and a target domain, and the data item corresponding to each first part of speech determined according to a plurality of first parts of speech input by a user may be stored in the form of table 1, or may be stored in a text manner, and a specific storage form is not limited. Each data item includes a part of speech and a field, each part of speech is composed of a basic part of speech and a root word, a row with a sequence number 1 in table 1 is a data item, a row with a sequence number 2 is also a data item, table 1 includes 3 data items, wherein a Cocos in a part of speech Cocos _ uid is a basic part of speech, a uid is a root word, a field of the part of speech Cocos _ uid (a second part of speech) is VARCHAR (20), the VARCHAR represents a data type of the part of speech, a place in a place _ id of the part of speech is a basic part of speech, an id is a root word, specifically, the VARCHAR is used for representing character data, a variable-length character string can also be stored in the VARCHAR, 20 represents the length of the character string, and other data items include data items whose contents correspond to sequence number 1, which is not described here.
TABLE 1
| Serial number | Part of speech | Domain |
| 1 | Cocos_uid | VARchar(20) |
| 2 | Cocos_appid | VARchar(45) |
| 3 | Placement_id | VARchar(45) |
It can be understood that the generated target data table includes the content in each data item, specifically, the content of the second part of speech in each data item, that is, the second part of speech can be understood as the header of the target data table, the domain of the second part of speech limits the format of the information that can be input in the region corresponding to the second part of speech in the target data table, for example, the type of the target data table is an information registration table, the second part of speech may be a user name, a birth date, an identification number, a mobile phone number, and the like, the user name, the birth date, the identification number, and the mobile phone number may be used as a header of the target data table, a field of the mobile phone number of the second part of speech may be set as char (11), wherein char is integer data, which is a basic data type that can only accommodate a single character in computer programming language, and 11 is the length of the character, that is, 11 numbers can be input in the input area corresponding to the mobile phone number.
S130, generating at least one application programming interface for editing the target data table based on the target data table, wherein different application programming interfaces correspond to different editing functions.
It can be understood that, on the basis of the above S120, after the target data table is generated according to the second part of speech of the specification, the server may continue to generate at least one application programming interface based on the target data table, specifically, select the input/output parameter in the target data table, automatically generate the target application programming interface corresponding to the target function (add, delete, search, repair), and generate at least one application programming interface based on each data item in the target data table, the application programming interface may be used to edit an editable area in the target data table, the editable area may be understood as an area capable of editing data other than the header, and different application programming interfaces correspond to different editing functions, and the application programming interfaces may be an add interface, a delete interface, a modify interface, and a query interface, which are respectively added, deleted, modified, or modified correspondingly, Editing functions such as modification and inquiry.
And S140, responding to the calling operation of at least one application programming interface, and editing the target data table.
It is understood that, on the basis of the above S130, after the at least one application programming interface is generated, in response to a call operation of the application programming interface, the target data table is edited, for example, data may be added to the target data table by adding the interface, data in the target data table may be deleted by deleting the interface, data in the target data table may be modified by modifying the interface, and data in the data table may be queried by querying the interface.
Optionally, the method further comprises: and generating a functional interface corresponding to the application programming interface based on the at least one application programming interface.
It is understood that corresponding function interfaces can be created for the application programming interfaces, for example, an add interface is created for an add interface, a delete interface is created for a delete interface, a modify interface is created for a modify interface, and the like, and data is added to the target data table or deleted from the target data table or data in the target data table is modified through input of each function interface.
Optionally, generating a functional interface corresponding to the application programming interface specifically includes: responding to the operation of a button control in the configuration canvas, and displaying a property configuration interface, wherein a plurality of services are displayed in the property configuration interface, and each service corresponds to an application programming interface; in response to the operation of selecting the target service, associating the button control with the application programming interface corresponding to the target service; after the association is completed, displaying a component library, wherein the component library comprises a plurality of components, and each component corresponds to one parameter of an application programming interface corresponding to the target service; in response to the dragging operation of any component in the component library, dropping the component at the position, where the dragging operation is finished, in the canvas; and in response to the operation of triggering the interface generation, generating a functional interface of the application programming interface corresponding to the target service based on the canvas.
It can be understood that the service end provides a canvas, the canvas is used for developing and setting the function interface of the generated application programming interface, can develop respective function interfaces of 'adding', 'deleting', 'searching' and 'modifying', for example, taking the development of the 'adding' function interface as an example, after a button is added in the canvas, an attribute configuration interface can be directly displayed, an attribute configuration interface can be displayed by a retransmission button, and then the button is configured by the attribute configuration interface, a plurality of services can be displayed in the attribute configuration interface in a form of a drop-down box, each service corresponds to one function, namely, each application programming interface realizes one function, the application programming interface can be understood as a service, the functions refer to the functions of adding, deleting, modifying and querying, and the button is associated with an adding interface (adding API) when the service 1 is selected (corresponding to the 'adding' function), the button may be a configure to save button, ok button, or other button. After the interface is added to the button in association, a component library is displayed, where the component library includes multiple components, each component corresponds to one parameter of the added interface, and the parameter is a data item in the target data table, for example, the added interface has 3 input parameters and 2 output parameters, then 5 components are displayed in the component library, each component corresponds to one parameter, and each parameter is one data item. The constraint of each component is defined by the domain of the target data item corresponding to the component, the domain of the target data item defines the display mode, the name, the data type, the value range, the data constraint and the like of the component, then the component can be dragged into the canvas to realize the layout and development of the function interface of adding, and after the user clicks and saves, the development of the function interface of adding is completed.
Illustratively, referring to fig. 3, fig. 3 is a schematic diagram of a development interface provided by an embodiment of the present disclosure, the canvas 310 and the property configuration interface 320 are included in fig. 3, which is illustrated by the example of generating the "add" function interface, adding a button 311 to canvas 310, canvas 310 may display a button 321, the name of which may be named save, the button may be named save button 311, then save button 311 is triggered, the save button 311 may be configured with services in the property configuration interface 320, including a drop-down list of service choices 321 in the property configuration interface 320, a plurality of services, including service 1 to service 4, can be seen in the service selection list 321, and corresponding services can be selected for the save button 311, if service 1 corresponds to an add function implemented by an add interface, clicking on service 1 in the property configuration interface 320 associates the save button 311 with the add interface. After the save button 311 is associated with the add interface, a component library of the service 1 is displayed, the component library 310 of the service 1 includes 5 components, the components 1 to 3 may be regarded as 3 input parameters in the add interface, the components 4 and 5 may be regarded as 2 output parameters in the add interface, or the components 1 to 5 in the component library may be directly dragged to the canvas 310, after the layout and development of the add interface in the canvas are completed, the add interface is as shown in 340 in fig. 3 and is denoted as an add interface 340, a component corresponding to 3 input parameters may be set in the add interface 340, a user only needs to input information to be added in the target data table, a component corresponding to 3 input parameters is denoted as 342, an input box corresponding to 3 components is denoted as 341, the add interface 340 further includes a save button 343, information is input in an input box corresponding to the components 1 to 3 in the add interface 340, and after the save button 343 is clicked, data can be added to the target data table through the adding interface.
It can be understood that after the functional interface corresponding to the application programming interface is generated, a network address corresponding to the functional interface is generated after the functional interface is stored, and the network address is also called a Uniform Resource Locator (URL), so that when the front-end interface is developed, a button control labeled "add" on the front-end interface can be associated with the network address to develop the front-end interface. And after the front-end interface is developed, responding to the triggering operation of the button control in the front-end interface, and opening a functional interface corresponding to the network address.
Illustratively, referring to fig. 4, fig. 4 is a schematic diagram of a front-end interface provided by an embodiment of the present disclosure, in fig. 4, the front-end interface 400 is included, the front-end interface 400 includes an operation area and a data table display area 450, where the operation area includes an add button 410, a query button 420, a delete button 430, and a modify button 440, and the data display area 450 includes an editable area 451. After the triggering operation of the add button 410 is responded, a triggering interface 460 is displayed, the triggering interface 460 is an add interface 470 associated with the add button 410 and directly displayed on the basis of the triggering interface 400, the layout of the add interface in fig. 3 can be seen in the add interface 470, after information is input in an input frame corresponding to each component in the add interface 470, a save button (the save button is associated with the add interface) is clicked, and then the add interface is called, so that the function of adding data in the editable area 451 of the front-end interface is realized.
The embodiment of the disclosure provides a data processing method and device, electronic equipment and a storage medium. The data processing method comprises the steps of acquiring a first part of speech used for building a data table, wherein the first part of speech can be information input by a user, normalizing the first part of speech into a second part of speech, namely normalizing the input information into standard information, generating a target data table based on the second part of speech, and then generating at least one application programming interface according to the target data table, wherein the application programming interface can be used for editing the target data table, for example, the part of speech can be added, the part of speech can be deleted, the part of speech can be modified, the part of speech can be inquired, and the like in the target data table through the application programming interface. The method provided by the disclosure can standardize the information input by the user into standard information, the application programming interface generated by the data table generated based on the standard information also has normativity and strong compatibility, the subsequent maintenance and integration of the application programming interface are facilitated, the method is flexible, the processing speed is high, and the user experience is improved.
On the basis of the foregoing embodiment, fig. 5 is a flowchart illustrating a data processing method according to an embodiment of the present disclosure, and optionally, the step S120 of normalizing the first part of speech into the second part of speech specifically includes the following steps S510 to S520 shown in fig. 5:
s510, inquiring the corresponding relation between the pre-configured part of speech normalized expression and at least one non-normalized expression, and determining the part of speech normalized expression matched with the first part of speech.
It can be understood that, the query is about the corresponding relationship between the pre-configured word-class normalized expression and at least one non-normalized expression, that is, the corresponding relationship between the multiple word-class normalized expressions and the non-normalized expressions is pre-established in the metadata management platform, the word-class normalized expression is the second word-class, for example, the second word-class Ur _ nm, and the cos _ uid in the above table 1 are word-class normalized expressions, the word-class non-normalized expression may be the input information (the first word-class) or the corresponding information when the input information is translated into english, for example, the input information User Name, User _ Name, Username and User _ Name, or the input information may be a User Name, etc., the english User Name and the User Name may be translated into english, wherein the User Name, User _ Name, Username and Username may be referred to as non-normalized expressions, the Ur _ nm can be regarded as a part-of-speech normalized expression corresponding to a part-of-speech non-normalized expression such as a User Name, a User Name and a User Name, and the part-of-speech normalized expression matched with the input first part-of-speech is the Ur _ nm.
Optionally, the step S510 specifically includes: and if the target non-normalized expression is matched with the first part of speech, determining that the part of speech normalized expression matched with the first part of speech is the part of speech normalized expression corresponding to the target non-normalized expression.
It can be understood that if a target non-normalized expression matched with the first part of speech is queried, that is, a corresponding relationship between a non-normalized expression matched with the first part of speech and a part of speech normalized expression exists in the metadata management platform, the part of speech normalized expression corresponding to the target non-normalized expression can be directly determined as the part of speech normalized expression matched with the first part of speech, for example, the first part of speech is a User Name, the User Name can be translated into an english User Name, and if the corresponding relationship between the non-normalized expression User Name and the part of speech normalized expression Ur _ nm is queried, the part of speech normalized expression of the first part of speech can be directly determined as Ur _ nm.
Optionally, the step S510 specifically further includes: if any non-normalized expression is not inquired to be matched with the first part of speech, determining a first basic part of speech and a first root word in the first part of speech; if the normalized root word in any part of speech normalized expression is matched with the first root word, determining that the part of speech normalized expression matched with the first part of speech is composed of a first basic part of speech and the normalized root word; and if the normalized basic word class in any word class normalized expression is matched with the first basic word class, determining that the word class normalized expression matched with the first word class is composed of the normalized basic word class and the first root word.
Understandably, if a target non-normalized expression matched with the first part of speech is not inquired, determining a first basic part of speech and a first root word in the first part of speech, namely, the first part of speech input by the user does not have a matched part of speech non-normalized expression, determining the first root word and the first basic part of speech in the first part of speech, for example, the first part of speech input by the user is a name, translating the name into english to be a Full name, the Full name can also be marked as the first part of speech, and if the part of speech matched with the Full name is not inquired, determining the first basic part of speech Full name and the first root word name in the first part of speech Full name; if the normalized basic word class in any word class normalized expression is matched with the first basic word class, namely whether the normalized basic word class matched with the first basic word class exists in the word class normalized expression is inquired, for example, the normalized basic word class User matched with the first basic word class Full exists in the word class normalized expression, determining that the initial word class normalized expression matched with the first word class is composed of the normalized basic word class and the first root word, namely the initial word class normalized expression matched with the first word class is the User name; similarly, if the normalized root word in any part of speech normalized expression is matched with the first root word, determining that the initial part of speech normalized expression matched with the first part of speech is composed of the first basic part of speech and the normalized root word.
S520, normalizing the first part of speech into a second part of speech based on the part of speech normalized expression matched with the first part of speech.
It is understood that, on the basis of the above S510, after determining the initial part-of-speech normalized expression corresponding to the first part-of-speech, the corresponding relationship between the queried pre-configured part-of-speech normalized expression and at least one non-normalized expression is further determined, in this case, the initial part-of-speech normalized expression corresponding to the first part-of-speech determined based on S510 may be understood as a part-of-speech non-normalized expression, and then the first part-of-speech is normalized to the second part-of-speech, that is, the corresponding part-of-speech normalized expression Ur _ nm is determined according to the initial part-of-speech normalized expression User name.
The data processing method provided by the embodiment of the disclosure determines a normalized part of speech expression matched with a first part of speech by querying a corresponding relationship between a pre-configured normalized part of speech expression and at least one non-normalized expression, then normalizes the first part of speech into a second part of speech based on the normalized part of speech expression matched with the first part of speech, when the normalized part of speech corresponding to the first part of speech cannot be directly determined according to the first part of speech, can determine a first basic part of speech and a first root word in the first part of speech, respectively match according to the first basic part of speech and the first root word, if the normalized basic part of speech matched with the first basic part of speech is matched, can determine that the normalized part of speech matched with the first part of speech is composed of the normalized basic part of speech and the first root word, or, if the normalized part of speech matched with the first root word is matched, can determine that the normalized part of speech matched with the first part of speech is composed of the normalized basic part of speech and the normalized root word, the first part of speech can be normalized to the maximum extent, the method is flexible, and the user experience is good.
In the development process of the backend interface, the development of the application programming interface in the prior art still needs a large amount of code writing, and the situation causes two main problems in the development process of the backend interface: first, there is no uniform specification for the word classes and domain definitions in the database, so the data is irregular when the application programming interface is developed. When front end interface and rear end interface need the cooperation development, need map and unify the data information on both sides, complex operation, secondly, need technical staff to write a large amount of codes manually in the whole rear end interface development process, need consume a large amount of manpower and materials, whole development flow standardization is than poor, and degree of automation is than low, and user experience is also than poor. Therefore, in order to solve the above problem, on the basis of the above embodiments, the data processing method provided by the embodiments of the present disclosure generates at least one application programming interface for editing a target data table based on the target data table, and specifically includes the following steps S610 to S630 as shown in fig. 6:
s610, for any editing function, determining the name of the target data table and the name of the database storing the target data table as the output parameters of the editing function.
It is understood that for any editing function, the editing function may be an add function, a delete function, a modify function, and a query function, and the name of the target data table and the name of the database storing the target data table are determined as output parameters of the editing function, and the output parameters may be understood as the database to which the edited data is directed and a specific data table in the database, and taking the add function as an example, the output parameters may be understood as to which data table in which the added data is to be written, that is, an explicitly edited data table.
And S620, determining each second part of speech included in the target data table as an input parameter of the editing function.
It can be understood that, on the basis of the above S610, each second word class included in the target data table is determined as an input parameter of the editing function, that is, information input by the user is determined, for example, the target data table is an information data table, a name, a birth date, a mobile phone number and the like in the second word class are used as input parameters of the add-on function, then, related information of the name, the birth date and the mobile phone number can be input in the add-on interface at one time, and in response to a save button in the add-on interface, the input basic information is written into an area corresponding to the name, the birth date and the mobile phone number in the target data table.
And S630, generating an application programming interface corresponding to the editing function based on the output parameters, the input parameters and the preset editing logic corresponding to the editing function.
Understandably, on the basis of the above S620, based on the input/output parameters determined by each second part of speech in the target data table and the preset editing logic corresponding to the editing function, the application programming interface corresponding to the editing function is automatically generated, where the preset editing logic corresponding to the editing function may be a logic set according to the user' S requirement, for example, the editing logic corresponding to each of the adding function, the deleting function, the modifying function, and the querying function may be preset.
The data processing method provided by the embodiment of the disclosure determines the name of the target data table and the name of the database storing the target data table as the output parameter of the editing function, determines each second part of speech included in the target data table as the input parameter of the editing function, and generates the application programming interface corresponding to the editing function based on the output parameter, the input parameter and the preset editing logic corresponding to the editing function.
Fig. 7 is a schematic structural diagram of a data processing apparatus according to an embodiment of the present disclosure. The data processing apparatus provided by the embodiment of the present disclosure may execute the processing flow provided by the above data processing method embodiment, as shown in fig. 7, the data processing apparatus 700 includes:
a first generating module 710, configured to normalize the first part of speech to a second part of speech, and generate a target data table based on the second part of speech;
a second generating module 720, configured to generate at least one application programming interface for editing the target data table based on the target data table, where different application programming interfaces correspond to different editing functions;
the response module 730 is configured to edit the target data table in response to a call operation of at least one application programming interface.
Optionally, the apparatus 700 further includes a third generating module, where the third generating module is specifically configured to:
and generating a functional interface corresponding to the application programming interface based on the at least one application programming interface.
Optionally, the normalizing the first part of speech into the second part of speech in the first generating module 710 includes:
inquiring the corresponding relation between the pre-configured part of speech normalized expression and at least one non-normalized expression, and determining the part of speech normalized expression matched with the first part of speech;
and normalizing the first part of speech into a second part of speech based on the part of speech normalized expression matched with the first part of speech.
Optionally, the querying, in the first generating module 710, a correspondence between a pre-configured part of speech normalized expression and at least one non-normalized expression, and determining the part of speech normalized expression matched with the first part of speech includes:
and if the target non-normalized expression is matched with the first part of speech, determining that the part of speech normalized expression matched with the first part of speech is the part of speech normalized expression corresponding to the target non-normalized expression.
Optionally, the querying, in the first generating module 710, a correspondence between a pre-configured part of speech normalized expression and at least one non-normalized expression, and determining the part of speech normalized expression matched with the first part of speech includes:
if any non-normalized expression is not inquired to be matched with the first part of speech, determining a first basic part of speech and a first root word in the first part of speech;
if the normalized root word in any part of speech normalized expression is matched with the first root word, determining that the part of speech normalized expression matched with the first part of speech is composed of a first basic part of speech and the normalized root word;
and if the normalized basic word class in any word class normalized expression is matched with the first basic word class, determining that the word class normalized expression matched with the first word class is composed of the normalized basic word class and the first root word.
Optionally, the generating the target data table based on the second part of speech in the first generating module 710 includes:
determining a second basic word class and a second root word in the second word class;
determining a target domain corresponding to the second root word based on a corresponding relation between the pre-configured root word and the domain;
and generating a target data table based on the second word class and the target domain.
Optionally, the generating at least one application programming interface for editing the target data table based on the target data table in the second generating module 720 includes:
for any editing function, determining the name of a target data table and the name of a database storing the target data table as output parameters of the editing function;
determining each second part of speech included in the target data table as an input parameter of the editing function;
and generating an application programming interface corresponding to the editing function based on the output parameters, the input parameters and the preset editing logic corresponding to the editing function.
Optionally, the generating, by the third generating module, a functional interface corresponding to the application programming interface based on at least one application programming interface includes:
responding to the operation of a button control in the configuration canvas, and displaying a property configuration interface, wherein a plurality of services are displayed in the property configuration interface, and each service corresponds to an application programming interface;
in response to the operation of selecting the target service, associating the button control with the application programming interface corresponding to the target service;
after the association is completed, displaying a component library, wherein the component library comprises a plurality of components, and each component corresponds to one parameter of an application programming interface corresponding to the target service;
in response to the dragging operation of any component in the component library, dropping the component at the position, where the dragging operation is finished, in the canvas;
and in response to the operation of triggering the interface generation, generating a functional interface of the application programming interface corresponding to the target service based on the canvas.
The data processing apparatus in the embodiment shown in fig. 7 may be configured to execute the technical solutions of the above method embodiments, and the implementation principles and technical effects are similar, which are not described herein again.
Fig. 8 is a schematic structural diagram of an electronic device according to an embodiment of the present disclosure. The electronic device provided in the embodiment of the present disclosure may execute the processing procedure provided in the above embodiment, as shown in fig. 8, the electronic device 800 includes: a processor 810, a communication interface 820, and a memory 830; wherein the computer program is stored in the memory 830 and is configured to be executed by the processor 810 for performing the data processing method as described above.
In addition, the embodiment of the present disclosure also provides a computer readable storage medium, on which a computer program is stored, the computer program being executed by a processor to implement the data processing method described in the above embodiment.
Furthermore, the embodiments of the present disclosure also provide a computer program product, which includes a computer program or instructions, and the computer program or instructions implement the data processing method as described above when executed by a processor.
It is noted that, in this document, relational terms such as "first" and "second," and the like, may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, 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 identical elements in a process, method, article, or apparatus that comprises the element.
The foregoing are merely exemplary embodiments of the present disclosure, which enable those skilled in the art to understand or practice the present disclosure. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the disclosure. Thus, the present disclosure is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (11)
1. A data processing method, comprising:
acquiring a first part of speech for constructing a data table;
normalizing the first part of speech into a second part of speech, and generating a target data table based on the second part of speech;
generating at least one application programming interface for editing the target data table based on the target data table, wherein different application programming interfaces correspond to different editing functions;
and editing the target data table in response to the calling operation of the at least one application programming interface.
2. The method of claim 1, further comprising:
and generating a functional interface corresponding to the application programming interface based on the at least one application programming interface.
3. The method of claim 2, wherein the generating a functional interface corresponding to the application programming interface based on the at least one application programming interface comprises:
responding to the operation of a button control in the configuration canvas, and displaying a property configuration interface, wherein a plurality of services are displayed in the property configuration interface, and each service corresponds to an application programming interface;
in response to an operation of selecting a target service, associating the button control with an application programming interface corresponding to the target service;
after the association is completed, displaying a component library, wherein the component library comprises a plurality of components, and each component corresponds to one parameter of an application programming interface corresponding to the target service;
in response to the dragging operation of any component in the component library, dropping the component at the position, in the canvas, of the end of the dragging operation;
and responding to the operation of triggering interface generation, and generating a functional interface of an application programming interface corresponding to the target service based on the canvas.
4. The method of claim 1, wherein the normalizing the first part of speech to a second part of speech comprises:
inquiring the corresponding relation between a pre-configured part of speech normalized expression and at least one non-normalized expression, and determining the part of speech normalized expression matched with the first part of speech;
and normalizing the first part of speech into a second part of speech based on the part of speech normalized expression matched with the first part of speech.
5. The method according to claim 4, wherein said querying a correspondence between a pre-configured part of speech normalized expression and at least one non-normalized expression, and wherein determining the part of speech normalized expression matched by the first part of speech comprises:
and if the target non-normalized expression is matched with the first part of speech, determining that the part of speech normalized expression matched with the first part of speech is the part of speech normalized expression corresponding to the target non-normalized expression.
6. The method according to claim 4, wherein said querying a correspondence between a pre-configured part of speech normalized expression and at least one non-normalized expression, and wherein determining the part of speech normalized expression matched by the first part of speech comprises:
if any non-normalized expression is not inquired to be matched with the first part of speech, determining a first basic part of speech and a first root word in the first part of speech;
if the normalized root word in any part of speech normalized expression is matched with the first root word, determining that the part of speech normalized expression matched with the first part of speech is composed of the first basic part of speech and the normalized root word;
if the normalized basic word class in any word class normalized expression is inquired to be matched with the first basic word class, determining that the word class normalized expression matched with the first word class is composed of the normalized basic word class and the first root word.
7. The method of claim 1, wherein generating the target data table based on the second part of speech comprises:
determining a second basic word class and a second root word in the second word class;
determining a target domain corresponding to the second root word based on a corresponding relation between the pre-configured root word and the domain;
and generating a target data table based on the second part of speech and the target domain.
8. The method of claim 1, wherein generating at least one application programming interface for editing the target data table based on the target data table comprises:
for any editing function, determining the name of the target data table and the name of a database storing the target data table as output parameters of the editing function;
determining each second part of speech included in the target data table as an input parameter of the editing function;
and generating an application programming interface corresponding to the editing function based on the output parameters, the input parameters and the preset editing logic corresponding to the editing function.
9. A data processing apparatus, comprising:
the acquisition module is used for acquiring a first part of speech for constructing a data table;
the first generation module is used for normalizing the first part of speech into a second part of speech and generating a target data table based on the second part of speech;
the second generation module is used for generating at least one application programming interface for editing the target data table based on the target data table, and different application programming interfaces correspond to different editing functions;
and the response module is used for responding to the calling operation of the at least one application programming interface and editing the target data table.
10. An electronic device, comprising:
a memory;
a processor; and
a computer program;
wherein the computer program is stored in the memory and configured to be executed by the processor to implement the data processing method of any one of claims 1 to 8.
11. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the data processing method according to any one of claims 1 to 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111489424.5A CN114168109A (en) | 2021-12-08 | 2021-12-08 | Data processing method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111489424.5A CN114168109A (en) | 2021-12-08 | 2021-12-08 | Data processing method and device, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114168109A true CN114168109A (en) | 2022-03-11 |
Family
ID=80484262
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111489424.5A Pending CN114168109A (en) | 2021-12-08 | 2021-12-08 | Data processing method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114168109A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115982137A (en) * | 2023-03-17 | 2023-04-18 | 鲁班(北京)电子商务科技有限公司 | Data name and database tabulation generation method and system |
| CN117057329A (en) * | 2023-10-13 | 2023-11-14 | 赞塔(杭州)科技有限公司 | Table data processing method and device and computing equipment |
-
2021
- 2021-12-08 CN CN202111489424.5A patent/CN114168109A/en active Pending
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115982137A (en) * | 2023-03-17 | 2023-04-18 | 鲁班(北京)电子商务科技有限公司 | Data name and database tabulation generation method and system |
| CN117057329A (en) * | 2023-10-13 | 2023-11-14 | 赞塔(杭州)科技有限公司 | Table data processing method and device and computing equipment |
| CN117057329B (en) * | 2023-10-13 | 2024-01-26 | 赞塔(杭州)科技有限公司 | Table data processing method and device and computing equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8438190B2 (en) | Generating web services from business intelligence queries | |
| US8392472B1 (en) | Auto-classification of PDF forms by dynamically defining a taxonomy and vocabulary from PDF form fields | |
| US7644065B2 (en) | Process of performing an index search | |
| US8275775B2 (en) | Providing web services from business intelligence queries | |
| CN101271475B (en) | Commercial intelligent system | |
| US20150169765A1 (en) | Federated search | |
| US7333986B2 (en) | Hierarchical database management system, hierarchical database management method, and hierarchical database management program | |
| CN110263317B (en) | Method and device for generating document template | |
| US20180232405A1 (en) | Building and managing data-processing attributes for modeled data sources | |
| CN114168109A (en) | Data processing method and device, electronic equipment and storage medium | |
| US10885087B2 (en) | Cognitive automation tool | |
| US10572278B2 (en) | Smart controls for user interface design and implementation | |
| CN111596965A (en) | Project engineering initialization method, device, computer equipment and storage medium | |
| CN109815242B (en) | Data processing method and system | |
| CN112287013B (en) | Data conversion method and adapter | |
| CN111784108B (en) | Modeling method and device of main data management platform | |
| US20130179152A1 (en) | Computer Implemented Method, Apparatus, Network Server And Computer Program Product | |
| CN111460779B (en) | Method for rendering and accessing flow form data based on Activiti | |
| CN106951399B (en) | Method and device for quickly generating ONIX standard file | |
| CN109254774A (en) | The management method and device of code in software development system | |
| CN114281688A (en) | Codeless or low-code automatic case management method and device | |
| CN114741276A (en) | Method and device for multiplexing test cases of domestic operating system | |
| CN113591447A (en) | Data table creating method, device, equipment and storage medium | |
| KR100545348B1 (en) | An integrated development system for a SyncML server application development | |
| CN118069587B (en) | Three-dimensional model management method, device, equipment and storage medium |
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 |