Advantages of MySQL over Oracle Essay

makes it difficult for programs to interface. Quite frequently data is just lost and not retrievable.

Which database management system platform should I use? This is a very common question that developers ask themselves when they work on a project that requires storing and querying data. There are 4 well-known platforms that people may consider; they are: Oracle, Microsoft SQL, Teradata and DB2. This essay will compare and contrast the differences and similarities between these fours platforms.

It will create a clear purpose of the database and each one of the tables within making maintenance easy to perform on weekly basis and security breaches easy to spot. The quick and efficient accessibility of the data will improve timing in business reporting turnaround and therefor increase sales and profit by quick and easy business response to market changes. Security concerns will be limited by creating admin account that can control and modify the system and users that can access it without any system modifications allowed. Main server and system will be backed up on an external drive and supported by external power source so no data will be lost if database is not

Attention to detail, dealing with databases means not always getting the expected results. Some times you have to modify tables multiple times before you get the correct outputs so attention to detail is a main factor when you are dealing specially with large databases.

Though MySQL began as a low-end alternative to more powerful proprietary databases, it has gradually evolved to support higher-scale needs as well. It is still most commonly used in small to medium scale single-server deployments, either as a component in a LAMP-based web application or as a standalone database server. Much of MySQL's appeal originates in its relative simplicity and ease of use, which is enabled by an ecosystem of open source tools such as php MyAdmin. In the medium range, MySQL can be scaled by deploying it on more powerful hardware, such as a multi-processor server with gigabytes of memory.

Constraints are used to ensure the accuracy and integrity of the data contained in the database.

This process simplifies access controls by maintaining access control at a single location. One issue with this control method is that the central access control unit is a single point of failure. If the centralized access control unit fails, no access can be granted to objects. Additionally, the central access control can hinder performance if the system is unable to keep up with all access requests.

The organization has a security objective of protecting the database from being altered. Since the data is held in the system, there are regulations that have been set to the users, and there are also limits to the functions that each user performs. In this case, there are three categories of users each with clearly defined responsibilities. For instance, the administration team has been given full control of the application in that they can even alter codes and perform any variations to the database objects. The other groups of users are the executives; these have the ability to access all the information

- DBA security – Controlling the access on the DB level can also serve as a mechanism to protect sensitive data. In this type, there is always an administrator who controls the process of Account creation, granting access, revoking roles and assigning appropriate security level assignment.

Database system design can be extremely time-consuming as it takes sophisticated software to create and control it. The design process becomes less user-friendly as it takes a more extensive knowledge of how to use it. The standard of an excellent database is one, which is complete, integral, simple, understandable, flexible and

Databases are normally used by businesses and schools to store their data. These databases are kept secure, and users can only access the information stored on the database they have been granted access to. Now data is added to, accessed, or remove from a database using languages such as SQL (Structured Query Language), MYSQL (My Sequel), etc.

     There are different markets for the different classes of DBMS. Access databases and applications will be used company-wide in very small companies. These databases can be found in different departments of larger companies, but would not be used at a company level. MySQL, according to their website http://www.mysql.com, has over 6 million installations, including companies like Yahoo and the Associated Press. I think MySQL would be a good fit for a mid-sized company that cannot afford the price of the higher-end DBMS, but need more functionality, security, and robustness than is offered by Access. Finally, the large DBMS systems like SQL Server, Oracle, and DB2 are typically only utilized in large companies, because of the investment required to install and maintain these databases.

• Logical and physical data independence from database applications: Neither changes a user makes to the logical design of the database, nor changes a database software vendor makes to the physical implementation of the database, will adversely affect the applications built upon it.

MySQL, designed and distributed by Oracle, is one of the most prevalent SQL database management systems presently available. The software is an open source version. In other words, it can be downloaded and used for free.

Access control has been in use before the growth of the technology world. It could involve a simple action as locking a door. A person locks a door to prevent entry to those who are not allowed or authorize to do so. The same can be said about the security involving databases and the controlling of who can have access and what can be accessed. As far as database security is concerned, there are various categories that are involved in access control. The four main categories of access control include: Discretionary, Mandatory, Role-based, and Rule-based access control.