What is better: 1- include LOOK UP tables in the application level. or 2- include LOOK UP tables in the database level?

Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Next Question:
What is the best combination of applications and programming languages to create...
Posted by:
Ghassan Barghouti
29-May-2013

Programming Database Administration IT Management

Question ajoutée par Raafat Sallam , Organizational Development and Training Consultant , Training Centers, Marketing Organizations.
Date de publication: 2013/10/25

Apprécier (2) Vues (6) Suiveurs (1) Réponses (3) Report Question

Ajoutez Une Réponse
Inscrivez-vous ou connectez-vous pour répondre.

3 Réponses

par Utilisateur supprimé

first, we must do a distinction between foreign key and lookup table!!

second, i do not seen the usefulness of lookup table in database?!

but in programming its verry useful, for Lookup combobox, lookupfield.....

so its better to use lookup table in application Level

Apprécier (1)

Déprécier Réponses () Rapport

par Mohammad Adnan Siddiqui , Senior Technology Consultant , Cogent Devs

Include LOOK UP tabels in the database level..

Apprécier (1)

Déprécier Réponses () Rapport

par Ubaidullah Nubar , Information Systems Consultant , Al-Ebdaa for Development

Lookup tables at the database level is better because this will allow you to add more values without having to change the application. Lookup at app level means the lookup values will be hardcoded. This is ok only in cases where the values are limited and are not expected to change during the lifetime of the app.

Apprécier (0)

Déprécier Réponses () Rapport