Close
  • Latest News
  • Cybersecurity
  • Big Data and Analytics
  • Cloud
  • Mobile
  • Networking
  • Storage
  • Applications
  • IT Management
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Menu
Search
  • Latest News
  • Cybersecurity
  • Big Data and Analytics
  • Cloud
  • Mobile
  • Networking
  • Storage
  • Applications
  • IT Management
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Database
    • Database

    Seven Steps to Effective Database Automation

    By
    Chris Preimesberger
    -
    March 23, 2017
    Share
    Facebook
    Twitter
    Linkedin

      PrevNext

      1Seven Steps to Effective Database Automation

      Seven Steps to Effective Database Automation

      For companies developing applications, one step is often the most painful: managing database changes. In fact, anything to do with creating and managing databases can be painful. It involves a lot of manual labor to make sure database changes are in sync with application changes. Managing and deploying database updates is by far the slowest and riskiest part of the application-release process. This is why an IT cottage industry, led by Quest Software and others, has been so successful in providing third-party database management tools that make life easier for DB admins. In this eWEEK slide show, Pete Pickerill, co-founder of Datical, discusses the pillars of effective database automation. These data points represent what is required to bring database change management practices in line with modern app development and IT operations practices.

      2Keep DBA and Devs on the Same Page at All Times

      Keep DBA and Devs on the Same Page at All Times

      Changes in the database are often made by both the application developer and the database administrator (DBA). The application developer typically has a good understanding of why a change is being made and the impact that change will have on the rest of the product. However, this is not the case for the DBA, the person who is actually handling the change. DBAs are simply informed that the change is necessary and hope they deploy everything they should and don’t deploy anything they shouldn’t.

      3STEP 1 in DB Change: Tightly Associate It With Dev Effort

      STEP 1 in DB Change: Tightly Associate It With Dev Effort

      The first step in packaging a database change is to tightly associate it with the development effort it supports. By tying changes to their features, DBAs are able to associate the activity with the driver more quickly and trace whether or not all of the appropriate schema components for an application change have been applied.

      4STEP 2: Tie New Features to Release Vehicle

      STEP 2: Tie New Features to Release Vehicle

      The second step of packaging is then tying the features to the appropriate release vehicle. This allows DBAs to better understand and participate in the application release process, especially as modifications to the established plan are made. If all changes are tightly associated with their feature and release, it becomes much easier to move those features in and out of releases without missing anything or grabbing too much.

      5STEP 3: Validate Automation All Around

      STEP 3: Validate Automation All Around

      Validation is focused on implementing automation with a human touch. This speeds the process of change validations without sacrificing the safety inherent in manual reviews. Recovering from a bad database change can be difficult, if not impossible. To avoid making a bad change in the first place, there are two levels of validation that must occur. Over time, databases serving the same application can drift out of sync due to their persistent nature and the manual process of updating them. To compensate for these possible differences, the first layer of validation should confirm that the database is in the appropriate state to successfully receive the changes.

      6STEP 4: Always Stick With Best Practices

      STEP 4: Always Stick With Best Practices

      The second level of validating a change is making sure it adheres to best practices, organizational standards and compliance requirements. To provide this in an automated fashion, a fully customizable validation mechanism must be present. DBAs must be able to configure automation to find the same things they look for when reviewing a change. If a change does not violate any policies in the rule suite, the change can pass through the system unhindered. However, if a change does violate a rule, the system will be stopped and the DBA will be alerted. From there, the DBA can accept or reject the change, and the process starts again. By only involving the DBA for manual review when it’s absolutely necessary, change moves through the system faster without sacrificing quality or security.

      7STEP 5: Avoid Triaging Batches of Errors

      STEP 5: Avoid Triaging Batches of Errors

      The current practice of manually processing a batch of scripts—and triaging the errors that arise until everything is eventually successful—must stop. The new deployment process should be simple and identical in every environment in the life cycle to ensure the same validation and consistency that enables other application components to be released worry-free. This can be partially accomplished by employing the first two data points above to ensure completeness and validity of the changes to be deployed. Once that’s taken care of, it’s simply one-click.

      8STEP 6: Tracking Must Be Automated

      STEP 6: Tracking Must Be Automated

      Database change tracking methods are largely manual, which introduces the possibility of human error and prevents us from truly trusting the various artifacts we use to piece the puzzle together. Therefore, tracking must happen automatically. Data must be collected and stored when a managed environment is materially changed. Removing the reliance on human action to track these changes leads to tracking data that is high quality, consistent and complete.

      9STEP 7: Go and Do the Integration

      STEP 7: Go and Do the Integration

      The tool chains employed by application development groups are as varied as they are powerful. There are a wide variety of IDEs, source code control solutions, infrastructure providers, build systems and deployment offerings. No matter what individual products make up a group’s chain of delivery, the integration between them is seamless. Your tools should integrate and collaborate as you do. When choosing a database change management solution for agile enablement, organizations should not be forced to limit options for tools that handle other areas of the process. Information should flow freely between the tools, and the tools should be easily invoked by any and all orchestration platforms so the flexibility to implement or change any other link in the chain is there.

      PrevNext

      MOST POPULAR ARTICLES

      Android

      Samsung Galaxy XCover Pro: Durability for Tough...

      Chris Preimesberger - December 5, 2020 0
      Have you ever dropped your phone, winced and felt the pain as it hit the sidewalk? Either the screen splintered like a windshield being...
      Read more
      Cloud

      Why Data Security Will Face Even Harsher...

      Chris Preimesberger - December 1, 2020 0
      Who would know more about details of the hacking process than an actual former career hacker? And who wants to understand all they can...
      Read more
      Cybersecurity

      How Veritas Is Shining a Light Into...

      eWEEK EDITORS - September 25, 2020 0
      Protecting data has always been one of the most important tasks in all of IT, yet as more companies become data companies at the...
      Read more
      Big Data and Analytics

      How NVIDIA A100 Station Brings Data Center...

      Zeus Kerravala - November 18, 2020 0
      There’s little debate that graphics processor unit manufacturer NVIDIA is the de facto standard when it comes to providing silicon to power machine learning...
      Read more
      Apple

      Why iPhone 12 Pro Makes Sense for...

      Wayne Rash - November 26, 2020 0
      If you’ve been watching the Apple commercials for the past three weeks, you already know what the company thinks will happen if you buy...
      Read more
      eWeek


      Contact Us | About | Sitemap

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Property of TechnologyAdvice.
      Terms of Service | Privacy Notice | Advertise | California - Do Not Sell My Information

      © 2021 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×