473,320 Members | 1,865 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 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 1565
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: GBartgo | last post by:
Hi everybody, I don't know how to initialize the weight vector of each node in the tree. The input is a set of N data in M dimensions. I have to realize a software based on the article "S-TREE:...
1
by: Nico de Groot | last post by:
I have a 2 node Microsoft 2000 cluster with a shared storage device. I want to create automatic failover for MS SQL 2000 server. I can do that wit the following options: 1. Active/Pasive (one...
2
by: Leonardo C | last post by:
Hi: I'm trying to setup a MS Cluster but I don't know if it is feasible to configure it in the way I think. I have two machines with win2k server and MSSQL-2000 one of them is currently...
1
by: willie | last post by:
Hi all: I have a clustering SQL Server on Node1 and Node2, the Node1 has named Instance1 and Node2 has named Instance2, no default instance. We tested it that everthing is OK, then we decide to...
7
by: janet | last post by:
HI, We had some data which had low cardinality (86) , the count for that table is 9 million rows. How to optimize query which involve joining this table on that column? I'm not sure if...
2
by: vibha vyas | last post by:
Hello sir We have a very huge database its around 6 lakh records are being stored in it. records are not being a sorted order so we checked all record field through clustering option in Sql...
11
by: chmmr | last post by:
Hi, I am currently in the process of gathering info/experiences for an incoming Linux DB2 clustering phase we actually know nothing about (since we are doing it for the first time ever), so I...
0
by: fionab | last post by:
Reading, Berkshire, UK - Crainiate Software announce the release of Objecto Framework 1.0, a new component framework 5 years in development, designed to make it easy for programmers to create agile...
3
by: dejavue82 | last post by:
Hi, Does anybody know of a software package that allows for several servers, running asp.net 2.0 to be clustered, regardless of where they are located (ie. without a hardware load balancer)....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.