WO2019218597A1 - Automatic construction method and system for table driven cloud-model software - Google Patents

Automatic construction method and system for table driven cloud-model software Download PDF

Info

Publication number
WO2019218597A1
WO2019218597A1 PCT/CN2018/111941 CN2018111941W WO2019218597A1 WO 2019218597 A1 WO2019218597 A1 WO 2019218597A1 CN 2018111941 W CN2018111941 W CN 2018111941W WO 2019218597 A1 WO2019218597 A1 WO 2019218597A1
Authority
WO
WIPO (PCT)
Prior art keywords
user
information
software
model
web
Prior art date
Application number
PCT/CN2018/111941
Other languages
French (fr)
Chinese (zh)
Inventor
杨灿
刘宇
潘诗颖
李闰民
Original Assignee
华南理工大学
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 华南理工大学 filed Critical 华南理工大学
Publication of WO2019218597A1 publication Critical patent/WO2019218597A1/en

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/30Creation or generation of source code
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/30Creation or generation of source code
    • G06F8/31Programming languages or programming paradigms
    • G06F8/312List processing, e.g. LISP programming language
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network arrangements or protocols for supporting network services or applications
    • H04L67/01Protocols
    • H04L67/02Protocols based on web technology, e.g. hypertext transfer protocol [HTTP]
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00Energy efficient computing, e.g. low power processors, power management or thermal management

Definitions

  • the present invention spans the programming and deployment steps of the traditional Web software development, and extracts the common features of the general information system software, and provides an automatic construction method of the Web software system that satisfies the specific needs of various users, thereby greatly improving the software development programming. Cost; and embed this invention method into the cloud environment to improve the timeliness of software deployment releases.
  • Another object of the present invention is to provide a table-driven cloud mode software automatic construction system by using the above table-driven cloud mode software automatic construction method.
  • the present invention adopts the following technical solutions:
  • a table-driven cloud mode software automatic construction method comprising the following steps:
  • S1 The user fills in the software system requirement information according to the form format provided or agreed by the Web software framework, and generates a software system information table; and then submits the completed software system requirement table to the Web software framework online or offline; the software system requirements
  • the information includes: system administrator information, user group information, user information, and model information; the web software framework is an application deployed on a web server;
  • the web software framework performs data type and format verification on each software system requirement information in the software system requirement table through the data analysis server, and determines whether the format requirement of the software system requirement table is met; if the verification fails, If the user is prompted to have a wrong format, please re-upload the software system requirement table, that is, repeat step S1, step S2, and current step; if the verification is passed, proceed to the next step;
  • step S43 The web software system obtained in step S42 is injected into the web software framework through the software injection server, and is automatically deployed and distributed in the cloud through the web software framework for the user to access and use;
  • the user When the user wants to batch inject data into the created Web software system, the user fills in a data record exchange table, where the data record exchange table includes model field information and data record information, and then submits to the Web software framework, the Web software.
  • the framework reads the information of the data record exchange table, and then performs format verification on the read information.
  • the Web software framework For the data exchange record table passed by the test, the Web software framework reads the model field information therein, and determines according to the model field information. The model for which data is to be exchanged, and then the data record information is injected into the model, that is, the data injection operation is completed.
  • the software system requirement information includes: system administrator information, user group information, user information, and model information, as follows:
  • the system administrator information includes: a system administrator ID, a system administrator password, and a system title;
  • the user group information is a user group ID, and multiple user groups can be customized according to requirements;
  • the user information includes: a user ID, a user name, a user password, and a group ID to which the user belongs;
  • the submission manner of the software system requirement table includes: online submission and offline submission; the online submission: the user fills in the software system requirement information online and submits to the web software framework according to the web form format provided by the web software framework; Submit: The user fills in the software system requirements information offline according to the offline form format template agreed by the Web software framework and submits it to the Web software framework in file upload mode.
  • the web software framework is an application deployed on a web server, with a system display interface;
  • the system display interface includes: a system administrator interface and a user interface;
  • the user interface includes data management, data statistics, import and export of Excel tables and other format tables, and advanced search;
  • the data management is used to manage records of the Web software system data table to be created, and the management function includes adding data. Recording, deleting data records, modifying data records, and obtaining all data records;
  • the data statistics are used to perform statistics on data table records of the Web software system to be created, and the statistics function includes recording statistics on data table integer fields.
  • the web software framework automatically reads various system requirement information in the software system requirement table, and the automatic reading unit includes a software system requirement table traversal unit, a system administrator information reading unit, and a user. a group information reading unit, a user information reading unit, and a model information reading unit;
  • the software system requirement table traversal unit is configured to traverse the software system requirement table
  • the system administrator information reading unit is configured to read a system administrator ID, a system administrator password, and a system title when traversing system administrator information;
  • the user group information reading unit is configured to read user group ID information when traversing user group information
  • the user information reading unit is configured to read a user ID, a user name, a user password, and a group ID to which the user belongs when traversing the user information, where the group ID of the user belongs to the user group ID included in the user group information. ;
  • step S3 the Web software framework performs data type and format verification on each software system requirement information in the software system requirement table, specifically, reading and writing the user in the group of the user group in the model information. Whether the permissions, other user read and write permissions, model field types, and field values allow empty values to meet the filling requirements; if the user belongs to a group item that is not empty, determine whether the value of the item is included in the software system requirements table. User group information.
  • the Web software framework automatically constructs a Web software system through an underlying code class
  • the underlying code class involves five classes, four interfaces, wherein five classes include: a requirement table read class Read_Demand User group management class Manage_Group, user management class Manage_User, model management class Manage_Schema, and data management class Manage_Data; 4 interfaces, including: user group management interface GManage_Group, user management interface GManage_User, model management interface GManage_Schema, and data management interface GManage_Data
  • the automated construction of the Web software system by the underlying code class includes the following steps:
  • the submission manner of the data exchange record table includes: online submission and offline submission; the online submission: when the user constructs the web software system according to the web software framework, the data input through the web software system is entered into the web page, and the online entry is performed.
  • the information in the data exchange record table is submitted to the web software system; the offline submission: when the user constructs the web software system according to the web software generation framework, the data record exchange table template format provided by the web software system is offline
  • the model field information and the data record information are entered and submitted to the web software system in a file upload manner.
  • a software automatic construction system for table-driven cloud mode software automatic construction method comprising a client, a data acquisition module, a data analysis module, a software construction module, a software injection module, and a web server; the client is used for user filling in software
  • the system requirement table is submitted to the data acquisition module, and the data acquisition module traverses the software system requirement table through the data acquisition server, and classifies and reads the information recorded in the software system requirement table, and then classifies the read software.
  • FIG. 1 is a flowchart of a method for automatically constructing a table-driven cloud mode software system of Embodiment 1;
  • 3(a) to 3(c) are respectively a user management interface, a user group management interface, and a model management interface under the system administrator interface of the University City Auto 4S service management information system of the application example;
  • 4 is a system interface of a general user interface of a university city automobile 4S service management information system according to an application example
  • Embodiment 5 is a flow chart of table-driven automated injection data recording of Embodiment 1;
  • FIG. 6 is a diagram showing a use case of a super administrator module of the automatically generated Web software system of Embodiment 1;
  • FIG. 7 is a diagram showing a use case of a system administrator module of the automatically generated Web software system of Embodiment 1;
  • FIG. 8 is a diagram showing a use case of a user module of the automatically generated Web software system of Embodiment 1;
  • Embodiment 9 is a UML class diagram of the automated construction flow of Embodiment 1;
  • FIG. 11 is a state diagram of an application example of a Web software system constructed by using a table-driven cloud mode software system automatic construction method in Embodiment 1;
  • Embodiment 12 is a table driven cloud mode software system automatic construction system of Embodiment 2.
  • system requirements table represents the software system requirements table.
  • S1 The user fills in the software system requirement information according to the form format provided or agreed by the Web software framework, and generates a software system information table; and then submits the completed software system requirement table to the Web software framework online or offline; the software system requirements
  • the information includes: system administrator information, user group information, user information, and model information; the web software framework is an application deployed on a web server;
  • the web software framework receives a storage path of the software system requirement table specified by the user through a data obtaining server, and obtains the software system requirement table according to the storage path, and then the web software framework performs the obtained software system requirement table. Traversing, reading various types of information recorded in the software system requirements table, and transmitting the read software system requirement information to the data analysis server;
  • the Web software framework automates the construction of the Web software system and deploys and publishes it in the cloud, and updates the Web software system;
  • the underlying code class involves five classes and four interfaces, wherein five classes include: The requirement table reads the class Read_Demand, the user group management class Manage_Group, the user management class Manage_User, the model management class Manage_Schema, and the data management class Manage_Data; four interfaces, including: user group management interface GManage_Group, user management interface GManage_User, model management interface GManage_Schema And the data management interface GManage_Data; obtain the demand information in the system requirement table through the Read_Demand class, perform the corresponding generating database entity and generate the database entity set operation; the Manage_Group class implements the GManage_Group interface, and the user in the group set of the database entity The group data is operated; Manage_User implements the GManage_User interface to operate on the user data in the user collection of the
  • the Web software framework automatically constructs a Web software system through the underlying code class.
  • the external activities are as follows:
  • the Web software framework registers a software system according to the administrator information registration of the software system requirement table passed through the verification, and then sequentially determines the software system requirement table. Whether there is user group information, user information, model information or structural information in the model. If it exists, the Web software framework reads the corresponding information in the software system requirements table, and generates user groups, users, and software systems in the created software system. Model, or model field; for multiple model cases in the software system requirements table, the Web software framework repeatedly reads the model information until all the models are read, and the final Web software system is generated; as shown in Figure 2,
  • the steps specifically include the following steps:
  • the web software framework reads the administrator information in the software system requirement table, where the administrator information includes a system administrator user name, a system administrator password, and information for creating a software system name; according to the read administrator information. , creating a software system;
  • the web software framework determines whether the user group information exists in the software system requirement table. If the user group information exists in the software system requirement table, and the user group information is a user group ID, according to the read user group ID, step S411 is performed. The user group is generated in the created software system; if the user group information does not exist in the software system requirement table, the next step is performed;
  • the web software framework determines whether the user information of the software system requirement table exists. If the user information does not exist in the software system requirement table, the user information includes a user ID, a user name, a user password, and a group to which the user belongs, according to the read User information is generated in the software system created in step S411; if user information exists in the software system requirements table, the next operation is performed;
  • System administrator information including: a) system administrator ID; b) system administrator password;
  • User group information part including: a) user group ID; multiple user groups can be filled according to requirements; if no user group is needed, the user group ID is not filled; the user group ID information needs to be filled in the same row and different columns;
  • the user information part including: a) user ID; b) user name; c) user password; d) the user belongs to the group; the user belongs to the group, if a user belongs to multiple groups, it is separated by a comma; If the user does not belong to any group, do not fill in;
  • panshiying There are three users in the system, namely: panshiying, the user name is panshiying, the user password is panshiying, the group is group1; lirunmin, the user name is lirunmin, the user password is lirunmin, the group is group2; liuyu, Its user name is liuyu, the user password is liuyu, and the group is group1 and group2.
  • the second model is customer information, the group belongs to group1, the permissions of the members of the group are readable and writable, the permissions of other users are readable and unwritable, the entry is liuyu; there are 6 fields in the model.
  • the customer number of the field type is Integer, which is not allowed to be empty; the customer name of the field type is Text, which is not allowed to be empty; the ID of the field type is Text, which is allowed to be empty; the service organization whose field type is Text is allowed to be Empty; the field type is the income status of Text, which is allowed to be empty; the field type is Integer's age, which is allowed to be empty.
  • the third model is maintenance information, the group belongs to group2, the permissions of the members of the group are readable and writable, the permissions of other users are readable and unwritable, the entry is liuyu; there are 7 fields in the model. : Service type with field type Integer, allowed to be empty; customer name with field type Text, allowed to be empty; vehicle name with field type Text, allowed to be empty; vehicle number with field type Text, allowed to be empty; field The type of fault of type Text is allowed to be empty; the maintenance record of the field type is Text, which is allowed to be empty; the repair cost of the field type is Text, which is allowed to be empty.
  • the super administrator of the Web software framework reads the system administrator ID, system administrator password and system title in the software system requirements table, and registers the system administrator account in the background of the Web software framework.
  • the data record exchange table can be filled in and the data is injected into the Web software system in batches.
  • the data record exchange table includes the following two parts:
  • Field information part The user fills in the model field according to the data record to be injected.
  • the automated injection of data records includes the following steps:
  • the Web software framework obtains 1) the data record exchange table uploaded by the client, and verifies whether the format of the data record exchange table meets the requirements. If it does not match, the user is prompted to format the error, please re-upload, if it is met, transfer to 3).
  • the user group management includes eight use cases, namely, adding a user group, deleting a user group, editing a user group, obtaining a user group list, obtaining a user group user list, adding a user to a user group, and a user group. Delete the user, get a list of models that the user group has permission;
  • the model management contains four use cases, namely adding a model, deleting a model, editing a model, and obtaining a list of system models;
  • Figure 8 shows a user interface use case diagram of the automatically generated Web software system, which is described as follows:
  • participant is associated with five use cases, namely data management, data statistics, import data records, export data records, advanced search;
  • the automated construction Web software system is implemented by the underlying code class.
  • the low-level code class mainly involves five classes and four interfaces. Among them, five classes include: the requirement table read class Read_Demand, the user group management class Manage_Group, and the user management class Manage_User. , model management class Manage_Schema, and data management class Manage_Data; 4 interfaces, including: user group management interface GManage_Group, user management interface GManage_User, model management interface GManage_Schema, data management interface GManage_Data;
  • FIG. 10 is an activity diagram of an application example of a Web software system constructed by using the software automatic construction method of the present invention, and the specific description is as follows:
  • the Web software framework determines whether there is user group information in the system requirements table. If it exists, the user group is created and the user group creation success status is entered. If it does not exist, the user group is not created and the user group status is not created.
  • the Web software framework determines whether there is user information in the system requirements table. If it exists, the user is created and the user creation success status is entered. If it does not exist, the user is not created and the user status is not created.
  • the Web software framework determines whether there are model fields and other information in the system requirements table. If it exists, create a model field, etc., and enter the model field to create a successful state; if it does not exist, the model field is not created, and the model field state is not created.
  • the client, the data acquisition server, the data analysis server, the software construction server, the software injection server, and the web server all adopt a PC computer, and the Http communication mode is adopted between the client and the web server.
  • the communication protocol uses the TCP protocol; the rest of the servers use the Socket communication method, and the communication protocol uses the TCP protocol.

Abstract

An automatic construction method and system for a table driven cloud-model software. The method comprises the following steps: a user fills in related demand information in a software system demand table and submits the table; a Web software automatic construction framework is used to automatically read the related information of each demand in the received software system demand table and to analyze and check the read related information of each system demand; and according to information in a software system demand table passing the check, a Web software system matching the demand is automatically constructed and is injected into a cloud environment in which the corresponding Web software framework is positioned. The software automatic construction method and system simplifies the complex software development process in a traditional mode, supports a multi-tenant software-as-a-service cloud model, and omits for a user the programming and deployment links in a conventional information management system software development process, such that the user can rapidly and efficiently construct a Web software system satisfying a demand by only focusing on defining system demands and software development efficiency is greatly improved.

Description

一种表驱动的云模式软件自动构造方法及系统Table-driven cloud mode software automatic construction method and system 技术领域Technical field
本发明涉及软件工程技术领域,具体涉及到一种表驱动的云模式软件自动构造方法及系统。The present invention relates to the field of software engineering technologies, and in particular, to a table-driven cloud mode software automatic construction method and system.
背景技术Background technique
随着互联网及云计算技术的高速发展,信息和数据收集、存储、查询等方面的需求日益成为信息社会的常态需求,无论是企业级应用开发者还是非企业级应用开发者,设计开发出针对特定需求的Web软件系统是一个十分普遍的客观需求。传统模式下软件从设计到生产通常都要经历相对繁琐的开发过程,包括需求分析、软件设计、程序编写、测试验证与系统部署等环节。并且每个用户所给定的需求也是不同的,如果针对每种需求都要经历这样一个繁杂的软件开发流程显然是非常耗费时间和资源的。然而,一般信息系统软件围绕数据的采集、存储、增删改查等操作具有共性特征,并且软件即服务云模式也为软件即时部署提供了技术可行性。因此,本发明跨越传统Web软件开发的编程和部署环节,通过抽取构造一般信息系统软件的共性特征,提供一种满足多种用户特定需求的Web软件系统自动构造方法,以大大节省提高软件开发编程成本;并将这一发明方法嵌入云环境,以提高软件部署发布的时效性。With the rapid development of the Internet and cloud computing technologies, the demand for information and data collection, storage, and query has become the norm in the information society. Whether it is an enterprise application developer or a non-enterprise application developer, the design and development are targeted at Web software systems with specific needs are a very common objective requirement. In traditional mode, software usually goes through a relatively cumbersome development process from design to production, including requirements analysis, software design, programming, test verification and system deployment. And the requirements given by each user are also different. It is obviously very time consuming and resourceful to go through such a complicated software development process for each requirement. However, the general information system software has common features around data collection, storage, addition, deletion and change operations, and the software-as-a-service cloud model also provides technical feasibility for software real-time deployment. Therefore, the present invention spans the programming and deployment steps of the traditional Web software development, and extracts the common features of the general information system software, and provides an automatic construction method of the Web software system that satisfies the specific needs of various users, thereby greatly improving the software development programming. Cost; and embed this invention method into the cloud environment to improve the timeliness of software deployment releases.
发明内容Summary of the invention
本发明的目的在于克服现有技术中的缺点与不足,提供一种表驱动的云模式软件自动构造方法,通过一个Web软件自动构造框架(WSACF,简称Web软件框架)自动读取、分析用户填写的软件系统需求表,然后根据读取的需求信息构造Web软件系统,并注入相应的Web软件框架所处云环境中,即可供用户使用,为用户省去耗时的编程开发与部署工作而只需专注于定义系统需求即可快速高效的构造出满足需求的Web软件系统,大大提高软件生产效率。The object of the present invention is to overcome the shortcomings and deficiencies in the prior art, and to provide a table-driven cloud mode software automatic construction method, which automatically reads and analyzes user fillings through a Web software automatic construction framework (WSACF, referred to as Web software framework). The software system requirements table, and then construct the Web software system according to the read demand information, and inject into the cloud environment where the corresponding Web software framework is located, that is, for the user to use, to save the user time-consuming programming development and deployment work. By focusing on defining system requirements, you can quickly and efficiently construct a Web software system that meets your needs, greatly improving software production efficiency.
本发明的另一目的在于运用上述的表驱动的云模式软件自动构造方法,提供一种表驱动的云模式软件自动构造系统。Another object of the present invention is to provide a table-driven cloud mode software automatic construction system by using the above table-driven cloud mode software automatic construction method.
为实现以上目的,本发明采取如下技术方案:To achieve the above object, the present invention adopts the following technical solutions:
一种表驱动的云模式软件自动构造方法,包括下述步骤:A table-driven cloud mode software automatic construction method, comprising the following steps:
S1、用户根据Web软件框架提供或约定的表单格式,填写软件系统需求信息,生成软件系统信息表;然后将填写完成的软件系统需求表在线或离线提交至Web软件框架中;所述软件系统需求信息包括:系统管理员信息、用户组信息、用户信息、以及模型信息;所述Web软件框架是一个部署在Web服务器上的应用;S1: The user fills in the software system requirement information according to the form format provided or agreed by the Web software framework, and generates a software system information table; and then submits the completed software system requirement table to the Web software framework online or offline; the software system requirements The information includes: system administrator information, user group information, user information, and model information; the web software framework is an application deployed on a web server;
S2、所述Web软件框架通过数据获取服务器接收用户指定的所述软件系统需求表的存储路径,并根据存储路径,获取所述软件系统需求表,然后Web软件框架对获取的软件系统需求表进行遍历,读取软件系统需求表所记载的各类信息,并将读取的各项软件系统需求信息传输至数据分析服务器;S2. The web software framework receives a storage path of the software system requirement table specified by the user through a data obtaining server, and obtains the software system requirement table according to the storage path, and then the web software framework performs the obtained software system requirement table. Traversing, reading various types of information recorded in the software system requirements table, and transmitting the read software system requirement information to the data analysis server;
S3、所述Web软件框架通过数据分析服务器对软件系统需求表中的各项软件系统需求信息进行数据类型及格式校验,判断是否满足软件系统需求表的格式填写要求;若校验不通过,则提示用户格式有误请重新上传软件系统需求表,即重复步骤S1、步骤S2和当前步骤;若校验通过,进行下一步操作;S3. The web software framework performs data type and format verification on each software system requirement information in the software system requirement table through the data analysis server, and determines whether the format requirement of the software system requirement table is met; if the verification fails, If the user is prompted to have a wrong format, please re-upload the software system requirement table, that is, repeat step S1, step S2, and current step; if the verification is passed, proceed to the next step;
S4、Web软件框架根据校验通过的软件系统需求表的各项信息构造Web软件系统,并注入Web软件框架所处云环境中,然后对所构造的Web软件系统进行使用;S4. The Web software framework constructs a Web software system according to various information of the software system requirement table passed by the verification, and injects into the cloud environment where the Web software framework is located, and then uses the constructed Web software system;
S41、设计Web软件框架的底层代码类,所述底层代码类用于实现Web软件框架内部自动化构造Web软件系统;S41. Designing an underlying code class of a Web software framework, wherein the underlying code class is used to implement an internal Web software system for automatically constructing a Web software framework;
S42、Web软件框架通过底层代码类自动化构造Web软件系统,其外部活动过程为:Web软件框架根据校验通过的软件系统需求表的管理员信息注册创建一个软件系统,然后再依次判断软件系统需求表中是否存在用户组信息、用户信息、模型信息或模型内结构信息,若存在,则Web软件框架读取软件系统需求表中对应存在的信息,并在创建的软件系统中生成用户组、用户、模型、或模型字段;对于软件系统需求表中存在多个模型情况,Web软件框架重复读取模型信息,直到读取完所有数量的模型,生成最终的Web软件系统;S42. The Web software framework automatically constructs the Web software system through the underlying code class. The external activity process is as follows: The Web software framework registers a software system according to the administrator information registration of the software system requirement table passed through the verification, and then sequentially determines the software system requirements. Whether the user group information, user information, model information, or structure information in the model exists in the table. If yes, the Web software framework reads the corresponding information in the software system requirement table, and generates a user group and a user in the created software system. , model, or model field; for multiple model cases in the software system requirements table, the Web software framework repeatedly reads the model information until all the models are read, and the final Web software system is generated;
S43、通过软件注入服务器将步骤S42获得的Web软件系统注入Web软件框架,并通过Web软件框架在云端自动部署和发布,供用户访问使用;S43. The web software system obtained in step S42 is injected into the web software framework through the software injection server, and is automatically deployed and distributed in the cloud through the web software framework for the user to access and use;
S44、当用户要在所创建的Web软件系统批量注入数据时,用户填写数据记录交换表,所述数据记录交换表包括模型字段信息和数据记录信息,然后提交至Web软件框架,所述Web软件框架对数据记录交换表的信息进行读取,然后对读取后的信息进行格式校验,对于检验通过的数据交换记录表,Web软件框架读取其中的模型字段信息,并根据模型字段信息确定所要进行数据交换的模型,然后将数据记录信息注入该模型中,即完成数据注入操作。S44. When the user wants to batch inject data into the created Web software system, the user fills in a data record exchange table, where the data record exchange table includes model field information and data record information, and then submits to the Web software framework, the Web software. The framework reads the information of the data record exchange table, and then performs format verification on the read information. For the data exchange record table passed by the test, the Web software framework reads the model field information therein, and determines according to the model field information. The model for which data is to be exchanged, and then the data record information is injected into the model, that is, the data injection operation is completed.
作为优选的技术方案,步骤S1中,所述软件系统需求信息包括:系统管理员信息、用户组信息、用户信息、以及模型信息,具体如下:As a preferred technical solution, in step S1, the software system requirement information includes: system administrator information, user group information, user information, and model information, as follows:
所述系统管理员信息包括:系统管理员ID、系统管理员密码、以及系统标题;The system administrator information includes: a system administrator ID, a system administrator password, and a system title;
所述用户组信息为用户组ID,可根据需求自定义多个用户组;The user group information is a user group ID, and multiple user groups can be customized according to requirements;
所述用户信息包括:用户ID、用户名、用户密码、以及用户所属组ID;The user information includes: a user ID, a user name, a user password, and a group ID to which the user belongs;
所述模型信息,可根据需求自定义多个模型,所包括的信息具体有:用户所属组的组内用户读写权限、其他用户读写权限、模型名称、模型录入员ID、所属组ID、模型字段类型、模型字段名、字段值是否允许空、缺省值、以及备选值;其中所述用户所属组的组内用户读写权限和他用户读写权限包括:可读可写、可读不可写、以及不可读不可写;所述模型录入员ID为用户信息中用户ID所包含;所述所属组ID为用户组中用户组ID所包含;所述模型字段类型,其取值包括:Text、Float、Integer、Link、Date、Datetime、以及Boolean;所述字段值是否允许空,其取值包括:TRUE、FALSE,其中TRUE表示允许为空,FALSE表示不允许为空;The model information may be customized according to requirements, and the information included includes: user read and write permissions, other user read and write permissions, model name, model entry ID, and group ID of the group to which the user belongs. The model field type, the model field name, the field value is allowed to be null, the default value, and the alternative value; wherein the user read and write permission of the group and the user read and write permissions of the group to which the user belongs include: readable and writable, The model is not writable, and is unreadable and unwritable; the model entry ID is included in the user ID in the user information; the belonging group ID is included in the user group ID in the user group; the model field type, the value of which includes : Text, Float, Integer, Link, Date, Datetime, and Boolean; whether the field value is allowed to be null, and its value includes: TRUE, FALSE, where TRUE means that the space is allowed to be empty, and FALSE means that it is not allowed to be empty;
所述软件系统需求表的提交方式包括:在线提交和离线提交;所述在线提交:用户根据Web软件框架提供的Web表单格式,在线填写软件系统需求信息并提交到该Web软件框架;所述离线提交:用户根据Web软件框架约定的离线表单格式模版,离线填写软件系统需求信息并以文件上传方式提交到Web软件框架。The submission manner of the software system requirement table includes: online submission and offline submission; the online submission: the user fills in the software system requirement information online and submits to the web software framework according to the web form format provided by the web software framework; Submit: The user fills in the software system requirements information offline according to the offline form format template agreed by the Web software framework and submits it to the Web software framework in file upload mode.
作为优选的技术方案,步骤S1中,所述Web软件框架是一个部署在Web服务器上的应用,带有系统显示界面;所述系统显示界面包括:系统管理员界面和用户界面;As a preferred technical solution, in step S1, the web software framework is an application deployed on a web server, with a system display interface; the system display interface includes: a system administrator interface and a user interface;
所述系统管理员界面包括用户管理、用户组管理、以及模型管理;所述用户管理用于对所要创建的Web软件系统的用户信息进行管理,管理功能包括增加用户、删除用户、为用户增加用户组信息、以及为用户删除用户组信息;所述用户组管理用于对所要创建的Web软件系统的用户组信息进行管理,管理功能包括增加用户组、删除用户组、为用户组增加用户信息、以及为用户组删除用户信息;所述模型管理用于对所要创建的Web软件系统的模型信息进行管理,管理功能包括增加模型信息、删除模型信息、增加模型字段信息、删除模型字段信息、修改模型字段信息、以及针对模型对不同的用户组分配不同的访问权限;The system administrator interface includes user management, user group management, and model management; the user management is used to manage user information of the Web software system to be created, and the management functions include adding users, deleting users, and adding users to users. Group information, and deleting user group information for the user; the user group management is used to manage user group information of the Web software system to be created, and the management functions include adding a user group, deleting a user group, adding user information to the user group, And deleting user information for the user group; the model management is used to manage model information of the Web software system to be created, and the management function includes adding model information, deleting model information, adding model field information, deleting model field information, and modifying the model. Field information, and assign different access rights to different user groups for the model;
所述用户界面包括数据管理、数据统计、导入和导出Excel表及其他格式表、以及高级搜索;所述数据管理用于对所要创建的Web软件系统数据表的记录进行管理,管理功能包括增加数据记录、删除数据记录、修改数据记录、以及获取所有数据记录;所述数据统计用于对所要创建的Web软件系统的数据表记录进行统计,统计功能包括可针对数据表整型字段进行记录数统计、最大值统计、最小值统计、以及平均值统计;所述导入和导出Excel表及其他格式表用于将Excel表及其他格式表中的数据导入至所创建的Web软件系统的相应表中,并可将Web软件系统的表中的数据导出至Excel表及其他格式表中;所述高级搜索用于对Excel表及其他格式表的多个字段进行多种逻辑组合搜索,查询出满足搜索条件的记录信息。The user interface includes data management, data statistics, import and export of Excel tables and other format tables, and advanced search; the data management is used to manage records of the Web software system data table to be created, and the management function includes adding data. Recording, deleting data records, modifying data records, and obtaining all data records; the data statistics are used to perform statistics on data table records of the Web software system to be created, and the statistics function includes recording statistics on data table integer fields. , maximum statistics, minimum statistics, and average statistics; the import and export of Excel tables and other format tables for importing data in Excel tables and other format tables into the corresponding table of the created Web software system, The data in the table of the Web software system can be exported to an Excel table and other format tables; the advanced search is used to perform multiple logical combination searches on multiple fields of the Excel table and other format tables, and the query meets the search condition. Record information.
作为优选的技术方案,步骤S2中,Web软件框架自动读取软件系统需求表中的各项系统需求信息,其自动读取单元包括软件系统需求表遍历单元、系统管理员信息读取单元、用户组信息读取单元、用户信息读取单元、以及模型信息读取单元;As a preferred technical solution, in step S2, the web software framework automatically reads various system requirement information in the software system requirement table, and the automatic reading unit includes a software system requirement table traversal unit, a system administrator information reading unit, and a user. a group information reading unit, a user information reading unit, and a model information reading unit;
所述软件系统需求表遍历单元用于对软件系统需求表进行遍历;The software system requirement table traversal unit is configured to traverse the software system requirement table;
所述系统管理员信息读取单元用于在遍历系统管理员信息时,读取系统管理员ID、系统管理员密码、以及系统标题;The system administrator information reading unit is configured to read a system administrator ID, a system administrator password, and a system title when traversing system administrator information;
所述用户组信息读取单元用于,用于在遍历用户组信息时,读取用户组ID信息;The user group information reading unit is configured to read user group ID information when traversing user group information;
所述用户信息读取单元,用于在遍历用户信息时,读取用户ID、用户名、用户密码、以及用户所属组ID,其中所述用户所属组ID为用户组信息中包含的用户组ID;The user information reading unit is configured to read a user ID, a user name, a user password, and a group ID to which the user belongs when traversing the user information, where the group ID of the user belongs to the user group ID included in the user group information. ;
所述模型信息读取单元,用于在遍历模型信息时,读取用户所属组的组内用户读写权限、其他用户读写权限、模型名称、模型录入员ID、用户所属组ID、字段类型、字段名、字段值是否允许为空、缺省值、以及备选值。The model information reading unit is configured to: when traversing the model information, read the user read/write permission, other user read/write permission, model name, model entry ID, user belonging group ID, and field type of the group to which the user belongs. , field name, field value is allowed to be empty, default value, and alternate value.
作为优选的技术方案,步骤S3中,Web软件框架对软件系统需求表中的各项软件系统需求信息进行数据类型及格式校验,具体是对模型信息中的用户所属组的组内用户读写权限、其他用户读写权限、模型字段类型、以及字段值是否允许空的取值是否满足填写要求;若用户所属组项不为空,则判断该项所填值是否包含于软件系统需求表中的用户组信息。As a preferred technical solution, in step S3, the Web software framework performs data type and format verification on each software system requirement information in the software system requirement table, specifically, reading and writing the user in the group of the user group in the model information. Whether the permissions, other user read and write permissions, model field types, and field values allow empty values to meet the filling requirements; if the user belongs to a group item that is not empty, determine whether the value of the item is included in the software system requirements table. User group information.
作为优选的技术方案,步骤S41中,Web软件框架通过底层代码类自动化构造Web软件系统,所述底层代码类涉及5个类,4个接口,其中,5个类包括:需求表读取类Read_Demand、用户组管理类Manage_Group、用户管理类Manage_User、模型管理类Manage_Schema、以及数据管理类Manage_Data;4个接口,包括:用户组管理接口GManage_Group、用户管理接口GManage_User、模型管理接口GManage_Schema、以及数据管理接口GManage_Data;通过所述底层代码类自动化构造Web软件系统,具体包括下述步骤:As a preferred technical solution, in step S41, the Web software framework automatically constructs a Web software system through an underlying code class, the underlying code class involves five classes, four interfaces, wherein five classes include: a requirement table read class Read_Demand User group management class Manage_Group, user management class Manage_User, model management class Manage_Schema, and data management class Manage_Data; 4 interfaces, including: user group management interface GManage_Group, user management interface GManage_User, model management interface GManage_Schema, and data management interface GManage_Data The automated construction of the Web software system by the underlying code class includes the following steps:
(1)、通过需求表读取类Read_Demand中用来处理系统管理员信息的API读取软件系统需求表中的系统管理员板块,遍历其单元格,根据系统管理员ID、系统管理员密码和系统名称在Web软件框架的超级管理员权限下注册软件系统,并在该Web软件框架的底层数据库中创建软件系统相应的数据库实体,同时在该数据库下创建4个Collection,分别为用户组group、用户user、模型schema、数据data;其中所述超级管理员是Web软件框架的最高权限管理员,用于接收用户设定的管理员信息并在Web框架中注册软件系统;所述Web软件框架的底层数据库用于Web软件框架存储数据;(1) Read the system administrator section in the API read request system table in the Read_Demand class to read the system administrator information through the requirements table, traverse its cell, according to the system administrator ID, system administrator password, and The system name registers the software system under the super administrator authority of the Web software framework, and creates the corresponding database entity of the software system in the underlying database of the Web software framework, and creates four Collections under the database, respectively, the user group group, User user, model schema, data data; wherein the super administrator is the highest authority administrator of the web software framework, and is configured to receive administrator information set by the user and register the software system in the web framework; the web software framework The underlying database is used by the Web software framework to store data;
(2)、通过需求表读取类Read_Demand中用来处理用户组信息的API读取软件系统需求表中的用户组信息,遍历其填写的用户组ID信息单元格,根据得到的用户组ID信息生成Json格式的字符串,并将其插入到步骤(1)创建的数据库实体的用户组group集合中;(2) reading the user group information in the API reading software system requirement table of the class Read_Demand for processing the user group information through the demand table, traversing the user group ID information cell filled in, and obtaining the user group ID information according to the obtained user group ID information. Generating a string in Json format and inserting it into the user group group collection of the database entity created in step (1);
(3)、通过需求表读取类Read_Demand中用来处理用户信息的API读取软件系统需求表中的用户信息,遍历其填写的用户信息,按行读取并遍历每行的单元格,根据得到的所有用户信息生成Json格式的字符串,并将其插入到步骤(1)创建的数据库实体的用户user集合中;(3) reading the user information in the API reading software system requirement table of the class Read_Demand for processing the user information through the demand table, traversing the user information filled in, reading and traversing the cells of each row according to the row, according to All the obtained user information generates a string in Json format and inserts it into the user user set of the database entity created in step (1);
(4)、通过需求表读取类Read_Demand中用来处理模型信息的API读取系统需求表的模型信息,遍历其填写的模型信息单元格,根据模型信息生成Json格式的字符串,并将其插入到步骤(1)创建的数据库实体的模型schema集合中;(4) reading the model information of the system requirement table in the API of the class Read_Demand for processing the model information through the requirement table, traversing the model information cell filled in, and generating a string of Json format according to the model information, and Insert into the model schema collection of the database entity created in step (1);
(5)、通过用户组管理类Manage_Group对底层数据库中数据库实体的用户组group集合中的用户组数据进行操作,并将操作结果返回给Web软件框架的系统显示界面,所述用户组管理类Manage_Group实现Web软件框架中定义的用户组管理接口GManage_Group;(5) operating the user group data in the user group group collection of the database entity in the underlying database by the user group management class Manage_Group, and returning the operation result to the system display interface of the Web software framework, the user group management class Manage_Group Implementing the user group management interface GManage_Group defined in the web software framework;
(6)、通过用户管理类Manage_User对底层数据库中数据库实体的用户user集合中的用户数据进行操作,并将操作结果返回给Web软件框架的系统显示界面;(6) operating the user data in the user user set of the database entity in the underlying database through the user management class Manage_User, and returning the operation result to the system display interface of the Web software framework;
(7)、通过模型管理类Manage_Schema对底层数据库中数据库实体的schema集合中的模型数据进行操作,并将结果返回给Web软件框架的界面,所述模型管理类Manage_Schema实现Web软件框架中定义的模型管理接口GManage_Schema;(7), through the model management class Manage_Schema to operate the model data in the schema collection of the database entity in the underlying database, and return the result to the interface of the Web software framework, the model management class Manage_Schema implements the model defined in the Web software framework Management interface GManage_Schema;
(8)、通过数据管理类Manage_Data对底层数据库中数据库实体的data集合中的数据记录进行操作,并将结果返回给Web软件框架的系统显示界面,所述数据管理类Manage_Data实现了Web软件框架中定义的数据管理接口GManage_Data。(8), through the data management class Manage_Data to operate on the data record in the data set of the database entity in the underlying database, and return the result to the system display interface of the Web software framework, the data management class Manage_Data is implemented in the Web software framework The defined data management interface GManage_Data.
作为优选的技术方案,在步骤S42中,Web软件框架通过底层代码类自动化构造Web软件系统,其外部活动的具体过程如下:As a preferred technical solution, in step S42, the Web software framework automatically constructs the Web software system through the underlying code class, and the specific process of the external activity is as follows:
S421、Web软件框架读取校验通过的软件系统需求表中的管理员信息,所述管理员信息包括系统管理员用户名、系统管理员密码、以及创建软件系统名称的信息;根据所读取的管理员信息,注册创建一个软件系统;S421: The web software framework reads the administrator information in the software system requirement table that passes the verification, where the administrator information includes a system administrator user name, a system administrator password, and information for creating a software system name; Administrator information, registration to create a software system;
S422、Web软件框架判断软件系统需求表是否存在用户组信息,若软件系统需求表中存在用户组信息,所述用户组信息为用户组ID,则根据所读取的用户组ID在步骤S411创建的软件系统中生成用户组;若软件系统需求表中不存在用户组信息,则进行下一步操作;S422: The web software framework determines whether the user group information exists in the software system requirement table. If the user group information exists in the software system requirement table, and the user group information is the user group ID, the user group ID is created according to the read user group ID in step S411. a user group is generated in the software system; if the user group information does not exist in the software system requirement table, the next step is performed;
S423、Web软件框架判断该软件系统需求表是否存在用户信息,若软件系统需求表中不存在用户信息,所述用户信息包括用户ID、用户名、用户密码、以及用户所属组,根据所读取的用户信息在在步骤S411创建的软件系统中生成用户;若软件系统需求表中存在用户信息,则进行下一步操作;S423. The web software framework determines whether the user information of the software system requirement table exists. If the user information does not exist in the software system requirement table, the user information includes a user ID, a user name, a user password, and a group to which the user belongs, according to the read User information is generated in the software system created in step S411; if user information exists in the software system requirements table, the next operation is performed;
S424、Web软件框架判断该软件系统需求表是否存在模型信息,若软件系统需求表存在模型信息,则读取软件系统需求表中的模型数量,并赋值当前计数值为0,然后读取模型信息,即模型名称、模型录入员、所属组ID、以及用户所属组的组内用户读写权限信息,并根据所读取的模型信息在在步骤S411创建的软件系统中创建指定模型;然后再判断模型内是否存在结构信息,若模型内存在结构信息,则读取模型内结构信息,即模型内结构字段名称、字段类型、字段值是否允许为空、缺省值、以及备选值,并根据所读取的模型内结构信息在已创建的指定模型内创建字段,同时当前模型数量计数值+1,然后判断当前计数是否小于模型数量,若当前计数小于模型数量,则继续读取下一个模型信息,重复该步骤操作;若当前计数大于模型数量,则Web软件框架完成软件系统的自构造,生成Web软件系统。S424. The Web software framework determines whether the software system requirement table has model information. If the software system requirement table has model information, the number of models in the software system requirement table is read, and the current count value is assigned to 0, and then the model information is read. , that is, the model name, the model entry clerk, the belonging group ID, and the user read/write authority information of the group to which the user belongs, and create a specified model in the software system created in step S411 according to the read model information; and then judge Whether there is structural information in the model. If there is structural information in the model, the structure information in the model is read, that is, whether the structure field name, field type, field value in the model is allowed to be empty, default value, and alternative value, and according to The read structure information in the model creates a field in the specified model that has been created, and the current model count value is +1, and then determines whether the current count is less than the model number. If the current count is less than the model number, the next model is continuously read. Information, repeat this step; if the current count is greater than the number of models, the Web software framework completes the software The self-construction of the system generates a web software system.
作为优选的技术方案,步骤S5中,所述用户填写数据记录交换表并提交至Web软件框架,具体如下:As a preferred technical solution, in step S5, the user fills in a data record exchange table and submits it to the web software framework, as follows:
所述数据交换记录表中的信息包括:模型字段信息和数据记录;所述模型字段信息是用户根据需求设置所要进行数据记录交换的模型的所有字段名;所述数据记录是用户根据需求添加需要注入到模型中的所有数据记录信息;The information in the data exchange record table includes: model field information and a data record; the model field information is all field names of a model that the user needs to perform data record exchange according to requirements; and the data record is added by the user according to requirements. All data record information injected into the model;
所述数据交换记录表的提交方式包括:在线提交和离线提交;所述在线提交:当用户根据Web软件框架构造出的Web软件系统,通过所述Web软件系统提供的数据录入Web页面,在线录入数据交换记录表中的信息并提交到该Web软件系统;所述离线提交:当用户根据Web软件生成框架构造出的Web软件系统,通过所述Web软件系统提供的数据记录交换表模版格式,离线录入模型字段信息和数据记录信息并以文件上传方式提交到该Web软件系统。The submission manner of the data exchange record table includes: online submission and offline submission; the online submission: when the user constructs the web software system according to the web software framework, the data input through the web software system is entered into the web page, and the online entry is performed. The information in the data exchange record table is submitted to the web software system; the offline submission: when the user constructs the web software system according to the web software generation framework, the data record exchange table template format provided by the web software system is offline The model field information and the data record information are entered and submitted to the web software system in a file upload manner.
一种表驱动的云模式软件自动构造方法的软件自动构造系统,包括客户端、数据获取模块、数据分析模块、软件构造模块、软件注入模块、以及Web服务器;所述客户端用于用户填写软件系统需求表并提交至数据获取模块,所述数据获取模块通过数据获取服务器遍历软件系统需求表,并对软件系统需求表所记载的信息进行分类读取,然后将分类读取后的各项软件系统需求信息传输至数据分析模块;所述数据分析模块通过数据分析服务器对获取的各项软件系统需求信息进行格式分析校验,若格式校验错误,则提醒用户重新填写软件系统需求表,若格式校验正确,则将格式校验正确的各项软件系统需求信息传输至软件构造模块;所述软件构造模块根据格式校验正确的各项软件系统需求信息,并通过软件构建服务器,自动构造出与该信息匹配的Web软件系统,然后将所述的Web软件系统传输至软件注入模块;所述软件注入模块通过软件注入服务器将Web软件系统注入Web软件框架,并通过Web软件框架将Web软件系统部署在Web服务器上,供用户访问使用;所述Web软件框架是一个用于自动构造软件,并部署在Web服务器上的应用,带有系统显示界面。A software automatic construction system for table-driven cloud mode software automatic construction method, comprising a client, a data acquisition module, a data analysis module, a software construction module, a software injection module, and a web server; the client is used for user filling in software The system requirement table is submitted to the data acquisition module, and the data acquisition module traverses the software system requirement table through the data acquisition server, and classifies and reads the information recorded in the software system requirement table, and then classifies the read software. The system requirement information is transmitted to the data analysis module; the data analysis module performs format analysis and verification on the acquired software system requirement information through the data analysis server, and if the format verification error occurs, the user is reminded to re-fill the software system requirement table, if If the format verification is correct, the software system requirement information with the correct format verification is transmitted to the software construction module; the software construction module verifies the correct software system requirement information according to the format, and constructs the server through the software, and automatically constructs a web software system that matches this information And then transferring the web software system to the software injection module; the software injection module injects the web software system into the web software framework through the software injection server, and deploys the web software system on the web server through the web software framework for user access The Web software framework is an application for automatically constructing software and deployed on a web server with a system display interface.
作为优选的技术方案,所述客户端、数据获取服务器、数据分析服务器、软件构造服务器、软件注入服务器、以及Web服务器均是采用PC电脑,所述客户端与Web服务器之间采用Http通信方式,通信协议采用TCP协议;其余服务器间均采用Socket通信方式,通信协议采用TCP协议。As a preferred technical solution, the client, the data acquisition server, the data analysis server, the software construction server, the software injection server, and the web server all adopt a PC computer, and the client and the web server adopt an Http communication manner. The communication protocol uses the TCP protocol; the rest of the servers use the Socket communication method, and the communication protocol uses the TCP protocol.
本发明相对于现有技术具有如下的优点和效果:The present invention has the following advantages and effects over the prior art:
本发明所提出的一种表驱动的云模式软件系统自动构造方法,不仅简化传统模式下繁杂的软件开发流程,并支持多租户软件即服务云模式,为用户省去了耗时的编程开发工作,使得用户只需专注于定义系统需求即可快速高效的构造出满足需求的Web软件系统,大大提高了软件开发效率,同时为企业级、非企业级用户定制满足自身需求的信息管理系统提供便利性。The table-driven cloud mode software system automatic construction method proposed by the invention not only simplifies the complicated software development process in the traditional mode, but also supports the multi-tenant software as the service cloud mode, thereby eliminating time-consuming programming development work for the user. This allows users to quickly and efficiently construct a Web software system that meets their needs by focusing on defining system requirements, greatly improving software development efficiency, and facilitating the customization of information management systems that meet their needs for enterprise and non-enterprise users. Sex.
附图说明DRAWINGS
图1为实施例1的表驱动的云模式软件系统自动构造方法的流程图;1 is a flowchart of a method for automatically constructing a table-driven cloud mode software system of Embodiment 1;
图2为实施例1的表驱动的云模式软件系统自动构造方法的具体工作流程图;2 is a specific working flow chart of the automatic construction method of the table-driven cloud mode software system of Embodiment 1;
图3(a)-图3(c)分别为本应用实例的大学城汽车4S服务管理信息系统的系统管理员界面下的用户管理界面、用户组管理界面、以及模型管理界面;3(a) to 3(c) are respectively a user management interface, a user group management interface, and a model management interface under the system administrator interface of the University City Auto 4S service management information system of the application example;
图4为本应用实例的大学城汽车4S服务管理信息系统的普通用户界面下的系统界面;4 is a system interface of a general user interface of a university city automobile 4S service management information system according to an application example;
图5为实施例1的表驱动的自动化注入数据记录的流程图;5 is a flow chart of table-driven automated injection data recording of Embodiment 1;
图6为实施例1的自动化生成的Web软件系统的超级管理员模块用例图;6 is a diagram showing a use case of a super administrator module of the automatically generated Web software system of Embodiment 1;
图7为实施例1的自动化生成的Web软件系统的系统管理员模块用例图;7 is a diagram showing a use case of a system administrator module of the automatically generated Web software system of Embodiment 1;
图8为实施例1的自动化生成的Web软件系统的用户模块用例图;8 is a diagram showing a use case of a user module of the automatically generated Web software system of Embodiment 1;
图9为实施例1的自动化构造流程的UML类图;9 is a UML class diagram of the automated construction flow of Embodiment 1;
图10为实施例1中利用表驱动的云模式软件系统自动构造方法构造的Web软件系统应用实例活动图;10 is an activity diagram of an application example of a Web software system constructed by using a table-driven cloud mode software system automatic construction method in Embodiment 1;
图11为实施例1中利用表驱动的云模式软件系统自动构造方法构造的Web软件系统应用实例状态图;11 is a state diagram of an application example of a Web software system constructed by using a table-driven cloud mode software system automatic construction method in Embodiment 1;
图12为实施例2的表驱动的云模式软件系统自动构造系统。12 is a table driven cloud mode software system automatic construction system of Embodiment 2.
在上述附图的文字描述中,系统需求表即表示软件系统需求表。In the text description of the above figures, the system requirements table represents the software system requirements table.
具体实施方式Detailed ways
为了使本发明的目的、技术方案以及优点更加清楚明白,以下结合附图及实施例,对本发明进行进一步的详细说明。应当理解,此处所描述的具体实施例仅用于解释本发明,并不限于本发明。The present invention will be further described in detail below with reference to the accompanying drawings and embodiments. It is understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to be limiting.
实施例1Example 1
如图1所示,一种表驱动的云模式软件自动构造方法,包括下述步骤:As shown in FIG. 1, a table-driven cloud mode software automatic construction method includes the following steps:
S1、用户根据Web软件框架提供或约定的表单格式,填写软件系统需求信息,生成软件系统信息表;然后将填写完成的软件系统需求表在线或离线提交至Web软件框架中;所述软件系统需求信息包括:系统管理员信息、用户组信息、用户信息、以及模型信息;所述Web软件框架是一个部署在Web服务器上的应用;S1: The user fills in the software system requirement information according to the form format provided or agreed by the Web software framework, and generates a software system information table; and then submits the completed software system requirement table to the Web software framework online or offline; the software system requirements The information includes: system administrator information, user group information, user information, and model information; the web software framework is an application deployed on a web server;
S2、所述Web软件框架通过数据获取服务器接收用户指定的所述软件系统需求表的存储路径,并根据存储路径,获取所述软件系统需求表,然后Web软件框架对获取的软件系统需求表进行遍历,读取软件系统需求表所记载的各类信息,并将读取的各项软件系统需求信息传输至数据分析服务器;S2. The web software framework receives a storage path of the software system requirement table specified by the user through a data obtaining server, and obtains the software system requirement table according to the storage path, and then the web software framework performs the obtained software system requirement table. Traversing, reading various types of information recorded in the software system requirements table, and transmitting the read software system requirement information to the data analysis server;
S3、所述Web软件框架通过数据分析服务器对软件系统需求表中的各项软件系统需求信息进行数据类型及格式校验,判断是否满足软件系统需求表的格式填写要求;若校验不通过,则提示用户格式有误请重新上传软件系统需求表,即重复步骤S1、步骤S2和当前步骤;若校验通过,进行下一步操作;S3. The web software framework performs data type and format verification on each software system requirement information in the software system requirement table through the data analysis server, and determines whether the format requirement of the software system requirement table is met; if the verification fails, If the user is prompted to have a wrong format, please re-upload the software system requirement table, that is, repeat step S1, step S2, and current step; if the verification is passed, proceed to the next step;
S4、Web软件框架自动化构造Web软件系统并在云端部署和发布,以及Web软件系统的更新;S4, the Web software framework automates the construction of the Web software system and deploys and publishes it in the cloud, and updates the Web software system;
S41、设计Web软件框架的底层代码类,所述底层代码类用于实现Web软件框架内部自动化构造Web软件系统;所述底层代码类涉及5个类,4个接口,其中,5个类包括:需求表读取类Read_Demand、用户组管理类Manage_Group、用户管理类Manage_User、模型管理类Manage_Schema、以及数据管理类Manage_Data;4个接口,包括:用户组管理接口GManage_Group、用户管理接口GManage_User、模型管理接口GManage_Schema、以及数据管理接口GManage_Data;通过Read_Demand类获取系统需求表中的各项需求信息,进行相应的生成数据库实体以及生成数据库实体集合操作;Manage_Group类实现了GManage_Group接口,对数据库实体的group集合中的用户组数据进行操作;Manage_User实现了GManage_User接口,对数据库实体的user集合中的用户数据进行操作;Manage_Schema实现了GManage_Schema接口,对数据库实体的schema集合中的模型数据进行操作;Manage_Data实现了GManage_Data接口,对数据库实体的data集合中的数据记录进行操作;Manage_Group、Manage_User、Manage_Schema、Manage_Data四个类都依赖于Read_Demand类;S41. Designing an underlying code class of a Web software framework, wherein the underlying code class is used to implement an internal Web software system for automatically constructing a Web software framework; the underlying code class involves five classes and four interfaces, wherein five classes include: The requirement table reads the class Read_Demand, the user group management class Manage_Group, the user management class Manage_User, the model management class Manage_Schema, and the data management class Manage_Data; four interfaces, including: user group management interface GManage_Group, user management interface GManage_User, model management interface GManage_Schema And the data management interface GManage_Data; obtain the demand information in the system requirement table through the Read_Demand class, perform the corresponding generating database entity and generate the database entity set operation; the Manage_Group class implements the GManage_Group interface, and the user in the group set of the database entity The group data is operated; Manage_User implements the GManage_User interface to operate on the user data in the user collection of the database entity; Manage_Schema implements the GManage_Schema interface, and enters the model data in the schema collection of the database entity. Row operation; Manage_Data implements the GManage_Data interface, and operates on the data records in the data collection of the database entity; the Manage_Group, Manage_User, Manage_Schema, and Manage_Data four classes all depend on the Read_Demand class;
S42、Web软件框架通过底层代码类自动化构造Web软件系统,其外部活动为:Web软件框架根据校验通过的软件系统需求表的管理员信息注册创建一个软件系统,然后再依次判断软件系统需求表中是否存在用户组信息、用户信息、模型信息或模型内结构信息,若存在,则Web软件框架读取软件系统需求表中对应存在的信息,并在创建的软件系统中生成用户组、用户、模型、或模型字段;对于软件系统需求表中存在多个模型情况,Web软件框架重复读取模型信息,直到读取完所有数量的模型,生成最终的Web软件系统;如图2所示,该步骤具体包括下述步骤:S42. The Web software framework automatically constructs a Web software system through the underlying code class. The external activities are as follows: The Web software framework registers a software system according to the administrator information registration of the software system requirement table passed through the verification, and then sequentially determines the software system requirement table. Whether there is user group information, user information, model information or structural information in the model. If it exists, the Web software framework reads the corresponding information in the software system requirements table, and generates user groups, users, and software systems in the created software system. Model, or model field; for multiple model cases in the software system requirements table, the Web software framework repeatedly reads the model information until all the models are read, and the final Web software system is generated; as shown in Figure 2, The steps specifically include the following steps:
S421、Web软件框架读取软件系统需求表中的管理员信息,所述管理员信息包括系统管理员用户名、系统管理员密码、以及创建软件系统名称的信息;根据所读取的管理员信息,创建一个软件系统;S421. The web software framework reads the administrator information in the software system requirement table, where the administrator information includes a system administrator user name, a system administrator password, and information for creating a software system name; according to the read administrator information. , creating a software system;
S422、Web软件框架判断该软件系统需求表是否存在用户组信息,若软件系统需求表中存在用户组信 息,所述用户组信息为用户组ID,则根据所读取的用户组ID在步骤S411创建的软件系统中生成用户组;若软件系统需求表中不存在用户组信息,则进行下一步操作;S422. The web software framework determines whether the user group information exists in the software system requirement table. If the user group information exists in the software system requirement table, and the user group information is a user group ID, according to the read user group ID, step S411 is performed. The user group is generated in the created software system; if the user group information does not exist in the software system requirement table, the next step is performed;
S423、Web软件框架判断该软件系统需求表是否存在用户信息,若软件系统需求表中不存在用户信息,所述用户信息包括用户ID、用户名、用户密码、以及用户所属组,根据所读取的用户信息在在步骤S411创建的软件系统中生成用户;若软件系统需求表中存在用户信息,则进行下一步操作;S423. The web software framework determines whether the user information of the software system requirement table exists. If the user information does not exist in the software system requirement table, the user information includes a user ID, a user name, a user password, and a group to which the user belongs, according to the read User information is generated in the software system created in step S411; if user information exists in the software system requirements table, the next operation is performed;
S424、Web软件框架判断该软件系统需求表是否存在模型信息,若软件系统需求表存在模型信息,则读取软件系统需求表中的模型数量,并赋值当前计数值为0,然后读取模型信息,即模型名称、模型录入员、用户所属组ID、以及用户所属组的组内用户权限信息,并根据所读取的模型信息在在步骤S411创建的软件系统中创建指定模型;然后再判断模型内是否存在结构信息,若模型内存在结构信息,则读取模型内结构信息,即模型内结构字段名称、字段类型、以及字段值是否允许为空,并根据所读取的模型内结构信息在已创建的指定模型内创建字段,同时当前模型数量计数值+1,然后判断当前计数是否小于模型数量,若当前计数小于模型数量,则继续读取下一个模型信息,重复该步骤操作;若当前计数大于模型数量,则Web软件框架完成软件系统的自构造,生成Web软件系统;S424. The Web software framework determines whether the software system requirement table has model information. If the software system requirement table has model information, the number of models in the software system requirement table is read, and the current count value is assigned to 0, and then the model information is read. , that is, the model name, the model entry clerk, the group ID of the user, and the group privilege information of the group to which the user belongs, and create a specified model in the software system created in step S411 according to the read model information; and then judge the model Whether there is structural information in the model, if there is structural information in the model, the structural information in the model is read, that is, whether the structure field name, the field type, and the field value in the model are allowed to be empty, and according to the structural information in the model read Create a field in the specified model, and the current model count value is +1, and then judge whether the current count is less than the model number. If the current count is less than the model number, continue to read the next model information, repeat the step operation; If the count is greater than the number of models, the Web software framework completes the self-construction of the software system. Web software system;
S43、通过软件注入服务器将步骤S42获得的Web软件系统注入Web软件框架,并通过Web软件框架在云端自动部署和发布,供用户访问使用;在本实施例中,所述Web软件框架支持Web软件系统即服务SAAS云模式,就是所述Web软件框架生成的Web软件系统在云端自动部署和发布。S43, the web software system obtained in step S42 is injected into the web software framework through the software injection server, and is automatically deployed and distributed in the cloud through the web software framework for user access; in the embodiment, the web software framework supports the web software. The system-as-a-service SAAS cloud mode is that the Web software system generated by the Web software framework is automatically deployed and distributed in the cloud.
S44、当用户要在所创建的Web软件系统批量注入数据时,用户填写数据记录交换表,所述数据记录交换表包括模型字段信息和数据记录信息,然后提交至Web软件框架,所述Web软件框架对数据记录交换表的信息进行读取,然后对读取后的信息进行格式校验,对于检验通过的数据交换记录表,Web软件框架读取其中的模型字段信息,并根据模型字段信息确定所要进行数据交换的模型,然后将数据记录信息注入该模型中,即完成数据注入操作。S44. When the user wants to batch inject data into the created Web software system, the user fills in a data record exchange table, where the data record exchange table includes model field information and data record information, and then submits to the Web software framework, the Web software. The framework reads the information of the data record exchange table, and then performs format verification on the read information. For the data exchange record table passed by the test, the Web software framework reads the model field information therein, and determines according to the model field information. The model for which data is to be exchanged, and then the data record information is injected into the model, that is, the data injection operation is completed.
表1Table 1
Figure PCTCN2018111941-appb-000001
Figure PCTCN2018111941-appb-000001
Figure PCTCN2018111941-appb-000002
Figure PCTCN2018111941-appb-000002
在本实施例1中,如表1所示,所述软件系统需求表,具体包括如下:In the first embodiment, as shown in Table 1, the software system requirement table specifically includes the following:
1)系统管理员信息部分,包括:a)系统管理员ID;b)系统管理员密码;1) System administrator information, including: a) system administrator ID; b) system administrator password;
c)系统标题;c) system title;
2)用户组信息部分,包括:a)用户组ID;可根据需求填写多个用户组,若无需用户组则不填;其中用户组ID的信息需填入同一行,不同列;2) User group information part, including: a) user group ID; multiple user groups can be filled according to requirements; if no user group is needed, the user group ID is not filled; the user group ID information needs to be filled in the same row and different columns;
3)用户信息部分,包括:a)用户ID;b)用户名;c)用户密码;d)用户所属组;其中的用户所属组,若某用户属于多个组,则用逗号分割;若某用户不属于任何组,则不填;3) The user information part, including: a) user ID; b) user name; c) user password; d) the user belongs to the group; the user belongs to the group, if a user belongs to multiple groups, it is separated by a comma; If the user does not belong to any group, do not fill in;
4)模型信息部分,包括:a)用户所属组的组内用户读写权限,包括三种:可读可写、可读不可写、不可读不可写;b)其他用户读写权限,包括三种:可读可写、可读不可写、不可读不可写;c)模型名称;d)录入员ID;e)所属组ID;f)模型内结构信息,包括:①字段类型,取值包括:Text、Float、Integer、Link、Date、Datetime、Boolean;②字段名;③字段值是否允许为空,取值可为:TRUE、FALSE;其中TRUE表示允许为空,FALSE表示不允许为空。4) Model information part, including: a) User read and write permissions of the group to which the user belongs, including three types: readable and writable, readable and writable, unreadable and unwritable; b) other users' read and write permissions, including three Species: readable and writable, readable and writable, unreadable and unwritable; c) model name; d) entry ID; e) group ID; f) structural information within the model, including: 1 field type, values include : Text, Float, Integer, Link, Date, Datetime, Boolean; 2 field name; 3 field value is allowed to be empty, the value can be: TRUE, FALSE; where TRUE means that the space is allowed, FALSE means that it is not allowed to be empty.
以下为本实施例的表驱动的云模式软件自动构造方法及系统的具体应用实例,详细阐述了自动化生产Web软件系统的过程。The following is a specific application example of the table-driven cloud mode software automatic construction method and system of the present embodiment, and details the process of automatically producing the Web software system.
若利用现有技术的软件构造方法,实现一个具备常规功能的Web软件系统需要经历系统需求分析、系统总体设计、系统详细设计、系统具体实现等常规化流程。以下将基于本实施例提出的一种表驱动的云模式软件系统自动构造方法详细叙述如何跨过传统的开发流程构造出一个大学城汽车4S服务管理信息系统;If the software construction method of the prior art is utilized, implementing a Web software system with conventional functions needs to go through a routine process such as system requirements analysis, overall system design, system detailed design, and system specific implementation. The following describes a table-driven cloud mode software system automatic construction method according to the present embodiment, detailing how to construct a university city automobile 4S service management information system across the traditional development process;
1)按照本实施例提供的软件系统需求表格式填写大学城汽车4S服务管理信息系统的相关需求信息,本实例中软件系统需求表以Excel表为例。大学城汽车4S服务管理信息系统的软件系统需求表填写如表2所示:1) According to the software system requirement table format provided in this embodiment, fill in the relevant demand information of the university city automobile 4S service management information system. In this example, the software system requirement table takes an Excel table as an example. The software system requirements table of the University City Auto 4S Service Management Information System is filled in as shown in Table 2:
表2Table 2
Figure PCTCN2018111941-appb-000003
Figure PCTCN2018111941-appb-000003
如表2可知:As shown in Table 2:
a)本系统的系统管理员ID为“liuyu2018”,密码为“2018”,系统标题为“大学城汽车4S服务管理信息系统1.0newmedia.lab.2018.Spring”。a) The system administrator ID of this system is “liuyu2018”, the password is “2018”, and the system title is “University City Auto 4S Service Management Information System 1.0newmedia.lab.2018.Spring”.
b)本系统存在三个用户组,分别为:group1,group2,group3。b) There are three user groups in the system: group1, group2, and group3.
c)本系统存在三个用户,分别为:panshiying,其用户名为panshiying,用户密码为panshiying,所属组为group1;lirunmin,其用户名为lirunmin,用户密码为lirunmin,所属组为group2;liuyu,其用户名为liuyu,用户密码为liuyu,所属组为group1和group2。c) There are three users in the system, namely: panshiying, the user name is panshiying, the user password is panshiying, the group is group1; lirunmin, the user name is lirunmin, the user password is lirunmin, the group is group2; liuyu, Its user name is liuyu, the user password is liuyu, and the group is group1 and group2.
d)本系统存在三个模型。d) There are three models in this system.
e)第一个模型:模型名称为车辆基本信息,所属组为group1,所属组成员的权限为可读可写,其他用户的权限为可读不可写,录入员为liuyu;模型内有八个字段:字段类型为Integer的车辆类型编号,不允许为空;字段类型为Text的车辆型号,允许为空;字段类型为Text的汽车发动机型号,允许为空;字段类型为Text的车体型号,允许为空;字段类型为Text的车轮型号,允许为空;字段类型为Float的销售价格,允许为空;字段类型为Text的车辆颜色,允许为空;字段类型为Text的车辆类型,允许为空。e) The first model: the model name is the basic information of the vehicle, the group belongs to group1, the permissions of the members of the group are readable and writable, the permissions of other users are readable and unwritable, the entry is liuyu; there are eight in the model. Field: Vehicle type number with field type Integer, not allowed to be empty; vehicle model with field type Text, allowed to be empty; car engine model with field type Text, allowed to be empty; body type with field type Text, Allowed to be empty; wheel type with field type Text, allowed to be empty; field type Float sales price, allowed to be empty; vehicle type with field type Text, allowed to be empty; vehicle type with field type Text, allowed air.
f)第二个模型:模型名称为客户信息,所属组为group1,所属组成员的权限为可读可写,其他用户的权限为可读不可写,录入员为liuyu;模型内有6个字段:字段类型为Integer的客户编号,不允许为空;字段类型为Text的客户名称,不允许为空;字段类型为Text的身份证编号,允许为空;字段类型为Text的服务机构,允许为空;字段类型为Text的收入状况,允许为空;字段类型为Integer的年龄,允许为空。f) The second model: the model name is customer information, the group belongs to group1, the permissions of the members of the group are readable and writable, the permissions of other users are readable and unwritable, the entry is liuyu; there are 6 fields in the model. : The customer number of the field type is Integer, which is not allowed to be empty; the customer name of the field type is Text, which is not allowed to be empty; the ID of the field type is Text, which is allowed to be empty; the service organization whose field type is Text is allowed to be Empty; the field type is the income status of Text, which is allowed to be empty; the field type is Integer's age, which is allowed to be empty.
g)第三个模型:模型名称为维修信息,所属组为group2,所属组成员的权限为可读可写,其他用户的权限为可读不可写,录入员为liuyu;模型内有7个字段:字段类型为Integer的维修编号,允许为空;字段类型为Text的客户名称,允许为空;字段类型为Text的车辆名称,允许为空;字段类型为Text的车辆编号,允许为空;字段类型为Text的故障类型,允许为空;字段类型为Text的维修记录,允许为空;字段类型为Text的维修费用,允许为空。g) The third model: the model name is maintenance information, the group belongs to group2, the permissions of the members of the group are readable and writable, the permissions of other users are readable and unwritable, the entry is liuyu; there are 7 fields in the model. : Service type with field type Integer, allowed to be empty; customer name with field type Text, allowed to be empty; vehicle name with field type Text, allowed to be empty; vehicle number with field type Text, allowed to be empty; field The type of fault of type Text is allowed to be empty; the maintenance record of the field type is Text, which is allowed to be empty; the repair cost of the field type is Text, which is allowed to be empty.
2)将该Excel格式的软件系统需求表命名为与系统管理员ID相同。本应用实例中该Excel文件名为“liuyu2018.xls”。2) Name the software system requirements table in Excel format to be the same as the system administrator ID. In this application example, the Excel file is named "liuyu2018.xls".
3)Web软件框架的超级管理员读取软件系统需求表中的系统管理员ID、系统管理员密码及系统标题,在Web软件框架的后台注册系统管理员账号。3) The super administrator of the Web software framework reads the system administrator ID, system administrator password and system title in the software system requirements table, and registers the system administrator account in the background of the Web software framework.
4)用户使用注册的系统管理员账号登录相应的Web软件框架中,将其定义的Excel格式的软件系统需求表上传至Web软件框架,将软件系统需求信息注入Web软件框架中;点击提交Excel文件后,即生成了满足需求定义的Web软件系统;4) The user logs in to the corresponding Web software framework using the registered system administrator account, uploads the defined software format requirement table in Excel format to the Web software framework, and injects the software system requirement information into the Web software framework; click Submit Excel file After that, a Web software system that satisfies the definition of the requirement is generated;
5)显示成功后刷新面板,可查看到生成的大学城汽车4S服务管理信息系统1.0newmedia.lab.2018.Spring。5) After the display is successful, refresh the panel, and you can view the generated University City Auto 4S Service Management Information System 1.0newmedia.lab.2018.Spring.
在本应用实例的大学城汽车4S服务管理信息系统中,普通用户界面如图4所示,系统管理员界面可以查到如图3(a)所示的用户组管理界面、如图3(b)所示的用户管理界面、和如图3(c)所示的模型管理界面。In the University City Auto 4S Service Management Information System of this application example, the common user interface is shown in Figure 4. The system administrator interface can find the user group management interface as shown in Figure 3 (a), as shown in Figure 3 (b). The user management interface shown, and the model management interface as shown in Figure 3(c).
表3table 3
字段名1 Field name 1 字段名2 Field name 2 字段名3 Field name 3 字段名4Field name 4 字段名5Field name 5 字段名6 Field name 6 ......
           
...... ...... ...... ...... ...... ...... ......
在本应用实例中,如表3所示为数据记录交换表格式,对其描述如下:In this application example, as shown in Table 3, the data record exchange table format is described as follows:
用户通过填写软件系统需求表生成Web软件系统后,可填写数据记录交换表向Web软件系统中批量注入数据。After the user generates the Web software system by filling in the software system requirements table, the data record exchange table can be filled in and the data is injected into the Web software system in batches.
所述数据记录交换表包括以下两部分:The data record exchange table includes the following two parts:
1)字段信息部分:用户根据所要注入数据记录的模型字段填写。1) Field information part: The user fills in the model field according to the data record to be injected.
2)数据记录部分:用户根据需求添加需要注入到模型中的数据记录信息。2) Data recording part: The user adds data record information that needs to be injected into the model according to requirements.
如图5所示,自动化注入数据记录,具体包括下述步骤:As shown in FIG. 5, the automated injection of data records includes the following steps:
1)客户根据需求填写由本发明提供格式的数据记录交换表。1) The customer fills in the data record exchange table provided by the present invention according to the requirements.
2)Web软件框架获取1)中客户上传的数据记录交换表,并校验数据记录交换表格式是否符合要求,若不符合则提示用户格式有误请重新上传,若符合则转入3)。2) The Web software framework obtains 1) the data record exchange table uploaded by the client, and verifies whether the format of the data record exchange table meets the requirements. If it does not match, the user is prompted to format the error, please re-upload, if it is met, transfer to 3).
3)Web软件框架读取数据记录交换表中的模型字段信息。3) The Web software framework reads the model field information in the data record exchange table.
4)Web软件框架根据3)读取的模型字段信息确定所需进行数据交换的模型。4) The Web software framework determines the model for which data exchange is required based on the 3) read model field information.
5)Web软件框架逐行读取数据记录交换表中的数据记录信息,并依次将其注入到步骤4)确定的模型中。5) The Web software framework reads the data record information in the data record exchange table line by line and injects it into the model determined in step 4).
在本应用实例中,如图6所示为自动化生成的Web软件系统的超级管理员模块用例图,超级管理员(该参与者)关联的用例是系统管理,其中系统管理具体包含了新增系统、删除系统和获取系统列表三个用例。In this application example, as shown in FIG. 6, the use case diagram of the super administrator module of the automatically generated Web software system, the use case associated with the super administrator (the participant) is system management, wherein the system management specifically includes the newly added system. Three use cases for deleting the system and getting the system list.
如图7所示为自动化生成的Web软件系统的系统管理员用例图,系统管理员(该参与者)关联的用例有用户管理、用户组管理和模型管理三个用例,具体如下:Figure 7 shows the system administrator use case diagram of the automatically generated Web software system. The use cases associated with the system administrator (the participant) are three examples of user management, user group management, and model management, as follows:
1)所述用户管理,该用例又包含七个用例,即添加用户、删除用户、编辑用户、获取用户列表、获取用户所属组列表、添加用户到用户组、将用户从用户组中删除;其中,1) The user management, the use case further includes seven use cases, namely, adding a user, deleting a user, editing a user, obtaining a user list, obtaining a group list of the user, adding a user to the user group, and deleting the user from the user group; ,
a)所述添加用户括两个用例,在系统内逐个添加用户和根据系统需求表批量添加用户;a) the added user includes two use cases, adding users one by one in the system and adding users in batch according to the system requirement table;
b)所述添加用户到用户组括两个用例,在系统内逐个添加用户到用户组和根据系统需求表批量添加用户到用户组;b) the adding user to the user group includes two use cases, adding the user to the user group one by one in the system and adding the user to the user group in batch according to the system requirement table;
2)所述用户组管理,该用例包含了八个用例,即添加用户组、删除用户组、编辑用户组、获取用户 组列表、获取用户组的用户列表、添加用户到用户组、从用户组中删除用户、获取用户组拥有权限的模型列表;其中,2) The user group management, the use case includes eight use cases, namely, adding a user group, deleting a user group, editing a user group, obtaining a user group list, obtaining a user group user list, adding a user to a user group, and a user group. Delete the user, get a list of models that the user group has permission;
a)所述添加用户组包括两个用例,即在系统内逐个添加用户组和根据系统需求表批量添加用户组两个用例;a) The added user group includes two use cases, namely, adding a user group one by one in the system and adding two user cases in a batch according to the system requirement table;
b)所述添加用户到用户组包括两个用例,即在系统内逐个添加用户到用户组和根据系统需求表批量添加用户到用户组;b) The adding user to the user group includes two use cases, that is, adding the user to the user group one by one in the system and adding the user to the user group in batch according to the system requirement table;
3)所述模型管理,该用例包含了四个用例,即添加模型、删除模型、编辑模型、获取系统模型列表;3) The model management, the use case contains four use cases, namely adding a model, deleting a model, editing a model, and obtaining a list of system models;
a)所述添加模型包括两个用例,即在系统内逐个添加模型和根据系统需求表批量添加模型两个用例;a) The added model includes two use cases, namely, adding models one by one in the system and adding two models in a batch according to the system requirements table;
b)所述编辑模型包括两个用例,即编辑模型信息和编辑模型内字段信息。b) The editing model includes two use cases, namely editing model information and editing field information within the model.
如图8所示为自动化生成的Web软件系统的用户界面用例图,具体描述如下:Figure 8 shows a user interface use case diagram of the automatically generated Web software system, which is described as follows:
1)用户,该参与者关联五个用例,即数据管理、数据统计、导入数据记录、导出数据记录、高级搜索;其中,1) User, the participant is associated with five use cases, namely data management, data statistics, import data records, export data records, advanced search;
a)所述数据管理包括四个用例,即获取模型所有记录、添加数据记录、删除数据记录、修改数据记录;a) The data management includes four use cases, namely, acquiring all records of the model, adding data records, deleting data records, and modifying data records;
b)所述数据统计用例包括四个用例,即最大值统计、最小值统计、平均值统计、记录数统计四个用例;b) The data statistics use case includes four use cases, namely, maximum value statistics, minimum value statistics, average value statistics, and record number statistics;
如图9所示为自动化构造软件系统流程的UML类图,具体描述如下:Figure 9 shows the UML class diagram of the automated construction software system flow, which is described as follows:
自动化构造Web软件系统通过底层代码类实现,所述底层代码类主要涉及5个类,4个接口,其中,5个类包括:需求表读取类Read_Demand、用户组管理类Manage_Group、用户管理类Manage_User、模型管理类Manage_Schema、以及数据管理类Manage_Data;4个接口,包括:用户组管理接口GManage_Group、用户管理接口GManage_User、模型管理接口GManage_Schema、数据管理接口GManage_Data;The automated construction Web software system is implemented by the underlying code class. The low-level code class mainly involves five classes and four interfaces. Among them, five classes include: the requirement table read class Read_Demand, the user group management class Manage_Group, and the user management class Manage_User. , model management class Manage_Schema, and data management class Manage_Data; 4 interfaces, including: user group management interface GManage_Group, user management interface GManage_User, model management interface GManage_Schema, data management interface GManage_Data;
通过所述底层代码类自动化构造Web软件系统,具体包括下述步骤:The web software system is automatically constructed by the underlying code class, and specifically includes the following steps:
(1)、通过需求表读取类Read_Demand中用来处理系统管理员信息的API读取软件系统需求表中的系统管理员板块,遍历其单元格,根据系统管理员ID、系统管理员密码和系统名称在Web软件框架的超级管理员权限下注册软件系统,并在该Web软件框架的底层数据库中创建软件系统相应的数据库实体,同时在该数据库下创建4个Collection,分别为用户组group、用户user、模型schema、数据data;其中所述超级管理员是Web软件框架的最高权限管理员,用于接收用户设定的管理员信息并在Web框架中注册软件系统;所述Web软件框架的底层数据库用于Web软件框架存储数据;(1) Read the system administrator section in the API read request system table in the Read_Demand class to read the system administrator information through the requirements table, traverse its cell, according to the system administrator ID, system administrator password, and The system name registers the software system under the super administrator authority of the Web software framework, and creates the corresponding database entity of the software system in the underlying database of the Web software framework, and creates four Collections under the database, respectively, the user group group, User user, model schema, data data; wherein the super administrator is the highest authority administrator of the web software framework, and is configured to receive administrator information set by the user and register the software system in the web framework; the web software framework The underlying database is used by the Web software framework to store data;
(2)、通过需求表读取类Read_Demand中用来处理用户组信息的API读取软件系统需求表中的用户组信息,遍历其填写的用户组ID信息单元格,根据得到的用户组ID信息生成Json格式的字符串,并将其插入到步骤(1)创建的数据库实体的用户组group集合中;(2) reading the user group information in the API reading software system requirement table of the class Read_Demand for processing the user group information through the demand table, traversing the user group ID information cell filled in, and obtaining the user group ID information according to the obtained user group ID information. Generating a string in Json format and inserting it into the user group group collection of the database entity created in step (1);
(3)、通过需求表读取类Read_Demand中用来处理用户信息的API读取软件系统需求表中的用户信息,遍历其填写的用户信息,按行读取并遍历每行的单元格,根据得到的所有用户信息生成Json格式的字符串,并将其插入到步骤(1)创建的数据库实体的用户user集合中;(3) reading the user information in the API reading software system requirement table of the class Read_Demand for processing the user information through the demand table, traversing the user information filled in, reading and traversing the cells of each row according to the row, according to All the obtained user information generates a string in Json format and inserts it into the user user set of the database entity created in step (1);
(4)、通过需求表读取类Read_Demand中用来处理模型信息的API读取系统需求表的模型信息,遍历其填写的模型信息单元格,根据模型信息生成Json格式的字符串,并将其插入到步骤(1)创建的数据库实体的模型schema集合中;(4) reading the model information of the system requirement table in the API of the class Read_Demand for processing the model information through the requirement table, traversing the model information cell filled in, and generating a string of Json format according to the model information, and Insert into the model schema collection of the database entity created in step (1);
(5)、通过用户组管理类Manage_Group对底层数据库中数据库实体的用户组group集合中的用户组数据进行操作,并将操作结果返回给Web软件框架的系统显示界面,所述用户组管理类Manage_Group实现Web软件框架中定义的用户组管理接口GManage_Group;(5) operating the user group data in the user group group collection of the database entity in the underlying database by the user group management class Manage_Group, and returning the operation result to the system display interface of the Web software framework, the user group management class Manage_Group Implementing the user group management interface GManage_Group defined in the web software framework;
(6)、通过用户管理类Manage_User对底层数据库中数据库实体的用户user集合中的用户数据进行操作,并将操作结果返回给Web软件框架的系统显示界面;(6) operating the user data in the user user set of the database entity in the underlying database through the user management class Manage_User, and returning the operation result to the system display interface of the Web software framework;
(7)、通过模型管理类Manage_Schema对底层数据库中数据库实体的schema集合中的模型数据进行操作,并将结果返回给Web软件框架的界面,所述模型管理类Manage_Schema实现Web软件框架中定义的模型管理接口GManage_Schema;(7), through the model management class Manage_Schema to operate the model data in the schema collection of the database entity in the underlying database, and return the result to the interface of the Web software framework, the model management class Manage_Schema implements the model defined in the Web software framework Management interface GManage_Schema;
(8)、通过数据管理类Manage_Data对底层数据库中数据库实体的data集合中的数据记录进行操作, 并将结果返回给Web软件框架的系统显示界面,所述数据管理类Manage_Data实现了Web软件框架中定义的数据管理接口GManage_Data。(8), through the data management class Manage_Data to operate on the data record in the data set of the database entity in the underlying database, and return the result to the system display interface of the Web software framework, the data management class Manage_Data is implemented in the Web software framework The defined data management interface GManage_Data.
如图10为利用本发明的软件自动构造方法构造的Web软件系统应用实例活动图,具体描述如下:FIG. 10 is an activity diagram of an application example of a Web software system constructed by using the software automatic construction method of the present invention, and the specific description is as follows:
1)用户填写软件系统需求表并上传到Web软件框架;1) The user fills in the software system requirements form and uploads it to the web software framework;
2)Web软件框架获取用户上传的系统需求表,判断用户上传的系统需求表格式是否正确,格式正确则进入读取系统需求表的活动,否则提示用户系统需求表的格式有误,让其重新上传。2) The Web software framework obtains the system requirement table uploaded by the user, determines whether the format of the system requirement table uploaded by the user is correct, and enters the activity of reading the system requirement table when the format is correct, otherwise the format of the user system requirement table is incorrect, so that it is re-created. Upload.
3)Web软件框架读取系统管理员用户名、密码和系统标题等创建系统的信息,并由超级管理员在Web软件框架中注册系统。3) The Web software framework reads the system administrator user name, password, and system title to create system information, and the super administrator registers the system in the Web software framework.
4)进入判断,若存在用户组相关信息,则进入读取用户组相关信息并创建用户组的活动,随后进入判断是否存在用户相关信息的活动,若不存在用户组相关信息则不创建用户组,进入判断是否存在用户相关信息的活动。4) Entering the judgment, if there is related information of the user group, entering the activity of reading the user group related information and creating the user group, and then entering the activity of judging whether the user related information exists, if the user group related information does not exist, the user group is not created. , enter the activity to determine whether there is user-related information.
5)进入判断,若存在用户相关信息,则进入读取用户相关信息并创建用户的活动,随后进入判断是否存在模型相关信息的活动,若不存在用户组相关信息则不创建用户,进入判断是否存在模型相关信息的活动。5) Enter the judgment. If there is user-related information, enter the user-related information and create the user's activity, and then enter the activity of judging whether there is model-related information. If there is no user group related information, the user is not created. An activity that has model related information.
6)进入判断,若存在模型相关信息,则进入读取系统需求表中模型数量并记当前数量为0的活动,随后进入读取模型相关信息并创建模型的活动,再进入判断是否存在模型内字段相关信息的活动,若不存在用户组相关信息则不创建模型,进入生成目标系统的活动。6) Enter the judgment. If there is model related information, enter the number of models in the reading system requirement table and record the current quantity is 0. Then enter the activity of reading the model related information and creating the model, and then enter the judgment to see if there is any model. The activity of the field related information, if there is no user group related information, does not create a model and enters the activity of generating the target system.
7)进入判断,若存在模型内字段相关信息,则进入读取模型内字段相关信息并创建模型内字段活动,随后进入将当前模型计数+1的活动,再进入判断当前模型计数是否小于模型数量的活动,若不存在模型内字段相关信息,则直接进入判断当前模型计数是否小于模型数量的活动。7) Enter judgment. If there is field related information in the model, enter the relevant information of the field in the model and create the field activity in the model, then enter the activity of counting the current model by +1, and then enter to determine whether the current model count is less than the number of models. The activity, if there is no field related information in the model, directly enters the activity to determine whether the current model count is less than the number of models.
8)进入判断,若当前模型计数小于模型数量,则进入读取模型相关信息并创建模型的活动,若当前模型计数不小于模型数量,进入生成目标Web软件系统的活动。8) Enter the judgment. If the current model count is less than the model number, enter the activity of reading the model related information and creating the model. If the current model count is not less than the model number, enter the activity of generating the target Web software system.
如图11为利用本发明的软件自动构造方法构造的Web软件系统应用实例状态图,具体描述如下:FIG. 11 is a state diagram of an application example of a Web software system constructed by using the software automatic construction method of the present invention, and the specific description is as follows:
1)当用户将系统需求表上传至Web软件框架后,进入判断,若格式校验正确则进入系统需求表格式正确状态,否则状态终止,无法创建系统。1) When the user uploads the system requirements table to the Web software framework, it enters the judgment. If the format verification is correct, the system requirements table is entered in the correct format. Otherwise, the state is terminated and the system cannot be created.
2)若进入系统需求表格式正确状态,Web软件框架的超级系统管理员根据需求表中的系统需求信息在Web软件框架中注册系统,进入注册系统成功状态。2) If the system requirements table is entered in the correct state, the super system administrator of the Web software framework registers the system in the Web software framework according to the system requirement information in the requirements table, and enters the registration system success state.
3)进入判断,Web软件框架判断系统需求表中是否存在用户组信息。若存在,则创建用户组,进入用户组创建成功状态;若不存在,则不创建用户组,进入未创建用户组状态。3) Enter the judgment, the Web software framework determines whether there is user group information in the system requirements table. If it exists, the user group is created and the user group creation success status is entered. If it does not exist, the user group is not created and the user group status is not created.
4)进入判断,Web软件框架判断系统需求表中是否存在用户信息。若存在,则创建用户,进入用户创建成功状态;若不存在,则不创建用户,进入未创建用户状态。4) Enter the judgment, the Web software framework determines whether there is user information in the system requirements table. If it exists, the user is created and the user creation success status is entered. If it does not exist, the user is not created and the user status is not created.
5)进入判断,Web软件框架判断系统需求表中是否存在模型信息。若存在,则创建模型,进入模型创建成功状态;若不存在,则不创建模型,进入未创建模型状态。5) Entering the judgment, the Web software framework determines whether the model information exists in the system requirements table. If it exists, the model is created and the model creation success state is entered; if it does not exist, the model is not created and the model state is not created.
6)若5)中进入未创建模型状态,则状态终止,系统创建成功。否则跳入7)6) If the model state is not created in 5), the state is terminated and the system is successfully created. Otherwise jump into 7)
7)进入判断,Web软件框架判断系统需求表中是否存在模型字段等信息。若存在,则创建模型字段等,进入模型字段创建成功状态;若不存在,则不创建模型字段,进入未创建模型字段状态。7) Entering the judgment, the Web software framework determines whether there are model fields and other information in the system requirements table. If it exists, create a model field, etc., and enter the model field to create a successful state; if it does not exist, the model field is not created, and the model field state is not created.
8)状态终止,系统创建成功。8) The status is terminated and the system is created successfully.
实施例2Example 2
如图12所示,一种表驱动的云模式软件自动构造方法的软件自动构造系统,包括客户端、数据获取模块、数据分析模块、软件构造模块、软件注入模块、以及Web服务器;所述客户端用于用户填写软件系统需求表并提交至数据获取模块,所述数据获取模块通过数据获取服务器遍历软件系统需求表,并对软件系统需求表所记载的信息进行分类读取,然后将分类读取后的各项软件系统需求信息传输至数据分析模块;所述数据分析模块通过数据分析服务器对获取的各项软件系统需求信息进行格式分析校验,若格式校验错误,则提醒用户重新填写软件系统需求表,若格式校验正确,则将格式校验正确的各项软件系统需求信息传输至软件构造模块;所述软件构造模块根据格式校验正确的各项软件系统需求信息,并通过软件构 建服务器,自动构造出与该信息匹配的Web软件系统,然后将所述的Web软件系统传输至软件注入模块;所述软件注入模块通过软件注入服务器将Web软件系统注入Web软件框架,并通过Web软件框架将Web软件系统部署在Web服务器上,供用户访问使用;所述Web软件框架是一个用于自动构造软件,并部署在Web服务器上的应用,带有系统显示界面。As shown in FIG. 12, a software automatic construction system of a table-driven cloud mode software automatic construction method includes a client, a data acquisition module, a data analysis module, a software construction module, a software injection module, and a web server; The end is used for the user to fill in the software system requirement table and submit to the data acquisition module. The data acquisition module traverses the software system requirement table through the data acquisition server, and classifies and reads the information recorded in the software system requirement table, and then reads the classification. The selected software system requirement information is transmitted to the data analysis module; the data analysis module performs format analysis and verification on the acquired software system requirement information through the data analysis server, and prompts the user to refill if the format verification error occurs. The software system requirement table, if the format verification is correct, transmits the software system requirement information with the correct format verification to the software construction module; the software construction module verifies the correct software system requirement information according to the format, and passes Software build server that automatically constructs to match this information The web software system then transmits the web software system to the software injection module; the software injection module injects the web software system into the web software framework through the software injection server, and deploys the web software system on the web server through the web software framework For user access; the Web software framework is an application for automatically constructing software and deployed on a web server with a system display interface.
在本实施例2中,所述客户端、数据获取服务器、数据分析服务器、软件构造服务器、软件注入服务器、以及Web服务器均是采用PC电脑,所述客户端与Web服务器之间采用Http通信方式,通信协议采用TCP协议;其余服务器间均采用Socket通信方式,通信协议采用TCP协议。In the second embodiment, the client, the data acquisition server, the data analysis server, the software construction server, the software injection server, and the web server all adopt a PC computer, and the Http communication mode is adopted between the client and the web server. The communication protocol uses the TCP protocol; the rest of the servers use the Socket communication method, and the communication protocol uses the TCP protocol.
以上所述实施例仅表达了本发明的几种实施方式,其描述较为具体和详细,但并不能因此而理解为对本发明专利范围的限制。应当指出的是,对于本领域的普通技术人员来说,在不脱离本发明构思的前提下,还可以做出若干变形和改进,这些都属于本发明的保护范围。因此,本发明专利的保护范围应以权利要求所述为准。The above-mentioned embodiments are merely illustrative of several embodiments of the present invention, and the description thereof is more specific and detailed, but is not to be construed as limiting the scope of the invention. It should be noted that a number of variations and modifications may be made by those skilled in the art without departing from the spirit and scope of the invention. Therefore, the scope of protection of the invention should be determined by the claims.

Claims (10)

  1. 一种表驱动的云模式软件自动构造方法,其特征在于,包括下述步骤:A table-driven cloud mode software automatic construction method, comprising the following steps:
    S1、用户根据Web软件框架提供或约定的表单格式,填写软件系统需求信息,生成软件系统信息表;然后将填写完成的软件系统需求表在线或离线提交至Web软件框架中;所述软件系统需求信息包括:系统管理员信息、用户组信息、用户信息、以及模型信息;所述Web软件框架是一个部署在Web服务器上的应用;S1: The user fills in the software system requirement information according to the form format provided or agreed by the Web software framework, and generates a software system information table; and then submits the completed software system requirement table to the Web software framework online or offline; the software system requirements The information includes: system administrator information, user group information, user information, and model information; the web software framework is an application deployed on a web server;
    S2、所述Web软件框架通过数据获取服务器接收用户指定的所述软件系统需求表的存储路径,并根据存储路径,获取所述软件系统需求表,然后Web软件框架对获取的软件系统需求表进行遍历,读取软件系统需求表所记载的各类信息,并将读取的各项软件系统需求信息传输至数据分析服务器;S2. The web software framework receives a storage path of the software system requirement table specified by the user through a data obtaining server, and obtains the software system requirement table according to the storage path, and then the web software framework performs the obtained software system requirement table. Traversing, reading various types of information recorded in the software system requirements table, and transmitting the read software system requirement information to the data analysis server;
    S3、所述Web软件框架通过数据分析服务器对软件系统需求表中的各项软件系统需求信息进行数据类型及格式校验,判断是否满足软件系统需求表的格式填写要求;若校验不通过,则提示用户格式有误请重新上传软件系统需求表,即重复步骤S1、步骤S2和当前步骤;若校验通过,进行下一步操作;S3. The web software framework performs data type and format verification on each software system requirement information in the software system requirement table through the data analysis server, and determines whether the format requirement of the software system requirement table is met; if the verification fails, If the user is prompted to have a wrong format, please re-upload the software system requirement table, that is, repeat step S1, step S2, and current step; if the verification is passed, proceed to the next step;
    S4、Web软件框架根据校验通过的软件系统需求表的各项信息构造Web软件系统,并注入Web软件框架所处云环境中,然后对所构造的Web软件系统进行使用;S4. The Web software framework constructs a Web software system according to various information of the software system requirement table passed by the verification, and injects into the cloud environment where the Web software framework is located, and then uses the constructed Web software system;
    S41、设计Web软件框架的底层代码类,所述底层代码类用于实现Web软件框架内部自动化构造Web软件系统;S41. Designing an underlying code class of a Web software framework, wherein the underlying code class is used to implement an internal Web software system for automatically constructing a Web software framework;
    S42、Web软件框架通过底层代码类自动化构造Web软件系统,其外部活动过程为:Web软件框架根据校验通过的软件系统需求表的管理员信息注册创建一个软件系统,然后再依次判断软件系统需求表中是否存在用户组信息、用户信息、模型信息或模型内结构信息,若存在,则Web软件框架读取软件系统需求表中对应存在的信息,并在创建的软件系统中生成用户组、用户、模型、或模型字段;对于软件系统需求表中存在多个模型情况,Web软件框架重复读取模型信息,直到读取完所有数量的模型,生成最终的Web软件系统;S42. The Web software framework automatically constructs the Web software system through the underlying code class. The external activity process is as follows: The Web software framework registers a software system according to the administrator information registration of the software system requirement table passed through the verification, and then sequentially determines the software system requirements. Whether the user group information, user information, model information, or structure information in the model exists in the table. If yes, the Web software framework reads the corresponding information in the software system requirement table, and generates a user group and a user in the created software system. , model, or model field; for multiple model cases in the software system requirements table, the Web software framework repeatedly reads the model information until all the models are read, and the final Web software system is generated;
    S43、通过软件注入服务器将步骤S42获得的Web软件系统注入Web软件框架,并通过Web软件框架在云端自动部署和发布,供用户访问使用;S43. The web software system obtained in step S42 is injected into the web software framework through the software injection server, and is automatically deployed and distributed in the cloud through the web software framework for the user to access and use;
    S44、当用户要在所创建的Web软件系统批量注入数据时,用户填写数据记录交换表,所述数据记录交换表包括模型字段信息和数据记录信息,然后提交至Web软件框架,所述Web软件框架对数据记录交换表的信息进行读取,然后对读取后的信息进行格式校验,对于检验通过的数据交换记录表,Web软件框架读取其中的模型字段信息,并根据模型字段信息确定所要进行数据交换的模型,然后将数据记录信息注入该模型中,即完成数据注入操作。S44. When the user wants to batch inject data into the created Web software system, the user fills in a data record exchange table, where the data record exchange table includes model field information and data record information, and then submits to the Web software framework, the Web software. The framework reads the information of the data record exchange table, and then performs format verification on the read information. For the data exchange record table passed by the test, the Web software framework reads the model field information therein, and determines according to the model field information. The model for which data is to be exchanged, and then the data record information is injected into the model, that is, the data injection operation is completed.
  2. 根据权利要求1所述的表驱动的云模式软件自动构造方法,其特征在于,步骤S1中,所述软件系统需求信息包括:系统管理员信息、用户组信息、用户信息、以及模型信息,具体如下:The table-driven cloud mode software automatic construction method according to claim 1, wherein in step S1, the software system requirement information comprises: system administrator information, user group information, user information, and model information, specifically as follows:
    所述系统管理员信息包括:系统管理员ID、系统管理员密码、以及系统标题;The system administrator information includes: a system administrator ID, a system administrator password, and a system title;
    所述用户组信息为用户组ID,可根据需求自定义多个用户组;The user group information is a user group ID, and multiple user groups can be customized according to requirements;
    所述用户信息包括:用户ID、用户名、用户密码、以及用户所属组ID;The user information includes: a user ID, a user name, a user password, and a group ID to which the user belongs;
    所述模型信息,可根据需求自定义多个模型,所包括的信息具体有:用户所属组的组内用户读写权限、其他用户读写权限、模型名称、模型录入员ID、所属组ID、模型字段类型、模型字段名、字段值是否允许空、缺省值、以及备选值;其中所述用户所属组的组内用户读写权限和他用户读写权限包括:可读可写、可读不可写、以及不可读不可写;所述模型录入员ID为用户信息中用户ID所包含;所述所属组ID为用户组中用户组ID所包含;所述模型字段类型,其取值包括:Text、Float、Integer、Link、Date、Datetime、以及Boolean;所述字段值是否允许空,其取值包括:TRUE、FALSE,其中TRUE表示允许为空,FALSE表示不允许为空;The model information may be customized according to requirements, and the information included includes: user read and write permissions, other user read and write permissions, model name, model entry ID, and group ID of the group to which the user belongs. The model field type, the model field name, the field value is allowed to be null, the default value, and the alternative value; wherein the user read and write permission of the group and the user read and write permissions of the group to which the user belongs include: readable and writable, The model is not writable, and is unreadable and unwritable; the model entry ID is included in the user ID in the user information; the belonging group ID is included in the user group ID in the user group; the model field type, the value of which includes : Text, Float, Integer, Link, Date, Datetime, and Boolean; whether the field value is allowed to be null, and its value includes: TRUE, FALSE, where TRUE means that the space is allowed to be empty, and FALSE means that it is not allowed to be empty;
    所述软件系统需求表的提交方式包括:在线提交和离线提交;所述在线提交:用户根据Web软件框架提供的Web表单格式,在线填写软件系统需求信息并提交到该Web软件框架;所述离线提交:用户根据Web软件框架约定的离线表单格式模版,离线填写软件系统需求信息并以文件上传方式提交到Web软件框架。The submission manner of the software system requirement table includes: online submission and offline submission; the online submission: the user fills in the software system requirement information online and submits to the web software framework according to the web form format provided by the web software framework; Submit: The user fills in the software system requirements information offline according to the offline form format template agreed by the Web software framework and submits it to the Web software framework in file upload mode.
  3. 根据权利要求1所述的表驱动的云模式软件自动构造方法,其特征在于,步骤S1中,所述Web软件框架是一个部署在Web服务器上的应用,带有系统显示界面;所述系统显示界面包括:系统管理员界面和用户界面;The table-driven cloud mode software automatic construction method according to claim 1, wherein in step S1, the web software framework is an application deployed on a web server, with a system display interface; The interface includes: a system administrator interface and a user interface;
    所述系统管理员界面包括用户管理、用户组管理、以及模型管理;所述用户管理用于对所要创建的Web软件系统的用户信息进行管理,管理功能包括增加用户、删除用户、为用户增加用户组信息、以及为用户删除用户组信息;所述用户组管理用于对所要创建的Web软件系统的用户组信息进行管理,管理功能包括增加用户组、删除用户组、为用户组增加用户信息、以及为用户组删除用户信息;所述模型管理用于对所要创建的Web软件系统的模型信息进行管理,管理功能包括增加模型信息、删除模型信息、增加模型字段信息、删除模型字段信息、修改模型字段信息、以及针对模型对不同的用户组分配不同的访问权限;The system administrator interface includes user management, user group management, and model management; the user management is used to manage user information of the Web software system to be created, and the management functions include adding users, deleting users, and adding users to users. Group information, and deleting user group information for the user; the user group management is used to manage user group information of the Web software system to be created, and the management functions include adding a user group, deleting a user group, adding user information to the user group, And deleting user information for the user group; the model management is used to manage model information of the Web software system to be created, and the management function includes adding model information, deleting model information, adding model field information, deleting model field information, and modifying the model. Field information, and assign different access rights to different user groups for the model;
    所述用户界面包括数据管理、数据统计、导入和导出Excel表及其他格式表、以及高级搜索;所述数据管理用于对所要创建的Web软件系统数据表的记录进行管理,管理功能包括增加数据记录、删除数据记录、修改数据记录、以及获取所有数据记录;所述数据统计用于对所要创建的Web软件系统的数据表记录进行统计,统计功能包括可针对数据表整型字段进行记录数统计、最大值统计、最小值统计、以及平均值统计;所述导入和导出Excel表及其他格式表用于将Excel表及其他格式表中的数据导入至所创建的Web软件系统的相应表中,并可将Web软件系统的表中的数据导出至Excel表及其他格式表中;所述高级搜索用于对Excel表及其他格式表的多个字段进行多种逻辑组合搜索,查询出满足搜索条件的记录信息。The user interface includes data management, data statistics, import and export of Excel tables and other format tables, and advanced search; the data management is used to manage records of the Web software system data table to be created, and the management function includes adding data. Recording, deleting data records, modifying data records, and obtaining all data records; the data statistics are used to perform statistics on data table records of the Web software system to be created, and the statistics function includes recording statistics on data table integer fields. , maximum statistics, minimum statistics, and average statistics; the import and export of Excel tables and other format tables for importing data in Excel tables and other format tables into the corresponding table of the created Web software system, The data in the table of the Web software system can be exported to an Excel table and other format tables; the advanced search is used to perform multiple logical combination searches on multiple fields of the Excel table and other format tables, and the query meets the search condition. Record information.
  4. 根据权利要求1所述的表驱动的云模式软件自动构造方法,其特征在于,步骤S2中,Web软件框架自动读取软件系统需求表中的各项系统需求信息,其自动读取单元包括软件系统需求表遍历单元、系统管理员信息读取单元、用户组信息读取单元、用户信息读取单元、以及模型信息读取单元;The table-driven cloud mode software automatic construction method according to claim 1, wherein in step S2, the Web software framework automatically reads various system requirement information in the software system requirement table, and the automatic reading unit includes the software. a system requirement table traversal unit, a system administrator information reading unit, a user group information reading unit, a user information reading unit, and a model information reading unit;
    所述软件系统需求表遍历单元用于对软件系统需求表进行遍历;The software system requirement table traversal unit is configured to traverse the software system requirement table;
    所述系统管理员信息读取单元用于在遍历系统管理员信息时,读取系统管理员ID、系统管理员密码、以及系统标题;The system administrator information reading unit is configured to read a system administrator ID, a system administrator password, and a system title when traversing system administrator information;
    所述用户组信息读取单元用于,用于在遍历用户组信息时,读取用户组ID信息;The user group information reading unit is configured to read user group ID information when traversing user group information;
    所述用户信息读取单元,用于在遍历用户信息时,读取用户ID、用户名、用户密码、以及用户所属组ID,其中所述用户所属组ID为用户组信息中包含的用户组ID;The user information reading unit is configured to read a user ID, a user name, a user password, and a group ID to which the user belongs when traversing the user information, where the group ID of the user belongs to the user group ID included in the user group information. ;
    所述模型信息读取单元,用于在遍历模型信息时,读取用户所属组的组内用户读写权限、其他用户读写权限、模型名称、模型录入员ID、用户所属组ID、字段类型、字段名、字段值是否允许为空、缺省值、以及备选值。The model information reading unit is configured to: when traversing the model information, read the user read/write permission, other user read/write permission, model name, model entry ID, user belonging group ID, and field type of the group to which the user belongs. , field name, field value is allowed to be empty, default value, and alternate value.
  5. 根据权利要求1所述的表驱动的云模式软件自动构造方法,其特征在于,步骤S3中,Web软件框架对软件系统需求表中的各项软件系统需求信息进行数据类型及格式校验,具体是对模型信息中的用户所属组的组内用户读写权限、其他用户读写权限、模型字段类型、以及字段值是否允许空的取值是否满足填写要求;若用户所属组项不为空,则判断该项所填值是否包含于软件系统需求表中的用户组信息。The table-driven cloud mode software automatic construction method according to claim 1, wherein in step S3, the Web software framework performs data type and format verification on each software system requirement information in the software system requirement table, specifically Whether the user's read/write permission, other user read/write permission, model field type, and field value of the group to which the user belongs in the model information satisfy the filling requirement; if the user belongs to the group item is not empty, Then, it is judged whether the value of the item is included in the user group information in the software system requirement table.
  6. 根据权利要求1所述的表驱动的云模式软件自动构造方法,其特征在于,步骤S41中,Web软件框架通过底层代码类自动化构造Web软件系统,所述底层代码类涉及5个类,4个接口,其中,5个类包括:需求表读取类Read_Demand、用户组管理类Manage_Group、用户管理类Manage_User、模型管理类Manage_Schema、以及数据管理类Manage_Data;4个接口,包括:用户组管理接口GManage_Group、用户管理接口GManage_User、模型管理接口GManage_Schema、以及数据管理接口GManage_Data;通过所述底层代码类自动化构造Web软件系统,具体包括下述步骤:The table-driven cloud mode software automatic construction method according to claim 1, wherein in step S41, the Web software framework automatically constructs a Web software system by using an underlying code class, the underlying code class involving five classes, four Interface, wherein the five classes include: a requirement table read class Read_Demand, a user group management class Manage_Group, a user management class Manage_User, a model management class Manage_Schema, and a data management class Manage_Data; four interfaces, including: a user group management interface GManage_Group, The user management interface GManage_User, the model management interface GManage_Schema, and the data management interface GManage_Data; automatically construct the Web software system by using the underlying code class, and specifically includes the following steps:
    (1)、通过需求表读取类Read_Demand中用来处理系统管理员信息的API读取软件系统需求表中的系统管理员板块,遍历其单元格,根据系统管理员ID、系统管理员密码和系统名称在Web软件框架的超级管理员权限下注册软件系统,并在该Web软件框架的底层数据库中创建软件系统相应的数据库实体,同时在该数据库下创建4个Collection,分别为用户组group、用户user、模型schema、数据data;其中所述超级管理员是Web软件框架的最高权限管理员,用于接收用户设定的管理员信息并在Web框架中注册软件系统;所述Web软件框架的底层数据库用于Web软件框架存储数据;(1) Read the system administrator section in the API read request system table in the Read_Demand class to read the system administrator information through the requirements table, traverse its cell, according to the system administrator ID, system administrator password, and The system name registers the software system under the super administrator authority of the Web software framework, and creates the corresponding database entity of the software system in the underlying database of the Web software framework, and creates four Collections under the database, respectively, the user group group, User user, model schema, data data; wherein the super administrator is the highest authority administrator of the web software framework, and is configured to receive administrator information set by the user and register the software system in the web framework; the web software framework The underlying database is used by the Web software framework to store data;
    (2)、通过需求表读取类Read_Demand中用来处理用户组信息的API读取软件系统需求表中的用户组信息,遍历其填写的用户组ID信息单元格,根据得到的用户组ID信息生成Json格式的字符串,并将其插入到步骤(1)创建的数据库实体的用户组group集合中;(2) reading the user group information in the API reading software system requirement table of the class Read_Demand for processing the user group information through the demand table, traversing the user group ID information cell filled in, and obtaining the user group ID information according to the obtained user group ID information. Generating a string in Json format and inserting it into the user group group collection of the database entity created in step (1);
    (3)、通过需求表读取类Read_Demand中用来处理用户信息的API读取软件系统需求表中的用户信息,遍历其填写的用户信息,按行读取并遍历每行的单元格,根据得到的所有用户信息生成Json格式的 字符串,并将其插入到步骤(1)创建的数据库实体的用户user集合中;(3) reading the user information in the API reading software system requirement table of the class Read_Demand for processing the user information through the demand table, traversing the user information filled in, reading and traversing the cells of each row according to the row, according to All the obtained user information generates a string in Json format and inserts it into the user user set of the database entity created in step (1);
    (4)、通过需求表读取类Read_Demand中用来处理模型信息的API读取系统需求表的模型信息,遍历其填写的模型信息单元格,根据模型信息生成Json格式的字符串,并将其插入到步骤(1)创建的数据库实体的模型schema集合中;(4) reading the model information of the system requirement table in the API of the class Read_Demand for processing the model information through the requirement table, traversing the model information cell filled in, and generating a string of Json format according to the model information, and Insert into the model schema collection of the database entity created in step (1);
    (5)、通过用户组管理类Manage_Group对底层数据库中数据库实体的用户组group集合中的用户组数据进行操作,并将操作结果返回给Web软件框架的系统显示界面,所述用户组管理类Manage_Group实现Web软件框架中定义的用户组管理接口GManage_Group;(5) operating the user group data in the user group group collection of the database entity in the underlying database by the user group management class Manage_Group, and returning the operation result to the system display interface of the Web software framework, the user group management class Manage_Group Implementing the user group management interface GManage_Group defined in the web software framework;
    (6)、通过用户管理类Manage_User对底层数据库中数据库实体的用户user集合中的用户数据进行操作,并将操作结果返回给Web软件框架的系统显示界面;(6) operating the user data in the user user set of the database entity in the underlying database through the user management class Manage_User, and returning the operation result to the system display interface of the Web software framework;
    (7)、通过模型管理类Manage_Schema对底层数据库中数据库实体的schema集合中的模型数据进行操作,并将结果返回给Web软件框架的界面,所述模型管理类Manage_Schema实现Web软件框架中定义的模型管理接口GManage_Schema;(7), through the model management class Manage_Schema to operate the model data in the schema collection of the database entity in the underlying database, and return the result to the interface of the Web software framework, the model management class Manage_Schema implements the model defined in the Web software framework Management interface GManage_Schema;
    (8)、通过数据管理类Manage_Data对底层数据库中数据库实体的data集合中的数据记录进行操作,并将结果返回给Web软件框架的系统显示界面,所述数据管理类Manage_Data实现了Web软件框架中定义的数据管理接口GManage_Data。(8), through the data management class Manage_Data to operate on the data record in the data set of the database entity in the underlying database, and return the result to the system display interface of the Web software framework, the data management class Manage_Data is implemented in the Web software framework The defined data management interface GManage_Data.
  7. 根据权利要求1所述的表驱动的云模式软件自动构造方法,其特征在于,在步骤S42中,Web软件框架通过底层代码类自动化构造Web软件系统,其外部活动的具体过程如下:The table-driven cloud mode software automatic construction method according to claim 1, wherein in step S42, the Web software framework automatically constructs the Web software system through the underlying code class, and the specific process of the external activity is as follows:
    S421、Web软件框架读取校验通过的软件系统需求表中的管理员信息,所述管理员信息包括系统管理员用户名、系统管理员密码、以及创建软件系统名称的信息;根据所读取的管理员信息,注册创建一个软件系统;S421: The web software framework reads the administrator information in the software system requirement table that passes the verification, where the administrator information includes a system administrator user name, a system administrator password, and information for creating a software system name; Administrator information, registration to create a software system;
    S422、Web软件框架判断软件系统需求表是否存在用户组信息,若软件系统需求表中存在用户组信息,所述用户组信息为用户组ID,则根据所读取的用户组ID在步骤S411创建的软件系统中生成用户组;若软件系统需求表中不存在用户组信息,则进行下一步操作;S422: The web software framework determines whether the user group information exists in the software system requirement table. If the user group information exists in the software system requirement table, and the user group information is the user group ID, the user group ID is created according to the read user group ID in step S411. a user group is generated in the software system; if the user group information does not exist in the software system requirement table, the next step is performed;
    S423、Web软件框架判断该软件系统需求表是否存在用户信息,若软件系统需求表中不存在用户信息,所述用户信息包括用户ID、用户名、用户密码、以及用户所属组,根据所读取的用户信息在在步骤S411创建的软件系统中生成用户;若软件系统需求表中存在用户信息,则进行下一步操作;S423. The web software framework determines whether the user information of the software system requirement table exists. If the user information does not exist in the software system requirement table, the user information includes a user ID, a user name, a user password, and a group to which the user belongs, according to the read User information is generated in the software system created in step S411; if user information exists in the software system requirements table, the next operation is performed;
    S424、Web软件框架判断该软件系统需求表是否存在模型信息,若软件系统需求表存在模型信息,则读取软件系统需求表中的模型数量,并赋值当前计数值为0,然后读取模型信息,即模型名称、模型录入员、所属组ID、以及用户所属组的组内用户读写权限信息,并根据所读取的模型信息在在步骤S411创建的软件系统中创建指定模型;然后再判断模型内是否存在结构信息,若模型内存在结构信息,则读取模型内结构信息,即模型内结构字段名称、字段类型、字段值是否允许为空、缺省值、以及备选值,并根据所读取的模型内结构信息在已创建的指定模型内创建字段,同时当前模型数量计数值+1,然后判断当前计数是否小于模型数量,若当前计数小于模型数量,则继续读取下一个模型信息,重复该步骤操作;若当前计数大于模型数量,则Web软件框架完成软件系统的自构造,生成Web软件系统。S424. The Web software framework determines whether the software system requirement table has model information. If the software system requirement table has model information, the number of models in the software system requirement table is read, and the current count value is assigned to 0, and then the model information is read. , that is, the model name, the model entry clerk, the belonging group ID, and the user read/write authority information of the group to which the user belongs, and create a specified model in the software system created in step S411 according to the read model information; and then judge Whether there is structural information in the model. If there is structural information in the model, the structure information in the model is read, that is, whether the structure field name, field type, field value in the model is allowed to be empty, default value, and alternative value, and according to The read structure information in the model creates a field in the specified model that has been created, and the current model count value is +1, and then determines whether the current count is less than the model number. If the current count is less than the model number, the next model is continuously read. Information, repeat this step; if the current count is greater than the number of models, the Web software framework completes the software The self-construction of the system generates a web software system.
  8. 根据权利要求1所述的表驱动的云模式软件自动构造方法,其特征在于,步骤S5中,所述用户填写数据记录交换表并提交至Web软件框架,具体如下:The table-driven cloud mode software automatic construction method according to claim 1, wherein in step S5, the user fills in a data record exchange table and submits it to a web software framework, as follows:
    所述数据交换记录表中的信息包括:模型字段信息和数据记录;所述模型字段信息是用户根据需求设置所要进行数据记录交换的模型的所有字段名;所述数据记录是用户根据需求添加需要注入到模型中的所有数据记录信息;The information in the data exchange record table includes: model field information and a data record; the model field information is all field names of a model that the user needs to perform data record exchange according to requirements; and the data record is added by the user according to requirements. All data record information injected into the model;
    所述数据交换记录表的提交方式包括:在线提交和离线提交;所述在线提交:当用户根据Web软件框架构造出的Web软件系统,通过所述Web软件系统提供的数据录入Web页面,在线录入数据交换记录表中的信息并提交到该Web软件系统;所述离线提交:当用户根据Web软件生成框架构造出的Web软件系统,通过所述Web软件系统提供的数据记录交换表模版格式,离线录入模型字段信息和数据记录信息并以文件上传方式提交到该Web软件系统。The submission manner of the data exchange record table includes: online submission and offline submission; the online submission: when the user constructs the web software system according to the web software framework, the data input through the web software system is entered into the web page, and the online entry is performed. The information in the data exchange record table is submitted to the web software system; the offline submission: when the user constructs the web software system according to the web software generation framework, the data record exchange table template format provided by the web software system is offline The model field information and the data record information are entered and submitted to the web software system in a file upload manner.
  9. 运用权利要求1~8任一项所述的表驱动的云模式软件自动构造方法的软件自动构造系统,其特征在于,包括客户端、数据获取模块、数据分析模块、软件构造模块、软件注入模块、以及Web服务器;所 述客户端用于用户填写软件系统需求表并提交至数据获取模块,所述数据获取模块通过数据获取服务器遍历软件系统需求表,并对软件系统需求表所记载的信息进行分类读取,然后将分类读取后的各项软件系统需求信息传输至数据分析模块;所述数据分析模块通过数据分析服务器对获取的各项软件系统需求信息进行格式分析校验,若格式校验错误,则提醒用户重新填写软件系统需求表,若格式校验正确,则将格式校验正确的各项软件系统需求信息传输至软件构造模块;所述软件构造模块根据格式校验正确的各项软件系统需求信息,并通过软件构建服务器,自动构造出与该信息匹配的Web软件系统,然后将所述的Web软件系统传输至软件注入模块;所述软件注入模块通过软件注入服务器将Web软件系统注入Web软件框架,并通过Web软件框架将Web软件系统部署在Web服务器上,供用户访问使用;所述Web软件框架是一个用于自动构造软件,并部署在Web服务器上的应用,带有系统显示界面。A software automatic construction system using the table-driven cloud mode software automatic construction method according to any one of claims 1 to 8, characterized in that it comprises a client, a data acquisition module, a data analysis module, a software construction module, and a software injection module. And the web server; the client is used for the user to fill in the software system requirement table and submit to the data acquisition module, and the data acquisition module traverses the software system requirement table through the data acquisition server, and performs information recorded in the software system requirement table. The classification reads, and then transmits the software system requirement information after the classification reading to the data analysis module; the data analysis module performs format analysis and verification on the acquired software system requirement information through the data analysis server, if the format is If the error is checked, the user is reminded to re-fill the software system requirement table. If the format verification is correct, the software system requirement information with the correct format verification is transmitted to the software construction module; the software construction module corrects each according to the format verification. Software system requirements information, and build the server through software Automatically constructing a web software system matching the information, and then transferring the web software system to a software injection module; the software injection module injects the web software system into the web software framework through a software injection server, and through the web software framework The web software system is deployed on a web server for user access; the web software framework is an application for automatically constructing software and deployed on a web server, with a system display interface.
  10. 根据权利要求9所述的表驱动的云模式软件自动构造系统,其特征在于,所述客户端、数据获取服务器、数据分析服务器、软件构造服务器、软件注入服务器、以及Web服务器均是采用PC电脑,所述客户端与Web服务器之间采用Http通信方式,通信协议采用TCP协议;其余服务器间均采用Socket通信方式,通信协议采用TCP协议。The table-driven cloud mode software automatic construction system according to claim 9, wherein the client, the data acquisition server, the data analysis server, the software construction server, the software injection server, and the web server are all PC computers. Http communication mode is adopted between the client and the web server, and the communication protocol adopts the TCP protocol; the rest of the servers adopt the Socket communication mode, and the communication protocol adopts the TCP protocol.
PCT/CN2018/111941 2018-05-14 2018-10-25 Automatic construction method and system for table driven cloud-model software WO2019218597A1 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201810455972.8A CN108427554B (en) 2018-05-14 2018-05-14 Automatic construction method and system for cloud mode software driven by table
CN201810455972.8 2018-05-14

Publications (1)

Publication Number Publication Date
WO2019218597A1 true WO2019218597A1 (en) 2019-11-21

Family

ID=63162942

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2018/111941 WO2019218597A1 (en) 2018-05-14 2018-10-25 Automatic construction method and system for table driven cloud-model software

Country Status (2)

Country Link
CN (1) CN108427554B (en)
WO (1) WO2019218597A1 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113486418A (en) * 2021-06-04 2021-10-08 中国交通信息科技集团有限公司 BIM (building information modeling) model cloud coding method and system

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108427554B (en) * 2018-05-14 2023-09-08 华南理工大学 Automatic construction method and system for cloud mode software driven by table
CN109858796A (en) * 2019-01-25 2019-06-07 中广核工程有限公司 A kind of information system requirement management system and method
CN111580786B (en) * 2020-05-06 2021-09-21 厦门理工学院 Internet + -based software engineering development system
CN111723396B (en) * 2020-05-20 2023-02-10 华南理工大学 SaaS-based universal cloud data privacy protection platform and method

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080320441A1 (en) * 2007-06-23 2008-12-25 Azadeh Ahadian Extensible rapid application development for disparate data sources
CN101853160A (en) * 2010-05-18 2010-10-06 上海动量软件技术有限公司 Platform system and method for realizing framework configuration based on cloud components in computer software system
US20110185340A1 (en) * 2010-01-27 2011-07-28 Oracle International Corporation Software modeling framework
CN103383645A (en) * 2013-07-29 2013-11-06 北京邮电大学 Code generation method and system
CN104899032A (en) * 2015-06-02 2015-09-09 浪潮集团有限公司 OpenDaylight automation development method based on data analysis
CN105630472A (en) * 2014-11-03 2016-06-01 中国科学院沈阳自动化研究所 Quick client development frame for manufacturing execution system and software development method for frame
CN108427554A (en) * 2018-05-14 2018-08-21 华南理工大学 A kind of the cloud mode software method for automatically constructing and system of table- driven

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101794226B (en) * 2010-03-08 2012-11-07 山东大学 Service software construction method and system adapting to multiple business abstraction levels
US9940222B2 (en) * 2015-11-20 2018-04-10 General Electric Company System and method for safety-critical software automated requirements-based test case generation
CN106445536B (en) * 2016-09-28 2021-06-25 湛江市霞山区新软佳科技有限公司 Automatic business design management system
CN107729008A (en) * 2017-09-28 2018-02-23 武汉创客空间信息管理有限公司 A kind of method based on electrical form rapid build management information system

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080320441A1 (en) * 2007-06-23 2008-12-25 Azadeh Ahadian Extensible rapid application development for disparate data sources
US20110185340A1 (en) * 2010-01-27 2011-07-28 Oracle International Corporation Software modeling framework
CN101853160A (en) * 2010-05-18 2010-10-06 上海动量软件技术有限公司 Platform system and method for realizing framework configuration based on cloud components in computer software system
CN103383645A (en) * 2013-07-29 2013-11-06 北京邮电大学 Code generation method and system
CN105630472A (en) * 2014-11-03 2016-06-01 中国科学院沈阳自动化研究所 Quick client development frame for manufacturing execution system and software development method for frame
CN104899032A (en) * 2015-06-02 2015-09-09 浪潮集团有限公司 OpenDaylight automation development method based on data analysis
CN108427554A (en) * 2018-05-14 2018-08-21 华南理工大学 A kind of the cloud mode software method for automatically constructing and system of table- driven

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113486418A (en) * 2021-06-04 2021-10-08 中国交通信息科技集团有限公司 BIM (building information modeling) model cloud coding method and system
CN113486418B (en) * 2021-06-04 2024-02-09 中国交通信息科技集团有限公司 BIM model cloud coding method and system

Also Published As

Publication number Publication date
CN108427554B (en) 2023-09-08
CN108427554A (en) 2018-08-21

Similar Documents

Publication Publication Date Title
WO2019218597A1 (en) Automatic construction method and system for table driven cloud-model software
US20210216983A1 (en) Data exchange-based platform
US20190251284A1 (en) Efficient data query and utilization through a semantic storage model
US10318551B2 (en) Reporting and summarizing metrics in sparse relationships on an OLTP database
US11360995B2 (en) Accessing listings in a data exchange
Imam et al. Automatic schema suggestion model for NoSQL document-stores databases
CN106104472A (en) Specify logic checking rule and logic checking rule is applied to data
WO2020023759A1 (en) Secure electronic messaging system
CN104572122A (en) Software application data generating device and method
US20140298151A1 (en) Creation and distribution of forms
Priebe et al. Business information modeling: A methodology for data-intensive projects, data science and big data governance
CN112307122B (en) Data lake-based data management system and method
CN104142930A (en) Universal Delta data loading technology
WO2022083436A1 (en) Data processing method and apparatus, and device and readable storage medium
CN106557307A (en) The processing method and processing system of business datum
Langit Foundations of SQL Server 2005 Business Intelligence
Pettit et al. The MySQL Workshop: A practical guide to working with data and managing databases with MySQL
CN114610803A (en) Data processing method and device, electronic equipment and storage medium
CN116150663A (en) Data classification method, device, computer equipment and storage medium
Eagar Data Engineering with AWS: Learn how to design and build cloud-based data transformation pipelines using AWS
Planting Developing a data repository for the Climate Adaptive City Enschede
CN117033460B (en) Automatic data model construction system and method based on bus matrix
CN115657901B (en) Service changing method and device based on unified parameters
CN117493371A (en) Service data processing method, device, computer equipment and storage medium
Kantipudi Business insights of user usage records of data cards

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 18918686

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

32PN Ep: public notification in the ep bulletin as address of the adressee cannot be established

Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205A DATED 25.03.2021)

122 Ep: pct application non-entry in european phase

Ref document number: 18918686

Country of ref document: EP

Kind code of ref document: A1