REVIEWER: Limor Malay, DW and ERP division manager for Partner Communications Company Ltd.
BACKGROUND: Partner Communications Company Ltd. is a leading Israeli mobile GSM communications operator, with millions of subscribers. It is part of the Hutchison Whampoa Limited multinational conglomerate.
PLATFORMS: BusinessObjects 5.X, 6.X using client, Web and broadcast agents on Sun Enterprise and Oracle 9i database.
PROBLEM SOLVED: Our data warehouse is more then 20 terabytes in size, supporting more then 1,000 enterprise users, with as many as 5,000 reports running daily. Due to usage increase and data growth, achieving service levels has become a major concern. Response time of selective business reports has quickly deteriorated, causing user frustration and hurting decision-making. With quick and easy installation, ActiveKnowledge from ActiveBase improved long-running business reports by 10 times (from an average of 1.5 hours to less then 10 minutes). These savings resulted in profound overall data warehouse performance improvement and increased server capacity. ActiveKnowledge enables users to run the reports several times a day, which has made a substantial impact on our visibility into the business and our ability to make decisions based on up-to-date information.
PRODUCT FUNCTIONALITY: ActiveBase is centrally and transparently installed on the database server, acting as the Oracle database listener. It has the ability to identify, audit and manage problematic statements submitted in real time to our databases according to their client information, SQL syntax, time of day, timely database load and to explain plan patterns. ActiveBase applies performance policies to incoming statements on the fly by adding hints, rewriting the statements or offloading during peak times until needed resources are available. For example, a performance optimization policy adds hints based on partial execution plan matching. Queries doing PARTITION RANGE ALL while accessing through a primary key index are identified by a single policy by matching part of the execution plan and corrected by adding a NO_INDEX hint, fixing hundreds of different statements every day. Security policies can be transparently applied, automatically changing a statement's "where" clause conditions and encrypting select list columns. It can also completely block queries from reaching the databases while returning a customized message to the user.
STRENGTHS: The Partner team recognized three critical strengths of the ActiveBase implementation. Most critical were the significant response time improvements of reports and ad hoc queries identified by the ActiveBase Expert, where a single optimization rule improved hundreds of reports and ad hoc queries. Second, ActiveBase was quickly installed on the database server, was implemented quickly and seamlessly into the data warehouse environment and is completely transparent to end users - which resulted in virtually no risk. The performance management and optimization policies are easily defined and managed. Last, with ActiveBase, the Partner team increased system efficiencies and today has a high-performance BI management solution.
WEAKNESSES: Although the ActiveBase solution provides full audit logs, summary reports would have helped Partner to track monthly changes to capacity and performance. This was overcome by loading the audit information to the database and developing BusinessObjects reports. ActiveBase plans to add this to future releases.
SELECTION CRITERIA: Because the proof of concept of ActiveBase proved immediate ROI, Partner saw the potential and decided to purchase the product. No other product offered the same high-quality results with a fast implementation and ROI.
DELIVERABLES: We have accelerated key business reporting by a factor of 10, enabling us to run them much more often, which dramatically improves our visibility into our business. These savings have resulted in profound overall data warehouse performance improvement and increased server capacity.
VENDOR SUPPORT: Vendor support is excellent. ActiveBase's consultants are highly professional and knowledgeable, and the information they provide is extremely useful.
DOCUMENTATION: ActiveBase is very easy to install and manage. Its screens are intuitive, and documentation is easy to understand.
4633 E. Holly Street
Phoenix, AZ 85008
Register or login for access to this item and much more
All Information Management content is archived after seven days.
Community members receive:
- All recent and archived articles
- Conference offers and updates
- A full menu of enewsletter options
- Web seminars, white papers, ebooks
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access