471,066 Members | 1,616 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,066 software developers and data experts.

data clustering.

Hello all,

My bulk data is sitting on a big table. I cluster its rows using views
and SQL-UDFs. So far it was ok, but its performance will become an
issue soon. Therefore I am looking for alternatives.

Any recommendation will be greatly appreciated.

Thanks in advance.

Mehmet Baserdem

Nov 14 '06 #1
2 1475
"Mehmet Baserdem" <mb*******@gmail.comwrites:
My bulk data is sitting on a big table. I cluster its rows using
views and SQL-UDFs. So far it was ok, but its performance will
become an issue soon. Therefore I am looking for alternatives.
What is the need for the clustering? what do you get from it.

You may want to look at MDC (multi-dimension clustering) or table
partitioning which are two ways to do this.

I am assuming you are running on DB2 LUW (Linux, Unix and Windows).

--
Haider
Nov 15 '06 #2

Mehmet Baserdem schreef:
Hello all,

My bulk data is sitting on a big table. I cluster its rows using views
and SQL-UDFs. So far it was ok, but its performance will become an
issue soon. Therefore I am looking for alternatives.

Any recommendation will be greatly appreciated.

Thanks in advance.

Mehmet Baserdem
If you mean 'blobs' by 'bulk data' you could store your blob data in
files and just put the pointer to the file in your table. Haven't used
this myself but I know DB2 UDB supports this kind of data.

Nov 16 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by GBartgo | last post: by
1 post views Thread by Nico de Groot | last post: by
2 posts views Thread by Leonardo C | last post: by
2 posts views Thread by vibha vyas | last post: by
11 posts views Thread by chmmr | last post: by
3 posts views Thread by dejavue82 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.