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

Elastic Search multi-value field aggregation

My indexed documents have a schema: { ... 'authors': [{'first name': 'John', 'last name': 'Smith'}, {'first name': 'Mark', 'last name': 'Spencer'}] ... } I would like to search them and aggregate by the individual authors, so…
stpk
  • 2,015
  • 1
  • 16
  • 23
0
votes
1 answer

How to write a function using arrays as input parameter in postgres 8.2

I am fairly new to Postgres and would like help with writing function that has an array as input parameter. I am using the function for a SSRS report and would like to add multiselect functionality CREATE OR REPLACE FUNCTION foo(facid bigint,…
katie
  • 23
  • 5
0
votes
2 answers

SSRS: is there a way to display a multivalued parameter in a table?

Using SSRS 2012 I have a multivalue parameter in a report and I would like to make it the source of a table. Is there a way to accomplish this? I'm coming to the conclusion that one cannot make the data source of a table anything except a…
PBMe_HikeIt
  • 659
  • 8
  • 24
0
votes
2 answers

Is there a more efficient way to handle multi-valued attributes other than creating a relationship table?

I have three tables, tbl_school, tbl_courses and tbl_branches. Each course can be taught in one or more branches of a school. tbl_school has…
Zulfi Ansari
  • 29
  • 7
0
votes
1 answer

Selecting tuples from a multivalue attribute

I'm trying to get a query for the following example, where I need to select all people who have played for the same team (or the same and others) as some person. For example person teamName 1 maple leafs 1 rangers 2 red wings 3 …
errorline1
  • 350
  • 1
  • 6
  • 18
0
votes
1 answer

Sitecore Solr DateTime range filter

I want to create a custom index for query datetime range (Event datetime) in sitecore content search (SOLR). I want to store datetime ranges like 2010-01-01 - 2010-02-02 2010-02-02 - 2011-03-21 .... and get items back as fast as possible. Is it…
Chrissx
  • 357
  • 1
  • 7
0
votes
0 answers

I want to add pagination on Solr multivalued fields

I have the Solr XML response below using this query: http://localhost:8983/solr/trl/select/?indent=off&facet=false&wt=xml&fl=title,overallscore,service,reviewdate&q=:&fq=id:315&start=0&rows=4&sort=reviewdate%20desc I want to add paging on the…
Adam
  • 6,041
  • 36
  • 120
  • 208
0
votes
1 answer

Last element of multivalued field in solr

Is there any way to get last element of multivalued field in solr. I want to run a query with search string present as the last element of multivalued field.Help would be really appreciated.
user199354
  • 505
  • 1
  • 5
  • 17
0
votes
1 answer

push multivalue elements to array in titanium (JS)

In titanium im accessing the phone book and i have an array with contact information (single and multi-value fields). i have troubles with the multi-value emails field. the multi-value fields stringified objects looks like this (work, home, other as…
user24957
  • 315
  • 3
  • 11
0
votes
0 answers

solr 3: multivalued field omitTermFreqAndPositions is ignored

We have 20mil document solr index which contains multiValued fields of numbers. We have omitNorms="true" omitTermFreqAndPositions="true" , but looks like solr still calculating idf and tf for the field. Is there any other way except creating custom…
usearch
  • 65
  • 1
  • 13
0
votes
1 answer

Multivalue parametres in SSRS- display in the report

I just started working with SSRS, so this question might seem silly. Anyway, for now I'm trying to avoid multi-valued parameters, because I want my parameters to be able to be NULL. So I'm just passing a comma-separated string of ID values to my…
Masha
  • 327
  • 1
  • 6
  • 17
0
votes
1 answer

update multi value dictionary in python

I am trying to update a specific value in a two-dimensional dictionary where each set of key holds several values. My script is somewhat along these lines: #!/usr/bin/python mylist=['a', 2, 3, 4] mydic = {} mydic[mylist[0]] = mydic.get(mylist[0],…
user3595396
  • 5
  • 2
0
votes
1 answer

How save multiple values JSONStore

I need to replace multiple value in JSONStore of IBM Worklight. In this way is saved only first value. Why? .then(function() { for (var index = 0; index < elencoSpese.length; index++) { …
Marco
  • 199
  • 1
  • 5
  • 14
0
votes
1 answer

SOLR error: Multi-valued field XXX should be mapped to either List or Set types

I'm trying to create a SOLR core and getting this error message: Multi-valued field md5checksum should be mapped to either List or Set types I don't understand it, because my schema specifically says multiValued="false" for field…
Joshua Richardson
  • 1,827
  • 22
  • 22
0
votes
1 answer

Multi-value parameter used with execute(@sql)

I'm having a hard time trying to figure out how to make this work : I have a big SQL query used for a report, that is run using "execute(@sql)". Withing @sql I have various select statements that I would like to filter using the values in the…
user3340627
  • 3,023
  • 6
  • 35
  • 80
1 2 3
…
22 23