Database version management methods, devices and electronic equipment

By embedding a database version management component into the software development platform, and using a graphical editing interface to automatically manage database versions, the problems of untimely updates to database table structures and misoperation of source code are solved, thereby improving programming and communication efficiency.

CN115167841BActive Publication Date: 2026-03-13CHINA CONSTRUCTION BANK
View PDF 2 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2022-07-18
Publication Date
2026-03-13

AI Technical Summary

Technical Problem

When multiple people are collaborating to develop software, untimely updates to the database table structure can lead to chaos, make the source code prone to errors, and complicate the programming process.

Method used

Embedding a database version management component into the software development platform allows for database version management through a graphical editing interface. It automatically converts developer actions into database script files, updates the database, and records the new version number.

Benefits of technology

It improved communication efficiency among developers, simplified programming operations, avoided errors in source code, and enabled orderly management of database versions.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN115167841B_ABST
    Figure CN115167841B_ABST
Patent Text Reader

Abstract

This specification provides a database version management method, device, and electronic device. The method includes: a software development platform displaying a first editing interface for editing parameters of a target business object; receiving the parameters edited in the first editing interface, associating the edited parameters with a target graphic, and using the target graphic as a graphical identifier for the target business object; the target graphic being associated by developers with a designated location to implement programming operations for associating with the target business object; responding to software deployment instructions, converting operations on the target business object parameters into a database script file, controlling the database version management component to execute the database script file to update the database, identifying the updated database as the new database version, and recording the new database version number. This solution simplifies and facilitates software programming operations; it allows programmers to manage database versions by calling the database version management component without accessing the source code.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] This application relates to the field of automation technology, and in particular to database version management methods, apparatus and electronic devices. Background Technology

[0002] Many software programs require databases to run, and the database table structure needs to be designed before development. However, when multiple people collaborate on software development, changes in requirements may lead to modifications to the database table structure by each individual. If communication between developers is not timely, the database table structure used by each developer may not be updated in a timely manner, resulting in a chaotic database table situation in the later stages of iterative development. Therefore, a database version management component is needed to uniformly manage database versions.

[0003] To manage databases, configuration code for database version control components is typically added to the source code (or code) development platform, along with the addition and modification of database script files. However, this approach has the following drawbacks: All software-related source code files are exposed to developers, who are prone to making mistakes when configuring the database version control component and adding / modifying database script files. If these mistakes go undetected, they can easily lead to problems with the entire software source code. Furthermore, software developers need to check whether the database operation statements in the database script files match the business logic, making the software programming work quite cumbersome. Summary of the Invention

[0004] The purpose of this application is to provide a database version management method, device, and electronic device to solve the problems of "source code being prone to misoperation and programming work being cumbersome".

[0005] To address the aforementioned technical problems, this specification provides a database version management method, comprising: a software development platform displaying a first editing interface, the first editing interface being used to create a new target business object or modify the parameters of a target business object; wherein the parameters of the target business object are associated with fields of a table in a database; receiving parameters edited by developers in the first editing interface, associating the edited parameters with a target graphic, and using the target graphic as a graphical identifier of the target business object; the target graphic being associated by developers with a specified location to implement a programming operation for associating the target business object; obtaining a software deployment instruction, the software deployment instruction being used to instruct the deployment of the software developed by developers on the software development platform to a target server; responding to the deployment instruction, converting the developers' operations on the target business object parameters into a database script file, and controlling a database version management component associated with the software development platform to execute the database script file to update the database, and determining the updated database as the new database version, and recording the number of the new database version.

[0006] In some embodiments, the method further includes: obtaining a database retrieval instruction before modifying an existing database through a software development platform; in response to the database retrieval instruction, obtaining a target version of the database from a database version management component; converting the target version of the database into parameters associated with a graphical identifier of a business object; and displaying the conversion result on a first editing interface.

[0007] In some embodiments, the target server is a debugging server used for debugging software; the database is associated with the debugging server; or, the target server is an application server used for serving software users; the database is associated with the application server.

[0008] In some embodiments, after obtaining the deployment instruction for the software, the method further includes: in response to the deployment instruction, converting the operations on each editing interface in the software development platform into target code segments; sending the code segments to the software version management component, so that the software version management component can use the target code segments to update the associated target software, and determine the updated target software as the new software version.

[0009] In some embodiments, the method further includes: obtaining a target software acquisition instruction before modifying existing target software through a software development platform; in response to the target software acquisition instruction, acquiring the target version of the target software from a software version management component; converting the latest version of the target software into a graphic; and displaying the conversion result on the associated interface of the software development platform.

[0010] In some embodiments, the method further includes: a software development platform displaying a second editing interface, the second editing interface being used to edit the business processing flow, the second editing interface including a first area and a second area, wherein the first area includes graphical identifiers of various process nodes, and the second area is an editing area for the business processing flow; receiving a flowchart edited by a developer based on adding graphical identifiers from the first area to the second area; receiving an operation by a developer associating at least one process node in the flowchart with a target business object, and using the operation result as the target business processing flow.

[0011] In some embodiments, the method further includes: a software development platform displaying a third editing interface, the third editing interface being used to edit the user interface of the software, the third editing interface including a third area and a fourth area, wherein the third area includes graphical identifiers of various page elements, and the fourth area is the editing area of ​​the user interface; receiving a page display style edited by a developer based on adding graphical identifiers from the third area to the fourth area; receiving an operation by a developer associating at least one page element in the page display style with a target business object and / or a target business processing flow, and using the operation result as the target user interface.

[0012] In some embodiments, after the developer has edited and obtained the target business object, target business process, and target user interface, the method further includes: the software development platform organizing the target business object, target business process, and target user interface into a unit, wherein the unit corresponds to an application in the software; and displaying a fourth interface, wherein the fourth interface is used to display each unit, as well as the editing link, upgrade control, deployment control, and version number corresponding to each unit, so that the developer can enter the editing interface of the target business object, target business process, and target user interface in the target unit after clicking the editing link of the target unit, upgrade the unit in the software development platform to the latest version after clicking the upgrade control, and deploy the software version in the software development platform to the server after clicking the deployment control.

[0013] A second aspect of this specification provides a database version management device, comprising: a first display unit for displaying a first editing interface on a software development platform, the first editing interface being used to create a new target business object or modify parameters of a target business object; wherein the parameters of the target business object are associated with fields of a table in a database; a first receiving unit for receiving parameters edited by developers in the first editing interface, associating the edited parameters with a target graphic, and using the target graphic as a graphical identifier of the target business object; the target graphic being associated by developers with a designated location to achieve a programming operation of associating the target business object; a first acquisition unit for acquiring a software deployment instruction, the software deployment instruction being used to instruct the software developed by developers on the software development platform to be deployed to a target server; and a first conversion unit for, in response to the deployment instruction, converting the developer's operations on the target business object parameters into a database script file, controlling a database version management component associated with the software development platform to execute the database script file to update the database, identifying the updated database as a new database version, and recording the number of the new database version.

[0014] In some embodiments, the apparatus further includes: a second acquisition unit, configured to acquire a database acquisition instruction before modifying an existing database through a software development platform; a third acquisition unit, configured to acquire a target version of the database from a database version management component in response to the database acquisition instruction; a second conversion unit, configured to convert the target version of the database into parameters associated with a graphical identifier of a business object; and a first display unit, configured to display the conversion result on a first editing interface.

[0015] In some embodiments, the target server is a debugging server used for debugging software; the database is associated with the debugging server; or, the target server is an application server used for serving software users; the database is associated with the application server.

[0016] In some embodiments, the apparatus further includes: a second conversion unit, configured to, after obtaining a deployment instruction for the software, convert operations on various editing interfaces in the software development platform into target code segments in response to the deployment instruction; and a sending unit, configured to send the code segments to a software version management component, so that the software version management component can use the target code segments to update the associated target software and determine the updated target software as a new software version.

[0017] In some embodiments, the apparatus further includes: a fourth acquisition unit, configured to acquire an acquisition instruction for the target software before modifying the existing target software through the software development platform; a fifth acquisition unit, configured to acquire the target version of the target software from the software version management component in response to the acquisition instruction for the target software; a third conversion unit, configured to convert the latest version of the target software into a graphic; and a second display unit, configured to display the conversion result on the associated interface of the software development platform.

[0018] In some embodiments, the apparatus further includes: a second display unit for displaying a second editing interface for editing the business processing flow, the second editing interface including a first area and a second area, wherein the first area includes graphical identifiers of various process nodes, and the second area is an editing area for the business processing flow; a second receiving unit for receiving a flowchart edited by a developer by adding graphical identifiers from the first area to the second area; and a third receiving unit for receiving an operation by a developer that associates at least one process node in the flowchart with a target business object, and using the operation result as the target business processing flow.

[0019] In some embodiments, the apparatus further includes: a third display unit for displaying a third editing interface, the third editing interface being used to edit the user interface of the software, the third editing interface including a third area and a fourth area, wherein the third area includes graphical identifiers of various page elements, and the fourth area is the editing area of ​​the user interface; a fourth receiving unit for receiving a page display style edited by a developer based on adding graphical identifiers from the third area to the fourth area; and a fifth receiving unit for receiving an operation by a developer associating at least one page element in the page display style with a target business object and / or a target business processing flow, and using the operation result as the target user interface.

[0020] In some embodiments, the software further includes: an organization unit, used to organize the target business object, target business process, and target user interface in one unit after the developer has edited and obtained them, wherein the unit corresponds to an application in the software; and a fourth display unit, used to display a fourth interface, wherein the fourth interface displays each unit, as well as the corresponding editing link, upgrade control, deployment control, and version number of each unit, so that the developer can enter the editing interface of the target business object, target business process, and target user interface in the target unit after clicking the editing link of the target unit, upgrade the unit in the software development platform to the latest version after clicking the upgrade control, and deploy the software version in the software development platform to the server after clicking the deployment control.

[0021] A third aspect of this specification provides a software development platform, comprising: a graphical programming module for displaying a first editing interface, the first editing interface being used to create new target business objects or change parameters of target business objects; wherein the parameters of the target business objects are associated with fields of tables in a database; receiving content edited by developers in the first editing interface, associating the input content with a target graphic, and using the target graphic as a graphical identifier of the target business object; the target graphic being associated by developers with a specified location to implement programming operations for associating the target business object; obtaining software deployment instructions, the software deployment instructions being used to instruct the deployment of software developed by developers on the software development platform to a target server; a code conversion module for, in response to the deployment instructions, converting the developers' operations on the target business object parameters into a database script file; and a database management module for controlling a database version management component associated with the software development platform to execute the database script file to update the database; and receiving the database version management component's feedback of the new database version number to the software development platform after determining the updated database as the new database version.

[0022] In some embodiments, the graphical programming module is further configured to: display a second editing interface for editing the business processing flow, the second editing interface including a first area and a second area, wherein the first area includes graphical identifiers of various process nodes, and the second area is an editing area for the business processing flow; receive a flowchart edited by a developer based on adding graphical identifiers from the first area to the second area; receive an operation by a developer to associate at least one process node in the flowchart with a target business object, and use the operation result as the target business processing flow.

[0023] In some embodiments, the graphical programming module is further configured to: display a third editing interface for editing the user interface of the software, the third editing interface including a third area and a fourth area, wherein the third area includes graphical identifiers of various page elements, and the fourth area is the editing area of ​​the user interface; receive a page display style edited by a developer based on adding graphical identifiers from the third area to the fourth area; receive an operation by a developer to associate at least one page element in the page display style with a target business object and / or a target business processing flow, and use the operation result as the target user interface.

[0024] A fourth aspect of this specification provides an electronic device, comprising: a memory and a processor, wherein the processor and the memory are communicatively connected to each other, the memory stores computer instructions, and the processor executes the computer instructions to implement the steps of the method described in any of the first aspects.

[0025] A fifth aspect of this specification provides a computer storage medium storing computer program instructions that, when executed by a processor, implement the steps of the method described in any of the first aspects.

[0026] A sixth aspect of this specification provides a computer program product comprising a computer program that, when executed by a processor, implements the steps of the method described in any of the first aspects.

[0027] The database version management method, device, and electronic equipment provided in this manual allow developers to edit business objects within a software development platform and set graphical identifiers for these objects. This enables developers to perform programming operations by adding these graphical identifiers to designated locations. This graphical programming approach does not expose the source code files to developers, and the graphical editing results are readily apparent. Therefore, this solution simplifies and facilitates software programming. The software development platform is a graphical programming platform. Control code for the database version management component is embedded in the platform's backend code. Upon receiving deployment instructions, the platform automatically converts the developer's operations on the business object parameters into database script files and automatically controls the database version management component to execute these scripts to update the database and record the new version number. This allows programmers to manage database versions without accessing the source code, ensuring orderly database management and improving communication efficiency among developers collaborating on software development projects. Attached Figure Description

[0028] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in this application. For those skilled in the art, other drawings can be obtained from these drawings without creative effort.

[0029] Figure 1 A schematic diagram of the software list display interface in the software development platform is shown;

[0030] Figure 2 This diagram illustrates the application list display interface of a software within a software development platform.

[0031] Figure 3 This diagram illustrates a unit within an application of a software development platform.

[0032] Figure 4 This diagram illustrates the model designer within a software development platform.

[0033] Figure 5 This diagram illustrates the UI designer within a software development platform.

[0034] Figure 6 This diagram illustrates the process designer in a software development platform.

[0035] Figure 7 A schematic diagram illustrating the operational status of each software application within a software operation platform that is matched with the software development platform is shown.

[0036] Figure 8 This document illustrates a flowchart of the database version management method provided in this specification.

[0037] Figure 9 This document shows a schematic block diagram of the database version management device provided in this specification;

[0038] Figure 10 This document shows a schematic diagram of the program modules of the software development platform provided in this specification.

[0039] Figure 11 A schematic block diagram of the electronic device provided in this specification is shown. Detailed Implementation

[0040] To enable those skilled in the art to better understand the technical solutions in this application, the technical solutions in the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only a part of the embodiments of this application, and not all of the embodiments. Based on the embodiments in this application, all other embodiments obtained by those skilled in the art without creative effort should fall within the scope of protection of this application.

[0041] This specification provides a database version management method that embeds a database version management component into a graphical software development platform, enabling developers to develop software through a graphical editing interface and automatically manage database versions through the database version management component.

[0042] Figure 1 This diagram illustrates the software list display interface within a software development platform. (For example...) Figure 1 As shown on the left, this software development platform can include modules such as a development workbench, test management, and deployment management. The development workbench can include software development and asset development. Here, "software" refers to a single piece of software. The software development interface can display a list of software projects previously worked on by the developer, such as Software A, Software B, and Software C.

[0043] Figure 2This diagram illustrates the application list display interface under a software application within a software development platform. For example, software A includes applications A1 and A2. Here, an application refers to a sub-function that constitutes the overall functionality of the software. For instance, an application might be used to acquire user input data or to provide data feedback to the user.

[0044] Figure 3 This diagram illustrates a unit within an application on a software development platform. A unit can include a domain model, a page, and a process. The domain model, also known as the business object, is a visual representation of conceptual classes within the domain or objects in the real world. A page refers to the user interface. A process refers to the internal processing flow of the software.

[0045] Figure 4 The diagram illustrates the model designer within the software development platform. The model designer's user interface, also known as the first editing interface, is used to create business objects or modify their parameters.

[0046] Figure 5 The diagram illustrates the UI designer within a software development platform. This UI designer's interface, also known as the second editing interface, is used to design the style of the user interface and to set associated business processes and business objects for various controls on the page.

[0047] Figure 6 The diagram illustrates the process designer within the software development platform. This process designer's interface, also known as the third editing interface, is used to design business operation processes and to set associated business objects and user interaction interfaces for some process nodes.

[0048] Figure 7 The diagram illustrates the operational status of each software in a software operation platform that matches the software development platform. It includes the software number, software name, software version number, running status, update time, and operation controls (such as upgrade and access) for each software.

[0049] Based on the above Figures 1 to 7 This specification provides a database version management method that can be used in software development platforms. The users of the software development platform are the software developers.

[0050] In some embodiments, after developing the target software, the developers can deploy the target software to the application server. After deployment, the software development platform can be used to obtain the running status of the deployed software in real time and upgrade the deployed software as needed.

[0051] In some embodiments, the software development platform has a matching software operation platform, such as... Figure 7The software operation platform shown allows operators to obtain real-time information about deployed software, its operational status, and to upgrade the software as needed.

[0052] It should be noted that the term "software" in this application can refer to software that can perform multiple functions under the same theme, such as Photoshop image processing software, input method software, etc.; or it can refer to a small software program that performs a single function, such as a voting, statistics, leave application, etc.

[0053] like Figure 8 As shown, the method includes the following steps:

[0054] S10: The software development platform displays the first editing interface, which is used to create new target business objects or change the parameters of target business objects; the parameters of the target business objects are associated with the fields of the tables in the database.

[0055] The first editing interface can be like... Figure 4 As shown. In step S10, "business object" refers to the visual representation of business content.

[0056] In the first editing interface, you can create a new target business object or select an existing target business object to modify its parameters.

[0057] When developers create a new target business object, the first editing interface will display a new graphic identifier. The name of this new graphic identifier can be automatically set to match the name of the target business object. If the graphic identifier is renamed and its name differs from the name of the target business object, the name of the target business object can be automatically changed to match the name of the graphic identifier.

[0058] Developers can set various parameters for business objects. For example, such as Figure 4 As shown, based on the graphical identifier of the business object 1, developers can set parameters 1, 2, 3, 4, 5, etc., and can also add other parameters.

[0059] Each parameter of the business object corresponds to a field in the database table.

[0060] S20: Receives parameters edited by developers in the first editing interface, associates the edited parameters with the target graphic, and uses the target image as a graphical identifier for the target business object; the target graphic is used by developers to associate with a specified location to achieve the programming operation of associating the target business object.

[0061] like Figure 4As shown, after developers set multiple parameters based on the graphic identifier, the software development platform's backend program automatically associates these parameters with the target graphic identifier. This target graphic identifier is the one associated with the parameters during parameter editing.

[0062] When developers implement software programming operations, they can edit the target graphic parameters by "dragging and dropping the graphic identifier to the specified area," which is also the way to edit the target business object parameters.

[0063] "The target graphic is associated with a specified location" means that the identifier of the target graphic is added to a specified area (such as the editing area in the software development platform interface), or the identifier of the target graphic is associated with a specified process node, a specified component of the user interface, etc.

[0064] S30: Obtain software deployment instructions, which are used to instruct developers to deploy the software developed on the software development platform to the target server.

[0065] In some embodiments, developers can issue deployment instructions by clicking the deployment control on the software development platform, or by writing code in the command line. Deployment instructions can also come from other software associated with the software development platform.

[0066] In some embodiments, the target server may be a debug server used for debugging software. Accordingly, a database is associated with the debug server; that is, the debug server stores data in the database and reads and queries data from the database.

[0067] In some embodiments, the target server may be an application server used to serve software users. Accordingly, the database is associated with the application server; that is, the application server stores data in the database and reads and queries data from the database.

[0068] S40: In response to deployment instructions, it converts the developer's operations on the target business object into a database script file, controls the database version management component associated with the software development platform to execute the database script file to update the database, identifies the updated database as the new database version, and records the new database version number.

[0069] In response to deployment instructions, the software development platform will deploy new software created by developers, or modifications to existing software, to the server. Since these new software versions are programmed based on the modified database table structure during development, the database must be updated to the latest version before the new software version takes effect on the server.

[0070] Since the parameters of the target business object are associated with the fields of the database table, operations on the business object, that is, operations on the parameters of the business object (such as adding or changing parameters), will cause changes to the fields of the database table. These database operations need to be converted into database scripts and executed to make the fields of the database table respond accordingly.

[0071] After executing the database script file, the software development platform identifies the updated database as the new version and records its version number. The software development platform or database management component can also record changes to the database script file, allowing developers to review whether these changes are relevant to their development work and whether timely database updates are necessary.

[0072] The database version management method provided in this manual involves editing business objects within a software development platform and setting graphical identifiers for these objects. Developers can then perform programming operations by adding these graphical identifiers to designated locations. This graphical programming approach does not expose the source code files to developers, and the graphical editing results are readily apparent. Therefore, this solution simplifies and facilitates software programming. The software development platform is a graphical programming platform, and the control code for the database version management component is embedded in its backend code. Upon receiving deployment instructions, it automatically converts the developer's operations on the business object parameters into database script files and automatically controls the database version management component to execute these scripts to update the database and record the new database version number. This allows programmers to manage database versions without accessing the source code, ensuring orderly database management and improving communication efficiency among developers collaborating on software development projects.

[0073] In some embodiments, before modifying an existing database through a software development platform, the following steps may be included: obtaining a database retrieval instruction; in response to the database retrieval instruction, obtaining the target version of the database from a database version management component; converting the target version of the database into parameters associated with a graphical identifier of a business object, and displaying the conversion result on a first editing interface.

[0074] The database retrieval command can be given by clicking the "Database Download" control on the software development platform. Clicking the "Database Download" control on the software development platform will download the target version of the database from the database version management component.

[0075] Typically, the target version can be the latest version stored on the database version management component. In some cases, the "Database Download" control can be associated with a database version; in this case, the target version can be the database version associated with the "Database Download" control. For example, if there are three database versions: 1.0, 2.0, and 3.0, and the user clicks on version 2.0 and then clicks the "Database Download" control, the 2.0 version database will be downloaded.

[0076] In some embodiments, after obtaining the software deployment instructions, in addition to generating database scripts, updating the database, and storing the new version of the database, a new version of the software can also be stored. Specifically, in response to the deployment instructions, the operations on each editing interface in the software development platform are also converted into target code segments; the target code segments are sent to the software version management component so that the software version management component can use the target code segments to update the associated target software and determine the updated target software as the new version of the target software.

[0077] In some embodiments, before modifying existing target software through a software development platform, the following steps may be included: obtaining a target software acquisition instruction; in response to the target software acquisition instruction, obtaining the target version of the target software from a software version management component; converting the latest version of the target software into a graphic, and displaying the conversion result on the associated interface of the software development platform.

[0078] The command to obtain the target software can be given by clicking the "Software Download" control on the software development platform. Clicking the "Software Download" control on the software development platform will allow you to download the target version of the software from the software version management component.

[0079] Typically, the target version can be the latest version stored on the software version management component. In some cases, the "Software Download" control can be associated with a software version; in this case, the target version can be the software version associated with the "Software Download" control. For example, if there are three software versions: 1.0, 2.0, and 3.0, and the user clicks on version 2.0 and then clicks the "Software Download" control, they can download version 2.0 of the software.

[0080] In some embodiments, the database version management method further includes: a software development platform displaying a second editing interface, the second editing interface being used to edit the business processing flow, the second editing interface including a first area and a second area, wherein the first area includes graphical identifiers of various process nodes, and the second area is the editing area for the business processing flow; receiving a flowchart edited by developers by adding graphical identifiers from the first area to the second area; receiving an operation by developers associating at least one process node in the flowchart with a target business object and / or a target user interface, and using the operation result as the target business processing flow. It can be seen that a flowchart only becomes a business processing flow after it is associated with a business object or a user interface.

[0081] Figure 6 The diagram illustrates the second editing interface. The upper left area displays a list of business processes; clicking on a process allows for its editing. The lower left area is the first region, containing graphical icons for various process nodes, such as process start, process end, and process processing nodes. The area to the right of the graphical icon area is the second region, the editing area for the business process. This area uses the graphical icons on the left to edit the flowchart; for example, icons can be dragged and dropped into the editing area. The right side of the interface is a parameter confirmation area for a process node in the flowchart. Parameters include the business object associated with the node and the user interface. Users can input these parameters in this area. The software development platform receives these parameters and uses the "flowchart associated with the business object and user interface" as the target business process. Alternatively, the parameter confirmation area can be a dialog box that pops up after the user clicks on a process node.

[0082] In some embodiments, the database version management method further includes: a software development platform displaying a third editing interface, the third editing interface being used to edit the user interface of the software, the third editing interface including a third area and a fourth area, wherein the third area includes graphical identifiers of various page elements, and the fourth area is the editing area for the user interface; receiving a page display style edited by a developer based on adding graphical identifiers from the third area to the fourth area; receiving an operation by a developer associating at least one page element in the page display style with a target business object and / or a target business process, and using the operation result as the target user interface. It can be seen that the page display style only becomes a user interface after being associated with a business object or business process.

[0083] Figure 5The diagram illustrates the third editing interface. The upper left area displays a list of user interaction interfaces; clicking on an interface allows for its editing. The lower left area is the first region, containing graphical icons for various page elements, such as forms, buttons, selection controls, and input windows. The area to the right of this graphical icon region is the second region, the editing area for the user interaction interface. This area uses the graphical icons on the left to edit the page display style, for example, by dragging and dropping icons into the editing area. The right side of the interface is a parameter confirmation area for a page element within the page display style. Parameters include the associated business object and business process flow. Users can input these parameters in this area. The software development platform receives these parameters and uses the "page display style associated with the business object and business process flow" as the target user interaction interface. Alternatively, the parameter confirmation area can be a dialog box that pops up after the user clicks on a page element.

[0084] In some embodiments, after the developer has edited and obtained the target business object, target business process, and target user interface, the method further includes: the software development platform organizing the target business object, target business process, and target user interface into a unit, where one unit corresponds to an application in the software; displaying a fourth interface, which displays each unit, as well as the corresponding edit link, upgrade control, deployment control, and version number, so that the developer can enter the edit interface of the target business object, target business process, and target user interface in the target unit after clicking the edit link, upgrade the unit in the software development platform to the latest version after clicking the upgrade control, and deploy the software version in the software development platform to the server after clicking the deployment control. Figure 3 As shown.

[0085] In some embodiments, Figure 3 The application shown is a single piece of software; that is, a single piece of software contains only one application. However, in some embodiments, a single piece of software can include multiple applications. In this case, the software development platform can organize multiple applications into a single unit, with each unit corresponding to a single piece of software. The software development platform can then display a fifth interface to showcase each piece of software, such as... Figure 1 As shown, after clicking on one of the target software programs, the software development platform displays the fourth interface, which shows the various application units under that target software.

[0086] This specification provides a database version management device that can be used to implement... Figure 8 The method shown. (As illustrated) Figure 9As shown, the device includes a first display unit 10, a first receiving unit 20, a first acquisition unit 30, and a first conversion unit 40.

[0087] The first display unit 10 is used to display the first editing interface of the software development platform. The first editing interface is used to create new target business objects or change the parameters of target business objects; wherein, the parameters of the target business objects are associated with the fields of the tables in the database.

[0088] The first receiving unit 20 is used to receive parameters edited by developers in the first editing interface, associate the edited parameters with the target graphic, and use the target graphic as a graphical identifier of the target business object; the target graphic is associated by the developers with a specified location to realize the programming operation of associating the target business object.

[0089] The first acquisition unit 30 is used to acquire software deployment instructions, which are used to instruct the developers to deploy the software developed on the software development platform to the target server.

[0090] The first conversion unit 40 is used to respond to deployment instructions, convert the developer's operations on the target business object parameters into a database script file, control the database version management component associated with the software development platform to execute the database script file to update the database, identify the updated database as the new database version, and record the number of the new database version.

[0091] In some embodiments, the apparatus further includes: a second acquisition unit, configured to acquire a database acquisition instruction before modifying an existing database through a software development platform; a third acquisition unit, configured to acquire a target version of the database from a database version management component in response to the database acquisition instruction; a second conversion unit, configured to convert the target version of the database into parameters associated with a graphical identifier of a business object; and a first display unit, configured to display the conversion result on a first editing interface.

[0092] In some embodiments, the target server is a debug server used for debugging software; the database is associated with the debug server; or, the target server is an application server used for serving users of the software; the database is associated with the application server.

[0093] In some embodiments, the apparatus further includes: a second conversion unit, configured to, after obtaining the deployment instruction for the software, convert the operations on each editing interface in the software development platform into target code segments in response to the deployment instruction; and a sending unit, configured to send the code segments to a software version management component, so that the software version management component can update the associated target software using the target code segments and determine the updated target software as a new software version.

[0094] In some embodiments, the apparatus further includes: a fourth acquisition unit, configured to acquire an acquisition instruction for the target software before modifying the existing target software through the software development platform; a fifth acquisition unit, configured to acquire the target version of the target software from the software version management component in response to the acquisition instruction for the target software; a third conversion unit, configured to convert the latest version of the target software into a graphic; and a second display unit, configured to display the conversion result on the associated interface of the software development platform.

[0095] In some embodiments, the device further includes: a second display unit for displaying a second editing interface for editing the business processing flow, the second editing interface including a first area and a second area, wherein the first area includes graphical identifiers of various process nodes, and the second area is an editing area for the business processing flow; a second receiving unit for receiving a flowchart edited by a developer by adding graphical identifiers from the first area to the second area; and a third receiving unit for receiving an operation by a developer that associates at least one process node in the flowchart with a target business object, and using the operation result as the target business processing flow.

[0096] In some embodiments, the apparatus further includes: a third display unit for displaying a third editing interface, the third editing interface being used to edit the user interface of the software, the third editing interface including a third area and a fourth area, wherein the third area includes graphical identifiers of various page elements, and the fourth area is the editing area of ​​the user interface; a fourth receiving unit for receiving a page display style edited by a developer based on adding graphical identifiers from the third area to the fourth area; and a fifth receiving unit for receiving an operation by a developer associating at least one page element in the page display style with a target business object and / or a target business processing flow, and using the operation result as the target user interface.

[0097] In some embodiments, the apparatus further includes: an organization unit, used to organize the target business object, target business process, and target user interface into a unit after the developer has edited and obtained them, wherein a unit corresponds to an application in the software; and a fourth display unit, used to display a fourth interface, which displays each unit, as well as the corresponding editing link, upgrade control, deployment control, and version number of each unit, so that the developer can enter the editing interface of the target business object, target business process, and target user interface in the target unit after clicking the editing link of the target unit, upgrade the unit in the software development platform to the latest version after clicking the upgrade control, and deploy the software version in the software development platform to the server after clicking the deployment control.

[0098] The description and beneficial effects of the aforementioned database version management device can be found in the description and beneficial effects section of the method section, and will not be repeated here.

[0099] This specification provides a software development platform, such as Figure 10 As shown, it includes a graphical programming module, a code conversion module, and a database management module.

[0100] The graphical programming module is used to display a first editing interface, which is used to create new target business objects or change the parameters of target business objects. The parameters of the target business objects are associated with fields in a table in the database. The module receives content edited by developers within the first editing interface, associates the input content with a target graphic, and uses the target graphic as a graphical identifier for the target business object. The target graphic is associated by developers with a specified location to perform programming operations related to the target business object. The module also obtains software deployment instructions, which instruct developers to deploy the software developed on the software development platform to the target server.

[0101] The code conversion module is used to respond to the deployment instructions and convert the developer's operations on the target business object parameters into database script files.

[0102] The database management module is used to control the database version management component associated with the control software development platform to execute the database script file to update the database; and to receive the database version number fed back to the software development platform after the database version management component determines the updated database as the new database version.

[0103] In some embodiments, the graphical programming module is further configured to: display a second editing interface for editing the business processing flow, the second editing interface including a first area and a second area, wherein the first area includes graphical identifiers of various process nodes, and the second area is the editing area for the business processing flow; receive a flowchart edited by a developer by adding graphical identifiers from the first area to the second area; receive an operation by a developer associating at least one process node in the flowchart with a target business object, and use the operation result as the target business processing flow. In some embodiments, the graphical programming module is further configured to: display a third editing interface for editing the user interface of the software, the third editing interface including a third area and a fourth area, wherein the third area includes graphical identifiers of various page elements, and the fourth area is the editing area for the user interface; receive a page display style edited by a developer by adding graphical identifiers from the third area to the fourth area; receive an operation by a developer associating at least one page element in the page display style with a target business object and / or a target business processing flow, and use the operation result as the target user interface.

[0104] The description and benefits of the aforementioned software development platform can be found in the description and benefits section of the methodology section, and will not be repeated here.

[0105] This invention also provides an electronic device, such as... Figure 11 As shown, the electronic device may include a processor 1101 and a memory 1102, wherein the processor 1101 and the memory 1102 may be connected via a bus or other means. Figure 11 Taking the example of a connection between China and Israel via a bus.

[0106] Processor 1101 may be a central processing unit (CPU). Processor 1101 may also be other general-purpose processors, digital signal processors (DSPs), application-specific integrated circuits (ASICs), field-programmable gate arrays (FPGAs), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or combinations thereof.

[0107] Memory 1102, as a non-transitory computer-readable storage medium, can be used to store non-transitory software programs, non-transitory computer-executable programs, and modules, such as the program instructions / modules corresponding to the database version management method in this embodiment of the invention (e.g., Figure 9 The first display unit 10, the first receiving unit 20, the first acquisition unit 30, and the first conversion unit 40 are shown. The processor 1101 executes various functional applications and data classification by running non-transitory software programs, instructions, and modules stored in the memory 1102, thereby realizing the database version management method in the above method embodiments.

[0108] The memory 1102 may include a program storage area and a data storage area. The program storage area may store the operating system and applications required for at least one function; the data storage area may store data created by the processor 1101, etc. Furthermore, the memory 1102 may include high-speed random access memory and may also include non-transitory memory, such as at least one disk storage device, flash memory device, or other non-transitory solid-state storage device. In some embodiments, the memory 1102 may optionally include memory remotely located relative to the processor 1101, and these remote memories may be connected to the processor 1101 via a network. Examples of such networks include, but are not limited to, the Internet, corporate intranets, local area networks, mobile communication networks, and combinations thereof.

[0109] The one or more modules are stored in the memory 1102, and when executed by the processor 1101, the above-described database version management method is performed.

[0110] For details regarding the electronic device described above, please refer to the relevant descriptions and effects in the above embodiments for further understanding; they will not be repeated here.

[0111] This specification provides a computer storage medium storing computer program instructions that, when executed by a processor, implement the steps of the database version management method described above.

[0112] This specification provides a computer program product comprising a computer program that, when executed by a processor, implements the steps of the database version management method described above.

[0113] Those skilled in the art will understand that all or part of the processes in the methods of the above embodiments can be implemented by a computer program instructing related hardware. The program can be stored in a computer-readable storage medium, and when executed, it can include the processes of the embodiments of the above methods. The storage medium can be a magnetic disk, optical disk, read-only memory (ROM), random access memory (RAM), flash memory, hard disk drive (HDD), or solid-state drive (SSD), etc.; the storage medium can also include combinations of the above types of memory.

[0114] The various embodiments in this specification are described in a progressive manner. For the same or similar parts between the various embodiments, please refer to each other. The focus of each embodiment is to describe the differences from other embodiments.

[0115] The systems, devices, modules, or units described in the above embodiments can be implemented by computer chips or entities, or by products with certain functions.

[0116] For ease of description, the above devices are described separately by function as various units. Of course, in implementing this application, the functions of each unit can be implemented in one or more software and / or hardware.

[0117] As can be seen from the above description of the embodiments, those skilled in the art can clearly understand that this application can be implemented by means of software plus necessary general-purpose hardware platforms. Based on this understanding, the technical solution of this application, in essence, or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product can be stored in a storage medium, such as ROM / RAM, magnetic disk, optical disk, etc., and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute certain parts of the methods of various embodiments of this application.

[0118] This application can be used in a wide variety of general-purpose or special-purpose computer system environments or configurations. For example: personal computers, server computers, handheld or portable devices, tablet devices, multiprocessor systems, microprocessor-based systems, set-top boxes, programmable consumer electronics devices, network PCs, minicomputers, mainframe computers, distributed computing environments including any of the above systems or devices, etc.

[0119] This application can be described in the general context of computer-executable instructions, such as program modules, that are executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc., that perform a specific task or implement a specific abstract data type. This application can also be practiced in distributed computing environments where tasks are performed by remote processing devices connected via a communication network. In distributed computing environments, program modules can reside in local and remote computer storage media, including storage devices.

[0120] Although this application has been described through embodiments, those skilled in the art will know that this application has many modifications and variations without departing from the spirit of this application, and it is intended that the appended claims cover such modifications and variations without departing from the spirit of this application.

Claims

1. A database version management method characterized by, The method comprises the following steps: The software development platform displays a first editing interface, which is used to create a new target business object or change parameters of the target business object; wherein the parameters of the target business object are associated with fields of a table in a database; Receiving the parameters edited by the developer in the first editing interface, associating the edited parameters to a target graph, and taking the target graph as a graphical identification of the target business object; the target graph is associated to a specified position by the developer to realize a programmed operation associated with the target business object; Obtaining a deployment instruction of software, which is used to instruct to deploy the software developed by the developer on the software development platform to a target server; In response to the deployment instruction, converting the operation of the developer on the parameters of the target business object into a database script file, and controlling a database version management component associated with the software development platform to execute the database script file to update the database, and determining an updated database as a new version of the database, and recording a number of the new version of the database; The method further comprises the following steps: The software development platform displays a second editing interface, which is used to edit a processing flow of a business, and the second editing interface comprises a first area and a second area; wherein the first area comprises graphical identifications of a plurality of flow nodes, and the second area is an editing area of the processing flow of the business; Receiving a flowchart edited by the developer based on a manner of adding the graphical identifications of the first area to the second area; Receiving an operation of the developer to associate at least one flow node in the flowchart to the target business object, and taking an operation result as a target processing flow of the business; The method further comprises the following steps: The software development platform displays a third editing interface, which is used to edit a user interactive interface of the software, and the third editing interface comprises a third area and a fourth area; wherein the third area comprises graphical identifications of a plurality of page elements, and the fourth area is an editing area of the user interactive interface; Receiving a page display style edited by the developer based on a manner of adding the graphical identifications of the third area to the fourth area; Receiving an operation of the developer to associate at least one page element in the page display style to the target business object and / or the target processing flow of the business, and taking an operation result as a target user interactive interface; After the developer edits the target business object, the target processing flow of the business, and the target user interactive interface, the method further comprises the following steps: The software development platform organizes the target business object, the target processing flow of the business, and the target user interactive interface in one unit, and the one unit is used to correspond to one application in the software; Displaying a fourth interface, which is used to display each unit, and an editing link, an upgrade control, a deployment control, and a version number corresponding to each unit, so that the developer enters an editing interface of the target business object, the target processing flow of the business, and the target user interactive interface in the target unit after clicking the editing link of the target unit, upgrades the unit in the software development platform to the latest version after clicking the upgrade control, and deploys a software version in the software development platform to a server after clicking the deployment control.

2. The method of claim 1, wherein, The method further comprises the following steps: Before modifying the existing database through the software development platform, an acquisition instruction of the database is acquired; In response to the database acquisition instruction, a target version of the database is acquired from the database version management component; The target version of the database is converted into parameters of graphical identification association of the business object; The conversion result is displayed on the first editing interface.

3. The method of claim 1, wherein, The target server is a debugging server, used for debugging software; the database is associated with the debugging server; Alternatively, the target server is an application server, used for serving users of the software; the database is associated with the application server.

4. The method of claim 1, wherein, After the deployment instruction of the software is acquired, the method further includes: In response to the deployment instruction, operations on each editing interface in the software development platform are converted into target code segments; The code segments are sent to the software version management component, so that the software version management component updates the associated target software by using the target code segments, and determines the updated target software as a new software version.

5. The method of claim 4, wherein, The method further includes: Before modifying the existing target software through the software development platform, an acquisition instruction of the target software is acquired; In response to the target software acquisition instruction, a target version of the target software is acquired from the software version management component; The latest version of the target software is converted into a graph; The conversion result is displayed on the associated interface of the software development platform.

6. A database version management apparatus characterized by comprising: The method includes: A first display unit is configured to display a first editing interface of a software development platform, the first editing interface being used for creating a new target business object or changing parameters of the target business object; wherein the parameters of the target business object are associated with fields of a table in a database; A first receiving unit is configured to receive parameters edited by a developer in the first editing interface, associate the edited parameters to a target graph, and use the target graph as a graphical identification of the target business object; the target graph is associated to a specified position by the developer to realize a programming operation associated with the target business object; A first acquisition unit is configured to acquire a deployment instruction of software, the deployment instruction of the software being used to indicate deployment of software developed by the developer on the software development platform to a target server; A first conversion unit is configured to, in response to the deployment instruction, convert operations of the developer on the parameters of the target business object into a database script file, control a database version management component associated with the software development platform to execute the database script file to update the database, and determine the updated database as a new version of the database and record a number of the new version of the database; The apparatus further includes: A second display unit is configured to display a second editing interface, the second editing interface being used for editing a business processing flow, the second editing interface including a first area and a second area, wherein the first area includes graphical identifications of multiple flow nodes, and the second area is an editing area of the business processing flow; A second receiving unit is configured to receive a flowchart edited by a developer based on a manner of adding graphical identifications in the first area to the second area; A third receiving unit is configured to receive an operation of the developer in associating at least one flow node in the flowchart to a target business object, and use an operation result as a target business processing flow. The device further comprises: a third display unit configured to display a third editing interface, the third editing interface being used to edit a user interaction interface of the software, the third editing interface comprising a third area and a fourth area, wherein the third area comprises graphical representations of a plurality of page elements, and the fourth area is an editing area of the user interaction interface; a fourth receiving unit configured to receive a page display style edited by the developer based on a manner of adding the graphical representations of the third area to the fourth area; a fifth receiving unit configured to receive an operation of the developer in associating at least one page element in the page display style with a target business object and / or a target business process, and to take an operation result as a target user interaction interface; The device further comprises: an organization unit configured to organize the target business object, the target business process and the target user interaction interface in one unit after the developer edits the target business object, the target business process and the target user interaction interface, the one unit being used to correspond to one application in the software; a fourth display unit configured to display a fourth interface, the fourth interface being used to display each unit, and an editing link, an upgrade control, a deployment control and a version number corresponding to each unit, so as to enable the developer to enter an editing interface of the target business object, the target business process and the target user interaction interface in the target unit by clicking the editing link of the target unit, to upgrade the unit in the software development platform to the latest version by clicking the upgrade control, and to deploy the software version in the software development platform to a server by clicking the deployment control.

7. The apparatus of claim 6, wherein, The device further comprises: a second obtaining unit configured to obtain a database obtaining instruction before modifying an existing database through the software development platform; a third obtaining unit configured to obtain a target version of the database from the database version management component in response to the database obtaining instruction; a second conversion unit configured to convert the target version of the database into parameters associated with graphical representations of the business object; a first display unit configured to display the conversion result on the first editing interface.

8. A software development platform, characterized by The device further comprises: a graphical programming module configured to display a first editing interface, the first editing interface being used to create a new target business object or to change parameters of the target business object, wherein the parameters of the target business object are associated with fields of a table in a database, to receive content edited by the developer in the first editing interface, to associate the input content to a target graph, and to take the target graph as a graphical representation of the target business object, and to obtain a deployment instruction of the software, the deployment instruction of the software being used to instruct to deploy the software developed by the developer on the software development platform to a target server; a code conversion module configured to convert the operation of the developer on the parameters of the target business object into a database script file in response to the deployment instruction. A database management module is configured to control a database version management component associated with the software development platform to execute the database script file to update the database, and receive a number of a new database version of the database from the database version management component after the database version management component determines the updated database as the new database version. The graphical programming module is further configured to: display a second editing interface, the second editing interface being configured to edit a business process, the second editing interface including a first area and a second area, the first area including graphical identifiers of a plurality of process nodes, and the second area being an editing area of the business process; receive a flowchart edited by the developer based on a manner of adding the graphical identifiers of the first area to the second area; receive an operation of associating at least one process node in the flowchart with a target business object by the developer, and take an operation result as a target business process; The graphical programming module is further configured to: display a third editing interface, the third editing interface being configured to edit a user interface of the software, the third editing interface including a third area and a fourth area, the third area including graphical identifiers of a plurality of page elements, and the fourth area being an editing area of the user interface; receive a page display style edited by the developer based on a manner of adding the graphical identifiers of the third area to the fourth area; receive an operation of associating at least one page element in the page display style with the target business object and / or the target business process by the developer, and take an operation result as a target user interface; The software development platform organizes the target business object, the target business process, and the target user interface in a unit, the unit being configured to correspond to an application in the software. The graphical programming module is further configured to:

9. An electronic device, comprising: display a fourth interface, the fourth interface being configured to display units, and editing links, upgrade controls, deployment controls, and version numbers corresponding to the units, so that the developer enters an editing interface of the target business object, the target business process, and the target user interface in a target unit by clicking an editing link of the target unit, upgrades the unit in the software development platform to a latest version by clicking an upgrade control, and deploys a software version in the software development platform to a server by clicking a deployment control. comprise:

10. A computer storage medium, characterized in that, a memory and a processor, the processor and the memory being communicatively connected, the memory storing computer instructions, and the processor implementing steps of the method of any one of claims 1 to 5 by executing the computer instructions.

11. A computer program product, characterised in that, The computer storage medium stores computer program instructions, and the computer program instructions are executed by the processor to implement steps of the method of any one of claims 1 to 5. The computer program is executed by the processor to implement steps of the method of any one of claims 1 to 5.

Citation Information

Patent Citations

  • Program document generation method based on vehicle business development platform and development platform

    CN114296727A

  • Content management system, static page management method and device and storage medium

    CN114329297A