CN100580662C - Heterogeneous report form integration and centralized management device and system - Google Patents
Heterogeneous report form integration and centralized management device and system Download PDFInfo
- Publication number
- CN100580662C CN100580662C CN200710308382A CN200710308382A CN100580662C CN 100580662 C CN100580662 C CN 100580662C CN 200710308382 A CN200710308382 A CN 200710308382A CN 200710308382 A CN200710308382 A CN 200710308382A CN 100580662 C CN100580662 C CN 100580662C
- Authority
- CN
- China
- Prior art keywords
- module
- management
- information
- engine
- user
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a device for heterogeneous statement integration and centralization of management. The device comprises: a statement application module, which is used for receiving the statement request of a user, completing the user-oriented displaying and management of various heterogeneous statements, and completing the control to the user authority; a fundamental management module, which is used for the uniform management on common fundamental function of each application module, and the completing of the corresponding common fundamental function by calling an engine module; a statement information management module, which is used for managing each statement information and common information in the system, and further helping the statement application module provide uniform normative statement display and management; and the engine module including a front-end tool engine and an information management engine, wherein, the engine module is called by the fundamental management module and the statement information management module; the front-end tool engine is used for supporting a plurality of various front-end tool statement integration interfaces; the information management engine is used for providing uniform information management function calling.
Description
Technical field
The present invention relates to technical field of computer information processing, particularly relate to the device and the system of a kind of heterogeneous report form integration and centralized management.
Background technology
Along with the development of infotech, a large enterprise may have a lot of infosystems, so the demand of the system integration just occurred: promptly need the inlet of these infosystems is integrated, and offer the user with uniform way; Described unification can have the unification of login process, as: land, customize, browse; Described unification also can comprise the unification at interface, as: the unification of display styles etc.
Concrete, for example in the financial field, along with the continuous development of each financial institution's business and carrying out in a deep going way of IT planning, increasing IT system is (such as ERPF, DW﹠amp; MIS, SMIS etc.) come into operation in succession, also have a lot of management information system to be in operation in addition, as CMIS or the like.All stored in these systems management information data a large amount of, and produced business diagnosis form separately.We can say, these systems have satisfied the service operation of business field and the needs of operation control separately with flying colors, but expose achievement data be difficult to share, be lack of consistency and system between form be difficult to problems such as integration, use and business diagnosis is made troubles to data.
And being on the increase along with system, the user need land different systems and go to obtain relevant information, and these systems are owing to adopted different front end BI (Business Intelligence, business intelligence) instrument or because the difference of exploitation custom, standard causes final information exhibition not the same at aspects such as look ﹠ feel, operating habits, the user faces continuous study, adapts to these management information system.And in fact user's real concern be the continuous accumulation and the precipitation of information, rather than the increase of various systems.Wherein, front end BI instrument generally is meant the software product that carries out information exhibition, analysis or excavation based on data warehouse or Data Mart, and BI instrument commonly used has Cognos, MicroStrategy (hereinafter to be referred as MSTR), BO etc.
In a word, the present situation of above-mentioned technology can cause following technical matters:
(1) form of different system administers and maintains separately, and the view that neither one is unified manages; And the user need land different systems and go to obtain information, lacks one and concentrates the environment of showing; Cause report data to be difficult to share, and be difficult to the concentrated user that shows.
(2) operating habit and the style of different BI instruments differ, and directly are exposed to the final user, and user's demand side is to learning different BI instruments; Cause user's service efficiency low.
Prior art is in order to address the above problem, and proposed employing Portal technology (have be translated as portal technology) and carried out the integrated of infosystem.Portal is an application program based on web, the presentation layer that it mainly provides the content integration of personalization, single-sign-on, separate sources and deposits infosystem.But the Portal technology generally is directly the form object to be connected on the Portal, this mode only can be used for integrated simple Interface Microstructure work (as the inlet of website respective services integrated etc.), can't relate to form interior business logic, be difficult to adapt to the integrated of complicated business infosystems such as financial institution.
In a word, need the urgent technical matters that solves of those skilled in the art to be exactly at present: a kind of heterogeneous report form integration of proposition that how can novelty and the solution of centralized management.
Summary of the invention
Technical matters to be solved by this invention provides the system and the device of a kind of heterogeneous report form integration and centralized management, can provide a tabular views overall situation, unified for user and supvr, integrate the operation interface and the style of each form, and can improve the access efficiency of system greatly.
In order to address the above problem, the invention discloses the device of a kind of heterogeneous report form integration and centralized management, comprising:
The form application module is used to receive user's form request, and user oriented is finished the displaying and the management of various heterogeneous report forms, and finishes the control to user right; Wherein, the management of form comprises the form issue and examines; Described form application module calls engine modules and finishes concrete data processing by basic management module and report messages administration module;
The basic management module is used for the public basic function of each application module is carried out unified management, and calls engine modules and finish corresponding public basic function; Described public basic function comprises that form is issued and examined, user right control;
The report messages administration module is used for each report messages and the public information of system are managed, thereby helps the form application module to provide the form of unified standard to show and management;
The engine modules that comprises front end tool engine and information management engine, described engine modules is called by described basic management module and report messages administration module; Described front end tool engine is used to support a plurality of different front end tool form integrated interfaces, and the information management function that described information management engine is used to provide unified calls.
Preferably, described device can also comprise: frame module is used for the running environment and the module management of system are provided support.
Preferably, described device can also comprise: the link information configuration module, be used for the annexation that each module of unified management relates to, and provide the connection of various data sources and the management of configuration information.
Preferably, described device can also comprise: flexible enquiry module is used to receive user's querying condition, and Query Result is provided;
At this moment,
Described report messages administration module also is used for providing search at various data sources by calling engine modules;
Described engine modules also comprises:
The SQL engine is used to provide SQL to generate and the calling function of relevant database;
The MDX engine is used to provide MDX to generate and the calling function of MDB;
The data processing engine is used for finishing data query, processing and encapsulation based on SQL engine and MDX engine.
Preferably, described device can also comprise: data typing module, be used to provide the data layout typing of being supported interface, and receive user's logging data and be stored to corresponding data source.
Preferably, described device can also comprise: the complex report forms module, be used to generate complex report forms, and to the issue of complex report forms, examine and browse, and to the control of authority of the form that generated; Described complex report forms comprises the form of Excel form.
Preferably, described device can also comprise: the information push module, be used to provide the active push of various information resources, and the propelling movement mode comprises mail or mobile device message.
Preferably, described device can also comprise: proxy module, be used to dispatch the operation of regular execution, and described operation comprises form, pushed information or the supervisory control system running situation of refreshing.
Preferably, described device can also comprise: the panel board module is used to provide the chart of information to show that described information comprises key index information; And the displaying that related news information is provided.
According to another embodiment of the present invention, the system of a kind of heterogeneous report form integration and centralized management is also disclosed, comprising:
A plurality of data servers are used to store all kinds of source datas;
A plurality of form application tools are used for generating corresponding separately form;
The report form integration device comprises:
Report query module, form are browsed module, statement analysis module;
Interface module is used for user's request is converted to corresponding form application tool or corresponding data server;
Engine modules is used for the sensing according to interface module, calls corresponding form application tool or corresponding data server, provides result data to report query module, form to browse module or statement analysis module.
Compared with prior art, the present invention has the following advantages:
The present invention studies in the business demand field the enterprise-level Report Server Management in design process, take out user's form visit behavior in service layer, be defined as the definition of form, the inquiry of form, the user interface that has been integrated is with demand unification to the inlet of user to each BI instrument form.In the query script of form, can satisfy retrieval to business factor in the form by the setup parameter item.Secondly, because the result that the server of general heterogeneous report form finally returns is a report file stream, so the present invention is provided with multiple application programming interfaces, one side is used for connecting each BI instrument, simultaneously is used to the access interface that provides unified.By above two aspects, i.e. the encapsulation of user interface and application programming interfaces has realized the ability of bi-directional expansion, and this just characteristics have been brought the integration of enterprise-level heterogeneous report form and the ability of centralized management to the present invention.
Adopt the present invention can avoid the enterprise customer to visit different systems and obtain form, and shield difference between the platform of different forms, reduce user's use complexity, improve the fast access ability of form.And can realize the unified management of enterprise's overall situation form, have problems such as complex management, form content repeat, the form content is conflicting between the form platform of avoiding disperseing, improve the trusting degree of user reporting system.The present invention can also provide multiple visit channel for the user, and the workload by functions such as task agent, automatic distribution minimizing user capture form makes part routine work robotization.
Description of drawings
Fig. 1 is the typical logical architecture figure that a kind of enterprise-level form of prior art is used;
Fig. 2 is the logical architecture figure of the system embodiment of a kind of heterogeneous report form integration of the present invention and centralized management;
Fig. 3 is the support figure of the present invention to other products or instrument;
Fig. 4 is a deployment way synoptic diagram of the present invention;
Fig. 5 is the structured flowchart of the device embodiment 1 of a kind of heterogeneous report form integration of the present invention and centralized management;
Fig. 6 is the structured flowchart of the device embodiment 2 of a kind of heterogeneous report form integration of the present invention and centralized management.
Embodiment
For above-mentioned purpose of the present invention, feature and advantage can be become apparent more, the present invention is further detailed explanation below in conjunction with the drawings and specific embodiments.
The present invention can describe in the general context of the computer executable instructions of being carried out by computing machine, for example program module.Usually, program module comprises the routine carrying out particular task or realize particular abstract, program, object, assembly, data structure or the like.Also can in distributed computing environment, put into practice the present invention, in these distributed computing environment, by by communication network connected teleprocessing equipment execute the task.In distributed computing environment, program module can be arranged in the local and remote computer-readable storage medium that comprises memory device.
With reference to Fig. 1, show the typical logical architecture that a kind of enterprise-level form of prior art is used.This framework mode is a kind of mode end to end, data are drawn into Data Mart from the basic data warehouse, after the processing of process BI instrument is converted to information, directly being published to front end represents, and between the BI instrument closely-coupled relation, the user need adapt to the feature and the present situation of BI instrument passively, and different system, the mode of operation of different B I instrument, operating habit have brought unnecessary learning cost to the user simultaneously; Moreover this mode is the mode that a kind of dispersion is dealt with problems, and that is to say, in order to adapt to user's needs, different systems can do some adaptability separately to the BI instrument and expand and satisfy the demand, and is unfavorable for reusing of function.
With reference to Fig. 2, show the embodiment of the system of a kind of heterogeneous report form integration of the present invention and centralized management, comprise with lower member:
A plurality of data servers are used to store all kinds of source datas; In Fig. 2, adopt Data Mart 201 and logic data model 202 expressions.
A plurality of form application tools 203 are used to obtain corresponding separately form; BI instrument shown in Fig. 2 comprises Cognos and MSTR or the like.
Report form integration device 204, with aforesaid data server and BI instrument the data annexation is arranged all, also report form integration device 204 is referred to as RIDE in the present invention, Reporting IntegratedDevelopment Environment, report set IDE.It specifically can comprise:
Report query module, form are browsed module, statement analysis module, and being used for representing 205 at front end provides function corresponding; Certainly, also may comprise other flogic system module, for example, risk monitoring and control module or panel board module (back has detailed introduction) or the like.In Fig. 2, adopt the module of flogic system service 2041 these classes of expression.
Interface module is used for user's request is converted to corresponding form application tool or corresponding data server; Promptly be used to realize with the data-interface of client layer and with the interface of BI instrument or Data Mart, in Fig. 2, adopt outside Connection Service 2042 signs.
From information consumption user's angle, the flow process of using said system is as follows:
1, after the user opens the form prompting device page (interface module), reads the option of report query by prompting device;
2, the user selects the query term of form prompting device, submits the form request then to;
3, engine modules is submitted in prompting device assembling user request;
4, the API of utility engines module invokes front end tool generates form, and the result is fed back to the form display module;
5, final user's reception result.
In Fig. 2, from the rear end to the front end process that information is produced, from the front end to the rear end user profile process of consumption, the two binding site is at RIDE, and the report messages that the information production run is produced by RIDE is published to and manages among the RIDE; Utilize the flogic system service function of RIDE simultaneously, according to the difference of the scope of business or user's request information is distributed to front end with the form of flogic system and represents.Front end among Fig. 2 represents and is used to represent mutual with client layer.
Like this, what the user faced no longer is different system and BI instruments, but the RIDE of consistent style and operating habit; Can concentrate solution in the RIDE link at the some shortcomings and the general character function of BI instrument simultaneously, be a kind of mode that initiatively adapts to user's request.Engine service by RIDE is carried out the BI instrument engine of various isomeries integrated, offer the unified use interface of user, make the existence of the imperceptible a plurality of isomery BI instruments of user, shielded the operating habit and the otherness of different B I instrument effectively, the show surroundings of style unanimity is provided for the user.
With reference to Fig. 3, show the support figure of the present invention to other products or instrument, promptly in order to guarantee the adaptability of RIDE under each environment, take into account other products and instrument, RIDE provides support more widely at aspects such as BI instrument, database, application server, operating systems to product or instrument, supports Cognos, MSTR etc. aspect the BI instrument; Database is supported Oracle, Informix and SQLServer etc.; The J2EE application server is supported WebLogic, Tomcat, WebSphere etc.; Operating system is supported IBM AIX, HP-UX, RedHat Linux, Windows or the like.
With reference to Fig. 4, show deployment way synoptic diagram of the present invention, among Fig. 4, the present invention is deployed in the J2EE application layer, between client and form application layer.By this deployment way, make that the deployment level of BI framework is very clear, reduce the degree of coupling physically, avoid influencing each other of difference in functionality zone; Make problem search and the location becomes and is more prone to, can carry out function optimization and Performance tuning at each layer; Have more extendability, can walk crosswise expansion according to the concrete condition of business, strengthened fault-tolerant ability and load balancing load-bearing capacity at different functional areas; Help making full use of of resource, needn't each flogic system all report server and the application server of Request For Disposition oneself separately, but in the unified deployed environment of trooping, share use.
With reference to Fig. 5, the device embodiment 1 of a kind of heterogeneous report form integration of the present invention and centralized management is shown, specifically can comprise:
Report messages administration module 503 is used for each report messages and the public information of system are managed, thereby helps form application module 501 to provide the form of unified standard to show and management;
The engine modules 504 that comprises front end tool engine 5041 and information management engine 5042, described engine modules 504 is called by described basic management module 502 and report messages administration module 503; Described front end tool engine 5041 is used to support a plurality of different front end tool form integrated interfaces, and the information management function that described information management engine 5042 is used to provide unified calls.
Embodiment 1 can provide general form form such as to show, issue, examine and use.Below each module among the embodiment 1 is carried out more detailed introduction again!
The form application module is called for short Reports module, is used to provide main flow front end product form is called support with common function, the form of various main flow front end productions can be carried out seamless integratedly, and provides the form organization and management function of multiple mode.Can issue form, browse form and download form by this module, and form be organized the control of authority, service authority and data permission.
Generally speaking, Reports module is based on front-end presentation tool, but can keep its functional independence.Reports module provides the support to main flow front-end presentation tool form, as Cognos, MicroStrategy etc.Use the form of different front-end presentation tool customizations, when in Reports module, showing, still can use its function that had originally, can not be affected.
Secondly, Reports module can be realized expansion, for example, meets the J2EE framework, and supports third party's report program (as the JSP form etc.) of the integrated standard of RIDE, can be integrated into fast equally to show in the Reports module and manage.The form adapter is that various types of forms are integrated into the key of going in the Reports module.This adapter is a socket, has defined the concrete grammar of these forms of seamless link in interface, and the user can realize these interfaces according to the actual needs of oneself, and registration realizes in system management then, so just can come in the form of oneself is integrated.
In a word, Reports module is in the displaying aspect, and the form that various front-end presentation tools can be made and third party's form carry out seamless integrated, makes the existence of the imperceptible a plurality of heterogeneous systems of user, and can retrieve, get access to own needed form fast.
Preferably, Reports module can also carry out personal management to the user.Be that the user can utilize Reports module to carry out the customization of personalized report interface style.The user can create, manage the collection of oneself, own interested resource added in the favorites folder in the mode of creating shortcut, and can be to these resources managing, organizing effectively.
The basic management module is the module of the public basic function of each module among the present invention being carried out unified management, is mainly used in to finish unified data configuration function.These utility functions comprise form issue, examine, the definition of user, role, authority, module, and system log management and authority are synchronous or the like.
The basic management module is carried out unified management and execution to the public basic function of each module of RIDE, includes: the Unified Identity checking; Unified licensing scheme; Unified data access; The unified tracking reviewed; Unified user entry etc.Because can carry out unified management to each module of system, the user can find own needed function fast and efficiently, or obtains resource needed, collects, manages and organize interested resource.For example, unified authenticating user identification can guarantee that the user mutually switches and need not login again between different flogic system (at the independent information display module or the zone of different user).
The concrete management function that the basic management module may be finished can comprise:
Report Server Management
(1) form with the outside is published to Integrated Development Environment, may write down it in the time of issue: resource name, resource description, the Cube that quotes, resource type, source resource, resource are deposited information such as approach, form platform catalogue, resource approver, report parameter masterplate.
(2) can the allocated resource approver in issue, behind the so appointed logging in system by user, just can examine this resource, the result who examines comprises formal issue, returns modification etc.
(3) resource is upgraded, walked approval process after the renewal again.
(4) according to user's authority, provide to comprise newly-built form sub-directory, directory attribute is set, the form attribute is set, operating resource, check form, arrange resource that form is searched, authority such as checks at a series of Report Server Management.
User authority management
Definition by user, role, authority, module is with She Ge, for the user of different institutions, different levels be provided with different role ， She Ge different organize authority, service authority and data permission.
System resource management
The management front end tool, relevant database/MDB data source connects, and perhaps meets the RIDE related specifications and by third party's program of RIDE unified management, as third party's program of B/S pattern.
Certainly, in preferred embodiments more of the present invention, the basic management module can also comprise other management functions, for example: system log management, authority synchronously, parameter management, news management etc.
Report messages administration module 503
The report messages administration module provides unified management to the information of RIDE the inside each side, makes things convenient for the user to carry out searching and obtaining of the information content.For example, in the preferred case, the report messages administration module can provide powerful function of search, supports to search classifiably, searches for generally, precise search, provides strong means for the user carries out the RIDE information content.The report messages administration module can be to the various types of information sources of RIDE, comprise that the form of different application customization, the form even the unstructured information of different front end tools manage, the functions such as classification, search of information are provided, thereby reach the target of information management and user's service.
The Engine module is the RIDE core services module, and calling of relevant database and BI instrument is provided, and is the basis of other each module.
In development environment Engine module, each Engine takes modular design, guarantees that each Engine can assemble separately and dismantle among the RIDE, does not influence between mutually, guarantees the stability and the robustness of system.Development environment Engine module is carried out the Engine of various isomeries seamless integrated, offers the unified use interface of user, makes the existence of the imperceptible a plurality of isomery Engine of user.
In embodiment 1, the Engine module can comprise front end tool Engine and information management Engine.Wherein, front end tool Engine is used to support different front end tool forms to be integrated into the interface of RIDE.Information management Engine is used for providing unified information management function to call to the different information contents.
With reference to Fig. 6, show the device embodiment 2 of a kind of heterogeneous report form integration of the present invention and centralized management, on embodiment illustrated in fig. 51 basis, specifically can also comprise: frame module is used for the running environment and the module management of system are provided support.
Development environment Framework module is the RIDE core services module, and running environment, module management and flogic system assembling are provided support.Based on the Framework module, the developer can dispose or delete a third party's program or a resource based on the integrated standard of RIDE easily, and don't has influence on other module of RIDE system.
Development environment Framework module is used to embody the integrated standard of RIDE, can provide a cover sane standardization, modularization program; The data support and the container service of various interface elements, interface elements are provided; The support of basic functions such as unified login, authority, system management, menu configuration and operation support is provided; Support to create and dispose one or more flogic systems.
Based on development environment Framework module, the user can convenient, fastly create and dispose one or more flogic systems, this flogic system is visible, system independently for the user, each flogic system can have look ﹠ feel and the system manager of oneself, flogic system is by the unified management of Framework module, and different flogic systems is transparent at super keeper.
Flogic system is the key concept of RIDE, the module of RIDE itself, function, menu etc. all are to carry out registration management by himself framework, super keeper can carry out the assembling of difference in functionality according to user's needs, produce different flogic systems, each flogic system can have role-security system, management function, application function of oneself etc.
In another preferred embodiment of the present invention, can also comprise: the link information configuration module, be used for the annexation that each module of unified management relates to, provide the connection of various data sources and the management of configuration information.The link information configuration module provides relational database, BI instrument and FTP etc. is connected and the management of configuration information, guarantees that RIDE has good access interface and extensibility.
RIDE is the basis that RIDE and other system are set up contact by the dissimilar connection that each module of link information configuration module unified management RIDE may relate to.By the link information configuration module, other modules of RIDE do not need the different link information of management separately, that is to say and had after the link information configuration module, each module of RIDE has really been accomplished isolation professional and that technology realizes, reduce development difficulty and risk, also improved the reusability between each module of RIDE.
RIDE is integrated with the information from business datum source, self data bank data source, front-end presentation tool, FTP even file path aspect.Loose coupling by between link information configuration module and the concrete operation system makes dilatancy obtain effective assurance, guarantees dirigibility and the robustness of RIDE in follow-up use and secondary development process.
The link information configuration module specifically can be finished following function:
The FTP address configuration information of management RIDE: the address of configuration and management ftp server, the FTP address will be used by proxy module (back can be introduced in detail) as the subscriber of FTP type, makes the publication that operation generated of RIDE can be pushed to this type of subscriber.
The relational data source of management RIDE: provide unified, support the relational data power management function of multi-user concurrent operation, carry out specific operations such as data query thereby be used for the connection that modules such as basic management, inquiry flexibly, complex report forms obtain data source.
The BI instrument of management RIDE connects: various types of BI instrument resources that management RIDE uses, for example COGNOS server, electronics account table, MicroStragy server etc., Reports module can be obtained the tabulation and the issue form of form from the report server that defines.
The file path of management RIDE: the file path information on the definition RIDE server, file path will be used by proxy module as the subscriber of file path type, thus the target of the publication that generates as the RIDE operation pushes the address.
In another preferred embodiment of the present invention, can also comprise: flexible enquiry module is used to receive user's querying condition, and Query Result is provided;
At this moment,
Described report messages administration module also is used for providing search at various data sources by calling engine modules;
Described engine modules also comprises:
The SQL engine is used to provide SQL (Structured Query Language (SQL): the calling function of generation and relevant database Structured Query Language);
The MDX engine is used to provide MDX (Multidimensional Expressions: the calling function of generation and MDB MultiDimension Expression); The MDB file is a kind of file layout, the Access database file.
The data processing engine is used for finishing data query, processing and encapsulation based on SQL engine and MDX engine.
In the preferred case, described engine modules can also comprise workflow Engine: provide unified workflow functionality to call to various workflow operations among the RIDE.
Flexible enquiry module
Provide User Defined querying condition and index to inquire about flexibly, and browsing or downloading of Query Result is provided; Inquiry to the user provides the management of organizing authority, service authority and data permission etc. control.Enquiry module is served information self-service consumer and information provider flexibly.
Enquiry module is supported the relevant database and the multi-dimensional database of main flow flexibly, as Oracle, Informix etc.Flexibly enquiry module provide flexibly, friendly, powerful graphical operation interface, help the user definition querying condition and inquire about index.The user is in the process of inquiry, and the result who feeds back according to inquiry can constantly adjust its querying condition and index.Flexibly the result of inquiry can be scheme, table, or the pattern that chart mixes carries out data display, and support report file form commonly used to export, as exporting with file layouts such as Excel, PDF, HTML.
Enquiry module generally can be finished following concrete function flexibly:
Relevant database is inquired about flexibly
Provide the unified flexible query interface of SQL to relevant database, the user can import self-defining SQL query statement, and enquiry module also offers the auxiliary interface that the user generates SQL flexibly.Relevant database is supported Oracle, the Informix etc. of main flow.
MDB inquires about flexibly
Provide the unified flexible query interface of MDX to MDB, the user can import self-defining MDX query statement, and enquiry module also offers the auxiliary interface that the user generates MDX flexibly.MDB inquires about the olap server of supporting main flow flexibly.
The data secondary treating
Enquiry module can be to carrying out secondary computing processing from the data of a plurality of Data Sources flexibly.Flexibly enquiry module has the complete query-defined flow process of a cover, can self-defined calculated column, can carry out on year-on-year basis, analyses such as preceding ratio, total.The mixing that represents various informativeization: figure, table or chart of data etc.
In another preferred embodiment of the present invention, can also comprise: the complex report forms module, be used to generate complex report forms, to the issue of complex report forms, examine and browse, and to the control of authority of the form that generated; Described complex report forms comprises the form of Excel form.
The complex report forms module
The function that generates form by Excel statement form masterplate is provided, and provide complex report forms issue, examine and function of browse; The control of authority, service authority and data permission is organized in support to the form that generates.Serve intermediate information consumer, information self-service consumer and general information consumer.
The complex report forms template uses " markup language " to extract data automatically from different data sources.Data source is supported the relevant database of main flow, as Oracle, Informix etc.The complex report forms module provides markup language, makes things convenient for the user definition form, and markup language can be expanded by function or storing process.The complex report forms template just once defines and can reuse, and the form that generates directly just can use, and need not spend more time, human and material resources make a return journey manual statistics, work out the Excel form, improved employee's work efficiency greatly.
The complex report forms template generally can be finished following concrete function:
Can specify Excel report template customization complex report forms
The complex report forms module uses the mode of User Defined Excel Reports module to set up the Excel complex report forms, also can use the outside Excel report form template that imports.
Markup language
The user can use " markup language " to define in advance in the complex report forms module needs return data, and markup language can be returned a multirow, multi-column data collection from data source, and can be expanded voluntarily by the user by function or storing process.By different units lattice corresponding markup language and parameter are set, just can obtain the cell that data are filled the Excel complex report forms in one or more relational datas source from the backstage to Excel complex report forms template.
Can generate form in batches according to different querying conditions
After the user sets the complex report forms template, can pass to RIDE complex report forms module on line.When this complex report forms of user inquiring, according to the querying condition of user's input, template is resolved by RIDE complex report forms module, generate corresponding form in batches.
Online treatment
Measured B/S architecture realizes the online report file of uploading, download masterplate, parsing masterplate, download generation.The dynamic connection pool of having realized the User Defined data source loads, and can support the concurrent parse operation of a large number of users.
Can and represent function in conjunction with the powerful data statistics of Excel self
The user also can utilize the powerful data statistics of Excel self and represent function, and Excel complex report forms template is carried out secondary processing, to generate more powerful Excel electronic report forms.
Need to prove, in the process that generates form, dual mode is arranged, a kind of is to be that unit generates form with an independent grid, another be whole report generation once, the former is the most flexible, can realize all report querys in theory, but inefficiency is the main way of realization of present domestic Chinese style form; The latter is handling existence limitation on the Chinese style form, but the efficient height is the main implementation of external report tool.Complex report forms module of the present invention can be a plurality of sublists (promptly being divided into a plurality of zones) with a form cutting, each zone generates once, contain above two kinds of implementations on the function, when each grid all is considered as a sublist, be equal to first kind of mode on handling so, if whole form can be divided into single table, processing mode just is equal to second kind of form so.But dual mode commonly used at present, the realization of the complex report forms of RIDE are comparatively complicated, but have optional more flexibly leeway-promptly can accept or reject in dirigibility and performance.
In another preferred embodiment of the present invention, can also comprise: data typing module, be used to provide the data layout typing of being supported interface, receive user's logging data and be stored to corresponding data source.
Data typing module provides replenishing and input function of data, is the strong guarantee of data integrity, consistance, validity; And provide the control of organizing authority, service authority and data permission to logging data.Serve the data typing personnel of all departments, each mechanism.
The data source of data typing module is supported the relevant database of main flow, as Oracle, Informix etc.To needing the batch data record of typing, the data layout typing interface of main flow is provided, as text, Excel or XML, guarantee data typing fast and accurately.Preferably, system can also provide special data input interface, guarantees the accuracy and the high-level efficiency of user's input.For the data of typing failure, the user also can check its error message.
Data typing module specifically can be finished some following functions:
The data typing
Data typing module provides special data input interface.For the batch data record that needs typing, data typing module then provides the data layout typing interface of main flow.Operations such as data typing module also can be deleted the data of typing, modification.
The data audit
After the intact data of user's typing, the user that data typing module can be submitted to the data of typing authority carries out strict audit and issue.
In another preferred embodiment of the present invention, can also comprise: the information push module, be used to provide the active push of various information resources, the propelling movement mode comprises mail or mobile device message.
The present invention may design the vast as the open sea information resources of financial institution's various aspects, the information push module can be required with information consumer, or initiatively be pushed to information consumer by its customized up-to-date information, be different from traditional reporting system passive access, passive query, can make the user understand up-to-date form report information at any time.The information push module can send to the user with up-to-date information by Mail or mobile phone short message.User even can land RIDE and carry out information searching just can finish the process that information is obtained, consumed, and the guiding user uses RIDE, helps promoting the use of of RIDE.
The information push module can adopt subscribing mode: for example the subscription of up-to-date information and self-defined information are subscribed to.Also can adopt the propelling movement mode: for example be pushed to mail or mobile device.
In another preferred embodiment of the present invention, can also comprise: proxy module, be used to dispatch the operation of regular execution, described operation comprises form, pushed information or the supervisory control system running situation of refreshing.Promptly replace manually finishing automatically certain operation.
Proxy module is a basic public module that is embedded among the RIDE, and the function of operation execution, job scheduling management is provided.Proxy module can be dispatched the operation of regular execution, and the problem that taken place of reporting system registrar server, for RIDE provides the robotization service.
Proxy module specifically can be finished some following functions:
Automatically perform the Report Server Management task
Proxy module helps or replaces the user to carry out form operation or Report Server Management task, for example periodic refreshing form etc.By in conjunction with Reports module, complex report forms module, basic information module, information push module, can produce abundant information service mode, for example can carry out organizing services such as sending the form report regularly for certain user or user by modes such as Email, SMS.
Monitoring RIDE operation
The system manager can also be by the system monitoring time interval that is provided with, and monitoring RIDE ruuning situation in time excites abnormality alarm.
In another preferred embodiment of the present invention, can also comprise: the panel board module is used to provide the chart of information to show that described information comprises key index information; And the displaying that related news information is provided.
The panel board module is used for the key index information with bank, with succinctly, panel board figure surface and interface intuitively, vivid, lively report information feeds back to the leader of financial institution, is fit to very much the user and understands financial institution's integral macroscopic information at a glance.Except the panel board chart, also can support multiple figure table schema: pie chart, trend map, post figure, calcspar, curve map etc.
The panel board module specifically can be finished some following functions:
News is showed
The issue of domestic and international or financial industry grave news or information is provided.The exposition news content can be clicked by the user and open link, browses complete news.
Data display
Provide the displaying of significant data, each module latest data preview.From database, extract up-to-date, most important data, carry out the chart preview, and can directly enter operation interface for the user.
MyEIS assistant
MyEIS is the function of the service of property one by one in the panel board module, for the user provide personalized, easily, can and system carry out interactive individual assistant.For example, user's authority is analyzed, in time the user is concerned about that functional module carries out mark; Operating habit to the user is analyzed; Module clicking rate to the user is analyzed, and the plate that the user is concerned about most carries out grade classification, and is user-friendly; Can be by back-stage management, self-defined MyEIS function.
Information indicating
The prompting of personal information state, alliance, important information prompting, personal work prompting (as form to be browsed, browsed form) or the like.
Certainly, the panel board module also for example can also have some subsidiary functions, and the function that jumps to other module of RIDE fast is provided to the user; Provide feedback or the evaluation of user to submit channel or the like to each exhibition information in the panel board module.
The present invention can well serve the enterprise-level form and use, the enterprise-level form is used and is meant that generally use enterprise-level BI instrument carries out the form application of the exploitation of form in enormous quantities, generation, management, and highlight high concurrency, high availability under the enterprise-level environment, can safeguard and manageability, simultaneously, role's complexity of mass data, magnanimity form, region dispersion, user group huge (generally in hundreds thousand of), system user also is the emphasis of its concern.In the complex environment of enterprise-level, often have to take multiple front end tool to satisfy demand under the specific environment, the management of multiple front end environment realization form will be used to the user and make troubles, as use different style etc., also increased simultaneously the complicacy of application architecture in this, the complicated network relation that often has multi-to-multi between user and the reporting system must cause the reduction of system's use value under this situation.
Enterprise-level heterogeneous report form integration technology of the present invention can overcome the deficiency of above traditional scheme, not only can organically be integrated into user and supvr to the enterprise-level form overall situation is provided, unified tabular views, and the single access module that provides for the final user, in this simultaneously, the hierarchical design that system design is adopted, the design concept of flexible configuration, the particularly introducing of flogic system, not only saved cost of developing greatly, but also for the work such as operation maintenance after going into operation provide cost savings, in the integrated process of newly-increased form near zero cost.
Each embodiment in this instructions all adopts the mode of going forward one by one to describe, and what each embodiment stressed all is and the difference of other embodiment that identical similar part is mutually referring to getting final product between each embodiment.
More than to the device and the system of a kind of heterogeneous report form integration provided by the present invention and centralized management, be described in detail, used specific case herein principle of the present invention and embodiment are set forth, the explanation of above embodiment just is used for helping to understand method of the present invention and core concept thereof; Simultaneously, for one of ordinary skill in the art, according to thought of the present invention, the part that all can change in specific embodiments and applications, in sum, this description should not be construed as limitation of the present invention.
Claims (9)
1, the device of a kind of heterogeneous report form integration and centralized management is characterized in that, comprising:
The form application module is used to receive user's form request, and user oriented is finished the displaying and the management of various heterogeneous report forms, and finishes the control to user right; Wherein, the management of form comprises the form issue and examines; Described form application module calls engine modules and finishes concrete data processing by basic management module and report messages administration module;
The basic management module is used for the public basic function of each application module is carried out unified management, and calls engine modules and finish corresponding public basic function; Described public basic function comprises that form is issued and examined, user right control;
The report messages administration module is used for each report messages and the public information of system are managed, thereby helps the form application module to provide the form of unified standard to show and management;
The engine modules that comprises front end tool engine and information management engine, described engine modules is called by described basic management module and report messages administration module; Described front end tool engine is used to support a plurality of different front end tool form integrated interfaces, and the information management function that described information management engine is used to provide unified calls.
2, device as claimed in claim 1 is characterized in that, also comprises:
Frame module is used for the running environment and the module management of system are provided support.
3, device as claimed in claim 1 is characterized in that, also comprises:
The link information configuration module is used for the annexation that each module of unified management relates to, and provides the connection of various data sources and the management of configuration information.
4, device as claimed in claim 1 is characterized in that, also comprises:
Enquiry module is used to receive user's querying condition, and Query Result is provided flexibly;
At this moment,
Described report messages administration module also is used for providing search at various data sources by calling engine modules;
Described engine modules also comprises:
The SQL engine is used to provide SQL to generate and the calling function of relevant database;
The MDX engine is used to provide MDX to generate and the calling function of MDB;
The data processing engine is used for finishing data query, processing and encapsulation based on SQL engine and MDX engine.
5, device as claimed in claim 1 is characterized in that, also comprises:
Data typing module is used to provide the data layout typing of being supported interface, receives user's logging data and is stored to corresponding data source.
6, device as claimed in claim 1 is characterized in that, also comprises:
The complex report forms module is used to generate complex report forms, to the issue of complex report forms, examine and browse, and to the control of authority of the form that generated; Described complex report forms comprises the form of Excel form.
7, device as claimed in claim 1 is characterized in that, also comprises:
The information push module is used to provide the active push of various information resources, and the propelling movement mode comprises mail or mobile device message.
8, device as claimed in claim 1 is characterized in that, also comprises:
Proxy module is used to dispatch the operation of regular execution, and described operation comprises form, pushed information or the supervisory control system running situation of refreshing.
9, device as claimed in claim 1 is characterized in that, also comprises:
The panel board module is used to provide the chart of information to show that described information comprises key index information; And the displaying that related news information is provided.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200710308382A CN100580662C (en) | 2007-12-29 | 2007-12-29 | Heterogeneous report form integration and centralized management device and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200710308382A CN100580662C (en) | 2007-12-29 | 2007-12-29 | Heterogeneous report form integration and centralized management device and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101216817A CN101216817A (en) | 2008-07-09 |
| CN100580662C true CN100580662C (en) | 2010-01-13 |
Family
ID=39623250
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200710308382A Active CN100580662C (en) | 2007-12-29 | 2007-12-29 | Heterogeneous report form integration and centralized management device and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100580662C (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| TWI802794B (en) * | 2020-04-29 | 2023-05-21 | 臺灣銀行股份有限公司 | Financial business review integration system and method thereof |
Families Citing this family (41)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101345758B (en) * | 2008-08-14 | 2012-09-05 | 中兴通讯股份有限公司 | Report normalization processing method, apparatus and system |
| CN101930443B (en) * | 2009-06-22 | 2012-12-19 | 金蝶软件（中国）有限公司 | Data service system and data service realization method |
| CN105701187B (en) * | 2010-08-13 | 2019-04-26 | 北京环球国广媒体科技有限公司 | Process integrated service device and the method for realizing system combination using it |
| CN105701188B (en) * | 2010-08-13 | 2019-04-26 | 重庆软维科技有限公司 | Process integrated service device and the method for realizing system combination using it |
| CN102467494A (en) * | 2010-11-19 | 2012-05-23 | 金蝶软件（中国）有限公司 | Discrete report processing method and device |
| CN102739692A (en) * | 2011-03-31 | 2012-10-17 | 新奥特（北京）视频技术有限公司 | Method and apparatus for uploading reports used in sports event information system |
| CN102436372B (en) * | 2011-08-31 | 2014-07-02 | 中国运载火箭技术研究院 | Monitoring table generation system |
| CN102509163A (en) * | 2011-11-21 | 2012-06-20 | 山东浪潮齐鲁软件产业股份有限公司 | Realization method for unified management and centralized check of enterprise report |
| CN103136621B (en) * | 2011-11-29 | 2016-01-27 | 北京建龙重工集团有限公司 | Engineering is submitted to a higher level for approval or revision the online management method of auditing flow of list |
| CN102629262A (en) * | 2012-03-02 | 2012-08-08 | 浪潮集团山东通用软件有限公司 | Method for customization of BI demonstration model |
| CN102663024A (en) * | 2012-03-22 | 2012-09-12 | 北京英孚斯迈特信息技术有限公司 | Data portal system for enterprise data unified platform |
| CN102799651B (en) * | 2012-06-28 | 2015-01-21 | 用友软件股份有限公司 | Query processing device and method |
| CN102867067A (en) * | 2012-09-28 | 2013-01-09 | 用友软件股份有限公司 | Device and method for data integration processing for heterogenous system |
| CN103838706A (en) * | 2012-11-22 | 2014-06-04 | 江苏现代造船技术有限公司 | Flexible management information system with process and form customization function |
| CN103530394A (en) * | 2013-10-22 | 2014-01-22 | 金蝶软件（中国）有限公司 | Method and device for report data expansion |
| CN103699644A (en) * | 2013-12-25 | 2014-04-02 | 深圳市盈富在线信息科技有限公司 | Information release method, information release system and user terminal |
| CN103840969A (en) * | 2014-01-20 | 2014-06-04 | 浪潮(北京)电子信息产业有限公司 | Alarm log management method and system in cloud computing system |
| CN103929477B (en) * | 2014-03-31 | 2017-09-19 | 国网山东省电力公司 | Without coupling integration analogy method and system between system based on Http agreements |
| CN103927378B (en) * | 2014-04-29 | 2017-04-12 | 智业软件股份有限公司 | Automatic positioning and early-warning method of problem data of report output results |
| CN104123346B (en) * | 2014-07-02 | 2017-10-20 | 广东电网公司信息中心 | A kind of structured data search method |
| CN104240126A (en) * | 2014-09-05 | 2014-12-24 | 宁波和佳软件技术有限公司 | Financial service managing system based on service supporting system and establishing method thereof |
| CN104376415B (en) * | 2014-11-17 | 2018-01-12 | 南通中远船务工程有限公司 | Cable volume management system |
| CN104317660B (en) * | 2014-11-18 | 2017-12-12 | 中国建设银行股份有限公司 | A kind of bank's parameter management system |
| CN106484665A (en) * | 2015-08-28 | 2017-03-08 | 上海新宇箴诚电控科技有限公司 | Assembling record PDF auto report completing method based on LabVIEW |
| CN105243533A (en) * | 2015-09-22 | 2016-01-13 | 武汉达策信息技术有限公司 | Unified publishing platform and method for various types of reports |
| CN105740328B (en) * | 2016-01-21 | 2020-01-31 | 中国建设银行股份有限公司 | method for generating bank protection report |
| CN106779994A (en) * | 2016-12-05 | 2017-05-31 | 深圳市中润四方信息技术有限公司 | A kind of tax-related service based on intelligent terminal handles method and its system and equipment |
| CN108282506A (en) * | 2017-01-06 | 2018-07-13 | 阿里巴巴集团控股有限公司 | A kind of method, apparatus that realizing business intelligence and mobile terminal |
| CN110019109B (en) * | 2017-07-12 | 2021-05-25 | 北京京东尚科信息技术有限公司 | Method and apparatus for processing data warehouse data |
| CN107480223B (en) * | 2017-08-02 | 2020-12-01 | 北京五八信息技术有限公司 | Searching method, searching device and storage medium |
| CN108255967B (en) * | 2017-12-26 | 2021-03-02 | 平安科技（深圳）有限公司 | Method and device for calling storage process, storage medium and terminal |
| CN108681674B (en) * | 2018-04-23 | 2022-02-01 | 平安科技（深圳）有限公司 | Report module creating method and device, computer device and storage medium |
| CN109871406B (en) * | 2018-12-28 | 2023-06-20 | 北京云杉信息技术有限公司 | Design method of general monitoring report platform |
| CN111831964A (en) * | 2019-04-10 | 2020-10-27 | 阿里巴巴集团控股有限公司 | Data report information processing method and device and computer system |
| CN110555200A (en) * | 2019-09-05 | 2019-12-10 | 北京思维造物信息科技股份有限公司 | report publishing method, device and equipment |
| CN111177177B (en) * | 2019-12-02 | 2023-06-16 | 国网吉林省电力有限公司吉林供电公司 | Automatic reporting system based on multi-source heterogeneous data fusion and method thereof |
| CN111177755A (en) * | 2019-12-25 | 2020-05-19 | 平安医疗健康管理股份有限公司 | Method and device for processing data permission in report application, computer equipment and computer storage medium |
| CN111767117B (en) * | 2020-06-22 | 2024-02-20 | 中兴智慧(北京)技术有限公司 | Mobile end BI middleware technology based on application container |
| CN112035568A (en) * | 2020-09-04 | 2020-12-04 | 银川安翰互联网医院有限公司 | Data list display method, client, server and system |
| CN113590241B (en) * | 2021-06-22 | 2023-06-16 | 青岛海尔科技有限公司 | Visual billboard display method and device, storage medium and electronic device |
| CN114116747B (en) * | 2021-11-25 | 2023-03-24 | 北京力控元通科技有限公司 | Production execution system data analysis method and device |
-
2007
- 2007-12-29 CN CN200710308382A patent/CN100580662C/en active Active
Non-Patent Citations (5)
| Title |
|---|
| . . |
| A Service-oriented Architecture for Business Intelligence. Liya Wu等.Service-Oriented Computing and Applications, 2007. SOCA '07. IEEE International Conference on. 2007 |
| A Service-oriented Architecture for Business Intelligence. Liya Wu等.Service-Oriented Computing and Applications,2007.SOCA'07.IEEE International Conference on. 2007 * |
| 数据仓库基础. 段云峰等，199-200,222-223,542-543，电子工业出版社. 2004 |
| 数据仓库基础. 段云峰等，199-200,222-223,542-543，电子工业出版社. 2004 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| TWI802794B (en) * | 2020-04-29 | 2023-05-21 | 臺灣銀行股份有限公司 | Financial business review integration system and method thereof |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101216817A (en) | 2008-07-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN100580662C (en) | Heterogeneous report form integration and centralized management device and system | |
| US8176083B2 (en) | Generic data object mapping agent | |
| US7673282B2 (en) | Enterprise information unification | |
| US7984417B2 (en) | Meta-model information associated with an enterprise portal | |
| US8412549B2 (en) | Analyzing business data for planning applications | |
| US8296311B2 (en) | Solution search for software support | |
| US8548938B2 (en) | Business rules for configurable metamodels and enterprise impact analysis | |
| US8478616B2 (en) | Business application development and execution environment | |
| CN102567539B (en) | Intelligent WEB report implementation method and intelligent WEB report implementation system | |
| US20090222749A1 (en) | Apparatus and method for automated creation and update of a web service application | |
| CN101329629B (en) | Business level method, apparatus and system for managing service information | |
| CN102687143A (en) | A method and system for implenting definable actions | |
| US7574689B2 (en) | Generic interface to provide object access display views based on object type | |
| US7099727B2 (en) | Knowledge repository system for computing devices | |
| US7818328B2 (en) | API for obtaining unambiguous representation of objects in a relational database | |
| CN108228762B (en) | Method and system for configuring master database universal templates | |
| Staudt et al. | The role of metadata for data warehousing | |
| Brambilla et al. | Model-driven design of service-enabled web applications | |
| US20060041623A1 (en) | Method and system to trigger an activity associated with a user interface element on a web page | |
| CN104699814A (en) | Searching method and system of hot spot information | |
| Browne et al. | IBM Cognos Business Intelligence V10. 1 Handbook | |
| Schneider | SAP Business ByDesign Studio: Application Development | |
| US20070136367A1 (en) | Methods and apparatus for dynamically modifying a business object definition | |
| US10607239B2 (en) | Enterprise evaluation using structured data | |
| Heilig et al. | SAP NetWeaver: The Official Guide |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |