Browse Definitions :
Definition

database automation

Contributor(s): Matthew Haughn

Database automation is the use of unattended processes and self-updating procedures for administrative tasks in a database. The automation of databases and their procedures reduces errors on deployments, improves reliability and increases the speed of implementing changes. Automation also frees up staff that might otherwise be occupied updating code and performing other tasks, including patching, upgrading, failover, scaling, provisioning and recovery.

Changes to databases pose a challenge because of their fundamental structure. Databases containing schema, stored procedures and existing data are add complexity to when making changes. When updating a running database for a production environment, the old information can’t simply be erased to create a new database. Prior to deployment, the preproduction database in development must run in a sandbox environment to simulate changes, rather than make them directly to the production environment.

One of the first automated databases as a service was launched with Amazon Web Services in the form of Amazon RDS in 2009. Microsoft followed suit shortly with Azure in 2010. Other tools for database automation include Stratavia’s Data Palate, GridApp and System BMC’s BladeLogic Database Automation.

This was last updated in January 2019

Continue Reading About database automation

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

File Extensions and File Formats

Powered by:

SearchCompliance

  • California Consumer Privacy Act (CCPA)

    The California Consumer Privacy Act (CCPA) is legislation in the state of California that supports an individual's right to ...

  • compliance audit

    A compliance audit is a comprehensive review of an organization's adherence to regulatory guidelines.

  • regulatory compliance

    Regulatory compliance is an organization's adherence to laws, regulations, guidelines and specifications relevant to its business...

SearchSecurity

  • endpoint detection and response (EDR)

    Endpoint detection and response (EDR) is a category of tools and technology used for protecting computer hardware devices–called ...

  • ransomware

    Ransomware is a subset of malware in which the data on a victim's computer is locked, typically by encryption, and payment is ...

  • single sign-on (SSO)

    Single sign-on (SSO) is a session and user authentication service that permits an end user to enter one set of login credentials ...

SearchHealthIT

SearchDisasterRecovery

  • disaster recovery team

    A disaster recovery team is a group of individuals focused on planning, implementing, maintaining, auditing and testing an ...

  • cloud insurance

    Cloud insurance is any type of financial or data protection obtained by a cloud service provider. 

  • business continuity software

    Business continuity software is an application or suite designed to make business continuity planning/business continuity ...

SearchStorage

  • blockchain storage

    Blockchain storage is a way of saving data in a decentralized network which utilizes the unused hard disk space of users across ...

  • disk mirroring (RAID 1)

    RAID 1 is one of the most common RAID levels and the most reliable. Data is written to two places simultaneously, so if one disk ...

  • RAID controller

    A RAID controller is a hardware device or software program used to manage hard disk drives (HDDs) or solid-state drives (SSDs) in...

Close