50 likes | 138 Views
Concept Summary. Adam Murphy - SQLDOT. Two main parts – DB and App Server No 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.
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