Analyzing the use of databases in the workplace
Analyzing the use of databases in the workplace
University of Phoenix
CIS/319
May 1, 2007�
Analyzing the use of databases in the workplace
A database stores keyed information in an organized and accessible manner. The size and capacity of databases can vary widely, from a small database used by an individual to file phone numbers, to an extremely large enterprise database that stores several gigabytes of information accessed by thousands of individuals. Databases are essential for almost every company in today's business world. Database can help us keep track of, inventory, billing, pay role, phone numbers and much more. Lacking the use of databases, work will take longer to accomplish. Another wonderful feature about having a database in place is that a record of all transitions can be kept for analyzing purposes.
In this paper I am going to discuss about the database and software used in my construction company. Oracle database is a multi platform database, meaning it can run efficiently on any operating system and this makes Oracle flexible and more secure when compared to its competitors. Our Oracle database is running on a Sun server, using the Sun Solaris enterprise operating system. Oracle databases are an enterprise database system, only medium and large companies would need an enterprise database. Oracle Corporation uses RDBMS rational database management systems to maintain all data within the organization. Various data items can be organized according to their relationships with each other, such as the relationship of Employee name and Employee ID, rational databases give Oracle a great deal of flexibility when describing the relationship between data elements. Oracle follows Dr.Cobbs 12 rules on how a true RDBMS should be evaluated. The following are Cobb's 12 rules.
1. Information is represented logically in tables.
2. Data must be logically accessible by table, primary key, and column.
3. Null values must be uniformly treated as "missing
University of Phoenix
CIS/319
May 1, 2007�
Analyzing the use of databases in the workplace
A database stores keyed information in an organized and accessible manner. The size and capacity of databases can vary widely, from a small database used by an individual to file phone numbers, to an extremely large enterprise database that stores several gigabytes of information accessed by thousands of individuals. Databases are essential for almost every company in today's business world. Database can help us keep track of, inventory, billing, pay role, phone numbers and much more. Lacking the use of databases, work will take longer to accomplish. Another wonderful feature about having a database in place is that a record of all transitions can be kept for analyzing purposes.
In this paper I am going to discuss about the database and software used in my construction company. Oracle database is a multi platform database, meaning it can run efficiently on any operating system and this makes Oracle flexible and more secure when compared to its competitors. Our Oracle database is running on a Sun server, using the Sun Solaris enterprise operating system. Oracle databases are an enterprise database system, only medium and large companies would need an enterprise database. Oracle Corporation uses RDBMS rational database management systems to maintain all data within the organization. Various data items can be organized according to their relationships with each other, such as the relationship of Employee name and Employee ID, rational databases give Oracle a great deal of flexibility when describing the relationship between data elements. Oracle follows Dr.Cobbs 12 rules on how a true RDBMS should be evaluated. The following are Cobb's 12 rules.
1. Information is represented logically in tables.
2. Data must be logically accessible by table, primary key, and column.
3. Null values must be uniformly treated as "missing