Are there any databases that can store multidiimensional boolean arrays?



I'm helping someone on another newsgroup but I need to know something. This
person wants to store a four dimensional boolean array, i.e.
boolean[][][][], in a column of a database. There are 53,000 entries in a
single occurrence of this array and they wan to store over 200,000 instances
of the array, one in each row of the table.

Ideally, that array could be stored as an Object of type boolean[][][][]:
then the user wouldn't have to turn it into something else for storage and
then convert it back when reading it. Are there any databases that can do
that? Or would I inevitably have to convert this array into a simpler object
like a String to store it? For example, it wouldn't be hard to convert this
boolean array:

boolean[] myArray = {true, false, true};

to a String like this:

String myString = "TFT"; //T=true; F=false

I know that JDBC has setObject() and getObject() methods but I'm really not
clear on how they are used, even after reading the API. It appears that I
still have to identify the object as one of the standard java.sql.Type
values and boolean[][][][] is NOT a standard java.sql.Type!

Can anyone shed some light on this for me?

--
Rhino


.



Relevant Pages

  • Re: Finding the nearest match without reusing results
    ... comparing an array with a value generates an array of Trues and ... Any diff with wrong State or with used Store is implicitly zeroed out. ... Each must be larger than the absolute value of the maximum Sales ... go.....it just needs to return the closest match. ...
    (microsoft.public.excel.programming)
  • Re: read keyboard input and storing in an array?
    ... > I'm trying to store user input in an array, ... You have the beginnings of that logic already since your prompt tells the ... 201st value since the array only has room for 200 values. ... This will force you to store the int values as Integer ('Integer' ...
    (comp.lang.java.help)
  • Re: Data From CREATEOBJECT
    ... the first column and the "key" in the second. ... The array is public so that all of the objects can find it and the main program can find all of the objects. ... So there is no need to store it once more in the array. ... If it is a variable set of properties, then it might be better to build a long string of the property names and the respective values and store this string in a memo field. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: what is the best datatype for..
    ... If you are only going to store it, then use a string. ... each value in the array, check to see if it already exists in the ... If it does, then just increment the count, otherwise, add ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Challenge: reading ascii data
    ... to store all the data before producing any output. ... would be bad practice in terms of memory consumption to use a standard ... So I use hashes to create a two-level "sparse array", ... Well the original problem definition was: ...
    (comp.lang.fortran)