Send the link below via email or IMCopy
Present to your audienceStart 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
Database Management System (DBMS)
Transcript of Database Management System (DBMS)
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
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.
Flexible to use
Free of cost
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.
Improved Reliability and Flexibility
High Code Reusability
Generally, an object database management system is a good choice when you have the following three factors:
Since the early 1980's RDBMS has a predominant choice for storing data for the following:
and much more
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.
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.
Abundance of Information
Lack of experience
Lack of support for security
Lack of support for user
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.
No relations between the tables
No Stored Procedures
There is no database developer
The Object DBMS stores objects such as string, char (character), boolean (true or false), float (real number), short (short integer), and long (long integer).