CN1641639A - Multi data base query system and method thereof - Google Patents
Multi data base query system and method thereof Download PDFInfo
- Publication number
- CN1641639A CN1641639A CN 200410001428 CN200410001428A CN1641639A CN 1641639 A CN1641639 A CN 1641639A CN 200410001428 CN200410001428 CN 200410001428 CN 200410001428 A CN200410001428 A CN 200410001428A CN 1641639 A CN1641639 A CN 1641639A
- Authority
- CN
- China
- Prior art keywords
- database
- key word
- data
- query result
- storehouse
- 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
Images
Abstract
The invention relates to a system that can inquire plural database and the method. There are plural different databases existing in computer, and the storage method, data format and data state are always different, even the stored file format is different. The invention would connect to plural databases through a universal inquiring interface. When inquiring data, the database needs to inquire should be selected and after inputting keywords, the inquiring result would be display according to the selected database.
Description
Technical field
The present invention relates to a kind of system and method thereof of inquiring about the several data storehouse, particularly show the system and the method thereof in the inquiry several data storehouse of corresponding Query Result according to selected database.
Background technology
Many executable application programs are arranged in the computing machine, and most application program all has its special storing mode for data, so, must use corresponding application program, could inquire about its stored data, operations such as unlatching, access.In addition, application program all mostly stores in the mode of file for data, and according to different storing modes, the application program that has can become data storing a file, and the application program that has is then according to the difference of data field, and is stored in respectively in the different files.
In general, the file in the computing machine all is based on storage data, even stores the data of many fields in some file, also can a kind of at last database.Therefore stored database miscellaneous (for example: musical database, film data storehouse, photograph database, address book etc.) still in the computing machine, when inquiring about a certain data, must hunt out the file that stores these data earlier, open this file by application-specific, and from file, capture the data that to inquire about by the query function of application-specific, then, by the output interface of application-specific, show the Query Result that meets data again.Below with the address book be example as an illustration, several master data fields have been comprised in the file of address book: title, phone, address, e-mail box etc., when the data that will inquire about, must open address book by address book software, the file of access address book.Address book software then provides query function, can inquire about by the input of key word, captures the data that meet from the file of address book, and exports its Query Result by its output interface.And inquire about other database also is like this.
Because the employed application program of disparate databases is all inequality, and most data all have specific file layout, must utilize corresponding application program to open, then the interface inquiry by application program.Therefore, even obtain some data files (for example: the file that the file of disk sheet, network transmit, the annex of Email etc.), owing to there is not corresponding application program yet, thus can't open this data file, and then learn its data content.Because the database of different file layouts must be opened or inquiry with different application programs, and is considerably inconvenient.
Summary of the invention
Because above-mentioned shortcoming if can pass through a common query interface, as long as import key word and choose the database that will inquire about, just can show that it meets the Query Result of key word according to the database of being inquired about.And need not go to consider the factors such as content, data layout and storing mode of database again, increase the convenience of inquiry.
So, the invention provides the common query interface of disparate databases, this common query interface can be respectively connects with different database, and common query interface also comprises a key word input field and a database is selected field, can select it to want individual data storehouse or a plurality of database of inquiring about, according to selected database, output meets the Query Result of key word then.
For achieving the above object, in the system and method thereof in inquiry several data provided by the present invention storehouse, include the following units:
The key word input block, in order to receive the key word of being imported, and the key word input block can receive the key word that single character string or a plurality of character string are formed, then, the key word that it received is analyzed, can be respectively in order to each character string of inquiring about and the sign of operation or the logical symbol that analyze in the key word.
The database selected cell in order to receive selected database, can only be selected a database, or selects a plurality of different database one query simultaneously.
Linkage unit in order to connecting selected database, and is set up a connecting channel with this database, and connecting channel can pass through network communication, so that can inquire about the database in the remote computer.And the database ways of connecting can be set up the connecting channel of linking up then by selected database corresponding application program when mediating, or the file in linkage unit energy direct accessing data storehouse, and sets up connecting channel.
Query unit in order to according to the key word of being imported, through the connecting channel Query Database, and captures or receives the data of being inquired about from database, put the back in order according to a data that capture or receive and produce a Query Result.
Output unit in order to receiving Query Result, and shows corresponding Query Result according to selected database.
In addition, the system and the method thereof in inquiry several data provided by the present invention storehouse include the following step:
At first, input key word and the database of selecting to inquire about; When pressing inquire button, can connect selected database, and set up a connecting channel with database; According to the key word of being imported, inquire about selected database through connecting channel, and from database, capture the Query Result that meets key word; Reach from database and receive above-mentioned Query Result, and show corresponding Query Result according to selected database.
The feasible embodiment of relevant the present invention now is described as follows with regard to conjunction with figs..
Description of drawings
Fig. 1 is the system in inquiry several data provided by the present invention storehouse and the synoptic diagram of method thereof;
Fig. 2 is the system in inquiry several data provided by the present invention storehouse and the block scheme of method thereof; And
Fig. 3 is the system in inquiry several data provided by the present invention storehouse and the process flow diagram of method thereof.
Wherein, description of reference numerals is as follows:
10 key words
11 musical databases
12 common query interfaces
13 film data storehouses
14 Query Results
15 photograph databases
16 database hubs
17 address books
20 database selected cells
22 key word input blocks
24 linkage units
26 query unit
28 output units
29 databases
Step 300 receives the key word of input and the database of selection
Embodiment
Fig. 1 is the system in inquiry several data of the present invention storehouse and the synoptic diagram of method thereof, as shown in Figure 1, import it and want the key word 10 inquired about, the key word 10 that common query interface 12 receptions of process are imported (for example: Kelly), be connected to database hub 16 then, and database hub 16 is made up of a plurality of disparate databases, for example musical database 11, film data storehouse 13, photograph database 15, address book 17 etc.(for example: address book 17) select its database that will inquire about from database hub 16, then, data from the relevant Kelly of address book 17 acquisitions, and Query Result (information such as e-mail box, phone, address) is back to common query interface 12, at last with the data output that is received, as Query Result 14.
Fig. 2 is the system in inquiry several data of the present invention storehouse and the block scheme of method thereof, as shown in Figure 2, comprise database selected cell 20, key word input block 22, linkage unit 24, query unit 26, output unit 28, reach database 29, by the reciprocation of above-mentioned each unit, reach the purpose that shows corresponding Query Result according to selected database 29.
The database 29 inquired about is wanted in selection, obtains its selected databases 29 by database selected cell 20.Also can import the key word that to inquire about, obtain the key word of its input by key word input block 22.Linkage unit 24 is set up a connecting channel according to selected database 29 with database 29 then.And query unit 26 through connecting channel Query Database 29, similarly, also returns Query Result through connecting channel by linkage unit 24 according to the key word of being imported.And query unit 26 obtains to send Query Result to output unit 28 after the Query Result.Then, output unit 28 shows corresponding Query Result according to selected database.
Fig. 3 is the system in inquiry several data of the present invention storehouse and the process flow diagram of method thereof, and please refer to Fig. 3 and be explained as follows:
At first, receive the key word and the selected database (step 300) of input; When receiving the instruction of pressing inquire button, can set up a connecting channel (step 310) with this database then according to selected database; After connecting with selected database, meeting is according to this connecting channel Query Database of key word process of being imported, and passback Query Result (step 320); And after receiving Query Result, the result can be exported, show corresponding Query Result (step 330) according to selected database.
The above only is the present invention's preferred embodiment wherein, is not to be used for limiting practical range of the present invention; All equalizations of being done without departing from the spirit and scope of the present invention according to the present patent application claim change and modify, and all should belong in the patent claims of the present invention scope required for protection.
Claims (6)
1. system of inquiring about the several data storehouse, wherein this system comprises:
One key word input block is in order to receive a key word of input;
One database selected cell is in order to receive selected this database;
One linkage unit in order to according to selected this database, and is set up a connecting channel with this database;
One query unit is in order to inquire about this database and to return a Query Result through this connecting channel according to this key word of being imported; And
One output unit in order to receiving this Query Result, and shows corresponding this Query Result according to selected this database.
2. the system in inquiry several data as claimed in claim 1 storehouse, wherein this database is group's combination of a musical database, a film data storehouse, a photograph database and an address book.
3. the system in inquiry several data as claimed in claim 1 storehouse, wherein this linkage unit also can connect through network and remote data base.
4. method of inquiring about the several data storehouse, wherein this method comprises the following step:
Receive a key word of this input and this database of selection;
According to selected this database, set up a connecting channel with this database;
Inquire about this database according to this key word of being imported through this connecting channel, and return a Query Result; And
Receive this Query Result, and show corresponding this Query Result according to selected this database.
5. the method in inquiry several data as claimed in claim 5 storehouse, wherein this database is group's combination of a musical database, a film data storehouse, a photograph database and an address book.
6. the method in inquiry several data as claimed in claim 5 storehouse, wherein this database also can be through network as connection.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200410001428 CN1641639A (en) | 2004-01-12 | 2004-01-12 | Multi data base query system and method thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200410001428 CN1641639A (en) | 2004-01-12 | 2004-01-12 | Multi data base query system and method thereof |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1641639A true CN1641639A (en) | 2005-07-20 |
Family
ID=34867113
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 200410001428 Pending CN1641639A (en) | 2004-01-12 | 2004-01-12 | Multi data base query system and method thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1641639A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102479218A (en) * | 2010-11-30 | 2012-05-30 | 深圳市金蝶友商电子商务服务有限公司 | Method and server for express query based on API (Application Program Interface) |
| CN103714066A (en) * | 2012-09-29 | 2014-04-09 | Sap股份公司 | Template-based database analyzer |
| CN103761260A (en) * | 2013-12-31 | 2014-04-30 | 北京京东尚科信息技术有限公司 | Method and device for processing mutually-exclusive lock of database, and distributed system |
| CN103457837B (en) * | 2013-08-18 | 2018-08-14 | 苏州量跃信息科技有限公司 | The method and system of instant messaging search are carried out by search engine |
| CN109376174A (en) * | 2018-12-30 | 2019-02-22 | 北京奇艺世纪科技有限公司 | A kind of method and apparatus selecting database |
| CN111259038A (en) * | 2020-01-16 | 2020-06-09 | 北京思特奇信息技术股份有限公司 | Database query and data export method, system, medium and equipment |
-
2004
- 2004-01-12 CN CN 200410001428 patent/CN1641639A/en active Pending
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102479218A (en) * | 2010-11-30 | 2012-05-30 | 深圳市金蝶友商电子商务服务有限公司 | Method and server for express query based on API (Application Program Interface) |
| CN103714066A (en) * | 2012-09-29 | 2014-04-09 | Sap股份公司 | Template-based database analyzer |
| CN103714066B (en) * | 2012-09-29 | 2019-10-22 | Sap欧洲公司 | Database analysis device based on template |
| CN103457837B (en) * | 2013-08-18 | 2018-08-14 | 苏州量跃信息科技有限公司 | The method and system of instant messaging search are carried out by search engine |
| CN103761260A (en) * | 2013-12-31 | 2014-04-30 | 北京京东尚科信息技术有限公司 | Method and device for processing mutually-exclusive lock of database, and distributed system |
| CN103761260B (en) * | 2013-12-31 | 2018-01-23 | 北京京东尚科信息技术有限公司 | The method and apparatus and distributed system of processing data storehouse mutual exclusion lock |
| CN109376174A (en) * | 2018-12-30 | 2019-02-22 | 北京奇艺世纪科技有限公司 | A kind of method and apparatus selecting database |
| CN111259038A (en) * | 2020-01-16 | 2020-06-09 | 北京思特奇信息技术股份有限公司 | Database query and data export method, system, medium and equipment |
| CN111259038B (en) * | 2020-01-16 | 2023-05-30 | 北京思特奇信息技术股份有限公司 | Database query and data export method, system, medium and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7562087B2 (en) | Method and system for processing directory operations | |
| CN1648903A (en) | Automatic query clustering | |
| CN1110067A (en) | Object-oriented network resource phonebook | |
| WO2005091165A2 (en) | Method and system for creation and retrieval of global annotations | |
| CN1573757A (en) | Automatic task generator method and system | |
| CN1360267A (en) | Sorting and searching method for files | |
| JP2005242996A (en) | System and method for controlling collection with visible results | |
| CN1913546A (en) | Method for sort storing mobile phone short message | |
| CN1159665C (en) | Code generator system for digital library and its method | |
| CN1716897A (en) | Be used to drive the client apparatus of remote user interface | |
| WO2008033582A1 (en) | System and method for collection and synchronization of metadata to facilitate distributed content search | |
| CN106294374A (en) | The method of small documents merging and data query system | |
| CN101043421A (en) | Memory based method for searching quickly the longest matching of IP address | |
| CN1885869A (en) | Address list system and its using method | |
| CN1859505A (en) | Bill checking system and method | |
| CN101076795A (en) | Structure of objects stored in a media server and improving accessibility of the structure | |
| CN1924915A (en) | Database technique based library intelligent management system | |
| CN1641639A (en) | Multi data base query system and method thereof | |
| CN101051947A (en) | Method for establishing equipment configuration parameter and base station single plate configuration system | |
| CN101430741A (en) | Short sequence mapping method and system | |
| US20040107204A1 (en) | File management apparatus | |
| CN1018032B (en) | System and method for efficient analysis of relational database objects | |
| CN1816067A (en) | Information terminal | |
| CN101042656A (en) | Application program engines startup method and system for hand held equipment | |
| US6883036B1 (en) | System and method for managing network directories |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20050720 |