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

February 22, 2024

Check Point® Software Technologies Ltd. introduces Check Point Quantum Force series: an innovative lineup of ten high-performance firewalls designed to meet and exceed the stringent security demands of enterprise data centers, network perimeters, campuses, and businesses of all dimensions.

February 22, 2024

Tabnine announced that Tabnine Chat — the enterprise-grade, code-centric chat application that allows developers to interact with Tabnine AI models using natural language — is now available to all users.

February 22, 2024

Avaamo released Avaamo LLaMB™, a new low-code framework for building generative AI applications in the enterprise safely, securely, and fast.

February 21, 2024

CAST announced the winter release of CAST Imaging, an imaging system for software applications, with significant user experience (UX) enhancements and new features designed to simplify and accelerate processes for engineers who develop, maintain, modernize, complex software applications.

February 21, 2024

Pulumi now offers native ways to manage Pinecone indexes, including its latest serverless indexes.

February 21, 2024

Orkes, whose platform offers the fastest way to scale distributed systems, has raised $20 million in new funding.

February 20, 2024

JFrog and Carahsoft Technology announced a partnership that empowers U.S. Government organizations to safeguard their software supply chains with automated DevSecOps workflows to secure software services consumed by citizens.

February 20, 2024

Multiplayer, a collaborative tool for teams that work on system design and distributed software, announced its public beta.

February 20, 2024

DataStax announced its out-of-the-box retrieval augmented generation (RAG) solution, RAGStack, is now generally available powered by LlamaIndex as an open source framework, in addition to LangChain.

February 20, 2024

UiPath announced new features in its platform designed to enable developers to build, test, and accelerate implementation of automations.

February 15, 2024

Kong announced a suite of open-source AI plugins for Kong Gateway 3.6 that can turn any Kong Gateway deployment into an AI Gateway, offering unprecedented support for multi-Language Learning Models (LLMs) integration.

February 15, 2024

ngrok unveiled early access to its API gateway-as-a-service.

February 15, 2024

Tabnine announced a strategic partnership with DigitalOcean.

February 15, 2024

Salt Security announced that the Salt Security API Protection Platform is now available for purchase in the CrowdStrike Marketplace, a one-stop destination for the world-class ecosystem of CrowdStrike compatible security products.

February 14, 2024

Perforce Software signed a definitive agreement to acquire Delphix.