Data Model and Database

Data Model

Huma BI has designed its own banking data model to hold data to support banking activities. This includes:

• reference data - customers, rates, holidays etc.
• financial data - accounts and postings.
• lending data - loans, collateral, fees etc.
• treasury data - FX, derivatives, money market, securities trades and positions.
• trade services data - trades.
• other transaction-related data.

The Data Model has been designed to be easily extensible to incorporate any other data that a bank may require. This could be anything from data held by other complete systems, to data maintained in user-managed spreadsheets. Huma BI has implemented such extensions to meet a variety of needs at client sites.

Database

The Data Model is in a database, currently implemented using Microsoft SQL Server 2005 and 2008. We chose this software because it provides a complete stack of software matching other leading vendors, but at a much lower cost. This software includes:

• powerful, highly scalable database easily capable of managing terabytes of data. Click here for much more information and many examples.
• SQL Service Integration Services (SSIS), a set of powerful tools for ETL (Extract, Transform & Load) processing. This is the very latest in ETL software, with a graphical interface allowing complex processes to be written quickly to extract data from many different systems.
• SQL Server Reporting Services (MSRS) - a complete server-based platform designed to support a wide variety of reporting needs.
• SQL Analysis Services (MSAS) – comprehensive analytical software.