CN102033951A - WEB database platform - Google Patents
WEB database platform Download PDFInfo
- Publication number
- CN102033951A CN102033951A CN 201010604557 CN201010604557A CN102033951A CN 102033951 A CN102033951 A CN 102033951A CN 201010604557 CN201010604557 CN 201010604557 CN 201010604557 A CN201010604557 A CN 201010604557A CN 102033951 A CN102033951 A CN 102033951A
- Authority
- CN
- China
- Prior art keywords
- web
- data base
- dds
- database
- unit
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a WEB database platform, comprising a WEB database display unit, a WEB data modification unit and a DDS (data definition sentence) conversion unit connected with the WEB data modification unit, wherein the WEB database display unit is connected with a background database and a foreground WEB display interface; the WEB database modification unit is connected with the foreground WEB display interface; and the DDS conversion unit is connected with the background database. By using the WEB database platform in the invention, the developers can comprehensively know the whole database, the management of the database is easily realized, and the approval processes can be undertaken, therefore, database operation and maintenance are realized in true sense; and the background database connection is separated from the foreground WEB display, so that the application in different databases is realized.
Description
Technical field
The present invention relates to the database management technology field, particularly a kind of WEB database platform.
Background technology
Big multinomial software project of today has all been used database, MYSQL for example, ORACLE, DB2, SQL SERVER or the like, the maintenance work of database is to be finished alone by DBA (data base administrator) always, and project developer has the change request of any database to rely on mail mostly or informs orally DBA or project leader's mode, or the intrinsic flow process of each enterprises is arranged.But such mode is difficult to allow the very fast overall data storehouse to project or company of exploitation personnel that overall understanding is arranged, also do not stop change in the performance history because of the demand of business, the change meeting of database table structure is more frequent, though it is this operation is very simple for DBA or project leader, quite heavy.
Each database company all has the visualized management instrument of a cover at DBA or database development personnel special use, complete function to the product of oneself.But it is an instrument at data base administrator or database professional and technical personnel, can not realize mutual with the developer, can not real overall understanding be arranged to the data structure, operation is also professional relatively, being not easy left-hand seat uses, nor can accept approval process, can not realize database O﹠M truly.
In sum, existing database management tools has following defective:
1, non-DBA such as developer or project leader can not have comprehensive understanding to the overall data storehouse, are not easy to realize the management to database;
2, approval process can not be accepted, database O﹠M truly can not be realized.
Summary of the invention
(1) technical matters that will solve
The technical problem to be solved in the present invention is, at above-mentioned defective, how a kind of WEB database platform is provided, make the developer comprehensive understanding to be arranged to the overall data storehouse, and be easy to realize management to database, and can accept approval process, thereby realize database O﹠M truly; The background data base connection represents with foreground WEB and separates, and can be implemented in the different databases and use.
(2) technical scheme
For solving the problems of the technologies described above, the invention provides a kind of WEB database platform, described WEB database platform comprises: the WEB database represents unit and interconnected WEB database update unit and data definition statement DDS converting unit; Described WEB database represents the unit and is connected with foreground WEB display interface with background data base; Described WEB database update unit is connected with foreground WEB display interface; Described DDS converting unit is connected with background data base; Wherein,
Described WEB database represents the unit, is used for the storehouse list structure from the background data base reading database, and the storehouse list structure of the database that read is sent to foreground WEB display interface shows;
Described WEB database update unit is used for providing the visible database of an easy operating to revise the page by the WEB display interface, and will sends to described DDS converting unit from the database update information that the WEB display interface receives;
Described DDS converting unit becomes the data base manipulation statement that can carry out according to the database update information translation that predefined transformational relation table will be received from described WEB database update unit in background data base, and the data base manipulation statement that is converted to sent in the background data base carries out.
Preferably, described WEB database platform further comprises: the DDS storage unit, be connected with described DDS converting unit, and be used to store the data base manipulation statement that is converted to that is received from described DDS converting unit.
Preferably, described WEB database platform further comprises: DDS historical information unit, be connected with foreground WEB display interface with described DDS storage unit, be used for reading the data base manipulation statement of described DDS cell stores, and the data base manipulation statement of the described DDS cell stores that read is sent to foreground WEB display interface show from described DDS storage unit; And the data base manipulation statement of storing the described DDS storage unit is operated according to the DDS operation information that receives from the WEB display interface.
Preferably, described operation comprises and consults, derives or delete.
Preferably, described WEB database platform further comprises: DDS examines the unit, be connected with background data base with the DDS storage unit, be used for the unenforced data base manipulation statement that reads from described DDS storage unit is examined, examine by, then will examine the data base manipulation statement that passes through and send to background data base and carry out, and in described DDS storage unit, the described data base manipulation statement that passes through of examining be done to examine and passed through mark; Otherwise, do to examine and do not pass through mark examining the data base manipulation statement that does not pass through in the described DDS storage unit.
Preferably, described examining comprises: to the operating right of database permission and examining of action type.
Preferably, described background data base comprises: MYSQL, ORACLE, DB2 or SQLSERVER
Preferably, described database update information comprises action type and corresponding modification data.
Preferably, described action type comprises increase table, delete list, increase field, deletion field or revises field.
Preferably, described modification data comprise table name, field name, field type or the explanation of field that needs are revised.
(3) beneficial effect
The present invention proposes a kind of WEB database platform, by described WEB database platform is connected with foreground WEB display interface with background data base, utilize foreground WEB display interface to show the storehouse list structure of background data base, and the database update information that the user is carried out on the WEB display interface of foreground, convert the data base manipulation statement that in background data base, to carry out to, and the data base manipulation statement that is converted to sent in the background data base carry out, make the developer comprehensive understanding to be arranged to the overall data storehouse, and be easy to realize management to database, and can accept approval process, thereby realize database O﹠M truly; The background data base connection represents with foreground WEB and separates, and can be implemented in the different databases and use.
Description of drawings
The structural representation of the WEB database platform of Fig. 1 embodiment of the invention;
Fig. 2 is the synoptic diagram that the visible database of an easy operating in the embodiment of the invention is revised the page.
Embodiment
Below in conjunction with drawings and Examples, the specific embodiment of the present invention is described in further detail.Following examples are used to illustrate the present invention, but are not used for limiting the scope of the invention.
The structural representation of the WEB database platform of Fig. 1 embodiment of the invention; Referring to Fig. 1, among the present invention, described WEB database platform comprises: the WEB database represents unit and interconnected WEB database update unit and DDS (Data Definition Statements, data definition statement) converting unit; Described WEB database represents the unit and is connected with foreground WEB display interface with background data base; Described WEB database update unit is connected with foreground WEB display interface; Described DDS converting unit is connected with background data base; Wherein,
Described WEB database represents the unit, is used for the storehouse list structure from the background data base reading database, and the storehouse list structure of the database that read is sent to foreground WEB display interface shows; Described background data base comprises MYSQL, ORACLE, DB2 or SQLSERVER or the like.
Described WEB database update unit is used for providing the visible database of an easy operating to revise the page by the WEB display interface, and will sends to described DDS converting unit from the database update information that the WEB display interface receives; The visible database of described easy operating is revised the page and is shown that for revise simple form such as tabulation or drop-down menu with WEB all allow the content that database is made amendment, and any associated authorization personnel can carry out database update at an easy rate.Described database update information comprises action type and corresponding modification data; Described action type comprises increase table, delete list, increase field, deletion field or revises field or the like.Described modification data comprise table name, field name, field type or explanation of field that needs are revised or the like.
Described DDS converting unit becomes the data base manipulation statement that can carry out according to the database update information translation that predefined transformational relation will be received from described WEB database update unit in background data base, and the data base manipulation statement that is converted to sent in the background data base carries out.Described predefined transformational relation is the corresponding relation between described database update information and the data base manipulation statement that can carry out in background data base, determines according to the difference of background data base.
For example, with the background data base is that MYSQL is an example, action type is for increasing the field in the table in the database update information, revise information such as table name that data comprise needs modification, field name, field type, explanation of field, then described DDS converting unit with above-mentioned database update information translation become the data base manipulation statement that can in MYSQL, carry out " table name add field name field type comment ' explanation of field that alter need revise '; ", and send it among the MYSQL and carry out, finished database update.
Described WEB database platform also comprises: the DDS storage unit, be connected with described DDS converting unit, and be used to store the data base manipulation statement that is converted to that is received from described DDS converting unit;
Described WEB database platform also comprises: DDS historical information unit, be connected with foreground WEB display interface with described DDS storage unit, be used for reading the data base manipulation statement of described DDS cell stores, and the data base manipulation statement of the described DDS cell stores that read is sent to foreground WEB display interface show from described DDS storage unit; And according to the DDS operation information that receives from the WEB display interface data base manipulation statement of storing the described DDS storage unit is operated, described operation comprises consults, derives or deletion etc.;
Described WEB database platform also comprises: DDS examines the unit, be connected with background data base with the DDS storage unit, be used for the unenforced data base manipulation statement that regularly reads from described DDS storage unit is examined, examine by, then will examine the data base manipulation statement that passes through and send to background data base and carry out, and in described DDS storage unit, the described data base manipulation statement that passes through of examining be done to examine and passed through mark; Otherwise, do to examine and do not pass through mark examining the data base manipulation statement that does not pass through in the described DDS storage unit.Described examining comprises the operating right of database permission and examining of action type.
Be that MYSQL is an example below with the background data base, WEB database platform of the present invention is described.
Described WEB database represents the unit user message table that to read a table name as shown in table 1 from MYSQL be uinf_users and is presented in the WEB display interface of foreground
Table 1 user message table uinf_users
Table 1 data from the information_schema storehouse (system information storehouse), this storehouse table is read-only, so without any potential safety hazard.If any list structure change is arranged in the entire database, database can upgrade this storehouse automatically.Present Sybase product all has the system information storehouse of similar information_schema, so this platform all is suitable for any database, just read the source difference, realized plug property flexibly, and can directly page info be stored document.
Described WEB database update unit provides the visible database of an easy operating as shown in Figure 2 to revise the page by the WEB display interface, and the action type that comprises that will receive from the WEB display interface is a delete list, revise data and comprise the database update information of the table name uinf_users that needs are revised or comprise that action type is to revise field name, revise data and comprise that table name uinf_users, the field name userid of needs modification and the database update information of amended field name user_id send to described DDS converting unit; Then described DDS converting unit becomes the data base manipulation statement that can carry out with above-mentioned database update information translation in MYSQL " drop table uinf_users; " or " alter table uinf_userschange userid user_id; " and be stored in the described DDS storage unit.
Described DDS historical information unit reads above-mentioned two data base manipulation statements from described DDS storage unit, and two data base manipulation statements that read are sent to foreground WEB display interface demonstration;
DDS examines the unit and reads above-mentioned two data base manipulation statements from described DDS storage unit and examine, for data base manipulation statement " alter table uinf_users change useriduser_id; " examine by, then will examine data base manipulation statement " the alter tableuinf_users change userid user_id that passes through; " send to background data base and carry out, and in described DDS storage unit to described data base manipulation statement " the alter tableuinf_users change userid user_id that passes through that examines; " do to examine and pass through mark; For data base manipulation statement " drop table uinf_users; " examine and do not pass through, then to examining the data base manipulation statement that does not pass through in the described DDS storage unit " drop table uinf_users; " do and examine not by mark, the described reason of not passing through of examining may be that background data base does not allow the operation of his-and-hers watches uinf_users or do not allow to carry out the operation of delete list uinf_users.
In sum, the invention provides a kind of WEB database platform, by described WEB database platform is connected with foreground WEB display interface with background data base, utilize foreground WEB display interface to show the storehouse list structure of background data base, and the database update information that the user is carried out on the WEB display interface of foreground, convert the data base manipulation statement that in background data base, to carry out to, and the data base manipulation statement that is converted to sent in the background data base carry out, make the developer comprehensive understanding to be arranged to the overall data storehouse, and be easy to realize management to database, and can accept approval process, thereby realize database O﹠M truly; The background data base connection represents with foreground WEB and separates, and can be implemented in the different databases and use.
Above embodiment only is used to illustrate the present invention; and be not limitation of the present invention; the those of ordinary skill in relevant technologies field; under the situation that does not break away from the spirit and scope of the present invention; can also make various variations and modification; therefore all technical schemes that are equal to also belong to category of the present invention, and scope of patent protection of the present invention should be defined by the claims.
Claims (10)
1. the invention discloses a kind of WEB database platform, it is characterized in that, described WEB database platform comprises: the WEB database represents unit and interconnected WEB database update unit and data definition statement DDS converting unit; Described WEB database represents the unit and is connected with foreground WEB display interface with background data base; Described WEB database update unit is connected with foreground WEB display interface; Described DDS converting unit is connected with background data base; Wherein,
Described WEB database represents the unit, is used for the storehouse list structure from the background data base reading database, and the storehouse list structure of the database that read is sent to foreground WEB display interface shows;
Described WEB database update unit is used for providing the visible database of an easy operating to revise the page by the WEB display interface, and will sends to described DDS converting unit from the database update information that the WEB display interface receives;
Described DDS converting unit becomes the data base manipulation statement that can carry out according to the database update information translation that predefined transformational relation table will be received from described WEB database update unit in background data base, and the data base manipulation statement that is converted to sent in the background data base carries out.
2. WEB database platform according to claim 1, it is characterized in that, described WEB database platform further comprises: the DDS storage unit, be connected with described DDS converting unit, and be used to store the data base manipulation statement that is converted to that is received from described DDS converting unit.
3. WEB database platform according to claim 2, it is characterized in that, described WEB database platform further comprises: DDS historical information unit, be connected with foreground WEB display interface with described DDS storage unit, be used for reading the data base manipulation statement of described DDS cell stores, and the data base manipulation statement of the described DDS cell stores that read is sent to foreground WEB display interface show from described DDS storage unit; And the data base manipulation statement of storing the described DDS storage unit is operated according to the DDS operation information that receives from the WEB display interface.
4. WEB database platform according to claim 3 is characterized in that, described operation comprises consults, derives or delete.
5. WEB database platform according to claim 2, it is characterized in that, described WEB database platform further comprises: DDS examines the unit, be connected with background data base with the DDS storage unit, be used for the unenforced data base manipulation statement that reads from described DDS storage unit is examined, examine by, then will examine the data base manipulation statement that passes through and send to background data base and carry out, and in described DDS storage unit, the described data base manipulation statement that passes through of examining be done to examine and passed through mark; Otherwise, do to examine and do not pass through mark examining the data base manipulation statement that does not pass through in the described DDS storage unit.
6. WEB database platform according to claim 5 is characterized in that, described examining comprises: to the operating right of database permission and examining of action type.
7. according to each described WEB database platform among the claim 1-6, it is characterized in that described background data base comprises: MYSQL, ORACLE, DB2 or SQLSERVER
8. according to each described WEB database platform among the claim 1-6, it is characterized in that described database update information comprises action type and corresponding modification data.
9. WEB database platform according to claim 8 is characterized in that, described action type comprises increase table, delete list, increase field, deletion field or revises field.
10. WEB database platform according to claim 8 is characterized in that, described modification data comprise table name, field name, field type or the explanation of field that needs are revised.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010604557A CN102033951B (en) | 2010-12-15 | 2010-12-15 | WEB database platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010604557A CN102033951B (en) | 2010-12-15 | 2010-12-15 | WEB database platform |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102033951A true CN102033951A (en) | 2011-04-27 |
| CN102033951B CN102033951B (en) | 2012-09-05 |
Family
ID=43886844
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201010604557A Active CN102033951B (en) | 2010-12-15 | 2010-12-15 | WEB database platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102033951B (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102346785A (en) * | 2011-11-15 | 2012-02-08 | 北京创腾科技有限公司 | Method and device for directly self-defining field of database |
| CN105224544A (en) * | 2014-05-30 | 2016-01-06 | 北大方正集团有限公司 | A kind of data editing method of database and device |
| US9779106B2 (en) | 2011-08-15 | 2017-10-03 | Lenovo (Beijing) Co., Ltd. | Application management method and device |
| CN107634996A (en) * | 2017-09-08 | 2018-01-26 | 苏州数睿云信息技术有限公司 | A kind of framework of unified data and business operation service development platform |
| CN108399183A (en) * | 2017-11-01 | 2018-08-14 | 平安科技（深圳）有限公司 | Database interlock method, electronic device and storage medium based on Excel system interfaces |
| CN110087135A (en) * | 2019-04-19 | 2019-08-02 | 上海车轮互联网服务有限公司 | Operation data processing method and processing device |
| CN110188089A (en) * | 2019-05-31 | 2019-08-30 | 杭州安恒信息技术股份有限公司 | A kind of database O&M management-control method and device |
| CN111190916A (en) * | 2018-10-25 | 2020-05-22 | 北京数安鑫云信息技术有限公司 | Visual business data operating system and method |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050108283A1 (en) * | 2003-11-18 | 2005-05-19 | Oracle International Corporation | Method of and system for associating an electronic signature with an electronic record |
| US7263663B2 (en) * | 2001-03-02 | 2007-08-28 | Oracle International Corporation | Customization of user interface presentation in an internet application user interface |
| CN101377774A (en) * | 2007-08-31 | 2009-03-04 | 上海证券交易所 | System and method for pre-analyzing according to relationship between metadata and data object |
-
2010
- 2010-12-15 CN CN201010604557A patent/CN102033951B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7263663B2 (en) * | 2001-03-02 | 2007-08-28 | Oracle International Corporation | Customization of user interface presentation in an internet application user interface |
| US20050108283A1 (en) * | 2003-11-18 | 2005-05-19 | Oracle International Corporation | Method of and system for associating an electronic signature with an electronic record |
| CN101377774A (en) * | 2007-08-31 | 2009-03-04 | 上海证券交易所 | System and method for pre-analyzing according to relationship between metadata and data object |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9779106B2 (en) | 2011-08-15 | 2017-10-03 | Lenovo (Beijing) Co., Ltd. | Application management method and device |
| CN102346785A (en) * | 2011-11-15 | 2012-02-08 | 北京创腾科技有限公司 | Method and device for directly self-defining field of database |
| CN105224544A (en) * | 2014-05-30 | 2016-01-06 | 北大方正集团有限公司 | A kind of data editing method of database and device |
| CN107634996A (en) * | 2017-09-08 | 2018-01-26 | 苏州数睿云信息技术有限公司 | A kind of framework of unified data and business operation service development platform |
| CN108399183A (en) * | 2017-11-01 | 2018-08-14 | 平安科技（深圳）有限公司 | Database interlock method, electronic device and storage medium based on Excel system interfaces |
| CN111190916A (en) * | 2018-10-25 | 2020-05-22 | 北京数安鑫云信息技术有限公司 | Visual business data operating system and method |
| CN110087135A (en) * | 2019-04-19 | 2019-08-02 | 上海车轮互联网服务有限公司 | Operation data processing method and processing device |
| CN110188089A (en) * | 2019-05-31 | 2019-08-30 | 杭州安恒信息技术股份有限公司 | A kind of database O&M management-control method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102033951B (en) | 2012-09-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102033951B (en) | WEB database platform | |
| US8423514B2 (en) | Service provisioning | |
| CN102770849B (en) | Optimizing a data cache when applying user-based security | |
| US20120110021A1 (en) | Generating data models | |
| CN101930443A (en) | Data service system and data service realization method | |
| CN101673287A (en) | SQL sentence generation method and system | |
| CN105046438A (en) | Customized process configuration office system based on visible process configuration | |
| WO2007002412A2 (en) | Systems and methods for retrieving data | |
| KR20150010655A (en) | System and method for modelling data | |
| US20150039600A1 (en) | Extensible person container | |
| CN104506628B (en) | A kind of plug-in unit warehouse management method and system | |
| CN101093524A (en) | Authorization process system based on hierarchy | |
| CN102663008A (en) | Government integrated business platform business library and construction method of base library | |
| US20110153578A1 (en) | Method And Apparatus For Propagation Of File Plans From Enterprise Retention Management Applications To Records Management Systems | |
| CN114218218A (en) | Data processing method, device and equipment based on data warehouse and storage medium | |
| CN104008107A (en) | Implement method of knowledge base on operation and maintenance management | |
| JP2013065216A (en) | Document management server system | |
| US20200089746A1 (en) | Merging documents based on document schemas | |
| CN117472874A (en) | Government affair data resource integrated management system and method based on big data analysis | |
| CN101266545A (en) | Electric power industry integral supporting platform | |
| Fürber et al. | Data quality | |
| KR100796906B1 (en) | Method for Quality Control of DataBase | |
| CN105550176A (en) | Basic mapping method for relational database and XML | |
| CN104573053A (en) | Configuration item template dynamic customizing method based on XML | |
| CN107273425A (en) | A kind of Database Development Method and device based on ORM frameworks |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CP02 | Change in the address of a patent holder |
Address after: Room 810, 8 / F, 34 Haidian Street, Haidian District, Beijing 100080 Patentee after: BEIJING D-MEDIA COMMUNICATION TECHNOLOGY Co.,Ltd. Address before: 100089 Beijing city Haidian District wanquanzhuang Road No. 28 Wanliu new building A block 5 layer Patentee before: BEIJING D-MEDIA COMMUNICATION TECHNOLOGY Co.,Ltd. |
|
| CP02 | Change in the address of a patent holder |