CN106326247A - Cloud real-time business intelligent module - Google Patents
Cloud real-time business intelligent module Download PDFInfo
- Publication number
- CN106326247A CN106326247A CN201510347975.6A CN201510347975A CN106326247A CN 106326247 A CN106326247 A CN 106326247A CN 201510347975 A CN201510347975 A CN 201510347975A CN 106326247 A CN106326247 A CN 106326247A
- Authority
- CN
- China
- Prior art keywords
- module
- data
- cloud service
- walking type
- main frame
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/24569—Query processing with adaptation to specific hardware, e.g. adapted for using GPUs or SSDs
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention discloses a cloud real-time business intelligent module. The cloud real-time business intelligent module comprises a gateway device arranged at a client device, an ambulatory type data management module arranged at a cloud service host, and clients in telecommunication with the cloud service host. The ambulatory type data management module of the cloud service host is connected with the gateway device of the client device; the gateway device is responsible for providing data to the client device; the ambulatory type data management module of the cloud service host generates data source grammar dynamically; and the ambulatory type data management module of the cloud service host captures a demand based on data in the operating process of each client and converts the demand into database data query grammar. As content transmitted to a client device is only summarized data within a demand range, the problem of mass data transmission is not caused; as mass data are unnecessary to be stored in the cloud service host, the doubts of the clients about information security are overcome, and the renting space of the cloud service host and the file transmission amount can be reduced.
Description
Technical field
The present invention relates to the technical field of a kind of data base, particularly relate to a kind of high in the clouds and go up page intelligence module in real time, it can make the data base of client need not deposit to high in the clouds, and the data volume of transmission is few, speed fast, rents cloud service hosting space and also can be greatly decreased.
Background technology
Enterprise is in the demand of business intelligence in the doubt of high in the clouds solution, and major part is the safety of information, namely the operation data of enterprise is placed in the data warehousing of high in the clouds.And BI technology in-memory of development on market today
Technology, the process of its necessity is loaded into data in host memory exactly, in addition to accelerating the instruction cycle, provides user independently to analyze the purpose of (self-service BI) simultaneously.Therefore, with the Technology application on market today in high in the clouds environment, analyzing demand in real time to meet enterprise, can be apt to again use cloud service and calculation resources, the problem of primary solution is exactly the doubt of information security.
The present inventor previously " was implemented in real-time commercial wisdom system with the design of the walking type instruction recombination of SOA (SOA) " with TaiWan, China application number the 102214822nd, content is generally: one is implemented in real-time commercial intelligence system with the design of the walking type instruction recombination of SOA (SOA), including: a service host, this service host includes a central processing unit, number internal memory, number disc storage device, wherein, it is loaded with in this service host: a SOA (SOA), one user side and an Information technology (Information
nullTechnology,IT) personnel's end，This SOA (SOA) includes walking type instruction recombination module (ReSQL)，This walking type instruction recombination module (ReSQL) includes by an instruction recombination and dissects module、One first service definition shelves (eistable.def)、One second service definition shelves (valueSQL.def) and one inherits module composition，This first service definition shelves (eistable.def) and this second service definition shelves (valueSQL.def) are simply defined by this Information technology (IT) personnel's end，Data take from operating system or data take from multiple operating system or data take from multiple operating system and data warehousing，It is the data source that the instruction acquisition after recombinating according to this walking type instruction recombination module (ReSQL) in real time obtains，Desired data is obtained again by data source，This SOA (SOA) also comprises a syntax conversion module，Linked up this instruction recombination by this syntax conversion module and dissected module and each operating system or the homogeneity of data warehousing or heterogeneous data base，Make automatically obtaining of all data accessible，This succession module can between each service by succession by the way of revise this user side demand and by service between in conjunction with become a new service complete multiple data source integrate，This instruction recombination and anatomy module are responsible for the definition of service and the parameter of user side input being set and completing real-time Demand and service analysis with the operational pattern of walking type instruction recombination，And service-oriented，When this user side demand changes，This instruction recombination and anatomy module provide the elasticity of strain，With acquisition there is the analysis environments of multi-dimensional data and the computing of data warehousing，After this user side conversion demand，Even if different dimensions、Different operating systems or multiple operating system and data warehousing or homogeneity or Different kinds databases，Also the real-time of data after conversion can be obtained immediately，And need not distinctly write independent application-specific DLL (API).
But, if its front case is individually directed into client, rather expensive, non-general medium-sized and small enterprises can be born, if able to by cloud service main frame, erection expense then can be greatly decreased in the way of renting, and it also can reduce cloud service host leasing space and client data database data and lower information security doubt without stock's cloud service main frame.
Therefore, for the problem points existing for above-mentioned conventional construction, how to develop the innovation structure of a kind of more preferable practicality, real consumer is eagerly looked forward to, and is also that those skilled in the art must make great efforts to research and develop the target broken through and direction.
In view of this, the present inventor this in being engaged in manufacturing development and the design experiences of Related product for many years, for above-mentioned target, in detail after design and scrupulous assessment, eventually the present invention really having a practicality.
Summary of the invention
It is an object of the invention to provide that a kind of transmitted data amount is few, speed is fast, it is not necessary to mass data storing in cloud service main frame, also make data be stolen high in the clouds real-time commercial intelligence module that probability reduces.
In order to reach above-mentioned purpose, the solution of the present invention is:
A kind of high in the clouds real-time commercial intelligence module, including:
One gateway apparatus, before preceding gateway device is installed in a client terminal device, client terminal device inner setting has the white list of mandate, and client terminal device includes multiple homogeneity or heterogeneous data base；
One cloud service main frame, builds a walking type data management module inside aforementioned cloud service main frame, cloud service main frame connects gateway apparatus, and gateway apparatus connects client terminal device；And
Most users end, user side is logined aforementioned cloud service main frame and is proposed demand, cloud service main frame carries out authorization check through gateway apparatus to client terminal device and verifies whether as white list, being verified, user side demand is captured the database syntax of the client database being converted into correspondence by walking type data management module, database syntax is sent to data base corresponding to client and carries out data acquisition, obtain desired data and by data Automatic Typesetting, and data after typesetting are derived to cloud service main frame for user side extraction.
Aforementioned user side is a computer, a notebook computer, a panel computer, a mobile phone or an intelligent television.
Preceding gateway device comprises the management and control authorizing setting white list, authorization check, data base's online setting with data acquisition.
nullAforementioned walking type data management module includes walking type instruction recombination module，This walking type instruction recombination module includes instruction recombination and dissects module、One first service definition shelves、One second service definition shelves and one inherit module，This walking type data management module also comprises a syntax conversion module、One data set、One multiple data source integration module、Dimension integration module、One user interface controls module、One user interface output module、One filter and a cache，It is the medium that user side is linked up with walking type data management module that aforementioned user interface controls module with user interface output module，And aforementioned walking type instruction recombination module、Syntax conversion module、Data set、Multiple data source integration module、Dimension integration module、Filter、Cache then produces the database syntax of correspondence，And then it is supplied to user side by aforementioned client terminal device Relational database acquisition desired data.
nullAfter using such scheme，High in the clouds of the present invention real-time commercial intelligence module includes: a gateway apparatus (gateway) is located at client terminal device and is connected with client terminal device，One walking type data management module，Aforementioned walking type data management module is set up in cloud service main frame，The walking type data management module of cloud service main frame is connected with client terminal device with gateway apparatus (gateway)，User side is connected with cloud service main frame telecommunication，Gateway apparatus (gateway) is responsible for the data of client terminal device to be provided，Data source grammer is dynamically to be produced by the walking type data management module of cloud service main frame，Can reach the purpose of analysis in real time，The walking type data management module of cloud service main frame can be according to the data acquisition demand of user side operating process，It is converted into database data query grammar，Range of needs cohersive and integrated data is only limited with client transmissions content，Do not result in mass data transmission problem，Also present enterprise data-base content need not be uploaded and be stored in cloud service main frame，Overcome client to information security doubt，And cloud service host leasing space can be greatly decreased，Also biography shelves amount and time can be reduced.The client database of the present invention need not store to cloud service main frame, cloud service main frame sets walking type data management module, walking type data management module extract user demand, reconvert becomes corresponding database syntax, and only by the transmission of correspondence database grammer to correspondence database, passback desired data collated one-tenth tables of data, figure and be supplied to user side, can make that transmitted data amount is few, speed is fast, without mass data storing in cloud service main frame, also make data be stolen probability reduce.
Accompanying drawing explanation
Fig. 1 is the motion flow block chart of one embodiment of the invention；
Fig. 2 is the system flow block chart of one embodiment of the invention；
Fig. 3 is the framework flow chart of walking type data management module of the present invention；
Fig. 4 be the present invention one application examples apply customer complaint management system system architecture schematic diagram；
Fig. 5 is the product interrelated state position schematic diagram of one embodiment of the invention.
Wherein:
Gateway apparatus 10
Client terminal device 20
Data base 21
Cloud service main frame 30
Walking type data management module 40
Walking type instruction recombination module (ReSQL)
41
Instruction recombination and anatomy module 411
First service definition shelves (eistable.def) 412
Second service definition shelves (valueSQL.def) 413
Inherit module 414
Data set 42
Syntax conversion module 43
Multiple data source integration module 44
Dimension integration module 45
User interface output module 461
User interface controls module 462
Filter 47
Cache 48
User side 50
Computer 51
Panel computer 52
Mobile phone 53.
Detailed description of the invention
In order to technical scheme is explained further, below by specific embodiment, the present invention will be described in detail.
Refering to shown in Fig. 1 to Fig. 5, the present invention provides a kind of high in the clouds real-time commercial intelligence module, includes:
One gateway apparatus (Gateway) 10, before preceding gateway device 10 is installed in a client terminal device 20, client terminal device 20 is internal obtains the white list being first set with mandate, and client terminal device 20 includes multiple homogeneity or heterogeneous data base 21；
One cloud service main frame 30, aforementioned cloud service main frame 30 is internal builds a walking type data management module 40, and cloud service main frame 30 connects gateway apparatus 10, and gateway apparatus 10 connects client terminal device 20；And
Most users end 50, user side 50 is logined aforementioned cloud service main frame 30 and is proposed demand, cloud service main frame 30 carries out authorization check through gateway apparatus 10 to client terminal device 20 and verifies whether as white list, being verified, user side 50 demand is captured client terminal device homogeneity or the database syntax of heterogeneous data base 21 being converted into correspondence by walking type data management module 40, the data base 21 that database syntax is sent to client terminal device 20 correspondence carries out data acquisition, obtain desired data and by data Automatic Typesetting, and data after typesetting are derived to cloud service main frame 30 for user's extraction.
Refering to shown in Fig. 5, high in the clouds of the present invention real-time commercial intelligence module, the most aforementioned user side 50 can be computer 51, notebook computer, tablet PC 52, mobile phone 53 or an intelligent television.
Refering to shown in Fig. 2, high in the clouds of the present invention real-time commercial intelligence module, wherein preceding gateway device (Gateway) 10 comprises the management and control authorizing setting white list, authorization check, data base's online setting with data acquisition.Walking type data management module 40 then carries out data acquisition, and makes client terminal device 20 service execution by database syntax, and then data are loaded into data set, and is supplied to user side 50.Aforementioned cloud service main frame 30 authorizes, and authorizes cloud service main frame 30 can perform produced authorization code, and after adding this authorization code in the white list of gateway apparatus 10 end, cloud service main frame 30 request sent can be able to be verified with this authorization code.
nullRefering to shown in Fig. 4，An application examples for the present invention is used for complaint management，Wherein cloud service main frame 30 internal frame is provided with walking type data management module 40，User side 50 is likely to be user or company personnel or supervisor，During user side 50 enters cloud service main frame 30 proposition、Product、During the demand of return of goods rate，Client terminal device 20 i.e. can verify whether as white list，And after being verified，By walking type data management module 40, demand is captured conversion correspondence database grammer and be sent to gateway apparatus 10，And by gateway apparatus 10 to client terminal device 20 acquisition data，Again data derivation is extracted to cloud service main frame 30 for user side 50，User side is it can be seen that the form of return of goods rate of the Related product of relevant period，And if north、In、Three kinds of disparate databases of three branch companies in south，The return of goods rate of the Related product of relevant period can also be incorporated into a form and show，And data one are extracted would not there is cloud service main frame 30，Can ensure that the safety of data，Cloud service main frame 30 need not be there is in data base，Cloud service main frame 30 rent can be greatly reduced，And transmit just for data in database syntax and required scope，Data volume is transmitted less can be more rapid.
nullRefering to shown in Fig. 3，High in the clouds of the present invention real-time commercial intelligence module，The most aforementioned walking type data management module 40 is set up in cloud service main frame 30 (refering to shown in Fig. 5)，Walking type data management module 40 includes walking type instruction recombination module (ReSQL) 41，Aforementioned walking type instruction recombination module (ReSQL) 41 includes instruction recombination and dissects module 411、One first service definition shelves (eistable.def) 412、One second service definition shelves (valueSQL.def) 413 and inherits module 414，This walking type data management module 40 further includes a syntax conversion module 43、One data set 42、One multiple data source integration module 44、Dimension integration module 45、One user interface controls module 462、One user interface output module 461、One filter 47 and a cache 48，It is the medium that user side 50 is linked up with walking type data management module 40 that aforementioned user interface controls module 462 with user interface output module 461，And aforementioned walking type instruction recombination module (ReSQL) 41、Syntax conversion module 43、Data set 42、Multiple data source integration module 44、Dimension integration module 45、Filter 47、Cache 48 then can produce the database syntax of correspondence，And then obtained desired data by Relational database 21 and be supplied to user side 50.
Refering to shown in Fig. 1, motion flow block chart for one embodiment of the present invention, wherein, a () user side 50 proposes demand to cloud service main frame 30, (b) client terminal device 20 authorization check white list, if it is non-for white list just refusal, conversion correspondence database grammer is captured if (c) walking type data management module 40 demand set up in white list then cloud service main frame 30, database syntax (d) is sent to client terminal device 20 correspondence database 21, e () walking type data management module 40 obtains desired data, (f) walking type data management module 40 Automatic Typesetting figure and table, g () derivation is extracted to cloud service main frame 30 for user side 50.
In sum, the high in the clouds real-time commercial intelligence module of the present invention, the novelty requirement of patent of invention is really met for industry head is seen, and its comprehensive innovative design, meet the creative requirement of patent of invention, and outside data need not be moved on to corporate environment by enterprise, but can be apt to use high in the clouds calculation resources, cost is built except reducing hardware environment, enterprise operation data content can be obtained again and carry out walking type analysis, create advanced business intelligence to be worth, and for the enterprise of group type operation, the scattered operation in each department data base, take walking type data management module, the Internet is coordinated to obtain the operation information of integration in real time, rather than scattered fragment data, the condition of sales selling retail sales is analyzed with Inventory Performance real-time integration, carry out commodity scheduling or sales promotion is more real-time, the turnover and the consume reducing immediate product can be increased simultaneously.
Above-described embodiment and the product form of the graphic and non-limiting present invention and style, suitably change that it is done by any person of an ordinary skill in the technical field or modify, all should be regarded as the patent category without departing from the present invention.
Claims (4)
1. a high in the clouds real-time commercial intelligence module, it is characterised in that including:
One gateway apparatus, before preceding gateway device is installed in a client terminal device, client terminal device inner setting has the white list of mandate, and client terminal device includes multiple homogeneity or heterogeneous data base；
One cloud service main frame, builds a walking type data management module inside aforementioned cloud service main frame, cloud service main frame connects gateway apparatus, and gateway apparatus connects client terminal device；And
Most users end, user side is logined aforementioned cloud service main frame and is proposed demand, cloud service main frame carries out authorization check through gateway apparatus to client terminal device and verifies whether as white list, being verified, user side demand is captured the database syntax of the client database being converted into correspondence by walking type data management module, database syntax is sent to data base corresponding to client and carries out data acquisition, obtain desired data and by data Automatic Typesetting, and data after typesetting are derived to cloud service main frame for user side extraction.
2. high in the clouds as claimed in claim 1 real-time commercial intelligence module, it is characterised in that: aforementioned user side is a computer, a notebook computer, a panel computer, a mobile phone or an intelligent television.
3. high in the clouds as claimed in claim 1 real-time commercial intelligence module, it is characterised in that: preceding gateway device comprises the management and control authorizing setting white list, authorization check, data base's online setting with data acquisition.
null4. high in the clouds as claimed in claim 1 real-time commercial intelligence module，It is characterized in that: aforementioned walking type data management module includes walking type instruction recombination module，This walking type instruction recombination module includes instruction recombination and dissects module、One first service definition shelves、One second service definition shelves and one inherit module，This walking type data management module also comprises a syntax conversion module、One data set、One multiple data source integration module、Dimension integration module、One user interface controls module、One user interface output module、One filter and a cache，It is the medium that user side is linked up with walking type data management module that aforementioned user interface controls module with user interface output module，And aforementioned walking type instruction recombination module、Syntax conversion module、Data set、Multiple data source integration module、Dimension integration module、Filter、Cache then produces the database syntax of correspondence，And then it is supplied to user side by aforementioned client terminal device Relational database acquisition desired data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510347975.6A CN106326247A (en) | 2015-06-23 | 2015-06-23 | Cloud real-time business intelligent module |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510347975.6A CN106326247A (en) | 2015-06-23 | 2015-06-23 | Cloud real-time business intelligent module |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106326247A true CN106326247A (en) | 2017-01-11 |
Family
ID=57727934
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510347975.6A Pending CN106326247A (en) | 2015-06-23 | 2015-06-23 | Cloud real-time business intelligent module |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106326247A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114417336A (en) * | 2022-01-24 | 2022-04-29 | 北京新桥信通科技股份有限公司 | Application system side safety management and control method and system |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8046441B2 (en) * | 2006-02-13 | 2011-10-25 | Infosys Limited | Business to business integration software as a service |
| CN102546684A (en) * | 2010-12-13 | 2012-07-04 | 财团法人资讯工业策进会 | Cloud service system and cloud service method |
| CN103323866A (en) * | 2013-06-13 | 2013-09-25 | 华南理工大学 | Low-power-consumption beidou receiver based on cloud calculation and positioning method thereof |
| CN103744403A (en) * | 2014-01-17 | 2014-04-23 | 兴旺 | ZigBee-based smart home control method and ZigBee-based smart home control system |
| CN103914958A (en) * | 2013-12-31 | 2014-07-09 | 北京市燃气集团有限责任公司 | Combustion gas metering system |
| TWM484139U (en) * | 2013-12-12 | 2014-08-11 | Far Eastone Telecomm Co Ltd | Cloud gas meter management and service system |
| TWM487489U (en) * | 2013-08-07 | 2014-10-01 | Bai Xu Technology Co Ltd | Walking-around type instructions reorganization design with service oriented architecture (SOA) to implement real-time business intelligence system |
-
2015
- 2015-06-23 CN CN201510347975.6A patent/CN106326247A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8046441B2 (en) * | 2006-02-13 | 2011-10-25 | Infosys Limited | Business to business integration software as a service |
| CN102546684A (en) * | 2010-12-13 | 2012-07-04 | 财团法人资讯工业策进会 | Cloud service system and cloud service method |
| CN103323866A (en) * | 2013-06-13 | 2013-09-25 | 华南理工大学 | Low-power-consumption beidou receiver based on cloud calculation and positioning method thereof |
| TWM487489U (en) * | 2013-08-07 | 2014-10-01 | Bai Xu Technology Co Ltd | Walking-around type instructions reorganization design with service oriented architecture (SOA) to implement real-time business intelligence system |
| TWM484139U (en) * | 2013-12-12 | 2014-08-11 | Far Eastone Telecomm Co Ltd | Cloud gas meter management and service system |
| CN103914958A (en) * | 2013-12-31 | 2014-07-09 | 北京市燃气集团有限责任公司 | Combustion gas metering system |
| CN103744403A (en) * | 2014-01-17 | 2014-04-23 | 兴旺 | ZigBee-based smart home control method and ZigBee-based smart home control system |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114417336A (en) * | 2022-01-24 | 2022-04-29 | 北京新桥信通科技股份有限公司 | Application system side safety management and control method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11036735B2 (en) | Dimension context propagation techniques for optimizing SQL query plans | |
| JP7316341B2 (en) | Spatial change detector in stream data | |
| US11016958B2 (en) | Recreating an OLTP table and reapplying database transactions for real-time analytics | |
| Kakish et al. | ETL evolution for real-time data warehousing | |
| KR101621137B1 (en) | Low latency query engine for apache hadoop | |
| US20130254237A1 (en) | Declarative specification of data integraton workflows for execution on parallel processing platforms | |
| US20110313969A1 (en) | Updating historic data and real-time data in reports | |
| US20090006309A1 (en) | Cluster processing of an aggregated dataset | |
| CN102867282A (en) | Implementation method for mobile Internet-based customer service quality analysis system | |
| US9177037B2 (en) | In-memory runtime for multidimensional analytical views | |
| US20180150532A1 (en) | Method and system for implementing an on-demand data warehouse | |
| CN114707914A (en) | Supply and marketing management center platform system based on SaaS framework | |
| US20180174164A1 (en) | Predictive Analysis of Transactional Data | |
| CN104599146A (en) | Order management method | |
| Esmail | A survey of real-time data warehouse and ETL | |
| TWI609281B (en) | Cloud Instant Business Intelligence Module | |
| CN106326247A (en) | Cloud real-time business intelligent module | |
| US10057108B2 (en) | Systems, devices, and methods for exchanging and processing data measures and objects | |
| CN115062084A (en) | Method and device for constructing API (application program interface) based on database metadata | |
| CN114298788A (en) | OMS order management system | |
| Zheng | Cloud service and interactive IoT system application in the service management mode of logistics enterprises | |
| TWM508067U (en) | Cloud real-time business intelligence module | |
| CN110796451A (en) | Information service system based on after-sale collaboration | |
| TWI556189B (en) | Methodology of common data manipulation and transformation within customers for telecom operators | |
| CN118379148A (en) | Tax counter window remoting device based on intelligent automatic processing robot |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170111 |