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
0
votes
1 answer

Oracle multi value parameter error

I am using below query in SSRS 2008 and I am getting an error when I click the 'Next' button on the Design Query window in Report Wizard. "An error occurred while the query design method was being saved. ORA-00911: invalid character" SELECT…
CoolArchTek
  • 3,729
  • 12
  • 47
  • 76
-1
votes
2 answers

Inserting multivalues from textbox into the MySQL Database using PHP

I'm having a problem with my PHP and MySQL project . I wanted to insert multi collumn value into the database but the truth is, im already confused by the codes. it's like this if you would like to take a look: if(!empty($_POST['brando'])){ …
Rfqkml
  • 51
  • 1
  • 2
  • 9
-1
votes
1 answer

Is there any workaround for sorting on multiValued field?

Sorting can be done on the "score" of the document, or on any multiValued="false" indexed="true" field provided that field is either non-tokenized (ie: has no Analyzer) or uses an Analyzer that only produces a single Term (ie: uses the…
ajreal
  • 46,720
  • 11
  • 89
  • 119
-1
votes
1 answer

How to upload file to Amazon S3 in UniBasic/UniData using the REST API, AWS Signature Version 4

I need to upload file to AWS S3 service, in UniBasic/UniData. The requirement is to call Amazon S3 HTTP REST API directly in UniBasic, using AWS Signature Version 4. Any examples out there?
Marvado
  • 1
  • 3
-1
votes
1 answer

SQLite set multiple values to specific foreign key

I have two tables in SQLite, article and keyword table. In the article table, I have some columns like article name, article year ... and also article keyword. I set the article keyword column as a foreign key and connect it to the keyword…
amirhossein
  • 56
  • 4
-1
votes
1 answer

Changing MultivalueMap keys throws ConcurrentModificationException

I have MultivalueMap and a TreeMap, both have key-value of type String. I wish to change any key in my MultivalueMap to keys found in my TreeMap. This is my code, why do I get ConcurrentModificationException and how to solve it? public…
Tal Angel
  • 1,301
  • 3
  • 29
  • 63
-1
votes
1 answer

Using multi value field to count number of mult value fields that occurred in an event

I'm a new analyst for a small collection of cardiology practices (to give some context). I am looking for a way to group combinations of CPT codes (IDs used for a specific procedures) and use them to count the number of tests (tests are often a…
H_Pearson
  • 1
  • 1
-1
votes
1 answer

How do I select values of a multivalue combobox using VBA in MS Access 2010?

I have a MS Access 2010 form with a "Company" combobox and an "address" multivalue combobox. When a company is selected the AfterUpdate event requeries the address combobox so that only addresses relevant to the company are listed. This works…
Symanb
  • 17
  • 1
  • 6
-1
votes
3 answers

SQLite Table with Multi-valued attributes

I would like to create a table that can store, say, the Title or Name of something in the first column, and then have associated people or objects in the next column. The problem is that there may be multiple people associated with the same Title or…
V1rtua1An0ma1y
  • 597
  • 2
  • 10
  • 16
-2
votes
1 answer

How to select a single digit from a MULTI-VALUE field?

I have the following table with '' as a special character: Column 1 Column 2 1 13 2 1312 3 315 4 1613 5 15311 I want to select only those records where Column 2 has 3 between special characters. I have used a built-in…
Nauman Khan
  • 7
  • 3
-3
votes
1 answer

In Python, how do I return a record multiple times based on a multi-value column

In Python, I have the following data. (Note: Below I display the data in a tabular format for easy reading, but the data is actually in a properly formatted csv file.) ID,Movie,tag 1,Fury,#action #war 2,Shrek,#cartoon #comedy #fantasy …
James Frick
  • 65
  • 4
-8
votes
2 answers

Splitting dict by multi values and one of the keys

I have a multivalue dictionary and unique key, I need to have one key for each value data = { "id": [123,456,546,311], "info": ["info1","info2","info3"], . . . } need this answer: data = { "id": [123], "id":…
Ali Nemati
  • 184
  • 5
1 2 3
…
22
23