Re: Continued Values Collection/List/Dictionary - C# Discussion Boards

16-Dec-09 7:48

I am learning further in C# and came across a special requirement of collections. I wonder if such implementations exists.

I need a list with a key and multiple values. After the first entry, next entries can be partial only to denote a change. Something like this:

index	value1	value2	value3		Result		value1	value2	value3
1	100	200	300		-		100	200	300
2			200		-		100	200	200
3	150		300		-		150	200	300
4		250			-		150	250	300
5	100	200			-		100	200	300

This can be achieved using DataTable and using select statements/compute etc. But, is there a simpler option available? Speed is the key here.

----------------------------Question Modified----------------------------------

Please understand that creating a list/dictionary/array/hashtable is not the problem here. Storing the data is easy. This could be done using numeric Key/Index (I can manage to keep indexes of the keys also).

The idea is to be able to look for the last fetched value against each key. The problem comes when I want to retrieve he value without having to loop again. Look at the same example with modified index values.

index	value1	value2	value3		Result		value1	value2	value3
100	100	200	300		-		100	200	300
200			200		-		100	200	200
300	150		300		-		150	200	300
400		250			-		150	250	300
500	100	200			-		100	200	300

Consider the next step. if I want to find out the value for key 250, I would want to look for 200, and then find results for it.

Is it possible without going through loops again?

Current Solution:

I created a class as:

class DataClass
{
    int Value1; int Value2; int Value3
    int ValueIndex1; int ValueIndex2; int ValueIndex3;
}

Then for each entry done, I need to run the loop once to find out the last index for which entry was done against the value and store it.

Dictionary<int, DataClass> entries = new Dictionary<int, DataClass>();
entries.Add(100, new DataClass(100,200,300, 100,100,100);
entries.Add(200, new DataClass(  0,150,  0, 100,200,100);
entries.Add(300, new DataClass(  0,  0,250, 100,200,300);
entries.Add(400, new DataClass(150,  0,  0, 400,200,300);
entries.Add(500, new DataClass(  0,200,  0, 400,500,300);

Now, whenever i need to look for 250, i search for closest smaller key (here that is 200). find values. whatever is available is taken as it is. For all others, find the key in the same record and get the new entries.

This solution works for the first time entries. However it creates problems when an entry is inserted in between. Another logic needs to be built in between.

Can there be something faster than this?
----------------------------------

modified on Thursday, December 17, 2009 12:58 AM

#realJSOP16-Dec-09 9:04

#realJSOP

16-Dec-09 9:04

Have each object maintain a dictionary of values. In the samples you rpovided above:

Index 1 would contain
1,100
2,200
3,300

Index 2 would contain
3, 200

Index 3 would contain
1, 150
3, 300

Index 4 would contain
2,250

Index 5 would contain
1,100
2,200

Use google to learn how to use dictionary collections.

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

Som Shekhar16-Dec-09 19:16

16-Dec-09 19:16

Thanks for the attempt.

I have modified the question for all the responses. Answering the same answer to all replies was not a good idea.

Please give it a read.

Eddy Vluggen16-Dec-09 10:19

16-Dec-09 10:19

Value1, value2 and value3 are distinct entities that you want to track? A dictionary consists of a value and a key. The key would be your index-column, the value could be a struct that holds the three columns;

System.Collections.Generic.Dictionary<int, MyValues> myListOfValues;

struct MyValues
{
   int value1;
   int value2;
   int value3;
}

You could consider the generic list as your datatable, and the struct as a single row in that table. Now you can add values to your dictionary;

MyValues oneRow = new MyValues();
oneRow.value1 = 100;
oneRow.value2 = 200;
oneRow.value3 = 300;
myListOfValues.Add(1, oneRow);

Now, if you want the recreate those values for index 3, you would have to search in the list for the first non-empty value for the column value2.

If speed is important, then I'd create one row outside of that list, just to mirror the current values. That wouldn't help if you need the values from the middle of the index, you'd still have to walk the list for that.

How many records will be in that list? It might just be worth to store copies of the latest value, instead of looking for them.

I are Troll Suspicious | :suss:

Som Shekhar16-Dec-09 19:15

16-Dec-09 19:15

I modified the question to answer all the people who replied. Please read that.

And yes. thanks for the attempt.

Eddy Vluggen16-Dec-09 21:13

16-Dec-09 21:13

Som Shekhar wrote:
Can there be something faster than this?

Yup; don't store the empty values, but do the looping on insert. Meaning that when you insert the values (null, 100, null), that you'll loop the list *at that moment* to fetch the null-values and store them at that index.

It's either a lookup on insert (fast, consumes more memory) or a lookup when you're reading (slower, less memory-pressure).

AFAIK, you can't have both (yet)

I are Troll Suspicious | :suss:

Som Shekhar16-Dec-09 21:28

16-Dec-09 21:28

I prefer anything to be done at the insert stage. So, that's taken.

Storing null values depends if it is an object or a list. In case of an class object constructor may demand all values and hence the null value. It can be skipped if possible.

Doesn't any implementation exist in this format? A very practical example will be Configuration Plans which is time bound. We may only want to save the planned changes and not at every stage.

Eddy Vluggen16-Dec-09 21:34

16-Dec-09 21:34

Som Shekhar wrote:
Doesn't any implementation exist in this format?

I don't know of any in the Framework, but then again, I don't know the entire framework by heart yet.

Som Shekhar wrote:
We may only want to save the planned changes and not at every stage.

Like I said, memory is cheap these days - and I doubt that you'll save a lot by inserting null values for a non-changed field. These kind of constructs are very common in SQL Server, where one would use a query to recreate the full list. The query does the lookups (over a speedy index) and you can read it as if it were the original table.

..but in-memory? Short lists should just store the values in a redundant way, and long lists shouldn't be kept in memory at all.

I are Troll Suspicious | :suss:

Som Shekhar16-Dec-09 21:39

16-Dec-09 21:39

Eddy Vluggen wrote:
Like I said, memory is cheap these days

Memory is not a trouble. Speed is.

This is for a single such list. When this kind of list exist in 100s and each has to be going through a for loop with multiple calculations in between, the calculations go in 0.2-0.3 sec range. this is not too much to look at but with drag and drop, 0.2-0.3 lag is not acceptable. I am just trying to go to 0.05-0.06 sec range.

These kind of change cannot come by simply tweaking a line or two. It can only come by changing the whole method of searching records.

By the way, this whole thing is not even happening in the server/sql. its happening in the memory... hence the speed trouble.

Eddy Vluggen16-Dec-09 21:53

16-Dec-09 21:53

Som Shekhar wrote:
By the way, this whole thing is not even happening in the server/sql. its happening in the memory... hence the speed trouble.

The good news is that memory is usually faster to access then a server Smile | :)

Som Shekhar wrote:
each has to be going through a for loop with multiple calculations in between

The only option that I'm aware of is to precalculate the missing values. That way you only have a lookup in a list, which is quite fast. So, instead of inserting the nulls for the unchanged values, insert the value.

That would move the cost for inserting from the "read from the list"-part to the "add to the list"-part of the code.

I are Troll Suspicious | :suss:

Som Shekhar16-Dec-09 21:56

16-Dec-09 21:56

If you read the modified question, i am saying an index along with as where to lookup again next time.

Saving values instead of null may have problems later one when more values are inserted or removed. The whole purpose of the list is to save the value where changed.

Eddy Vluggen17-Dec-09 1:53

17-Dec-09 1:53

Som Shekhar wrote:
Saving values instead of null may have problems later one when more values are inserted or removed. The whole purpose of the list is to save the value where changed.

It sounded like the main issue was to have a list with values that you can query at a high speed. If you save all the values, then you won't have the problems you mentioned when removing an item;

Col1 Col2 Col3
100  200  300
100  200  100
100  100  100

Remove the second line, all data will still be correct. On the other hand, if you store the null-values (to indicate a non-change), then you might run into trouble;

Col1 Col2 Col3
100  200  300
?    ?    100
?    100  ?

If you remove the second line now, you'll get this;

Col1 Col2 Col3
100  200  300
?    100  ?

Which decodes to this when you try to track back the changes;

Col1 Col2 Col3
100  200  300
100  100  300

As you can see, the last item has changed. I don't see the advantage of storing only the changes in this particular structure, only more challenges Frown | :(

It seems that I don't understand the question well enough to provide you with an answer.

I are Troll Suspicious | :suss:

Som Shekhar17-Dec-09 2:40

17-Dec-09 2:40

Hey there!!!

I really appreciate your efforts.

But the question is to know if I am missing something fundamentally? If there is an implementation already present? Like we have Hashtables, List, Dictionaries for various purposes. Is there any other tool that I missed which can handle such a case?

Or, may be there could be a need to develop such a list which could only record changes, do all the calculations internally, fast enough to match those of dictionary/indexed methods.

In any case, thanks once again.

Eddy Vluggen17-Dec-09 9:34

17-Dec-09 9:34

Som Shekhar wrote:
I really appreciate your efforts.

Nice to see someone who's biting into a subject, instead of just asking for code Smile | :)

Som Shekhar wrote:
But the question is to know if I am missing something fundamentally? If there is an implementation already present? Like we have Hashtables, List, Dictionaries for various purposes. Is there any other tool that I missed which can handle such a case?

Not that I know. Yes, we got generic lists that can take all kinds of data, and we got observable lists that give you a notification if anything changes. But no list that's specialized in doing an incremental save.

I think that most of us would cache the result, storing redundant values. It's a waste of memory, I know, but we often make these kind of trades. If you got some spare CPU-time, then it might make sense to add this optimization. You'll lose a bit of speed reconstructing the data at a particular index, but return you'd have some extra memory.

The guys who work with Windows Mobile might have more experience with this, as they have less resources and actually need to think about using them effectively. On my desktop, I don't mind wasting a megabyte or so, if it means that I can spend my time on more critical issues.

Som Shekhar wrote:
Or, may be there could be a need to develop such a list which could only record changes, do all the calculations internally, fast enough to match those of dictionary/indexed methods.

Again, recalculating the data will (logically seen) cost more processor-time than just reading it. Then again, the time that it takes might be neglectable, and it may also be true that you win back a fair amount of memory. That would depend on the amount of data, and the amount of 'holes' that one has to move through to get the 'last known values' for the columns on that particular index.

At the start of this thread, I would have advised against that on the assumption that there's not much to gain. I'm not that sure anymore. The only way to get a definite answer is by building a prototype and measuring the results. Therein lies another consideration; would it be worth to spend the time on building such a prototype?

I are Troll Suspicious | :suss:

Som Shekhar17-Dec-09 10:12

17-Dec-09 10:12

Eddy Vluggen wrote:
Nice to see someone who's biting into a subject, instead of just asking for code

Coding is easy. Concepts are difficult to grasp. If you know the direction, you can reach anywhere. If you only know the target,god save you.

Eddy Vluggen wrote:
It's a waste of memory

Memory is not really an issue. I am building an application for a bigger use and hence using all kind of hardware resources onto it. I can tell my clients to use better hardware. This means a good speed CPU and a good amount of RAM. Hence I really don't mind 1-2 MB extra here.

I am already looping to create lookup-ready directory. Hence that is already covered.

As I mentioned, The trouble comes when multiple of such calculations happen together. I am currently working on multi-threading of different instances. Atleast to save some more time.

Let me give you a link of another problem that i posted. You would see the use of such a datatype there.
http://www.codeproject.com/Messages/3304858/What-will-be-the-height-of-fluid-columns-in-a-vari.aspx[]

In this problem, calculation of fluid height is needed. There are multiple fluid columns and many such tubes. With drag and drop functionality Frown | :(

Usually working with already implemented concepts is always better. Consider using a dictionary vs. implemented List with key.

Eddy Vluggen wrote:
would it be worth to spend the time on building such a prototype?

You would be surprised that i have come across such situation more than 4-5 times already while designing my applications. I usually work on disconnected database system and speed is a primary concern in loading and saving data.

I initially worked with datatables which worked fine when my application was young. As it grew older, datatables are damn slow. I moved to dictionary. So far, they are fine. Even today, i experience a max lag of 0.5-0.6 sec on a drag drop operation which isn't too much to worry about.

By multi-threading, i hope to reduce it to around 0.1-0.2 which should be manageable. But it is good to keep up with concepts.

Usually a parallel solutions does wonders and thats what I was hoping here.

Eddy Vluggen17-Dec-09 13:13

17-Dec-09 13:13

Som Shekhar wrote:
Coding is easy.

I'm looking at a buglist right now which tells me that it's not as easy as English.

Som Shekhar wrote:
As I mentioned, The trouble comes when multiple of such calculations happen together. I am currently working on multi-threading of different instances. Atleast to save some more time.

Have you seen the article[^] on the AForge.Parallel.For-class? It might help in building a prototype to measure against Smile | :)

Som Shekhar wrote:
In this problem, calculation of fluid height is needed. There are multiple fluid columns and many such tubes. With drag and drop functionality

True, but it would also make an impressive interface Cool | :cool:

Som Shekhar wrote:
Usually working with already implemented concepts is always better. Consider using a dictionary vs. implemented List with key.

I'd try to mirror the concept of a database in-memory; creating a list of the records, and the equivalent of an index. IQueryable[^] springs into mind.

Som Shekhar wrote:
You would be surprised that i have come across such situation more than 4-5 times already while designing my applications. I usually work on disconnected database system and speed is a primary concern in loading and saving data.

I initially worked with datatables which worked fine when my application was young. As it grew older, datatables are damn slow. I moved to dictionary. So far, they are fine. Even today, i experience a max lag of 0.5-0.6 sec on a drag drop operation which isn't too much to worry about.

This post[^] confirms that although databases manipulate data very fast, your results are faster.

Som Shekhar wrote:
By multi-threading, i hope to reduce it to around 0.1-0.2 which should be manageable. But it is good to keep up with concepts.

Usually a parallel solutions does wonders and thats what I was hoping here.

One could consider multiple ways to optimize, and I'm sure that would be some creative ways that'd get posted to do so. Using the Parallel.For class to lookup all the elements could be a good start.

Another, perhaps better implementation yet, would then be a readonly list, to describe a table like presented below. Instead of writing a null, your could launch a short lived thread to calculate it's distance to a yougest version in the list, that disctince gives you the index of the value that it actually stands for. This should be done when you load the data; you'd have to process it a bit of a time decoding it, but that also shortens the amount needed to retrieve data from that list. This would be an optimization on the readprocess, as you can forget about fetching it at all if it's really there. Moving this particular task to the method that's doing the initalization, lookups would be faster. The initialization-routine could also be (ab)used to dynamically enrich your data, if that would be required.

You could then do parallel lookups, each lookup falling back on it's PK - A Perhaps a HashTable<key, record="" [as="" struct!]="">. You'd would then already be pointing at all the correct values, for all correct columns, without having to worry for corruption. That's as long as the read is readonly and easily accessible by threads.

I'm of to bed, this kept going through my head all the time. I wonder if I'm now gonna dream about it?

I are Troll Suspicious | :suss:

Som Shekhar18-Dec-09 18:59

18-Dec-09 18:59

Parallel.For looks promising. Will dig into it.

Currently, since i have already implemented multithreading, I guess no need to implement that for now.

Eddy Vluggen wrote:
True, but it would also make an impressive interface

Oh you bet. These days, looks may not be everything but that is what sells the first.

I guess, that is it for now... I gotta be happy with multithreading for now. Since no other implementation already exist in this area.

It was great having some meaningful conversations. Smile | :)

Eddy Vluggen19-Dec-09 0:48

19-Dec-09 0:48

Som Shekhar wrote:
Oh you bet. These days, looks may not be everything but that is what sells the first.

Sad, but true.

Som Shekhar wrote:
I guess, that is it for now... I gotta be happy with multithreading for now.

You're dividing your workload over multiple CPU's, there's not much room for improvement there. If you get unhappy in the future, try Brahma[^], that would give you the option to offload some work from the CPU to the GPU, abusing the graphics-card.

Som Shekhar wrote:
It was great having some meaningful conversations.

Yup, engaging a conversation is simply more fun than posting an answer. Good luck with your venture Smile | :)

I are Troll Suspicious | :suss:

Som Shekhar19-Dec-09 2:28

19-Dec-09 2:28

Brahma looks interesting!!!

Now, that we are talking of multi threading, why is it that we need to code for multi-threading?

If you look at any operating system that can support multiple processors, it automatically distributes work onto different cores. Can't there be a framework which can do the same without the need to code differently?

If a user defines a program priority as "High" or "RealTime" it only increases the share of thread time to current process. But no change in threading...

Am I missing something?

Eddy Vluggen19-Dec-09 9:41