ªÑé¹µèÒ§æ¢Í§«Í¿·ìáÇÃì
¤ÍÁà»ÕÂÃì à»ç¹ application ·Õè¶Ù¡ÊÃéÒ§¢Öé¹´éÇÂÀÒÉÒ Java 100%
àÇÍÃìªÑ蹻Ѩ¨ØºÑ¹Âѧ¤§ãªé Oracle áÅÐ
PostgreSQL
à»ç¹ DBMS áµè¡ç¡ÓÅѧ¾Ñ²¹ÒãËéãªéä´é¡Ñº Opensource DBMS µÑÇÍ×è¹æ àªè¹
Firebird, MySQL à»ç¹µé¹
«Ö觹èÒ¨ÐÍÍ¡ÁÒãªéä´éã¹ÃÒÇ¡ÅÒ§»Õ 2008 ¹Õé
¤ÍÁà»ÕÂÃìÁÕÅѡɳÐà»ç¹ Client-Server Êèǹ·Õèà»ç¹ Client ¡çà¢Õ¹´éÇ Java
·ÓãËéÊÒÁÒö·Ó§Ò¹ ä´éº¹¤ÍÁ¾ÔÇàµÍÃìËÅÒª¹Ô´ ·Ñé§ PC ·Õèãªé Windows áÅÐ
Linux, ·Ó§Ò¹ä´éº¹ Mac, SUN à»ç¹µé¹ µÑÇ Client Ê×èÍÊÒáѺ DBMS º¹ Server
´éÇ thin JDBC áÅеԴµè͡Ѻ Application Server â´Â¼èÒ¹ RMI áÅÐ Client
à¢éÒ¶Ö§ Server ´éÇ¡ÒÃÊ觼èÒ¹¢éÍÁÙŢͧÍÔ¹àµÍÃìà¹çµ
¹Í¡¨Ò¡¹ÕéÂѧÊÒÁÒöà¢éÒ¶Ö§ Server ¢Í§¤ÍÁà»ÕÂÃì´éÇ HTML ä´é
´Ñ§¹Ñ鹨֧ÊÒÁÒöãªé browser à¢éÒ¶Ö§¿Ñ§¡ìªÑè¹µèÒ§æ ¢Í§¤ÍÁà»ÕÂÃìä´é
Êèǹ·Ò§´éÒ¹ Apllication Server ¡çãªéà·¤â¹âÅÂÕè J2EE áÅÐãªé JBoss
à»ç¹â¤Ã§ÊÃéÒ§¾×é¹°Ò¹¢Í§ Server Êèǹ»ÃСͺ·Õè Server Áմѧ¹Õé
1. Compiere Server
«Ö觻ÃСͺ´éÇ Accounting Server, Request Server, Utility Server
2. Web Server áÅÐ Servlet
Container «Öè§ãªé Tomcat
3. EJB container «Öè§ãªé JBoss
ʶһѵ¡ÃÃÁẺ¹Õé·ÓãËéä´é¢éÍ´Õ¤×Í ÊÒÁÒöºÃÔËÒà Server ä´éâ´Âãªé web
interface áÅÐÊÒÁÒöà¾ÔèÁ¿Ñ§¡ìªÑè¹¢ÂÒÂà¾ÔèÁàµÔÁ áÅÐÊÒÁÒöà¾ÔèÁ application
J2EE Í×è¹æ à¢éÒä»ä´éÍÕ¡
Data Dictionary
Application ÊèǹãËè¶Ù¡¾Ñ²¹Ò¢Öé¹´éÇ¡Ãкǹ¡ÒÃÍ͡Ẻ, à¢Õ¹â»Ãá¡ÃÁ,
·´Êͺ¡Ñ¹·Ø¡æ ˹éÒ¨Í áµè¤ÍÁà»ÕÂÃì¶Ù¡ÊÃéÒ§¢Öé¹´éÇÂá¹Ç¤Ô´·Õè¡éÒÇ˹éÒ¡ÇèÒ
â´Âãªé active data dictionary ËÃ×ÍàÃÕ¡ѹã¹ÍÕ¡ª×èÍ˹Ö觤×Í
¤Åѧ¢éÍÁÙÅÊÒÃʹà·È (information repository)
µÑÇ data dictionary ¢Í§¤ÍÁà»ÕÂÃì¹ÕéÍÂÙè·ÕèªÑé¹ meta-data,
áÅÐÁѹÃÙéÇÔ¸Õà¢éÒ¶Ö§¢éÍÁÙÅ áÅÐÇÔ¸Õ·Õè¢éÍÁÙÅÊÑÁ¾Ñ¹¸ì¡Ñ¹ ã¹ data dictionary
¨ÐÁÕ¹ÔÂÒÁ¢Í§¢éÍÁÙÅ àªè¹ type, validation, à»ç¹µé¹,
ÁÕÇÔ¸Õ·Õè¢éÍÁÙÅàËÅèÒ¹Ñ鹨ж١áÊ´§¼Å àªè¹ áÊ´§à»ç¹ label
º¹Ë¹éÒ¨ÍáÅÐã¹ÃÒ§ҹ, áÊ´§¢éͤÇÒÁ help, áÊ´§ÊӴѺ¡ÒÃáÊ´§¼Å
áÅÐáÊ´§µÓá˹è§ÊÑÁ¾Ñ·¸ìàÁ×èÍà·Õº¡Ñº¿ÕÅ´ìÍ×è¹æ à»ç¹µé¹,
áÅÐÁÕ¡¯à¡³±ì¢Í§¡ÒÃáÊ´§¼Å
¡¯à¡³±ì¤ÇÒÁ»ÅÍ´ÀÑÂáÅСÒÃà¢éÒ¶Ö§¡ç¶Ù¡à¡çºáÅдÙáÅÃÑ¡ÉÒäÇé·Õè¹Õè
¡Ò÷Õèãªé¤ÓÇèÒ 'active' ¡è͹ data dictionary ¹Ñé¹, ËÁÒ¤ÇÒÁÇèÒ
Áѹ¨Ð¶Ù¡ãªéã¹¢³Ð runtime áÅÐÁռŵÒÁà¹×éÍËÒ·Õèà¡çºäÇé µÑÇÍÂèÒ§àªè¹
Áѹ"ÃÙé"ÇèÒ¡ÒâÒ·Õè˹éÒÃéÒ¹äÁèµéͧÁÕ payment term Áѹ¡ç¨ÐäÁèáÊ´§¼ÅÍÍ¡ÁÒ
áµèàÁ×èÍà»ÅÕ蹪¹Ô´¸ØáÃÃÁà»ç¹ ¡ÒÃÊÑè§ÊÔ¹¤éÒÁҵðҹ, «Ö觵éͧÁÕ payment
term Áѹ¡ç¨ÐáÊ´§¼ÅãËéàË繿ÕÅ´ì payment term ¹Ñé¹â´ÂÍѵâ¹ÁѵÔ
data dictionary ¹Õéà»ç¹áºº·Õè¼ÙéãªéÊÒÁÒöà¾ÔèÁàµÔÁà¢éÒä»ä´é
áÅмÙéãªé¡çÊÒÁÒöà¾ÔèÁ¡¯à¡³±ì áÅТéÍÁÙÅÊÒÃʹà·È·Õè¼Ùéãªé¡Ó˹´àͧà¢éÒä»ä´é
ÃкºÍÍ¡ÃÒ§ҹ
â´Â»¡µÔã¹ application
·ÑèÇæ仹Ñé¹ ÃкºÍÍ¡ÃÒ§ҹ¨Ðà»ç¹Êèǹ·Õè¶Ù¡á¡ÍÍ¡ÁÒ¨Ò¡Ãкº§Ò¹Í×è¹æ
áµèÃкºÍÍ¡ÃÒ§ҹ¢Í§¤ÍÁà»ÕÂÃì «Ö觷ӧҹÍÂÙ躹 data dictionary ¹Ñé¹
ÃÇÁà»ç¹Ãкºà´ÕÂǡѹ¡ÑºÃкº§Ò¹Í×è¹æ ·Ø¡ÃÒ§ҹ·Õè¶Ù¡ÃÒ§ҹÍÍ¡ÁÒ
ÊÒÁÒö´Ùä´éº¹¨Í¡è͹·Õè¨ÐÊè§ä»ÍÍ¡à¤Ã×èͧ¾ÔÁ¾ì
ËÃ×ÍÊÃéÒ§ÍÍ¡ÁÒà»ç¹ä¿ÅìÃٻẺµèÒ§æ àªè¹ Excel, HTML, XML, Word áÅÐ PDF
ã¹ÃÒ§ҹ·Ø¡ÃÒ§ҹ ¼ÙéãªéÊÒÁÒöà¨ÒÐÅ֡ŧ件֧¢éÍÁÙÅ·Ø¡¢éÍÁÙÅ
·ÕèÃÒ§ҹ¹Ñé¹ãªéÍéÒ§ÍÔ§
¡¯à¡³±ì¤ÇÒÁ»ÅÍ´ÀÑ·Ñé§ËÁ´¨Ð¶Ù¡µÃǨÊͺâ´ÂÍѵâ¹ÁѵÔ
Íѹ¹ÕéÃÇÁ件֧¡ÒÃà¢éÒ¶Ö§µÒÃÒ§¢éÍÁÙÅ, ¤ÍÅÑÁ¹ìã¹µÒÃÒ§ áÅÐáÁéáµèÃÐàºÕ¹¢éÍÁÙÅ
àªè¹ äÁèãªèºÑªÕ 1234 ËÃ×Í੾Òо¹Ñ¡§Ò¹¢Òª×èÍÊÁªÒÂ
¼ÙéãªéÊÒÁÒö¨Ð»éͧ¡Ñ¹äÁèãËé¼ÙéãªéÍ×è¹ÍÍ¡ÃÒ§ҹà¡ÕèÂǡѺ¢éÍÁÙźҧ¢éÍÁÙÅ
ËÃ×Í»éͧ¡Ñ¹äÁèãËé¾ÔÁ¾ìËÃ×ÍÊè§ÍÍ¡¢éÍÁÙÅà»ç¹ä¿Åìä´é
¤ÍÁà»ÕÂÃìÁÕà¤Ã×èͧÁ×ÍÍÍ¡ÃÒ§ҹÍÂÙè 4 ÍÂèÒ§¤×Í
1. ÃÒ§ҹáÊ´§ÃÒ¡ÒâéÍÁÙÅ
2. ¿ÍÃìÁµèÒ§æ
3. ÃÒ§ҹ·Ò§¡ÒÃà§Ô¹
4. àÍ¡ÊÒÃÊÃØ»ÂÍ´ºÑªÕ
ÃÒ§ҹáÊ´§ÃÒ¡ÒâéÍÁÙŹÑ鹨ÐÁÕÍÂÙè·Ø¡Ë¹éÒµèÒ§áÅÐàÁ¹Ù
áÅÐÁÕ¾ÒÃÒÁÔàµÍÃì·Õè¡Ó˹´ ¶Ù¡àÅ×Í¡äÇéãËéáÅéÇ
«Ö觼Ùéãªé¡çÂѧÊÒÁÒöá¡é䢾ÒÃÒÁÔàµÍÃìàËÅèÒ¹Ñé¹ä´é´éÇÂ
¿ÍÃìÁµèÒ§æ àªè¹ãºá¨é§Ë¹Õé
à»ç¹µé¹ ªèÇÂãËé¼Ùéãªé¡Ó˹´ÃٻẺ¡ÒþÔÁ¾ì¢éÍÁÙÅä´é
¤ÍÁà»ÕÂÃìÊÒÁÒöãªé¿ÍÃìÁËÅÒÂÃٻẺä´é àªè¹
ã¹Ë¹èǧҹ˹Öè§ÍÒ¨ãªéãºá¨é§Ë¹Õéä´éËÅÒÂÃٻẺ ÊÓËÃѺÅÙ¡¤éÒ੾ÒÐÃÒ à»ç¹µé¹
ÊÓËÃѺÃÒ§ҹ·Ò§¡ÒÃà§Ô¹¹Ñé¹,
¼Ùéãªé¨Ð¡Ó˹´ªØ´ºÃ÷ѴáÅФÍÅÑÁ¹ì
áÅéÇÃÇÁ·Ñé§ËÁ´¹Ñé¹à¢éÒà»ç¹ÃÒ§ҹ·Ò§¡ÒÃà§Ô¹ãËÁèä´é
¾ÃéÍÁ·Ñé§ãËéàÅ×Í¡¾ÒÃÒÁÔàµÍÃìä´éÍÕ¡ËÅÒ¡ËÅÒÂ
àÍ¡ÊÒÃÊÃØ»ÂÍ´ºÑªÕ
ãËé¼ÙéãªéÊÒÁÒöáÊ´§ÃÒ¡ÒøØáÃÃÁ ¢Í§ºÑªÕËÃ×Íà¾Õ§Êèǹ˹Ö觢ͧºÑªÕ ³
Çѹ·Õè¡Ó˹´ ËÃ×ͪèǧÃÐÂÐàÇÅÒ·Õè¡Ó˹´ä´é ¾ÃéÍÁ·Ñé§Âʹ¡ÁÒáÅÐÂÍ´¤§àËÅ×Í ³
ÇѹÊÔé¹ÊØ´
¡ÒûÃѺáµè§ÃÒ§ҹ
¤ÍÁà»ÕÂÃìá¡ÁØÁÁͧ (view) ¨Ò¡
âÁà´Å (model) ¢éÍÁÙŨҡâÁà´Å㹤ÍÁà»ÕÂÃì¹Ñé¹ ¼ÙéãªéÊÒÁÒöàÅ×Í¡ÇÔ¸Õ
áÊ´§¼Å/·Ó¢éÍÊÃØ»/àÃÕ§ÅӴѺ àͧä´é ã¹Í§¤ì¡Ã¸ØáԨ¹Ñé¹
ÁÑ¡¨ÐÁÕ¤ÇÒÁàËç¹µèÒ§¡Ñ¹ÍÂÙèàÊÁÍ ã¹àÃ×èͧÇèÒ
ÃÒ§ҹáµèÅÐÃÒ§ҹ¤ÇèÐÍÍ¡ÁÒã¹ÅѡɳÐã´ ¤ÍÁà»ÕÂÃì͹ØÒµãËé¼Ùéãªé
ÊÒÁÒöãËé¹ÔÂÒÁÃٻẺÃÒ§ҹµèÍ仹Õéä´é
1. ¤ÍÅÑÁ¹ìã¹ÃÒ§ҹ
2. ÅӴѺ¤ÍÅÑÁ¹ì
3. ¡ÒÃàÃÕ§ÃÒ§ҹ
4. ËÑÇàÃ×èͧ¢Í§¤ÍÅÑÁ¹ì
5. ¼ÅÃÇÁ, ¤èÒ¹éÍ·ÕèÊØ´,
¤èÒÁÒ¡·ÕèÊØ´, ¤èÒà©ÅÕè à»ç¹µé¹ ÃÇÁ·Ñ駨ӹǹ˹éÒÃÇÁ
6. ¡ÒÃÃÇÁ¡ÅØèÁ
7. Pie Chart
8. Bar/Line Chart
ÀÒÉҢͧÃÒ§ҹ¨Ðà»ç¹ä»µÒÁÀÒÉҢͧ¼Ùéãªé áµèÅмÙéãªéÊÒÁÒöÁÕÀÒÉÒµèÒ§¡Ñ¹ä´é
¡ÒÃàÅ×Í¡¢éÍÁÙŨзӼèÒ¹¾ÒÃÒÁÔàµÍÃì¢Í§ÃÒ§ҹàÁ×èÍàÃÔèÁµé¹ÃÒ§ҹ
ËÃ×ͼèÒ¹¡ÒÃÊͺ¶ÒÁ, ªèÇÂãËé¼ÙéãªéãÊèà§×è͹ä¢ÃÒ§ҹä´éã¹ÃٻẺ
"Êͺ¶ÒÁâ´ÂµÑÇÍÂèÒ§"
|
ʶһѵ¡ÃÃÁ¢Í§¤ÍÁà»ÕÂÃì
|
|
|
|
|