Use cases

Eugenia Kuzina

ADP is a powerful relational database management system (RDBMS). ADP is based on the object-relational Open Source DBMS PostgreSQL. ADP can be used in business critical and non-critical applications in various industries.

ADP is a good solution in the following cases:

  • Financial industry. ADP is fully ACID compliant and suitable for OLTP (Online Transaction Processing) workloads. It is also an analytical database and can be integrated with math software.

  • Industrial manufactures. ADP is a reliable long-term data warehouse that offers reliable storage at a low cost. ADP is the good choice because it can be configured for automatic failover, full redundancy, and almost zero downtime upgrades.

  • GIS data. ADP includes a powerful GIS extension — PostGIS, which provides hundreds of functions to process geographic data in various formats.

  • Web technologies and NoSQL workloads. Websites might require thousands or hundreds of thousands of requests per second to serve customers. ADP meets this requirement and can be used as a storage backend in scalable applications. ADP works with modern web frameworks including Django (Python), node.js (JavaScript), Hibernate (Java), Ruby on rails, PHP, and others.

    Due to replication capabilities, websites can be scaled out to as many database servers as you need.

    ADP can also be used as a NoSQL-style data store.

  • Scientific data. Research and scientific projects can generate terabytes of data. ADP has analytical capabilities and offers a powerful SQL engine that can easily process large amounts of data. ADP can also be extended. You can write aggregation functions and implement your own business logic in the database.

  • Metric storage. You can install the TimescaleDB extension and use ADP to store time series data. For example, currency rates, vehicle movement telemetry, statistics of server access or CPU load that change over time.

  • Storage for Arenadata products. Some Arenadata products use ADP as their internal storage. For example, ADH saves meta-information in an ADP cluster.

Found a mistake? Seleсt text and press Ctrl+Enter to report it