UDB-TX Distributed Relational Database

UDB-TX is the first product launched by Universal Technology, which is a new generation of transactional relational database supporting centralized and distributed deployment in two ways with six sets of architecture. The current version has been commercialized mainly to replace ORALCE, MYSQL single node, read-write separation, a master-multi-slave cluster mode, and three other deployment modes, with the expansion and enhancement of middleware capabilities will gradually support the remaining three deployment modes.

UDB-TX is an enterprise-level, large-scale, general-purpose database management system for key applications across the industry.It is suitable for online transaction processing, data warehousing, Internet applications and other scenarios.

Product Advantages
Technical Characteristic
Better Performance: (1)


Adopts MPP (Massive Parallel Processing) architecture; supports row storage and column storage, and selects the appropriate storage method according to the load model; JIT dynamic compilation technology based on LLVM to improve query performance.



Powerful Complex Queries: (1)


Support cost-based query optimization model to improve the performance of complex queries .Supports all major multi-table query methods.Through parallel computing, index coverage, storage reconfiguration and other processing models, to comfortably cope with the business needs of enterprises with high load and high concurrency.


Support for Data Partition Management: (1)


With the ability to manage data partitioning, support for range partitioning, hash partitioning, list partitioning and other partitioning mechanisms for tables; support for multi-level partitioning mechanisms; support for automatic partitioning.In the applicable scenarios, the reasonable use of partitioning can allow the database system to obtain exponential performance improvement.


Support for Physical and Logical Replication: (1)


UDB-TX is an enterprise-level, large-scale, general-purpose database management system for key applications across the industry.It is suitable for online transaction processing, data warehousing, Internet applications and other scenarios.


Support for read/write Split Clustering: (1)


Supports 2 or more nodes, executing write transactions on the master node and read transactions on the slave nodes, automatically realizing high availability, read-write separation, load balancing and connection pooling.


Support Spatial Data: (1)


Extended based on PostGIS standards, with built-in geometry type support for seamless integration and operation between vector and raster data. Supports topology functions and spatial operations on 3D spatial data. Specifically includes: support for all spatial data types; support for all object expression methods; support for all data access and construction methods; a variety of spatial analysis functions; support for metadata; a set of binary predicates for detecting spatial relationships between spatial objects; spatial operators for spatial data manipulation; coordinate transformations within the database; spherical arithmetic operations; three-dimensional geometry type support; spatial aggregation functions; and raster data storage and access.

Provides Massive Index Types: (1)


Supports the following Index Types: General-purpose Btree indexes; and Brin indexes, Hash indexes, GIN inverted indexes, GIST general-purpose search trees, KNN queries, Bloom efficient filtering indexes, conditional indexes, function indexes, and full-text search indexes, RUM.


Full-Text Search Capability: (1)


The process of word splitting and indexing is decoupled in the realization, with GIN index, UDB-TX full-text search has excellent query performance.At the same time, it provides a variety of Chinese word segmentation capabilities, perfectly supporting Chinese full-text search.There is no need to build an additional search engine, through the SQL operation to achieve full-text search and fuzzy query.


Safe and Credible: (1)


Complete database security technology that eliminates all security threats from the inside out, with comprehensive reliability security enhancements.Including data encryption, different granularity access control, communication channel encryption, different levels of access isolation, built-in database auditing, built-in data desensitization and other security features.


Supporting Tools

UDB-CLUSTER
Cluster Management Platform
UDB-STUDIO
Integrated Management Tools
UDB-CDC
Data Synchronization Tools
UDB-LOADER
Database Migration Tools