M-A-O-L

MySQL and the forks in the road:

At the beginning of 2008 Sun Microsystems purchased MySQL AB, and ever since then there have been divisions in the ecosystem. As with any software community or ecosystem, where there are divisions there are usually forks, both in the community and the software itself.

MySQL history lesson.

When is “ACID” ACID? Rarely.

ACID and NewSQL databases rarely provide true ACID guarantees by default, if they are supported at all

Not even Oracle or DB2 provide full ACID (in distributed scenarios at least).

Updated database landscape graphic:

I recently published an updated version but noted that there were a group of database vendors that had emerged in 2012 that didn’t easily fit into the segments we’d created.

It’s so much better… Good overview for anybody interested in understanding the DB world beyond just whatever one or two products or technologies they already know.

SQL Server 2008 SP3 is now available!

A few customers requested updates in Microsoft SQL Server 2008 SP3 are:

• Enhanced upgrade experience from previous versions of SQL Server to SQL Server 2008 SP3. In addition, we have increased the performance & reliability of the setup experience.
• In SQL Server Integration Services logs will now show the total number of rows sent in Data Flows.
• Enhanced warning messages when creating the maintenance plan if the Shrink Database option is enabled.
• Resolving database issue with transparent data encryption enabled and making it available even if certificate is dropped.
• Optimized query outcomes when indexed Spatial Data Type column is referenced by DTA Database Tuning Advisor.
• Superior user experience with Sequence Functions e.g Row_Numbers in a Parallel execution plan.

Go get it!

Oracle docs show plans for Hadoop, NoSQL about the Oracle Loader for Hadoop, and Added Session: Big Data Appliance about Oracle’s Big Data Appliance.

And another one leaving the relational world for their DBaaS offering. It’s probably easier to manage as a service than Oracle…

Today SAP announced that they are using MongoDB as a core component of SAP’s platform-as-a-service (PaaS) offering. MongoDB was selected for the enterprise content management (ECM) section of the platform, as its flexibility and scalability will enable SAP to scale its content management service on its PaaS offering to meet customers’ requirements while managing data from different applications

Via MongoDB Selected as the Core Content Management Component of SAP’s PaaS Offering.

Exadata Mini is the Oracle DB Appliance (ODBA?), as Oracle announced now.

It turns out that Oracle’s new small appliance isn’t really an Exadata Mini-Me. Rather, the Oracle Database Appliance is — well, it seems to be a box with an Oracle DBMS in it. Plus Oracle RAC and so on.

via Oracle Database Appliance soundbites and Database Appliance for the Masses.

Oracle Openworld must be close, because the rumour mill starts heating up… Piper Jaffray is predicting that Oracle will release an Exadata Mini machine that will fit under ones desk (via DBMS2). And Jean-Pierre Dijcks compiled a list of Big Data related sessions at Openworld, Big Data may very well be the key note topic, I hear, so it’s worth spending some time at these sessions.

Some Sybase PR about their latest release: Sybase Adaptive Server Enterprise 15.7 Boosts Performance and Lowers Cost of Managing Exploding Data Volumes

ASE 15.7 further reduces cost of operations by simplifying administration and enhancing system security, providing a database manager that remains easy to manage while protecting against intrusion. ASE 15.7’s online operations and extended diagnostic features increase data availability, optimize the data for application performance and quickly pinpoint bottlenecks to speed performance. Strong password encryption and single login profiles protect the database from unauthorized external access attempts and make it easier to manage large numbers of users.

Sybase 15.7 is quite a major update to 15.5, there are more details in the Sybase ASE 15.7 New Features guide.

Oracle’s MySQL Blog reports about New Commercial Extensions for MySQL Enterprise Edition:

MySQL 5.5 GA and MySQL 5.6 Development Milestone Releases have delivered many new compelling features to the MySQL users and community for testing, feedback and use.

In addition, commercial customers have access to a number of commercial extensions already included in MySQL Enterprise Edition:

• MySQL Enterprise Monitor
• MySQL Enterprise Backup

Continuing the business model of MySQL, we are adding three new commercial extensions to MySQL Enterprise Edition:

• MySQL Enterprise Scalability
• MySQL Enterprise High Availability
• MySQL Enterprise Security

Via Heise, who have some coverage in German.