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

March 28, 2024

Check Point® Software Technologies Ltd. announced a collaboration with Microsoft that utilizes the Microsoft Azure OpenAI Service to enhance Check Point Infinity AI Copilot, marking a significant advancement in cyber security AI applications.

March 28, 2024

ArmorCode announced ArmorCode Risk Prioritization, providing a 3D scoring approach for managing application security risks.

March 28, 2024

AppViewX and Fortanix announced a partnership to offer cloud-delivered secure digital identity management and code signing.

March 27, 2024

WaveMaker has updated its platform in response to customer demand for more sophisticated API and code management tools.

March 27, 2024

Vercara announced the launch of UltraAPI™, a product suite that protects APIs and web applications from malicious bots and fraudulent activity while ensuring regulatory compliance.

March 27, 2024

Legit Security announced the launch of its standalone enterprise secrets scanning product, which can detect, remediate, and prevent secrets exposure across the software development pipeline.

March 26, 2024

Progress announced a strategic partnership with Veeam® Software, the #1 leader by market share in Data Protection and Ransomware Recovery, to provide customers with an enterprise-ready cyber defense solution that strengthens the security of their business-critical data.

March 26, 2024

GitGuardian released its Software Composition Analysis (SCA) module.

March 26, 2024

DataStax announced a milestone in its journey to simplify enterprise retrieval-augmented generation (RAG) for developers by integrating with Microsoft Semantic Kernel.

March 25, 2024

Check Point® Software Technologies Ltd. is collaborating with NVIDIA to enhance the security of AI cloud infrastructure. Integrating NVIDIA BlueField DPUs, which feature a broad range of purpose-built, innovative security capabilities, the new Check Point AI Cloud Protect solution will help prevent threats at both the network and host levels.

March 25, 2024

Sentry announced the release of Autofix, an AI-powered feature to debug and fix code in minutes, saving important time and resources.

March 25, 2024

Apiiro announced a product integration and partnership with Secure Code Warrior, the agile developer security training platform, to extend its ASPM technology and processes to the people layer.

March 21, 2024

Progress announced that Progress® Semaphore™, its metadata management and semantic AI platform, was named a Champion in SoftwareReviews’ 2024 Metadata Management Emotional Footprint Awards.

March 21, 2024

The Cloud Native Computing Foundation® (CNCF®) has partnered with Udemy, an online skills marketplace and learning platform.

March 21, 2024

GitLab has acquired Oxeye, the provider of a cloud-native application security and risk management solution.