Relational databases store and manage data in a traditional table format, with each piece of data organized into a row and a column. Columns hold the data of a single type or field, like first name, order number, or the image link of a product logo. Rows create the relationship between these data points. For example, rows can associate a first name to a last name and then to a user name, email address, and customer ID. Businesses use relational databases to maintain the data from their applications and ensure they always have access to critical customer information, product data, social data, and financial particulars like purchases, fulfillment, revenue, and expenses. These systems can range from desktop applications that create a small database on your machine to large enterprise-grade data stores. Almost all use a form of SQL as their query language, and most adhere to the ACID set of properties to ensure reliable transactions: atomicity, consistency, isolation, and durability.
Relational databases are generally chosen due to their simplicity in comparison to NoSQL databases, such as object-oriented databases, document databases, and graph databases. Those looking for a relational database solution with little budget also have options with free database software.
To qualify for inclusion in the Relational Databases category, a product must:
Relational Databases reviews by real, verified users. Find unbiased ratings on user satisfaction, features, and price based on the most reviews available anywhere.
SQL Server 2017 brings the power of SQL Server to Windows, Linux and Docker containers for the first time ever, enabling developers to build intelligent applications using their preferred language and environment. Experience industry-leading performance, rest assured with innovative security features, transform your business with AI built-in, and deliver insights wherever your users are with mobile BI.
About IBM Db2 IBM believes in unlocking the potential of your data, not throttling it. We hold our databases to a higher standard, making it easy to deploy your data wherever it's needed, fluidly adapting to your changing needs and integrating with multiple platforms, languages and workloads. IBM Db2 is supported across Linux, Unix, and Windows operating systems.
The SAP HANA® platform helps you reimagine business by combining a robust database with services for creating innovative applications. It enables real-time business by converging trans-actions and analytics on one in-memory platform. Running on premise or in the cloud, SAP HANA untangles IT complexity, bringing huge savings in data management and empowering decision makers everywhere with new insight and predictive power.
Amazon Relational Database Service (Amazon RDS) is a web service that makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while managing time-consuming database administration tasks, freeing you up to focus on your applications and business. Amazon RDS gives you access to the capabilities of a familiar MySQL, Oracle or Microsoft SQL Server database engine. This means that the code, applications, and tools you already use today with your existing databases can be used with Amazon RDS. Amazon RDS automatically patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery. You benefit from the flexibility of being able to scale the compute resources or storage capacity associated with your relational database instance via a single API call. In addition, Amazon RDS makes it easy to use replication to enhance availability and reliability for production databases. Amazon RDS for MySQL also enables you to scale out beyond the capacity of a single database deployment for read-heavy database workloads. As with all Amazon Web Services, there are no up-front investments required, and you pay only for the resources you use.
MariaDB frees companies from the costs, constraints and complexity of proprietary databases, enabling them to reinvest in what matters most – rapidly developing innovative, customer-facing applications. MariaDB uses pluggable, purpose-built storage engines to support workloads that previously required a variety of specialized databases. With complexity and constraints eliminated, enterprises can now depend on a single complete database for all their needs, whether on commodity hardware or their cloud of choice. Deployed in minutes for transactional or analytical use cases, MariaDB delivers unmatched operational agility without sacrificing key enterprise features including real ACID compliance and full SQL. Trusted by organizations such as Deutsche Bank, DBS Bank, Nasdaq, Red Hat, The Home Depot, ServiceNow and Verizon – MariaDB meets the same core requirements as proprietary databases at a fraction of the cost. No wonder it’s the fastest growing open source database. Real business relies on MariaDB™.
Harness data with broad functionality and unlimited scalability. IBM Informix is a secure embeddable database, optimized for OLTP and Internet of Things (IoT) data. Informix has the unique ability to seamlessly integrate SQL, NoSQL/JSON, time series and spatial data. Everyone from developers to global enterprises can benefit from its reliability, flexibility, ease of use and low total cost of ownership. Optimize business decisions Perform analytics close to data sources to enhance local decision making. Access business intelligence faster with enhanced integration with various tools and applications. Eliminate downtime Ensure always-on operations across your grid environment. Upgrade, maintain and configure the grid with no downtime. Successfully meet service-level agreements. Improve development agility Support both structured and unstructured data with a hybrid database system for enhanced flexibility and easier development. IBM Informix is available on-premise and on the IBM Cloud. IBM Informix on Cloud offers the complete feature set of on-premises Informix deployments. Run your OLTP queries and workloads on an optimized instance and use the Informix warehouse accelerator to configure in-memory query acceleration for predictive analytics. Get the benefits of Informix without the cost, complexity and risk of managing your own infrastructure. IBM Informix V14.10 enhances all editions, bringing improvements to performance, security, administration, and core database capabilities. Discover why many of the world’s most innovative companies depend on IBM Informix.
Cloud SQL is a fully-managed database service that makes it easy to set up, maintain, manage, and administer your relational PostgreSQL BETA and MySQL databases in the cloud. Cloud SQL offers high performance, scalability, and convenience. Hosted on Google Cloud Platform, Cloud SQL provides a database infrastructure for applications running anywhere.
Azure SQL Database is a relational database-as-a service using the Microsoft SQL Server Engine. SQL Database is a high-performance, reliable, and secure database you can use to build data-driven applications and websites in the programming language of your choice, without needing to manage infrastructure.
SAP® IQ software delivers speed and power for extreme-scale enterprise data warehousing and analytics. Its column-oriented, grid-based massively parallel processing (MPP) architecture and patented data compression and indexing technologies enable companies to exploit the value of huge amounts of data at the speed of business.
MemSQL is The No Limits Database™, powering modern applications and analytical systems with a cloud-native, massively scalable architecture for maximum ingest and query performance with the highest concurrency. MemSQL envisions a world where every business can make decisions in real time and every experience is optimized through data. Global enterprises use the MemSQL distributed database to easily ingest, process, analyze, and act on data in order to thrive in today’s insight-driven economy. MemSQL is optimized to run on any public cloud or on-premises with commodity hardware. Headquartered in San Francisco, CA with offices in Seattle, WA and Portland OR, MemSQL has raised $110M from top investors including GV, Accel Partners, and Khosla Ventures, among others. MemSQL is trusted by customers including Uber, Akamai, Dell EMC, Samsung, Comcast, Kellogg, and more. If you want to work at a company that celebrates diversity, innovation, leadership, and creativity every day, check out our openings on our Careers page - https://msql.co/2IiV84M.
PSQL database files can be defragmented without any engine down time. Reads and writes can operate continuously during defragmentation. The Defragmenter GUI will detect data files in use and can analyze fragmentation levels of files, allowing users to quickly find the biggest problem first.
With SAP® Adaptive Server® Enterprise (SAP ASE), you can handle massive volumes of data and thousands of concurrent users to accelerate the growth of new data-driven business applications. Drive value with a faster, more efficient transactional system that is designed to meet the demands of the digital economy.
Base is a full-featured desktop database front end, designed to meet the needs of a broad array of users. Base caters to power users and enterprise requirements, providing native-support drivers for some of the most widely employed multi-user database engines: MySQL/MariaDB, Adabas D, MS Access and PostgreSQL. In addition, the built-in support for JDBC- and ODBC-standard drivers allows you to connect to virtually any other existing database engine as well.
SQLGate is an integrated database management and development solution that simplifies construction and operation of databases. A solution that fits different types of databases, SQLGate is customized for seven different databases that make up 83.2% of the DBMS market. These include: Oracle, SQL Server, MySQL, MariaDB, Tibero, and PostgreSQL. SQLGate makes it easier and quicker to deal with databases holding large amounts of data.
Active Query Builder is a component for software developers to give end-users without any experience in SQL language the ability to create SQL queries via the intuitive drag'n'drop interface. Same time it allows experienced users to analyze their queries visually by parsing them and building the visual diagram. Active Query Builder substitutes tedious typing with natural point-and-click actions, helps to avoid common pitfalls, enables preview the result sub-query data to understand and debug complex SQL queries.
dbForge Schema Compare for SQL Server is a reliable tool that saves your time and effort when comparing and synchronizing databases on SQL Server. The tool allows working with live SQL Server databases, snapshots, and backups. You can quickly compare your SQL Server databases, analyze differences and perform error-free schema synchronization using generated SQL scripts.
InterSystems Caché® is a high-performance database that powers transaction processing applications around the world. It is used for everything from mapping a billion stars in the Milky Way, to processing a billion equity trades in a day, to managing smart energy grids. Caché is a multi-model (object, relational, key-value) DBMS and application server developed by InterSystems. InterSystems Caché provides several APIs to operate with same data simultaneously: key-value, relational, object, document, multidimensional. Data can be managed via SQL, Java, node.js, .NET, C++, Python. DBMS Caché has proven embedded technologies for horizontal scaling (ECP, SLM), High Availability (Mirroring), transaction support and backup. It includes embedded Caché ObjectScript language which is back compatible to mumps and which helps to run applications' business logic close to the data and achieve maximum performance for complex logic operations with data. Caché also provides application server which hosts web apps (CSP), REST, SOAP, web sockets and other types of TCP access for Caché data.
Postgres Plus Advanced Server is built upon and integrates every release advanced open source database, PostgreSQL. EDB engineers then work continuously with our enterprise users to add features, tools and solutions to meet our customers demanding standards.