Case study of relational database management system

In addition, expanding traditional databases to accommodate rapid growth is costly. As a result, NoSQL database technologies are challenging the monopoly of the relational database management system. Many organizations are finding new freedom in having so many choices when it comes to database architectures.

Case study of relational database management system

About EROAD EROAD is a New Zealand technology and road services business that sells hardware and software that can monitor commercial vehicles and collect road-user charges electronically, replacing paper-based systems. The fleet tolling system comprises a secure on-board unit for vehicles and a secure web transaction gateway to collect road user charges and provide value-added services such as fleet and fuel management, messaging and off-road reports.

Figure 1 below shows how the service works.

The Auckland-based company has employees in offices in New Zealand, North America and Australia and is now a global technology player. Expanding into Australia and North America soon outstripped hardware capacity and prompted the company to review its infrastructure options.

EROAD considered purchasing more hardware, but that option would require annual hardware purchases and infrastructure upgrades at considerable capital and operational cost. However, establishing a co-located disaster recovery environment over multiple locations would be prohibitively expensive and time-consuming for EROAD to maintain.

The service later moved into full production following an independent audit of its Weight-Mile Tax solution by the Oregon Secretary of State Audits Division. At that point, the organization then decided to move its entire environment to AWS. Elastic Load Balancing automatically distributes traffic across the Amazon EC2 instances to ensure no single instance is overused.

A Review of Different Database Types: Relational versus Non-Relational

Amazon Route 53 manages public-facing domain name services records and ensures the services backing them are operating properly. EROAD uses Amazon VPC helps to control all elements of its virtual network, including placing its internal databases and application servers in private subnets not accessible from the internet.

The firm uses network access control lists and security groups to control access to individual Amazon EC2 instances, and running virtual private networks from its AWS environments to partners such as Vodafone. EROAD scales up and down daily to meet demand.

The firm has also pulled a large number of data sources into the Amazon Redshift managed data warehouse service with Amazon S3 as the basis of a Tableau analytics visualization service for its customers.

Solution-Why relational database would be suitable

If a change is required, EROAD can adjust the stack template or Chef recipe to roll it out through the environments using its standard release pipeline. The company uses a combination of Amazon CloudWatchthe Sensu open source monitoring framework, the Graphite storage engine and the Grafana dashboard and graph editor for monitoring.

The cloud also supports responses to each update such as checking whether the vehicle is subject to a road user charge or tax, or needs a service. The AWS Cloud delivered Relational databases are also called Relational Database Management Systems (RDBMS) or SQL databases.

Historically, the most popular of these have been Microsoft SQL Server, Oracle Database, MySQL, and IBM DB2. 1 Cluster Computing Supported by Relational Database Management Systems (A Case Study) Gerd Heber, Paul Stodghill and David Lifka Abstract — Relational database management systems are probably.

Essentials of Management Information Systems Organization and Technology Questions , Discussion Questions , Group Project , Case Study: A Geographic Information System Adds Zest to Sonny's Bar-B-Q , References Can Migration to a Relational Database Management System Help a German Home Loan Lender?


Lecture Series on Database Management System by kaja-net.comram, Department of Computer Science and Engineering, IIT Madras / Dr. S. Srinath, IIIT Bangalore.

Database Management Systems A database management system (DBMS) is computer software designed for the purpose of managing databases.

Case study of relational database management system

Typical examples of DBMSs include Oracle, IBM's DB2, Microsoft Access, Microsoft SQL Server, MySQL, 4th Dimension and FileMaker. Business needs come first when selecting databases.

While new database technologies offer sleek designs and the promise of fast performance, for many companies a relational database management system is still best for business.

Database Management System | NPTEL Online Videos, Courses - IIT Video Lectures