dcsimg
Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
SQL Scripts & Samples
Tips
» Database Forum
» Slideshows
Free Newsletters:



News Via RSS Feed


Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Oracle slideshows

Posted January 31, 2019

Top 10 Databases for 2019

By Hannes DuPreez

  • Previous
    Introduction to the Top 2019 Databases
    Next

    Introduction

  • Previous
    1)	Top 2019 Database # 1: Oracle Database
    Next

    Top 2019 Database # 1: Oracle Database

    The first commercially available SQL-based Relational Database Management System was released by Oracle in 1979. Oracle provides a range of industry-leading on-premises and cloud-based database solutions to meet the data management requirements from small businesses to large enterprises.

    Oracle Database Cloud Service enables you to create full running deployments of Oracle Database easily. Oracle Autonomous Data Warehouse is a fully autonomous data warehousing environment that scales elastically, and delivers fast query performance, but most importantly, Oracle Autonomous Data Warehouse and requires no database administration. Oracle Autonomous Transaction Processing provides a self-driving, self-securing, self-repairing database service that scales to meet demands of mission critical transactions

  • Previous
    Top 2019 Database #2: MySQL
    Next

    Top 2019 Database #2: MySQL

    MySQL is the most popular Open Source SQL Database Management System (DBMS). MySQL databases are relational which stores data in separate organized tables. MySQL is Open Source which means that it is possible for anyone to use and modify the software. Anybody may download MySQL from the Internet and use it without paying a cent.

    MySQL Server handles large databases much faster than existing solutions and is used in demanding production environments and is also multi-threaded.

  • Previous
    Top 2019 Database #3: Microsoft SQL Server
    Next

    Top 2019 Database #3: Microsoft SQL Server

    Security innovations in Microsoft's flagship database, Microsoft SQL Server, help secure data for mission-critical workloads with 'layers of protection', Always Encrypted technology, dynamic data masking, and transparent data encryption.

    Microsoft SQL Server allows you to scale your business intelligence models and ensure accuracy with a comprehensive BI solution. You can also gain insights from your business with paginated reports and vivid visualizations. SQL Server Reporting Services enables you to publish reports to any mobile device and access the reports online or offline.

  • Previous
    Top 2019 Database #4: PostgreSQL
    Next

    Top 2019 Database #4: PostgreSQL

    PostgreSQL is an object-relational database management system. PostgreSQL is transactional and ACID-compliant. PostgreSQL contains updatable views and materialized views, triggers, foreign keys and supports stored procedures and functions.

    PostgreSQL is free and open source, so you are free to use, modify and distribute PostgreSQL in any form. PostgreSQL is very stable; therefore, it requires very minimum maintained efforts and the total cost of ownership is low in comparison with other database management systems.

  • Previous
    Top 2019 Database #5: MongoDB
    Next

    Top 2019 Database #5: MongoDB

    MongoDB is a cross-platform document-oriented database. It stores data in flexible, JSON-like documents. MongoDB's document model maps to the objects in your application thus making data easy to work with.

    MongoDB is free and open-source.

  • Previous
    Top 2019 Database #6: IBM Db2
    Next

    Top 2019 Database #6: IBM Db2

    The IBM Db2 family includes products for operational databases, data warehouses, data lakes and fast data.

    The IBM DB2 Relational Database Management System is designed to store, analyze and retrieve the data efficiently. DB2 is extended with the support of Object-Oriented features and non-relational structures with XML.

    The Data warehouse includes a common SQL engine to support a wide range of data structures and types. IBM Data Lake enables agile, data-driven decisions by utilizing vast amounts of unstructured data that historically could not be analyzed. IBM Fast Data combines fast data ingestion and concurrent analysis of real-time and historical data with machine learning.

  • Previous
    Top 2019 Database #7: Redis
    Next

    Top 2019 Database #7: Redis

    Redis (Remote Dictionary Server) is an open source in-memory data structure store, functioning as a database. It has built-in replication, Lua scripting and transactions. Redis supports strings, hashes, lists, sets, bitmaps, hyper loglogs, geospatial indexes and streams.

  • Previous
    Top 2019 Database #8: Amazon SimpleDB
    Next

    Top 2019 Database #8: Amazon SimpleDB

    Amazon SimpleDB is a NoSQL data store that offloads the work of database administration. Developers can easily store and query data items via web services requests while Amazon SimpleDB does the rest.

    Amazon SimpleDB is not a relational database system, it instead creates and manages multiple geographically distributed replicas of your data automatically that enables high availability and data durability.

  • Previous
    Top 2019 Database #9: Microsoft Access
    Next

    Top 2019 Database #9: Microsoft Access

    Microsoft Access is a lightweight database management system that combines the Microsoft Jet Database Engine with a user interface. An added benefit is that Microsoft Access is a member of the Microsoft Office suite of applications. Microsoft Access offers traditional Access desktop solutions as well as SharePoint web solutions.

  • Previous
    Top 2019 Database #10: SQLite
    Next

    Top 2019 Database #10: SQLite

    SQLite is a C-language library that implements a small, very fast, self-contained SQL database engine. SQLite is the most used database engine in the world mainly due to it being built into all mobile phones and most computers.

    SQLite is ACID-compliant. It implements most of the SQL standard making use of the PostgreSQL syntax. On the other hand, SQLite uses a dynamically and weakly typed SQL syntax that does not guarantee any domain integrity.

     

    Note: Database list and order were provided by the author and do not necessarily reflect the opinion of the site.

You are quite spoiled for choice when it comes to databases in 2019. The trick is to know which database to use where and when. These slides will show the top 10 databases to use in 2019, as well as the reason(s) why they are so useful and great.



Comment and Contribute

 


(Maximum characters: 1200). You have characters left.