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

is it necessary to have multi valued attributes in an entity to be present when there is a relationship for that

is it necessary to have multi valued attributes in an entity to be present when there is a relationship for that multi valued attribute whith 1:m cardinality. for a example there is a table called tester and there is a multivalued att called…
Gayan Prasanna
  • 95
  • 1
  • 9
0
votes
0 answers

SSRS The restrictions imposed by the CONSTRAINED flag in the STRTOSET function were violated

I got a problem using Multi-Value Parameters in SSRS. I got a DataSet with this MDX Query : SELECT NON EMPTY { [Measures].[Air Temperature Out - Fact Germination Continue] } ON COLUMNS, NON EMPTY { ([81 Germination Continue].[Batch …
AKMMM
  • 294
  • 1
  • 2
  • 19
0
votes
1 answer

how insert multi value from chechbox to database in codeigniter

I try to insert value from selected checkbox to database with codeigniter, but when i submit the form nothing happen with it this is my view code
ana luthfa
  • 11
  • 4
0
votes
1 answer

How to prevent Multi-Value field showing duplicates in Access 365 2016

Im using Microsoft Access 365 2016. I have created a multi-value field in a table so that i can choose multiple values from a list of check box options (similar to the drop down menu in a field table). When I click the drop down arrow It shows all…
frustrationmultiplied
  • 439
  • 8
  • 18
0
votes
0 answers

Selecting one value from a multi-value field

New to programming. Using R currently. Pulled in a employee data flat text file that has multi-value fields. The value options for the EmployeeClass variable can be: A, B, C, D, E. More than one can be selected, there can be blank values, one can be…
CurlyW
  • 61
  • 1
  • 5
0
votes
0 answers

Solve multi-variable equations by R

Here are the…
Charles Yan
  • 83
  • 1
  • 1
  • 9
0
votes
0 answers

SSRS multivalue parameter default selection

I have a SSRS report and it have one multi valued parameter. I need to assign some default values into that param during report rendering time. The multi valued paramater having hundreds of data. I write a procedure for getting default values and…
Sreepathi
  • 93
  • 13
0
votes
3 answers

Search only for single value of Solr multivalue field, not across the values

I have a multivalued field in my schema called citation. One of the documents in the database has values for this field like: "citation":["13-33", "12-44"], I want to be able to do a query like: citation:(13 44) and not have this…
mlissner
  • 17,359
  • 18
  • 106
  • 169
0
votes
1 answer

Is a multi-valued stored procedure parameter just bad practice?

I have the strange aversion to passing in multiple ID parameters to a single stored procedure. For example, this feels just wrong: GetMyObject(ListofIDs, OtherParam1, OtherParam2, ...) I understand HOW to do it (correctly if I must).. but I don't…
deLux_247
  • 161
  • 1
  • 5
0
votes
1 answer

IOS/Addressbook framework: 2nd street address field in contact

In the Apple contacts app, when you go to edit a contact, there are two fields labeled Street. I am able to pull in the information from the first field with the following code: ABMultiValueRef st = ABRecordCopyValue(addressBookRecord,…
user1904273
  • 4,562
  • 11
  • 45
  • 96
0
votes
2 answers

Searching on flat multivalue fields

let say I have got a multivalued field named myfield and some documents containing some values in myfield. Now I start a query like this: myfield:foobar The result will be something like this: foobar_1 …
Obenland
  • 856
  • 16
  • 28
0
votes
3 answers

Create a Multi-value date field using datepicker

I'm trying to create a MV date field using the date picker, The closest I have been able to get is to use the date picker to store a date in a viewScope then have a button to Add the date to the existing MV Date field. It works (sort of) but seems…
Bill F
  • 2,057
  • 3
  • 18
  • 39
0
votes
1 answer

Converting a multivalued attribute serialnumber

I am looking to pull LastLogonDate, SerialNumber, Name and Description from AD. I have everything working except when I open the csv instead of the serialnumber is gives me: Microsoft.AdctiveDirectory.Management.ADPropertyValueCollection. From what…
Mason Evans
  • 121
  • 3
  • 4
  • 12
0
votes
4 answers

SQL Split Multiple Multivalue Columns into Rows

I have data that was sent to me, and I need to normalize it. The data is in a sql table, but each row has multiple multi value columns. An example is the following: ID fname lname projects projdates 1 John Doe …
missscripty
  • 529
  • 2
  • 11
  • 30
0
votes
1 answer

remove attribute in json that contain multivalue in asp.net c# before show it in gridview

I'm newbie in asp.net c# . Iwant to show the json data into table with gridview .I have json data with this format : [{ "reviewerID": "A1YS9MDZP93857", "asin": "0006428320", "reviewerName": "John Taylor", "helpful": [ 0, …
Ana
  • 113
  • 13
1 2 3
…
22 23