Question

From the book "Database Systems" 11th ed

1. Navigate to the Web Database Issues threaded discussion, and discuss the following issues:
   1. Web-to-database interfaces in terms of data types
   2. Security
   3. Database transaction management
   4. De-normalization of database tables.

Answer 1

a)WEB_TO_DATABASE INTERFACES IN TERMS OF DATATYPES:

1)The method in which the Web-to-Database stores and extracts complex data objects such as documents, graphics, and streaming video through a Web serve

b)SECURITY:

1)No security testing before deployment

2)Poor encryption

3)Broken database

4)Stolen database backups

c)DATABASE TRANSACTION MANAGEMENT:

1)Hardware failure

2}System crashes

3)Deadlock

4)Concurrent esecution of same transaction

d)De-normalization of database tables:

1)If tables are large, we may spend an unnecessarily long time doing joins on tables.

2)Data inconsistencies are possible due to data duplication