Method, system and computer program for designing business model based on web

Abstract

The invention discloses a method for designing a business model based on a web. The method comprises the following steps: defining model structure parameters; constructing a model tree based on the model structure parameters; storing the model tree as a model table in a database; defining model structure parameters of a new version, and constructing a model tree of the new version; obtaining the model tree of the new version and a difference item of a model table in a database, and generating a DDL statement; updating a model table in a database by utilizing the DDL statement; based on a web front end, the operation of newly adding, updating, deleting or querying model data is realized. According to the technical scheme provided by the invention, the design and application of the business model in the vehicle OTA field are quickly completed through the web page design business model, the establishment of the model field, the model display page, the relationship between the models and the like; based on a web front end, the operation of newly adding, updating, deleting or querying the model data is realized.

Description

Technical Field

[0001] The present invention relates to the field of data processing, and in particular to a method for designing a business model based on a web. Background Art

[0002] In the field of vehicle OTA, in order to meet the rapid development of intelligent connected vehicle technology, the business model involves commercial services such as software subscription services, paid upgrades, advertising push and data services. Automakers can use a complete business model to better provide users with more intelligent and personalized services, bringing more business opportunities and competitive advantages.

[0003] As the business develops, the business model needs to be updated to meet the latest product design. This includes multiple tasks: updating the database table design, modifying the corresponding code, self-testing, joint debugging, testing, bug fixing, regression testing, etc., and finally completing the launch. This series of work processes increases the workload of operation and maintenance personnel, developers, and testers, and reduces output efficiency. Summary of the invention

[0004] The present invention provides a method for designing a business model based on a web, which designs a business model through a web page, establishes model fields, model display pages, and relationships between models, so as to quickly complete the design and application of a business model in the field of vehicle OTA.

[0005] To achieve the above object, the embodiments of the present invention adopt the following technical solutions: A method for designing a business model based on a web comprises the following steps: Define model structure parameters; Based on the model structure parameters, a model tree is constructed; Save the model tree as a model table in the database; Define the model structure parameters of the new version and build the model tree of the new version; Get the differences between the new version of the model tree and the model table in the database, and generate DDL statements; Use DDL statements to update the model table in the database.

[0006] According to one aspect of the present invention, the model structure parameters include: model attributes, model table fields, model table indexes, form fields, list fields, query condition fields, and association relationships.

[0007] According to one aspect of the present invention, the form is a form page rendered by the model; the list is a list page rendered by the model; and the association relationship is used to define other models associated with the model.

[0008] According to one aspect of the present invention, the method based on web design business model further includes: Based on the web front end, operations such as adding, updating, deleting or querying model data are implemented.

[0009] According to one aspect of the present invention, the newly added model data includes: Organize the model table into Json format data and send it to the web front end; The web front end parses the Json format data and renders it into a form page for users to enter new model data; The user inputs new model data; The web front end calls the new interface of the back end to save the new model data to the database.

[0010] According to one aspect of the present invention, updating model data includes: The web front end calls the back end query interface to obtain the model data required by the user; The web front end displays the model data on the form page; The user modifies the model data; The web front end calls the back end update interface to save the model data modified by the user to the database.

[0011] According to one aspect of the present invention, deleting model data includes: The web front end calls the back end query interface to obtain the model data required by the user; The web front end displays the model data on the form page; User deletes model data; The web front end calls the back end deletion interface to delete the model data deleted by the corresponding user in the database.

[0012] According to one aspect of the present invention, querying model data includes: Organize the model table into Json format data and send it to the web front end; The web front end parses the Json format data and renders it into a list page for users to enter query conditions; The user sets the query conditions; The web front end calls the back end query interface to obtain the model data queried by the user.

[0013] A system based on a web design business model, based on the method based on a web design business model as described above, comprises: Model definition module, used to define model structure parameters; Model tree module, used to build a model tree based on model structure parameters; Model table module, used to save the model tree as a model table in the database; The new version model module is used to define the model structure parameters of the new version and build the model tree of the new version; DDL module, used to obtain the differences between the new version of the model tree and the model table in the database, and generate DDL statements; The update module is used to update the model table in the database using DDL statements.

[0014] A computer program, when executed, implements the steps of the method for designing a business model based on a web.

[0015] Advantages of the present invention: The present invention provides a method for designing a business model based on a web. The method designs a business model through a web page, establishes model fields, model display pages, and relationships between models, etc., to quickly complete the design and application of a business model in the field of vehicle OTA; based on the web front end, the operations of adding, updating, deleting or querying model data are realized, thereby improving business efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings required for use in the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0017] Figure 1 This is a flow chart of a method for designing a business model based on a web according to Embodiment 1 of the present invention; Figure 2 This is a flow chart of a method for designing a business model based on a web as described in Embodiment 2 of the present invention. DETAILED DESCRIPTION

[0018] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0019] Embodiment 1 like Figure 1 As shown, a method for designing a business model based on a web comprises the following steps: S1: Define model structure parameters.

[0020] The model structure parameters include: model attributes, model table fields, model table indexes, form fields, list fields, query condition fields, and association relationships.

[0021] In practical applications, in the field of vehicle OTA, model attributes include attributes such as model table name, table comments, and model version.

[0022] Model table fields are used to define which database fields the model has, including properties such as database field name, field comment, field default value, field type, field length, whether the field is the primary key, whether the field is auto-incrementing, and whether the field is required.

[0023] For example, set one of the fields, the field name is uid, the field type is BIGINT, the field length is 19, and the field is a required field.

[0024] Model table index is used to define which database indexes the model has, including properties such as index name, fields included in the index, and index type.

[0025] The form is: a form page rendered by the model.

[0026] Form fields are used to define which fields the form page rendered by the model has, including attributes such as field name, field notes, field internationalization Label, controls used by the field, field default value, whether the field is required, field length limit, field regular validation rules, whether the field is displayed, whether the field is editable, dictionary used by the field, field custom query SQL, field encoding rules, etc.

[0027] For example, set the form fields p_id, desc_cn, class_id, etc.

[0028] The list is: a list page rendered by the model.

[0029] List fields are used to define which fields are included in the list page rendered by the model, including attributes such as field name, field note, field internationalization Label, whether the field is displayed, field default display width, and whether the field supports sorting.

[0030] For example, set the list fields p_id, desc_cn, class_id, etc.

[0031] The query condition field is used to define which fields that support conditional search are available on the list page rendered by the model. It includes attributes such as field name, field note, field internationalization Label, whether the control field used by the field is displayed, whether the field supports fuzzy search, the dictionary used by the field, and field custom query SQL.

[0032] The association relationship is used to define other models associated with the model. The association relationship includes foreign keys and relationship rules.

[0033] Foreign keys are used to define other models associated with this model, including properties such as foreign key name, foreign key description, associated field name, associated model id, associated model field name, foreign key pop-up trigger field name, etc.

[0034] Relationship rules are used to define other models that are associated with this model through a specified relationship type, which contain fields such as the associated model ID, the number of associated objects, and the relationship type.

[0035] S2: Build a model tree based on the model structure parameters.

[0036] In actual applications, in the field of vehicle OTA, different models often have some common attributes. For example, all models in the business have attributes such as creator, creation time, updater, and update time. In order to quickly reuse these attributes, a model tree is designed. Each node on the tree is a model. The child node model can inherit attributes from the parent model. In order to enhance flexibility, the attributes inherited by the child model from the parent model support rewriting and overwriting.

[0037] S3: Save the model tree as a model table in the database.

[0038] Save the designed model structure into the database in table form.

[0039] S4: Define the model structure parameters of the new version and build the model tree of the new version.

[0040] S5: Obtain the difference items between the new version of the model tree and the model table in the database, and generate DDL statements.

[0041] S6: Use the DDL statement to update the model table in the database.

[0042] After completing the design of the database model table fields and database indexes, you can compare two versions of the same model to obtain the differences in the database model table, thereby generating DDL statements and automatically updating the database table structure.

[0043] In practical application, this method can realize the definition and design of the model structure in the vehicle OTA field on the web page, and then save it in the database.

[0044] The beneficial effect of this embodiment is that the method quickly completes the design of the business model in the vehicle OTA field by establishing model fields, model display pages, and relationships between models.

[0045] Embodiment 2 like Figure 1 As shown, a method for designing a business model based on a web comprises the following steps: S1: Define model structure parameters.

[0046] The model structure parameters include: model attributes, model table fields, model table indexes, form fields, list fields, query condition fields, and association relationships.

[0047] In practical applications, in the field of vehicle OTA, model attributes include attributes such as model table name, table comments, and model version.

[0048] Model table fields are used to define which database fields the model has, including properties such as database field name, field comment, field default value, field type, field length, whether the field is the primary key, whether the field is auto-incrementing, and whether the field is required.

[0049] For example, set one of the fields, the field name is uid, the field type is BIGINT, the field length is 19, and the field is a required field.

[0050] Model table index is used to define which database indexes the model has, including properties such as index name, fields included in the index, and index type.

[0051] The form is a form page rendered by the model. The form page allows users to add, update or delete model data.

[0052] Form fields are used to define which fields the form page rendered by the model has, including attributes such as field name, field notes, field internationalization Label, controls used by the field, field default value, whether the field is required, field length limit, field regular validation rules, whether the field is displayed, whether the field is editable, dictionary used by the field, field custom query SQL, field encoding rules, etc.

[0053] For example, set the form fields p_id, desc_cn, class_id, etc.

[0054] The list is a list page rendered by the model. The form page allows users to query model data.

[0055] List fields are used to define which fields are included in the list page rendered by the model, including attributes such as field name, field note, field internationalization Label, whether the field is displayed, field default display width, and whether the field supports sorting.

[0056] For example, set the list fields p_id, desc_cn, class_id, etc.

[0057] The query condition field is used to define which fields that support conditional search are available on the list page rendered by the model. It includes attributes such as field name, field note, field internationalization Label, whether the control field used by the field is displayed, whether the field supports fuzzy search, the dictionary used by the field, and field custom query SQL.

[0058] The association relationship is used to define other models associated with the model. The association relationship includes foreign keys and relationship rules.

[0059] Foreign keys are used to define other models associated with this model, including properties such as foreign key name, foreign key description, associated field name, associated model id, associated model field name, foreign key pop-up trigger field name, etc.

[0060] Relationship rules are used to define other models that are associated with this model through a specified relationship type, which contain fields such as the associated model ID, the number of associated objects, and the relationship type.

[0061] S2: Build a model tree based on the model structure parameters.

[0062] In actual applications, in the field of vehicle OTA, different models often have some common attributes. For example, all models in the business have attributes such as creator, creation time, updater, and update time. In order to quickly reuse these attributes, a model tree is designed. Each node on the tree is a model. The child node model can inherit attributes from the parent model. In order to enhance flexibility, the attributes inherited by the child model from the parent model support rewriting and overwriting.

[0063] S3: Save the model tree as a model table in the database.

[0064] Save the designed model structure into the database in table form.

[0065] S4: Define the model structure parameters of the new version and build the model tree of the new version.

[0066] S5: Obtain the difference items between the new version of the model tree and the model table in the database, and generate DDL statements.

[0067] S6: Use the DDL statement to update the model table in the database.

[0068] After completing the design of the database model table fields and database indexes, you can compare two versions of the same model to obtain the differences in the database model table, thereby generating DDL statements and automatically updating the database table structure.

[0069] In practical application, this method can realize the definition and design of the model structure in the vehicle OTA field on the web page, and then save it in the database.

[0070] S7: Based on the web front end, implement operations of adding, updating, deleting or querying model data.

[0071] New model data includes: Organize the model table into Json format data and send it to the web front end; The web front end parses the Json format data and renders it into a form page for users to enter new model data; The user inputs new model data; The web front end calls the new interface of the back end to save the new model data to the database.

[0072] In actual applications, after completing the design of model form fields, foreign keys, and relationship rules in the vehicle OTA field, the form field design is organized into a Json format and sent to the front end. This Json contains the form field design of the main model and other models associated with it through foreign keys and relationship rules. The front end parses this Json and renders it into a Form form page for users to enter information.

[0073] After the user information is entered, click the Submit button of the form, the front end calls the back end's general new interface, passes in the model id and the model data entered by the user, and saves the model data to the database.

[0074] Updating model data includes: The web front end calls the back end query interface to obtain the model data required by the user; The web front end displays the model data on the form page; The user modifies the model data; The web front end calls the back end update interface to save the model data modified by the user to the database.

[0075] In actual applications, when a user clicks on model data editing, the front end calls the general query details interface, passes in the model id and model data id, the back end returns the model data, and the front end displays the model data on the rendered form update page.

[0076] Deleting model data includes: The web front end calls the back end query interface to obtain the model data required by the user; The web front end displays the model data on the form page; User deletes model data; The web front end calls the back end deletion interface to delete the model data deleted by the corresponding user in the database.

[0077] Query model data includes: Organize the model table into Json format data and send it to the web front end; The web front end parses the Json format data and renders it into a list page for users to enter query conditions; The user sets the query conditions; The web front end calls the back end query interface to obtain the model data queried by the user.

[0078] In actual applications, after completing the design of model list fields, query condition fields, foreign keys, and relationship rules in the vehicle OTA field, the list field design and query condition field design are organized into Json format and sent to the front end. This Json contains the list field and query condition field design of the main model and other models associated with it through foreign keys and relationship rules. The front end parses this Json to render the list page. The header of the list page will contain the query conditions configured in the modeling.

[0079] The user enters the query conditions, and the list page loads data. The front end calls the general paging interface of the back end, passes in the model id and the query conditions entered by the user, and the back end returns the model data that matches the conditions, and the front end displays the model data on the list page.

[0080] According to the model design in modeling, the backend provides a set of general add / delete / update / query details / paging / tree paging interfaces that receive model ID and model data to realize data processing for any model.

[0081] The beneficial effects of this embodiment are: this method designs business models through web pages, establishes model fields, model display pages, and relationships between models to quickly complete the design and application of business models in the vehicle OTA field; based on the web front end, it implements operations such as adding, updating, deleting or querying model data to improve business efficiency.

[0082] Embodiment 3 A system based on a web design business model, based on the method based on a web design business model as described in Embodiment 1 or 2, includes: Model definition module, used to define model structure parameters; Model tree module, used to build a model tree based on model structure parameters; Model table module, used to save the model tree as a model table in the database; The new version model module is used to define the model structure parameters of the new version and build the model tree of the new version; DDL module, used to obtain the differences between the new version of the model tree and the model table in the database, and generate DDL statements; The update module is used to update the model table in the database using DDL statements.

[0083] Preferably, the system further comprises: The data operation module is used to implement operations such as adding, updating, deleting or querying model data based on the web front end.

[0084] Embodiment 4

[0085] A computer program, when executed, implements the steps of the method based on web design business model as described in embodiment 1 or 2.

[0086] Embodiment 5

[0087] A readable storage medium stores a computer program as described in Example 4, and when the computer program is executed, the steps of the method based on the web design business model as described in Example 1 or 2 are implemented.

[0088] The above is only a specific embodiment of the present invention, but the protection scope of the present invention is not limited thereto. Any changes or substitutions that can be easily thought of by any technician familiar with the art within the technical scope disclosed in the present invention should be included in the protection scope of the present invention. Therefore, the protection scope of the present invention shall be based on the protection scope of the claims.

Claims

1. A method for designing a business model based on a web, characterized in that: The following steps are involved: Define model structure parameters; Based on the model structure parameters, a model tree is constructed; Save the model tree as a model table in the database; Define the model structure parameters of the new version and build the model tree of the new version; Get the differences between the new version of the model tree and the model table in the database, and generate DDL statements; Use DDL statements to update the model table in the database.

2. The method based on web design business model according to claim 1, characterized in that: The model structure parameters include: model attributes, model table fields, model table indexes, form fields, list fields, query condition fields, and association relationships.

3. The method based on web design business model according to claim 2, characterized in that: The form is a form page rendered by the model; the list is a list page rendered by the model; and the association relationship is used to define other models associated with the model.

4. The method based on web design business model according to claim 1, characterized in that: The method based on the web design business model also includes: Based on the web front end, operations such as adding, updating, deleting or querying model data are implemented.

5. The method based on web design business model according to claim 4, characterized in that: New model data includes: Organize the model table into Json format data and send it to the web front end; The web front end parses the Json format data and renders it into a form page for users to enter new model data; The user inputs new model data; The web front end calls the new interface of the back end to save the new model data to the database.

6. The method based on web design business model according to claim 4, characterized in that: Updating model data includes: The web front end calls the back end query interface to obtain the model data required by the user; The web front end displays the model data on the form page; The user modifies the model data; The web front end calls the back end update interface to save the model data modified by the user to the database.

7. The method based on web design business model according to claim 4, characterized in that: Deleting model data includes: The web front end calls the back end query interface to obtain the model data required by the user; The web front end displays the model data on the form page; User deletes model data; The web front end calls the back end deletion interface to delete the model data deleted by the corresponding user in the database.

8. The method based on web design business model according to claim 4, characterized in that: Query model data includes: Organize the model table into Json format data and send it to the web front end; The web front end parses the Json format data and renders it into a list page for users to enter query conditions; The user sets the query conditions; The web front end calls the back end query interface to obtain the model data queried by the user.

9. A system based on a web design business model, characterized in that: The method based on the web design business model according to any one of claims 1 to 8 comprises: Model definition module, used to define model structure parameters; Model tree module, used to build a model tree based on model structure parameters; Model table module, used to save the model tree as a model table in the database; The new version model module is used to define the model structure parameters of the new version and build the model tree of the new version; DDL module, used to obtain the differences between the new version of the model tree and the model table in the database, and generate DDL statements; The update module is used to update the model table in the database using DDL statements.

10. A computer program, characterized in that When the computer program is executed, the steps of the method based on the web design business model according to any one of claims 1 to 8 are implemented.

Images