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.
- 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.
- 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
- 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.
- 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
- 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++.
- 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.
- 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