CN111177204A - Foundation supporting platform - Google Patents

Abstract

The invention discloses a basic supporting platform, which belongs to the field of software development, wherein a data layer stores data and comprises a basic database and a database to be defined, the basic database comprises a user account information database and a system management database, and the system management database comprises a user role database and a user authority database; the service layer comprises basic services and application services to be defined, and the basic services comprise user account service components and system management service components; the definition layer is used for defining basic standards and specifications of the access system, performing authority configuration and unified authentication management on application services to be defined, and managing and configuring user accounts, user roles and user authorities of basic services. The invention is developed for the second time by the technical personnel on the basis of the basic supporting platform, and only the service access interface is defined, so that the required software system can be primarily completed, the workload of technical research personnel is reduced, the working efficiency is improved, and the cost of the final user can be reduced.

Description

Foundation supporting platform

Technical Field

The invention relates to the technical field of software development, in particular to a basic supporting platform.

Background

With the continuous development of information technology and the gradual improvement of informatization construction of various industries, enterprises, schools and governments gradually move to digital office, such as ERP systems, OA systems, data exchange management systems and the like. Many small enterprises do not have the capability of independently developing intelligent management systems and need to spend a great deal of money on purchasing software. And each software developer develops a software system of a different enterprise, a corresponding software framework needs to be established for the enterprise, and the cost is high. However, all software systems include common functional modules, so a basic support platform is needed, technical personnel can perform secondary development on the basis of the basic support platform, and only a service access interface needs to be defined, so that the required software system can be primarily completed, the workload of technical research and development personnel is reduced, the working efficiency is improved, and the cost of an end user can be reduced.

Disclosure of Invention

The invention provides a basic supporting platform, which is developed for the second time by technicians on the basis of the basic supporting platform, and can primarily complete a required software system only by defining a service access interface, thereby reducing the workload of technical research and development personnel, improving the working efficiency and helping end users to reduce the cost.

The technical scheme of the invention is realized as follows:

a foundation support platform comprises

The data layer is used for data storage and comprises a basic database and a database to be defined, the basic database comprises a user account information database and a system management database, and the system management database comprises a user role database and a user authority database;

the service layer comprises basic services and application services to be defined, the basic services comprise user account service components and system management service components, and the application services to be defined are in one-to-one correlation matching with the defined database;

and the definition layer is used for defining the basic standard and specification of the access system, performing authority configuration and unified authentication management on the application service to be defined, and also used for managing and configuring the user account, the user role and the user authority of the basic service.

As a preferred embodiment of the present invention, the definition layer defines the basic standard and specification of the access system based on a RESTful API manner, and performs permission configuration and unified authentication management on the application service to be defined.

As a preferred embodiment of the present invention, the present invention further comprises

And the interface layer is used for displaying the basic service and the defined application service by a visual interface.

As a preferred embodiment of the present invention, the basic service further includes a newly added service component, a modified service component, a deleted service component and a query service component.

As a preferred embodiment of the present invention, the basic service further includes a database definition service component, where the definition platform collects address information of a database of data, and performs addition, modification, deletion, initialization/de-initialization operations.

As a preferred embodiment of the present invention, the data layer is implemented based on a high availability data server cluster.

As a preferred embodiment of the present invention, the high availability data server cluster includes a master data server for performing data write operations and a slave data server for performing data read operations.

The invention has the beneficial effects that: the technical personnel develop for the second time on the basis of the basic supporting platform, and only the service access interface is defined, so that the required software system can be primarily completed, the workload of the technical research personnel is reduced, the working efficiency is improved, and the final user can be helped to reduce the cost.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.

FIG. 1 is a schematic block diagram of an embodiment of a base support platform of the present invention.

Detailed Description

The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

As shown in FIG. 1, the present invention provides a foundation support platform, comprising

The data layer is used for data storage and comprises a basic database and a database to be defined, the basic database comprises a user account information database and a system management database, and the system management database comprises a user role database and a user authority database;

the service layer comprises basic service and application service to be defined, the basic service comprises a user account service component and a system management service component, and the application service to be defined is associated and matched with the defined database one by one;

and the definition layer is used for defining the basic standard and specification of the access system, performing authority configuration and unified authentication management on the application service to be defined, and also used for managing and configuring the user account, the user role and the user authority of the basic service. Specifically, the definition layer defines the basic standard and specification of the access system based on the RESTful API mode, and performs permission configuration and unified authentication management on the application service to be defined.

The invention also comprises an interface layer which is used for displaying the basic service and the defined application service by a visual interface.

The base services also include newly added service components, modified service components, deleted service components, and queried service components. The basic service also comprises a database definition service component, the definition platform collects the address information of the database of the data and executes the operations of adding, modifying, deleting, initializing/de-initializing.

Examples of user account service components are as follows:

and (4) user management, namely clicking a menu platform management and authorized user registration menu, entering a user list page, clicking a newly added button, and filling account information according to requirements, wherein after a mechanism is selected, a logic node can be dynamically associated and filled without selection. The excel user information can also be imported through an import button, and the excel can be filled in through a template in an import menu and imported.

And (4) role management, namely clicking a menu platform management and authorization to register a role menu, entering a role list page, clicking a newly added button, and filling in role information according to requirements. And clicking a role authority management menu under the management and authorization of the menu platform, and entering a role authority operation list page. And clicking an operation column in the role authority list, entering a role authority setting page, selecting menu items which can be viewed by the role, and storing the menu items. And clicking a user registration menu under menu platform management and authorization, entering a user list page, selecting a user role management label, clicking an operation bar of the newly added user list, and setting a role for the user.

The adding, modifying and deleting operations of the system management service component are as follows:

selecting a menu bar 'system management', clicking a menu item 'menu management' in a left side bar, entering a 'menu management' interface, clicking a '+' button of the menu management interface, popping up a newly-added window, inputting information such as a menu name, an address, an icon, a permission, remarks and the like which need to be newly added as shown in the figure, and selecting whether to display the menu or not when displaying a drop-down box, and sequencing: the menu order is arranged. Clicking to store, and completing the addition of the menu. Selecting a menu to be deleted, clicking a ' -button of a menu management interface, popping up a deletion inquiry window, selecting a menu to be modified, clicking a ' modification ' button of the menu management interface, popping up a modification window, inputting information such as a menu name, an address, an icon, a right, remarks and the like to be modified, modifying whether to display the menu or not in a ' whether to display ' drop-down box, and sequencing: the menu order is arranged. Clicking on the next parent menu may modify the parent menu to which the menu belongs. And clicking to save to finish the modification of the menu.

Clicking a 'system management' -user management 'menu item in the left column, entering a' user menu 'interface, clicking a' system management '-user information management' menu item in the left column, entering a 'user information management' interface, clicking a 'newly added' button on the user management interface, popping up a 'newly added user management' interface, and inputting necessary items such as a name, a mobile phone number, a login name, a password, a confirmation password and the like.

The data layer is implemented based on a cluster of highly available data servers. The high availability data server cluster includes a master data server for performing data write operations and a slave data server for performing data read operations. The high availability data server cluster comprises a master data server and a slave data server, and front-end and back-end data separation can be realized.

The invention may also be defined for a database, for example as follows:

the new service domain is explained as follows:

name of service domain: a name is defined for the exchanged traffic.

And (4) numbering the service domain: an encoding code is defined for the exchanged services.

Service domain scope: and defining the authority of the current service using node.

The new data source is explained as follows:

data source name: a name is defined for the database.

And (4) numbering the service domain: and dividing a business domain to which the database belongs, and defaulting to a public domain.

And (3) node name: and defining a switching node to access the database and collect data.

Resource type: the types of the databases currently support databases such as more than oracle10, more than MySQL5, more than SQLSERVER2005, sybase, db2, dm, kingbase, and gbase.

The library IP address: physical server IP address for deploying a database

Library name: defining library names to be exchanged

Port: defining database access ports

User name: user name defining database access

Password: defining passwords for database access

Schema name: defining database instance names

The description of the newly added database is as follows:

task name: names are defined for database tasks.

And (4) service domain: and dividing a business domain to which the database belongs, and defaulting to a public domain.

A source node: a data collection source server is defined.

And the destination node: and defining a data acquisition destination server.

A source data source: defining access to an acquisition database through an origin server

And a target data source: defining access to an acquisition database through a destination server

And (3) exchange mode: defining the switching mode of tasks, and supporting a trigger, a timestamp, a zone bit and a full trigger: capturing incremental data volume timestamps based on a database table trigger: based on the database table update time field, obtaining incremental data through query; the update time field needs to be changed as the data changes.

A flag bit: the incremental data is obtained by querying a specific field of the database, and the flag bit field needs to be changed along with the change of the data.

The total amount is as follows: all data is obtained for a full query at a time.

Exchange frequency: defining how often the system collects data. Two settings of time interval and CRON expression are provided.

Time interval: the unit is second, and can be defined according to the requirement.

CRON expression: scheduling algorithm

Task description: and defining other description information of the task.

The new file task is explained as follows:

task name: names are defined for database tasks.

And (4) service domain: and dividing a business domain to which the database belongs, and defaulting to a public domain.

A source node: a data collection source server is defined.

And the destination node: and defining a data acquisition destination server.

Exchange frequency: defining how often the system collects data. Providing two settings of time interval and CRON expression;

the time mode is as follows:

time interval: the unit is second, and can be defined according to the requirement.

CRON expression: scheduling algorithm

Task description: and defining other description information of the task.

The new database flow is illustrated as follows:

the process name is as follows: names are defined for the database processes, and table names are generally used for facilitating viewing.

Attribution tasks: the process belongs to the exchange task, and the process loads relevant range information from the task.

Skipping the error data: in the process of running the flow, when a data structure error (such as mismatch of the types of the target end table fields, lack of fields and the like) is encountered, the current data is not processed.

Selecting a trigger: when the attributed task is the trigger mode, the data of the operations of adding, modifying and deleting of the monitoring table needs to be selected.

Number of data packets: and inquiring the number of data pieces in each batch and forming a data packet file.

The process is described as follows: and defining a data acquisition destination server.

Adding a source table: and selecting the table under the source data source needing to be collected.

Adding a target table: and selecting which table to be obtained from a target data source for the collected data.

Clearing the table relationship: and clearing the configuration information of the newly added source table and the target table in the interface canvas.

And the file flow defines a file source directory and a received target directory, and screens contents such as file types and the like.

Description of document flow configuration information

The invention is a basic platform of an information system, defines basic standards and specifications required to be followed by an access system, can realize service docking and management of a business system based on a micro-service architecture, supports the authority configuration and unified authentication management of an API (application program interface), and manages users, authorities and logs of the system. By adopting a micro-service framework and front-end and back-end separation mode, user interaction experience is improved, high-concurrency services can be independently deployed, and system performance optimization deployment is realized.

The invention is developed for the second time by the technical personnel on the basis of the basic supporting platform, and only the service access interface is defined, so that the required software system can be primarily completed, the workload of technical research personnel is reduced, the working efficiency is improved, and the cost of the final user can be reduced.

The present invention is not limited to the above preferred embodiments, and any modifications, equivalent substitutions, improvements, etc. within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims (7)

1. A basic supporting platform which is characterized in that: comprises that

The data layer is used for data storage and comprises a basic database and a database to be defined, the basic database comprises a user account information database and a system management database, and the system management database comprises a user role database and a user authority database;

the service layer comprises basic services and application services to be defined, the basic services comprise user account service components and system management service components, and the application services to be defined are in one-to-one correlation matching with the defined database;

and the definition layer is used for defining the basic standard and specification of the access system, performing authority configuration and unified authentication management on the application service to be defined, and also used for managing and configuring the user account, the user role and the user authority of the basic service.

2. The base support platform of claim 1, wherein: the definition layer defines the basic standard and specification of the access system based on the RESTful API mode, and performs authority configuration and unified authentication management on the application service to be defined.

3. The base support platform of claim 1, wherein: also comprises

And the interface layer is used for displaying the basic service and the defined application service by a visual interface.

4. The base support platform of claim 1, wherein: the basic service further comprises a newly added service component, a modified service component, a deleted service component and an inquired service component.

5. The base support platform of claim 1, wherein: the basic service also comprises a database definition service component, the definition platform collects the address information of the database of the data and executes the operations of adding, modifying, deleting, initializing/de-initializing.

6. The base support platform of claim 1, wherein: the data layer is implemented based on a cluster of highly available data servers.

7. The base support platform of claim 6, wherein: the high availability data server cluster includes a master data server for performing data write operations and a slave data server for performing data read operations.

Images