The Register® — Biting the hand that feeds IT

Feeds

IBM database strategy chief on DB2: Devs are people too

Big Blue looks beyond DBAs for input on features

Agentless Backup is Not a Myth

Developers are exerting greater influence on new versions of IBM’s DB2 database, according to one of Big Blue's information management strategy chiefs.

Bernie Spang, director of strategy and marketing for database software and systems, said while IBM has historically consulted DBAs on new features they’d like in IBM’s mighty database, that has changed.

In an interview with El Reg, Spang said IBM is now taking a more balanced approach. “It’s not shifted from one to the other, it’s got to be both,” he told us.

Driving the change is a need to make DB2 more comfortable for developers building web and big data apps that suck on the DB2 data store.

One recent consequence of the shifting approach was the addition of tripled graph-store capabilities for graph analytics in DB2 10.1, which was released in April.

Graph stores find connections between data, so you don’t have to search through piles of relational tables or raw info using Hadoop. Graphs are popular with social networks like Facebook and LinkedIn trying to establish connections between individuals on their sites.

Looking ahead, Spang called key-value pairs a “hot area”. This might be one possibility for future inclusion in DB2.

“It’s going to be driven by the application developers, that’s what’s pushing this, which is different historically – historically we’ve spoken to the DBAs,” Spang said of the recent and future changes.

“I got asked in one interview: ‘Did the DBAs ask for the RDF triple store?’ No, the DBAs didn’t ask for that, it’s for those who want a simpler structure to do things in a different way,” the strategy boss said.

“It was same with XML,” he said. IBM announced XML in DB2 10 years ago with XQuery – the programming language to query XML.

Spang continued: “The DBAs said: ‘I don’t want to put XML in my relational database' and we said: 'Right – we are giving you the same software, it’s just a different structure.' It’s a way for the app developers to find ways that are going to be faster, simpler easier for them.”

Support for XML gave DB2 and its associated tools the ability to combine structured and unstructured data, with the ability to search the data’s metadata.

IBM’s feeling its way on new capabilities like RDF data store in DB2.

Graph data is stored using the Resource Definition Framework (RDF) and queried using the SPARQL query language to look for triple patterns, conjunctions, disjunctions and optional patterns.

“We will bring it [RDF] in, see how it goes, and if this turns out to be a relatively small niche or a passing fad, because the next thing comes along and supersedes it, we will evolve,” Spang said.

Regcast training : Hyper-V 3.0, VM high availability and disaster recovery

Next page: Risky business

> Big Data is even more of a nose bleed.

I hear that in Japan, extreme sexual excitement is depicted by nosebleeds. So here?

1
0
Anonymous Coward

Re: @IBM: Fix the Basics First

No issues when using SQLJ and DB2... Nothing Microsoft makes works well with anything that isn't made by Microsoft. ODBC is, for all intents and purposes, Microsoft technology. Oracle's ODBC drivers are nothing to write home about either. Java connections, JDBC and SQLJ, are the standard.

You can connect to DB2 with ODBC (below), but if you absolutely need to use .NET, I would use ado.net as it is slightly faster and built into the default .NET framework. DB2 works with ado.net.

http://support.microsoft.com/kb/216428

0
0

Re: @IBM: Fix the Basics First

Totally agree, both the IBM-supplied one and the MS one are complete piles of dog shit

0
0

More from The Register

Bjarne Again: Hallelujah for C++
Plus: Now officially OK to admit you never used STL algorithms
Interwebs taunt Sir Jony over Apple eye candy makeover
Hey Ive, Ive... add more unicorns, willya?
SCO vs. IBM battle resumes over ownership of Unix
Zombie lawsuit back and wants to suck the brains out of Linux
Apple: iOS7 dayglo Barbie makeover is UNFINISHED - report
Plus: You don't like the icons? Blame marketing
Red Hat to ditch MySQL for MariaDB in RHEL 7
So long, Oracle! Don't let the door hit you on the way out
Shy? Socially inadequate? Fiddling with your phone could help
App 'tells the brutal truth' about social inadequates' chatup lines
Java EE 7 melds HTML5 with enterprise apps
New release arrives with GlassFish, NetBeans support
 breaking news
'Office Facebook' firm Tibbr wants you to PAY for mobe-meetings app
Great idea. Punters won't cough for it though
 breaking news
The only Waze is Google: Ad giant tipped to gobble map app 'for $1.3bn'
Pac-Man-satnav-ish upstart in bidding war with Apple, Facebook
 breaking news
PM Cameron calls for modern, programmable computers! (We think)
IT education musings to G8 chiefs to mystify IT industry