Future database development

Future database development

Learning Outcomes:

• Discuss the needs and trends of future database development and the corresponding applications.
• Students should be able to discuss the impact of technologies, and dynamic web pages on database development.
• In considering the need for different database applications, factors such as volume of data, variety of data and variety of users should be discussed.

Relevant past paper:

DSE Elec A(SP-2016): 2012 4e. 2014 3d. 2016 2c.

Dynamic web pages and database

Contents of dynamic web pages change on interaction with user. For examples, user can login to their own account and make purchases in a web page, which will be saved in the DBMS. The web page content show what you have purchased based on the information from DBMS.

Different systems are necessary to provide dynamic web pages including a web server, a database system and application system to build the dynamic web page.

They are more costly and slower than usual static web pages. Yet, it allows interaction with users and provides up-to-date information to users.

Variety of data

Image data and other types of data can be stored in a database table or outside the database.

Store images in database tables:

• Advantages: data consistency maintained by DBMS, security provided by DBMS.
• Disadvantages: large volume of data to process - slower, inconvenient to view the images.

References:

https://www.business2community.com/web-design/5-important-points-database-driven-website-01567201

http://creatisoul.com/blog/what-are-basic-requirements-building-dynamic-website

https://www.geeksforgeeks.org/static-vs-dynamic-website/

https://www.datanamic.com/support/storeimagesinthedatabase.html

Data Privacy

Data Privacy

Learning Outcomes:

Discuss the importance of data privacy and develop proper attitudes to be an ethical user of database to respect data privacy.

Ways to achieve data privacy in database applications using access rights should be discussed.

Relevant past paper:

DSE ICT Elec A(SP-2016): SP 4ab. PP 4b. 2012 2eii. 2013 2c, 4di. 2015 4d. 2016 2e.

Data Protection Principles

1. Data collected should be necessary and adequate but not excessive.
2. Ensure the personal data is accurate and not kept longer than necessary.
3. Prohibit use of personal data for new purpose not related to original purpose.
4. Take all practical steps to protect the personal data.
5. Take all practical steps to ensure openness of personal data policies and practices.
6. Provide data subjects with the right to request access to and correction of their own personal data.

 Ways to achieve data privacy in database applications - Access control

• Use of login and password
• Access rights to database objects according to user groups
• Create views for different user groups - only provide the necessary information

References:

https://www.pcpd.org.hk/english/data_privacy_law/ordinance_at_a_Glance/ordinance.html

https://www.pcpd.org.hk/english/data_privacy_law/6_data_protection_principles/principles.html