posted 6 years ago in CUBRID Apps&Tools category by Esen Sagynov
CUBRID Manager - a Window to CUBRID Database Management System.
What is it that CUBRID 2008 users actually look at the most?
Provided that the user is not a developer of the CUBRID 2008 engine itself, the answer would be definitely CUBRID Manager. To make it simple, let's abbreviate it to CM. Let's examine CM, a tool that provides easier access to CUBRID 2008, and some other tools that we can describe as CM's friends.
What kind of tool is CM?
CM, or CUBRID Manager, is literally a management tool used to administer CUBRID. It allows users to manage CUBRID through a convenient and intuitive User Interface (UI) and provides a space where they can execute queries and view the results.
What specific aspects of CUBRID does CM manage?
CM can manage all aspects of database management. In brief, these can be divided into the following 8 categories:
- DB Operations Management
- Users and Groups Management
- Tables, Views, Triggers, Serial and Stored Procedures Management
- Backup Automation and Query Automation Management
- DB Volume Management
- Broker Management
- Monitor Management
- Log Management
Even from this brief summary, you can see that CUBRID Manager is responsible for diverse aspects of CUBRID.
- The DB operation management is a feature that you will inevitably use with CM. You will not be able to do anything without running the DB. When you click the DB name, the icon at the top turns into green. When you click this icon, the DB starts running. Just don't forget to log in as a dba. Non-dba users do not have permission to run the DB.
- Now it's time to create tables for storing data. The table management is used at this point. You can use queries to create a table, but let's do it with some clicking in CM. Clicking may cause some difficulties in creating all tables, but it will be useful for modifying each table.
- The backup automation is a set up when to perform the DB backup. The backup is an essential operation for the DB management. Regular backup is very important. CUBRID supports the backup operation by level (Level 0, 1 or 2). By enabling the backup automation, you can manage the DB stably.
For the other management tools refer to the Installing and Running CUBRID Manager. You will find there additional valuable for a database administrator features.
Then, where do I make queries?
In fact, what developers need more is a Query execution window with a simple UI. CM provides powerful Query Editor with syntax highlighting feature. CM not only shows the query results but also provides plan information.
In CM, I can sense a bit of Eclipse. Am I right?
CM is an Eclipse-based tool to manage CUBRID DBMS. Therefore, the Eclipse plug-in might also be used. A very good Eclipse plugin is QuantumDB. I have tried it, and it worked well.
Are there any other interfaces that can be used to connect to CUBRID?
Of course, there are! It can be JDBC, ODBC, PHP, Python, Ruby, etc.
... One more thing...
We have recorded several video tutorials related to CUBRID Manager. There are four videos in the Introduction Series which explain how to quickly master CM.
You can start with the first chapter: CUBRID Manager - Video Tutorial - Part I & II.
Besides CM videos there many others. Visit our CUBRID Trainings Channel for more!