A: AlSego has built a financial business application, MiddleOffice Control™, a Business Intelligence reporting and integration solution running on our Core platform XL-Groupware™. It took 5 months to develop and implement the Risk & Control Management solution for one of the major asset management company in Luxembourg, mainly providing wealth management services. We have decided to develop the business solution only with MySQL. We used it from the start of the project and received excellent technical support while developing our application.
A: Flexibility is a key item; the system handles many different types of data for storing all description data of financial transactions, which could be successfully consolidated using MySQL. Our volume is not huge but the various types of information are significant.
Then with any financial application, security is obviously a major concern, and MySQL provided the safety and robustness demanded by the application and its users.
Last but not least, performance, as the application entails the update of approximately 2 million records on a daily basis. Currently we have an average of 20 concurrent users requesting complex financial statements; this results in about 56,000 queries and 250,000 transactions (Commits/Rollbacks) running each day if we take into account the Core platform Master Repository (security, session, log updates and audit trails).
A: Because it’s extremely powerful; we needed a database engine that was very fast in terms of calculation, we have 100 different DCS (Data Collection Scenario that could be compared to execution plans for gathering data) and the users demand very fast response times – they cannot afford to wait for the results. Performance was the main reason for us. Secondly, AlSego is a young company and we knew that we could initially work with MyQL Community Edition in the event our development project was not successful, therefore limiting our commercial exposure. MySQL is one of the best RDBMS available – it’s flexible, multi-platform, and powerful. Plus, it offers automated monitoring via MySQL Enterprise, so if there is a problem, we are aware of it before the client and work pro-actively to resolve the issue. This is quite unique.
A: The end customer immediately saw the value of the MySQL Enterprise subscription offering. The opportunity to benefit from the MySQL Enterprise replication monitoring as well as the replication automatic advisors is very valuable. Indeed, the company plans in the near future to roll out the same application in its subsidiaries abroad and therefore will intensively use replication for centralizing all the data at headquarters.
The second reason is obtaining formal vendor technical support. The Luxembourgish financial regulatory agency imposes all financial institutions to secure their operational activities by ensuring they are able to count on expert assistance in case of critical issue.
A: Yes, some of the developers software toolkit for Oracle database, which we integrated into our Core platform XL-Groupware™. Our platform is Windows only today, but Linux is planned for next releases.
A: Today, XL groupware is an innovative reporting platform using extensively web technologies, but in the future, we want to extend its functionality to web development and integration. Our strategy is to offer a complete integration business solution, with multi-capabilities including reporting, data and application integration as well as fast web application development. We plan to increasingly leverage MySQL Enterprise moving forward.