Web Database: Implementation, Development, and Security Issues

Verified

Added on 2024/07/01

AI Summary

This document explores the concept of web databases, their implementation, and the recent advancements in database technology. It delves into the process of developing a web database, highlighting the essential steps and software tools involved. Furthermore, it examines the security challenges associated with web databases, including access control, authentication, and potential threats like spoofing. The document concludes by emphasizing the importance of robust security measures to protect sensitive data and ensure the integrity of web database systems.

Contribute Materials

Your contribution can guide someone’s learning journey. Share your documents today.

Assessment 4
Web database is used to store and manages data on internet. It is used to store and manage the
transactional database. Oracle and SQL server are the examples of database.
Implementation of web database
1. Create programs: File menu>New>Internet application>OK
In internet application, web applications introduction discussed.
Choose Full application then click on the SQL Database which is present in dialog box.
Click NEXT and if user wants to create project then choose YES option
Select Empty project and write the name of the project then click on the create option.
If user wants to create directory then click on YES
2. Build application: On the project menu, click on the Rebuild all the click on OK button
3. Run application
4. Database navigation
5. Database updating
6. Database filtration
Bruce who is a football volunteer is coach. He faces problem while informing players for training
sessions. He wants to implement a web database system for the players to record the
operational data. Training sessions contains training session ID, date, time and venue of the
training session and each players contain players name,ID,date of birth and playing position.
There are many players in the football team:
Player (Player_ID,Player_DOB,FirstName_LastName)
Team (Team_ID,Sport_ID,TeamName)
Sport (Sport_ID, SportName)
Training session
Training session (Training session_ID,Training session_date,training session_time,training
session_venue)
How to develop web database
Database which is used to manage operations on internet is named as web database. MySQL is a
relational database which is used to control or manages multiple databases. The process of
developing web database is planning, creating project, creating web interface which includes
welcome page and response page , establishing connection between database and application,
running application. There are various software require to develop the web database such as
NetBean IDE, Java Development Kit, MySQL database server, MySQL connector.(Giunipero. T, 2018)

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.

💎 Get Pro

Recent development in Database technology
Recent developed database technology supports applications which are distributed and allow users to
work in the heterogeneous environment. Data management in high level SQL language, query
optimization theory and management techniques in transaction. The performance of commercial DBMS
enhances systems by indexing, physical storage techniques and buffer management development. In
distributed environment, operations are supported by database server technology. Features of database
added in the database server systems such as store procedures in database, database triggers which
enhance the performance of the applications. Recent development in database allows server system to
operate in open systems environments and supports gateways and APIs. In recent development database,
simple records can be updated by individuals.Recent development in database technology enhances the
reliability and reusability of the database by supporting inheritance. It also enhanced the performance and
security of database server.OLAP databases are used for statistical data analysis for business purposes.
Recent development in database allows users to operate NoSQL database .It allow database to work with
less intervention of human. Database with cloud provide cloud services also which helps to meet the goal.
Many issues are overcame by new database technologies such as data leaks, misused of software and
hardware configurations and privileges of networks.(Gates,2018)
Security issues in Database
A database security issue includes access control policy, audit policy, authorization of user, identification
of user, consistency policy. Three components are included in multiple access control i.e. relational
database, file system, object oriented databases. Mandatory access control provides security which is in-
built and user cannot change it. Normally database security focuses on access control in which data access
can be denied. Manager of database security maintained the confidential data in an organization.
[Spamlaws,2018,para.1)
Security issues in database
1. Maintenance: In this,an account of user needs to update on daily basis and users will face less
problems if they follow these tasks daily.[Spamlaws,2018,para.3]
2. Manages password of user: Sometimes user forget to remove the IDs which create a security
issue so that it should be managed in such a way that unauthorized user cannot misuse it.
[Spamlaws,2018,para.8]

3. Spoofing: Attackers are able to create duplicate applications which are similar to original
application. It can generate problems related to policies which are created for the applications.
[Spamlaws,2018,para.7]
4. Multiple security methods: There are many security methods and each security method need
different policies which are difficult to access applications then confidential data is at risk.
[Spamlaws,2018,para.4]
Referencing
1. Spamlaws. (2018). Database Security Issues: Database Security Problems and How to Avoid
Them. Retrieved from https://www.spamlaws.com/database-security-issues.html
2. Ferrari.E. & Thuraisingham, B. (2004, March). Security and privacy for web databases and
services. In International Conference on Extending Database Technology (pp. 17-28). Springer,
Berlin, Heidelberg.
3. Bertino. E. & Sandhu, R. (2005). Database security - concepts, approaches, and
challenges. IEEE Transactions On Dependable And Secure Computing, 2(1), 2-19. doi:
10.1109/tdsc.2005.9
4. Giunipero. T. (2018). Creating a Simple Web Application Using a MySQL Database -
NetBeans IDE Tutorial. Retrieved from https://netbeans.org/kb/docs/web/mysql-webapp.html
5. Gates, P. (2018). 4 Top Trends in Database Management - Datavail. Retrieved from
https://www.datavail.com/blog/4-top-trends-db-management/
6. Harrison.G. (2016). The Database Technologies of the Future. Retrieved from
http://www.dbta.com/BigDataQuarterly/Articles/The-Database-Technologies-of-the-Future-
109659.aspx
7. Watt.A. (2018). Chapter 13 Database Development Process – Database Design – 2nd Edition.
Retrieved from https://opentextbc.ca/dbdesign01/chapter/chapter-13-database-development-
process/
8. Maurer. R. (2015). Top Database Security Threats and How to Mitigate Them. Retrieved from
https://www.shrm.org/resourcesandtools/hr-topics/risk-management/pages/top-database-security-
threats.aspx
9. North. M. (2018). What Is a Web Database? | Techwalla.com. Retrieved from
https://www.techwalla.com/articles/what-is-a-web-database
10. Rongalla. A. (2018). 8 Essential Phases in Web Application Development Process - Invensis
Technologies. Retrieved from https://www.invensis.net/blog/it/8-essential-phases-in-web-
application-development-process/

1 out of 4

+13062052269

info@desklib.com

Web Database: Implementation, Development, and Security Issues

Contribute Materials

Secure Best Marks with AI Grader

Related Documents

Research Report on Entity Relationship Diagram Assignment PDF

Implementing Database Management System in Cloud Instance

Implementing a Secure Web Database in a Cloud Instance

Network Vulnerability And Penetration Testing Assignment

Introduction to Web Databases in Cloud Instances: A Case Study with Oracle Database Cloud Service

Database Management System Concepts