1 / 9

Understanding Different Types of Databases

Learn about various types of databases, including MySQL, PostgreSQL, Microsoft SQL Server, Oracle, and Sybase. Explore the functions and features of each system to understand their applications and benefits.

talia
Download Presentation

Understanding Different Types of Databases

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Topic: Types Of DatabaseManish.A.Giri

  2. What is Database • A database is an organized collection of data. The data is typically organized to model aspects of reality in a way that supports processes requiring information. • For example: library,Bank • Database management systems are computer software applications that interact with the user, other applications, and the database itself to capture and analyze data. • Well-known DBMSs include MySQL, PostgreSQL,Microsoft SQL Server, Oracle, Sybase and IBM DB2.

  3. MySQL • MySQL is an open source relational database management system. It is based on the structure query language (SQL). • Standard SQL commands, such as ADD, DROP, INSERT, and UPDATE can be used with MySQL. • MySQL can be used for a variety of applications, but is most commonly found on Web servers. • Many database-driven websites that • use MySQL also use a Web scripting • language like PHP to access information • from the database.

  4. PostgreSQL • PostgreSQL, is an object-relational database management system (ORDBMS). • As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. •  Recent versions also provide replication of the database itself for availability and scalability. • PostgreSQL is cross-platform and runs on many operating systems including Linux, FreeBSD, Solaris, and Microsoft Windows. • PostgreSQL is developed by the PostgreSQL • Global Development Group, a diverse group • of many companies and individual contributors. •   It is free and open source software

  5. Microsoft SQL Server • Microsoft SQL Serveris a relational database management system developed by Microsoft. • As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications. • Today, SQL is commonly used for Web database development and management. • Though SQL is now considered to be a standard • language, there are still a number of • variations of it, such as mSQL • and mySQL. • Its primary query languages are T-SQL • and ANSI SQL.

  6. Oracle Database • Oracle Database(commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system . • IT was produced and marketed by Oracle Corporation. • SDL developed the original version of the Oracle software. • An Oracle database system identified by an alphanumeric system identifier or SID—comprises at least one instance of the application, along with data storage. • The Oracle RDBMSstores data logically • in the form of tablespacesand • physically in the form of data files • ("datafiles").

  7. Sybase • Sybaseis an enterprise software and services company offering software to manage, analyze, and mobilize information, using relational databases, analytics and data warehousing solutions and mobile-application development platforms. • Sybase is a standalone subsidiary of SAP. • Sybase works with companies in infrastructure, data storage and virtualization to optimize technologies for delivery into public and virtual private cloud environments that provide greater technology availability and flexibility to Sybase customers looking to unwire their enterprise. • Sybase has a strong presence in the • financial services,telecommunications, • technology, and government • markets.

More Related