CN110928712B - Method for forming standard by connecting RPC service interface through visual database - Google Patents
Method for forming standard by connecting RPC service interface through visual database Download PDFInfo
- Publication number
- CN110928712B CN110928712B CN201911195000.0A CN201911195000A CN110928712B CN 110928712 B CN110928712 B CN 110928712B CN 201911195000 A CN201911195000 A CN 201911195000A CN 110928712 B CN110928712 B CN 110928712B
- Authority
- CN
- China
- Prior art keywords
- service
- configuring
- access system
- interface
- query
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/54—Interprogram communication
- G06F9/547—Remote procedure calls [RPC]; Web services
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/34—Graphical or visual programming
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/54—Interprogram communication
- G06F9/541—Interprogram communication via adapters, e.g. between incompatible applications
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Storage Device Security (AREA)
- Telephonic Communication Services (AREA)
Abstract
The invention discloses a method for forming a standard by connecting RPC service interfaces through a visual database, wherein different protocols are adapted under unified service, so that the problems of protocol conversion and data conversion in the traditional SOA architecture are solved, and the docking difficulty and the development and communication cost of a system are reduced; intervention and implementation scheme of service flow control are realized by means of inquiring conditions, limiting the number of inquired items and paging; data opening of the visual configuration of the DataBase interface greatly improves the development efficiency of the DataBase interface, reduces the modification and maintenance difficulty of the interface, even does not need a developer to process, can ensure the modification work of the interface only by operation and maintenance personnel, reduces the corresponding labor cost, and improves the economic benefit and the value-added benefit; and the function of storing records of the request message and the response message is provided, and the problem of security audit is effectively solved.
Description
Technical Field
The invention relates to the technical field of DateBase database capability opening and protocol standardization, in particular to a method for forming a standard through RPC service interface connection by a visual database.
Background
In a traditional SOA architecture, the problems of protocol conversion and data conversion are often faced, and most of the adopted services are the switching mode between standard RPC service interfaces. Under the condition of different protocols, a one-to-one mode is usually adopted, different protocols cannot be mounted under a unified service, and the mode easily causes that the service addresses are too many, the service types and the service parameter lists are too many, and the service calling is inconvenient.
Under the condition that table or view contents in the DataBase are required to be opened as a service scene, an RPC service interface is generally defined first, and then required contents are inquired from the DataBase through a service code. And then mounting the well-defined RPC service interface to a service bus for service transfer. The realization mode can not guarantee the intervention of the service flow control in a standardized way according to different service realization logics.
If we need to open the data in the database each time, an interface needs to be opened and corresponding service codes are developed. Meanwhile, if the service logic changes, the codes need to be modified, tested and then released to the production environment, a series of work is inefficient, and economic benefits and value-added benefits are greatly influenced.
When a service is called, security audit problems are often encountered, and colloquially, what is found in each operation of the service from a source to a target, and from where data comes if audit is required. If a problem occurs, the problem is simply an incorrect request message or an error in responding to the service.
Disclosure of Invention
Aiming at the defects of the prior art, the invention aims to provide a method for forming a standard by connecting RPC service interfaces through a visual database, which can reduce the docking difficulty of a system and the development and communication cost.
In order to realize the purpose, the scheme provided by the invention is as follows: a method for forming a standard by connecting RPC service interfaces through a visual database is characterized in that: the method comprises the following steps:
s1, registering a service publisher to become a developer and mounting an access system, wherein the access system is in communication connection with a preset service bus;
s2, configuring one or more usable data sources to an access system;
s3, the service publisher configures the published service in the access system, and the configuration comprises the following steps:
a1, setting information of a service to be released, wherein the service parameters comprise a service identifier, a service name, a service version, an affiliated access system, a service type and a service description;
a2, after setting service parameters, selecting an access DataBase protocol, and then configuring a corresponding data source, wherein the corresponding data source is selected from data sources configured by an access system;
a3. Configuring a corresponding database script, including configuring a table or view for selective query, configuring a query field, configuring a query condition, and configuring a paging condition, wherein the table or view for selective query is a table or view in the configured data source;
a4, setting input parameters and output parameters of the service, wherein the input parameters comprise selected query conditions and query page numbers, and the output parameters are queried data sets and queried data numbers;
-a5. Configuring a restricted access and a restricted attachment, wherein restricted access comprises whether unauthorized access is allowed, whether a request message is saved and whether a response message is saved;
s4, after the configuration of the service is completed, the service is issued to a service bus;
and S5, calling the published service through an RPC interface.
Further, the service bus comprises a service engine, and the access system is in communication connection with the service engine through a preset adapter.
Further, the service bus comprises a management platform and a monitoring platform which respectively manage and monitor the service engine.
Further, the data source configured to the access system may be of Oracle, mySql, postgreSql, and Hive4 type.
Further, the query condition configured in step A3 is specifically a query condition that satisfies multiple conditions through a tree structure, and a field, an operator, a parameter type, and a fixed value that need to be determined may be selected.
Compared with the prior art, the method has the advantages that adaptation of different protocols under unified service is realized, the problems of protocol conversion and data conversion in the traditional SOA architecture are solved, and the docking difficulty and the development and communication cost of the system are reduced; intervention and implementation scheme of service flow control are realized by means of inquiring conditions, limiting the number of inquired items and paging; data opening of the visual configuration of the DataBase interface greatly improves the development efficiency of the DataBase interface, reduces the modification and maintenance difficulty of the interface, even does not need a developer to process, can ensure the modification work of the interface only by operation and maintenance personnel, reduces the corresponding labor cost, and improves the economic benefit and the value-added benefit; and the function of storing records of the request message and the response message is provided, and the problem of security audit is effectively solved.
Drawings
FIG. 1 is a flow chart of the present invention.
Fig. 2 is a block diagram of the present invention.
Detailed Description
The invention will be further illustrated with reference to specific examples:
referring to fig. 1 and fig. 2, the present embodiment is a service publishing and subscribing system and a method for forming a standard by connecting RPC service interfaces through a visual database; the service publishing and subscribing system comprises a service bus, a service publishing platform and a service subscribing platform, wherein the service bus is configured with a data source, the service bus comprises a service engine, a monitoring platform for monitoring the service engine and a management platform for managing the service engine, the access system is in communication connection with the service engine through a preset adapter, the service subscribing platform is in communication connection with the service engine through the preset adapter, a service requester applies for calling service to the service engine through the service subscribing platform, and a service publisher publishes the service to the service engine through the service publishing platform.
In this embodiment, the method for forming the standard by connecting the RPC service interface with the visual database includes the following steps:
s1, registering a service publisher to become a developer and mounting an access system, wherein the access system is a service publishing platform and a service subscribing platform, and the service publisher can publish and subscribe services through the access system;
s2, configuring one or more usable data sources to the access system, wherein the data sources configured to the access system can be of Oracle, mySql, postgreSQL and Hive4 types; the process of configuring the data source mainly comprises the following steps: setting parameters of a data source, wherein the parameters comprise a host name, a database name type, a database name, a user name, a password, a data table space, an index table space and a port number, testing the connectivity of the data source after setting is finished, and enabling the data source to be used when the connection is successfully prompted;
s3, the service publisher configures the published service in the access system, and the method comprises the following steps:
a1, setting information of a service to be released, wherein the service parameters comprise a service identifier, a service name, a service version, a belonging access system, a service type and a service description;
a2, after service parameters are set, selecting to access a DataBase protocol, and then configuring a corresponding data source, wherein the corresponding data source is selected from data sources configured by an access system;
a3, configuring a corresponding database script, wherein the database script comprises a table or view for selective query, a query field, a query condition and a paging condition, and the database script is specifically configured with a Groovy script and a sql script, and the Groovy script is used for parameter verification to ensure that the data type and range of parameters in the query condition are correct and the paging parameters are correct; the Sql script is used for an Sql statement used for DataBase query; specifically, a table or view for selecting query is a table or view in a configured data source, a query field is configured to be able to view all fields, types, descriptions and other information in a database table, and to modify the alias of the fields, the query condition is configured to satisfy a multi-condition query condition through a tree structure, and fields, operators, parameter types and fixed values to be determined can be selected; constructing a reasonable query condition through configuration, wherein the paging condition is the number of pieces of each page, namely the maximum number of data pieces returned in a single time when the service is called;
a4, setting input parameters and output parameters of the service, wherein the input parameters comprise selected query conditions and query page numbers, and the output parameters are a queried data set and a queried data number;
a5, configuring a limited access and a limited attachment, wherein the limited access comprises whether unauthorized access is allowed or not, whether a request message is stored or not and whether a response message is stored or not, when the unauthorized access is allowed to be set to be yes, the service can be called without using a certificate, and when the request message is stored or not and the response message is set to be yes, the request message and the response message are stored in a database or a file for safety audit of the service;
s4, after the configuration of the service is completed, the service is issued to a service bus;
and S5, calling the issued service by the service requester through an RPC interface.
In this embodiment, the specific flow of the publish and subscribe service is as follows: the service publisher publishes the service to the service engine so that the service subscriber can find and access the service, the service subscriber applies for the service, the service publisher or the service manager verifies the information of the applied service, and the service subscriber uses the service according to the information provided after the service application after the verification is passed.
In addition, it should be noted that the names of the parts and the like of the embodiments described in the present specification may be different, and the equivalent or simple change of the structure, the characteristics and the principle described in the present patent idea is included in the protection scope of the present patent. Various modifications, additions and substitutions for the specific embodiments described may be made by those skilled in the art without departing from the scope of the invention as defined in the accompanying claims.
Claims (5)
1. A method for forming a standard by connecting RPC service interfaces through a visual database is characterized in that: the method comprises the following steps:
s1, registering a service publisher to become a developer and mounting an access system, wherein the access system is in communication connection with a preset service bus;
s2, configuring one or more usable data sources to an access system;
s3, the service publisher configures the published service in the access system, and the configuration comprises the following steps:
a1, setting information of a service to be released, wherein the service parameters comprise a service identifier, a service name, a service version, an affiliated access system, a service type and a service description;
a2, after service parameters are set, selecting an access DataBase protocol, and then configuring a corresponding data source, wherein the corresponding data source is selected from data sources configured by an access system;
a3. Configuring a corresponding database script, including configuring a table or view for selective query, configuring a query field, configuring a query condition, and configuring a paging condition, wherein the table or view for selective query is a table or view in the configured data source;
setting input parameters and output parameters of the service, wherein the input parameters comprise selected query conditions and query page numbers, and the output parameters are queried data sets and queried data numbers;
a5. Configuring a restricted access and restricted attachment, wherein restricted access includes whether unauthorized access is allowed, whether the request message is saved, and whether the response message is saved;
s4, after the configuration of the service is completed, the service is issued to a service bus;
and S5, calling the published service through an RPC interface.
2. The RPC service interface of claim 1, which forms a standard method by connecting visual databases, wherein: the service bus comprises a service engine, and the access system is in communication connection with the service engine through a preset adapter.
3. The RPC service interface of claim 2, wherein the standard method is formed by connecting visual databases, and comprises: the service bus comprises a management platform and a monitoring platform which respectively manage and monitor the service engine.
4. The method of claim 1, in which the RPC service interface forms a standard by connecting visual databases, and the method includes: the data source configured to the access system can be of Oracle, mySql, postgreSQL and Hive4 type.
5. The RPC service interface of claim 1, which forms a standard method by connecting visual databases, wherein: the step A3 of configuring the query condition is to specifically satisfy the query condition of multiple conditions by using a tree structure, and may select a field, an operator, a parameter type, and a fixed value that need to be determined.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911195000.0A CN110928712B (en) | 2019-11-28 | 2019-11-28 | Method for forming standard by connecting RPC service interface through visual database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911195000.0A CN110928712B (en) | 2019-11-28 | 2019-11-28 | Method for forming standard by connecting RPC service interface through visual database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110928712A CN110928712A (en) | 2020-03-27 |
| CN110928712B true CN110928712B (en) | 2023-03-28 |
Family
ID=69847619
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911195000.0A Active CN110928712B (en) | 2019-11-28 | 2019-11-28 | Method for forming standard by connecting RPC service interface through visual database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110928712B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113489757A (en) * | 2021-05-25 | 2021-10-08 | 石化盈科信息技术有限责任公司 | Data open service method |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107818127A (en) * | 2017-09-09 | 2018-03-20 | 国网浙江省电力公司 | A kind of querying method and system for multi-source data |
| CN109002362A (en) * | 2017-06-06 | 2018-12-14 | 阿里巴巴集团控股有限公司 | A kind of method of servicing, device, system and electronic equipment |
| CN109522139A (en) * | 2018-11-23 | 2019-03-26 | 杭州数梦工场科技有限公司 | A kind of tables of data service creation call method, device, equipment and storage medium |
-
2019
- 2019-11-28 CN CN201911195000.0A patent/CN110928712B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109002362A (en) * | 2017-06-06 | 2018-12-14 | 阿里巴巴集团控股有限公司 | A kind of method of servicing, device, system and electronic equipment |
| CN107818127A (en) * | 2017-09-09 | 2018-03-20 | 国网浙江省电力公司 | A kind of querying method and system for multi-source data |
| CN109522139A (en) * | 2018-11-23 | 2019-03-26 | 杭州数梦工场科技有限公司 | A kind of tables of data service creation call method, device, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110928712A (en) | 2020-03-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10834013B2 (en) | Network slice management | |
| US20170115977A1 (en) | Apparatus and method for automating the installation and configuration of infrastructure | |
| CN102622247B (en) | The BIOS information configuration-system of server and method | |
| CN101009591A (en) | Method and system for configuring network devices through an operations support system interface | |
| CN115309566B (en) | Dynamic management method and system for service interface | |
| WO2012155643A1 (en) | Method for implementing configuration console based on database, configuration console, and system | |
| EP2681942A2 (en) | System and method to provide remote device management for mobile virtualized platforms | |
| CN110928712B (en) | Method for forming standard by connecting RPC service interface through visual database | |
| US20170085673A1 (en) | Attribute Operating Method and Apparatus | |
| US20160182304A1 (en) | Integration method and system | |
| CN109756557B (en) | User authority server and service method and system based on user authority | |
| CN103217956B (en) | Industrial control system as well as control method and control device thereof | |
| CN106354507A (en) | Enterprise-level application management system and method for operating same | |
| US20230384750A1 (en) | Efficient controller data generation and extraction | |
| CN110908955B (en) | Management system of IO device description file | |
| CN100423492C (en) | Management information base processing method | |
| CN115314518A (en) | Internet of things management method and system and computer readable storage medium | |
| CA2486236A1 (en) | Service provisioning method, system and computer program product | |
| CN107145606A (en) | A kind of data managing method and device | |
| CN101222359B (en) | Command configuration method in network element | |
| CN114254165A (en) | System and method for managing authority of user data related to Internet of vehicles service | |
| CN117193956A (en) | Distributed data processing system, method, server, and readable storage medium | |
| CN101902364A (en) | System and method for reporting comprehensive network management data | |
| WO2023050815A1 (en) | Slice service configuration method, network device, network system, and storage medium | |
| US7412512B2 (en) | Indirect addressing method and system for locating a target element in a communication network |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |