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

Extensions de fichiers et formats de fichiers

Motorisé par:

SearchCompliance

  • compliance framework

    A compliance framework is a structured set of guidelines that details an organization's processes for maintaining accordance with...

  • regulatory compliance

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

  • privacy compliance

    Privacy compliance is a company's accordance with established personal information protection guidelines, specifications or ...

SearchSecurity

SearchHealthIT

  • telemedicine (telehealth)

    Telemedicine is the remote delivery of healthcare services, such as health assessments or consultations, over the ...

  • Project Nightingale

    Project Nightingale is a controversial partnership between Google and Ascension, the second largest health system in the United ...

  • medical practice management (MPM) software

    Medical practice management (MPM) software is a collection of computerized services used by healthcare professionals and ...

SearchDisasterRecovery

  • crisis management plan (CMP)

    A crisis management plan (CMP) outlines how to respond to a critical situation that would negatively affect an organization's ...

  • disaster recovery (DR) test

    A disaster recovery test (DR test) is the examination of each step in a disaster recovery plan as outlined in an organization's ...

  • business continuity plan (BCP)

    A business continuity plan (BCP) is a document that consists of the critical information an organization needs to continue ...

SearchStorage

  • kilobyte (KB or Kbyte)

    A kilobyte (KB or Kbyte) is a unit of measurement for computer memory or data storage used by mathematics and computer science ...

  • megabytes per second (MBps)

    Megabytes per second (MBps) is a unit of measurement for data transfer speed to and from a computer storage device.

  • zettabyte

    A zettabyte is a unit of measurement used by technology professionals and the general public to describe a computer or other ...

Close