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
2 answers

Multiple ID's in a field. Postgresql

So, i'm currently working with a database system where a user can register, login and update his/her details whenever. The database includes 5 roles: 1. Public 2. Member 3. Moderator 4. Coordinator 5. Admin I want to be able to assign multiple…
Anuj Hari
  • 543
  • 3
  • 9
  • 19
2
votes
1 answer

DSE search - Solr multi valued field schema can't be mapped with CAS schema :(

I start my DSE node as Solr node i.e. /dse cassandra -s I then create KS and CF. My CF has KEY field only. I then publish Solr schema and solr config on it. My Solr schema has dynamic field which is indexed and multivalued. I then try to insert…
Sanjeev Dhiman
  • 1,169
  • 1
  • 11
  • 20
2
votes
2 answers

SSRS 2008: Some Multi-Value Paramaters Blank/Unselectable When Creating Subscriptions

I have a report set up with 9 different multi-value parameters. When I go to create a subscription for the report and specify the values of these parameters, only 4 of them will allow me to click on the drop-down list to expand and select options. …
AJH
  • 365
  • 1
  • 4
  • 18
2
votes
3 answers

Limiting / Filtering multivalue fields in Solr

Is there a way to limit, or filter, the returned text of a multivalued field in Solr? Given the following document structure in Solr: ... example bar1 …
dubrie
  • 49
  • 7
2
votes
3 answers

Hashmap - single key, multiple values - How to retrieve?

I am calling a service and I get the XML response in the below format. How do I retrieve multiple values under a single key from this response? I want to store all the values in a List …
rvelagaleti
  • 51
  • 2
  • 5
2
votes
1 answer

Solr - DataImportHandler: When attempting to use column values as field names, multivalued fields only retain the first result

I'm trying to perform a full-import with document configuration similar to the following:
ek1
  • 23
  • 4
2
votes
4 answers

Select From Multi-Value List with Where Clause

I'm trying to select all Projects which have Employees who are AtWork. Projects: ProjName | EmpOnProj -------------------------- Alpha | 1, 2, 3 Beta | 1, 3 Employees: EmpID | EmpName | …
StuckAtWork
  • 1,613
  • 7
  • 23
  • 37
2
votes
1 answer

Reporting Services - Multi-value parameter query returning no results

Using SSRS (SQL Server 2005) I've set up two reports. For ease of explanation, let's call them MAIN_REPORT and SUB_REPORT. MAIN_REPORT runs a query that returns a set of Areas, with multiple TagNames per area: AREA Tagname ---------- A1 …
Jimfletcha
  • 81
  • 3
  • 12
1
vote
1 answer

Apache Solr: Faceted Search on multivalued fields

Im currently working on a solr based search application. I have two multivalued fields for example: The data is read out of a database. 1
SimonH
  • 140
  • 2
  • 17
1
vote
2 answers

NSUserDefaults standardUserDefaults setObject: forKey: not working for Multivalue preference

I am trying to do following task [[NSUserDefaults standardUserDefaults] setObject:@"Dry" forKey:@"vesselType_preference"]; [[NSUserDefaults standardUserDefaults] synchronize]; where my "vesselType_preference" is multivalue attribute, but it is not…
Sunil Pandey
  • 7,042
  • 7
  • 35
  • 48
1
vote
2 answers

mysql select data from a multivalue attribute

How can I run a select query on a multivalue attribute? Does mysql have a function do select certain data from a multivalue field? Much help is appreciated. Here's a sample of the problem: Table userid groups ------------------- 2 …
user962449
  • 3,743
  • 9
  • 38
  • 53
1
vote
1 answer

Solr stats facet left out some values

I want to facet over products in Solr and want to retrieve statistics about the categories. My schema has got a field called categories, a multiValued field. the problem is, that the statistics left out a bunch of categories. Am I wrong with…
sclausen
  • 1,720
  • 3
  • 15
  • 22
1
vote
0 answers

How to deal with a frequently changing multivalued field in Lucene/Solr?

Basically we want to be able to search in various subsets of a large document repository. We are thinking about using a multivalued field to store for each document which subsets it's currently in, and filter on this field when searching. The…
Gary Chang
  • 1,042
  • 12
  • 18
1
vote
2 answers

Solr copyField mixed with RegexTransformer

Scenario: In the database I have a field called Categories which of type string and contains a number of digits pipe delimited such as 1|8|90|130| What I want: In Solr index, I want to have 2 fields: Field Categories_ pipe which would contain the…
mrd3650
  • 1,371
  • 3
  • 16
  • 24
1
vote
3 answers

Multivalue Dependency violation?

i am confused about mvd violation, simply i cant figure out anything that will violate mvd, for example there are A B C three columns, each row is a tuple A B C a2 b2 c1 a1 b1 c2 a1 b1 c3 a2 b3 …
bluedream
  • 999
  • 2
  • 12
  • 15
1 2 3
…
22 23