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

SSRS 2008 URL click-through with multi-value parameter not working but works if the string is manually entered

I'm attempting to create drill-through functionality to another report using Text Box Properties > Action > Go to URL , all parameters that are in the drill-through report are included in the url expression to ensure no defaults within the drill…
Adrian Torrie
  • 2,795
  • 3
  • 40
  • 61
0
votes
2 answers

Solr Multivalued date range from two separate field as sub entity

I am a Apache Solr beginner. My data-config.xml contains this code ...
Sadat
  • 3,493
  • 2
  • 30
  • 45
0
votes
0 answers

pros/cons of combining values in a column and then exploding it in mysql

I been doing some research on normalization for mysql db. I realized that it's much more easier to have multiples tables rather than one table. I'm guessing it's much more easier to have a column for different values than combining it in one column.…
Sam Bo
  • 23
  • 3
0
votes
0 answers

Google App Engine Datastore multi-valued properties matches only when having > 1 values

I have a data table as follows. When I execute the GQL from the Admin Console: SELECT * FROM DbFeed WHERE broadcasterAccountNames='gmnexuss@gmail.com' The result I got is only 1 row, which is the one with id=10001. What's wrong with it? Why…
Randy Sugianto 'Yuku'
  • 71,383
  • 57
  • 178
  • 228
0
votes
1 answer

Solr File Indexing map content by pages

I would like to index files in Solr. I have already made an "output script" with PHP, but my project leader has given me the task of displaying the page number of the found text. So: - I am searching for the Word "Foo". - Solr returns the results…
amahrt
  • 523
  • 1
  • 5
  • 13
0
votes
2 answers

How do you put multiple values into one variable or field without using a list and then parsing?

Sometimes there is a need to have multiple values in one variable or database field, even though that violates relational normalization principles. In python and other languages that support lists, that's easy. In others it is not. See insert…
user15972
  • 124
  • 4
0
votes
1 answer

Multivalued Dependencies Task

We have R(A,B,C) 1 2 3 1 3 2 1 2 2 3 2 1 3 2 3 Question : Which of the following multivalued dependencies does this instance of R not satisfy? BC ↠ A BC ↠ C C ↠ A ✔ A ↠ B Right answer is 4 but why i dont understand please explain
ChessBarbarian
  • 306
  • 1
  • 3
  • 9
0
votes
1 answer

birt dynamic range parameters

I'm a newbye in Birt and I'd like to develop a report that accepts a "multiple and dynamic range parameter". Here you are an example to explain better the problem:    Dataset:   table: Customer   columns: idCustomer, name I'd like that user will be…
GG GG
  • 11
  • 3
0
votes
1 answer

Solr MultiValued scoring boost with search based on array

First, I'm fairly new to solr and I'm far from sure that solr is the right solution to solve this problem. The documents that I'm working on is already there so, if solr can solve it, then it would be great :) One of our fields in a document is of…
Tobias
  • 1,062
  • 1
  • 9
  • 15
0
votes
1 answer

UI Example for selecting multi value

In my form there is text box that allow multi value input with a delimiter example "AU,RU,SG,US" user can add in multi value.. May I know if there is anywhere site that shows UI input example for such data? currently we are using a popup bean with…
seesee
  • 1,145
  • 5
  • 20
  • 46
0
votes
1 answer

can i add multiple value in field ? (please see an image)

I need to do the stock management website with 2 Content type Supplier and Product. First I add contents in Supplier content type. Then I add node reference field in Product content type and call it supplier and make it multiple value. it's looks…
user1656560
  • 1
  • 1
0
votes
1 answer

multivalued field in solr returns one item only

I am newbie in solr, i have a table like this id infield body --------------------------------------------- 1 ValX Article1-Body 1 ValY Article1-Body 1 ValZ Article1-Body 2 …
Alaa
  • 4,471
  • 11
  • 50
  • 67
0
votes
3 answers

Finding a Value In a Database Table Multivalued Column

I have the following table search_redirect sr_id | sr_keyword | sr_redirect | sr_synonyms ------------------------------------------------------ 1 | chair | www.url.com | recliner,seat,stool 2 | couch | www.url.com | sofa,divan 3 …
ckxcore
  • 25
  • 5
0
votes
1 answer

dependent multi values in setting bundle

I want to use two multi value in setting bundle. Second multi value's values depend on first multi value's chosen value. For example: first one is 'States' and second one is 'Cities'. Every states has different cities. Could i explain it?
Daedelus
  • 266
  • 5
  • 14
0
votes
1 answer

Are User Defined Functions supported in UniData

Currently investigating migrating from mvBase to Unidata and would like to know if User Defined Functions are supported as I cannot see this in the documentation I have downloaded? e.g I have DATABASIC program with something like A =…
Stuart Whitman
  • 13
  • 3
1 2 3
…
22
23