Questions On Database Design

Submitted By Kristin-Sullivan
Words: 561
Pages: 3

Week 1 Individual: Database Design
Kristin M. Sullivan
May 19, 2014
Sandra Graca

Database systems are designed to allow developers to create a database, fill it with information and be able to call up that information and change it as necessary. This also allows the user not to worry about data storage and retrieval. Some of the other aspects to database systems are:
“User access and security management systems provide appropriate data access to multiple users while protecting sensitive data.
Data backup to ensure consistent availability of data.
Access logs, making it easier for a database manager to see how the database is being used.
Rules enforcement to ensure only data of the prescribed type is stored in each field, for example, date fields may be set to only contain dates within a set range.
Formulas such as counting, averaging and summing included in the DBMS make statistical analysis and representation of the data simpler.
Performance monitoring and optimization tools may also be included to allow the user to tweak the database settings for speed and efficiency.” (Seymour, 1998-2014). Something to keep in mind is that almost any website that requires a log on and password to be accessed has a database that stores your information. And most computers can use a database to store your passwords that you use for certain pages. However, I would not recommend using this on a public computer and only on a private computer where you are either the only one who uses it or have set up security safeguards for other people using your private PC. Oracle has come a long way as have a lot of other database programs. The newest thing seems to be what is called a database cloud. According to "Oracle Database-Introducing Oracle Database 12c: Plug Into The Cloud" (n.d.), “Oracle Database 12c introduces a new multitenant architecture that makes it easy to deploy and manage database clouds. Innovations such as Oracle Multitenant, for consolidating multiple databases quickly, and Automatic Data Optimization with Heat Map, for compressing and tiering data at a higher density, maximize resource efficiency and flexibility. These unique advancements, combined