Multivalued Fields a Good Idea?

by

See:

Multivalued datatypes considered harmful: How dangerous can a data type be?

I had a long talk with Suraj
Poozhiyil, the Access Program
Manager… both Suraj and I agree
wholeheartedly that developers do not
need to use multi-valued fields.
People who understand databases
already have a good way of
implementing many to many
relationships and will gain no benefit
from multi-valued fields.

So, my clear and certain advice to
developers is not to use multi-valued
fields. They have nothing to offer us
except potential pain.

More Related Contents:

  1. Best way to test a MS Access application?
  2. Good Free Alternative To MS Access [closed]
  3. What’s the difference between identifying and non-identifying relationships?
  4. To Do or Not to Do: Store Images in a Database [duplicate]
  5. Can I have multiple primary keys in a single table?
  6. What is an ORM, how does it work, and how should I use one? [closed]
  7. What is the difference between an entity relationship model and a relational model?
  8. Best practices for storing postal addresses in a database (RDBMS)?
  9. Does MS Access support “CASE WHEN” clause if connect with ODBC?
  10. What are the advantages of using a single database for EACH client?
  11. Is it possible to generate django models from the database?
  12. Run a single Maven plugin execution?
  13. How to create an auto delete mechanism for firestore? (deleting data after time period) [closed]
  14. Do stored procedures run in database transaction in Postgres?
  15. What is a View in Oracle?
  16. MS Access: how to compact current database in VBA
  17. Normal forms – 2nd vs 3rd – is the difference just composite keys? non trivial dependency?
  18. Is there any NoSQL data store that is ACID compliant?
  19. How to think in data stores instead of databases?
  20. Is it better to use multiple databases with one schema each, or one database with multiple schemas? [closed]
  21. Is it a good idea to use an integer column for storing US ZIP codes in a database?
  22. Connect to a heroku database with pgadmin
  23. Starting and populating a Postgres container in Docker
  24. Adding a new value to an existing ENUM Type
  25. What’s the better database design: more tables or more columns?
  26. Should OLAP databases be denormalized for read performance? [closed]
  27. Android Room Persistence library and Kotlin
  28. How can I import a .sql file into my Heroku postgres database?
  29. Predict next auto-inserted row id (SQLite)
  30. Best beginner resources for understanding the EAV database model? [closed]

Leave a Comment