Best Practices for Database Application System Development

This chapter introduces the usage and best practices for application software design and development using the Klustron database system, particularly focusing on the features and practices related to Klustron.md)s distributed database system.

• Computation Node User Manual

• Klustron Extended DDL Syntax

• Using Prepared Statements

• Using Enum Data Type

• insert/update/delete...returning Statements
• Settings Required for Executing Long-duration Queries
• Klustron_Sequence Feature and Its Implementation Mechanism
• Principles and Features of Klustron Triggers
• Usage Examples of Klustron Triggers
• Machine Learning in Klustron
• Managing JSON Data in Klustron
• Klustron Vector Data Management
• Klustron Online Table Migration and Multi-Compute Node Consistency Demonstration
• Accessing Oracle with Klustron using oracle_fdw
• Accessing MSSQL with Klustron using tds_fdw