CHAPTER 5: DATABASE PROCESSING

A Database is a collection of incorporated records. An example of a great database would be Wal-Mart which could be considered the world's largest database with more than half a petabyte. Theirretail link allows suppliers to access large amounts of online, real-time, item-level data to help those suppliers improve operations. Unlike a typical database that can get slower as it expands and requires more time to complete backups and virus scans , their database is designed to scale without the management restrictions of other databases. Every purchase made by a customer is sent to their data warehouse and shows what people are buying, what is popular, how much of a certain product is needed at a specific Walmart, their database helps them run their company efficiently and enables suppliers to send needed products when their out of stock. A database management is a program that is used to create, process, and administer a database. Walmarts vendor isNCRs Teradata division and supports those many bytes of data and says that their systems can scale without hiccups even at an extreme number so their database is pretty accurate. Other DBMs are DB2 from IBM, Oracle, etc. Processing the database requires 4 operations which is to read, insert, modify, or delete data. In the operation phase in administering the Database, DBMS can be used to create a security system which involve user accounts, passwords, permissions, and limits for processing the database. Most Companies will not allow any outsiders to access their database, my sjsu has a username and password that when accessed shows all payments, reminders, schedules, etc. You can track problems and find resolutions to the problem and monitor the data performance. The backup and recovery can be very crucial for professors because if they for some reason lose all their notes, powerpoints, grades, etc it can be detrimental if their is not a database that has a backup. One of my professors recently lost all her data because of a trojan spam and went to an IT professional in order to manage her backups and recover her lost files. She went to individuals who understand and know how to operate backup procedure and was able to recover all of her files. Adaption is where you can set up a tracking system and manage configuration change. All changes can be recorded and manage your changes of the database. A database application is a collection of forms, reports, queries, and applications needed to process a database. Different database applications include membership application, class application, and personal training applications. I believe that knowing how to create a database is a very essential and beneficial tool to know because it can keep all business transactions in order, to date and have a company running more smoothly.