CN109086052A - BI system based on Portal - Google Patents
BI system based on Portal Download PDFInfo
- Publication number
- CN109086052A CN109086052A CN201810737038.5A CN201810737038A CN109086052A CN 109086052 A CN109086052 A CN 109086052A CN 201810737038 A CN201810737038 A CN 201810737038A CN 109086052 A CN109086052 A CN 109086052A
- Authority
- CN
- China
- Prior art keywords
- data
- portal
- portlet
- company information
- layer
- 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
- G06F8/00—Arrangements for software engineering
- G06F8/60—Software deployment
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The BI system based on Portal that the invention discloses a kind of, the system include data acquisition layer, data storage layer and data access layer；The data acquisition layer includes the data pick-up unit that initial data is extracted from each operation system, and the data processing unit for obtaining unified company information after the initial data of dispersion is cleaned, converted and loaded；The data storage layer includes the data warehouse for saving the unified company information；The data access layer is for calling, showing the unified company information.The system can realize BI system and third party system loose coupling, also be able to achieve fully-integrated with third party system；BI, which is applied, realizes that customized page layout and permission control with third party system.Also, in permission tolerance band, the data switching at runtime that BI is applied can be realized in current page and customized again.
Description
Technical field
The BI system based on Portal that the present invention relates to a kind of.
Background technique
BI software is the english abbreviation of business intelligence (Business Intelligence) software.Business intelligence usually quilt
It is interpreted as converting data existing in enterprise to knowledge, user is helped to make the tool of wise business business decision.Currently,
BI system or by the way of Complete customization, couples deeply with third party system or is stand-alone development and deployment, with third
Method, system can not achieve integrated.
Summary of the invention
The BI system based on Portal that the object of the present invention is to provide a kind of cannot be realized simultaneously with solving existing BI system
With third party system loose coupling and fully-integrated problem.
In order to solve the above technical problems, the present invention provides a kind of BI system based on Portal, including data acquisition layer, number
According to accumulation layer and data access layer；The data acquisition layer includes the data pick-up list that initial data is extracted from each operation system
Member, and for being obtained after the initial data of dispersion is cleaned, converted and loaded at the uniformly data of company information
Manage unit；The data storage layer includes the data warehouse for saving the unified company information；The data access layer is used
In calling, show the unified company information comprising Portal server, Portlet container and Portlet, it is described
Portal server gives the Portlet in user's current page for change, then calls Portlet container, weight for handling client's request
The content of each Portlet is newly obtained, the Portlet container is for providing the runtime environment of Portlet.
Further, the data warehouse includes SQL database and Nosql database；The SQL database is for storing
Implementation relation type data；The Nosql database storage relational data and character string.
Further, the data storage layer realizes the quick search and retrieval of json data by JSONB.
Further, the data warehouse has ODS.
Further, the Portal server passes through unified company information described in Portal webpage representation, and described
The Portal page includes at least one Portlet window.
Further, the Portlet window contains title bar, window control, Graphicxtras Frames Collection and Portlet segment.
The invention has the benefit that the system can realize BI system and third party system loose coupling, also it is able to achieve and the
Three method, systems are fully-integrated；BI, which is applied, realizes that customized page layout and permission control with third party system.Also, permitted in permission
The data switching at runtime of BI application can be realized in current page and again customized in range.
Detailed description of the invention
The drawings described herein are used to provide a further understanding of the present application, constitutes part of this application, at this
The same or similar part, the illustrative embodiments and their description of the application are indicated using identical reference label in a little attached drawings
For explaining the application, do not constitute an undue limitation on the present application.In the accompanying drawings:
Fig. 1 is the structural block diagram of one embodiment of the invention；
Fig. 2 is the relationship between the Portal server, Portlet container and Portlet of one embodiment of the invention
Schematic diagram；
Fig. 3 is the schematic diagram of the Portal page of one embodiment of the invention.
Specific embodiment
BI system based on Portal as shown in Figure 1, including data acquisition layer, data storage layer and data access layer.
Various pieces are described in detail separately below:
The data acquisition layer include from each operation system extract initial data data pick-up unit, and for pair
The initial data of dispersion obtains the data processing unit of unified company information after being cleaned, converted and being loaded.
The data storage layer includes the data warehouse for saving the unified company information；Data in data warehouse
It is to process, summarize and arrange by system on the basis of the database data of original dispersion is extracted, cleared up, eliminates
Inconsistency in source data guarantees that the information in data warehouse is the consistent global information about entire enterprise.Data bins
The data in library mainly for business decision analysis be used, related data manipulation is mainly data query, once some data into
After entering data warehouse, it will be retained for a long time under normal circumstances, that is, generally have a large amount of inquiry operation in data warehouse, but
Modification and delete operation are seldom, usually only need regularly to load, refresh.Data in data warehouse generally comprise history letter
Breath, system have recorded enterprise since past a certain time point (applying the time point of data warehouse such as) to the letter in current each stage
Breath, by these information, can development course to enterprise and future trend make quantitative analysis and prediction.
The data access layer is for calling, showing the unified company information comprising Portal server,
Portlet container and Portlet, the Portal server are given for change in user's current page for handling client's request
Then Portlet calls Portlet container, reacquire the content of each Portlet, the Portlet container is for providing
The runtime environment of Portlet.
According to one embodiment of the application, the data warehouse includes SQL database (structured query language data
Library) and Nosql database；The SQL database (such as mysql, oracl) is for storing implementation relation type data；The Nosql
Database storage relational data and character string.
According to one embodiment of the application, the data storage layer realizes json (JavaScript object by JSONB
Label) data quick search and retrieval.
According to one embodiment of the application, the data warehouse has ODS.
According to one embodiment of the application, the Portal server passes through unified enterprise described in Portal webpage representation
Information, and the Portal page includes at least one Portlet window.
Portal is a Web page, it is formed by one or several Portal page tissues.And each Portal pages
Face is made of one or several Portlet windows again --- Portlet is to appear in Portal pages in the form of windows
In face.Fig. 2 is the exemplary construction schematic diagram of a Portal page structure, and there are four Portlet windows for the window.
According to one embodiment of the application, the Portlet window contain title bar, window control, Graphicxtras Frames Collection and
Portlet segment.That is Portlet window is made of two parts: one is appearance, includes title bar, window control and frame
Pattern；The second is content, i.e. Portlet segment.
Using Portal technology, can be convenient by required for employee, manager, the information from various channels provides
Material is integrated within a unified desktop window.According to the customization function that Portal is provided, body can be measured for this department personnel
A set of distinctive information portal is customized, effectively group is woven among unified Web browser by the common information needed of department, and can
Corresponding access operation permission is set according to personnel's rank and function.
The system can also can be realized and other moulds as other modules freely according to demand in page layout
Block uniformly shows and organically blends；Secondly, can realize the switching at runtime of BI data at interface and again customize.
BI integrates each operation system by the technology of portal, so that BI and OA, CRM, ERP, SCM and other
It is able to achieve fusion between system to integrate, the structural data between system can be managed platform by portal and call mutually, show, entirely
Face provides the Integrated services such as decision support, knowledge excavation, business intelligence, realizes enterprise digital, more educated, virtualization.This
When scope of the BI far beyond traditional BI, develop become the powerful management support platform of Enterprise Integrated, be changed to Enterprise Knowledge Portal,
Enterprise B I is pushed to develop to comprehensive platform, portal direction.
In addition, tradition BI with emphasis on by the relationship between visual contingency table and table, then realizing the poly- of data again
It closes and sorts out, data are shown finally by modes such as report, table, maps.In the present solution, it is believed that visual
Being associated between the table of change and table is not emphasis, and for the user, it is understood that the relationship between table needs relevant
Professional knowledge, so we by way of directly configuring SQL statement, SQL is that business is unrelated.
Finally, it is stated that the above examples are only used to illustrate the technical scheme of the present invention and are not limiting, although referring to compared with
Good embodiment describes the invention in detail, those skilled in the art should understand that, it can be to skill of the invention
Art scheme is modified or replaced equivalently, and without departing from the objective and range of technical solution of the present invention, should all be covered at this
In the scope of the claims of invention.
Claims (6)
1. a kind of BI system based on Portal, which is characterized in that including data acquisition layer, data storage layer and data access
Layer；The data acquisition layer includes the data pick-up unit that initial data is extracted from each operation system, and for dispersion
The initial data cleaned, converted and loaded after obtain the data processing unit of unified company information；The data are deposited
Reservoir includes the data warehouse for saving the unified company information；The data access layer is for calling, showing the system
One company information comprising Portal server, Portlet container and Portlet, the Portal server is for handling
Client's request, gives the Portlet in user's current page for change, then calls Portlet container, reacquires each Portlet's
Content, the Portlet container is for providing the runtime environment of Portlet.
2. the BI system according to claim 1 based on Portal, which is characterized in that the data warehouse includes SQL number
According to library and Nosql database；The SQL database is for storing implementation relation type data；Nosql database storage is closed
It is type data and character string.
3. the BI system according to claim 2 based on Portal, which is characterized in that the data storage layer passes through
The quick search and retrieval of JSONB realization json data.
4. the BI system according to claim 1 to 3 based on Portal, which is characterized in that the data warehouse has
ODS。
5. the BI system according to claim 1 based on Portal, which is characterized in that the Portal server passes through
Unified company information described in Portal webpage representation, and the Portal page includes at least one Portlet window.
6. the BI system according to claim 5 based on Portal, which is characterized in that the Portlet window contains mark
Inscribe item, window control, Graphicxtras Frames Collection and Portlet segment.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810737038.5A CN109086052A (en) | 2018-07-06 | 2018-07-06 | BI system based on Portal |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810737038.5A CN109086052A (en) | 2018-07-06 | 2018-07-06 | BI system based on Portal |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109086052A true CN109086052A (en) | 2018-12-25 |
Family
ID=64837147
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810737038.5A Pending CN109086052A (en) | 2018-07-06 | 2018-07-06 | BI system based on Portal |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109086052A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110941657A (en) * | 2019-11-08 | 2020-03-31 | 支付宝(杭州)信息技术有限公司 | Service data processing method and device |
| CN113126849A (en) * | 2021-04-07 | 2021-07-16 | 帆软软件有限公司 | Spreadsheet interactive mapping virtual system based on database and interactive mapping method |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101187868A (en) * | 2006-11-23 | 2008-05-28 | 国际商业机器公司 | Method and system for configuration application in door circumstance based on Web |
| US20110126090A1 (en) * | 2009-11-24 | 2011-05-26 | Nec Corporation | Component cooperation device, a component cooperation method, a method of updating components of a web page and a program thereof |
| CN102360377A (en) * | 2011-10-12 | 2012-02-22 | 中国测绘科学研究院 | Spatial clustering mining PSE (Problem Solving Environments) system and construction method thereof |
| CN102663024A (en) * | 2012-03-22 | 2012-09-12 | 北京英孚斯迈特信息技术有限公司 | Data portal system for enterprise data unified platform |
| CN103824150A (en) * | 2013-11-25 | 2014-05-28 | 广州杰赛科技股份有限公司 | Food safety monitoring system |
| US9158556B2 (en) * | 2012-04-19 | 2015-10-13 | Sap Portals Israel Ltd | Managing web content creation in a web portal |
| CN105740309A (en) * | 2015-12-18 | 2016-07-06 | 北京中科汇联科技股份有限公司 | Portal platform-based website content management system |
-
2018
- 2018-07-06 CN CN201810737038.5A patent/CN109086052A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101187868A (en) * | 2006-11-23 | 2008-05-28 | 国际商业机器公司 | Method and system for configuration application in door circumstance based on Web |
| US20110126090A1 (en) * | 2009-11-24 | 2011-05-26 | Nec Corporation | Component cooperation device, a component cooperation method, a method of updating components of a web page and a program thereof |
| CN102360377A (en) * | 2011-10-12 | 2012-02-22 | 中国测绘科学研究院 | Spatial clustering mining PSE (Problem Solving Environments) system and construction method thereof |
| CN102663024A (en) * | 2012-03-22 | 2012-09-12 | 北京英孚斯迈特信息技术有限公司 | Data portal system for enterprise data unified platform |
| US9158556B2 (en) * | 2012-04-19 | 2015-10-13 | Sap Portals Israel Ltd | Managing web content creation in a web portal |
| CN103824150A (en) * | 2013-11-25 | 2014-05-28 | 广州杰赛科技股份有限公司 | Food safety monitoring system |
| CN105740309A (en) * | 2015-12-18 | 2016-07-06 | 北京中科汇联科技股份有限公司 | Portal platform-based website content management system |
Non-Patent Citations (2)
| Title |
|---|
| 佚名: "Juzuweb框架使用（一）——portal及portlet介绍", 《HTTPS://BLOG.CSDN.NET/FENGSHUIYUE/ARTICLE/DETAILS/77435458?FPS=1&LOCATIONNUM=8》 * |
| 吴兴莲: "基于Portal的学生管理信息系统的开发及应用", 《无线互联科技》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110941657A (en) * | 2019-11-08 | 2020-03-31 | 支付宝(杭州)信息技术有限公司 | Service data processing method and device |
| CN110941657B (en) * | 2019-11-08 | 2023-03-31 | 支付宝(杭州)信息技术有限公司 | Service data processing method and device |
| CN113126849A (en) * | 2021-04-07 | 2021-07-16 | 帆软软件有限公司 | Spreadsheet interactive mapping virtual system based on database and interactive mapping method |
| CN113126849B (en) * | 2021-04-07 | 2022-06-07 | 帆软软件有限公司 | Spreadsheet interactive mapping virtual system based on database and interactive mapping method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Karnitis et al. | Migration of relational database to document-oriented database: structure denormalization and data transformation | |
| US10346532B2 (en) | Document collaboration and consolidation tools and methods of use | |
| US11468103B2 (en) | Relational modeler and renderer for non-relational data | |
| US8812439B2 (en) | Folder structure and authorization mirroring from enterprise resource planning systems to document management systems | |
| US7853610B2 (en) | Virtual foldering system for blending process and content in a collaborative environment | |
| US5721911A (en) | Mechanism for metadata for an information catalog system | |
| US20090287737A1 (en) | Architecture for enabling rapid database and application development | |
| WO2008033577A2 (en) | Hierarchy global management system and user interface | |
| CN101004683A (en) | Method and device for accessing database | |
| CN103473256B (en) | Method and system for content management | |
| CN106126569A (en) | A kind of rapid data method of servicing and system | |
| CN101872449A (en) | Customer information screening method | |
| CN103914290A (en) | Operating command processing method and device | |
| Raden | Shedding light on shadow IT: Is Excel running your business | |
| CN103473332A (en) | Data archive repository with virtual test architecture | |
| US11762820B2 (en) | Automatic conversion of data models using data model annotations | |
| CN109086052A (en) | BI system based on Portal | |
| US11734309B2 (en) | Nested group hierarchies for analytics applications | |
| CN100590616C (en) | Multilayer database system and method for establishing the multilayer database system | |
| Farooq | The data warehouse virtualization framework for operational business intelligence | |
| Hodinka et al. | Business intelligence in Environmental reporting powered by XBRL | |
| ITMI20071825A1 (en) | DYNAMIC SYSTEM FOR THE CREATION AND MANAGEMENT OF A DATABASE | |
| Becker et al. | Concpetual Design of WWW Based Information Systems | |
| KR100873807B1 (en) | How to Build an Object-Oriented Metadata Repository for Enterprise Data Systems | |
| Chen et al. | A practical guide to managing reference data with IBM InfoSphere master data management reference data management hub |
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 |
Application publication date: 20181225 |
|
| RJ01 | Rejection of invention patent application after publication |