CN103078918B - A kind of system for realizing data query - Google Patents
A kind of system for realizing data query Download PDFInfo
- Publication number
- CN103078918B CN103078918B CN201210584067.5A CN201210584067A CN103078918B CN 103078918 B CN103078918 B CN 103078918B CN 201210584067 A CN201210584067 A CN 201210584067A CN 103078918 B CN103078918 B CN 103078918B
- Authority
- CN
- China
- Prior art keywords
- inquiry request
- mobile terminal
- data
- packet
- fabric interface
- 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.)
- Active
Links
Landscapes
- Mobile Radio Communication Systems (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention discloses a kind of system for realizing data query, the server end comprising several mobile terminal and be connected by mobile network with mobile terminal, server end has Fabric Interface, data processor, content server and database; Mobile terminal, for sending the first packet to server end; Fabric Interface, is connected to data processor, analyzes the first packet to obtain positional information, and/or inquiry request, and/or data message, and above-mentioned information is sent to data processor; Data processor is connected to Fabric Interface, content server and database, when receiving positional information, positional information is sent to content server; When receiving inquiry request, according to inquiry request, computing obtains Query Result, and Query Result is sent to Fabric Interface; When receiving data message, data message is sent to database; Fabric Interface, sends to corresponding mobile terminal by Query Result; Mobile terminal can obtain and show Query Result.
Description
Technical field
The present invention relates to mobile communication and internet arena, particularly a kind of system for realizing data query.
Background technology
Along with the sale shops of present enterprise is increasing, the operator of each shops needs to contact in real time with headquarters server, to carry out the operation such as data upload and data query.The existing system for data query is based on cable network, uses conventional PC to carry out framework as application end, and the terminal by the PC of application end data being read on-line shop from the server of general headquarters analyzes data for user.There are four defects in it, is first that mobility is inadequate; Secondly, in existing scheme, server cannot obtain positional information and the Weather information of shops automatically; 3rd, the operator of a lot of shops can not use computer, just more need not talk data analysis; 4th, each shops application end need more new data time, will read a large amount of data from server, resource overhead is large.
Along with the development of 3G development of Mobile Internet technology and the universal of intelligent mobile phone terminal, the operator of shops has a smart mobile phone mostly, and very expertly can operate them, therefore can develop shops's data analysis system on mobile terminal of mobile telephone.But problem is, the excavation of data and the analysis of data need larger operand, and the computing capability of mobile terminal is also not enough to support fairly large data processing, is not suitable for directly carrying out the excavation of data and the analysis of data at mobile terminal; During from server update data, wireless signals speed is not enough; The positioning function of smart mobile phone, is not effectively utilized.
Summary of the invention
The invention provides a kind of system for realizing data query, realizing carrying out in real time the effect of data query to reach based on cordless communication network.For achieving the above object, the present invention adopts following technical scheme:
The invention discloses a kind of system for realizing data query, the server end that this system is comprised several mobile terminal and is connected by mobile network with mobile terminal, this server end has Fabric Interface, data processor, content server and database; Described mobile terminal, for sending the first packet to server end, this first packet comprises the positional information of this mobile terminal self, and/or inquiry request, and/or data message; This Fabric Interface, is connected to this data processor, for receiving the first packet, analyzes the first packet to obtain positional information, and/or inquiry request, and/or data message, and the information of acquisition is sent to this data processor; This data processor, is connected to this Fabric Interface, this content server and this database, when receiving positional information, for the positional information received is sent to this content server; When receiving inquiry request, according to the inquiry request received, computing obtains Query Result, Query Result is sent to this Fabric Interface; When receiving data message, data message is sent to this database; This content server, for preserving the positional information of described mobile terminal; This database, for preserving data message; This Fabric Interface, to be further used for Query Result with the form of the second packet, sends to corresponding mobile terminal; Described mobile terminal, is further used for the second packet that reception server end returns, and obtains and display Query Result.
Wherein, described mobile terminal, comprises position acquisition module, signal dispatcher module, processing module and display module, and this position acquisition module is for obtaining positional information; This processing module is connected to this position acquisition module and this signal dispatcher module, for generating the first packet and analyzing the second packet; This signal dispatcher module is used for sending the first packet to this Fabric Interface and being received from the second packet of this Fabric Interface transmission; This display module, is connected to this processing module, for showing Query Result.
Wherein, this position acquisition module is GPS locating module, and this positional information is GPS locating information.
Wherein, this processing module and display module, adopt the APP application architecture based on Android, supports that user is to use the mode data query of application program.
Wherein, described inquiry request comprises data inquiry request and/or place information inquiry request; When described inquiry request is data inquiry request, this data processor is according to the inquiry request received, read the data message among this database, and to the operation that the data read extract, clean, change and load, according to the statement analysis rule preset to data processing, result is sent to this Fabric Interface; When described inquiry request is place information inquiry request, this data processor is according to the inquiry request received, the positional information of described mobile terminal is read from this content server, distance between selection and the mobile terminal sending this inquiry request is less than the positional information of the mobile terminal of predetermined threshold value, and the positional information of reading is sent to this Fabric Interface.
Wherein, the server end of this system, comprises further: Weather information acquiring unit, is connected to this content server, and according to the positional information of described mobile terminal, interconnection network corresponds to the Weather information of described mobile terminal locations to obtain; This content server, is further used for preserving described Weather information.
Wherein, described inquiry request comprises data inquiry request, and/or place information inquiry request, and/or Weather information inquiry request; When described inquiry request is data inquiry request, this data processor is according to the inquiry request received, read the data message among this database, and to the operation that the data read extract, clean, change and load, according to the statement analysis rule preset to data processing, result is sent to this Fabric Interface; When described inquiry request is place information inquiry request, this data processor is according to the inquiry request received, the positional information of described mobile terminal is read from this content server, distance between selection and the mobile terminal sending this inquiry request is less than the positional information of the mobile terminal of predetermined threshold value, and the positional information of reading is sent to this Fabric Interface; When described inquiry request is Weather information inquiry request, this data processor, according to the inquiry request received, reads described Weather information from this content server, and the Weather information of reading is sent to this Fabric Interface.
Wherein, described first packet and the second packet are the packet after compress-encrypt.
Wherein, this Fabric Interface is WebService service end interface; This data processor is SAS data mining analysis engine; This database and this content server, be SQLServer database.
The beneficial effect of the embodiment of the present invention is: mobile terminal carries out data interaction by mobile network and Fabric Interface, by gathering the positional information of each mobile terminal, and can so that obtaining information; By uploading data information, positional information rapidly, send inquiry request, server end, according to inquiry request, obtains Query Result, therefore can complete a large amount of data operations by server end, reduces the operand of data traffic and mobile terminal.
Accompanying drawing explanation
The block diagram of a kind of system for realizing data query that Fig. 1 provides for present pre-ferred embodiments;
The detailed block diagram of the mobile terminal that Fig. 2 provides for present pre-ferred embodiments.
Embodiment
For making the object, technical solutions and advantages of the present invention clearly, below in conjunction with accompanying drawing, embodiment of the present invention is described in further detail.
The block diagram of a kind of system for realizing data query that Fig. 1 provides for present pre-ferred embodiments.This system comprises among several mobile terminal 100(Fig. 1 for two) and the server end 200 that is connected by mobile network with mobile terminal 100, this server end has Fabric Interface 210, data processor 220, content server 230 and database 240.
Described mobile terminal 100, for sending the first packet to server end 200, this first packet comprises the positional information of this mobile terminal self, and/or inquiry request, and/or data message.Specifically, first packet can comprise data message, the data message that such as user is sent by mobile terminal 100, processes for server end 200, such as shops manager uses mobile terminal 100 that condition of sales is sent to server end 200, can the data of update server end in real time.
This Fabric Interface 210, is connected to this data processor 220, for the first packet that mobile terminal receive 100 sends, analyze the first packet to obtain positional information, and/or inquiry request, and/or data message, and the above-mentioned information obtained is sent to this data processor 220.Specifically, this Fabric Interface 210 can be analyzed the first packet thus obtain the positional information of mobile terminal transmission, and/or inquiry request, and/or data message, and sends to data processor 220.
This data processor 220, is connected to this Fabric Interface 210, this content server 230 and this database 240, when receiving positional information, for the positional information received is sent to this content server 230; When receiving inquiry request, according to the inquiry request received, computing obtains Query Result, Query Result is sent to this Fabric Interface 210; When receiving data message, data message is sent to this database 240.Specifically, data processor 220 processes operation accordingly according to the information received, such as, preserve data or process inquiry request.
This content server 230, preserves the positional information of described mobile terminal 100.The positional information of mobile terminal 100 can be the GPS locating information using GPS locating module to obtain.
This database 240, for preserving data message, such as, can preserve product sale information, inquiring about sales information for shops manager.
This Fabric Interface 210, to be further used for Query Result with the form of the second packet, sends to corresponding mobile terminal 100.Fabric Interface 200, sends to mobile terminal by Query Result.Among the present embodiment, the instruction transformation of mobile terminal 100 is the discernible order of data processor 220 by Fabric Interface 210, after inquiry, then converts data to the discernible data of mobile terminal 100, shows for mobile terminal 100.
Described mobile terminal 100, is further used for the second packet that reception server end 200 returns, and obtains and display Query Result.
The detailed block diagram of the mobile terminal that Fig. 2 provides for present pre-ferred embodiments.Described mobile terminal 100, comprises position acquisition module 110, signal dispatcher module 120, processing module 130 and display module 140.Wherein, this position acquisition module 110 is for obtaining positional information; This processing module 130 is connected to this position acquisition module 110 and this signal dispatcher module 120, for generating the first packet and analyzing the second packet; This signal dispatcher module 120 is for sending the first packet to this Fabric Interface 210 and being received from the second packet of this Fabric Interface 210 transmission; This display module 140, is connected to this processing module 130, for showing Query Result.
Position acquisition module 110 is GPS locating module, and the positional information of acquisition is GPS locating information.Processing module 130 and display module 140, can be developed by JAVA language, adopts the APP application architecture based on Android, and support that user is to use the mode of application program but not to pass through browser data query, more convenient operation, system is safer, stable and efficient.
Among the present embodiment, the inquiry request that mobile terminal 100 sends comprises data inquiry request, and/or place information inquiry request.
When described inquiry request is data inquiry request, the data processor 220 of server end 200 is according to the inquiry request received, read the data message among this database 240, and to the operation that the data read extract, clean, change and load, according to the statement analysis rule preset to data processing, result is sent to this Fabric Interface 210, and then by Fabric Interface 210, result is sent to the mobile terminal 100 sending inquiry request.In the present embodiment, the statement analysis rule that data processor 220 adopts is identical with the form rule preset among the processing module 130 of mobile terminal 100, by adopting default statement analysis rule, the computational complexity that mobile terminal 100 carries out data processing can be reduced.
When described inquiry request is place information inquiry request, this data processor 220 is according to the inquiry request received, the positional information of described mobile terminal 100 is read from this content server 230, distance between selection and the mobile terminal 100 sending this inquiry request is less than the positional information of the mobile terminal 100 of predetermined threshold value, and the positional information of reading is sent to this Fabric Interface 210, and then by Fabric Interface 210, result is sent to the mobile terminal 100 sending inquiry request.In the present embodiment, data processor 220, can calculate the position of the mobile terminal 100 sending inquiry request, the positional information of contiguous mobile terminal 100 is sent to the mobile terminal 100 sending inquiry request.Certainly, also can to each mobile terminal 100 default access, the authority according to arranging chooses the positional information sending to this mobile terminal 100, is not limited with disclosing of the present embodiment.
Further, server end 200 comprises Weather information acquiring unit 250, this Weather information acquiring unit 250 is connected to this content server 230, and according to the positional information of described mobile terminal, interconnection network corresponds to the Weather information of described mobile terminal 100 position to obtain.In the present embodiment, Weather information acquiring unit 250, can connect Meteorological Services platform by network, by sending positional information to Meteorological Services platform to obtain should the Weather information of position, and Weather information is sent to this content server 230.This content server 230, can preserve described Weather information simultaneously.
In the present embodiment, inquiry request comprises data inquiry request, and/or place information inquiry request, and/or Weather information inquiry request.When inquiry request is Weather information inquiry request, this data processor 220, according to the inquiry request received, reads Weather information from this content server 230, and the Weather information of reading is sent to this Fabric Interface 210.In the present embodiment, the Weather information that this data processor 230 reads is the Weather information corresponding with mobile terminal 100 position sending this inquiry request, also can comprise the Weather information of close position further, not be limited with disclosing of the present embodiment.
Described first packet and the second packet are the packet after compress-encrypt.The fail safe of data can be guaranteed like this, reduce the requirement to bandwidth.
In the present embodiment, Fabric Interface 210 is WebService service end interface, adopts MicrosoftC#.NET language development, plays the effect of the interface of exchanges data between mobile terminal 100 and data processor.Data processor 220 is SAS data mining analysis engine, the inquiry request that handle mobile terminal 100 sends; Database 240 and content server 230, be SQLServer database, for preserving data message, positional information and Weather information, wherein, content server 230, the data volume stored is little, and read-write operation frequency is higher, therefore memory space can be used relatively little, the memory that read-write operation speed is higher; Meanwhile, by data information memory in database 220, positional information and Weather information are stored in content server 230, the storage security of data message can be promoted.
In addition, content server 230, cartographic information can also be stored, when described inquiry request is place information inquiry request, this data processor 220 is according to the inquiry request received, also select from this content server 230 cartographic information closing on mobile terminal 100 position sending this inquiry request, and cartographic information is sent to this Fabric Interface 210, and then by Fabric Interface 210, cartographic information is sent to the mobile terminal 100 sending inquiry request.
Certainly, also can preserve cartographic information by described mobile terminal 100, when needs display map and position, read corresponding cartographic information according to positional information.
Therefore, from the above mentioned, shops manager uses the present embodiment disclosed for realizing the system of data query, the GPS locating information that mobile terminal can be utilized the GPS locating module of self to obtain sends to server end, mobile network can be used to send inquiry request to server end simultaneously, obtain data message or positional information, Weather information etc., thus obtain data easily, understand the position residing for shops, commercial circle, Weather information, contiguous mobile terminal etc.
Embodiments of the invention have following advantage:
(1) mobile terminal is by mobile network but not cable network and Fabric Interface carry out data interaction, can so that obtaining information;
(2) pass through uploading data information, positional information rapidly, send inquiry request, server end, according to inquiry request, obtains Query Result, can complete a large amount of data operations by server end, reduces the operand of data traffic and mobile terminal;
(3) obtain GPS locating information by the GPS locating module of mobile terminal, the positional information of mobile terminal can be gathered by server end; Each mobile terminal, can obtain the positional information of all the other mobile terminals, makes location more convenient;
(4) can positional information be passed through, obtain Weather information very quickly.
The above; be only the specific embodiment of the present invention, but protection scope of the present invention is not limited thereto, is anyly familiar with those skilled in the art in the technical scope that the present invention discloses; the change that can expect easily or replacement, all should be encompassed within protection scope of the present invention.Therefore, protection scope of the present invention should be as the criterion with the protection range of claim.
Claims (8)
1. for realizing a system for data query, it is characterized in that, the server end that this system is comprised several mobile terminal and is connected by mobile network with mobile terminal, this server end has Fabric Interface, data processor, content server and database;
Described mobile terminal, for sending the first packet to server end, this first packet comprises the positional information of this mobile terminal self, and/or inquiry request, and/or data message;
This Fabric Interface, is connected to this data processor, for receiving the first packet, analyzes the first packet to obtain positional information, and/or inquiry request, and/or data message, and the above-mentioned information obtained is sent to this data processor;
This data processor, is connected to this Fabric Interface, this content server and this database, when receiving positional information, for the positional information received is sent to this content server; When receiving inquiry request, according to the inquiry request received, computing obtains Query Result, Query Result is sent to this Fabric Interface; When receiving data message, data message is sent to this database;
This content server, for preserving the positional information of described mobile terminal; This database, for preserving data message; This Fabric Interface, is further used for Query Result to send to corresponding mobile terminal with the form of the second packet; Described mobile terminal, is further used for the second packet that reception server end returns, and obtains and display Query Result;
Described inquiry request comprises data inquiry request, and/or place information inquiry request;
When described inquiry request is data inquiry request, this data processor is according to the inquiry request received, read the data message among this database, and to the operation that the data read extract, clean, change and load, according to the statement analysis rule preset to data processing, result is sent to this Fabric Interface;
When described inquiry request is place information inquiry request, this data processor is according to the inquiry request received, the positional information of described mobile terminal is read from this content server, distance between selection and the mobile terminal sending this inquiry request is less than the positional information of the mobile terminal of predetermined threshold value, and the positional information of reading is sent to this Fabric Interface.
2. system according to claim 1, is characterized in that,
Described mobile terminal, comprises position acquisition module, signal dispatcher module, processing module and display module,
This position acquisition module is for obtaining positional information;
This processing module is connected to this position acquisition module and this signal dispatcher module, for generating the first packet and analyzing the second packet;
This signal dispatcher module is used for sending the first packet to this Fabric Interface and being received from the second packet of this Fabric Interface transmission;
This display module, is connected to this processing module, for showing Query Result.
3. system according to claim 2, is characterized in that,
This position acquisition module is GPS locating module, and this positional information is GPS locating information.
4. system according to claim 2, is characterized in that,
This processing module and display module, adopt the APP application architecture based on Android, supports that user is to use the mode data query of application program.
5. system according to claim 1 and 2, is characterized in that,
The server end of this system, comprises further: Weather information acquiring unit, is connected to this content server, and according to the positional information of described mobile terminal, interconnection network corresponds to the Weather information of described mobile terminal locations to obtain;
This content server, is further used for preserving described Weather information.
6. system according to claim 5, is characterized in that,
Described inquiry request comprises Weather information inquiry request;
When described inquiry request is Weather information inquiry request, this data processor, according to the inquiry request received, reads Weather information from this content server, and the Weather information of reading is sent to this Fabric Interface.
7. system according to claim 1 and 2, is characterized in that,
Described first packet and the second packet are the packet after compress-encrypt.
8. system according to claim 1 and 2, is characterized in that,
This Fabric Interface is WebService service end interface;
This data processor is SAS data mining analysis engine;
This database and this content server, be SQLServer database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210584067.5A CN103078918B (en) | 2012-12-27 | 2012-12-27 | A kind of system for realizing data query |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210584067.5A CN103078918B (en) | 2012-12-27 | 2012-12-27 | A kind of system for realizing data query |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103078918A CN103078918A (en) | 2013-05-01 |
| CN103078918B true CN103078918B (en) | 2015-12-02 |
Family
ID=48155320
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210584067.5A Active CN103078918B (en) | 2012-12-27 | 2012-12-27 | A kind of system for realizing data query |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103078918B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106841044B (en) * | 2015-12-07 | 2020-04-14 | 北京奇虎科技有限公司 | Stain recognition method and device |
| CN113223223A (en) * | 2021-04-27 | 2021-08-06 | 上海创米科技有限公司 | Position information acquisition system and position information acquisition method |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101969599A (en) * | 2010-10-22 | 2011-02-09 | 厦门雅迅网络股份有限公司 | Geographical position based system and implementation method thereof for acquiring weather forecast |
| CN102034156A (en) * | 2010-12-20 | 2011-04-27 | 北京兴远达科技有限公司 | Cargo allocation method for implementing logistic transportation by utilizing GPS positioning |
| CN102546656A (en) * | 2012-02-10 | 2012-07-04 | 腾讯科技（深圳）有限公司 | Method, system and device for finding user in social network |
-
2012
- 2012-12-27 CN CN201210584067.5A patent/CN103078918B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101969599A (en) * | 2010-10-22 | 2011-02-09 | 厦门雅迅网络股份有限公司 | Geographical position based system and implementation method thereof for acquiring weather forecast |
| CN102034156A (en) * | 2010-12-20 | 2011-04-27 | 北京兴远达科技有限公司 | Cargo allocation method for implementing logistic transportation by utilizing GPS positioning |
| CN102546656A (en) * | 2012-02-10 | 2012-07-04 | 腾讯科技（深圳）有限公司 | Method, system and device for finding user in social network |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103078918A (en) | 2013-05-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP6014173B2 (en) | Method, system, and terminal for performing Wi-Fi connection by NFC | |
| CN103246529B (en) | Update and push the method, apparatus and system of navigation bar | |
| CN101583075A (en) | System and method for positioning and inquiring wireless mobile terminal | |
| CN103366196B (en) | Two-dimensional bar code connecting method | |
| CN102682134A (en) | Intelligent bookshelf based on radio frequency identification technology and working method thereof | |
| CN104424241B (en) | Web site url processing method based on two dimensional code, apparatus and system | |
| CN104881612A (en) | Data deleting method and apparatus | |
| CN103559009A (en) | Geographic information terminal and geographic information presentation method | |
| CN105430747A (en) | Communication method, device and system | |
| CN103517405A (en) | Network positioning method and system, mobile terminal and network-side apparatus | |
| CN107567071B (en) | Method and equipment for inquiring wireless hotspot | |
| CN110493770A (en) | Obtain method, card pool equipment and the cloud server with management cloud SIM card data | |
| CN103078918B (en) | A kind of system for realizing data query | |
| CN107949019B (en) | Load balancing method of wireless access point | |
| CN213092318U (en) | Sweep a yard device | |
| CN105515892A (en) | Mobile terminal data sending monitoring device and application method thereof | |
| CN107889191B (en) | Connection method, device and equipment of wireless local area network and computer readable storage medium | |
| CN103412759A (en) | Production data recovery method and terminal | |
| CN108282736B (en) | Networking method and device of intelligent terminal | |
| CN104410951A (en) | Intelligent terminal tracking locating method and intelligent terminal | |
| CN106910077B (en) | Target object information query method and device | |
| CN103220624A (en) | Updating method for mobile terminal system and device thereof | |
| CN104254051A (en) | Device, method and system for automatic testing of indoor wireless signals | |
| CN102761613A (en) | Mobile terminal and device information obtaining method and system thereof as well as server | |
| CN108984221B (en) | Method and device for acquiring multi-platform user behavior logs |
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 | ||
| CP01 | Change in the name or title of a patent holder |
Address after: Yongjia Oubei County of Wenzhou City, Zhejiang province 325105 Angelo Industrial Park Patentee after: Angelo Cmi Holdings Ltd Address before: Yongjia Oubei County of Wenzhou City, Zhejiang province 325105 Angelo Industrial Park Patentee before: Zhejiang Baoxiniao Garment Co., Ltd. |
|
| CP01 | Change in the name or title of a patent holder |