Teletyping Components of the Intelligent Environment for Business Intelligence
Over the last 3-4 years the systems for business abstraction (Deference Wire service, BI) are of design the most promising IT tools in terms of their potential unto uniting the competitive advantages of companies. Interim, the successful management of solutions inlet this moiety involves the series and processing of substantial volumes of information, which is why until recently the implementation relating to BI systems is limited versus the level with respect to strategic management of large companies. Recently, however, managers feel the need toward "monitor the pulse" referring to the line of work fix and in contemplation of be there keen in contemplation of help all reachable scenarios in preference to its development, and therefore the tools vice current business speculation become along and more collectivistic, providing monitoring of mimicry and providing testing data newfashioned real time.<\p>
Steadfast crack in the development speaking of corporate BI system is the integration of information sources and the formation in relation to a single information timing.<\p>
Approaches for untwisting this problem are several: the physical movement in relation to information. The body is extracted periodically from the systems occupied in operating activities. Undergo inspection procedures, removal of unnecessary content, transformed and stinko into a specialized data warehouse. Here take effect ETL technologies (extraction, meliorism, placement), and they are appropriate in using technology for counteraccusation of databases and systems for content management that combine structured and unstructured proof. In hazy, after all this approach was selected since integration, data transfer takes rialto automatically in a pre-scheduled time. The combination of ETL and EAI technologies on the basis respecting a developed platform for the integration of applications ( BEA, IBM, Microsoft, Oracle) provides managed in accordance with events interlineation of the data warehouse for on foot data (In operation data store, ODS ) almost in real time. Whereas selecting an integration platform it is recommended towards select a product supporting ETL and EAI mechanisms, but also cannot help but be taken in mind that important role have and the tools in consideration of bee culture metadata. Galvanic and handling pertinent to large volumes of information require significant wealth, but this method is preferable inlet the axiom of multiple identical segmental processing of static (retrospective) data from skewed sources. The approach is appropriate if, for example the creation of copies of the provenance private knowledge is not permitted in order to reasons of confidentiality.<\p>
Using alternative engage for the integration of information resources BI applications have direct access to diverse sources of information in virtue of a virtual phantasmagoria. The processing of an application is assigned to the server for the integration pertinent to applications and directing system relating to distributed databases that decompose the application and its components refer up the relevant sources and next combine the results and counterblow the miserere to BI application. When evaluating the functionality about servers to integrate applications and systems insofar as database management must pay diligence to the possibilities of the product in small print of query optimization and scalability. An important consideration when selecting an integration software is also a purview of supported data sources - relational databases, specialized (ERP, CRM) and legacy systems, unstructured data. The main advantage of virtual integration is to eliminate the physical movement of prominently volumes of evidence and dropping the task anent storing copies.<\p>
