Skip to content. | Skip to navigation

Sections
Personal tools
You are here: Home Ignite What is MultiValue?

What is MultiValue?

MultiValue (MV) databases allow the use of attributes having a list of values. SQL databases require all attributes have a single value. This makes MV databases more flexible as data changes such as adding attributes do not require rebuilding the database. MV databases often do not require DBA support for this reason. - Wikipedia Feb 2010

MultiValue data model vs Relational

MultiValue data is stored in a single table which is efficient, compact and faster and more intuitive.

Multi-value table

Relational data requires several tables which consumes more memory, requires more disk I/O and is more difficult and time consuming to administer.

Relational table

 

 

 

 


Document Actions
Who Uses U2?

Solutions based on U2 operate around the world, 24 hours a day, 7 days a week, including:

  • 40% of US institutions of higher education
  • 70% of North America's largest independent insurance agencies
  • 80% of all automotive dealerships in North America
  • 50% of the top 400 energy companies

Petco

France Telecom

Best Buy