CN101042746A - Container pier intellectualized report forms based on store house and method - Google Patents
Container pier intellectualized report forms based on store house and method Download PDFInfo
- Publication number
- CN101042746A CN101042746A CNA200610024884XA CN200610024884A CN101042746A CN 101042746 A CN101042746 A CN 101042746A CN A200610024884X A CNA200610024884X A CN A200610024884XA CN 200610024884 A CN200610024884 A CN 200610024884A CN 101042746 A CN101042746 A CN 101042746A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- source
- warehouse
- analysis model
- 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
Images
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
This invention discloses one container harbor intelligent report system and method based on data ware composed of data source, data extraction and extension module, wherein, the data source comprises harbor management system, financial system database and other system database; the extraction module uses ETL technique through back coding program to draw source data from management system and other systems and to load them into middle database or staging area for integration on each information islands in database; accordingly establishing data multi-dimensional analysis module to display reports through hyperion P erformance suite.
Description
Technical field
The present invention relates to a kind of container wharf, specifically is a kind of container wharf GEOMAP and method based on data warehouse.
Background technology
In the management process of container terminal logistics system, the leader and the decision maker that are necessary for company provide effective decision references information, and to improve the efficiency of operation of company, the competitive edge of reinforcement company in the same industry reached the operations objective of company.Along with the growth at full speed of dock container handling capacity, each business department is more and more higher to the requirement of form.
Traditional fixedly report form is difficult to satisfy the new demand that the business personnel produces owing to turn of the market, and form is fixed difficult expansion; Each department that the container terminal logistics system is correlated with is different to the query composition requirement of data, the data that same department needs when analyzing different themes also are different, and traditional Database Systems produce aspect the data combination powerless in personalization in real time; Traditional report data leaves in to be produced in the real-time management system, and therefore, report query not only brings very big pressure to system in real time; And, can cause the data of report generation inconsistent owing to often will safeguard to these data, i.e. same form of different time generation, the result understands different.Therefore, must use new data analysis system that reporting system is improved.
Summary of the invention
The present invention is for solving the deficiency in the existing reporting system, and a kind of independent architecture, exploitation and easy to use, data consistent, the analytic function with powerful and multi-angle, the intelligent form in extendible container wharf based on data warehouse and method of adopting is provided.
The present invention is achieved by the following technical solutions:
The intelligent form in a kind of container wharf based on data warehouse, by intermediate database, data source, data pick-up, form show the exhibition module and form.Data source comprises harbour management system (CTMS), financial system database and other system database.Data extraction module adopts data pick-up (ETL) technology, programme by the backstage, to extract from the source data harbour management system and other system, be loaded in the data warehouse (DataWarehouse) or buffer zone (Staging area) in the intermediate database, intermediate database to data source in the data of each information island integrate, and on this basis, set up data multidimensional analytical model (MDA); And by the apparent front end technology for revealing realization form of opening up module Hyperion Performance Suite (HPS) of described form.
Multidimensional analysis models (MDA) comprises case component analysis model, revenue analysis model, customer analysis model, boats and ships analytical model.
The implementation method of the intelligent form in a kind of container wharf based on data warehouse, its concrete steps are as follows:
At first, various original production data leaves in harbour management system (CTMS) and equipment and the financial system database with Star Schema;
Secondly, maintenance data extracts (ETL) technology, and the data in the different pieces of information source according to correlativity, with algorithm and transformation rule, are loaded in the target data warehouse to timing or not timing, and this process comprises following operation:
(1) extracts (Extract), the data extract in the data source is come out;
(2) conversion (Transform) becomes same form with the data-switching in the operation system, and is inconsistent or incomplete and influence the problem of the quality of data to eliminate the data that exist in the operation system;
(3) redundant in the data source or off-limits data scrubbing are fallen in cleaning (Cleansing), guarantee the quality of data in the data warehouse;
(4) be written into (Load), will through extraction, the Data Loading of conversion and cleaning is in system data warehouse (Data Warehouse) or buffer zone (Staging area); 0
Then, set up the data multidimensional analytical model (MDA) that comprises case component analysis model, revenue analysis model, customer analysis model, boats and ships analytical model at the actual demand of the professional theme of department;
At last, realize representing of form by Hyperion Performance Suite (HPS) front end technology for revealing.
The place that the present invention is different from traditional form technology is: one, intelligent report forms have certain " intelligence ", and it can gather, see that the thinking habit of details represents form according to seeing earlier of user; Its two, for a form, the user can also further select subclass, promptly further analyzes and excavates on the basis of form; Its three, intelligent report forms allows the user to represent in common mode arbitrarily and checks same form, can check with forms such as HTML, DHTML, EXCEL, PDF, RTF; Its four, intelligent report system has the unexistent advantage of traditional reporting system at aspects such as security, Version Control, filing control, Email notification service.The present invention adopts the random challenge technology, set up friendly, easy-to-use, flexibly, comprehensive information random challenge application interface.Make service-user to seek answer by the form of random challenge to some interim problem that occurs.
Beneficial effect of the present invention is: the pressure that can alleviate real time operating system; Exploitation and easy to use; Analytic function is strong, and angle is many, and amount is big; Data consistency; Dirigibility, extensibility is strong.
Description of drawings
Fig. 1 is a system architecture diagram of the present invention.
Embodiment
The invention will be further described below in conjunction with accompanying drawing:
As shown in Figure 1, system of the present invention is by intermediate database, data source, and data pick-up, form show the exhibition module and form.Data source comprises harbour management system (CTMS), financial system database and other system database.Data extraction module adopts data pick-up (ETL) technology, programme by the backstage, to extract from the source data harbour management system and other system, be loaded in the data warehouse (Data Warehouse) or buffer zone (Staging area) in the intermediate database, intermediate database to data source in the data of each information island integrate, and on this basis, set up the data multidimensional analytical model (MDA) that comprises case component analysis model, revenue analysis model, customer analysis model, boats and ships analytical model; And by the apparent front end technology for revealing realization form of opening up module Hyperion Performance Suite (HPS) of described form.
Implementation method of the present invention is as follows:
At first, various original production data leaves in harbour management system (CTMS) and equipment and the financial system with Star Schema.
Secondly, maintenance data extracts (ETL) technology, and the data in the different pieces of information source according to certain correlativity, with certain algorithm and transformation rule, are loaded in the target data warehouse to timing or not timing.This process comprises following operation: (1) extracts (Extract), and the data extract in the data source is come out; (2) conversion (Transform) becomes same form with the data-switching in the operation system, to eliminate the inconsistent or incomplete problem that waits some to influence the quality of data of data that exists in the operation system; (3) redundant in the data source or off-limits data scrubbing are fallen in cleaning (Cleansing), also are in order to guarantee the quality of data in the data warehouse; (4) be written into (Load), will through extraction, the Data Loading of conversion and cleaning is to the system data warehouse in (DW, Data Warehouse) or the buffer zone (SA, Staging area).After system set up, these operations were all finished automatically by system.Through the data after the ETL three trends are arranged: most of data are loaded onto among the DW; But consider the complicated and changeable of harbour actual production, the data of process ETL also may need to revise, so for uncertain data, leave in earlier among the SA, are written into DW at last again; In addition, some data is directly represented in form.
Then, study of the actual demand of each business department, set up data multidimensional analytical model (MDA) at department's (professional theme) then BI.Mainly contain case component analysis model, revenue analysis model, customer analysis model, boats and ships analytical model or the like.Transform and data scrubbing owing to passed through data layout, the data that are stored in the data warehouse have consistance and completeness, so when setting up the MDA of all departments, do not need to consider the problem of data layout.
At last, realize representing of form by Hyperion Performance Suite (HPS) front end technology for revealing.Because HPS also has certain data analysis function, therefore do not set up MDA for some analysis, analyze and represent by HPS but directly from DW, fetch data.
Claims (3)
1. one kind based on the intelligent form in the container wharf of data warehouse, by intermediate database, data source, data pick-up, form shows the exhibition module and forms, it is characterized in that: described data source comprises harbour management system (CTMS), financial system database and other system database, described data extraction module adopts data pick-up (ETL) technology, programme by the backstage, to extract from the source data harbour management system and other system, be loaded in the data warehouse (Data Warehouse) or buffer zone (Staging area) in the described intermediate database, described intermediate database to data source in the data of each information island integrate, and on this basis, set up data multidimensional analytical model (MDA); And by the apparent front end technology for revealing realization form of opening up module Hyperion Performance Suite (HPS) of described form.
2. according to the intelligent form in the described container wharf of claim 1, it is characterized in that described multidimensional analysis models (MDA) comprises case component analysis model, revenue analysis model, customer analysis model, boats and ships analytical model based on data warehouse.
3. the implementation method of a claim 1 is characterized in that, its concrete steps are as follows:
At first, various original production data leaves in harbour management system (CTMS) and equipment and the financial system database with Star Schema;
Secondly, maintenance data extracts (ETL) technology, and the data in the different pieces of information source according to correlativity, with algorithm and transformation rule, are loaded in the target data warehouse to timing or not timing, and this process comprises following operation:
(1) extracts (Extract), the data extract in the data source is come out;
(2) conversion (Transform) becomes same form with the data-switching in the operation system, and is inconsistent or incomplete and influence the problem of the quality of data to eliminate the data that exist in the operation system;
(3) redundant in the data source or off-limits data scrubbing are fallen in cleaning (Cleansing), guarantee the quality of data in the data warehouse;
(4) be written into (Load), will through extraction, the Data Loading of conversion and cleaning is in system data warehouse (Data Warehouse) or buffer zone (Staging area); 0
Then, set up the data multidimensional analytical model (MDA) that comprises case component analysis model, revenue analysis model, customer analysis model, boats and ships analytical model at the actual demand of the professional theme of department;
At last, realize representing of form by Hyperion Performance Suite (HPS) front end technology for revealing.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA200610024884XA CN101042746A (en) | 2006-03-21 | 2006-03-21 | Container pier intellectualized report forms based on store house and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA200610024884XA CN101042746A (en) | 2006-03-21 | 2006-03-21 | Container pier intellectualized report forms based on store house and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101042746A true CN101042746A (en) | 2007-09-26 |
Family
ID=38808244
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA200610024884XA Pending CN101042746A (en) | 2006-03-21 | 2006-03-21 | Container pier intellectualized report forms based on store house and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101042746A (en) |
Cited By (19)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102246210A (en) * | 2008-12-15 | 2011-11-16 | 松下航空电子公司 | System and method for performing real-time data analysis |
| CN102402733A (en) * | 2011-10-12 | 2012-04-04 | 远光软件股份有限公司 | Diversified electronic accounting file management system and method |
| CN101694661B (en) * | 2009-10-22 | 2012-05-09 | 中兴通讯股份有限公司 | Method and device for generating statistical form and statistical server |
| CN102710455A (en) * | 2012-04-19 | 2012-10-03 | 华为技术有限公司 | Method, device and system for real time data monitoring |
| CN101587477B (en) * | 2008-05-23 | 2012-10-31 | 阿里巴巴集团控股有限公司 | Method and system for automatically maintaining ETL modules |
| CN103226570A (en) * | 2013-03-21 | 2013-07-31 | 江苏省电力公司泰州供电公司 | Real-time data report processing system based on OPEN3000 system database |
| CN103679383A (en) * | 2013-12-25 | 2014-03-26 | 武汉武船信息集成有限公司 | Method for establishing shipbuilding enterprise group management and control platform |
| CN103679309A (en) * | 2012-09-13 | 2014-03-26 | 余明阳 | Intelligent statistical analysis method for power data warehouse services |
| CN103838788A (en) * | 2012-11-27 | 2014-06-04 | 大连灵动科技发展有限公司 | Data analyzing method based on fMRI brain activation data warehouse |
| CN104376483A (en) * | 2014-12-10 | 2015-02-25 | 用友软件股份有限公司 | Device and method for inserting multi-dimensional analysis models into operation system |
| CN104809110A (en) * | 2014-01-23 | 2015-07-29 | 安徽海汇金融投资集团有限公司 | Large data system |
| CN105787059A (en) * | 2016-02-29 | 2016-07-20 | 四川长虹电器股份有限公司 | Data warehouse based financial data integration method |
| CN106202527A (en) * | 2016-07-22 | 2016-12-07 | 浪潮电子信息产业股份有限公司 | General data warehouse construction method for mobile APP big data analysis |
| CN106874353A (en) * | 2016-12-28 | 2017-06-20 | 合肥智畅信息科技有限公司 | A kind of manipulation type business intelligence application system |
| CN107451151A (en) * | 2016-05-31 | 2017-12-08 | 北京京东尚科信息技术有限公司 | Data concentrating system and method based on distributed data source |
| CN107958048A (en) * | 2017-11-27 | 2018-04-24 | 安徽经邦软件技术有限公司 | A kind of multi-dimensions database system and implementation method based on financial data analysis |
| CN109871391A (en) * | 2019-01-09 | 2019-06-11 | 东莞联宝光电科技有限公司 | Utilize the method for Excel software retrospect packaging products in boxes |
| CN112668929A (en) * | 2021-01-08 | 2021-04-16 | 上海振华重工(集团)股份有限公司 | Production operation performance index system for automatic wharf and statistical method thereof |
| CN114595294A (en) * | 2022-03-11 | 2022-06-07 | 北京梦诚科技有限公司 | Data warehouse modeling and extracting method and system |
-
2006
- 2006-03-21 CN CNA200610024884XA patent/CN101042746A/en active Pending
Cited By (25)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101587477B (en) * | 2008-05-23 | 2012-10-31 | 阿里巴巴集团控股有限公司 | Method and system for automatically maintaining ETL modules |
| CN102246210A (en) * | 2008-12-15 | 2011-11-16 | 松下航空电子公司 | System and method for performing real-time data analysis |
| CN102246210B (en) * | 2008-12-15 | 2014-09-24 | 松下航空电子公司 | System and method for performing real-time data analysis |
| CN101694661B (en) * | 2009-10-22 | 2012-05-09 | 中兴通讯股份有限公司 | Method and device for generating statistical form and statistical server |
| CN102402733A (en) * | 2011-10-12 | 2012-04-04 | 远光软件股份有限公司 | Diversified electronic accounting file management system and method |
| CN102710455B (en) * | 2012-04-19 | 2015-08-19 | 华为技术有限公司 | Method, Apparatus and system that data are monitored in real time |
| CN102710455A (en) * | 2012-04-19 | 2012-10-03 | 华为技术有限公司 | Method, device and system for real time data monitoring |
| CN103679309A (en) * | 2012-09-13 | 2014-03-26 | 余明阳 | Intelligent statistical analysis method for power data warehouse services |
| CN103679309B (en) * | 2012-09-13 | 2017-11-03 | 国网湖北省电力公司 | A kind of electric power data warehouse business intelligence statistical analysis technique |
| CN103838788A (en) * | 2012-11-27 | 2014-06-04 | 大连灵动科技发展有限公司 | Data analyzing method based on fMRI brain activation data warehouse |
| CN103226570A (en) * | 2013-03-21 | 2013-07-31 | 江苏省电力公司泰州供电公司 | Real-time data report processing system based on OPEN3000 system database |
| CN103679383A (en) * | 2013-12-25 | 2014-03-26 | 武汉武船信息集成有限公司 | Method for establishing shipbuilding enterprise group management and control platform |
| CN104809110A (en) * | 2014-01-23 | 2015-07-29 | 安徽海汇金融投资集团有限公司 | Large data system |
| CN104376483B (en) * | 2014-12-10 | 2018-05-18 | 用友网络科技股份有限公司 | The apparatus and method that operation system is embedded in multidimensional analysis models |
| CN104376483A (en) * | 2014-12-10 | 2015-02-25 | 用友软件股份有限公司 | Device and method for inserting multi-dimensional analysis models into operation system |
| CN105787059A (en) * | 2016-02-29 | 2016-07-20 | 四川长虹电器股份有限公司 | Data warehouse based financial data integration method |
| CN107451151A (en) * | 2016-05-31 | 2017-12-08 | 北京京东尚科信息技术有限公司 | Data concentrating system and method based on distributed data source |
| CN106202527A (en) * | 2016-07-22 | 2016-12-07 | 浪潮电子信息产业股份有限公司 | General data warehouse construction method for mobile APP big data analysis |
| CN106874353A (en) * | 2016-12-28 | 2017-06-20 | 合肥智畅信息科技有限公司 | A kind of manipulation type business intelligence application system |
| CN107958048A (en) * | 2017-11-27 | 2018-04-24 | 安徽经邦软件技术有限公司 | A kind of multi-dimensions database system and implementation method based on financial data analysis |
| CN109871391A (en) * | 2019-01-09 | 2019-06-11 | 东莞联宝光电科技有限公司 | Utilize the method for Excel software retrospect packaging products in boxes |
| CN109871391B (en) * | 2019-01-09 | 2021-04-09 | 东莞联宝光电科技有限公司 | Method for tracing product boxing by using Excel software |
| CN112668929A (en) * | 2021-01-08 | 2021-04-16 | 上海振华重工(集团)股份有限公司 | Production operation performance index system for automatic wharf and statistical method thereof |
| CN112668929B (en) * | 2021-01-08 | 2023-12-22 | 上海振华重工(集团)股份有限公司 | Production operation performance index system for automatic wharf and statistical method thereof |
| CN114595294A (en) * | 2022-03-11 | 2022-06-07 | 北京梦诚科技有限公司 | Data warehouse modeling and extracting method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101042746A (en) | Container pier intellectualized report forms based on store house and method | |
| Garnsey et al. | Growth setbacks in new firms | |
| Bestelmeyer et al. | Desertification, land use, and the transformation of global drylands | |
| Ghenţa et al. | SMEs and the circular economy: From policy to difficulties encountered during implementation | |
| CN103577605A (en) | Data warehouse based on data fusion and data mining and application method of data warehouse | |
| CN102073712B (en) | Holographic process data archiving and inverting method based on dynamic change frame | |
| CN101071477A (en) | Financial analysis system and method based on expert system and nonlinear technology | |
| Zhen et al. | Capacitated closed-loop supply chain network design under uncertainty | |
| CN102473298A (en) | System and method for extracting representative feature | |
| Kopanakis et al. | Big Data in Data-driven innovation: The impact in enterprises’ performance | |
| CN113361559B (en) | Multi-mode data knowledge information extraction method based on deep-width combined neural network | |
| DE112016004924T5 (en) | System for excavating a user cycle mode and its method | |
| CN102724279B (en) | System for realizing log-saving and log-managing | |
| CN113849513A (en) | Data center operation and maintenance alarm information merging method and system | |
| Aldridge | High-frequency runs and flash-crash predictability | |
| CN104809110A (en) | Large data system | |
| Mital et al. | Robust material handling system design with standard deviation, variance and downside risk as risk measures | |
| Bowman | The life‐cycle dynamics of zombie companies amongst listed firms in China | |
| CN105260931A (en) | Financial service platform system based on MOT module | |
| CN108647288A (en) | Method for digging, device, computer equipment and the storage medium of business connection | |
| Gudfinnsson et al. | Tackling lack of motivation in aspirational analytics companies: SME examples from the manufacturing industry | |
| Stroiko et al. | Anti-crisis management as the basis of ensuring the economic stability of enterprises | |
| Islam et al. | BUSINESS ENGAGEMENT IN ADAPTATION TO CLIMATE CHANGE IN DEVELOPING COUNTRIES: A CASE STUDY BASED ON BEHAVIORAL PERSPECTIVE. | |
| Mulvaney | Energy and global production networks | |
| Shen et al. | Research on strategic pre-plan of enterprise crisis management in dynamic environment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20070926 |