ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Raafat Sallam , Organizational Development and Training Consultant , Training Centers, Marketing Organizations.
تاريخ النشر: 2013/10/25
مستخدم محذوف‎
من قبل مستخدم محذوف‎

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

 

Mohammad Adnan Siddiqui
من قبل Mohammad Adnan Siddiqui , Senior Technology Consultant , Cogent Devs

Include LOOK UP tabels in the database level..

Ubaidullah Nubar
من قبل 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.

المزيد من الأسئلة المماثلة