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
6
votes
1 answer

Solr query to filter document with at least one value in array except of specified values

Is there a way to filter query, so I will get documents with specific array filed containing at least one other value except of values which I pass. For example I have 3 docs. 2 4 …
fider
  • 1,976
  • 26
  • 29
5
votes
2 answers

Can I search Solr documents by member of a multi-value field?

I have a set of Solr documents containing (among other fields) multi-value fields with percentage data or -1 if the value is null, e.g. ... 0.23 0.23 …
Cyranix
  • 337
  • 1
  • 4
  • 11
5
votes
1 answer

In Solr, can I sort on the matching value from a multi-valued field?

We are considering a schema with two multi-valued fields. Search is performed on the first field, but sorting should be done on the second field, using the corresponding value. E.g. if documents match because of the n-th value in the first field…
Michiel van Oosterhout
  • 22,839
  • 15
  • 90
  • 132
5
votes
3 answers

Alternative to multi-valued fields in MS Access

Related question: Multivalued Fields a Good Idea? I know that multi-valued fields are similar to many-to-many relationship. What is the best way to replace multi-valued fields in an MS Access application? I have an application that has multi-valued…
Jay
  • 1,210
  • 9
  • 28
  • 48
5
votes
5 answers

How to perform a search in a Multivalued Field in Solr?

I'm having dificulties to execute a search in Solr. My Solr has a Multivalued field like this document below: 2166324592435 ...others fields The Walking Dead<\str> Game of…
Thiago
  • 694
  • 3
  • 12
  • 26
4
votes
1 answer

Tensorflow: predicting a point from an image, training model with a point labels

I want to create a model which can predict a point from an image. I have a dataset with training images. Those images are splitted between 24 dirs. I have prepared an json file containing a (x, y) values for every image. example: "dir22": { …
Jakub Balicki
  • 180
  • 1
  • 11
4
votes
2 answers

How can I get schema information about a UniData/UniVerse database?

I have some (limited) experience with UniData and UniVerse databases and now wanting to work with them via the .NET framework. It appears that the way to work with them now is via Rocket Software's U2 Toolkit for .NET. Since I will be accessing…
ksigmund
  • 527
  • 1
  • 6
  • 13
4
votes
2 answers

Writing a Path Coverage Tool

Currently, one of our production systems is handled by over 3000 programs written between 1986 and now . The code base is written in a non-standard language, which unfortunately lacks modern testing tools. In a bid to improve our code quality moving…
Dan McGrath
  • 41,220
  • 11
  • 99
  • 130
3
votes
1 answer

SOLR multi valued fields

The Scenario: I have the following (simplified) database table scenario: ID ProductName ProductCategory Colour Price ---------------------------------------------------------- 1 BatmanTShirt T-Shirt Black 22 2 …
mrd3650
  • 1,371
  • 3
  • 16
  • 24
3
votes
2 answers

Importing Multivalue DB with SSIS into SQL

I would like to know if it is possible to Transfer Data into SQL Server from a multi value database file using SSIS. The only thing that I could find online was using a bluefinity tool to achieve this. Thanks Simona
user1094446
  • 31
  • 1
3
votes
1 answer

Storing multiple values in single property of Neo4j Lucene index

I want to store multiple values in a single index property of neo4j Lucene index, e.g. IndexName: profile property- Education: "Stanford University, Grad School", "Harvard University, MS" property- Work: "Nokia Siemens Networks", "Motorola"…
wakeup
  • 495
  • 4
  • 19
3
votes
1 answer

Is there any way to use a more modern language with Pick Basic? D3 to be exact

So been on the Pick system since the 70s. Everything we have is done in Pick. I would like to maintain the Pick records but use another language such as Java for front end user interfaces. The issue is D3 seems to be locked away in the linux…
Sparky2146
  • 31
  • 2
3
votes
1 answer

How to set multiple strings for Python Enum?

I want to define multiple strings for an enum variable and compare the variable either against a string or an enum type. I am currently doing the following: from enum import Enum class Ordinal(str, Enum): NORTH = ['north', 'NORTH', 'n'] …
David Zanger
  • 333
  • 1
  • 3
  • 8
3
votes
1 answer

SSRS - MultiValue Parameter "Select All" Problems

I am using SSRS 2008. I have a multivalue, text, not blank parameter named personID. This parameter's available values are set to a dataset (let's call this dataset PersonQuery), which is tied to a stored procedure. This parameter's default…
gloomy.penguin
  • 5,833
  • 6
  • 33
  • 59
1
2
3
…
22 23