PL is a procedural language (Procedural Language). It is an extension of SQL. PL adds programming language features to SQL statements, allowing data operations and queries to be organized within procedural code. This enables complex functionalities through logical judgments and loops.
Using PL, you can develop programs with advanced features. It allows encapsulating business logic within the database, providing better abstraction and security. It also reduces network interactions, resulting in faster call speeds and overall performance improvements.
The main advantages of PL are as follows:
High performance
When interacting with the database using PL, all processing logic occurs on the database server, and only the required results are returned to the client. This significantly reduces data exchange between the application server and the database server, saving network resources and processing time.
PL objects are stored in the database in a precompiled form. Compared to regular SQL, the optimizer provides better optimization for PL, leading to more efficient execution.
Easy development
PL's features can save developers time on design and error troubleshooting. Developers can efficiently develop using OceanBase Developer Center (ODC), which is provided by OceanBase Database.
For more information, see the ODC-related documentation on the OceanBase Database website.
Portability
For database developers, PL is a portable standard language. PL applications can run in any OceanBase Database.
Easy management
PL objects are stored in the database. When modifying applications or iterating versions, changing the PL objects in the database immediately affects all applications. This eliminates the need to worry about differences in client code updates.