50 likes | 143 Vues
A summary of an SQL-based application with two main parts - Database and Application Server. The application has minimal interaction with other infrastructure, featuring a main page, secondary pages, search function, and report. Key components include MSSQL database server, main and reference tables, and various lookup functionalities. While the design is simple and tailored to specific needs, it requires regular maintenance to prevent obsolescence.
E N D
Concept Summary Adam Murphy - SQLDOT
Two main parts – DB and App ServerNo interaction with other infrastructure • IIS Web App • App Server • 1 main page • 4 Secondary Pages • 1 Search Function • 1 Report • DB Server • MSSQL DB • Main tables • Secondary ref tables • 1 View
App Server Main Page IIS Application DBA Srv Mgt Ntw Business Report1
DB Server MS SQL DB Tables DBA Lookup Lookup Business Link Lookup Srv Mgt Lookup Lookup Lookup Ntw Lookup Lookup
Good points: Simple build Design Bespoke application Bad points: Has to be maintained Can get out of date quickly