CN1858744A - Data inquire system and method - Google Patents
Data inquire system and method Download PDFInfo
- Publication number
- CN1858744A CN1858744A CN 200610064845 CN200610064845A CN1858744A CN 1858744 A CN1858744 A CN 1858744A CN 200610064845 CN200610064845 CN 200610064845 CN 200610064845 A CN200610064845 A CN 200610064845A CN 1858744 A CN1858744 A CN 1858744A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- query
- strange land
- inquiry terminal
- 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
This invention relates to a data enquiry system and a method, in which, said system includes: multiple databases connecting to the enquiry terminals, each terminal and the database are connected with the communication network, the database includes: a storage module, a pointer storage module and an enquiry request analysis module connected with the data storage module, the pointer module, enquiry terminals and the communication network, the enquiry mentod includes: an enquiry terminal sends a request to the local database to get a data pointer pointing to databases of different places to re-send them the enquiry requests, which reduces cost for constructing and maintaining databases.
Description
Technical field
The present invention relates to a kind of data query system and data enquire method, especially point to data query system that strange land data of database pointer makes up and obtain strange land data of database pointer carries out data query to the strange land database the method for pointing to by access local database by storage in the database of this locality.
Background technology
Development along with development of technology and society, it is more and more important that information sharing becomes, in order to solve the problem of data sharing, prior art realizes data sharing by the mode of setting up large-scale central database, as shown in Figure 1, all peripheral systems are connected with central database, and all data that need share are all by the central database centralized management, and peripheral system obtains needed data by the visit central database.But along with being on the increase of shared data amount, caused prior art to show following deficiency: the construction of central database and the cost of maintenance improve greatly; The efficient that peripheral system carries out data access reduces greatly, it mainly shows as, data for some strange lands, adopt the mode of whole centralized stores certainly will cause the database cost to increase and the huge waste of Internet resources, especially those data that often change are such as some daily statistical report forms, the amount of money of customer consumption, daily transaction record or the like, these data are not suitable for being stored in central database.Peripheral system for the visit central database, usually do not need to visit all data of storing in the central database, and just need some specific strange land data be conducted interviews, when in the local data base of these data storage at peripheral system, other peripheral system is difficult to visit again, therefore is difficult to realize data sharing.
Summary of the invention
The present invention is directed to above-mentioned the deficiencies in the prior art, a kind of data query system and data enquire method are provided, can realize sharing of strange land data of database by the mode of storage sensing strange land data of database pointer in local data base, reduced the cost of Database Construction and maintenance, improved access efficiency, avoid the huge waste of database and Internet resources in the prior art, also increased the dirigibility of data access.
For achieving the above object, the invention provides a kind of data query system, comprise a plurality of databases, each database is connected with inquiry terminal, and each inquiry terminal and database all are connected with communication network; Be provided with in the described database: data memory module is used for the data in store local data storehouse; The data pointer memory module, be used for storage and point to strange land data of database pointer, and the query requests analysis module that is connected with communication network with described data memory module, data pointer memory module, inquiry terminal, this query requests analysis module is used to receive the data query request, obtains and points to strange land data of database pointer and return data.
In described database, can also be provided with the query requests forwarding module, be connected, be used to transmit the data query request with described query requests analysis module.
The present invention also provides a kind of data enquire method, comprises the steps:
The query requests analysis module analysis of step 11, described database is by data query request that locally-attached inquiry terminal sent, according to the data category information of carrying in this data query request, judge whether described data are stored in the local data base, if, execution in step 12, otherwise, execution in step 13;
Step 12, the data memory module from described local data base obtain this data, and send to described inquiry terminal, finish then;
Step 13, the described data category information of foundation are obtained from the data pointer memory module of described local data base and are pointed to strange land data of database pointer, and sends to inquiry terminal;
Step 14, described inquiry terminal resend described data query request according to described data pointer to described strange land database, obtain the data that will inquire about.
The present invention also provides another kind of data enquire method to comprise the steps:
The query requests analysis module analysis of step 21, described database is by data query request that locally-attached inquiry terminal sent, according to the data category information of carrying in this data query request, judge whether described data are stored in the local data base, if, execution in step 22, otherwise, execution in step 23;
Step 22, the data memory module from described local data base obtain this data, and send to described inquiry terminal, finish then;
Step 23, the described data category information of foundation are obtained from the data pointer memory module of described local data base and are pointed to strange land data of database pointer, and sends to the query requests forwarding module;
Step 24, described query requests forwarding module resend described data query request according to described data pointer to described strange land database, obtain the data that will inquire about.
Data-storage system provided by the invention and data enquire method have following beneficial effect:
1, reduces the cost of Database Construction and maintenance, improved access efficiency, also avoided the huge waste of database and Internet resources in the prior art.
2, increased the dirigibility of data sharing, can realize data sharing easily by technical scheme of the present invention, data for the less and frequent variation of the frequent degree of visit can be stored in the local data base of application system correspondence, realize data sharing by the mode that data pointer is set in other databases, do not need to increase new equipment, and when the changing of database, only need to revise a data pointer and get final product.
3, can dispose data sharing fast, and can be by revising data pointer dynamic-configuration shared data bank.
Below by drawings and Examples, technical scheme of the present invention is described in further detail.
Description of drawings
Fig. 1 is for realizing the data-storage system synoptic diagram of data sharing in the mode of central database in the prior art;
Fig. 2 is the synoptic diagram of data query system specific embodiment one of the present invention;
Fig. 3 is the synoptic diagram of data query system specific embodiment two of the present invention;
Fig. 4 is the synoptic diagram of data enquire method specific embodiment one of the present invention;
Fig. 5 is the synoptic diagram of data enquire method specific embodiment two of the present invention;
Embodiment
Ultimate principle of the present invention is to realize application program to other access of database by deposit the mode of pointing to other data of database pointers in database, and inquiry terminal only needs just can obtain the data that will inquire about to sending the data query request with its local data base that directly links to each other like this.Wherein said data pointer can but to be not limited to be URL, IP address, signalling coding or the like.
Referring to Fig. 2, it is the synoptic diagram of data query system specific embodiment one of the present invention, and this data query system comprises a plurality of databases 1, and each database 1 is connected with inquiry terminal 2, each inquiry terminal 2 all is connected with communication network 3 with database 1, wherein is provided with in described database 1:
Data memory module c is used for the data in store local data storehouse;
Data pointer memory module b is used for storage and points to other data of database pointers;
Query requests analysis module a, be connected with communication network 3 with described data memory module c, described data pointer memory module b, described inquiry terminal 1, be used to receive the data query request, obtain and point to strange land data of database pointer and to the portable terminal return data.For each inquiry terminal, with its database that directly links to each other is local data base, other databases are the strange land database, inquiry terminal can be by sending the data query request to local data base, get access to and point to strange land data of database pointer, resend the data query request by communication network then, obtain the data content that to inquire about, thereby realize the strange land data sharing.
Referring to Fig. 3, it is the synoptic diagram of data query system specific embodiment two of the present invention, and this data query system has been set up query requests forwarding module d in database on the system-based of embodiment one, be connected with described query requests analysis module a, be used to transmit the data query request.
In the present embodiment, the data that will inquire about when inquiry terminal are not in local data base the time, then from data pointer memory module b, obtain the pointer that points to the strange land database by the query requests analysis module a in the local data base, and send to query requests forwarding module d, by query requests forwarding module d to strange land database forwarding inquiries request.The data that inquire can directly return to inquiry terminal by communication network, also can return to the query requests analysis module of the local data base of described inquiry terminal correspondence by communication network, by this module data are returned to inquiry terminal.Whole process similarly is data query in local data base for inquiry terminal.
In the application of reality, for above-mentioned two embodiment, can be set to central database by one of them database, and be connected with a plurality of inquiry terminals, with often the visit deposit data in central database, in other databases, inquiry terminal just can get access to other data of database by send the data query request to central database with the data storage of visit seldom.
Referring to Fig. 4, it is the process flow diagram of the specific embodiment one of data enquire method of the present invention, comprises the steps:
The query requests analysis module analysis of step 101, described database is by data query request that locally-attached inquiry terminal sent, according to the data category information of carrying in this data query request, judge whether described data are stored in the local data base, if, execution in step 102, otherwise, execution in step 103;
Step 102, the data memory module from described local data base obtain this data, and send to described inquiry terminal, finish then;
Step 103, the described data category information of foundation are obtained from the data pointer memory module of described local data base and are pointed to strange land data of database pointer, and sends to inquiry terminal;
Step 104, described inquiry terminal resend described data query request according to described data pointer to described strange land database, obtain the data that will inquire about.
In described step 104, the concrete operations of obtaining the data that will inquire about are: the query requests analysis module of described strange land database is analyzed described query requests, from the data of database memory module of described strange land, obtain the data that to inquire about, and send to described inquiry terminal by communication network; Referring to Fig. 5, it is the process flow diagram of the specific embodiment two of data enquire method of the present invention, comprises the steps:
The query requests analysis module analysis of step 201, described database is by data query request that locally-attached inquiry terminal sent, according to the data category information of carrying in this data query request, judge whether described data are stored in the local data base, if, execution in step 202, otherwise, execution in step 203;
Step 202, the data memory module from described local data base obtain this data, and send to described inquiry terminal, finish then;
Step 203, the described data category information of foundation are obtained from the data pointer memory module of described local data base and are pointed to strange land data of database pointer, and sends to the query requests forwarding module;
Step 204, described query requests forwarding module resend described data query request according to described data pointer to described strange land database, obtain the data that will inquire about.
In described step 204, obtain the data that will inquire about concrete operations can for: the query requests analysis module of described strange land database is analyzed described query requests, from the data of database memory module of described strange land, obtain the data that to inquire about, and send to described inquiry terminal by communication network.
In described step 204, obtain the data that will inquire about concrete operations can also for: the query requests analysis module of described strange land database is analyzed described query requests, from the data of database memory module of described strange land, obtain the data that to inquire about, and sending to the query requests analysis module of the local data base that directly links to each other with described inquiry terminal by communication network, this query requests analysis module returns to described inquiry terminal with described data.
With a business data inquiry system is that example illustrates concrete application of the present invention, this business data inquiry system comprises human resource data storehouse, marketing database, financial database, pass through interconnection of telecommunication network between each database, and all have other data of database pointers of sensing in each database.The all corresponding application system of each database (corresponding to inquiry terminal of the present invention), and directly be connected local data base as this application system with this application system, other databases then are the strange land database.For example: for the human resources system, the human resource data storehouse is local data base, and marketing database, financial database are the strange land database, the human resources system can be the data query request of financial class by sending query categories to local data base, get access to the data pointer that points to financial database, resend the data query request by communication network to financial database then, obtain the data that to inquire about, thereby reach of the data sharing of the data of financial database the human resources system; The human resources system also can send the data query request that the data query classification is financial class to local data base, transmit this data query request by communication network to financial database by the human resource data storehouse, financial database inquires to put after the data and returns to the human resource data storehouse, returns to the human resources system by the human resource data storehouse; Financial database also can directly send the data to the human resources system by communication network after inquiring data.
By data-storage system of the present invention and data enquire method, for application system, only need access local database just can obtain the strange land data of database, and do not need to increase new equipment; During by data pointer inquiry strange land data of database just as the data in the inquiry local data base, do not need to revise querying condition, only need application program to resend query requests, and this process is fully transparent for the user according to the address that data pointer points to; When change takes place the strange land database, also only need to revise data pointer and get final product; Can dispose data sharing fast by the technical program, and can pass through to revise data pointer dynamic-configuration shared data bank, and not influence the operation of total system.
Technical solution of the present invention especially is fit to be applied in fields such as communication, large enterprise, public security, bank, educational system, medical system, for example in the medical system transfer the files in the strange land of user's case, public security system is to the investigation of strange land files on each of customers, in the communication system to inquiry of strange land user's communication inventory or the like.
It should be noted last that, above embodiment is only unrestricted in order to technical scheme of the present invention to be described, although the present invention is had been described in detail with reference to preferred embodiment, those of ordinary skill in the art is to be understood that, can make amendment or be equal to replacement technical scheme of the present invention, and not break away from the spirit and scope of technical solution of the present invention.
Claims (7)
1, a kind of data query system is characterized in that comprising a plurality of databases, and each database is connected with inquiry terminal, and each inquiry terminal and database all are connected with communication network; Be provided with in the described database:
Data memory module is used for the data in store local data storehouse; The data pointer memory module, be used for storage and point to strange land data of database pointer, and the query requests analysis module that is connected with communication network with described data memory module, data pointer memory module, inquiry terminal, this query requests analysis module is used to receive the data query request, obtains and points to strange land data of database pointer and return data.
2, data query system according to claim 1 is characterized in that also being provided with the query requests forwarding module in described database, be connected with described query requests analysis module, is used to transmit the data query request.
3, a kind of data enquire method based on the described data query system of claim 1 is characterized in that comprising the steps:
The query requests analysis module analysis of step 11, described database is by data query request that locally-attached inquiry terminal sent, according to the data category information of carrying in this data query request, judge whether described data are stored in the local data base, if, execution in step 12, otherwise, execution in step 13;
Step 12, the data memory module from described local data base obtain this data, and send to described inquiry terminal, finish then;
Step 13, the described data category information of foundation are obtained from the data pointer memory module of described local data base and are pointed to strange land data of database pointer, and sends to inquiry terminal;
Step 14, described inquiry terminal resend described data query request according to described data pointer to described strange land database, obtain the data that will inquire about.
4, data enquire method according to claim 3, it is characterized in that the concrete operations of obtaining the data that will inquire about in described step 14 are: the query requests analysis module of described strange land database is analyzed described query requests, from the data of database memory module of described strange land, obtain the data that to inquire about, and send to described inquiry terminal by communication network.
5, a kind of data enquire method of the data query system based on claim 2 is characterized in that comprising the steps:
The query requests analysis module analysis of step 21, described database is by data query request that locally-attached inquiry terminal sent, according to the data category information of carrying in this data query request, judge whether described data are stored in the local data base, if, execution in step 22, otherwise, execution in step 23;
Step 22, the data memory module from described local data base obtain this data, and send to described inquiry terminal, finish then;
Step 23, the described data category information of foundation are obtained from the data pointer memory module of described local data base and are pointed to strange land data of database pointer, and sends to the query requests forwarding module;
Step 24, described query requests forwarding module resend described data query request according to described data pointer to described strange land database, obtain the data that will inquire about.
6, data enquire method according to claim 5, it is characterized in that the concrete operations of obtaining the data that will inquire about in described step 24 are: the query requests analysis module of described strange land database is analyzed described query requests, from the data of database memory module of described strange land, obtain the data that to inquire about, and send to described inquiry terminal by communication network.
7, data enquire method according to claim 5, it is characterized in that the concrete operations of obtaining the data that will inquire about in described step 24 are: the query requests analysis module of described strange land database is analyzed described query requests, from the data of database memory module of described strange land, obtain the data that to inquire about, and sending to the query requests analysis module of the local data base that directly links to each other with described inquiry terminal by communication network, this query requests analysis module returns to described inquiry terminal with described data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2006100648452A CN100498780C (en) | 2006-03-14 | 2006-03-14 | Data inquire system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2006100648452A CN100498780C (en) | 2006-03-14 | 2006-03-14 | Data inquire system and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1858744A true CN1858744A (en) | 2006-11-08 |
| CN100498780C CN100498780C (en) | 2009-06-10 |
Family
ID=37297653
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB2006100648452A Expired - Fee Related CN100498780C (en) | 2006-03-14 | 2006-03-14 | Data inquire system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100498780C (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101872356A (en) * | 2010-05-31 | 2010-10-27 | 中兴通讯股份有限公司 | Method and system for improving processing performance of memory database |
| WO2014043921A1 (en) * | 2012-09-24 | 2014-03-27 | 东莞宇龙通信科技有限公司 | Terminal and contact lookup method |
| CN104537796A (en) * | 2014-12-17 | 2015-04-22 | 深圳市中科安防科技有限公司 | Alarm message processing system and method |
| CN105956210A (en) * | 2016-07-14 | 2016-09-21 | 上海超橙科技有限公司 | Data management method and equipment |
| CN106776820A (en) * | 2016-11-25 | 2017-05-31 | 中国银行股份有限公司 | Obtain method and system, block chain, the centralized system of different blocks chain data |
| CN106951452A (en) * | 2017-02-22 | 2017-07-14 | 中国建设银行股份有限公司 | The data query method and device reviewed for account |
| CN109831494A (en) * | 2019-01-21 | 2019-05-31 | 生迪智慧科技有限公司 | User data management and equipment |
-
2006
- 2006-03-14 CN CNB2006100648452A patent/CN100498780C/en not_active Expired - Fee Related
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101872356A (en) * | 2010-05-31 | 2010-10-27 | 中兴通讯股份有限公司 | Method and system for improving processing performance of memory database |
| CN101872356B (en) * | 2010-05-31 | 2013-08-07 | 中兴通讯股份有限公司 | Method and system for improving processing performance of memory database |
| WO2014043921A1 (en) * | 2012-09-24 | 2014-03-27 | 东莞宇龙通信科技有限公司 | Terminal and contact lookup method |
| CN104335671A (en) * | 2012-09-24 | 2015-02-04 | 东莞宇龙通信科技有限公司 | Terminal and contact lookup method |
| CN104537796A (en) * | 2014-12-17 | 2015-04-22 | 深圳市中科安防科技有限公司 | Alarm message processing system and method |
| CN105956210A (en) * | 2016-07-14 | 2016-09-21 | 上海超橙科技有限公司 | Data management method and equipment |
| CN106776820A (en) * | 2016-11-25 | 2017-05-31 | 中国银行股份有限公司 | Obtain method and system, block chain, the centralized system of different blocks chain data |
| CN106951452A (en) * | 2017-02-22 | 2017-07-14 | 中国建设银行股份有限公司 | The data query method and device reviewed for account |
| CN109831494A (en) * | 2019-01-21 | 2019-05-31 | 生迪智慧科技有限公司 | User data management and equipment |
| CN109831494B (en) * | 2019-01-21 | 2021-11-02 | 生迪智慧科技有限公司 | User data management method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN100498780C (en) | 2009-06-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111459985B (en) | Identification information processing method and device | |
| CN1858744A (en) | Data inquire system and method | |
| US20130191523A1 (en) | Real-time analytics for large data sets | |
| CN102043862B (en) | Directional web data extraction method | |
| CN1547719A (en) | System and method for identifying and generating business events | |
| CN1259704A (en) | Expandable/compressible type high speed register | |
| CN1947403A (en) | Event notification network | |
| CN1547720A (en) | System and method for generating and propagating business events | |
| CN103164507A (en) | Mixed join of row and column database tables in native orientation | |
| CN1949220A (en) | Structuring system and method of network community dynamic list | |
| CN105164674A (en) | Queries involving multiple databases and execution engines | |
| CN1258139C (en) | Method and system for incorporating legacy applications into a distributed data processing environment | |
| CN101079763A (en) | A remote configuration and management system and method of servers | |
| CN1900967A (en) | Logistics bidding system and method for internet electronic business | |
| CN1959676A (en) | Apparatus and method for materialized query table journaling in a computer database system | |
| CN101046806A (en) | Search engine system and method | |
| CN1859505A (en) | Bill checking system and method | |
| CN1924851A (en) | Data storage method and data storage structure | |
| CN1717686A (en) | Automatic data consolidation | |
| CN1363886A (en) | Target integrated management system | |
| CN1635494A (en) | Method for implementing class memory database access and retrieval | |
| CN1913492A (en) | Data exchange device, system and method | |
| CN1924915A (en) | Database technique based library intelligent management system | |
| CN1275137C (en) | Mass data processing method and system | |
| CN1877581A (en) | Advertisement display system and method used for Internet search engine |
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 | ||
| C17 | Cessation of patent right | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20090610 Termination date: 20130314 |