Introduction to Tibero Studio

This chapter introduces the main features and functionality of the Tibero Studio product.

Overview

Tibero Studio is a graphical user interface (GUI) tool for database development that provides database developers with an efficient development environment and a wide range of features. Tibero Studio supports major tasks required for database management and development, such as running SQL queries, managing Data Definition Language (DDL), and controlling transactions.

In particular, it provides features specific to Tibero database development and supports the creation and execution of tbPSM (Tibero Procedural Stored Module) programs. Developers can directly create and execute tbPSM programs such as procedures, functions, and triggers, and easily manage database objects.

---

Key features

Tibero Studio 3 provides the following key features.

• Schema Object Tree

  • It displays all schema object information accessible to the user in the form of a tree to support intuitive object management and navigation.

• SQL Editor

  • User can run multiple SQL statements in batch, sequential execution, current position execution, selection execution, all tabs execution, etc.

  • User can check the execution results and Server Output in real time, making debugging and development tasks efficient.

  • User can set Auto-Commit mode to apply SQL statements to the database immediately when executed, or manually commit or roll back transactions.

• PSM Editor

  • It provides a dedicated editor to create, edit, and run Tibero Procedural Stored Module (PSM) programs such as procedures, functions, and triggers.

  • User can compile the written PSM code and check error messages, and it supports debugging functions to efficiently perform code verification and modification tasks.

• Template

  • It provides the ability to store and manage frequently used SQL statements and PSM code as predefined templates, and the ability to create custom templates to meet project requirements.

  • The template management tool makes it easy to modify, delete, and reuse existing templates, and the systematic classification of templates maximizes work efficiency.

• Preference

  • Manages Tibero Studio preferences to customize the development and work environment to meet User's needs.

• DBA

  • A set of tools to help database administrators (DBAs) do their jobs more efficiently, designed to give them intuitive visibility into system-wide status and control over key resources.