Posts Under Tag: Beehive

Beehive 3 – What’s new?

Beehive 3 released

Logo Beehive 3Beehive 3 offers various improvements for managing the Operational Data Store (ODS) in terms of performance, stability, maintenance and administration.

Fast Load cycle

The key to improved performance is an optimized and less restrictive load strategy. Therefor the way changed data takes into the final ODS stage has been redesigned. Outdated data can now be linked more efficiently to the valid time frame. The optimized load processing between the staging area (STG) and the final ODS stage (GDP) leads to an extensive improvement of performance within the linking of outdated records, particularly in case of high data volume that needs to be changed.
All processing areas influencing performance (keys, indexes, etc.) have been reduced to a minimum without negative impact on performance when querying the data. For stability and performance reasons, key tables, used to enable constraint checks, have been dropped from the load cycle and are not supported any more. Therefor detailed logging mechanisms describe the completeness of the current Beehive load cycle, giving information whether a load has finished successfully or not. If necessary, data constraint checks can be implemented manually by user exits after the load cycle has finished.


The Oracle partitioning option becomes now available in the ODS stage, making the ODS more flexible than before. The embedded use of partitioning assures high performance when processing large data volumes, high maintainability of the ODS stage and gives even faster access to actual and historized data. By range-partitioning of the ODS (by valid-to date), the GDP-tables become easy to maintain, independent from their volume. Admins become able to archive legacy data and separate it from the active ODS by splitting off partitions until a defined date.


The FLink Monitoring view offers new functionalities for maintenance and administration. Beehive 3 jobs can be started, stopped, aborted or restarted. Logs can be archived in order to clean up operational log tables from old load cycle entries. Failed tasks can be skipped in order to complete a Beehive 3 cycle, if tasks failed and are not necessarily to be loaded.

Querying data

An important factor when building the new Beehive Release 3 has been the preservation of the existing ODS structure to maintain the migration effort as low as possible. Certainly, minor changes do appear on optimal data request.
The partitioning of the ODS area demands a modification of indexing, so that existing requests have to be slightly changed to allow for the new subscription. Though, the reorganization of the requests also means a simplification of the queries on the ODS during request for validity periods, as well as a higher performance at data access.

Beehive 3 – Impressive performance boost for load processing

National Bank of Malawi decided to upgrade its Beehive License to the new Beehive 3 release.

Blantyre, Malawi / Hamburg, Germany, July 2012 – FRAMETEXX GmbH, the provider of IT-Solutions in the TEMENOS T24™ environment, announced that National Bank of Malawi has successfully implemented the new release of the FLink Beehive Module.

Beehive 3 offers the bank various improvements for managing the operational data store (ODS) in terms of performance, stability, maintenance and administration. The key to improved performance is an optimized strategy how historical data is calculated in the final ODS stage. The bank also benefits from enhancement of data management of GDP tables, as well as considerable improvement of the monitoring process for operating the Beehive process.

National Bank of Malawi achieves with Beehive 3 a significant decrease of loading time in the staging areas:

Staging areas No. of Records Duration Beehive 2 Duration Beehive 3
IMP ~ 22 Mill 18 minutes 12 minutes
STG ~ 13 Mill 25 minutes 10 minutes
GDP ~ 13 Mill 110 minutes 15 minutes

During a two-weeks onsite visit at the bank’s premises in Blantyre, FRAMETEXX GmbH supported the project team of National Bank of Malawi in setting up the Beehive 3 environment for test and productive system as well as in testing the reporting system. FRAMETEXX also introduced the bank’s IT members into the enhanced monitoring functionalities, Beehive 3 provides, and gave some further recommendation how to optimize the loading times of data.

National Bank of Malawi is a financial services company, based in Malawi. It was listed on the Malawi Stock Exchange in August 2000 with a total of 450,000,000 ordinary shares.