CN104298763A - Web-based external access method of structured database system - Google Patents
Web-based external access method of structured database system Download PDFInfo
- Publication number
- CN104298763A CN104298763A CN201410570196.8A CN201410570196A CN104298763A CN 104298763 A CN104298763 A CN 104298763A CN 201410570196 A CN201410570196 A CN 201410570196A CN 104298763 A CN104298763 A CN 104298763A
- Authority
- CN
- China
- Prior art keywords
- configuration file
- database system
- web
- parameter
- described configuration
- 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.)
- Pending
Links
Classifications
-
- 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
Abstract
The invention discloses a web-based external access method of a structured database system, applied to the field of computer software and aims to overcome the defects that the applications are poor in integrity and are shared under poor effect in the prior. The method includes: establishing a configuration file in which an entry parameter of an access interface, a program debugging mode judging parameter and an error logging string variable are configured; defining an legal IP (internet protocol) range and a legal user account in the configuration file based on web services; in the configuration file, configuring a multi-condition selection type value meeting the type of the structured database system so that a database conveniently calls the web services. The method is applicable to database applications.
Description
Technical field
The present invention relates to computer software fields, particularly relate to a kind of structured database system external access method based on web.
Background technology
Large data age, network world progressively trends towards information disclosure, resource sharing, and good web application also should be shared.But we often will write as with different language, the various programs run in different platform integrate, and this integrated exploitation strength that will cost a lot of money.Even if on same platform, the various softwares of different software manufacturers produce also usually need to integrate.
summary of the invention
The invention provides a kind of structured database system external access method based on web, can effectively overcome the defect that in prior art, application program integration is poor, impact-share is undesirable.
A first aspect of the present invention provides a kind of structured database system external access method based on web, comprise: set up configuration file, the suction parameter of configuration access interface, program debug mode decision parameter and error logging string variable in described configuration file; In described configuration file, legal IP scope and user account is configured based on web services; In described configuration file, configuration meets the many condition switch Selective type value of Database Systems type, so that data base call web services.
According to first aspect, in the implementation that the first is possible, described in call web services before, also comprise: carry out security information inspection, to determine user validation.
According to the first possible implementation of first aspect, in the implementation that the second is possible, describedly carry out security information inspection, comprise: the character string defining connection data storehouse in described configuration file, the character string in described connection data storehouse and described many condition switch Selective type value one_to_one corresponding, to guarantee Database System Security.
According to first aspect, in the implementation that the third is possible, described program debug mode decision parameter is that sign is write debugging log and carried out switching manipulation, and described error logging string variable is followed the tracks of for indicating misregistration.
According to first aspect, in the 4th kind of possible implementation, described method also comprises: in described configuration file, arrange the number of concurrent allowing interface message processor (IMP) to send request.
According to first aspect, in the 5th kind of possible implementation, the suction parameter of described configuration access interface in described configuration file comprises the combination of multiple suction parameter.
A kind of structured database system external access method based on web provided by the invention, by arranging configuration file, achieve the access to structured database system based on web services, thus achieve better resource reuse, data security, the system expandability and maintainable resource sharing.
accompanying drawing explanation
The schematic flow sheet of a kind of structured database system external access method based on web that Fig. 1 provides for the embodiment of the present invention;
The schematic flow sheet of a kind of structured database system external access method based on web that Fig. 2 provides for further embodiment of this invention.
Embodiment
For making the object of the embodiment of the present invention, technical scheme and advantage clearly, below in conjunction with the accompanying drawing in the embodiment of the present invention, technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is the present invention's part embodiment, instead of whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.
Web service, i.e. WebService are a kind of far call technology across programming language and spanning operation system platform.We are called client the application program calling this WebService, and providing the application program of this WebService to be called service end.WebService is the new platform of the distributed application program setting up interoperable.By WebService, can the application program of integrated different structure easily.Adopt WebService application program can with the method for standard function and data " exposure " out, for other application program, reach service level and reuse.
In order to the resource sharing of implementing structured Database Systems, and integrated with other system, the structured database system we set up by Web service technology realizes network resources locating, saves programmer's development time, makes other application programs obtain the application of mass data.
The present invention is based on Web service technology, by building external interface, structured database system is conducted interviews, " client " (as computing machine, the server etc.) contacted with it are made to complete the process operations such as data query, Data Update amendment, Computer image genration, without the need to programming consuming time again with store data, code and code data are behind reused; Compared with traditional database access method, there is better software reuse, data security, the system expandability and maintainable advantage.
The present invention is described in detail below.The schematic flow sheet of a kind of structured database system external access method based on web that Fig. 1 provides for the embodiment of the present invention.With reference to figure 1, the method mainly comprises:
Step 10, set up configuration file, the suction parameter of configuration access interface, program debug mode decision parameter and error logging string variable in configuration file.
Wherein, configuration file is used to the file of the configuration information of storage application program, such as Web.config, is used for storing the configuration information of ASP.NET Web application program.
Program debug mode decision parameter is that sign is write debugging log and carried out switching manipulation, and error logging string variable is followed the tracks of for indicating misregistration.
Step 20, in configuration file, configure legal IP scope and user account based on web services.
Before calling web services, first need to carry out security information inspection, to determine user validation.By defining legal IP scope and user account in configuration file, to determine user validation.
Step 30, in configuration file configuration meet the many condition switch Selective type value of Database Systems type, so that data base call web services.
Wherein, many condition switch Selective type value refers to definition different parameters ID, the database that different I D value is corresponding different.
In configuration file, define many condition switch Selective type value, meet the type of Database Systems definition, the Web service of the type could be called targetedly.
The present embodiment, by arranging configuration file, achieves the access to structured database system based on web services, thus achieves better resource reuse, data security, the system expandability and maintainable resource sharing.
On such scheme basis, for improving security, carrying out security information inspection and comprising:
In configuration file, define the character string in connection data storehouse, the character string in connection data storehouse and many condition switch Selective type value one_to_one corresponding, to guarantee Database System Security.
This database character string and many condition switch Selective type value one_to_one corresponding, meet the character string that many condition switch Selective type value just can open corresponding connection data storehouse, thus open database corresponding to this character string, ensure that Database Systems access security.
Optionally, method also comprises: in configuration file, arrange the number of concurrent allowing interface message processor (IMP) to send request, and to avoid network blockage, thus ensures data efficient.
Further alternative, in configuration file, the suction parameter of configuration access interface comprises the combination of multiple suction parameter, can realize different business demands, makes to have reusability to database structureization access.
Provide a concrete embodiment below, the present embodiment, design under Microsoft ASP.NET WebMethod framework, by configuration to the suction parameter of the external interface that structured database system conducts interviews and return data collection, thus provide the service interface of mass data for demand system, make " client " (as computing machine, the server etc.) contacted with it complete the process operations such as data query, Data Update amendment, Computer image genration.Needs illustrate, the present embodiment is not limited to Microsoft ASP.NET WebMethod framework and realizes.
The schematic flow sheet of a kind of structured database system external access method based on web that Fig. 2 provides for further embodiment of this invention.As shown in Figure 2, the method mainly comprises the following steps:
Step 201, start to call web services interface.
Step 202, the combination of input different parameters.
Such as, the suction parameter of the access interface configured in configuration file, comprises the combination of multiple suction parameter, can realize different business demands.
Step 203, determine whether debugging mode.
If debugging mode, then open debugging log switch, log, read client ip and input parameter; If not, then misregistration information, and return.
Step 204, carry out legitimate verification according to client ip and input parameter.
Wherein, input parameter can comprise account, password, IP, judge whether that there is the parameters such as search access right, also carry out non-null value checking in addition, the query type (judging whether query type that client inputs meets the one of the many condition switch selective value in configuration file) of client input.If parameter is legal, just meeting reading database address, ensures database security.If parameter is illegal, then return parameters verifies illegal information.
If step 205 user inputs legal query type value, read the character string in the connection data storehouse of this code value definition in configuration file, open database.
User inputs legal query type value and refers to the code value met in the selection of many condition switch, if met, reads the character string in the connection data storehouse of this code value definition in configuration file, thus opens database.
Step 206, according to many condition switch select, performing database inquire about.
In the present embodiment, database can comprise the databases such as Oracle and SQLServer, also can comprise other databases.
Last it is noted that above embodiment is only in order to illustrate technical scheme of the present invention, be not intended to limit; Although with reference to previous embodiment to invention has been detailed description, those of ordinary skill in the art is to be understood that: it still can be modified to the technical scheme described in foregoing embodiments, or carries out equivalent replacement to wherein portion of techniques feature; And these amendments or replacement, do not make the essence of appropriate technical solution depart from the spirit and scope of various embodiments of the present invention technical scheme.
Claims (6)
1., based on a structured database system external access method of web, it is characterized in that, comprising:
Set up configuration file, the suction parameter of configuration access interface, program debug mode decision parameter and error logging string variable in described configuration file;
In described configuration file, legal IP scope and user account is configured based on web services;
In described configuration file, configuration meets the many condition switch Selective type value of Database Systems type, so that data base call web services.
2. method according to claim 1, is characterized in that, described in call web services before, also comprise:
Carry out security information inspection, to determine user validation.
3. method according to claim 2, is characterized in that, described in carry out security information inspection, comprising:
In described configuration file, define the character string in connection data storehouse, the character string in described connection data storehouse and described many condition switch Selective type value one_to_one corresponding, to guarantee Database System Security.
4. method according to claim 1, is characterized in that, described program debug mode decision parameter is that sign is write debugging log and carried out switching manipulation, and described error logging string variable is followed the tracks of for indicating misregistration.
5. method according to claim 1, is characterized in that, described method also comprises: in described configuration file, arrange the number of concurrent allowing interface message processor (IMP) to send request.
6. method according to claim 1, is characterized in that, the suction parameter of described configuration access interface in described configuration file comprises the combination of multiple suction parameter.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410570196.8A CN104298763A (en) | 2014-10-23 | 2014-10-23 | Web-based external access method of structured database system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410570196.8A CN104298763A (en) | 2014-10-23 | 2014-10-23 | Web-based external access method of structured database system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104298763A true CN104298763A (en) | 2015-01-21 |
Family
ID=52318488
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410570196.8A Pending CN104298763A (en) | 2014-10-23 | 2014-10-23 | Web-based external access method of structured database system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104298763A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105490850A (en) * | 2015-12-09 | 2016-04-13 | 北京京东尚科信息技术有限公司 | Method and system for configuring data source |
| CN112286538A (en) * | 2020-10-28 | 2021-01-29 | 电信科学技术第十研究所有限公司 | Greenplus database automatic installation method and device |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040268139A1 (en) * | 2003-06-25 | 2004-12-30 | Microsoft Corporation | Systems and methods for declarative client input security screening |
| CN101196926A (en) * | 2007-12-29 | 2008-06-11 | 中国建设银行股份有限公司 | Database access platform and access method thereof |
-
2014
- 2014-10-23 CN CN201410570196.8A patent/CN104298763A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040268139A1 (en) * | 2003-06-25 | 2004-12-30 | Microsoft Corporation | Systems and methods for declarative client input security screening |
| CN101196926A (en) * | 2007-12-29 | 2008-06-11 | 中国建设银行股份有限公司 | Database access platform and access method thereof |
Non-Patent Citations (1)
| Title |
|---|
| 杨晓明等: "基于ASP.NET的Web网络应用程序开发的安全策略实践", 《计算机教育》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105490850A (en) * | 2015-12-09 | 2016-04-13 | 北京京东尚科信息技术有限公司 | Method and system for configuring data source |
| CN105490850B (en) * | 2015-12-09 | 2018-10-19 | 北京京东尚科信息技术有限公司 | The method and system of disposition data source |
| CN112286538A (en) * | 2020-10-28 | 2021-01-29 | 电信科学技术第十研究所有限公司 | Greenplus database automatic installation method and device |
| CN112286538B (en) * | 2020-10-28 | 2023-02-17 | 电信科学技术第十研究所有限公司 | Greenplus database automatic installation method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108549580B (en) | Method for automatically deploying Kubernets slave nodes and terminal equipment | |
| CN106156186B (en) | Data model management device, server and data processing method | |
| US10185549B2 (en) | Updating live system with static changes | |
| CN111324571B (en) | Container cluster management method, device and system | |
| US10922214B1 (en) | System and method for implementing a test optimization module | |
| US8719949B1 (en) | Parameter based operation | |
| CN113114498B (en) | Architecture system of trusted block chain service platform and construction method thereof | |
| CN110325968A (en) | System upgrade management in distributed computing system | |
| CN105324750A (en) | Development-environment system, development-environment device, and development-environment provision method and program | |
| JP6045134B2 (en) | Parallel workload simulation for application performance testing | |
| US10761903B2 (en) | Management instrumentation and discovery (MID) server support for executing automated flows within a cloud based system | |
| CN110673923A (en) | XWIKI system configuration method, system and computer equipment | |
| WO2021137757A1 (en) | Authority management method and apparatus, and electronic device, and storage medium thereof | |
| CN106095483A (en) | The Automation arranging method of service and device | |
| CN104811922A (en) | Adjacent node registration method and the device and cross-node registration method and system | |
| CN110063042A (en) | A kind of response method and its terminal of database failure | |
| CN111639309B (en) | Data processing method and device, node equipment and storage medium | |
| US10824446B2 (en) | Methods and systems for autocompletion | |
| CN114443171A (en) | Configurable service platform and configurable service implementation method | |
| JP2023550607A (en) | Continuous code integration and development in a secure environment | |
| CN104298763A (en) | Web-based external access method of structured database system | |
| US20210344701A1 (en) | System and method for detection promotion | |
| CN112256989A (en) | Page loading method and device based on offline package, terminal equipment and storage medium | |
| US20120265879A1 (en) | Managing servicability of cloud computing resources | |
| CN116483707A (en) | Test method, test device, test apparatus, test program, and test program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150121 |