| Thus changes in the format and structure of data and records within a file require making the same change for all the programs that use that file Lack of data integrity: in file processing system, end user can define some data elements such as customer address | Fiber-optic transmission, which uses pulses of laser- generated light, offers significant advantage Reduce size Reduce installation effort Vastly greater communication capacity Much faster transmission speeds Freedom from electrical interface Satellite transmission Ability to transmit massive amount of data, audio, and video over global networks, especially to isolated areas Internet2 13 Next generation of the Internet High-performance network that uses an entirely different infrastructure than the public Internet we know today |
|---|---|
| 23 Database Maintenance Database of an organization need to be updated to reflect new business transactions such as a new sale Done by transaction processing systems with support of DBMS 24 Application Development DBMS packages play a major role in application development Use DBMS software development tools to develop custom application programs Example: you can use a DBMS to develop the data entry screen, forms, reports or Web pages of a business application that access to a company database to find and update specific data Application software developers do not need to develop data using conventional programming | It was never intended to replace Internet |
Rather, its purpose is to build a road map that can be followed during the next innovation for the current Internet.
10| Such as new addressing protocols and satellite-quality streaming video, will likely be deployed to the Internet, but it might take about 10 years | This caused problems when data is needed to be updated since it required developing each file separately |
|---|---|
| , DB2 to access another database e | It was never intended to replace Internet |
The functions are in the DW to meet the users' reporting needs.
19| Such as new addressing protocols and satellite-quality streaming video, will likely be deployed to the Internet, but it might take about 10 years | |
|---|---|
| 6 Distributed Databases 7 Challenge: any data change in one location must be made in all other locations |
WHERE After SELECT you list the data fields you need After FROM you list the fields or tables from which the data must be retrieved After WHERE you specify conditions that limit the search Example: natural language: what students have the full mark? Data mart DM is the access layer of the data warehouse DW environment that is used to get data out to the users.
6