In this report I will discuss briefly how transaction management can be used within the database I will also discuss how concurrency and recovery can be used within databases I intend to use the database platforms provided by Microsoft and Oracle.
Transaction Management
As applications develop the capability enhances and they can undertake more complex operations, enabling employees to keep an eye on business transactions in real time is becoming more and more important. For transaction management to occur properly IT organisations need to address a number of challenges some of these challenges may be:
1. Transaction status checking and health checks for the transaction.
2. Business figures that analyse the well-being of the company, these
…show more content…
For more than three and a half decades, Oracle has been the leader in database software. And as it has further developed technologies and acquired best-in-class companies over the years, that leadership has expanded to into all sectors of the technology industry he started off with hardware stacks and other pieces of hardware, the company then evolved into middleware and software applications for databases and other programs and now it is starting to majorly expand within the cloud. Oracle are now advancing their technologies within the cloud.
Throughout its history Oracle has proved it can build for the future on the foundation of its innovations and its knowledge of customer challenges and successes analysed by the best technical and business minds in the world.
Microsoft SQL databases- a brief description
Microsoft’s offering in the database field is SQL however over the last number of years it has amalgamated its services with Windows Azure. Windows Azure is an open and flexible cloud platform that enables you to quickly build, deploy and manage applications across a global network of Microsoft-managed datacenters. You can build applications using any language, tool or framework. You can integrate your public cloud applications with your existing IT
…show more content…
These are as follows:
1. Pessimistic locking: this control strategy must be kept locked the entire time it in the database memory. One of the main drawbacks is that it limits or prevents people from changing the data entity that is locked.
Pessimistic locking tries to guarantee the safety of database changes however this is not always made possible by the increased number of users and interactions with the database therefore slowing the operation down considerably within the database.
2. Optimistic locking: optimistic locking does not try to prevent collisions from happening however it aims to detect when they are going to happen and then it tries to counteract and resolve any issues that may occur which means that these instances can be avoided.
Optimistic locking on the other hand can take the sting out of the problem of waiting for the locks to release however this will increase the possibility and potential of accidents and collisions occurring when attempting to update the
Starvation can occur in systems where the selection of victims is based primarily on cost factors, that is, there is a high possibility that the same transaction is always picked as a victim. The downside to this is that this transaction may never get to complete its designated task, leading to the issue of starvation. Therefore, mechanisms must be put in place to ensure that transaction can be picked as a victim only a (small) finite number of times. Including the number of rollbacks in the cost factor is a common strategy used to deal with the issue.
In 1994, Jim Donehey was brought in to update Capital One’s IT system. His solution was to replace their aging mainframe computers with an object-based system, but this technology had never been used on such a large scale. In contrast, two-thirds of Capital One’s competitors outsourced their IT functions. Within 5 years the company had the world’s largest Oracle database with 23 terabytes of data – winning them the Gartner Group’s Excellence in Technology Award.
Chaffey et al., (2003) identifies the following components of the transaction processing system. The first one is the data entry. Usually it is implemented with the help of bar-code techniques and magnetic charts. In the database of dentist clinic, the information is entered using a computer keyboard and mouse. The second one is the storage and search for information in the database management system (DBMS). Microsoft Access allows saving data after input, change them as needed and find any available information. The third component is the admittance to data throw the reporting online and offline, where the last one saves records in another system for deep analyzing. In the database of dentist clinic, Microsoft Access is able to create the reports based on the queries, moderate them in a proper way and provide to managers for subsequent monitoring.
What technology can do for a company is important. A database takes information from one location and sends it to another location. Amazon’s database is the backbone to the company because Amazon is an e-commerce base company. Amazon runs off of a Linux- based database. As of 2...
In 1977, Larry Ellison, Bob Miner, and Ed Oates founded System Development Laboratories. After being inspired by a research paper written in 1970 by an IBM researcher titled “A Relational Model of Data for Large Shared Data Banks” they decided to build a new type of database called a relational database system. The original project on the relational database system was for the government (Central Intelligence Agency) and was dubbed ‘Oracle.’ They thought this would be appropriate because the meaning of Oracle is source of wisdom.
...There is less room for errors in when using automated accounting programs. The overall advantage of automating accounting processes is efficiency.
Since then, three Oracle programs have been initiated, and the application suite has been organized into five key processes, including one that assists in paint recipes and manufacturing processes spread seemlessly around the world. The Oracle applications allowed for globally centralized data that promotes efficiency and compliance, stimulates growth, and strengthens the bottom line.
Enterprise systems implementation projects are considered high risk. Tektronix had never progressed beyond the requirements analysis stage in five prior attempts to replace its order management system, so it would seem that its Oracle enterprise system implementation project was astronomically high risk. Tektronix used a number of methods to mitigate and manage the implementation risks. Clearly and thoroughly describe the major risks and critique the company’s methods for mitigating and managing the risks. Your critiques should include strengths and weaknesses of the company’s approach
Applications that depend on the frequent delivery of one-at-a-time transactions, as opposed to the transfer of large quantities of data.
[7] Elmasri & Navathe. Fundamentals of database systems, 4th edition. Addison-Wesley, Redwood City, CA. 2004.
Concurrency is a feature that allow multiple users of a database to read, modify or updat...
Some faculties and departments are already using Oracle applications in their day-to-day operations. As time goes by, more and more information users will be working with an application based on Oracle database technology. If you get the opportunity to be a member of an application development team, you will become familiar with the workings of Oracle and relational databases. Other users may have to learn about this popular database management system through their own experience. This article is for our readers who, as of yet, have no access to Oracle databases but have a yearning for learning what they're all about.
Over the last thirty plus years, in which computer software applications have been vital to business operations, the concept of client/server applications has evolved. In the early 1980’s the term, Client/Server, primarily referenced capabilities of new powerful centralized hardware. The computer world is different today and the concept is better defined as a system where the different logical components are separated from each other. The first of the three basic logical components is the Presentation Logic. The Presentation Logic is what is shown to the end user and handles the inputs and outputs of the underlying application. The second logical component is the Processing Logic. The Processing Logic handles all of the Input and Output processing and contains all of the business rules and logical processing that drives the system. The final logical component is the Storage Logic, which is where the data is stored and retrieved from and often takes the form of a database. These three components can be found in any type of Client/Server database environment.
: What is the "A" in ACID database properties? Give an example of the use of this property and what might happen if the property is not met
Another function of the DBMS is the concurrency control services. Database Management System must ensure that the database is updated correctly because the database can be used by many multiple users. The DMS enable many user to access the data concurrently. The database managements system will help from ay data loss. It have the features which that can support the updates like batch processing, locking, two-phase locking and the time stamping.