Oracle Communications Data Model

Oracle Communications Data Model 11.2.5

The Oracle corporation submitted at the beginning of 2012 the new version of Oracle Communications Data Model 11.2.5 which allows communication service providers to analyze different data types, including about income, clients, network performance and failures in network functioning, activation and provision of services.

As demand for information around the world grows, communication service providers face a problem of effective management of data. Clients even more often demand new services, and thereof, CSP providers need operational data analysis quickly to react to changes of conditions of business, rapid development of technologies and toughening of requirements of the legislation.

Oracle Communications Data Model as the key Oracle Exadata Intelligent Warehouse Solution for Communications component represents the ready data warehouse founded on standards from the database which is completely described by a logical structure. The solution supports the complex analysis of trends (trending) and deep data analysis (data mining) and provides a broad spectrum of dashboards. All these opportunities are intended for the solution of business challenges in telecom industry.

The new product provides communication service providers with information, important for business, such as behavioral models of use by subscribers of the network resources, indicators of average income counting on the subscriber (Average Revenue Per User, ARPU) which are not completed for various reasons orders and "reset" because of failures of the systems of phone calls and also performance indicators of marketing campaigns. All this information helps to reduce outflow of clients and to make more address and target offers.

"Communication service providers even more often face the problems connected with data management. Capability process and analyze data for adoption of the timely and considered solutions purchases crucial importance today. The new version of Oracle Communications Data Model 11.2.5 in combination with the Oracle Communications Network Charging and Control Adapter for Oracle Communications Data Model adapter provides to CSP providers analytical opportunities and the unified system which are necessary for them for achievement of optimum efficiency and notable economic advantages", – Liam Maxwell, the vice president for the products Oracle Communications noted.

According to developers, unlike the competing offers which are, as a rule, delivered in the form of expensive custom packets of professional services Oracle Communications Data Model is quickly unrolled, ready to use, easily expanded and updated software solution. It is certified by the industry non-profit association TM Forum developing and approving standards, recommendations and models for IT in a telecom.

New opportunities of Oracle Communications Data Model 11.2.5 include: support of all forms of information on perfect calls of the subscriber (CDR), including about the unprocessed, mediated, paid and unpaid calls and also support of detailed registration of events (EDR) and the IP addresses (IPDR); increase in quantity of logical objects to more than 1500 tables and 30,000 columns (columns). It will allow communication service providers to store and analyze more data, than ever before; new reports on order management and support of analytics for the solution Oracle Rapid Offer Design and Order Delivery; support for the system of the business analysis Oracle Business Intelligence Enterprise Edition 11.1.1.5 regarding generation of the reporting on mobile devices, such as iPhone and iPad.

For the purpose of reduction of time for deployment, decrease in integration expenses and risks and also support of the subsequent updates of Oracle also represents ready modules adapters "extraction, loadings and conversions" ("to extract, load and transform", ELT) for Oracle Communications Data Model. Version 11.2.5 contains the Oracle Communications Network Charging and Control Adapter for Oracle Communications Data Model adapter.

The industry-first ELT adapter optimized for a certain product and completely ready to work supports two modes of data loading – standard and operational (in real time). The adapter also contains data mapping forms for CDR, EDR and the balance sheet reporting of the subscriber.

"Today communication service providers often do not manage to apply analytics effectively. It is connected with difficulty of data acquisition from several sources and their organization in data models, suitable for use, – Larry Goldman, the partner and the head of researches of software products for a telecom in Analysys Mason company emphasized. – In the new version of Oracle provides the adapter which provides interaction of a management system, accounting and tariffing of services of the telecom operator with the analytical platform".

Improvements give to communication service providers the chance more effectively to process information on subscriber payments. It allows to provide (almost in real time) with the minimum delay data for the predictive analysis of potential outflow of the clients using both prepaid (prepaid), and the services paid upon (postpaid); data on average income counting on the subscriber (ARPU) and other statistical data about use of communication services. Besides, the built-in integration between Oracle Communications Data Model and the solution Oracle Communications Network Charging and Control unifies the analytical systems for communication service providers and helps to lower the time and finance costs connected with implementation of the corporate data warehouse.