Welcome to Analytic SQL Server Homepage
Analytic SQL Server is implementation of the next generation Data Warehouse Model (for now available only for PostgreSQL server), with full OLAP functionality and analytical processing support (Mathematical Models, Statistics Models etc.) on the SQL server-site.
The main feature of ASQL is building very large scale Business Intelligence and Analytic Intelligence solutions, forgetting the known limitations of today's systems.
The proposed Analytical SQL Server is one of the first integrated systems on the market. Analytical SQL Server's main applications include systems belonging to the class of Business Intelligence, such as financial applications:
- Financial Sector (Controlling, Budgeting, Forecasting; MiFID);
- Banking (BASEL II, credit scoring, forecasting, frauds, money laundering);
- Insurance (Solvency II);
- Healthcare Industry;
- General Purpose Data Analysis.
Extensions of Business Intelligence concern relational OLAP (ROLAP) with full support for multidimensional data processing (MOLAP). Integration of these two technologies (ROLAP and MOLAP) is directly transposed into facility of modelling and processing multidimensional data using standard SQL interface. This is rarely available in other solutions. System presented in Products Section, called SART, is an example of solution where OLAP model has been built on non-uniform dimensions, and more specifically on Chart of Accounts.
Server's functional architecture has been schematically shown on below Figure
Extensions of Analytical SQL Server allow also to use advanced analysis based on mathematical and statistical models. Similar to Business Intelligence features, the extensions of Computational Intelligence are built-in in the database management system and are available through standard SQL interface. This feature is also not found in currently commercialized systems.
During designing Analytical SQL Server a lot of attention has been directed to the system performance which resulted in very high efficiency of data processing. In one of the largest data warehouses (imported data concerned period of 14 months) all multidimensional analyses were performed within duration of time that did not exceed 10 seconds, where 98% analyses were carried out in less than 5 seconds. Above mentioned technological properties of Analytical SQL Server make implementation of data warehouses with advanced data analysis a low risk task, and allow to achieve very easily full user requirements.
Homogeneity of analytical system offered by Analytical SQL has also considerable influence on reducing license fees and implementation costs, because it does not require payment for third-party licenses as well as reducing integration cost related to different tools and systems (e.g. DBMS and statistical programs).