Databases Archive

A beginner’s guide to NoSQL

Let’s say you’ve decided to set up a website or an application. You'll obviously need something to manage the data. Yes, that's right, a database. So, what is it going to be? MySQL, MS-SQL, Oracle or PostgreSQL? After all, nothing can be as amazing as a good old RDBMS that employs SQL to manage the data.

Well, allow me to introduce to you an entirely unique and unconventional Database model - NoSQL.

First Look: Oracle NoSQL Database

InfoWorld's Peter Wayner takes a first look at Oracle NoSQL Database, the company's take on the distributed key-value data store for the enterprise. 'There are dozens of small ways in which the tool is more thorough and sophisticated than the simpler NoSQL projects. You get a number of different options for increasing the durability in the face of a node crash or trading that durability for speed,' Wayner writes. 'Oracle NoSQL might not offer the heady fun and "just build it" experimentation of many of the pure open source NoSQL projects, but that's not really its role. Oracle borrowed the best ideas from these groups and built something that will deliver good performance to the sweet spot of the enterprise market.'

10 Essential FOSS Tools For MySQL

MySQL toolmaker Daniel Nichter provides a look at 10 must-have free and open source tools for MySQL. 'MySQL has attracted a vibrant community of developers who are putting out high-quality open source tools to help with the complexity, performance, and health of MySQL systems, most of which are available for free,' writes Nichter, who was named 2010 MySQL Community Member of the Year for his work on maatkit. From mydumper, to mk-query-digest, to stalk and collect, the list compiles tools to help back up MySQL data, increase performance, guard against data drift, and log pertinent troubleshooting data when problems arise, each of which is a valuable resource for anyone using MySQL, from a stand-alone instance to a multiple-node environment.

‘Save MySQL’ Campaign Gains Momentum

A petition launched in December by MySQL creator Michael 'Monty' Widenius to 'save' the open-source database from Oracle has quickly gained momentum, collecting nearly 17,000 signatures. Widenius on Monday submitted an initial batch of 14,174 signatures to the European Commission, which is conducting an antitrust review of Oracle's acquisition of Sun Microsystems, MySQL's current owner. The petition calls for authorities to block the merger unless Oracle agrees to one of three "solutions", including spinning off MySQL to a third party and releasing all past versions and subsequent editions for the next three years under the Apache 2.0 open-source license.

Cloudera Desktop Released, Simplifies Hadoop Even More

A while back, we covered the release of the free Cloudera distribution of Hadoop-- handy software to manage data across a multiplicity of servers-- the same software behind Yahoo!, Facebook, and other successful companies. Though Hadoop and Cloudera's Hadoop have been truly stellar at what they do, it's all essentially been done via command line, which for many people isn't the most productive or user-friendly type of interface. The folks at Cloudera knew this, so they've gone ahead and created a graphical interface to communicate with Hadoop.

Cloudera Distribution of Hadoop Available, Makes Hadoop Easy

Hadoop, the same software that lies at the heart of successful companies such as Google, Facebook, Yahoo!, and others, has been proven time and again with said companies to be a successful data management server, keeping data secure and fault-free spread across multiple servers. It isn't the easiest piece of software to configure, however, which is why the Cloudera company has just announced a freely downloadable and easier to use custom distribution of Hadoop to bring the power of entities like Google to smaller businesses.

MySQL Founder Leaves Sun

Michael "Monty" Widenius, original author and founder of MySQL, has announced he has now resigned from Sun to start his own company, Monty Program Ab. Rumours of his departure had circulated last September and Widenius now confirms these had an element of truth to them. According to him, his issues with MySQL 5.1 GA were pivotal in the decision making process and his public warnings of those problems "had the wanted effect". That effect was an agreement to stay on for three months to "help Sun work out things in MySQL development" and allow Sun to "create an optimal role for me".

An Atomic Level of Data Storage

In an almost indiscernible and confusing article filled with various scientific terms that most cringe to hear, it was described how in October of 2008 scientists successfully stored and retrieved data on the nucleus of an atom-- and all for two short lived seconds. With this new type of storage, a traditional bit can now be both zero and one at the same time, but in order to understand just how this is possible, translate the article linked above to plain English. Data integrity returns after two seconds at 90% and storage is obviously impermanent, so there are many kinks to work out before atomic storage actually serves a purpose, but give these scientists a couple of decades, and it's theoretical that we'll one day have nuclear drives the size of USB drives today (or MicroSD cards, or why not even specs of dust?) that can hold hundreds of terabytes-- even pentabytes-- of information.

Sun Buys MySQL AB

MySQL AB and Sun have announced that MySQL has been bought by Sun. "Sun Microsystems today announced it has entered into a definitive agreement to acquire MySQL AB, an open source icon and developer of one of the world's fastest growing open source databases for approximately USD 1 billion in total consideration. The acquisition accelerates Sun's position in enterprise IT to now include the USD 15 billion database market. Today's announcement reaffirms Sun's position as the leading provider of platforms for the Web economy and its role as the largest commercial open source contributor." More here.

Size Isn’t Everything for the Modest Creator of SQLite

"In a world of people obsessed by turning the tiniest idea into something profitable, Dr Richard Hipp's best-known software stands out for two reasons - he actively disclaims copyright in it; and at a time when multi-megabyte installations are booming, he has a self-imposed limit on the size of his product: 250KB. And he's stuck to both aims. 'I think we've got 15 kilobytes of spare space,' he says of the headroom left in the code."

SQL Server 2005 Gets Second Service Pack

Microsoft has released a second free service pack for its popular SQL Server 2005 database application. The update makes SQL Server 2005 compatible with Microsoft's new Windows Vista operating system and Office 2007 suite, and adds a number of data compression, manageability and interoperability enhancements. Microsoft has also changed the terms under which SQL Server 2005 can be run using virtualisation software.