DQ DATABASE
A powerful converged database that allows quickly migrating from Oracle and MS SQL platforms.
Instead of using a single primary dialect or database standard, the highly compatible DQ Database supports multiple dialects and ensures easy replacement of Oracle and MS SQL platforms without the need to rewrite the application code.
DQ DATABASE
– THE POWERFUL MULTIDIALECT DATABASE PLATFORM
MIGRATE FROM MS SQL
AUTOMATICALLY
AUTOMATICALLY
Native support for the dialect and the TDS protocol enables MS SQL migration without involving software developers.
MS SQL Compatibility Features
- Support for all T-SQL syntax constructs
- Support for all MS SQL data types
- Support for IDENTITY fields and @@IDENTITY constructs
- Support for @@SPID session identifiers
- Support for all documented built-in functions
- Support for multiple system tables, views, and sp_ stored procedures
- TDS protocol-based connectivity, with external applications (e.g., Microsoft SSMS) recognizing DQ Database as MS SQL Server
Current MS SQL compatibility –96%.*
We are continuously enhancing the compatibility of DQ Database with MS SQL and Oracle dialects and transport protocols, which is driven by real-world implementation projects.
MIGRATE FROM ORACLE
FASTER
FASTER
Pre-integrated support for the Oracle dialect (PL/SQL) and the emulation of Oracle Instant Client enable rapid migration from Oracle
Oracle Compatibility Features
- Support for all PL/SQL syntax constructs
- Support for all native Oracle data types
- Support for core system tables and views (e.g., all_objects)
- Support for the most popular UTL and DBMS packages
- Support for the %type, %rowtype, %rowcount and other constructs
- Support for user-defined types and nested tables
- Support for all officially documented Oracle DBMS built-in functions
- Client-side emulation library for Oracle Instant Client — The customer can choose to connect either via this library or via a Java driver
Current Oracle compatibility – 71%.*
We are continuously enhancing the compatibility of DQ Database with MS SQL and Oracle dialects and transport protocols, which is driven by real-world implementation projects.
* We are continuously enhancing the compatibility of DQ Database with MS SQL and Oracle dialects and transport protocols, which is driven by real-world implementation projects.
Start using DQ Database today!
Download the free fully-featured distribution version (up to 8 cores)
CHALLENGES WE ADDRESS
Rapid Replacement of MS SQL
1.
For IT solutions of any scale, including the critical information infrastructure (CII).
Rapid Replacement of Oracle
2.
For mission - and business-critical systems
of large organizations and enterprises
Protecting Investments
in the Legacy Code
in the Legacy Code
3.
The only solution that allows replacing Oracle and Microsoft database management system without significantly recoding existing applications.
Support for High-Load Systems
4.
After the migration, DQ Database ensures high performance of applications.
Ensuring Security
5.
DQ Database delivers secure, reliable,
and high-integrity data storage
and high-integrity data storage
Unified Management Interface
for System Softwar
for System Softwar
6.
An intuitive unified GUI for managing all clusters, complemented by a flexible role-based access control system
DQ DATABASE COMPONENTS
1
Database Server and Client Components
2
DQ Database Management Center
A graphical web interface for configuring, administrating and monitoring DQ Database
3
Components
- Logical data replication between DQ Database nodes.
- Connection Polling: Management of the pool of connections between client applications and database instances.
- Ensuring high availability and fault tolerance of systems based on DQ Database.
4
Migration Tools
- Data Migration Wizard for the transfer of data from Oracle, MS SQL Server and PostgreSQL into DQ Database.
- Data Migration Quality Assurance Wizard used to validate the quality of data migration between the above databases and DQ Database.
5
Documentation & Guidelines
- Full technical documentation.
- Guidelines for setup of continuous replication of data changes from Oracle and MS SQL databases into DQ Database.
- Use cases.
- Video overview of key features.
6
Additional Components
- Distributed key-value store for mission-critical data in distributed systems.
- High-availability cluster management tools.
- Connection pool management utility.
- DQ Database Security Package: A set of extensions that provide protection against unauthorized access, ensure configuration integrity for the DBMS, databases, stored procedures, and enable comprehensive logging of security events.
FACTS & FIGURES
20 TB per Day
Oracle migration at up to 20 TB per day.
Under 30 Minutes
Takes to migrate from MS SQL
3-In-1
Transactional, analytical and key-value database
Built-In In-Memory Engine
Pre-integrated in-memory for “hot” caching dramatically boosts high load performance
>2x
DQ Database contains 4.6 million lines
of code, which is more than double the size of the original PostgreSQL capacity (2.1 million lines)
DQ DATABASE VS POSTGRESQL
– KEY ENHANCEMENTS
From a technical standpoint, DQ Database is a heavily modified fork of the PostgreSQL DBMS
(Version 17.4 is based on the PostgreSQL 17 core; Version 18.0 uses the PostgreSQL 18 core).
(Version 17.4 is based on the PostgreSQL 17 core; Version 18.0 uses the PostgreSQL 18 core).
1. Supported Data
Native support for all Oracle and MS SQL data types. DQ Database ensures seamless data migration with its full Unicode support –unlike the standard, free PostgreSQL
2. SQL Compatibility
SQL-level support for many MS SQL and Oracle functions. No third-party extensions are required to use the database functions you are already accustomed to.
3. Differential Backups
Support for the differential backup functionality allows backing up only the data that has changed since the last full backup.
4. Data Optimization
Built-in support for columnar and in-memory data processing.
5. "Smart" SQL
Enhanced SQL interpreter and query planner. Ability to "forgive" and automatically correct a range of common query syntax errors, including those originating from external applications, without code changes.
6. Application Optimization
The advanced optimizer "understands" features of many popular business applications and can significantly accelerate their performance (requires purchase of the corresponding optimization package).
7. Cross-Database Access
Access to data from other database management systems (a db-link to Oracle, Microsoft SQL Server, PostgreSQL) and other data sources.
8. Hinting Mechanism
Built-in support for query hints.
9. Extended Features
Manual cardinality management, table partitioning, data sharding, and other enhancements.
200+ other improvements that ensure support for enterprise-grade
requirements for security, scalability and fault tolerance
requirements for security, scalability and fault tolerance
Read more about the DQ Database architecture and its differences from the basic PostgreSQL version
WHO CAN USE DQ DATABASE
Free Version
Up to 8 cores
Software Developers
To ensure high reliability and security of information systems.
Startups and Small Businesses
For prototyping and small-scale projects which do not require expensive solutions.
Personal Projects
For individual projects and experimentations.
Students and Researchers
Looking for a perfect sandbox to learn and experiment with databases.
Commercial Version
Starting from 8 cores, with technical support, updates and migration projects
Personal Data Processing Organizations
Entities handling large volumes of personal data.
Government Services
To ensure high information security and protection
of state secrets.
Critical Information Infrastructure (CII) Facilities
Companies operating in energy, transportation, telecommunications and other critical sectors.
Financial Institutions
Banks, insurance companies, and other financial organizations.
DQ DATABASE USE CASES
Corporate Information Systems
Web Applications
Mobile Apps
Analytics Platforms
Content Management Systems (CMS)
Banking & Financial Application
Oil & Gas Applications
Healthcare Information Systems
Retail & Trade Management Systems
Government Information Systems
Document Management Systems
Business Process Management Systems (BPM)
KEY ADVANTAGES
Unique Solution
Our ready-to-use migration tools do not just automatically transfer your data to DQ Database—they migrate your entire stored codebase, including triggers, functions, procedures, and indices.
Ready-to-Use Tools
Leveraging our deep expertise in the development of both system and application software, we assume the end-to-end responsibility for the successful migration of your application software to DQ Database.
A Single Point of Accountability
We guarantee full compatibility with queries and functionality of popular SQL dialects
Your application software won't even notice the switch from MS SQL or Oracle*
Compared to other Database
Management Systems
Management Systems
* Compared to other Database
Management Systems
Management Systems
TRAINING, TECHNICAL SUPPORT, MIGRATION PROJECTS
Training*
If you already have experience administering PostgreSQL, MS SQL or Oracle, you won't need to retrain
We offer structured training courses for database administrators and DBMS support engineers, designed to bring them up to speed on DQ Database in the shortest possible time. Upon completion of courses, participants receive certificates.
Migration Projects
Our team of certified experts, with deep expertise in both application and system software, delivers end-to-end migration projects. We take full ownership to ensure a successful outcome.
Technical Support
Choose the plan that fits your needs—standard business hours (8x5) or 24/7 coverage. Our technical support team is always available to solve any issue, in full compliance with the most stringent Service Level Agreements (SLAs).
* If you already have experience administering PostgreSQL, MS SQL or Oracle, you won't need to retrain
PARTNERS
Contact us to join our partner program as a distribution or a development partner.
Become a partner
DQ DATABASE — The Hybrid DBMS for Corporate Systems
DQ Database is a cutting-edge database management system designed for fast and secure migration of corporate IT infrastructures from other DBMS platforms—with no code rewrites and no loss of performance.
Key Advantages
- Seamless Migration from other database management systems (Oracle, MS SQL, PostgreSQL) without the vast application rework. Support for queries and functionality of popular dialects.
- Hybrid Core — A synergy of relational, columnar, and in-memory technologies to optimize storage and processing for data of any volume.
- Comprehensive Offering — From purchasing just the DBMS to the comprehensive solution, complimented with consulting services or delivered as part of other software solutions offered by our Company.
- Savings Time and Budget — Rapid testing of hypotheses, assessment of the migration scope, reduced TCO, and transparent licensing.
What businesses is DQ Database suited for?
The product is optimally designed for:
- Banks and financial institutions
- Government agencies
- Defense industry
- Large enterprises
- IT integrators and telecom companies
- Organizations handling mission-critical data that demand reliability, scalability, and regulatory compliance.
Solution Tasks
- Stable and fast migration from other DBMS platforms
- Minimizing transition costs and personnel retraining
- Ensuring business process continuity
- High availability, security, and data protection
Technological Features
- Intuitive administrative console
- Reliable backup and flexible recovery
- Effective access management and integration with corporate IT landscapes
Technological Features
Implementation is supported by training programs and certification for administrators and integrators. This includes regular updates and SLA-driven technical support.
DQ Database is the modern standard for seamless migration, speed, and technological independence of your business.
DQ Database is a hybrid database management system (DBMS), based on the synergy of relational, columnar, and in-memory data storage technologies.
Core Functions
- Data Management: Creating, editing, and deleting records in the database.
- Query Processing: Executing data operations in specialized query languages.
- Administration: Controlling user access and ensuring security.
- Backup & Recovery: Creating data copies and restoring them in case of failure.
- Monitoring: Tracking changes and system statuses.
DBMS Components:
- System Kernel
- Language Processor for query handling (query processor)
- Data Manipulation Subsystems
- Utility Software
- Administrative Console
Data Storage Types
The following data models are supported:
- Relational Databases: Storing information in related tables.
- Object-Oriented Systems: Representing data as objects with attributes.
- Hierarchical Structures: Organizing data in tree-like schemas
Benefits
- Data Security: Protection against unauthorized access.
- Data Integrity: Prevention of data loss.
- Scalability: Ability to expand the system.
- High Performance: Optimization for large data volumes.
- Ease of Administration: Simple system control and management.
Use Cases
- Corporate Information Systems,
- Web Applications,
- Mobile Apps,
- Analytical Platforms,
- Content Management Systems,
- Banking and Financial Applications.
A Database Management System is a critically important IT component. It ensures reliable storage, efficient management, and secure use of data across various use fields. Thanks to its wide range of functions and capabilities, DQ Database helps customers to streamline information handling, increase productivity, and ensure data protection.
The choice of the DBMS depends on the specific task, data volume, and performance requirements. When selected and configured correctly, the system can significantly improve the quality of information management and ensure the effective functioning of business processes.
In today’s environment, DQ Database is not merely an advantage but a necessity for the successful business development.