Feeds

Teradata Universe in Warsaw

Is data warehousing writ large an opportunity for developers?

Providing a secure and efficient Helpdesk

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. ®

Secure remote control for conventional and virtual desktops

More from The Register

next story
'Windows 9' LEAK: Microsoft's playing catchup with Linux
Multiple desktops and live tiles in restored Start button star in new vids
Not appy with your Chromebook? Well now it can run Android apps
Google offers beta of tricky OS-inside-OS tech
New 'Cosmos' browser surfs the net by TXT alone
No data plan? No WiFi? No worries ... except sluggish download speed
Greater dev access to iOS 8 will put us AT RISK from HACKERS
Knocking holes in Apple's walled garden could backfire, says securo-chap
NHS grows a NoSQL backbone and rips out its Oracle Spine
Open source? In the government? Ha ha! What, wait ...?
Google extends app refund window to two hours
You now have 120 minutes to finish that game instead of 15
Intel: Hey, enterprises, drop everything and DO HADOOP
Big Data analytics projected to run on more servers than any other app
prev story

Whitepapers

Secure remote control for conventional and virtual desktops
Balancing user privacy and privileged access, in accordance with compliance frameworks and legislation. Evaluating any potential remote control choice.
Saudi Petroleum chooses Tegile storage solution
A storage solution that addresses company growth and performance for business-critical applications of caseware archive and search along with other key operational systems.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?
Security for virtualized datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.
Providing a secure and efficient Helpdesk
A single remote control platform for user support is be key to providing an efficient helpdesk. Retain full control over the way in which screen and keystroke data is transmitted.