CN104252463A - Db2 database management method based on web system - Google Patents
Db2 database management method based on web system Download PDFInfo
- Publication number
- CN104252463A CN104252463A CN201310258385.7A CN201310258385A CN104252463A CN 104252463 A CN104252463 A CN 104252463A CN 201310258385 A CN201310258385 A CN 201310258385A CN 104252463 A CN104252463 A CN 104252463A
- Authority
- CN
- China
- Prior art keywords
- user
- data
- template
- web
- subscriber
- 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.)
- Granted
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/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention relates to a db2 database management method based on a web system. The method comprises the following steps of making a template; filling a user table displaying template; filling a data displaying template; filling a data displaying skeleton; filling a user field operation template; analyzing and executing a user command. The db2 database management method based on the web system has the advantage that one set of database management system for managing any db2 database without installation of client ends can be provided, and all operations are performed with secondary explaining and execution by a backend server, so various unsafe operations caused by the user directly using the database can be effectively avoided.
Description
Technical field
The present invention relates to data processing technique, relate to the db2 data base management method based on web system particularly.
Background technology
In Internal Management System, often need to carry out direct additions and deletions to backstage db2 database look into and change operation, seldom relate to concrete service logic.Way general is at present that use standard db2 database client is directly connected to the enterprising line operate of target database by the mode of c/s, or for a set of proprietary web-based management system of specific db2 database development.Wherein, db2 data can make industry, business intelligence and Content Management electronic commercial application program be easier to integrated traditional operation data and image, voice and video.C/s refers to, and (Client/Server or Client/Server): Client and Server is usually on two computing machines of wide apart respectively, the task of Client program is that Server program is submitted in the requirement of user, then the result that Server program returns is shown to user in a specified pattern; The task of Server program is the services request receiving CLIENT PROGRAM proposition, processes accordingly, then result is returned to CLIENT PROGRAM.
The scheme of two kinds of prior aries is as follows particularly:
Prior art one: direct-connected on database by standard client, but existing standard client is all the database management schemes based on c/s framework (client/server framework).The maximum drawback of the program is exactly that applicable surface is narrow, is generally used in LAN (Local Area Network); Client software needs to install and could use, and uses inconvenience for some provisional users, unfriendly; User right controls more difficult, needs to carry out secondary development to client software.
Prior art two: for a set of proprietary web-based management system of specific db2 database development, although can solve all drawbacks of above-mentioned standard client, needs to carry out different developments to different db2 databases.Development and maintenance cost compare is high.
Summary of the invention
In view of the above problems, the present invention aims to provide one does not need rely on any db2 client (namely not needing the installation of client) and only need primary development just can carry out the db2 data base management method based on web system of operation maintenance work to all db2 databases.
Db2 data base management method based on web system of the present invention, it is characterized in that, web client calls db2 database by web server, and the method comprises the steps:
Template formulates step, formulates general database user and represents template, and described general database user represents that template at least comprises data exhibiting template, subscriber's meter represents template, user field operation template;
Subscriber's meter represents template filling step, and the subscriber's meter information obtained from db2 database is filled into described subscriber's meter and represents template by web server, to generate data user's tabular table, and shows described data user's list in web client;
Data exhibiting template filling step, according to data user's list selected from shown described data user's listuser, web server reads metadata table from db2 database, obtain the definition information of selected data user's list, fill described data exhibiting template according to this information, generate data exhibiting skeleton;
Data exhibiting skeleton filling step, the data stuffing that inquires in described data exhibiting skeleton, is generated data exhibiting form, and represents described data exhibiting form in web client by web server;
User field operation template filling step, fills user field operation template according to user operation, is presented to user after filling;
User command is resolved and is performed step, and user submit data record operational order is to web server, and web server is translated described data recording operation order and performs, and web client shows execution result case.
Preferably, described subscriber's meter represents template filling step and comprises following sub-step:
Web server reads metadata table from db2 database, extracts all subscriber's meter information;
Described subscriber's meter information is filled into described subscriber's meter and represents template, generate data user's tabular table;
The described data user's list generated is sent to web client;
Web client shows described data user's list.
Preferably, described data exhibiting template filling step comprises following sub-step:
User, according to the described data user's list shown in described web client, selectes certain data user list;
Web client sends the table name of this selected data user's list to web server;
Web server reads db2 database according to the table name of data user's list of sending and reads metadata table, obtains the definition information of selected subscriber's meter;
Definition information according to the subscriber's meter obtained fills described data exhibiting template, generates data exhibiting skeleton.
Preferably, described data exhibiting skeleton filling step comprises following sub-step:
Described selected subscriber's meter is generated to the query statement of set form;
By the data stuffing that inquires according to this query statement in described data exhibiting skeleton, generate data exhibiting form;
This data exhibiting form is sent to web client, and represents described data exhibiting form in web client.
Preferably, described user field operation template filling step comprises following sub-step:
For the described data exhibiting form represented in described web client, user selects certain record;
Web client obtains this record;
Web, according to the content obtained, fills user field operation template;
User field operation template after filling is presented to user.
Preferably, described user command parsing execution step comprises following sub-step:
User submit data record operational order is to web server;
Web server is translated described data recording operation order, is performed;
Execution result is returned web client;
Web client is shown execution result.
Preferably, formulate in step in described template, utilize form to realize data exhibiting template, utilize list or combobox or tree structure figure to realize subscriber's meter and represent template, utilize transverse direction or longitudinal window to realize user field operation template.
Utilize the db2 data base management method based on web system of the present invention, can provide a set of client that do not need that the data base management system (DBMS) that just can manage any db2 database is installed.And in the present invention, all operations all carry out second interpretation and execution through back-end server, the various dangerous operation that user's direct usage data library tape comes effectively can be avoided thus.
Accompanying drawing explanation
Fig. 1 represents the db2 data base management method FB(flow block) based on web system of the present invention.
Fig. 2 represents an example based on the data exhibiting template in the db2 data base management method of web system of the present invention.
Fig. 3 represents the example representing template based on the several subscriber's meters in the db2 data base management method of web system of the present invention.
Fig. 4 represents an example based on the user field operation template in the db2 data base management method of web system of the present invention.
Fig. 5 is the particular flow sheet representing the db2 data base management method based on web system of the present invention.
?
Embodiment
What introduce below is some in multiple embodiment of the present invention, aims to provide basic understanding of the present invention.Be not intended to confirm key of the present invention or conclusive key element or limit claimed scope.
Although the present invention be build with web system on, but traditional web erection of the erection of web system and application and development technique, it not the discussion emphasis of this patent, so in embodiments by web login system, and web client and the how mutual intelligibility not affecting this system of server are omitted description.
Fig. 1 represents the db2 data base management method FB(flow block) based on web system of the present invention.As shown in Figure 1, the db2 data base management method based on web system of the present invention can be divided into following step haply:
Template formulates step S101: formulate general database user and represent template, and described general database user represents that template at least comprises data exhibiting template, subscriber's meter represents template, user field operation template;
Subscriber's meter represents template filling step S102:web server and the subscriber's meter information obtained from db2 database is filled into described subscriber's meter represents template, to generate data user's tabular table, and shows described data user's list in web client;
Data exhibiting template filling step S103: according to data user's list selected from shown described data user's listuser, web server reads metadata table from db2 database, obtain the definition information of selected data user's list, fill described data exhibiting template according to this information, generate data exhibiting skeleton;
The data stuffing that inquires in described data exhibiting skeleton, is generated data exhibiting form, and represents described data exhibiting form in web client by data exhibiting skeleton filling step S104:web server;
User field operation template filling step S105: according to user operation, user field operation template is filled, be presented to user after filling;
User command is resolved and is performed step S106: user submit data record operational order is to web server, and web server is translated described data recording operation order and performs, and web client shows execution result case.
Wherein, formulate in step S101, formulate general database user and represent template in template, in the present invention, general database user represents that template at least comprises data exhibiting template, subscriber's meter represents template, user field operation template.A reference of each template realizes as described below:
Fig. 2 represents an example based on the data exhibiting template in the db2 data base management method of web system of the present invention.As shown in Figure 2, a reference of data exhibiting template realizes can being a two-dimentional form, and the content of the first row form is title, last column form is empty data line, change one's profession as a click entrance of newly-increased data, centre is data exhibiting region, and its performance can reference diagram 2.
Fig. 3 represents the example representing template based on the data user's table in the db2 data base management method of web system of the present invention.As shown in Figure 3, the reference that subscriber's meter represents template realizes can being that a list or combobox or tree structure figure etc. do not limit, and title can be surface or the table note of this subscriber's meter.
Fig. 4 represents an example based on the user field operation template in the db2 data base management method of web system of the present invention.As shown in Figure 4, a reference of user field operation template realizes can being a horizontal window or longitudinal window, contains all field key elements of selected table in this window.
Fig. 5 is the particular flow sheet representing the db2 data base management method based on web system of the present invention.
Then, with reference to Fig. 5, the db2 data base management method based on web system of the present invention is specifically described.
First, represent in template filling step S102 at subscriber's meter, Web client signs in Web server, Web server reads metadata table from db2 database, extract all subscriber's meter information, padding data storehouse subscriber's meter template, to generate data user's tabular table, and is sent to web client by data user's tabular table of generation.After web client's degree client receives data user's tabular table, web client is shown this list.
Then, in data exhibiting template filling step S103, user after the selected subscriber's meter of web client, web client sends the table name of this selected table to web server, web server reads db2 database metadata table according to the table name of this selected table, obtain the definition information of selected subscriber's meter, and represent template according to these information padding datas, generate data exhibiting skeleton.
Then, in data exhibiting skeleton filling step S104, Web server generates the query statement of a set form to user-selected fixed subscriber's meter, and in the data exhibiting skeleton that the data stuffing inquired is generated to data exhibiting template filling step S103, generate a complete data exhibiting form, then, send this form to web client, web client carries out representing operation.
Then, in user field operation template filling step S105, user double-clicks a certain bar record, and web client obtains this record, and fills operation template according to acquisition content, is presented to user after filling.
Then, resolving in user command performs in step S106, user submit data record operational order is to web server, web server is translated the order that web client sends over and is performed, and execution result is turned back to web client (not representing in Figure 5), web client is shown execution result.
In the invention described above based in the db2 data base management method of web system, by dynamically generating in conjunction with the operation of html generation technique to subscriber's meter the operation of db2 database metadata table, can provide a set of client that do not need that the data base management system (DBMS) that just can manage any db2 database is installed thus.
As mentioned above, in the present invention, owing to adopting B/S framework, just do not need to use installation file.So-called B/S framework refers to, Browser/Server, Browser/Server Mode, it is a kind of network structure pattern after WEB rises, web browser is the topmost application software of client, this pattern has unified client, the core that systemic-function realizes is focused on server, simplify the exploitation of system, safeguard and use, as long as client computer installs a browser (Browser), as long as server installation database, browser carries out data interaction by Web Server with database, the maximum advantage of B/S is exactly to carry out anywhere operating and need not installing any special software, as long as there is a computer that can surf the Net just can use, client zero installation, zero dimension is protected, and the expansion of system is very easy to.
In the present invention, all operations all carry out second interpretation and execution through back-end server, effectively can avoid the various dangerous operation that user's direct usage data library tape comes like this.
And, in the present invention for be db2 database unit table operate, the not structure of concerned with user table, and first table information of all db2 databases is basically identical, so only need exploitation once, just change the anti-dummy address of different databases for different databases, these operations are carried out all on the server, and can not produce any impact to client.
Above example mainly describes the db2 data base management method based on web system of the present invention and the db2 data base management system (DBMS) based on web system is illustrated.Although be only described some of them the specific embodiment of the present invention, those of ordinary skill in the art should understand, and the present invention can implement with other forms many not departing from its purport and scope.Therefore, the example shown and embodiment are regarded as illustrative and not restrictive, when do not depart from as appended each claim define the present invention spirit and scope, the present invention may contain various amendments and replacement.
Claims (7)
1. based on a db2 data base management method for web system, it is characterized in that, web client calls db2 database by web server, and the method comprises the steps:
Template formulates step, formulates general database user and represents template, and described general database user represents that template at least comprises data exhibiting template, subscriber's meter represents template, user field operation template;
Subscriber's meter represents template filling step, and the subscriber's meter information obtained from db2 database is filled into described subscriber's meter and represents template by web server, to generate data user's tabular table, and shows described data user's list in web client;
Data exhibiting template filling step, according to data user's list selected from shown described data user's listuser, web server reads metadata table from db2 database, obtain the definition information of selected data user's list, fill described data exhibiting template according to this information, generate data exhibiting skeleton;
Data exhibiting skeleton filling step, the data stuffing that inquires in described data exhibiting skeleton, is generated data exhibiting form, and represents described data exhibiting form in web client by web server;
User field operation template filling step, fills user field operation template according to user operation, is presented to user after filling;
User command is resolved and is performed step, and user submit data record operational order is to web server, and web server is translated described data recording operation order and performs, and web client shows execution result case.
2., as claimed in claim 1 based on the db2 data base management method of web system, it is characterized in that,
Described subscriber's meter represents template filling step and comprises following sub-step:
Web server reads metadata table from db2 database, extracts all subscriber's meter information;
Described subscriber's meter information is filled into described subscriber's meter and represents template, generate data user's tabular table;
The described data user's list generated is sent to web client;
Web client shows described data user's list.
3., as claimed in claim 2 based on the db2 data base management method of web system, it is characterized in that,
Described data exhibiting template filling step comprises following sub-step:
User, according to the described data user's list shown in described web client, selectes certain data user list;
Web client sends the table name of this selected data user's list to web server;
Web server reads db2 database according to the table name of data user's list of sending and reads metadata table, obtains the definition information of selected subscriber's meter;
Definition information according to the subscriber's meter obtained fills described data exhibiting template, generates data exhibiting skeleton.
4., as claimed in claim 3 based on the db2 data base management method of web system, it is characterized in that,
Described data exhibiting skeleton filling step comprises following sub-step:
Described selected subscriber's meter is generated to the query statement of set form;
By the data stuffing that inquires according to this query statement in described data exhibiting skeleton, generate data exhibiting form;
This data exhibiting form is sent to web client, and represents described data exhibiting form in web client.
5., as claimed in claim 4 based on the db2 data base management method of web system, it is characterized in that,
Described user field operation template filling step comprises following sub-step:
For the described data exhibiting form represented in described web client, user selects certain record;
Web client obtains this record;
Web, according to the content obtained, fills user field operation template;
User field operation template after filling is presented to user.
6., as claimed in claim 5 based on the db2 data base management method of web system, it is characterized in that,
Described user command is resolved execution step and is comprised following sub-step:
User submit data record operational order is to web server;
Web server is translated described data recording operation order, is performed;
Execution result is returned web client;
Web client is shown execution result.
7., as claimed in claim 6 based on the db2 data base management method of web system, it is characterized in that,
Formulate in step in described template, utilize form to realize data exhibiting template, utilize list or combobox or tree structure figure to realize subscriber's meter and represent template, utilize transverse direction or longitudinal window to realize user field operation template.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310258385.7A CN104252463B (en) | 2013-06-26 | 2013-06-26 | A kind of db2 data base management methods based on web system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310258385.7A CN104252463B (en) | 2013-06-26 | 2013-06-26 | A kind of db2 data base management methods based on web system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104252463A true CN104252463A (en) | 2014-12-31 |
| CN104252463B CN104252463B (en) | 2018-09-04 |
Family
ID=52187369
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310258385.7A Active CN104252463B (en) | 2013-06-26 | 2013-06-26 | A kind of db2 data base management methods based on web system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104252463B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105354237A (en) * | 2015-10-09 | 2016-02-24 | 上海瀚之友信息技术服务有限公司 | Business data display method |
| CN108287874A (en) * | 2017-12-19 | 2018-07-17 | 中国科学院声学研究所 | A kind of DB2 database management method and device |
| CN109582647A (en) * | 2018-11-21 | 2019-04-05 | 珠海市新德汇信息技术有限公司 | A kind of analysis method and system towards the unstructured instrument of evidence |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20030024309A (en) * | 2001-09-17 | 2003-03-26 | 정상호 | Slang Remover Program On Web board |
| CN101308490A (en) * | 2008-04-28 | 2008-11-19 | 北京航空航天大学 | Dynamic report generation method and platform |
| CN101650710A (en) * | 2009-08-03 | 2010-02-17 | 金蝶软件（中国）有限公司 | Online software service system as well as method and device for generating report |
-
2013
- 2013-06-26 CN CN201310258385.7A patent/CN104252463B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20030024309A (en) * | 2001-09-17 | 2003-03-26 | 정상호 | Slang Remover Program On Web board |
| CN101308490A (en) * | 2008-04-28 | 2008-11-19 | 北京航空航天大学 | Dynamic report generation method and platform |
| CN101650710A (en) * | 2009-08-03 | 2010-02-17 | 金蝶软件（中国）有限公司 | Online software service system as well as method and device for generating report |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105354237A (en) * | 2015-10-09 | 2016-02-24 | 上海瀚之友信息技术服务有限公司 | Business data display method |
| CN105354237B (en) * | 2015-10-09 | 2020-06-26 | 上海瀚之友信息技术服务有限公司 | Business data display method |
| CN108287874A (en) * | 2017-12-19 | 2018-07-17 | 中国科学院声学研究所 | A kind of DB2 database management method and device |
| CN108287874B (en) * | 2017-12-19 | 2020-07-31 | 中国科学院声学研究所 | DB2 database management method and device |
| CN109582647A (en) * | 2018-11-21 | 2019-04-05 | 珠海市新德汇信息技术有限公司 | A kind of analysis method and system towards the unstructured instrument of evidence |
| CN109582647B (en) * | 2018-11-21 | 2022-09-30 | 珠海市新德汇信息技术有限公司 | Unstructured evidence file oriented analysis method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104252463B (en) | 2018-09-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101256563B (en) | System and method for on-line generation of asian documents with multiple font faces | |
| EP2629210A1 (en) | Method of providing data included in building information modeling data file, computer readable medium therefor, system using the method, and method of providing data using building information modeling server | |
| US11520825B2 (en) | Method and system for converting one type of data schema to another type of data schema | |
| CN101388904B (en) | GIS service aggregating method, device and system | |
| CN104050261A (en) | Stormed-based variable logic general data processing system and method | |
| CN106528741A (en) | Visualization implementation method based on big data | |
| US7698632B2 (en) | System and method for dynamically updating web page displays | |
| CN104715052A (en) | Method and system for generating statement | |
| CN102799690A (en) | Method for verifying page input by using database technology | |
| CN106371874A (en) | Plug-in data loading method and equipment | |
| CN108108460A (en) | A kind of standardized work flows intelligent management system framework and system | |
| US10742764B2 (en) | Web page generation system | |
| CN101488154B (en) | Words input implementing method used for web page | |
| CN104252463A (en) | Db2 database management method based on web system | |
| CN101477644A (en) | Computer apparatus for supporting enterprise work flow operation | |
| CN103593345A (en) | Webpage flow chart editing method and system | |
| CN104834715A (en) | Website generating method and system based on components and container | |
| KR101516213B1 (en) | Responsive Web Generating Method By Converting Document To Responsive Web | |
| CN102096715A (en) | Method and system for acquiring webpage template, and method and system for generating single website | |
| KR20100132752A (en) | Distributed data processing system | |
| US20170031878A1 (en) | Web Page Generation System | |
| CN102193907A (en) | Method and system for comparing manuscripts based on B/S (Browser/Server) structure | |
| CN101957754A (en) | Man-machine interaction method in service-oriented service process | |
| JP5786769B2 (en) | Nayoro Support Program, Nayoro Support Method, and Nayoro Support Device | |
| CN101145959A (en) | A method and system for automatic realization of network management function |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |