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

Networking
Security
  • personally identifiable information (PII)

    Personally identifiable information (PII) is any data that could potentially identify a specific individual.

  • zero-day vulnerability

    A zero-day vulnerability is a security loophole in software, hardware or firmware that threat actors exploit before the vendors ...

  • DNS attack

    A DNS attack is an exploit in which an attacker takes advantage of vulnerabilities in the domain name system.

CIO
  • data collection

    Data collection is the process of gathering data for use in business decision-making, strategic planning, research and other ...

  • chief trust officer

    A chief trust officer (CTrO) in the IT industry is an executive job title given to the person responsible for building confidence...

  • green IT (green information technology)

    Green IT (green information technology) is the practice of creating and using environmentally sustainable computing resources.

HRSoftware
  • diversity, equity and inclusion (DEI)

    Diversity, equity and inclusion is a term used to describe policies and programs that promote the representation and ...

  • ADP Mobile Solutions

    ADP Mobile Solutions is a self-service mobile app that enables employees to access work records such as pay, schedules, timecards...

  • director of employee engagement

    Director of employee engagement is one of the job titles for a human resources (HR) manager who is responsible for an ...

Customer Experience
  • digital marketing

    Digital marketing is the promotion and marketing of goods and services to consumers through digital channels and electronic ...

  • contact center schedule adherence

    Contact center schedule adherence is a standard metric used in business contact centers to determine whether contact center ...

  • customer retention

    Customer retention is a metric that measures customer loyalty, or an organization's ability to retain customers over time.

Close