Next in our Improving the Daily Life of a Database Developer blog series: now that you’ve successfully connected to your database, we will focus on helping you navigating through it. If you missed it, you can read the previous post on Connecting to the Database Server.
Navigation in a hierarchical explorer is the most familiar mode for browsing, navigating, and selecting databases and objects. It is intuitive to every database developer and even to novice users. When you have a lot of servers to manage, particularly across multiple platforms, the hierarchy tree can get very messy and confusing if you don’t organize them into related groups. So it helps to have a tool that facilitates easy organization of the connected servers by customizable categories. These could be combined by database platform, by business usage, or whatever is relevant for your business, to make the databases more accessible.
From the GUI, database professionals can use context menus to explore tables, data, and database objects. They can also select actions to CREATE, ALTER, and DROP tables, databases, and objects without the need to write schema scripts. There are tools that automate the process of generating the SQL statements required to create databases and to create/alter/ drop tables, constraints, indexes, views, triggers, scripts, and storage objects.
That is helpful because architecture and nomenclature differ among databases. For example, a schema in Oracle is analogous to a database and one of its schemas in SQL Server; similarly, creating a collection in MongoDB is on par with creating a table in Oracle.
By keeping operations available in context menus and maintaining a layout as consistent as possible from one database to another, the IDE approach makes it easy for database developers and administrators to work effectively in multi-platform environments.