CN104346334A - Remote visual interface database system - Google Patents
Remote visual interface database system Download PDFInfo
- Publication number
- CN104346334A CN104346334A CN201310312155.4A CN201310312155A CN104346334A CN 104346334 A CN104346334 A CN 104346334A CN 201310312155 A CN201310312155 A CN 201310312155A CN 104346334 A CN104346334 A CN 104346334A
- Authority
- CN
- China
- Prior art keywords
- interface
- statement
- data
- database
- remote visible
- 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
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
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)
Abstract
The invention discloses a remote visual interface database system, and the remote visual interface database system comprises a data transmission interface, a statement conversion unit, a mapping correlation chart and a database. The data transmission interface is connected with the statement conversion unit to provide multiple input and output templates, and each template is corresponding to one data input and output type; all templates are in advance stored in the mapping correlation chart, and each template is correspondingly converted into the SQL (structured query language ) statement; the statement conversion unit is connected with the mapping correlation chart, according to the mapping correlation chart, the data introduced from the data transmission interface is converted into the SQL statement; the converted SQL statement is written into the database through the statement conversion unit. Through the technical solution of the remote visual interface database system, exclusive statements of the database can be converted, so that general technicians and nontechnical persons can correctly access and operate the database on the external interface, and the using threshold of the special database is reduced.
Description
Technical field
The present invention relates to a kind of Database Systems, more particularly, relate to a kind of remote visible interface data storehouse system.
Background technology
Database (Database) be organize according to data structure, the warehouse of store and management data, it results from before modern ISUZU company, along with the development in infotech and market, particularly after nineteen nineties, data management is no longer only store and management data, and is transformed into the mode of the various data managements required for user.Database has number of different types, is widely used all in all fields from the form the most simply storing various data to the large-scale database system can carrying out mass data storage.
The core of database is data structure, and data structure is divided into again the logical organization of data and the physical arrangement of data.The logical organization of data carrys out observed data from the angle (contact namely between data and organizational form) of logic, analyzes data, has nothing to do with the memory location of data.The physical arrangement of data refers to the structure that data are deposited in a computer, i.e. the logical organization of data way of realization in a computer, so physical arrangement is also referred to as storage organization.Here the logical organization of a data, and reflection and the method that realizes Data relationship are called data model.Popular data model has three kinds, namely press Graph Theory set up hierarchy Model and reticulate texture model and by relational theory foundation relational structure model.
But the data structure that database is especially proprietary, but this data structure needs special personnel could grasp after a large amount of study and training, the staff circulated around whole database must be want IT technician, proposes very high requirement like this for enterprise on the threshold utilizing database.
Summary of the invention
Object of the present invention aims to provide a kind of remote visible interface data storehouse system, solves the professional height of prior art database statement, the unworkable problem of general personnel.
According to the present invention, a kind of remote visible interface data storehouse system is provided, comprises data transmission interface, statement converting unit, mapping relations table, database.Data transmission interface enable statement converting unit, it provides multiple input and output masterplate, the corresponding a kind of data input and output type of each template; Prestoring all templates in mapping relations table, is SQL statement by each template corresponding conversion; Statement converting unit connects mapping relations table, according to mapping relations table, the data that data transmission interface imports is converted to SQL statement; SQL statement after conversion is written in database by statement converting unit.
According to one embodiment of the invention, data transmission interface connects visual interface, and visual interface comprises local visual interface and remote visible interface; Visual interface provides multiple input and output type selecting.Input and output type is sent to data transmission interface by visual interface.
According to one embodiment of the invention, data transmission interface receives output type, and is sent to statement converting unit, and SQL statement, when reading database data, is converted to output type according to mapping relations table by statement converting unit.
According to one embodiment of the invention, input and output type comprises Word, Excel, PDF.
According to one embodiment of the invention, relation mapping table comprises the mutual GO TO statement of Word and SQL, the mutual GO TO statement of Excel and SQL, the mutual GO TO statement of PDF and SQL.
According to one embodiment of the invention, remote visible interface data storehouse system also comprises contract generation module, and contract generation module connection data storehouse, reads corresponding data from database.
According to one embodiment of the invention, remote visible interface data storehouse system also comprises agreed-upon price module, connects contract generation module, and the data of correspondence can be written in contract generation module.
According to one embodiment of the invention, remote visible interface data storehouse system also comprises print module, is connected with contract generation module.
According to one embodiment of the invention, remote visible interface data storehouse system also comprises confirmation module, confirms that module connects local visual interface and remote visible interface respectively.
Have employed technical scheme of the present invention, conversion can be provided to the proprietary statement of database, thus those skilled in the art and non-technical personnel can be allowed also correctly to access and operating database in outer interface, reduce the use threshold of specialized database.
Accompanying drawing explanation
In the present invention, identical Reference numeral represents identical feature all the time, wherein:
Fig. 1 is the structural representation of remote visible interface data storehouse of the present invention system.
Embodiment
Technical scheme of the present invention is further illustrated below in conjunction with drawings and Examples.
With reference to Fig. 1, the present invention discloses a kind of remote visible interface data storehouse system, it is by following main module composition: data module 3, process module 4, visual interface and confirmation module 5, wherein data module 3 include data transmission interface 31,33, statement converting unit 32,34, mapping relations table 35 and database 36, process module 4 includes contract generation module 41, agreed-upon price module 42 and print module 43, and visual interface includes local visual interface 1 and remote visible interface 2.Illustrate the major function of the annexation of above-mentioned modules below.
As shown in Figure 1, the core of remote visible interface data storehouse of the present invention system is data module 3, in the inside of data module 3, data transmission interface 31 enable statement converting unit 32, data transmission interface 33 enable statement converting unit 34, it provides multiple input and output masterplate, the corresponding a kind of data input and output type of each template.
Prestoring all templates in mapping relations table 35, is SQL statement by each template corresponding conversion.Statement converting unit 32,34 connects mapping relations table 35, according to mapping relations table 35, the data that data transmission interface 31,33 imports is converted to SQL statement.SQL statement after conversion is written in database by statement converting unit 32,34.
Illustrate how data module 3 and visual interface operate below by an example.
Data module 3 connects outside local visual interface 1 and remote visible interface 2 by data transmission interface 31,33.Local visual interface 1/ remote visible interface 2 provides multiple input and output type selecting, and input and output type is first sent to data transmission interface 31 by remote visible interface 2.Then, after data transmission interface 31 receives output type, output type is sent to statement converting unit 32, SQL statement, when reading database 36 data, is converted to input type according to mapping relations table 35 by statement converting unit 32.
Conversely, local visual interface 1 also can provide the selection of input type, input type is sent to data transmission interface 33.After data transmission interface 33 receives input type, input type is sent to statement converting unit 34, SQL statement, when reading database 36 data, is converted to output type according to mapping relations table 35 by statement converting unit 34.
The input and output type of mapping relations table 35 comprises Word, Excel, PDF, specifically, comprises the mutual GO TO statement of Word and SQL, the mutual GO TO statement of Excel and SQL, the mutual GO TO statement of PDF and SQL.
Data module 3 is connected with process module 4 by database, and database is connected with contract generation module 41 specifically, and contract generation module 41 reads corresponding data from database.
Contract generation module 41 also connects agreed-upon price module 42, and agreed-upon price module 42 provides the agreed-upon price interface of both parties, can be changed the data that part price is relevant, and the data of correspondence can be written in contract generation module 41 by artificial mode.Contract generation module 41 also connects print module 43, and final contract dataset is printed as contract text.
In addition, also be provided with between local visual interface 1 and remote visible interface 2 and confirm module 5, confirm that module 5 connects local visual interface 1 and remote visible interface 2 respectively, in order to directly to transmit data between local visual interface 1 and remote visible interface 2, the operating personnel of such both sides are after operating database, can directly be confirmed by the mode being similar to special line, thus can at very first time feedback database operating result.
Those of ordinary skill in the art will be appreciated that, above instructions is only one or more embodiments in the numerous embodiment of the present invention, and not uses limitation of the invention.Any equalization for the above embodiment changes, modification and the equivalent technical scheme such as to substitute, as long as spirit according to the invention, all will drop in scope that claims of the present invention protect.
Claims (9)
1. a remote visible interface data storehouse system, is characterized in that, comprising:
Data transmission interface, statement converting unit, mapping relations table, database;
Described data transmission interface connects described statement converting unit, and it provides multiple input and output masterplate, the corresponding a kind of data input and output type of template described in each;
Prestoring all described templates in described mapping relations table, is SQL statement by template corresponding conversion described in each;
Described statement converting unit connects mapping relations table, according to described mapping relations table, the data that data transmission interface imports is converted to SQL statement;
SQL statement after conversion is written in database by described statement converting unit.
2. remote visible interface data storehouse as claimed in claim 1 system, is characterized in that, described data transmission interface connects visual interface, and described visual interface comprises local visual interface and remote visible interface; Described visual interface provides multiple input and output type selecting.Described input and output type is sent to described data transmission interface by described visual interface.
3. remote visible interface data storehouse as claimed in claim 2 system, it is characterized in that, described data transmission interface receives output type, and be sent to statement converting unit, SQL statement, when reading database data, is converted to described output type according to described mapping relations table by described statement converting unit.
4. remote visible interface data storehouse as claimed in claim 1 system, it is characterized in that, described input and output type comprises Word, Excel, PDF.
5. remote visible interface data storehouse as claimed in claim 1 system, it is characterized in that, described relation mapping table comprises the mutual GO TO statement of Word and SQL, the mutual GO TO statement of Excel and SQL, the mutual GO TO statement of PDF and SQL.
6. remote visible interface data storehouse as claimed in claim 1 system, it is characterized in that, described remote visible interface data storehouse system also comprises contract generation module, and described contract generation module connects described database, from described database, read corresponding data.
7. remote visible interface data storehouse as claimed in claim 1 system, it is characterized in that, described remote visible interface data storehouse system also comprises agreed-upon price module, connects described contract generation module, and the data of correspondence can be written in described contract generation module.
8. remote visible interface data storehouse as claimed in claim 1 system, it is characterized in that, described remote visible interface data storehouse system also comprises print module, is connected with described contract generation module.
9. remote visible interface data storehouse as claimed in claim 2 system, it is characterized in that, described remote visible interface data storehouse system also comprises confirmation module, and described confirmation module connects described local visual interface and described remote visible interface respectively.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310312155.4A CN104346334A (en) | 2013-07-23 | 2013-07-23 | Remote visual interface database system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310312155.4A CN104346334A (en) | 2013-07-23 | 2013-07-23 | Remote visual interface database system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104346334A true CN104346334A (en) | 2015-02-11 |
Family
ID=52501966
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310312155.4A Pending CN104346334A (en) | 2013-07-23 | 2013-07-23 | Remote visual interface database system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104346334A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108399183A (en) * | 2017-11-01 | 2018-08-14 | 平安科技（深圳）有限公司 | Database interlock method, electronic device and storage medium based on Excel system interfaces |
| CN109325042A (en) * | 2018-08-14 | 2019-02-12 | 中国平安人寿保险股份有限公司 | Handle template acquisition methods, form processing method, device, equipment and medium |
| CN112131846A (en) * | 2020-09-07 | 2020-12-25 | 北京思特奇信息技术股份有限公司 | Method and system for parameter transmission based on mapping relation, electronic device and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060247805A1 (en) * | 2005-01-27 | 2006-11-02 | Neil Thomson | Process automation |
| CN101311926A (en) * | 2007-05-23 | 2008-11-26 | 鸿富锦精密工业（深圳）有限公司 | Notes data structuring system and method |
| CN101393526A (en) * | 2008-10-16 | 2009-03-25 | 宁波玺玛克智能科技有限公司 | Data synchronization method capable of implementing programmable data conversion and file conversion function |
| CN101499162A (en) * | 2009-03-05 | 2009-08-05 | 唐文超 | Medical research data management system and method |
| CN102254029A (en) * | 2011-07-29 | 2011-11-23 | 株洲南车时代电气股份有限公司 | View-based data access system and method |
-
2013
- 2013-07-23 CN CN201310312155.4A patent/CN104346334A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060247805A1 (en) * | 2005-01-27 | 2006-11-02 | Neil Thomson | Process automation |
| CN101311926A (en) * | 2007-05-23 | 2008-11-26 | 鸿富锦精密工业（深圳）有限公司 | Notes data structuring system and method |
| CN101393526A (en) * | 2008-10-16 | 2009-03-25 | 宁波玺玛克智能科技有限公司 | Data synchronization method capable of implementing programmable data conversion and file conversion function |
| CN101499162A (en) * | 2009-03-05 | 2009-08-05 | 唐文超 | Medical research data management system and method |
| CN102254029A (en) * | 2011-07-29 | 2011-11-23 | 株洲南车时代电气股份有限公司 | View-based data access system and method |
Non-Patent Citations (2)
| Title |
|---|
| 刘炳文: "《精通Visual Basic 6.0中文版》", 31 July 1999 * |
| 文龙: "基于XML的非结构化数据管理研究及应用", 《中国优秀硕士学位论文全文数据库信息科技辑》 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108399183A (en) * | 2017-11-01 | 2018-08-14 | 平安科技（深圳）有限公司 | Database interlock method, electronic device and storage medium based on Excel system interfaces |
| CN109325042A (en) * | 2018-08-14 | 2019-02-12 | 中国平安人寿保险股份有限公司 | Handle template acquisition methods, form processing method, device, equipment and medium |
| CN109325042B (en) * | 2018-08-14 | 2023-11-24 | 中国平安人寿保险股份有限公司 | Processing template acquisition method, form processing method, device, equipment and medium |
| CN112131846A (en) * | 2020-09-07 | 2020-12-25 | 北京思特奇信息技术股份有限公司 | Method and system for parameter transmission based on mapping relation, electronic device and storage medium |
| CN112131846B (en) * | 2020-09-07 | 2024-06-04 | 北京思特奇信息技术股份有限公司 | Method and system for transmitting parameters based on mapping relation, electronic device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103714129B (en) | Dynamic data structure based on conditional plan and the construction device of relation and construction method | |
| CN102968306B (en) | A kind of code automatic generation method based on data model driving and system | |
| CN105739984B (en) | A kind of maintainable data presentation system of height based on Qt | |
| CN108228817A (en) | Data processing method, device and system | |
| US11928114B2 (en) | Query generation based on a logical data model with one-to-one joins | |
| CN103810275A (en) | Method and device for data interaction between non-relation type database and relation type database | |
| US10354343B2 (en) | Automated process control hardware engineering using schema-represented requirements | |
| CN103699638A (en) | Method for realizing cross-database type synchronous data based on configuration parameters | |
| CN106980672A (en) | The data-storage system and method for a kind of isomerous environment Based on Object-Oriented Technology | |
| CN104008485A (en) | Intelligent order generation device and method | |
| CN102306355A (en) | Management system for IT (Information Technology) operation and maintenance configuration | |
| CN104317864A (en) | Automatic identification method of information model based on IEC61850 logical nodes | |
| CN110737729A (en) | Engineering map data information management method based on knowledge map concept and technology | |
| CN109783886A (en) | Emerging system and method for GIM model and IFC model | |
| Zhong et al. | RFID-enabled real-time manufacturing execution system for discrete manufacturing: Software design and implementation | |
| CN105354376A (en) | Method and system for interaction between BIM based multi-dimensional data and OA database | |
| CN104346334A (en) | Remote visual interface database system | |
| KR20200082051A (en) | System for managing ontology data of power grid | |
| CN104951565B (en) | XM (extensible messaging client) L (extensible markup language) configuration maintenance method and system based on memory database | |
| CN102799555B (en) | Design method capable of configuring data interaction tool in electric power information system and system | |
| CN113434798B (en) | Code-free RPA automatic process file generation method and system | |
| CN103729455B (en) | Master data storage method based on primary copy storage pattern | |
| CN105550176A (en) | Basic mapping method for relational database and XML | |
| CN103294878A (en) | Unified modeling method of multidimensional grid models based on DMS (database management system) | |
| CN108090151A (en) | Spatial data accessing method and storage medium based on multi-data source |
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 |
Application publication date: 20150211 |
|
| RJ01 | Rejection of invention patent application after publication |