Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Database Management System (DBMS)

No description
by

Zack Creekmore

on 12 February 2014

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Database Management System (DBMS)

DATABASE MANAGEMENT SYSTEM
Database Management System (DBMS)
A DataBase Management System (DBMS) is a software system designed to allow the definition, creation, querying, update, and administration of databases.

Well known DBMS's include MySQL, MariaDB, PostgreSQL, SQLite, Microsoft SQL Server, Oracle, SAP, dBASE, FoxPro, IBM DB2 and
MySQL Workbench.
Object databases have been considered since the early 1980s.
The term object oriented is abbreviated by OO or 0-0.
Object DBMS Databases store data elements as objects.
Object databases are different from relational databases which are table-oriented.
Object oriented DBMS is a DBMS that stores data in a logical model that is closely aligned with an application program’s object model.
NoSQL systems are also referred to as "Not only SQL" to emphasize that they may in fact allow SQL-like query languages to be used.
A NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases.
Advantages/Disadvantages
Administrator-Friendly
More Scalable
Flexible
Cost-Effective
Flexible to use
Developer friendly
Free of cost
Uses
NoSQL databases are finding significant and growing industry use in big data and real-time web applications.
Google and Amazon are users of this specific Database Management System.
Advantages/Disadvantages
Reduced Maintenance
Real-World Modeling
Improved Reliability and Flexibility
High Code Reusability
Generally, an object database management system is a good choice when you have the following three factors:

Business needs
High performance
Complex data.
Uses
Advantages/Disadvantages
Multi-User Access
Data Structure
Network Access
Speed
Maintenance
Language
Since the early 1980's RDBMS has a predominant choice for storing data for the following:
financial records
manufacturing
logistical information
personnel data
and much more
Uses
Introduced by E. F. Codd of IBM.
RDBMS is a predominant choice for the storage of information in new databases since the 1980's.
The first commercial RDBMS was SQL/DS, released in 1981. However, the first commercially available RDBMS was Oracle, released in 1979 by Relational Software, now Oracle Corporation.

Relation DBMS
Object-oriented DBMS
NoSQL DBMS
Zack Creekmore
Structure
Structure
Structure
RDBMS
The structure of the RDBMS is a table format which is simple and easy for database users to understand and use. RDBMS provide data access using a natural structure and organization of the data. Database queries can search any column for matching entries.

Advantages
Disadvantages
Cost
Abundance of Information
Structure limit
Isolated database
RDBMS
RDBMS
Object DBMS
Object DBMS
Object DBMS
Advantages
Disadvantages
Lack of experience
Complexity
Lack of support for security
Lack of support for user
Performance
Object-oriented database technology is a marriage of object-oriented programming and
database technologies. Figure below illustrates how these programming and database concepts have come together to provide object-oriented databases
The data structure differs from the RDBMS, and therefore some operations are faster in NoSQL than in RDBMS.
NoSQL can handle hierarchical nested data structures easily. There is a relationship between performance and data complexity. Performance can degrade in a traditional RDBMS as we store the massive amounts of data required in social networking applications.
NoSQL
NoSQL
NoSQL
Standardization
Open Source
No relations between the tables
No Stored Procedures
There is no database developer
Support
Backups
Advantages
Disadvantages
The Object DBMS stores objects such as string, char (character), boolean (true or false), float (real number), short (short integer), and long (long integer).
Full transcript