CN109408575B - Data access service system - Google Patents
Data access service system Download PDFInfo
- Publication number
- CN109408575B CN109408575B CN201811236401.1A CN201811236401A CN109408575B CN 109408575 B CN109408575 B CN 109408575B CN 201811236401 A CN201811236401 A CN 201811236401A CN 109408575 B CN109408575 B CN 109408575B
- Authority
- CN
- China
- Prior art keywords
- service
- data
- layer
- parameters
- calling
- 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
Abstract
The invention discloses a data access service system, which comprises a calling layer, a service layer and a data layer, wherein the calling layer is the boundary of a user for calling data access service, the data layer is a database management system for providing data to the outside by using the data service access system, the application performance is improved and the sensitive information of the database system is shielded by using a database connection pool technology, the service layer is responsible for analyzing and responding a user request and comprises an analysis unit, an access identity authentication unit, a service rule management unit, a request execution unit and a service positioning five logic module; by arranging the calling layer, the service layer and the data layer, the safety of the database is improved, the requirements for standardized calling and standardized output of results and interfaces are met, and the maintenance and the expansion are easy.
Description
Technical Field
The invention relates to the technical field of internet, in particular to a data access service system.
Background
With the rapid development of the integrated meteorological observation automation service and new detection technology, the existing meteorological equipment integrated guarantee system is gradually improved, but the existing meteorological equipment integrated guarantee system is low in data access efficiency, complex in flow and low in safety performance, so that the problem of solving the same is very important.
Disclosure of Invention
Aiming at the defects of the prior art, the invention provides a data access service system which is provided with a calling layer, a service layer and a data layer so as to improve the safety of a database, meet the requirements of standardized calling and standardized output results and interfaces and is easy to maintain and expand.
In order to solve the above problems, the present invention provides a data access service system, which includes a call layer, a service layer and a data layer, wherein the call layer is a boundary for a user to call a data access service, the data layer is a database management system for providing data to the outside by using the data access service system, the application performance is improved and the sensitive information of the database system is shielded by using a database connection pool technology, and the service layer is responsible for analyzing, processing and responding a user request and includes five logic modules, namely an analysis unit, an access identity authentication, a service rule management unit, a request execution unit and a service location unit.
The further improvement lies in that: the parameters of the analysis unit are divided into system parameters and service parameters, wherein the system parameters are non-null parameters necessary for the complete operation of service logic of the service system, and comprise an interface Id, a user ID, a password, a data format, a service program and a data source name (the parameter identifiers are respectively an interface Id, a user Id, a pwd, a dataFormat, a sql and a datasource); the service parameters are non-null parameters required by normal execution of the service rules corresponding to the system parameters, namely the interface Ids, the users transmit the parameters according to the parameter specification requirements of the calling mode, and the analysis unit is responsible for decomposing to form Map < Key, Value > objects.
The further improvement lies in that: the system roles in the access identity authentication are divided into a system administrator and an external user, the system administrator can acquire data through an interface and simultaneously has the management authority of logging in a console of the system; the external user can only refer to and call the data interface issued by the system. And verifying the provided user information and judging whether the calling is legal or not.
The further improvement lies in that: and the business rule management searches a corresponding business rule program in a business rule base according to the interface Id, and fills a corresponding position in the rule program by using the business parameters to form a complete and executable program.
The further improvement lies in that: the request execution unit acquires database session by using the database connection pool, executes the service program to obtain a correct data set, selects a data format conversion adapter according to the data format parameters, packages the data into a format specified by a user, judges whether a compression strategy is started or not, and returns a result.
The further improvement lies in that: the service positioning rule searches the corresponding database connection pool service name in the service rule base according to the interface Id, and the database management system bound by the service rule can be conveniently positioned by utilizing the naming service and the directory service.
The invention has the beneficial effects that: the data access service system provided by the invention meets the requirements of providing a standardized calling mode, outputting a standardized output result and easily maintaining and expanding an interface by taking the design of improving the database security and shielding the database heterogeneity as a principle.
Drawings
Fig. 1 is a schematic diagram of the operation of the present invention.
Detailed Description
In order to further understand the present invention, the following detailed description will be made with reference to the following examples, which are only used for explaining the present invention and are not to be construed as limiting the scope of the present invention.
As shown in fig. 1, this embodiment provides a data access service system, which includes a call layer, a service layer, and a data layer, where the call layer is a boundary of a user calling a data access service, the data layer is a database management system that provides data to the outside by using the data access service system, the application performance is improved and sensitive information of the database system is shielded by using a database connection pool technology, and the service layer is responsible for analyzing, processing, and responding a user request and includes five logic modules, i.e., an analysis unit, an access identity authentication, a service rule management unit, a request execution unit, and a service location unit. The parameters of the analysis unit are divided into system parameters and service parameters, wherein the system parameters are non-null parameters necessary for the complete operation of service logic of the service system, and comprise an interface Id, a user ID, a password, a data format, a service program and a data source name (the parameter identifiers are respectively an interface Id, a user Id, a pwd, a dataFormat, a sql and a datasource); the service parameters are non-null parameters required by normal execution of the service rules corresponding to the system parameters, namely the interface Ids, the users transmit the parameters according to the parameter specification requirements of the calling mode, and the analysis unit is responsible for decomposing to form Map < Key, Value > objects. The system roles in the access identity authentication are divided into a system administrator and an external user, the system administrator can acquire data through an interface and simultaneously has the management authority of logging in a console of the system; the external user can only refer to and call the data interface issued by the system. And verifying the provided user information and judging whether the calling is legal or not. And the business rule management searches a corresponding business rule program in a business rule base according to the interface Id, and fills a corresponding position in the rule program by using the business parameters to form a complete and executable program. The request execution unit acquires database session by using the database connection pool, executes the service program to obtain a correct data set, selects a data format conversion adapter according to the data format parameters, packages the data into a format specified by a user, judges whether a compression strategy is started or not, and returns a result. The service positioning rule searches the corresponding database connection pool service name in the service rule base according to the interface Id, and the database management system bound by the service rule can be conveniently positioned by utilizing the naming service and the directory service.
The data access service system provided by the invention meets the requirements of providing a standardized calling mode, outputting a standardized output result and easily maintaining and expanding an interface by taking the design of improving the database security and shielding the database heterogeneity as a principle.
The foregoing illustrates and describes the principles, general features, and advantages of the present invention. It will be understood by those skilled in the art that the present invention is not limited to the embodiments described above, which are described in the specification and illustrated only to illustrate the principle of the present invention, but that various changes and modifications may be made therein without departing from the spirit and scope of the present invention, which fall within the scope of the invention as claimed. The scope of the invention is defined by the appended claims and equivalents thereof.
Claims (5)
1. A data access service system, characterized by: the system comprises a calling layer, a service layer and a data layer, wherein the calling layer is the boundary of a user for calling data access service, the data layer is a database management system for providing data to the outside by using a data service access system, the application performance is improved and the sensitive information of the database system is shielded by using a database connection pool technology, the service layer is responsible for analyzing, processing and responding a user request and comprises an analysis unit, an access identity authentication unit, a service rule management unit, a request execution unit and a service positioning five logic module, the parameters of the analysis unit are divided into system parameters and service parameters, and the system parameters are necessary non-empty parameters for the complete operation of service logic of the service system and comprise an interface ID, a user ID, a password, a data format, a service program and a data source name; the service parameters are non-null parameters required by normal execution of the service rules corresponding to the system parameters, namely the interface Ids, the users transmit the parameters according to the parameter specification requirements of the calling mode, and the analysis unit is responsible for decomposing to form Map < Key, Value > objects.
2. A data access service system according to claim 1, wherein: the system roles in the access identity authentication are divided into a system administrator and an external user, the system administrator can acquire data through an interface and simultaneously has the management authority of logging in a console of the system; the external user can only refer to and call the data interface issued by the system; and verifying the provided user information and judging whether the calling is legal or not.
3. A data access service system according to claim 1, wherein: and the business rule management searches a corresponding business rule program in a business rule base according to the interface Id, and fills a corresponding position in the rule program by using the business parameters to form a complete and executable program.
4. A data access service system according to claim 1, wherein: the request execution unit acquires database session by using the database connection pool, executes the service program to obtain a correct data set, selects a data format conversion adapter according to the data format parameters, packages the data into a format specified by a user, judges whether a compression strategy is started or not, and returns a result.
5. A data access service system according to claim 1, wherein: the service positioning rule searches the corresponding database connection pool service name in the service rule base according to the interface Id, and a database management system bound by the service rule can be conveniently positioned by utilizing a naming service and a directory service.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811236401.1A CN109408575B (en) | 2018-10-19 | 2018-10-19 | Data access service system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811236401.1A CN109408575B (en) | 2018-10-19 | 2018-10-19 | Data access service system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109408575A CN109408575A (en) | 2019-03-01 |
| CN109408575B true CN109408575B (en) | 2020-11-10 |
Family
ID=65468768
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811236401.1A Active CN109408575B (en) | 2018-10-19 | 2018-10-19 | Data access service system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109408575B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7472349B1 (en) * | 1999-06-01 | 2008-12-30 | Oracle International Corporation | Dynamic services infrastructure for allowing programmatic access to internet and other resources |
| CN102024008A (en) * | 2009-09-09 | 2011-04-20 | 浙江省电力公司 | Limitation method of Web server concurrent number |
| CN103955795A (en) * | 2014-04-30 | 2014-07-30 | 贵州永恒光科技有限公司 | Project management system |
| CN105320522A (en) * | 2015-09-24 | 2016-02-10 | 四川长虹电器股份有限公司 | Service-oriented architecture based XBRL application platform |
| CN108650254A (en) * | 2018-05-08 | 2018-10-12 | 上海你我贷互联网金融信息服务有限公司 | A kind of encrypting and deciphering system for multi-tenant data |
-
2018
- 2018-10-19 CN CN201811236401.1A patent/CN109408575B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7472349B1 (en) * | 1999-06-01 | 2008-12-30 | Oracle International Corporation | Dynamic services infrastructure for allowing programmatic access to internet and other resources |
| CN102024008A (en) * | 2009-09-09 | 2011-04-20 | 浙江省电力公司 | Limitation method of Web server concurrent number |
| CN103955795A (en) * | 2014-04-30 | 2014-07-30 | 贵州永恒光科技有限公司 | Project management system |
| CN105320522A (en) * | 2015-09-24 | 2016-02-10 | 四川长虹电器股份有限公司 | Service-oriented architecture based XBRL application platform |
| CN108650254A (en) * | 2018-05-08 | 2018-10-12 | 上海你我贷互联网金融信息服务有限公司 | A kind of encrypting and deciphering system for multi-tenant data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109408575A (en) | 2019-03-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Lv | Security of internet of things edge devices | |
| CN102394885B (en) | Information classification protection automatic verification method based on data stream | |
| CN106874461A (en) | A kind of workflow engine supports multi-data source configuration security access system and method | |
| WO2017059717A1 (en) | Identification method and system for user information in social network | |
| CN104753677B (en) | Password hierarchical control method and system | |
| CN109063077B (en) | Data access method and device based on elastic search | |
| CN113468511B (en) | Data processing method and device, computer readable medium and electronic equipment | |
| CN105243107B (en) | CALPUFF Atmospheric models multithread calculating systems | |
| CN111680313B (en) | Data processing method, device, equipment and storage medium | |
| CN112256682B (en) | Data quality detection method and device for multi-dimensional heterogeneous data | |
| US9852226B2 (en) | Search engine results system using entity density | |
| CN115510249A (en) | Knowledge graph construction method and device, electronic equipment and storage medium | |
| CN109408575B (en) | Data access service system | |
| CN113761079A (en) | Data access method, system and storage medium | |
| CN108959952B (en) | Data platform authority control method, device and equipment | |
| CN115828251A (en) | Method and device for evaluating data risk | |
| CN112214769B (en) | Active measurement system of Windows system based on SGX architecture | |
| CN112865987A (en) | Information resource prepositive access system and method based on big data background | |
| CN107818122A (en) | A kind of Agent components, search management method and search management system | |
| CN113127109A (en) | Interface calling method and device, electronic equipment and readable storage medium | |
| CN103902453B (en) | A kind of embedded device safety detection method of Component-Based Development | |
| CN113420046A (en) | Data operation method, device, equipment and storage medium of non-relational database | |
| CN107517177B (en) | Interface authorization method and device | |
| KR100906449B1 (en) | Database tool identifying apparatus and method thereof | |
| WO2022267177A1 (en) | Address desensitization method and apparatus, and electronic device and storage medium |
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 |