Scribd
Upload
62 views6 pages

ISAM Assignment #3

The document discusses several topics related to database management systems: 1. It defines what a database management system is and some of its key benefits like enabling data sharing and more efficient data management. 2. It lists three important reasons for using a database management system, including preventing data inconsistencies, improving productivity, and facilitating higher quality data. 3. It provides answers to additional questions, comparing features of file systems and database management systems, listing properties of popular database types like MySQL, Oracle, SQL Server, MongoDB, and Redis.

Uploaded by

Muhammad Ahsan Khan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
62 views6 pages

ISAM Assignment #3

The document discusses several topics related to database management systems: 1. It defines what a database management system is and some of its key benefits like enabling data sharing and more efficient data management. 2. It lists three important reasons for using a database management system, including preventing data inconsistencies, improving productivity, and facilitating higher quality data. 3. It provides answers to additional questions, comparing features of file systems and database management systems, listing properties of popular database types like MySQL, Oracle, SQL Server, MongoDB, and Redis.

Uploaded by

Muhammad Ahsan Khan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 6

IS AUDIT AND MANAGEMENT

M. Ahsan Khan 20191-25852

Submitted to: Sir Waqar Khan

Answer #1:

DATABASE MANAGEMENT SYSTEMS:

A collection of programs that enables you to store, modify, and extract information from a database.
There are many different types of DBMSs, ranging from small systems that run on personal computers to
huge systems that run on mainframes.

1. Possible to share data among multiple applications or users


2. Makes data management more efficient and effective

Importance of database management system:

1. When multiple versions of the same data exist in different areas within an organization, this is
known as data inconsistency. You may ensure that an all-encompassing picture of your data is
provided throughout your company by using a suitable management system and data quality
management tools.
2. Assuming good end-user acceptance, deploying a database management system will always
result in greater productivity for the users. End users are empowered by data management
systems to make rapid and informed decisions that can contribute to an organization's long-
term success or failure.
3. A database management system aids in the facilitation of data quality activities by offering a
structure. As a result, higher-quality data aids in the organization's ability to make better, faster
decisions.

Answer #2:

1. A file system is software that maintains and organizes files on a storage media, whereas a
database management system (DBMS) is software that accesses, creates, and manages
databases.
2. The file system, on the other hand, does not have a crash recovery mechanism, but the DBMS
does.
3. The file system has a greater level of data inconsistency. Data inconsistency is low in a database
management system, on the other hand.
4. Complicated transactions are not supported by the file system, but they are simple to construct
in a database management system using SQL.
5. Concurrency is not available on a file system, but it is available on a database management
system.

Answer #3:

1. MySQL
 There are two license types for open source RDBMS: free Community Server and
commercial Enterprise Server.
IS AUDIT AND MANAGEMENT

 Transactions are guaranteed to be ACID (with InnoDB engine). It provides instant


consistency in terms of CAP.
 Through its Shared Nothing MySQL Cluster, it provides horizontal partitioning (sharding). As
a result, it provides high availability, throughput, and low latency, as well as near-linear
scaling.
 It has multi-master ACID transactions with MySQL Cluster.
2. Oracle
 Transactions are guaranteed to be ACID. It provides instant Consistency as a single Server in
terms of CAP.
 Structured Data (SQL), Semi-Structured Data (JSON, XML), Spatial Data, and RDF Store are all
supported by advanced multi-model databases
 Depending on the Data Model, different access patterns are available.
 Blockchain Tables are available.
3. Microsoft SQL Server
 Developer and Express (free), Standard, and Enterprise licenses are available for this
proprietary RDBMS (commercial).
 Transactions are guaranteed to be ACID. It provides instant Consistency as a single Server in
terms of CAP.
 T-SQL,.NET languages, R, Python, and Java are all supported for server-side scripting.
 Structured Data (SQL), Semi-Structured Data (JSON), and Spatial Data are all supported by
this multi-model database.
4. MongoDB
 Community Server (free), Enterprise Server (commercial), and Atlas are some of the licenses
available for the Open-Core NoSQL Document Database (BSON) (managed in Cloud).
 Auto-Sharding provides horizontal scalability, and primary-secondary nodes provide built-in
replication. It is CP in terms of CAP (Consistent and Partition tolerant).
 Multi-document ACID transactions with snapshot isolation distributed across many servers.
 With the use of an aggregate pipeline, a rich and sophisticated query language with
complicated querying is available. Map-Reduce queries, text search, graph search, and geo-
search are also supported.
 MongoDB Inc. also offers a MongoDB-based full-text search engine (Atlas Search) and data
lake (Atlas Data Lake).
5. Redis
 As a distributed, in-memory key-value database, it may be used. Also functions as a
distributed cache (with or without database) and as a message broker with optional
persistence.
 Strings, hashes, lists, sets, sorted sets with range queries, bitmaps, hyper-logs, geographic
indexes, and streams are among the data structures supported.
 Redis Cluster is highly scalable, with built-in replication, automated failover, and sharding. It
is CP in terms of CAP (Consistent and Partition tolerant).
 Cache capability that is advanced (LRU eviction policy, Keys with limited TTL).
IS AUDIT AND MANAGEMENT

Answer #4
IS AUDIT AND MANAGEMENT
IS AUDIT AND MANAGEMENT
IS AUDIT AND MANAGEMENT

You might also like