Feeds

Teradata Universe in Warsaw

Is data warehousing writ large an opportunity for developers?

Remote control for virtualized desktops

After a couple of days with the Teradata people at its Universe Conference 2007 (22-25 April), I'm seriously impressed.

I like Teradata's "one data warehouse" concept, with all the disaggregated data in a normalised store. I like the way it separates the logical views of the data (including the semantic view) from underlying physical database.

And, I think I even understand the use of hashing rather than indexing to get at the stored data and why it is faster (basically, you hash the key to get a unique location on disk, which is a bit less efficient than just adding it in the next available space in an indexed database, but thereafter you can go straight to the data without any indexing overheads) – because that is how IBM's IMS HDAM databases work (albeit IMS is optimised for transaction processing rather than retrieval).

Teradata chooses to market to the largest companies in any space, so its installations are usually big and expensive, but it can scale down – in Finland, for example, it might have customers with comparatively small data warehouses, because there aren't that many people in Finland.

There is also a flourishing developer community and I hope to explore this more in the future. Could there be advantages for a developer moving into a comparatively specialised space such as Teradata application development?

The general theme of the conference is "embracing active enterprise intelligence" - and an excellent point was made that fact-based decision-making often needs near-real-time information and that the real metric for any data warehouse is the active use of its data to make decisions

An interesting announcement at the conference was "multi temperature" data warehousing – automatic management of "hot" (frequently accessed) data and "cold" (less accessed) data in the same warehouse, with management in logical (SLA) terms instead of physical terms.

So, the data you need for near-real-time operational decisions) might be on expensive "enterprise quality" disks and the stuff kept just for contingency regulatory reports on something more commodity level – and this would be transparent to the data users/owners who just specify the appropriate service level. This doesn't handle migration to archive/backup yet, but it might in the future.

This is interesting and (as far as I can see) new to data warehousing. Although, of course, IMS implemented something similar in the OLTP space years ago and IBM has had logical object-based data migration tools for some time.

Another interesting development is a partnership between Microsoft and Teradata, so that Microsoft's excellent BI tools can be used against Teradata data warehouses. I did ask if this was a tacit admission that SQL Server couldn't scale and was told by Microsoft (I paraphrase) "not exactly".

Teradata's conference recital at the Opera House in Warsaw.But Mark Whitehorn points out that Teradata's Inmon-style single warehouse appears to be in conflict with SQLServer's data mart approach (which neatly avoids any scalability issues, for a while at least) and I've asked him to explore this in a future article.

One more thing to remember is that Teradata is splitting off as an independent company from NCR soon, and that might generate new opportunities. On the whole then, an informative conference – and Warsaw's hospitality was excellent. I particularly enjoyed the mezzo recital Teradata provided at its Opera House gala. ®

Beginner's guide to SSL certificates

More from The Register

next story
Download alert: Nearly ALL top 100 Android, iOS paid apps hacked
Attack of the Clones? Yeah, but much, much scarier – report
You stupid BRICK! PCs running Avast AV can't handle Windows fixes
Fix issued, fingers pointed, forums in flames
Microsoft: Your Linux Docker containers are now OURS to command
New tool lets admins wrangle Linux apps from Windows
Facebook, working on Facebook at Work, works on Facebook. At Work
You don't want your cat or drunk pics at the office
Soz, web devs: Google snatches its Wallet off the table
Killing off web service in 3 months... but app-happy bonkers are fine
First in line to order a Nexus 6? AT&T has a BRICK for you
Black Screen of Death plagues early Google-mobe batch
prev story

Whitepapers

Why and how to choose the right cloud vendor
The benefits of cloud-based storage in your processes. Eliminate onsite, disk-based backup and archiving in favor of cloud-based data protection.
Forging a new future with identity relationship management
Learn about ForgeRock's next generation IRM platform and how it is designed to empower CEOS's and enterprises to engage with consumers.
Designing and building an open ITOA architecture
Learn about a new IT data taxonomy defined by the four data sources of IT visibility: wire, machine, agent, and synthetic data sets.
How to determine if cloud backup is right for your servers
Two key factors, technical feasibility and TCO economics, that backup and IT operations managers should consider when assessing cloud backup.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.