A database is must need for any software development and which database to choose is one of the main requirement for software architecture. In 2018 – 2019 year, As a developer we have lots of choices for the databases. We can have mainly two types of the database.

       ORACLE

  • Yes, Oracle is king in the race for most popular databases. Why? – its really famous among all developers, easy to use, well-written documents, amazing new features ( JSON from SQL, Robust Code using Constants for Data Type Lengths feature, long name support, list tag improved, etc).
  • The latest version of Oracle database is 18C that is released in February 2018 with Polymorphic Table Functions, Active Directory Integration Features.

        MYSQL

  • Enterprises can commence out utilizing the free community server and later upgrade to the commercial version.
  • Runs on Linux, Windows, OSX and FreeBSD and Solaris.
  • Intuitive graphical utilize interface for designing database tables.
  • Due to its open-source community, My-SQL has a sizably voluminous bank of tutorials and information to avail you get commenced and solve quandaries

       MICROSOFT SQL

  • The most widely used commercial DBMS
  • Constrained to Windows, but this is an advantage if your enterprise uses mostly Microsoft products
  • It is platform dependent.

       POSTGRESQL

  • A particularly scalable object-relational database
  • Runs on Linux, Windows, OSX and several other systems
  • Support for table spaces, as well as for stored procedures, joins, views, triggers, etc.
  • Companies who use postgre-SQL include Apple, Cisco, Fujitsu, Skype, and IMDb

        MONGODB

  • The most popular No-SQL DB; nevertheless retains some SQL properties like query and index.
  • Fortifies a wide range of programming languages like Scala, Groovy, Clojure, and Java – eminently more than No-SQL rival Cassandra.
  • High performance on colossal databases.
  • Best for dynamic queries and for defining indexes.
  • Mongo-DB is written in C++.

        DB 2

  • IBM’s answer to Oracle’s 11g, available in host and Windows/Linux versions.
  • Runs on Linux, UNIX, Windows, and mainframes.
  • Ideal for IBM host environments.
  • Support for both SQL and No-SQL data models.

        MICROSOFT ACCESS

  • Only one installation needed (DBMS and design implement in one)
  • MS Access is DBMS from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools
  • Like Microsoft SQL Server, it’s used is circumscribed Windows

Leave a Reply