New possibilities of MS SQL Server 2016 in Lime Systems solutions
13 / 04 / 2017
Modern databases continue growing the functionality on processing and storing of large amounts of information. This allows development companies process and store the client information more effectively, undertake the multilevel analysis and ensure the bigger relevance in decision making. Microsoft company in its SQL Server 2016 solution offered interesting and much-needed mechanisms, some of which were used by Lime Systems.
Let us remind that officially the partnership of Lime Systems with Microsoft started in 2004, and in 2011 the company received the status of Golden Partner of Microsoft, which shows the high level of company’s specialists and solutions as a whole.
We distinguish several key changes, which influenced the efficiency and peculiarity of work of MS SQL Server 2016:
- Least vulnerable database – high accessibility and disaster recovery
- New features of SQL Server 2016 in the sphere of security allow protecting data for critically important workload. Due to the multilevel approach to security, including a reliable mechanism of audit, transparent data encryption (TDE) mechanism and others, the requirements of controlling bodies to critical information storage are fully met.
- High productivity – SQL Server 2016 is keeping the leadership in all the productivity tests, which use the workload TPC-E (OLTP), TPC-H. The results of synthetic tests find their confirmation when realizing real tasks in real systems.
- SQL Server 2016 includes wide possibilities on database management and maintenance. The extended list of operations, which can be performed in the ONLINE mode, significantly simplifies the tasks of administration, allowing to lower the time of data non-availability to a significant extent.
Apart from that, SQL Server Management Studio received a useful possibility - Live Query Statistics, which allows to monitor the query realization process. The data received as a result (time, %% of realization, quantity of data) are used for optimization.
It should be specially emphasized that Microsoft announced special conditions on migration to SQL server 2016 from the competitive platforms. According to the idea of the corporation, this offer would make the unified solution on data storing, protection, processing and analysis more affordable for those organizations, which invested in the platforms of other producers. Such special conditions, which will help to economize on the cost of licenses of a new product, development of a migration plan and training, would also be interesting to banking departments.
- SCROOGE Core Banking System
- Cash&Billing Cashier’s Module
- WebBank Front Office Module
- iTiny Web Banking Module
- iTiny.Mobile Mobile Banking Module
SCROOGE Core Banking System
Core Banking System consisting of a number of interrelated modules, which ensures the integrated management of bank resources and its overall effective functioning.
Cash&Billing Cashier’s Module
This software module unites two systems: "Cash&Billing" and "MoneyTransfer", and represents the universal workstation of the bank cashier.
WebBank Front Office Module
WebBank Front Office Module gives the bank possibility to organize the cooperation between employees, serving clients of the bank via the single application with convenient, easy web-interface and extended possibilities and control on each step of the work – client consultation, product sale, client background check, evaluation of the financial capabilities of clients, additional product orders, realization of the transactions and creation of the additional agreements, monitoring pledged security and work with non-performing liabilities.
The system of cryptographic information protection LS-Crypt is the library of cryptographical transformations, based on mathematical method of elliptic curves. It is used for encryption and decryption of the information, calculation of the message authentication code, hash function calculation, creation and verification of the electronic digital signature.
iTiny Web Banking Module
The software module of remote service for bank customers (legal entities and individuals), which provides access to financial information of the client and the possibility of executing a certain set of operations and functions.
iTiny.Mobile Mobile Banking Module
Mobile version of popular web banking module iTiny. It is freely distributed via the App Store, Google Play Market, Windows Phone Store. It allows managing funds on your accounts 24 hours/day with the help of mobile phone.