CN104965868B - Data query analysis system and method based on wechat public platform - Google Patents
Data query analysis system and method based on wechat public platform Download PDFInfo
- Publication number
- CN104965868B CN104965868B CN201510311556.7A CN201510311556A CN104965868B CN 104965868 B CN104965868 B CN 104965868B CN 201510311556 A CN201510311556 A CN 201510311556A CN 104965868 B CN104965868 B CN 104965868B
- Authority
- CN
- China
- Prior art keywords
- data
- user
- unit
- content
- query
- 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
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/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/958—Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/9038—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
Abstract
The invention discloses a kind of data query analysis system based on wechat public platform, including：Data synchronisation unit, the synchronous update operation for obtaining operation system；Data capture unit, decryption obtain data；Identification authenticating unit reads configuration documentation and completes authentication；Query unit, user can carry out data information inquiry by keyword；Transmitting element, query result data are sent to user terminal by processing；Show unit, caller interface, establishment shows the page；Feedback unit carries out system for content feedback to user.Above-mentioned technical proposal proposed by the present invention is based on wechat public platform, realize that real-time, the diversity of mobile end data show, user can inquire data for keyword, information is obtained in time and grasps analysis, it guarantees data security again simultaneously, data leak is prevented, enhances user experience, improves user job efficiency.
Description
Technical field
The invention belongs to field of communication technology, applied to mobile clients such as smart mobile phone, tablet computers, and in particular to one
Data query analysis system and method for the kind based on wechat public platform.
Background technology
It is the mobile application entrance that enterprise customer provides that wechat public platform enterprise number, which is wechat,.For business intelligence
(BI), decision system (DSS) this intermediate item, the data query analysis under present mode are generally based on PC ends and carry out showing analysis
Service, and nowadays mobile client apply more extensive period, PC ends can not fully meet information instantaneity and
The demand of portability, wechat public platform is also more single to user's pushed information, and user can not pass through inquiry
Obtain the real time information of enterprise.How to solve on existing business intelligence (BI) data application platform base, realize mobile terminal
Real-time, the diversity of data show, and obtain information in time and grasp analysis, while guarantee data security again, prevent data leak,
Improve user experience, be presently, there are the problem of.
Invention content
To solve the above-mentioned problems, a kind of data query analysis system based on wechat public platform is disclosed, including：
Data synchronisation unit, Data Warehouse for Enterprises application platform carry out service logic processing to data, pass through third number formulary
It is read out according to extraction tool for database manipulation daily record, after operation system updates the data, synchronous acquisition operation system
Update operation；
Data capture unit, data warehouse applications platform uses ESB channel encryption transmission datas, by calling web services
Interface, decryption obtain data；
Identification authenticating unit, wechat server setting open call back scheme, insert URL addresses, Token and
EncodingAESkey, after sending authentication request, wechat server, which performs, to be returned in ciphertext to the URL being configured, decryption
The character string of return reads configuration documentation and completes authentication；
Query unit, by rear, user can carry out data information inquiry by keyword for authentication；
Transmitting element, query result data are then forwarded to user terminal, type by message splicing, json conversion process
Including pure words form, picture and text message, news forms, speech message；
Show unit, caller interface, establishment shows the page, and content of pages includes word, two-dimensional table and chart, leads to
Configuration documentation generation content of pages is crossed, word and chart Show Styles user can select；
Feedback unit, establishes associated databases, realizes that user accesses robot, according to the question information that user sends, into
Row screening judges, system for content feedback is carried out to user.
The invention also discloses a kind of data query analysis methods based on wechat public platform, include the following steps：
S11, Data Warehouse for Enterprises application platform carry out service logic processing to data, pass through third party's data extraction tool
It is read out for database manipulation daily record, after operation system updates the data, the synchronous update operation for obtaining operation system；
S12, data warehouse applications platform use ESB channel encryption transmission datas, by calling web service interface, decrypt
Obtain data；
S13, wechat server setting open call back scheme, insert URL addresses, Token and EncodingAESkey, send
After authentication request, wechat server, which performs, to be returned in ciphertext to the URL being configured, and decrypts the character string of return, reading is matched
It puts document and completes authentication；
S14, by rear, user can carry out data information inquiry by keyword for authentication；
S15, query result data are then forwarded to user terminal, type includes pure by message splicing, json conversion process
Text formatting, picture and text message, news forms, speech message；
S16, caller interface, establishment show the page, and content of pages includes word, two-dimensional table and chart, by matching
Document structure tree content of pages is put, word and chart Show Styles user can select；
S17 establishes associated databases, realizes that user accesses robot, according to the question information that user sends, is screened
Judge, system for content feedback is carried out to user.
Above-mentioned technical proposal proposed by the present invention realizes the real-time, more of mobile end data based on wechat public platform
Sample shows, and user can inquire data for keyword, obtains information in time and grasps analysis, while ensure data again
Safety prevents data leak, enhances user experience, improves user job efficiency.
Description of the drawings
Fig. 1 is a kind of data query analysis system structure chart based on wechat public platform of the present invention
Fig. 2 is a kind of data query analysis method flow chart based on wechat public platform of the present invention
Specific embodiment
Referring to Fig. 1, a kind of data query analysis system based on wechat public platform, including：
Data synchronisation unit 21, Data Warehouse for Enterprises application platform carry out service logic processing to data, pass through third party
Data extraction tool is read out for database manipulation daily record, and after operation system updates the data, query analysis system is in milli
Second grade synchronizes the update operation for getting operation system；
Data capture unit 22, query analysis system obtain enterprise's latest data using web services, and data warehouse applications are put down
Platform uses ESB channel encryption transmission datas, and by calling web service interface, decryption obtains data；
Identification authenticating unit 23, wechat server setting open call back scheme, insert URL addresses, Token and
EncodingAESkey, after sending authentication request, wechat server, which performs, to be returned in ciphertext to the URL being configured, decryption
The character string of return reads configuration documentation and completes authentication；
Query unit 24, by rear, user can carry out data information inquiry by keyword for authentication；
Transmitting element 25, query result data are then forwarded to user terminal, class by message splicing, json conversion process
Type includes pure words form, picture and text message, news forms, speech message；
Show unit 26, caller interface, establishment shows the page, adds event, and content of pages includes word, bivariate table
Lattice and chart generate content of pages, word and chart Show Styles user it can be selected that user's access also may be used by configuration documentation
Different jump page are shown according to permission；
Chart use Javascript charts library, wherein, subtype can unrestricted choice switching, if pie chart is between column figure
Switching, switches, pictorial statement mode includes, map, radar map, block diagram, line chart, scatter plot, K between column figure and line chart
Line chart, pie chart, chord figure, power lead figure, instrument board, crater blasting, isolated island figure, thermodynamic chart etc., and chart components include reference axis, net
Lattice, polar coordinates, title, prompting, legend, data area scaling, codomain roaming, tool box, time shaft etc., word report character font
It automatically adjusts according to mobile client different screen, two-dimensional table content arbitrarily expands and reduces according to user's operation.
Feedback unit 27, establishes associated databases, realizes that user accesses robot, according to the question information that user sends,
Screening judgement is carried out, system for content feedback is carried out to user.
Referring to Fig. 2, a kind of data query analysis method flow chart based on wechat public platform includes the following steps：
S11, Data Warehouse for Enterprises application platform carry out service logic processing to data, pass through third party's data extraction tool
It is read out for database manipulation daily record, after operation system updates the data, the synchronous update operation for obtaining operation system；
S12, data warehouse applications platform use ESB channel encryption transmission datas, by calling web service interface, decrypt
Obtain data；
S13, wechat server setting open call back scheme, insert URL addresses, Token and EncodingAESkey, send
After authentication request, wechat server, which performs, to be returned in ciphertext to the URL being configured, and decrypts the character string of return, reading is matched
It puts document and completes authentication；
S14, by rear, user can carry out data information inquiry by keyword for authentication；
S15, query result data are then forwarded to user terminal, type includes pure by message splicing, json conversion process
Text formatting, picture and text message, news forms, speech message；
S16, caller interface, establishment show the page, and content of pages includes word, two-dimensional table and chart, by matching
Document structure tree content of pages is put, word and chart Show Styles user can select；
S17 establishes associated databases, realizes that user accesses robot, according to the question information that user sends, is screened
Judge, system for content feedback is carried out to user.
After mobile client subscribes to enterprise number, you can obtain query-relevant data content, user's mobile client is included not
It is limited to IOS systems, android, linux, unix systems.The present invention is suitable for wechat enterprise number, and access personnel are only limitted to enterprise
Address list institute accredited personnel, and the application need to be to the user as it can be seen that can just subscribe to access." query analysis system of the present invention
System " is by the way that external interface is called to carry out message transfer by wechat server, it is necessary to which application, which possesses enterprise number, can just be opened
Hair uses.The present invention uses development language as java language, and version used is jdk1.6, and war forms are packaged after the completion of system,
The web servers such as tomcat, websphere can be deployed in.
The application of the method wechat client query analysis system of this implementation, based on the mobile client of usable wechat,
Such as mobile phone, tablet computer.The use using deployment and client is specifically described below.
A, using deployment
This application is deployed on the windows servers with public network IP, uses third party's web server, dispositions method
With reference to web server official explanation.After deployment, modification enterprise number user information, public network IP address, PUSH message frequency
The basic informations such as rate, the time of PUSH message, basic information are stored in the attribute configuration file of properties forms, file
Under web-inf/classes catalogues.After deployment configuration, start web server, user can subscribe to access.
B, client uses
The method and system of the present invention, is only applicable to the mobile equipment for possessing wechat client.User obtain public platform into
Row concern, after paying close attention to successfully, you can receive feedback message.According to configuration informations such as the PUSH message temporal frequencies being configured before,
User can obtain latest news in specific time.User can send to server according to keyword and ask, and obtain newest number
It is believed that breath.It returns to message content and includes word report manner, two-dimensional table mode, graph mode.Word report adaptive can be applied
Family screen carries out font adjusting, and two-dimensional table user can arbitrarily expand diminution and show content, and graph mode is realized according to content
Diversification displaying, subtype, user can be converted accordingly.User can carry out system to put question to and answer questions, system machine
People's automatic screening replys user.
Above-mentioned technical proposal proposed by the present invention realizes the real-time, more of mobile end data based on wechat public platform
Sample shows, and user can inquire data for keyword, obtains information in time and grasps analysis, while ensure data again
Safety prevents data leak, enhances user experience, improves user job efficiency.
Those skilled in the art of the present technique are appreciated that technical term used herein, suitable for the one of those of ordinary skill
As understanding.Also it should be noted that used term is understood that is consistent in the meaning in the context of the prior art.
Obviously, the above embodiments are merely examples for clarifying the description, and is not intended to limit the embodiments.It is right
For those of ordinary skill in the art, can also make on the basis of the above description it is other it is various forms of variation or
It changes.There is no necessity and possibility to exhaust all the enbodiments.And the obvious variation thus extended out or
Among changing still in the protection domain of the invention.
Claims (2)
1. a kind of data query analysis system based on wechat public platform, which is characterized in that including：
Data synchronisation unit (21), Data Warehouse for Enterprises application platform carry out service logic processing to data, pass through third number formulary
It is read out according to extraction tool for database manipulation daily record, after operation system updates the data, synchronous acquisition operation system
Update operation；
Data capture unit (22), data warehouse applications platform uses ESB channel encryption transmission datas, by calling web services
Interface, decryption obtain data；
Identification authenticating unit (23), wechat server setting open call back scheme, insert URL addresses, Token and
EncodingAESkey, after sending authentication request, wechat server, which performs, to be returned in ciphertext to the URL being configured, decryption
The character string of return reads configuration documentation and completes authentication；
Query unit (24), by rear, user carries out data information inquiry by keyword for authentication；
Transmitting element (25), query result data are then forwarded to user terminal, type by message splicing, json conversion process
Including pure words form, picture and text message, news forms, speech message；
Show unit (26), caller interface, establishment shows the page, and content of pages includes word, two-dimensional table and chart, leads to
Configuration documentation generation content of pages is crossed, word and chart Show Styles are selected by user；
Feedback unit (27), establishes associated databases, realizes that user accesses robot, according to the question information that user sends, into
Row screening judges, system for content feedback is carried out to user.
2. a kind of data query analysis method based on wechat public platform, which is characterized in that include the following steps：
S11, Data Warehouse for Enterprises application platform carry out service logic processing to data, are directed to by third party's data extraction tool
Database manipulation daily record is read out, after operation system updates the data, the synchronous update operation for obtaining operation system；
S12, data warehouse applications platform use ESB channel encryption transmission datas, and by calling web service interface, decryption obtains
Data；
S13, wechat server setting open call back scheme, insert URL addresses, Token and EncodingAESkey, send identity
After checking request, wechat server, which performs, to be returned in ciphertext to the URL being configured, and decrypts the character string of return, reads configuration text
Shelves complete authentication；
S14, by rear, user carries out data information inquiry by keyword for authentication；
S15, query result data are then forwarded to user terminal, type includes pure words by message splicing, json conversion process
Form, picture and text message, news forms, speech message；
S16, caller interface, establishment show the page, and content of pages includes word, two-dimensional table and chart, by the way that text is configured
Shelves generation content of pages, word and chart Show Styles are selected by user；
S17 establishes associated databases, realizes that user accesses robot, according to the question information that user sends, carries out screening and sentences
It is disconnected, system for content feedback is carried out to user.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510311556.7A CN104965868B (en) | 2015-06-09 | 2015-06-09 | Data query analysis system and method based on wechat public platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510311556.7A CN104965868B (en) | 2015-06-09 | 2015-06-09 | Data query analysis system and method based on wechat public platform |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104965868A CN104965868A (en) | 2015-10-07 |
| CN104965868B true CN104965868B (en) | 2018-06-08 |
Family
ID=54219905
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510311556.7A Active CN104965868B (en) | 2015-06-09 | 2015-06-09 | Data query analysis system and method based on wechat public platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104965868B (en) |
Families Citing this family (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105763430A (en) * | 2016-05-04 | 2016-07-13 | 北京思特奇信息技术股份有限公司 | Service encapsulation method and system for WeChat public account development |
| CN106357510B (en) * | 2016-09-13 | 2019-06-28 | 山东脉达信息科技有限公司 | A kind of business administration data interaction system and method |
| CN106570118B (en) * | 2016-11-02 | 2020-08-07 | 国网山东省电力公司物资公司 | Report data processing system and method based on electric power material allocation mobile platform |
| CN106779959A (en) * | 2016-12-28 | 2017-05-31 | 合肥智畅信息科技有限公司 | A kind of electric business service platform system based on wechat APP |
| CN108282506A (en) * | 2017-01-06 | 2018-07-13 | 阿里巴巴集团控股有限公司 | A kind of method, apparatus that realizing business intelligence and mobile terminal |
| CN107483489A (en) * | 2017-09-18 | 2017-12-15 | 上海上实龙创智慧能源科技股份有限公司 | A kind of wisdom office system authentication method based on wechat enterprise number |
| CN109840424A (en) * | 2018-12-18 | 2019-06-04 | 合肥天源迪科信息技术有限公司 | A kind of data base encryption and the system that desensitizes |
| CN110009290A (en) * | 2019-04-16 | 2019-07-12 | 广西先飞达物流股份有限公司 | A kind of transit information Synergistic method and system based on wechat end |
| CN110188260A (en) * | 2019-04-18 | 2019-08-30 | 上海马小修智能科技有限公司 | A kind of IT underlying hardware knowledge system |
| CN110717128B (en) * | 2019-10-18 | 2021-02-09 | 腾讯科技（深圳）有限公司 | Method, device, terminal and storage medium for processing in-application webpage |
| CN110765256B (en) * | 2019-12-24 | 2020-07-07 | 杭州实在智能科技有限公司 | Method and equipment for generating online legal consultation automatic reply |
| CN111897527B (en) * | 2020-06-28 | 2022-06-07 | 福建亿能达信息技术股份有限公司 | Hospital equipment budget management system, equipment and medium based on holographic view |
| CN112559921A (en) * | 2020-12-04 | 2021-03-26 | 中国农业银行股份有限公司深圳市分行 | Method, system and storage medium for realizing bank information visualization |
| CN113420194A (en) * | 2021-05-07 | 2021-09-21 | 上海汇付数据服务有限公司 | Method and system for displaying data |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103347137A (en) * | 2013-07-24 | 2013-10-09 | 联创亚信科技（南京）有限公司 | Method and device for processing user service handling data |
| CN104156862A (en) * | 2014-08-07 | 2014-11-19 | 四川途谷信息技术有限公司 | Wechat-platform-based two-dimensional code anti-fake and anti-channel conflict inquiry system and method |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050202392A1 (en) * | 2004-01-30 | 2005-09-15 | Allen J. V. | Web service api for student information and course management systems |
-
2015
- 2015-06-09 CN CN201510311556.7A patent/CN104965868B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103347137A (en) * | 2013-07-24 | 2013-10-09 | 联创亚信科技（南京）有限公司 | Method and device for processing user service handling data |
| CN104156862A (en) * | 2014-08-07 | 2014-11-19 | 四川途谷信息技术有限公司 | Wechat-platform-based two-dimensional code anti-fake and anti-channel conflict inquiry system and method |
Non-Patent Citations (3)
| Title |
|---|
| 图书馆微信服务应用开发_以上海图书馆为例;郭利敏等;《现代图书情报技术》;20140525;第2014年卷(第05期);全文 * |
| 基于微信公众平台的校园信息自助查询系统;关辉等;《福建电脑》;20140625;第2014年卷(第06期);全文 * |
| 基于微信平台的校园信息查询系统研究;刘国营等;《中国教育信息化》;20150305;第2015年卷(第05期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104965868A (en) | 2015-10-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104965868B (en) | Data query analysis system and method based on wechat public platform | |
| US10506428B2 (en) | Wireless network connection method, apparatus, and system | |
| CN103024061B (en) | Network communication contact book shared system and method | |
| CN106874389A (en) | The moving method and device of data | |
| CN107077559B (en) | Verification System reminds terminal and information recording carrier | |
| CN111352740B (en) | Application interaction processing method and device | |
| Hu | Taxonomy of the snowden disclosures | |
| CN105049631B (en) | Enter the method and mobile terminal of row information transmission in address list program | |
| CN104268611A (en) | Webpage synchronizing method and device | |
| KR101351264B1 (en) | System and method for message translation based on voice recognition | |
| CN106254226B (en) | A kind of information synchronization method and device | |
| JP2017187818A (en) | Information processing system, information processing method, and program | |
| CN104158893B (en) | The method and system of Contents of clipboard are transmitted based on WiFi equipment | |
| CN112910741A (en) | Interface testing method and device, computer equipment and storage medium | |
| CN104243597A (en) | Business card dispensing and collecting system and business card dispensing and collecting method based on WLAN (wireless local area network) environment | |
| CN112350991A (en) | Login method and device of front-end system | |
| KR101612462B1 (en) | Method for managing schedule between a plurality of users in a group | |
| US9900304B2 (en) | Method, apparatus and system for implementing third party application in micro-blogging service | |
| KR20050034680A (en) | A telephone number guidance system which uses a character message. | |
| KR20150119668A (en) | File sharing method and system using a e-mail message | |
| CN109241381A (en) | Information matching method and device | |
| CN102333047A (en) | Information interaction method and system based on community group | |
| CN102333045A (en) | Group information interaction method and system of community network | |
| US11126971B1 (en) | Systems and methods for privacy-preserving enablement of connections within organizations | |
| KR20160120529A (en) | System and method for providing internet-article based on sectorial classification |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |