Database Blog

  • MySQL and MariaDB Encryption Options

    Dec 10, 2019

    Reading Time: 4 minutes MySQL and MariaDB Encryption Options Encryption remains one of the most widely used cornerstones of data security across organizations of all sizes and industries. Why? In many cases it’s both effective and relatively simple to implement. There are two fundamental encryption capabilities that are almost universally necessary for basic data security: The ability to encrypt sensitive data “at rest”—that is, where it resides on disk—is a critical security capability for many organizations and applications, as…..

    Read more Add new comment
  • Database Patch News — November 2019 (Issue 1)

    Oct 29, 2019

    Reading Time: < 1 minute Welcome to Database Patch News, Buda Consulting’s monthly newsletter of current patch information for Oracle and Microsoft SQL Server. Here you’ll find information on available patches—including security patches—and desupported versions made available during the past month.

    Read more Add new comment
  • MySQL Fabric: The Best of NoSQL and Relational Databases

    Jul 12, 2014

    Reading Time: 2 minutes Oracle Corp. is currently the world’s second-largest software vendor—and it isn’t going to let a little thing like unstructured data stand in its way. With the recent release of its MySQL Fabric technology, which is meant to meet the demands of cloud- and web-based applications, Oracle is positioning itself to dominate the big data landscape. Most enterprise data is still stored in relational databases written in SQL. To handle diverse data types and increase the…..

    Read more Add new comment
  • MySQL Parser Deficiencies

    Jul 5, 2013

    Reading Time: 3 minutes MySQL is a very popular database for many applications. But the parser has some important deficiencies that developers need to be aware of. The parser is inconsistent and not robust in the way that it enforces statement syntax. This may lead to ambiguity and application defects that are very difficult to find. I include one example below and link to another blog article that discusses another. Inadequate Group By Parsing The MySQL group by function…..

    Read more Add new comment
  • Relational Database Design: It’s All About The Set

    Dec 5, 2011

    Reading Time: 5 minutes The Lost Science of Relational Algebra and Set Theory. I originally wrote this post in 2011. Much has changed in the database technology landscape since then. Big Data Technologies such as Hadoop have gone mainstream, cloud technology and is changing how and where we think about hosting our databases. But relational databases are still relied upon as the best option for rich transactional data. So, since this technology is still the foundation of our mission critical…..

    Read more Add new comment
  • Query Rewrite: What is MySQL Doing To My Queries?

    Nov 30, 2011

    Reading Time: < 1 minute The Impact of Query Rewrite on MySQL Query Optimization When processing a query, every relational database vendor takes a number of similar steps to parse, validate, and optimize a query. MySQL does the following: Validates the query syntax — does it use valid operators, are the clauses in the proper order, etc. Validates the query semantics — are the the objects (tables, views, columns) valid database objects in the database, etc. Transforms the query —…..

    Read more Add new comment
  • Storing documents in a MongoDB database instead of the file system

    Jul 9, 2010

    Reading Time: < 1 minute We are currently working on an application that uses a mysql database. The application produces a large number of csv files that must be kept around for a few weeks, and then removed after being used in various ways by the users of the system. We need to keep track of all of these files and present a list of the files to the user so they can download them to their local machine, or send…..

    Read more Add new comment