1 / 11

DBMS and tools comparison

DBMS and tools comparison. Database discussion. Outline. MySQL or PostgreSQL Is ORACLE a competitor ? Database designer tools . MySQL and PostgreSQL at first glance. First DB management systems which are seen at Linux Indicates frequency of use Both are well documented

chika
Télécharger la présentation

DBMS and tools comparison

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. DBMS and tools comparison Database discussion P.Semenov

  2. Outline • MySQL or PostgreSQL • Is ORACLE a competitor ? • Database designer tools P.Semenov

  3. MySQL and PostgreSQL at first glance • First DB management systems which are seen at Linux • Indicates frequency of use • Both are well documented • Several MySQL books • PostgreSQL book was released in December 2000 • FAQs,HOWTOs and manuals in electronic form • Both are open source software • Commercial support is also available • Both are in FNAL KITS db with maintenance level of support P.Semenov

  4. MySQL and PostgreSQL similar fetures • ANSI SQL92 compliant (almost) • Client/server architecture • Client-side library APIs • C,C++,Java • Perl,Python,Tcl • PHP • Middleware: ODBC, JDBC P.Semenov

  5. MySQL vs PostrgeSQL P.Semenov

  6. MySQL vs PostrgreSQLperformance Concurrency test results P.Semenov

  7. PostgreSQL additional featuresand drawbacks • User loadable procedural languages to define functions and triggers • PL/pgSQL • PL/Perl • PL/Tcl • Rules (SQL table operation substitutions) • Needs to run VACUUM after ADD, DELETE, UPDATE – not for real 24x7 hard environment P.Semenov

  8. MySQL additional features • Fully multi-threaded using kernel threads • Very fast thread-based memory allocation system • Several types of tables – supports transactional and non-transactional tables for fast access P.Semenov

  9. ORACLE • Includes all the features discussed • But what in addition? • More stable • Strong support • More DB administration features and tools • WebDB tool to make Web interfaces • Larger data sets • Tools to generate forms and reports • Oracle8 parallel server • Oracle integration server P.Semenov

  10. Database development tools • DbDesigner • Open source • Based on QT and KDE libraries • ER diagrams drawing and conversion from DDL • Generates DDL for several DBMSes (including MySQL and PostgreSQL) • But only at the first stage of development • DIA with UML plug-in + dia2sql perl script • Open source • Drawing ER diagram and generating DDL • Tested for MySQL and PostgreSQL only • Not very convenient P.Semenov

  11. DeZign • Commercial, but cheap • ER diagram drawing • Generates DDL for many DBMS including PostgreSQL and MySQL • Can read DDL • ex. Oracle Designer generates DDL for ANSI92 DB -> DeZing reads ANSI92 DDL -> generates MySQL or PostgreSQL database • ORACLE designer tool • Commercial and not cheap • ER diagram drawing, data flow process modeling, database size evaluation, automatic triggers definitions, user interface developing, etc • Generates DDL for many types of DBMS, unfortunately excluding MySQL and PostgreSQL • Very convenient drawing tools • But may be too complicated for beginner’s usage P.Semenov

More Related