adbms
Patricia Mae C. Melchor
BSIT -3D
Chapter 5
Application Design
Application design is more than just writing efficient database requests in application programs: Every aspect of the way the program is coded affects the usability and effectiveness of the application. Of course, application design includes database concerns such as interfacing SQL with traditional programming languages and the type of SQL to use. However, each application program must be designed to ensure the integrity of the data it modifies. Additionally, performance has to be treated as a design issue.
Application design and development is the job of systems analysts and application programmers. However, the DBA must be involved in the process when programs are being written to access databases. Special skills are required that can be difficult to master. The DBA must first understand these skills and then work to transfer the knowledge to developers. This is a continual job because new programmers are constantly being hired—each with a different level of skill and degree of database experience. Furthermore, DBMS products are constantly changing, resulting in additional development options and features that need to be mastered.
5.1 Database Application Development and SQL
Designing a proper database application system is a complex and time consuming task. The choices made during application design will impact the usefulness of the final, delivered application. Indeed, an improperly designed and coded application may need to be redesigned and recoded from scratch if it is in efficient, ineffective, or not easy to use.
To properly design an application that relies on databases for persistent data storage, the system designer at a minimum will need to understand the following issues:
• How data is stored in a relational database
• How to code SQL statements to access and modify data in the database
• How SQL differs from traditional programming languages
• How to
BSIT -3D
Chapter 5
Application Design
Application design is more than just writing efficient database requests in application programs: Every aspect of the way the program is coded affects the usability and effectiveness of the application. Of course, application design includes database concerns such as interfacing SQL with traditional programming languages and the type of SQL to use. However, each application program must be designed to ensure the integrity of the data it modifies. Additionally, performance has to be treated as a design issue.
Application design and development is the job of systems analysts and application programmers. However, the DBA must be involved in the process when programs are being written to access databases. Special skills are required that can be difficult to master. The DBA must first understand these skills and then work to transfer the knowledge to developers. This is a continual job because new programmers are constantly being hired—each with a different level of skill and degree of database experience. Furthermore, DBMS products are constantly changing, resulting in additional development options and features that need to be mastered.
5.1 Database Application Development and SQL
Designing a proper database application system is a complex and time consuming task. The choices made during application design will impact the usefulness of the final, delivered application. Indeed, an improperly designed and coded application may need to be redesigned and recoded from scratch if it is in efficient, ineffective, or not easy to use.
To properly design an application that relies on databases for persistent data storage, the system designer at a minimum will need to understand the following issues:
• How data is stored in a relational database
• How to code SQL statements to access and modify data in the database
• How SQL differs from traditional programming languages
• How to