We are independent & ad-supported. We may earn a commission for purchases made through our links.
WiseGeek

Advertiser Disclosure

Our website is an independent, advertising-supported platform. We provide our content free of charge to our readers, and to keep it that way, we rely on revenue generated through advertisements and affiliate partnerships. This means that when you click on certain links on our site and make a purchase, we may earn a commission. Learn more.

How We Make Money

We sustain our operations through affiliate commissions and advertising. If you click on an affiliate link and make a purchase, we may receive a commission from the merchant at no additional cost to you. We also display advertisements on our website, which help generate revenue to support our work and keep our content free for readers. Our editorial team operates independently from our advertising and affiliate partnerships to ensure that our content remains unbiased and focused on providing you with the best information and recommendations based on thorough research and honest evaluations. To remain transparent, we’ve provided a list of our current affiliate partners here.
Technology

What Are the Different Database Administrator Tools?

By Micah MacBride
Updated May 17, 2024
Our promise to you
WiseGeek is dedicated to creating trustworthy, high-quality content that always prioritizes transparency, integrity, and inclusivity above all else. Our ensure that our content creation and review process includes rigorous fact-checking, evidence-based, and continual updates to ensure accuracy and reliability.

Our Promise to you

Founded in 2002, our company has been a trusted resource for readers seeking informative and engaging content. Our dedication to quality remains unwavering—and will never change. We follow a strict editorial policy, ensuring that our content is authored by highly qualified professionals and edited by subject matter experts. This guarantees that everything we publish is objective, accurate, and trustworthy.

Over the years, we've refined our approach to cover a wide range of topics, providing readers with reliable and practical advice to enhance their knowledge and skills. That's why millions of readers turn to us each year. Join us in celebrating the joy of learning, guided by standards you can trust.

Editorial Standards

At WiseGeek, we are committed to creating content that you can trust. Our editorial process is designed to ensure that every piece of content we publish is accurate, reliable, and informative.

Our team of experienced writers and editors follows a strict set of guidelines to ensure the highest quality content. We conduct thorough research, fact-check all information, and rely on credible sources to back up our claims. Our content is reviewed by subject matter experts to ensure accuracy and clarity.

We believe in transparency and maintain editorial independence from our advertisers. Our team does not receive direct compensation from advertisers, allowing us to create unbiased content that prioritizes your interests.

Databases act as a central information repository that authorized programs or Web services can access, add to, or modify. Professionals called database administrators are in charge of setting up and maintaining these specialized software servers. Database administrator tools are specialized programs that allow them to access, modify, and update database software and configurations.

In the world of computer programming, a server is a program whose purpose is to provide information to other pieces of software called clients. A server can run on its own machine, which clients access through the Internet or a local network. A server can also run as a background program on the same machine as its client programs. Database software runs as a server that listens on a specific port for incoming connections from client programs that want to access information it holds.

The database administrator tools that professionals use to maintain running databases are separate programs and not part of the database software itself. Database administrators use these tools to issue commands to which a particular piece of database software is programmed, to recognize and respond with a corresponding action. Although the exact syntax for these commands varies between different database software, actions that can be performed using them include:

  • adding and removing the credentials programs can use to log in to a particular database
  • add databases to, or remove databases from, the server
  • add or remove individual tables within a database
  • modify the layout of a table
  • modify individual data entries

These utility programs can have full graphical user interfaces or be text-based terminal programs. Database administrator tools that use a text-based interface require the user to type out the full syntax for every maintenance command. Programs that have a full graphical interface allow users to set up commands by clicking buttons and selecting different options, then they translate the action into the necessary syntax for a command to the database.

Database administrator tools also include software that allows for remotely logging into a computer and executing system commands. These are necessary for when the administrator has to update database software that runs on a machine with no computer monitor or graphical interface. In order for an administrator to be able apply an update, he or she has to stop the database server, which is like quitting a running application. Remote login software allows a database administrator to access the computer on which the database is running to stop the database server, update the software, and then restart the database software.

WiseGeek is dedicated to providing accurate and trustworthy information. We carefully select reputable sources and employ a rigorous fact-checking process to maintain the highest standards. To learn more about our commitment to accuracy, read our editorial process.
See our Editorial Process Share Feedback

Related Articles

Discussion Comments

WiseGeek, in your inbox

Our latest articles, guides, and more, delivered daily.

WiseGeek, in your inbox

Our latest articles, guides, and more, delivered daily.