Browse Definitions :
Definition

database automation

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

SearchCompliance
  • compliance risk

    Compliance risk is an organization's potential exposure to legal penalties, financial forfeiture and material loss, resulting ...

  • information governance

    Information governance is a holistic approach to managing corporate information by implementing processes, roles, controls and ...

  • enterprise document management (EDM)

    Enterprise document management (EDM) is a strategy for overseeing an organization's paper and electronic documents so they can be...

SearchSecurity
  • Extensible Authentication Protocol (EAP)

    The Extensible Authentication Protocol (EAP) is a protocol for wireless networks that expands the authentication methods used by ...

  • session key

    A session key is an encryption and decryption key that is randomly generated to ensure the security of a communications session ...

  • data breach

    A data breach is a cyber attack in which sensitive, confidential or otherwise protected data has been accessed and/or disclosed ...

SearchHealthIT
SearchDisasterRecovery
  • risk mitigation

    Risk mitigation is a strategy to prepare for and lessen the effects of threats faced by a business.

  • call tree

    A call tree is a layered hierarchical communication model that is used to notify specific individuals of an event and coordinate ...

  • Disaster Recovery as a Service (DRaaS)

    Disaster recovery as a service (DRaaS) is the replication and hosting of physical or virtual servers by a third party to provide ...

SearchStorage
  • cloud storage

    Cloud storage is a service model in which data is transmitted and stored on remote storage systems, where it is maintained, ...

  • cloud testing

    Cloud testing is the process of using the cloud computing resources of a third-party service provider to test software ...

  • storage virtualization

    Storage virtualization is the pooling of physical storage from multiple storage devices into what appears to be a single storage ...

Close