Usage Scenarios
Scenario Description
In real-world production, users' service systems often involve complex data analysis and operations. Traditional data types may not fully or efficiently represent or process their data scenarios. To address this, JDBC provides user-defined data types, Struct and Array, enabling the creation of new data types from existing ones. These user-defined types offer users a more convenient way to add, delete, and modify data.
Trigger Conditions
JDBC operations involve user-defined data types.
Impact on Services
- Improved data consistency and integrity
User-defined types allow users to declare data types and check constraints for columns during the type definition phase, ensuring that all columns referencing these types automatically inherit the same verification logic.
- Improved data reusability and encapsulation
User-defined types encapsulate frequently used data structures for reuse across multiple tables or functions. This minimizes redundant definitions and enhances maintenance efficiency.
- Additional performance overhead
Using user-defined types will take up additional storage space and necessitate object assembly and disassembly during access, potentially leading to increased CPU and I/O usage.
Applicable Versions
This applies only to GaussDB 503.0 and later versions.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot