UC Vendor and Database Technology Solutions Discussion

User Generated

gtf13

Writing

University of the Cumberlands

BLCN

Description

For this assignment, you are going to do a detailed technical and business evaluation of the Open Source DBS (MySQL, PostgresDB, MariaDB, SQLite etc).

The report is a DETAILED, RESEARCH ASSIGNMENT. This is not an outline, excel spreadsheet, or a one-two project. This will require a significant level of effort and time. You are building a business use as to WHY a company would want to use this database technology solution or vendor technology (Open Source DBS (MySQL, PostgresDB, MariaDB, SQLite etc).

QUESTIONS

What are the key database products made by the vendor OR the key database platforms available under the database category (do not just use the ones listed - there are MANY MORE)?

o A minimum of 4-6 is expected here.

If a vendor, who are the competitors to the platform? If a database technology class, who is the clear leader and why?

o Provide a ½ page response at most!

Provide a short history of each key database platform you've described

o A minimum of 1-2 paragraphs PER DATABASE PLATFORM is expected.

What industries are these database vendors tools or database technology platforms used in? Is the market increasing or decreasing for technology?

o I expect a 1/2 -1-page industry synopsis here.

What are the key features for each of these database platforms? What are differentiators compared to other database platforms in its like-kind class?

o I expect 1-2 pages for EACH DATABASE PLATFORM.

Are these databases used on-premise only? Cloud-based only? Mainframe only? Explain the infrastructure use case for each of these databases that you are discussing.

o I expect a 1/2 -1-page technical synopsis here.

Provide three (3) business uses for why a customer/client would want to use your vendors/class of database technology in their environment.

o I expect a 1-2 page analysis that is researched for each use case (up to 6 pages).

What are key technical skills a data administrator or database administrator would require if they use this platform?

o You need to review job boards and postings for this. you need to come up with the ideal skill set.

Where do you believe this technology will be in 3-5 years?

o Provide a 1-2 paragraph summary.

As you can tell, this is about a 15-20 Page Paper! Your group will have a LOT OF RESEARCH. You MUST use APA citations throughout this paper. It counts as 20% of your overall grade for this assignment. Your paper will be graded against the assignment rubric which measures the following weight based on the points assigned (i.e. 20 points, 25 points depending on if you are in MAIN or 1G/IIG)

Technical Competency (25%)

Business Competency (20%

Technical Accuracy (25%)

Spelling / Grammar (10%)

Citations / APA (20%)



User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hey buddy, see attached. Let me know if you need any revisions or edits😃

Running Head: DBMS PRODUCTS AND VENDORS

Vendor and Database Technology Solutions
Name
Institution
Course Code

1

DBMS PRODUCTS AND VENDORS

2
Introduction

Storing data in distinct, simple files was bound to fail because of the desire to
minimize data redundancy and share data, the need for recovery, backup, privacy, data
security, and the increase in volumes of data and demand for data access (Gillenson, 2011).
Database management systems emerged to satisfy these requirements, along with a new
category of personnel, such as data management specialist and database administrator. Even
though the database management industry comprises some of the biggest corporations in the
technology industry such as Amazon, Oracle, SAP, IBM, and Microsoft, several open-source
DBMSs such as Apache Cassandra, MySQL, MongoDB, SQLite, PostgreSQL, and MariaDB
are still highly competitive.
Key Database Products
Oracle MySQL
Oracle acquired MySQL open-source DBMS from Sun Microsystem in 2010.
MySQL, which uses Structured Query Language, is used for information technology
enterprise environments. It is devised to allow users to manage and design complex data sets
and applications and has obtained a significant share of the overall database management
systems’ market.
Although Oracle MySQL is an open-source system, it is regarded as a feasible choice
for even the mission-critical and most complex enterprise databases. Oracle has affirmed its
dedication to MySQL even though it competes with its own 11g database. MySQL has
several valuable features that lack in 11g. Furthermore, it has penetrated the open-source
market, which Oracle’s database has not managed to achieve (Kercher, 2011). Oracle has also
integrated the InnoDB and MySQL teams which will ensure enhancements in the
performance of the product.

DBMS PRODUCTS AND VENDORS

3

MySQL is well-known for hosting web application due to its abundance in weboptimized features such as HTML data types. It is a section of the PHP, MySQL, Apache,
Linux architecture, and an arrangement used to support and deliver advanced web-based
applications. MySQL is employed as the back-end database by some extensive web
application, like Facebook, Google, and Wikipedia – proof to its robustness and stability even
though it is decentralized.
SQLite
SQLite is composed of an in-process library that employs a transactional SQL,
serverless, zero-configuration, self-contained database engine. SQLite’s source code is easily
accessible and free for both commercial and private purposes. The database management
system has bindings to numerous programming languages like Delphi, Java, Python, C#,
BASIC, C++, and C. Users can access SQLite using scripting languages on Windows
operating systems like JavaScript and Visual Basic script to enhance abilities to HTML
applications because of the COM (ActiveX) wrapper. Also, it is offered in embedded OS like
Symbian OS, Android, WebOS, BlackBerry, Maemo, Android, and iOS due to its ease of
operation and small size (Techopedia, 2001).
SQLite complies to ACID properties. It is an integral part of client-based applications,
and it comprises of a C programming library that is dynamically called. This embedded
relational DBMS performs multitasking to do writes and reads simultaneously, and also
makes use of a dynamic SQL syntax. The writes and reads are performed directly to common
disk files. Application programs make use of SQLite’s capability using simple function calls,
thus minimizing latency in accessing the database. These applications keep their whole
databases in host machines as single cross-platforms files. This scheme is employed by
locking the whole database when performing a write.

DBMS PRODUCTS AND VENDORS

4

SQLite uses an unusual system for SQL DBMS and employs the SQL-92 standard.
Assigning separate values to types enhances flexibility to columns when connected to
dynamic scripting languages. SQLite makes full Unicode support optional.
PostgreSQL
PostgreSQL is an enterprise-class and advanced open-source database management
system that supports both non-relational querying using JSON and relational querying using
SQL (Amazon, n.d.). It is a very scalable DBMS, backed by over two decades of community
development which have played a role in its correctness, integrity, and resilience.
PostgreSQL is employed as the main data warehouse or data store for numerous analytical,
geospatial, mobile, and web applications. Its latest release is version 11. PostgreSQL
maintains a degree of performance optimization that is shared among its commercial database
competitors such as SQL Server and Oracle. It also has a rich history for backing advanced
types of data.
MariaDB
MariaDB DBMS is among the well-known database systems in the globe. It is
developed by the initial creators of MySQL and assured to remain open-source. Some of the
notable users comprise Google, WordPress, and Wikipedia (MariaDB, n.d.). MariaDB
converts data into structured information in a large variety of uses, varying from websites to
banking. It is an improved alternative for MySQL.
MariaDB is employed since it is robust, scalable, and fast, with an abundant
ecosystem of plug-ins and storage engines, and numerous other tools that give it the
capability to become very flexible for a variety of uses. As a relational DBMS, it offers users
with an SQL interface for retrieving data. The latest MariaDB version also includes JSON
and GIS features.

DBMS PRODUCTS AND VENDORS

5

Apache Cassandra
Apache Cassandra is a DBMS which was originally created at Facebook by Prashant
Malik and Avinash Lakshman. It employs a No-SQL distributed system as an alternative to
the traditional relational DBMS. Apache Cassandra is suitable for managing large volumes of
unstructured data, like those created by online and website companies, while providing zero
downtime and highly accessible service.
The DBMS’s system is accountable for its capability to perform, scale and offers
continuous uptime. Instead of employing a challenging design to maintain sharded
architecture or a legacy server master-slave, it uses a masterless ring structure that is easily
maintainable, elegant, and easy to setup. In this database management system, all nodes have
an identical function; all nodes interact equally among themselves since there is no concept of
the master node. Its scalable architecture ensures that the DBMS can handle thousands of
concurrent operations or users per second and large volumes of data as effortlessly as it
would handle much smaller user traffic and amounts of data. Unlike other sharded or masterslave systems, Apache Cassandra’s structure also makes sure that it cannot fail, thus can
provide true continuous uptime and availability – easily increase the nodes in an existing
cluster without shutting it down.
Several organizations have successfully implemented and gained from Apache
Cassandra, including various large organizations like Netflix, Uber, Spotify, Instagram, eBay,
Comcast, Apple, among others. More significant production environments consist of
petabytes of data in clusters of more than seventy-five thousand nodes.
MongoDB
MongoDB uses an unstructured query language and a document-oriented data system.
It is among the most robust NoSQL databases and systems available today. Being NoSQL

DBMS PRODUCTS AND VENDORS

6

implies that it does not employ the common columns and rows associated with relational
DBMS. MongoDB is an architecture developed on documents and collections. The basic unit
of data contained in this DBMS comprises of a collection of key-value pairs (Intellipat,
2016). It permits documents to various structures and fields.
MongoDB makes use of a document storage structure known as BSON which is a
binary format of JSON files. The data model implemented in MongoDB is highly flexible
and allows organizations to store and combine data of several variable types while
maintaining the robust validation, data access, and indexing options rules. Moreover, the
DBMS has no downtime when modifying the schemas dynamically.
Competitors
Oracle MySQL remains the number one opensource and free database management
system. According to Anderson (2020), Oracle MySQL represents more than thirty per cent
of the opensource DBMSs. It has held this position for several years. Its main competitor is
PostgreSQL which is the second most used database management system. In recent years, it
has acquired a lot of popularity and developers employing the database management system
are impressed with it, both in performance and capabilities.
MongoDB, in ...


Anonymous
Excellent resource! Really helped me get the gist of things.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags