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
76
votes
3 answers

What is the use of "multiValued" field type in Solr?

I'm new to Apache Solr. Even after reading the documentation part, I'm finding it difficult to clearly understand the functionality and use of the multiValued field type property. What internally Solr does/treats/handles a field that is marked as …
Gnanam
  • 10,613
  • 19
  • 54
  • 72
29
votes
4 answers

How To Use Multi Value Title and Value From Settings Bundle

I have a multi value setting (location) defined in my settings bundle for an app. The Titles are defined as long titles, for example, "London" and the corresponding value part of the setting is defined as "1". [EDIT] To expand this question I will…
motionpotion
  • 2,656
  • 6
  • 42
  • 60
25
votes
7 answers

Is there a way to query multiple hash keys in DynamoDB?

Is there a way to query multiple hash keys using a single query in Amazon's AWS SDK for Java? Here's my issue; I have a DB table for project statuses. The Hash Key is the status of a project (ie: new, assigned, processing, or complete). The…
DGolberg
  • 2,109
  • 4
  • 23
  • 31
20
votes
8 answers

SSRS Multi Value Parameter. Check whether "Select All" is selected

I have a multi value parameter in my SSRS Report. I want to find out whether (Select All) is checked in that parameter. In other words, whether all the values in the parameter are checked or only some values are checked. Is it possible? I am able…
Sathya
  • 332
  • 1
  • 3
  • 10
17
votes
3 answers

Is there a multivalued field type available in PostgreSQL?

I want to know if it is possible to store multiple values in a field in PostgreSQL. I have a table called Token with the columns id, text and category. category is a multivalued field. Is it necessary to create a separate table for it or is there a…
Renato Dinhani
  • 35,057
  • 55
  • 139
  • 199
9
votes
1 answer

JCR SQL2 Multivalue properties search

I want to do a search in the content repository using one or more of the values as an input parameter for a multivalue property Something like: find all nodes with the primary type 'nt:unstructured' whose property 'multiprop' (multivalue property)…
silverb77
  • 279
  • 5
  • 16
9
votes
3 answers

What Java data structure is best for two-way multi-value mapping

I'm relatively new to Java and I have a question about what type of data structure would be best for my case. I have a set of data which are essentially key-value pairs, however each value may correspond to multiple keys and each key may correspond…
user4588937
  • 101
  • 4
9
votes
2 answers

How to add distinct values in a multivalue field in solr

I have a multivalue field called category(which is also a store field) in which i need to add only distinct values value1 value2 If I do a update as follows
Jagadesh
  • 6,489
  • 8
  • 29
  • 30
9
votes
8 answers

Multivalued Fields a Good Idea?

I have recently been introduced to the new Access 2007 feature which is multivalued fields. My initial impression is that it is a bad idea to make use of multiple values in a single field. Traditionally if you wanted to allow for a record to have…
stimms
  • 42,945
  • 30
  • 96
  • 149
7
votes
3 answers

Illegal method called

I have a Java class which handles both single valued and multi-valued data. Therefore, it exposes two methods: getValue() and getValues(). However, I want to throw some kind of exception when the getValue method is called for multi-valued data. What…
Neel
  • 2,100
  • 5
  • 24
  • 47
7
votes
1 answer

SSRS: How to set Multiple Values on ParameterValue object?

The code below gets the values I have entered for my report parameters in a Windows interface I have written for SSRS. However this only works for parameters that do not allow MultiValue. Since Parameter.Value is a string, I don't know how to assign…
user259286
  • 977
  • 3
  • 18
  • 38
7
votes
3 answers

Passing multivalue parameter to a subreport

I'm having a problem when working with multivalue parameters between reports. I have a main report in which I have defined a multivalue paramer, which I use to run a SQL query to populate its dataset. The parameter is used in the WHERE clause in the…
monican
  • 353
  • 2
  • 3
  • 9
6
votes
2 answers

Django haystack, How to search for a ManyToMany related field?

I've added a MultivaluedField to my index (haystack), I need to search for a ManyToMany related field, but it doesn't work. The engine is WHOOSH. This how my index looks like: class PostIndex(SearchIndex): text = CharField(document=True,…
Félix
  • 579
  • 4
  • 21
6
votes
1 answer

Search for document in Solr where a multivalue field is either empty or has a specific value

I have a multivalue field in Solr, and want to query for documents where this field is either empty, or contains a specific value.
neu242
  • 15,796
  • 20
  • 79
  • 114
6
votes
3 answers

How would I search for blank facets in a multi valued facet field and at the same time in Solr?

I have an application where users can pick car parts. They pick their vehicle and then pick vehicle attributes as facets. After they select their vehicle, they can pick facets like engine size, for example, to narrow down the list of results. The…
Dan
  • 555
  • 3
  • 11
  • 16
1
2 3
…
22 23