Experience

PostgreSQL Compatible

Tacnode offers enhanced functionality and unlimited horizontal scalability, akin to PostgreSQL. It is suitable for traditional database applications and excels in efficient search and high-performance analysis to address complex data requirements.

• Drivers: Compatible with the PostgreSQL ecosystem, allowing seamless use of PostgreSQL drivers like JDBC/ODBC.

• Development Framework: Supports frameworks developed for PostgreSQL, including Hibernate, Mybatis, SQLAlchemy, Gorm, and other ORM frameworks.

• Development Tools: Compatible with mainstream development tools supporting PostgreSQL, such as psql, pgAdmin, DBeaver, DataGrip, etc.

• BI Tools: Works with various mainstream BI tools by selecting the PostgreSQL type for connection, such as Tableau, Metabase, Superset, Fanruan, or Quick BI.

• ETL Tools: Supports various ETL tools, such as DBT.

• Documentation: Reuses PostgreSQL documentation in most cases, providing guidance for SQL statement writing, tuning, and table structure design.

Agile Development

Tacnode enhances development and operational efficiency with advanced features.

• Schema Evolution: Simplifies table structure modifications with ALTER TABLE, allowing changes without data re-import. Supports online schema evolution to accommodate new business needs without affecting live traffic.

• Time Travel: Facilitates data experiments by allowing users to revert to past data states, similar to using Git branches. Enables easy switching between experimental and original data states, ideal for data science applications.

• Partitioned Table: Efficient data management through hot and cold data stratification. Supports distributed capabilities for infinite horizontal scalability, focusing on management rather than performance.

Workload Isolation

Tacnode ensures effective isolation for multiple workloads.

• Isolation between different businesses: Allows separate databases and warehouses for different businesses, isolating resources at the resource level.

• Soft Isolation for multiple workloads: Uses software to isolate different traffic within a Warehouse, ensuring complex background queries do not impact front-end business.

• Physical Isolation for multiple workloads: Achieved through read-only replication instances, allowing separate analysis and operations without affecting front-end user experience.

Adaptive Execution

Adaptation is integral to Tacnode's design, ensuring optimal system choices for a seamless user experience.

• Adaptive data distribution and index building: Automatically manages data distribution and migration across computing units based on data volume and changes.

• Adaptive One-phase transactions: Utilizes one-phase commit for transactions on the same machine, reducing overhead from distributed transactions.

• Adaptive query parallelism: Adjusts execution methods based on query complexity, using single-node execution for simple queries and distributed execution for complex analytical queries.

Tacnode is designed for high-performance, consistency, and real-time standards, with adaptability to optimize resource use based on specific business requirements.