Computerworld: MySQL Breaks Into the Data Center

Grok Headline matches for Computerworld: MySQL Breaks Into the Data Center

Computerworld Hong Kong: MySQL Buys
Alzato

Computerworld Hong Kong: MySQL Buys
Alzato 10/29/2003 12:10 AM
"In a bid to make its open source database more scalable and available, MySQL AB on Tuesday acquired Alzato, maker of the NDB Cluster--a data management system designed for the telecom and Internet Protocol environments..."

Computerworld Data Points - CRM

Computerworld Data Points - CRM 09/20/2004 11:07 AM
Designed to further enhance the value of our Special Report, these Powerpoint slides offer key data and statistics about the choices facing today's IT decision makers regarding CRM.

Computerworld Careers Data Points

Computerworld Careers Data Points 04/18/2005 08:42 AM
These PowerPoint slides offer experts' tips on how to advance your career -- and common pitfalls to avoid that can torpedo your progress. This presentation offers advice on everything from how to successfully compete with younger workers, to the wrong way of professional networking.

MySQL Breaks the Mold and Some Records

MySQL Breaks the Mold and Some Records 10/22/2002 08:45 AM

Ariadne Genomics Announces the Release
of Seqware Data Center, Self-Updating
Sequence Data Management and Personal
Blast System

Ariadne Genomics Announces the Release
of Seqware Data Center, Self-Updating
Sequence Data Management and Personal
Blast System 03/14/2005 05:08 PM
Ariadne Genomics, Inc. today announced the release of Seqware Data Center, a sequence data management and personal BLAST software, enabling scientists to easily maintain and search annotated sequence collections. Seqware comes with GenBank pre-loaded. A free trial of Seqware is available at www.ariadnegenomics.com/products/seqware.html. [PRWEB Feb 7, 2005]

Gtk+ MySQL Command Center 0.2.0

Gtk+ MySQL Command Center 0.2.0 06/04/2004 08:37 AM
A GTK+ MySQL client.

Gtk+ MySQL Command Center 0.1.0

Gtk+ MySQL Command Center 0.1.0 05/10/2004 07:13 PM
A GTK+ MySQL client.

MySQL Control Center 0.9.4

MySQL Control Center 0.9.4 12/29/2003 07:14 AM
A GUI client for MySQL databases.

Gtk+ MySQL Command Center 0.2.1

Gtk+ MySQL Command Center 0.2.1 07/02/2004 10:00 AM
A GTK+ MySQL client.

Gtk+ MySQL Command Center 0.2.3 (Default
branch)

Gtk+ MySQL Command Center 0.2.3 (Default
branch) 03/25/2005 01:10 PM
Gtk+ MySQL Command Center is a GUI client for MySQL databases. It will help you to use your MySQL servers, do requests on them, manage their configuration (users, process, etc.), and more.

---

Changes:
This release rewrites all internal dump code, orthogonalizes the GUI code, and adds two flags to server management, "read only" and "warning".

MySQL and Terabytes of Data?

MySQL and Terabytes of Data? 12/06/2002 04:09 PM
It sounds like I'll be helping with some multi-terabyte MySQL tests in the not too distant future. This is good not just because I get to play with neat toys, but it'll finally help me to answer the "how well...

Backing up your MySQL data

Backing up your MySQL data 12/27/2004 03:08 AM
If you have ever pulled your hair out in frustration over data loss, no doubt the word 'backup' has special meaning in your life. Databases offer a nice way to catalog data, but with the amount of data being trusted into MySQL databases these days, the after-effects of an unwise DROP DATABASE command, an unlucky system crash, or a failed hand-edit of the table structure are catastrophic and can be unrecoverable -- unless you have a backup to restore from.

Mysql Data Manager 1.72'

Mysql Data Manager 1.72' 12/25/2003 04:21 PM
Advanced client for Mysql over TCP/IP.

Data Globbing with MySQL Regex

Data Globbing with MySQL Regex 07/13/2004 11:50 PM

As I become a more experienced developer, I'm learning when you should and shouldn't break the rules. While following every rule of programming and data modeling is wonderful, sometimes you need to bend the rules for the sake of simplicity and expediency.

Always remember, an app in the hand is worth a thousand on the white board.

This being the case, lately I've been known to "glob" up data in database fields. Yes, I know this breaks the first normal form — that of atom icity — but there are times when doing it right would involve three more queries, two more database tables, another UI screen, etc. Often it makes the cure worse than the disease.

For instance, consider this little XML document as the contents of the "children" field for one of the records in my "church_attender" table:


<children>
  <child>
    <first_name>Isabella</first_name> ;
    <last_name>Barker</last_name>
  </child>
  <child>
    <first_name>Gabrielle</first_name&g t;
    <last_name>Barker</last_name>
  </child>
</children>



Now if I never wanted to search for individual children, I would make no excuses for this. It saves us a database table, a join, and a ton of complexity in the interface. Life is good.

Searching a globbed up field is a problem, though. We alluded to it in this post when we said:

However, the problem is that the XML field is a black box that — on most database platforms — you can't look inside. What if you want a list of articles written by a particular author? Well, you need to use SQL to get all the XML back, spin that collection, XPath into every single one to find the value author of the author node, then keep that record it matches.

So what if I want to find a person with a child named Gabrielle? Some databases (Oracle, for one), will let you do something like this:


SELECT * FROM church_attender WHERE XPATH(children,'/child/first_name') = 'Gabrielle'


That'd be great, but I don't have Oracle. However, given our experience this week with MySQL regular expressions, how unacceptable would this be:


SELECT * FROM church_attender WHERE children LIKE '%Gabrielle%' AND children RLIKE '<children>.*<child>.*<first_name> Gabrielle </first_name>.*</child>.*</children>'


(Note that there are some extra spaces in there just so the lines would wrap.)

Yes, yes, I know the database Gods would frown on this, but given the enourmous amount of complexity it would save us, is it acceptable? Does the good outweigh the bad?

Fishing for opinions here. Let's hear them.

Click here to comment on this entry

NewsForge: Backing Up Your MySQL Data

NewsForge: Backing Up Your MySQL Data 12/28/2004 07:36 PM
"If you have ever pulled your hair out in frustration over data loss, no doubt the word 'backup' has special meaning in your life..."

Transferring Data to MySQL Using SQLyog

Transferring Data to MySQL Using SQLyog 03/11/2003 01:23 AM
Need any easy way to import data from your ODBC-compliant database into MySQL? Look no further than SQLyog's ODBC Import tool. Read all about it inside.

Adding & Changing Data in MySQL

Adding & Changing Data in MySQL 04/09/2004 04:05 PM
"There are several ways to add and to change data in MySQL. There are a few SQL statements that you can use, each with a few options. Additionally, there are twists that you can do by mixing SQL statements together with various clauses, some of which are available with the release of version 4 of MySQL. In this article, I will explore the ways in which data can be added and changed in MySQL." Story

Zend: Growing a Tree of Data with PHP
and MySQL

Zend: Growing a Tree of Data with PHP
and MySQL 11/12/2002 08:35 AM

Sybase, MySQL, IBM boost data management

Sybase, MySQL, IBM boost data management 04/19/2004 08:26 AM
Database vendors Sybase, MySQL, and IBM are lacing products with features that improve access to information and offer clustering and fault tolerance.

How to access MySQL data in Filemaker
via ODBC

How to access MySQL data in Filemaker
via ODBC 02/10/2004 12:01 PM
In order to import data from a MySQL database into FileMaker 6 via ODBC, do not install the DataDirect ODBC driver that comes with FileMaker. Instead, download the OpenLink one.If you decided to install the DataDirect driver...

Synchronize MySQL Data Using SQLyog Job
Agent

Synchronize MySQL Data Using SQLyog Job
Agent 02/10/2004 02:42 AM
What's the best and most efficient way to synchronize data between two MySQL databases? Using SQLyog Job Agent (SJA)! Karam shows us how to use SJA to your advantage in this quick-and-easy tutorial.

Open Sourcery: Backing Up Your MySQL
Data

Open Sourcery: Backing Up Your MySQL
Data 05/05/2004 08:16 AM
MySQL has had, quite possibly, one of the most impressive climbs to fame of any Open Source based software I know. Of course, with this fame, there are more and more people out there downloading it and setting it up on their servers/home machines. Once it's up and working, though, one of the most common questions is "how can I backup my information?". Well, with a new posting this morning, Open Sourcery hopes to provide you with an easy and quick example.

ACS Builds New Data Center

ACS Builds New Data Center 07/20/2004 01:07 PM
theWHIR Jul 20 2004 5:11PM GMT

PinkRoccade to buy UWV data center

PinkRoccade to buy UWV data center 09/22/2004 02:52 PM
Computer Business Review Sep 22 2004 6:34PM GMT

Virtual Data Center

Virtual Data Center 05/06/2004 02:25 PM
VDC Daily Builds

Virtual Data Center 1.0

Virtual Data Center 1.0 09/23/2004 01:11 PM
An OSS digital library "in a box" for numeric data.

The well-prepared data center

The well-prepared data center 03/23/2005 08:19 PM
ZDNet Mar 24 2005 12:47AM GMT

Jennfomation Data Center

Jennfomation Data Center 06/01/2004 12:25 PM
Former BB guest blogger Jenn Shreve has launched her new personal Web site, the Jennfomation Data Center. Jenn is strictly a writer, but this site is a DIY design tour de force. Jenn cut up exquisite imagery from vintage brochures and books she found at junkyards and on eBay resulting in an ironically industrial aesthetic that's equal parts El Lissitzky and 1980s 'zine. The text is great too! Link

The Data Center of the Future

The Data Center of the Future 12/16/2003 04:07 PM
Internet.com Dec 16 2003 3:13PM ET

AlphaZeta Launches Data Center

AlphaZeta Launches Data Center 09/15/2004 02:59 PM
theWHIR Sep 15 2004 6:47PM GMT

HostMySite.com Opens New Data Center

HostMySite.com Opens New Data Center 05/10/2004 08:22 PM
theWHIR May 11 2004 0:02AM GMT

BEA, Veritas in Data Center Deal

BEA, Veritas in Data Center Deal 04/13/2004 12:39 PM
theWHIR Apr 13 2004 5:13PM GMT

IBM, Cisco sync up in data center

IBM, Cisco sync up in data center 04/29/2004 07:46 AM
CNET Apr 29 2004 11:46AM GMT

IBM, Cisco synch up in data center

IBM, Cisco synch up in data center 04/28/2004 11:12 PM
The two companies unveil an alliance to more tightly integrate Cisco switches and networking gear with Big Blue's management software, server and service offerings.

Google Data Center Experiments

Google Data Center Experiments 03/14/2005 05:11 PM
This mega thread focuses on one core issue: "There seems to be some confusion (myself included) over whether some DCs are being used to return results to the user (public) or simply as a juggling vehicle for algo changes."

What 2007 means to your data center

What 2007 means to your data center 06/12/2004 03:38 PM
Part I: The SMP revival

One Google Data Center Updated

One Google Data Center Updated 01/24/2004 10:16 AM

The ultimate data center manager

The ultimate data center manager 03/31/2005 05:10 AM
The TV show “Monk” features a detective who’s obsessive-compulsive. He gets bent out of shape over a picture hanging off-center on a wall, or papers that aren’t lined up 100% evenly on a desk. The joke is that his attention to detail is what makes him a great detective (and an impossible person to work with).

Inkra VSS Used for Data Center Research

Inkra VSS Used for Data Center Research 01/23/2004 04:13 PM
theWHIR Jan 23 2004 8:34PM GMT
Grok Description matches for Computerworld: MySQL Breaks Into the Data Center
GrokA matches for Computerworld: MySQL Breaks Into the Data Center

Computerworld: MySQL Breaks Into the Data Center

The following phrases have been identified by the grok system as matching this entry: