Databases in My Organization

* Describe the role of databases and database management systems in managing organizational data and information.

According to the textbook, Sarbanes-Oxley Act is a federal statute enacted by Congress to improve corporate governance (Cheeseman, H. R., p.344). It was passed by congress that sets policy and regulates the accounting practices of U.S corporations.

The Sarbanes-Oxley Act was a law created in 2002 to ensure that the boards of public companies oversee their companies in a more competent and transparent way in order to protect investors. Section 302 refers to the obligations of the corporate officers who sign the financial reports. The officers are responsible for verifying that the report is accurate and represents a true picture of the company’s financial condition. Section 401 states that The Commision must evaluate the financial reports. Section 404 covers the company’s internal control structure and the requirements of the accounting firm in assessing internal controls and reporting procedures. Section 409 requires a company to disclose information on changes to financial conditions or

According to Jennings (2015), the Sarbanes Oxley Act’s purpose is “An Act to protect investors by improving the accuracy and reliability of corporate disclosures made pursuant to the securities laws, and for other purposes” (p. 246). This act was enacted because of several major accounting scandals. One company with such a scandal was Enron.

The Sarbanes-Oxley Act was enacted on July 30, 2002. It was enacted by the 107th United States Congress. It is named after sponsors U.S. Senator Paul Sarbanes and U.S. Representative Michael G. Oxley. It is also known as the ‘Public Company Accounting Reform and Investor Protection Act’ in the Senate and ‘Corporate and Auditing Accountability and Responsibility Act’ in the House. The main purpose of this act was to protect investors by improving the accuracy and reliability of corporate disclosures made pursuant to the securities laws, and for other purposes. This act was enacted as a result to a number of corporate and accounting scandals including those affecting Enron, Tyco internationals, Adelphia, Peregrine Systems, and WorldCom. The

Sarbanes Oxley Act is US federal law, which is established in order to set out the some standards for accounting firms, public company boards and management. These standards are established in order to overcome the problem of accounting scandals. Companies such as Enron and WorldCom have created major accounting scandals. Sarbanes-Oxley Act protects the investors from the accounting scandals

The Sarbanes-Oxley (SOX) act was passed into law in 2002. It was created in response to major financial scandals that largely shook the public's confidence in corporate accounting practices. It was a significant response to improper record handling techniques. Under the law, corporate managers must assess whether they have sufficient safeguards to catch fraud and bookkeeping errors. There are consequences for not complying with the provisions of the act and there are certainly advocates and opponents of it. Price Waterhouse Coopers says "Without a doubt, the Sarbanes-Oxley Act is the single most important piece of legislation affecting corporate governance, financial disclosure and the practice of public

A vital part of business today is the Sarbanes-Oxley Act. It was created to protect the integrity of business and the interest of consumers and investors. The Sarbanes-Oxley Act enforces the monitoring of finance data and information technology as it relates to storage of information. It requires the audit of a company’s assets, accounting and finance. The act requires certifications by top company officials’ to guarantee that data submitted is true and accurate. Monitoring to ensure compliance is performed by audits. Falsification of data or non-compliance to the Sarbanes-Oxley Act can results to in penalties of fines and/or imprisonment.

Databases can be used by businesses for managing accounts, inventory, personnel information, customer information, and any other record keeping needs. Phone companies have extensive databases for keeping track of customer’s calls for monthly statements, likewise with mobile phone companies. Banks transactions are all recorded in databases. The DMV has records of all drivers and motor vehicles. IRS databases contain income related information of everyone in the country. Ultimately, databases are everywhere. One can only wonder how many records relating to you are stored across what is now a forest of databases.

ESL Inc. has tasked me with the project of finding a new database system that will better meet the needs of their growing customer base. ESL is a large company that has been using a series of spreadsheets and access databases, and manual records to track their business and they are currently looking for a better way to streamline the inner workings of their business. After evaluating their current system, it is apparent, that if a decision to move forward hadn’t taken place within the next few months, their current system would start to fail, as they are reaching capacity in memory used and bandwidth running the various individual instances of Access on their network.

This paper will compare and contrast five different database management systems on six criteria. The database management systems (DBMS) that will be discussed are SQL Server 2000, Access, MySQL, DB2, and Oracle. The criteria that will be compared are the systems’ functionality, the requirements that must be met to run the DBMS, the expansion capabilities – if it is able to expand to handle more data over time, the types of companies that typically use each one, the normal usage of the DBMS, and the costs associated with implementing the DBMS.

“A database is a structured collection of records or data that is stored in a computer system. In order for a database to be truly functional, it must not only store large amounts of record, but also be able to access those records fast and efficiently. In addition, new information and changes should also be easy to input.” (tech-faq.com) To be useful over a long term the database should be able to store all the records necessary for the business to function as well as be able to get all of this information back in case of a system failure or a crash. If all the information is loss a business could go bankrupt so the database is a fail

At the U.S. Census Bureau, hundreds, perhaps more than a thousand heterogeneous databases are currently operating. Some divisions have standardized the database technology on Oracle, while others are using a combination of Sybase, MySQL, SQL Server, etc. These Relational Database Management Systems (RDBMSs), supporting many databases and applications and each hosted on dedicated servers, are often under-utilizing the server resources available to them. Such a database infrastructure, therefore, is not cost-, or resource-effective from a maintenance or administrative standpoint. Consequently, the best solution to mitigate these issues involves the implementation of database consolidation technology. Database consolidation is the process of centralizing database resources, so that they are shareable among several databases and instances. In other words, it is the process of consolidating databases from multiple servers onto one or fewer servers. For example, Multitenant Architecture of Oracle 12c moves the database management principle to a completely new level with database consolidation. Consequently, for the U.S. Census Bureau, consolidation initiatives such as the following are beneficial:

Database Systems are in requirement of hardware as well as software of a sophisticated nature, along side personnel who are deemed highly skilled. the cost of maintenance of the personnel, the hardware & the software, required for the operation and management of a Database Management System may be considerable. regulation licensing, & compliance & training costs are many at times looked over on the implementation of the Database System.

With the increasing requirements of the business world, software developers came up with the computerized database solution which has multiple built. Computer database reduces the replication of the data by storing the data at a central location so that everyone can access it