Stack Overflow
Stack Overflow

Questions tagged [multivalue]

The term "multivalue" refers to a nested data structure where a data column in a database table can contain multiple levels of nested columns.

In some databases, such as the namesake MultiValue database, an example of which is UniVerse, a number of top-level columns can be associated with each other, so that the data in, for example column 1, sub-column 2 has a direct relationship with the data in column 2, sub-column 2.

An example structure could look as follows:

Column one being order numbers, column 2 being order dates and column 3 being part numbers:


Column 1: 00001]00002]00003
Column 2: 26/07/12]27/07/12]28/07/12
Column 3: P123^P124]P125]P126

Multivalue data structures can often lead to excellent performance, one of the reasons being that they eliminate the need for resource consuming table joins.

Apart from the original MultiValue Databases, other examples which use multivalued data structures are many of the NoSQL databases and many Business Intelligence and Reporting tools.

342 questions
2
votes
1 answer

Pick/UniBasic Field function that operates with a delimiter of more than one character?

Has there ever been an implementation of the field function (page 311) in the various flavors of Pick/UniBasic etc. that would operate on a delimiter of more than one character? The documented implementations I can find stipulate one character as…
spencer741
  • 965
  • 1
  • 10
  • 22
2
votes
3 answers

How do I perform these common administrator D3 multivalue tasks in jBASE?

jbasemultivalue-databasepickmultivalue This is how D3 lists the accounts in the system. SORT ONLY MDS WITH A1 = "D]""Q" Not sure how to do this in jBASE. This is how D3 lists the users that can log into the system. SORT USERS Not sure how to do…
JohnW
  • 23
  • 4
2
votes
3 answers

SSIS excluding multiple items in a foreach loop

I have a file system that contains a variable number of folders These folders may or may not contain a file destined for further processing There are certain folders I wish to exclude from processing The list of excluded folders is comma delimited…
TPV
  • 61
  • 1
  • 5
2
votes
2 answers

MulitvaluedMap to MultivaluedMap

I have a MultivaluedMap strMap which i want to convert to MultivaluedMap objMap. I tried exploring a few routes in the post below but none of them seem to work. Converting Map to Map
Pi Horse
  • 2,350
  • 8
  • 30
  • 51
2
votes
0 answers

Understand Elasticsearch Multivalue Fields

I am trying to understand the position_increment_gap as it is explained on the Elasticsearch documentation https://www.elastic.co/guide/en/elasticsearch/guide/current/_multivalue_fields_2.html I created the same index as in the example and inserted…
user2434291
  • 149
  • 11
2
votes
1 answer

GQL: Not equal filter on a multivalued property

Tinkering a little with GAE's datastore i've found that i can't think a proper way to filter out results using the inequality filter '!=' on a multivalued property: class Entry(db.Model): ... tags = db.StringListProperty() e1 = Entry() e2 =…
Gianluca Bargelli
  • 1,780
  • 2
  • 17
  • 23
2
votes
2 answers

SQL Database multiple values for same attribute - Best practices?

I have found myself that some attributes from my Person table, need to hold multiple values/choices, which is not a good SQL practice so I created a second table, like this: Before: Person table -ID (ex. 101) -Name (ex. John) -Accessories (ex.…
Norbert Forgacs
  • 605
  • 1
  • 8
  • 27
2
votes
3 answers

U2 UniVerse: update a multivalue field

I have a DICT that is set as a multivalue. When opening TCL, and doing an UPDATE DICT.FILE SET Blah = 'Y' statement, I get the following error: Correlatives are illegal for UPDATE, column "Blah" How can I update a specific attribute in a multivalue…
vinco83
  • 467
  • 1
  • 4
  • 16
2
votes
4 answers

Multiple inputs multivariate data visualisation

I am trying to visualise multivariate data model by reading them from multiple input files. I am looking for a simple solution to visualise multiple category data read from multiple input csv files. The no. Of rows in inputs range from 1 to 10000s…
Sitz Blogz
  • 1,061
  • 6
  • 30
  • 54
2
votes
2 answers

How to find length/size of a key in a MultivaluedMap?

MultivaluedMap map= new MultivaluedMapImpl(); map.add("Accept-Encoding", "compress;q=0.5"); map.add("Accept-Encoding", "gzip;q=1.1"); map.add("Accept-Encoding", "gzip;q=1.2"); map.add("Accept-Encoding", "gzip;q=1.3"); How can I find the size of the…
Rakesh B
  • 47
  • 1
  • 1
  • 9
2
votes
1 answer

Solr 4.10 - Suggester is not working with multi-valued field

Hello everyone i am using solr 4.10 and i am not getting the result as per my expectation. i want to get auto complete suggestion using multiple fields that is discountCatName,discountSubName and vendorName. i have a created multi-valued field…
Dipti Ranparia
  • 570
  • 5
  • 17
2
votes
0 answers

How to pass a multivalued field to a custom function

I’ve been reading answers around this problem but I wanted to make sure that there is another way out of my problem. The thing is that the solution shouldn’t be on index-time, involve indexing a new field or changing this multi-valued field to a…
fjaguero
  • 185
  • 10
2
votes
1 answer

Nested multi value specifiers in iPhone app's Settings bundle

I am trying to add nested multi value specifiers to my app's Settings bundle (something like what is done in the "Region Format" section of the International settings in the Settings app). I have tried to use a PSMultiValueSpecifier for the first…
Paloma
  • 21
  • 2
2
votes
0 answers

elasticsearch search for exact match in multi valued field with urls relevant to document

I'm very new to elasticsearch and got stuck with forming the search queries, or rather using the ElasticSearch PHP Client what i'm trying to do is the following: we have 500,000 documents, with various properties that are available for each…
Alex Smirnov
  • 537
  • 1
  • 5
  • 12
2
votes
1 answer

Pass checkbox list multiple selected value to stored procedure through one parameter

i have checkbox list to select multiple value ,now i want to pass this multiple selected value to my stored procedure using one parameter insert into tblAccessRights (roleid,customerid,SubcustomerId) values(@_roleid,@CustomerId,@SubcustomerId,) in…
shweta
  • 319
  • 2
  • 8
  • 21
1 2 3
…
22 23