Achieve Database Compliance with DevOps
January 19, 2017

Yaniv Yehuda
DBmaestro

The task of managing many ongoing technology projects, coupled with the need to continuously amend and improve systems for meeting reporting requirements, sometimes serves as an obstacle for enterprises in implementing Continuous Delivery practices for the database. In a number of surveys, common automation issues cited by DBAs include an inability to determine who made what changes to the database and the possibility of version control scripts not being updated, which can result in executing the wrong revision in production, thus creating bugs or application crashes.

Yet, enterprises taking advantage of modern, effective DevOps for Database solutions find that it's possible to implement the same Continuous Delivery best practices, which prove valuable in application development, for the database, enabling true database automation that actually mitigates the risk of human error while simultaneously speeding development cycles. The end result is less downtime, fewer errors, and a reduction in development costs.

While continuous delivery can speed development and help reduce costly downtime, regulatory database compliance remains a sticking point for modern enterprises. With the fast-paced wave of regulation, technology should be serving as a tool that helps to achieve compliance and combat regulatory constraints, rather than a roadblock to meeting compliance.

Enterprises successfully navigate these challenges, balancing the need for innovation, fast-paced development, and risk management with regulatory compliance, by implementing DevOps for Database solutions to actually leverage technology to meet compliance requirements. This is achieved through:

■ Proper database version control for structure, code, and content, while enforcing a single work process to prevent out of process changes, code overrides, and incomplete updates.

■ Leveraging proven version control best practices, such as check-in, check-out functionality to document complete information for regulatory reporting, including who made changes to a database object, what changes were made, and when and why the changes were introduced. This results in a complete, reliable audit trail while minimizing manual documentation requirements for developers.

■ Reliable impact analysis for deployment generators, relying on baseline-aware analysis (not simple compare-and-sync), offering the ability to deal with conflicts and merges of the database code – even cross-updates from dispersed teams – and also dealing with out-of-process changes and ignoring wrong code overrides.

■ Defined access levels (down to individual objects and data), which completely prevents unauthorized changes to the database, maintaining the quality and integrity of the database and associated data while still enabling complete and functional access for every team member on-demand.

Security and regulatory compliance are increasing concerns for companies in today's complex business climate. The database presents a more substantial concern because unauthorized database changes can spell disaster.

Adopting an effective DevOps for Database solution helps companies successfully manage and secure multiple database environments in order to create applications and drive business results. By combining security and database change management capabilities, customers can better address critical database security vulnerabilities and their ability to meet audit and compliance requirements.

Yaniv Yehuda is Co-Founder and CTO of DBmaestro
Share this

Industry News

August 18, 2022

GitHub Enterprise Server 3.6 is now generally available.

August 18, 2022

Opsera announced the availability of Opsera GitCustodian.

August 18, 2022

CircleCI announced the general availability of the CircleCI Visual Configuration Editor, an all-in-one open source project for configuration editing, including creating component definitions and usages.

August 17, 2022

Cloudera announced the launch of Cloudera Data Platform (CDP) One, an all-in-one data lakehouse software as a service (SaaS) offering that enables fast and easy self-service analytics and exploratory data science on any type of data.

August 17, 2022

Prosimo introduced a new NetDevOps Infrastructure-as-Code (IaC) Toolkit that enables enterprises to accelerate the deployment of cloud networking.

August 17, 2022

Aqua Security announced the addition of cloud security posture management (CSPM) capabilities to the open source tool Aqua Trivy.

August 16, 2022

Canonical welcomes the .NET development platform, one of Microsoft’s earliest contributions to open source projects, as a native experience on Ubuntu hosts and container images, starting in Ubuntu 22.04 LTS.

August 16, 2022

Veracode announced the launch of the Veracode Velocity Partner Program.

August 16, 2022

Render announced a new monorepository feature that enables its customers to keep all of their code in one super repository instead of managing multiple smaller repositories.

August 15, 2022

Gadget announced Connections, a major new feature that gives app developers access to building blocks that enable them to build and scale ecommerce apps in a fraction of the time, at a fraction of the cost.

August 15, 2022

Opsera is on the Salesforce AppExchange to help enterprise customers shorten software delivery cycles, improve pipeline quality and security, lower operations costs and better align software delivery to business outcomes.

August 15, 2022

Virtusa Corporation earned the DevOps with GitHub on Microsoft Azure advanced specialization, a validation of a services partner's deep knowledge, extensive experience and proven success in implementing secure software development practices applying DevOps principles and using Azure and GitHub solutions.

August 15, 2022

Companies looking to reduce their cloud costs with automated optimization can now easily procure CAST AI via Google Cloud Marketplace using their existing committed spend.

August 11, 2022

Granulate, an Intel Company, announced the upcoming launch of its latest free cost-reduction solution, gMaestro, a continuous workload and pod rightsizing tool for Kubernetes cost optimization.

August 11, 2022

Rezilion announced the availability of MI-X, a newly created open-source tool developed by Rezilion's vulnerability research team.