# Best Database Management Systems (DBMS)

## How Many Database Management Systems (DBMS) Products Does G2 Track?

**Total Products under this Category:** 256

### Category Stats (Aug 2026)

- **Average Rating:** 4.29/5 The average rating of products in this category, based on all submitted ratings
- **Top Trending Product:** ScaleGrid (+1.86%) - Among all products in this category, ScaleGrid recorded the largest rating increase compared to last month

_Last updated: August 03, 2026_

## How Does G2 Rank Database Management Systems (DBMS) Products?

**Why You Can Trust G2's Software Rankings:**

- 30 Analysts and Data Experts
- 9,900+ Authentic Reviews
- 256+ Products
- Unbiased Rankings

G2's software rankings are built on verified user reviews, rigorous moderation, and a consistent research methodology maintained by a team of analysts and data experts. Each product is measured using the same transparent criteria, with no paid placement or vendor influence. While reviews reflect real user experiences, which can be subjective, they offer valuable insight into how software performs in the hands of professionals. Together, these inputs power the G2 Score, a standardized way to compare tools within every category.

## G2 Grid® for Database Management Systems (DBMS)
 ![G2 Grid® for Database Management Systems (DBMS) plotting products by satisfaction and market presence](https://www.g2.com/categories/database-management-systems-dbms/grids.png?focus%5B%5D=630&focus%5B%5D=10938&focus%5B%5D=1251&focus%5B%5D=40540&focus%5B%5D=135981&focus%5B%5D=40859&focus%5B%5D=1327283&focus%5B%5D=2503)

Highlighted products: Microsoft SQL Server, Snowflake, SAP HANA Cloud, Google Cloud SQL, Supabase, Amazon Athena, SAS Viya, and SQL Developer.

Underlying data: [Grid® JSON](https://www.g2.com/categories/database-management-systems-dbms/grids.json?focus%5B%5D=microsoft-sql-server&focus%5B%5D=snowflake&focus%5B%5D=sap-hana-cloud-2025-10-01&focus%5B%5D=google-cloud-sql&focus%5B%5D=supabase-supabase&focus%5B%5D=amazon-athena&focus%5B%5D=sas-sas-viya&focus%5B%5D=sql-developer)

**Sponsored**

### RaimaDB

RaimaDB: The High-Performance Embedded Database for Edge and IoT Systems RaimaDB is a high-performance, small-footprint database designed for edge computing, IoT, and embedded systems. Built on over three decades of database innovation, RaimaDB provides a powerful, reliable, and resource-efficient solution for developers building applications where data integrity, speed, and local storage are critical. Unlike large-scale enterprise databases, RaimaDB is purpose-built for environments with limited memory and processing power—such as industrial controllers, automotive systems, medical devices, and network appliances. Its lightweight architecture allows for fast transactions, deterministic performance, and minimal overhead, making it ideal for real-time applications. RaimaDB supports both SQL and C/C++ APIs, giving developers flexibility in how they access and manage data. It’s fully ACID-compliant, ensuring data reliability even in harsh or disconnected environments. With advanced features like in-memory performance, high availability, and flexible replication, RaimaDB enables secure local data processing while still integrating seamlessly with cloud or enterprise systems when connectivity is restored. The database can be deployed on a wide range of operating systems, including Linux, embedded Linux, Windows, QNX, and VxWorks, and can run on both ARM and x86 architectures. Its modular design allows for efficient scaling—from compact single-board computers to complex distributed networks. Trusted by global leaders in industries such as automotive, aerospace, energy, and telecommunications, RaimaDB powers mission-critical systems that demand reliability and speed. Developers choose RaimaDB for its ease of integration, low maintenance requirements, and proven performance under demanding conditions. Whether you’re building the next generation of connected devices or optimizing data handling at the edge, RaimaDB provides the robust foundation you need. Experience the efficiency of a database built for embedded and real-time systems—fast, reliable, and ready for the future of intelligent data management.

[Visit website](https://www.g2.com/external_clickthroughs/record?secure%5Bad_program%5D=ppc&secure%5Bad_slot%5D=category_product_list_llm&secure%5Bcategory_id%5D=303&secure%5Bchosen_at%5D=2026-08-04T03%3A32%3A17Z&secure%5Bdisplayable_resource_id%5D=303&secure%5Bdisplayable_resource_type%5D=Category&secure%5Bmedium%5D=sponsored&secure%5Bplacement_reason%5D=page_category&secure%5Bplacement_resource_ids%5D%5B%5D=303&secure%5Bprioritized%5D=false&secure%5Bproduct_id%5D=6173&secure%5Bresource_id%5D=303&secure%5Bresource_type%5D=Category&secure%5Bsource_type%5D=category_page&secure%5Bsource_url%5D=https%3A%2F%2Fwww.g2.com%2Fcategories%2Fdatabase-management-systems-dbms%3Fopen_modal_url%3D%252Fproducts%252Fca-rc-update-for-db2-for-z-os%252Fwishlists%253Fhost_path%253D%25252Fcategories%25252Fdatabase-management-systems-dbms%2526source%253Dcategory&secure%5Btoken%5D=d536a71ce66d6eecb029de73caa6e6d4bbd8145a953b85a4183e45fc32bfcbc0&secure%5Burl%5D=https%3A%2F%2Fraima.com%2Fdownload-trial%2F%3Futm_content%3Dproducts-raimadb-reviews%26utm_medium%3Dreferral%26utm_source%3Dg2&secure%5Burl_type%5D=free_trial)

### [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews)

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.

**Average Rating:** 4.4/5.0

**Total Reviews:** 2,127

#### How Do G2 Users Rate Microsoft SQL Server?

- **Has the product been a good partner in doing business?:** 8.4/10 (Category avg: 8.8/10)
- **Data dictionary:** 8.9/10 (Category avg: 8.5/10)
- **Backup and Recovery:** 9.0/10 (Category avg: 8.5/10)
- **Data Migration:** 8.9/10 (Category avg: 8.4/10)

#### Who Is the Company Behind Microsoft SQL Server?

- **Seller:** [Microsoft](https://www.g2.com/sellers/microsoft)
- **Year Founded:** 1975
- **HQ Location:** Redmond, Washington
- **Twitter:** @microsoft  
13,091,739 Twitter followers
- **LinkedIn® Page:** [www.linkedin.com](https://www.g2.com/external_clickthroughs/record?secure%5Bsource_type%5D=product_profile&secure%5Btoken%5D=9458f51bd6ded48ad432a804f19ad736469f007787569b63827154231c315630&secure%5Burl%5D=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fmicrosoft%2F&secure%5Burl_type%5D=linkedin_company_website)  
231,632 employees on LinkedIn®
- **Ownership:** MSFT

#### Who Uses This Product?

- **Who Uses This:** Software Engineer, Software Developer
- **Top Industries:** Information Technology and Services, Computer Software
- **Company Size:** 45% Large, 37% Medium

#### What Do G2 Reviewers Say About Microsoft SQL Server?

_AI-generated summary from verified user reviews_

##### Pros

- Users appreciate the **ease of use** of Microsoft SQL Server, enjoying its intuitive GUI and powerful capabilities.
- Users appreciate the **robust database management** of Microsoft SQL Server, enabling effective data handling and user administration.
- Users value the **exceptional performance** of Microsoft SQL Server, noting its powerful capabilities and ease of use.
- Users appreciate the **enterprise-grade security and powerful features** of Microsoft SQL Server, enhancing peace of mind and usability.
- Users appreciate the **easy integrations** of Microsoft SQL Server, enhancing their data management and analytics workflows seamlessly.

##### Cons

- Users find Microsoft SQL Server's **high licensing costs** prohibitive, particularly affecting smaller businesses and startups.
- Users struggle with the **high licensing costs** of Microsoft SQL Server, making it challenging for smaller businesses.
- Users note that the **high licensing costs** of Microsoft SQL Server can be challenging for smaller businesses and projects.
- Users find the **licensing costs to be prohibitively high** , especially for small businesses and projects.
- Users find **performance issues** with SQL Server, particularly regarding tuning, scaling, and resource consumption on older systems.

#### What Are Recent G2 Reviews of Microsoft SQL Server?

**["Makes Data management simpler!!"](https://www.g2.com/survey_responses/microsoft-sql-server-review-12902759)**

**Rating:** 4.0/5.0 stars

_— Hari K._

[Read full review](https://www.g2.com/survey_responses/microsoft-sql-server-review-12902759)

**["Powerful Performance Tuning, Strong Security and Environment Flexible"](https://www.g2.com/survey_responses/microsoft-sql-server-review-12873238)**

**Rating:** 4.0/5.0 stars

_— Janani D._

[Read full review](https://www.g2.com/survey_responses/microsoft-sql-server-review-12873238)

#### What Are G2 Users Discussing About Microsoft SQL Server?

- [What are the latest advancements in Microsoft SQL Server that are enhancing database management for businesses?](https://www.g2.com/discussions/what-are-the-latest-advancements-in-microsoft-sql-server-that-are-enhancing-database-management-for-businesses) - 2 comments
- [What is Microsoft SQL Server used for?](https://www.g2.com/discussions/microsoft-sql-server-what-is-microsoft-sql-server-used-for) - 2 comments, 1 upvote
- [Is there a free version of Microsoft SQL Server?](https://www.g2.com/discussions/is-there-a-free-version-of-microsoft-sql-server) - 3 comments
- [What is Microsoft SQL Server used for?](https://www.g2.com/discussions/what-is-microsoft-sql-server-used-for) - 2 comments
- [What are the features of SQL?](https://www.g2.com/discussions/what-are-the-features-of-sql) - 1 comment

### [Snowflake](https://www.g2.com/products/snowflake/reviews)

Snowflake makes enterprise AI easy, efficient and trusted. Thousands of companies around the globe, including hundreds of the world’s largest, use Snowflake’s AI Data Cloud to share data, build applications, and power their business with AI. The era of enterprise AI is here. Learn more at snowflake.com (NYSE: SNOW).

**Average Rating:** 4.5/5.0

**Total Reviews:** 712

#### How Do G2 Users Rate Snowflake?

- **Has the product been a good partner in doing business?:** 9.0/10 (Category avg: 8.8/10)
- **Data dictionary:** 9.0/10 (Category avg: 8.5/10)
- **Backup and Recovery:** 9.0/10 (Category avg: 8.5/10)
- **Data Migration:** 9.3/10 (Category avg: 8.4/10)

#### Who Is the Company Behind Snowflake?

- **Seller:** [Snowflake, Inc.](https://www.g2.com/sellers/snowflake-inc)
- **Company Website:** www.snowflake.com
- **Year Founded:** 2012
- **HQ Location:** 135 Constitution Drive, Menlo Park CA
- **Twitter:** @SnowflakeDB  
278 Twitter followers
- **LinkedIn® Page:** [www.linkedin.com](https://www.g2.com/external_clickthroughs/record?secure%5Bsource_type%5D=product_profile&secure%5Btoken%5D=ad18ff73a9b8bb34dd1b98a6ba1c6be57f7364939ad352612ecc483aba05d2b2&secure%5Burl%5D=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fsnowflake-computing%2F&secure%5Burl_type%5D=linkedin_company_website)  
11,308 employees on LinkedIn®

#### Who Uses This Product?

- **Who Uses This:** Data Engineer, Data Analyst
- **Top Industries:** Information Technology and Services, Computer Software
- **Company Size:** 45% Medium, 43% Large

#### What Do G2 Reviewers Say About Snowflake?

_AI-generated summary from verified user reviews_

##### Pros

- Users appreciate the **ease of use** of Snowflake, finding it fast and effective for data sharing and analytics.
- Users value the **reliable features** of Snowflake, enjoying its intuitive interface and seamless data integration for analytics.
- Users find Snowflake's **data management capabilities** excellent for efficiently aggregating and querying across multiple datasets.
- Users admire the **seamless scalability** of Snowflake, effortlessly accommodating work demands and ensuring optimal performance.
- Users appreciate the **fast data analysis** of Snowflake, enabling quick insights without infrastructure worries.

##### Cons

- Users find Snowflake's **high costs** burdensome, especially for small businesses with limited budgets.
- Users find **feature limitations** in Snowflake, such as lack of code blocks and challenge in permissions management.
- Users find that **cost management** requires discipline, as unexpected charges can accumulate quickly without careful monitoring.
- Users find the **cost structure difficult to optimize** , leading to unexpectedly high initial expenses during implementation.
- Users find Snowflake's **limited features** in dynamic scripts and monitoring hinder flexibility and usability.

#### What Are Recent G2 Reviews of Snowflake?

**["Elastic Scaling and Fast Analytics with Snowflake"](https://www.g2.com/survey_responses/snowflake-review-13129003)**

**Rating:** 4.5/5.0 stars

_— Ravindra N._

[Read full review](https://www.g2.com/survey_responses/snowflake-review-13129003)

**["Snowflake Simplifies Data Management at Scale"](https://www.g2.com/survey_responses/snowflake-review-12898129)**

**Rating:** 4.0/5.0 stars

_— Harshil A._

[Read full review](https://www.g2.com/survey_responses/snowflake-review-12898129)

#### What Are G2 Users Discussing About Snowflake?

- [What is Snowflake used for?](https://www.g2.com/discussions/what-is-snowflake-used-for) - 2 comments, 1 upvote

### [SAP HANA Cloud](https://www.g2.com/products/sap-hana-cloud-2025-10-01/reviews)

SAP HANA Cloud is a modern database-as-a-service (DBaaS) powering the next generation of intelligent data applications. SAP HANA Cloud offers a competitive edge by incorporating advanced machine learning and predictive tools grounded in modern data science. Its powerful in-memory performance safeguards efficient data processing. By securely storing vast amounts of data with its integrated multitier storage and handling various types on a single copy in its native multi-model database, SAP HANA Cloud simplifies data management and connects to other data sources. The seamless integration of these capabilities in a reliable, unified foundation makes it easier for developers to build high-demand intelligent data apps.

**Average Rating:** 4.3/5.0

**Total Reviews:** 521

#### How Do G2 Users Rate SAP HANA Cloud?

- **Has the product been a good partner in doing business?:** 8.5/10 (Category avg: 8.8/10)
- **Data dictionary:** 8.7/10 (Category avg: 8.5/10)
- **Backup and Recovery:** 9.0/10 (Category avg: 8.5/10)
- **Data Migration:** 8.6/10 (Category avg: 8.4/10)

#### Who Is the Company Behind SAP HANA Cloud?

- **Seller:** [SAP](https://www.g2.com/sellers/sap)
- **Year Founded:** 1972
- **HQ Location:** Walldorf
- **Twitter:** @SAP  
297,052 Twitter followers
- **LinkedIn® Page:** [www.linkedin.com](https://www.g2.com/external_clickthroughs/record?secure%5Bsource_type%5D=product_profile&secure%5Btoken%5D=8fd712dbd816fadfc039a60dcf8c1a3d6a48469756075586fa0be3da7e4b74d7&secure%5Burl%5D=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fsap%2F&secure%5Burl_type%5D=linkedin_company_website)  
141,955 employees on LinkedIn®
- **Ownership:** NYSE:SAP

#### Who Uses This Product?

- **Who Uses This:** Consultant, SAP Consultant
- **Top Industries:** Information Technology and Services, Computer Software
- **Company Size:** 61% Large, 26% Medium

#### What Do G2 Reviewers Say About SAP HANA Cloud?

_AI-generated summary from verified user reviews_

##### Pros

- Users appreciate the **ease of use** with SAP HANA Cloud, enjoying seamless integration and smooth real-time analytics.
- Users appreciate the **easy integrations** of SAP HANA Cloud, enhancing their workflow and data management seamlessly.
- Users value the **smooth integration capabilities** of SAP HANA Cloud, enhancing efficiency and simplifying data management.
- Users value the **speed and responsiveness** of SAP HANA Cloud, making data handling efficient and streamlined.
- Users value the **flexible and elastic scalability** of SAP HANA Cloud, enhancing performance for data-intensive applications.

##### Cons

- Users find the **complexity of the setup** challenging, particularly for new users and integrations with other systems.
- Users find SAP HANA Cloud to be **expensive** , particularly for large data demands and advanced configurations requiring expertise.
- Users find the **learning curve challenging** , especially for teams new to HANA's concepts and SQL extensions.
- Users find the **difficult learning curve** of SAP HANA Cloud challenging, especially for new users and feature navigation.
- Users find the **complex setup** of SAP HANA Cloud challenging, particularly for newcomers and during initial provisioning.

#### What Are Recent G2 Reviews of SAP HANA Cloud?

**["Efficient Transactions, But Time-Intensive Setup"](https://www.g2.com/survey_responses/sap-hana-cloud-review-12983922)**

**Rating:** 4.0/5.0 stars

_— Sumeet R._

[Read full review](https://www.g2.com/survey_responses/sap-hana-cloud-review-12983922)

**["Real-Time Analytics Powerhouse with Flexible, Scalable Performance."](https://www.g2.com/survey_responses/sap-hana-cloud-review-12631916)**

**Rating:** 5.0/5.0 stars

_— Mahendra S._

[Read full review](https://www.g2.com/survey_responses/sap-hana-cloud-review-12631916)

### [Google Cloud SQL](https://www.g2.com/products/google-cloud-sql/reviews)

Cloud SQL is a fully-managed managed relational database service for MySQL, PostgreSQL, and SQL Server with rich extension collections, configuration flags, and developer ecosystems.

**Average Rating:** 4.5/5.0

**Total Reviews:** 355

#### How Do G2 Users Rate Google Cloud SQL?

- **Has the product been a good partner in doing business?:** 9.0/10 (Category avg: 8.8/10)
- **Data dictionary:** 8.8/10 (Category avg: 8.5/10)
- **Backup and Recovery:** 9.1/10 (Category avg: 8.5/10)
- **Data Migration:** 9.0/10 (Category avg: 8.4/10)

#### Who Is the Company Behind Google Cloud SQL?

- **Seller:** [Google](https://www.g2.com/sellers/google)
- **Year Founded:** 1998
- **HQ Location:** Mountain View, CA
- **Twitter:** @google  
31,899,995 Twitter followers
- **LinkedIn® Page:** [www.linkedin.com](https://www.g2.com/external_clickthroughs/record?secure%5Bsource_type%5D=product_profile&secure%5Btoken%5D=fe4a5936665c9702418dd53c477fef5a7baea08078bb117ed67e966fc581b9ec&secure%5Burl%5D=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2F1441%2F&secure%5Burl_type%5D=linkedin_company_website)  
341,888 employees on LinkedIn®
- **Ownership:** NASDAQ:GOOG

#### Who Uses This Product?

- **Who Uses This:** Data Engineer, Software Engineer
- **Top Industries:** Information Technology and Services, Computer Software
- **Company Size:** 41% Medium, 34% Small

#### What Do G2 Reviewers Say About Google Cloud SQL?

_AI-generated summary from verified user reviews_

##### Pros

- Users appreciate the **automated management** of Google Cloud SQL, which saves time and enhances scalability and reliability.
- Users value the **seamless integration** of Google Cloud SQL with Google Cloud services, enhancing efficiency and scalability.
- Users love the **ease of use** of Google Cloud SQL, making database management straightforward and hassle-free.
- Users appreciate the **easy integrations** of Google Cloud SQL, enhancing efficiency and convenience for cloud-based database management.
- Users praise the **scalability** of Google Cloud SQL, enjoying its seamless integration and automation for efficient database management.

##### Cons

- Users find Google Cloud SQL to be **expensive** , especially regarding storage, traffic, and pricing for smaller projects.
- Users feel that the **cost concerns** of Google Cloud SQL can be burdensome, especially for small businesses and individuals.
- Users often face **scaling issues** with Google Cloud SQL, including slow support and cost escalation during vertical scaling.
- Users find the **complex pricing** difficult to understand, making cost forecasting and optimization challenging.
- Users find the **pricing confusion** in Google Cloud SQL challenging, desiring clearer estimates and better forecasting tools.

#### What Are Recent G2 Reviews of Google Cloud SQL?

**["Effortless Database Management with Google Cloud SQL"](https://www.g2.com/survey_responses/google-cloud-sql-review-13190312)**

**Rating:** 4.0/5.0 stars

_— Jai Y._

[Read full review](https://www.g2.com/survey_responses/google-cloud-sql-review-13190312)

**["Secure, Highly Available, and Scalable Cloud SQL for Diverse Workloads"](https://www.g2.com/survey_responses/google-cloud-sql-review-12804608)**

**Rating:** 5.0/5.0 stars

_— Akshay J._

[Read full review](https://www.g2.com/survey_responses/google-cloud-sql-review-12804608)

#### What Are G2 Users Discussing About Google Cloud SQL?

- [What is Google Cloud SQL used for?](https://www.g2.com/discussions/what-is-google-cloud-sql-used-for) - 2 comments
- [How much is Google Cloud SQL?](https://www.g2.com/discussions/how-much-is-google-cloud-sql) - 2 comments
- [What is Cloud SQL?](https://www.g2.com/discussions/what-is-cloud-sql) - 3 comments
- [How do I use Google cloud in SQL?](https://www.g2.com/discussions/how-do-i-use-google-cloud-in-sql)
- [What are the features of Cloud SQL?](https://www.g2.com/discussions/what-are-the-features-of-cloud-sql) - 1 comment, 1 upvote

## FAQs About Database Management Systems (DBMS)

Generated using AI

Last updated: June 3, 2026

### Which DBMS offers the most advanced indexing capabilities

According to verified users, advanced indexing in this category is most often described through fast query optimization, execution plan visibility, and smoother performance tuning on large structured datasets. Recent reviewers repeatedly connect strong indexing with handling high-volume transactions, improving reporting speed, and reducing bottlenecks in ETL and analytics workflows. They also mention that indexing matters most when teams need consistent performance across growing workloads and concurrent usage. In the current review set, buyers most often praise indexing alongside query analyzers, stored procedures, partitioning, and centralized administration rather than as an isolated capability, so evaluation tends to focus on overall tuning experience and operational reliability.

### Which DBMS supports the widest range of data types

According to verified users, support for different data types usually shows up in reviews as the ability to work with structured records plus formats like JSON, semi-structured data, document-style content, graph, spatial, or time-series use cases. Recent reviewers frame this less as a checklist and more as a practical question of whether a platform can unify multiple workloads without forcing teams into separate systems. They also highlight that flexible data type support matters most for integrations, analytics, and evolving application requirements. In this review set, buyers frequently mention structured data first, then call out JSON, semi-structured data, multi-model processing, and vector or relational combinations as useful differentiators for broader database needs.

### Which DBMS offers the lowest total cost of ownership

According to verified users, total cost of ownership in this category depends on more than licensing alone. Recent reviews point to infrastructure overhead, scaling efficiency, administration effort, backup and recovery management, and how many separate tools a team needs around the database. Buyers often describe lower ownership costs when a platform reduces manual tuning, simplifies deployment, automates maintenance, or consolidates analytics, storage, and governance tasks. At the same time, reviewers frequently note that premium editions, complex enterprise pricing, and resource-heavy workloads can raise costs quickly. In practice, G2 reviewers evaluate cost through the balance of performance, reliability, support burden, and operational simplicity rather than through sticker price alone.

### What are the most important features in database management systems

According to verified users, the most important features in database management systems are reliability, performance, security, scalability, and ease of administration. Recent reviews also emphasize backup and recovery, high availability, query optimization, monitoring, and support for reporting or analytics workflows. Integration is another recurring theme, especially with cloud platforms, BI tools, ETL pipelines, and application environments. Buyers repeatedly mention that the best systems make it easier to centralize data, maintain a single source of truth, and keep workloads stable as usage grows. For many teams, the most valuable feature set is the one that combines dependable day-to-day operations with enough flexibility for analytics, automation, and future expansion.

### How do teams use Database Management Systems (DBMS) for reporting

According to verified users, teams use Database Management Systems (DBMS) for reporting by centralizing structured data, running queries across large datasets, and feeding dashboards or business intelligence tools with more consistent information. Recent reviews describe reporting workflows tied closely to ETL pipelines, stored procedures, fact tables, and scheduled data transformations. Buyers also mention using database platforms to improve data accessibility, reduce duplication, and create a single source of truth for operational and strategic decisions. In many cases, reporting use includes downstream integrations with visualization tools, cloud services, and analytics environments. The strongest review themes connect reporting value to faster decision-making, smoother daily operations, and more reliable access to current business data.

### [Supabase](https://www.g2.com/products/supabase-supabase/reviews)

Supabase is an open-source backend-as-a-service (BaaS) platform that enables developers to build and scale applications efficiently without managing server infrastructure. Launched in 2020 as an alternative to Firebase, Supabase offers a suite of tools including a PostgreSQL database, authentication, real-time subscriptions, and storage capabilities. By leveraging the robustness of PostgreSQL, Supabase provides a scalable and secure foundation for modern web and mobile applications. Key Features and Functionality: - PostgreSQL Database: Each Supabase project includes a dedicated PostgreSQL database, offering full SQL support and advanced features such as JSON handling, full-text search, and vector support. - Instant APIs: Supabase automatically generates RESTful and GraphQL APIs based on your database schema, eliminating the need for manual coding and accelerating development. - Authentication and Authorization: The platform provides built-in user authentication with support for various sign-in methods, including email/password, magic links, and social logins. It also integrates seamlessly with PostgreSQL's Row Level Security for fine-grained access control. - Real-time Capabilities: Supabase enables real-time data synchronization via WebSockets, allowing applications to respond instantly to database changes. - Edge Functions: Developers can deploy serverless functions close to users for low-latency execution, facilitating scalable and efficient backend logic. - File Storage: Supabase offers scalable storage solutions for managing and serving files, complete with configurable access policies to ensure data security. Primary Value and User Solutions: Supabase addresses the challenges developers face in building and scaling applications by providing a comprehensive, open-source backend platform. It eliminates the complexities of managing server infrastructure, allowing developers to focus on creating feature-rich applications. With its real-time capabilities, robust authentication, and seamless integration with PostgreSQL, Supabase empowers developers to build secure, scalable, and responsive applications efficiently.

**Average Rating:** 4.6/5.0

**Total Reviews:** 139

#### How Do G2 Users Rate Supabase?

- **Has the product been a good partner in doing business?:** 9.2/10 (Category avg: 8.8/10)
- **Data dictionary:** 8.7/10 (Category avg: 8.5/10)
- **Backup and Recovery:** 9.0/10 (Category avg: 8.5/10)
- **Data Migration:** 9.5/10 (Category avg: 8.4/10)

#### Who Is the Company Behind Supabase?

- **Seller:** [Supabase](https://www.g2.com/sellers/supabase)
- **Year Founded:** 2020
- **HQ Location:** Global, US
- **LinkedIn® Page:** [www.linkedin.com](https://www.g2.com/external_clickthroughs/record?secure%5Bsource_type%5D=product_profile&secure%5Btoken%5D=90292f271b5b4feb535f6c4c2b32bb22ad2b1d3a612cb21ca0afc68b74ac3772&secure%5Burl%5D=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fsupabase%2F&secure%5Burl_type%5D=linkedin_company_website)  
357 employees on LinkedIn®

#### Who Uses This Product?

- **Who Uses This:** Founder, Software Engineer
- **Top Industries:** Computer Software, Information Technology and Services
- **Company Size:** 72% Small, 22% Medium

#### What Do G2 Reviewers Say About Supabase?

_AI-generated summary from verified user reviews_

##### Pros

- Users appreciate the **ease of use** of Supabase, highlighting its simple setup and user-friendly backend experience.
- Users appreciate the **powerful design and intuitive API** of Supabase, making development both easy and enjoyable.
- Users find Supabase to be **user-friendly** , appreciating its simplicity, great UI, and seamless integration with tools.
- Users find **easy integrations** with Supabase enhance their development experience and streamline project setups effortlessly.
- Users appreciate the **seamless integrations** of Supabase, making it easy to connect with various development tools smoothly.

##### Cons

- Users find Supabase has **beginner unfriendliness** , as its complexity and limited support hinder novice coders' experience.
- Users find the **pricing high** , particularly for premium services that should be accessible to all users.
- Users find the **high complexity** of Supabase challenging, particularly for novice coders seeking user-friendly tools.
- Users feel Supabase lacks **insufficient guidance** , particularly for novice coders needing better documentation and user-friendliness.
- Users find **learning difficulty** with Supabase, especially novices who struggle with complex tools and limited community support.

#### What Are Recent G2 Reviews of Supabase?

**["All-in-One Backend That Stays Out of Your Way—Auth, Postgres, Storage, and RLS"](https://www.g2.com/survey_responses/supabase-review-13192362)**

**Rating:** 5.0/5.0 stars

_— Rohit p._

[Read full review](https://www.g2.com/survey_responses/supabase-review-13192362)

**["Supabase’s All-in-One Backend Stack Speeds Up Development"](https://www.g2.com/survey_responses/supabase-review-13198712)**

**Rating:** 4.5/5.0 stars

_— Ravindra N._

[Read full review](https://www.g2.com/survey_responses/supabase-review-13198712)

### [Amazon Athena](https://www.g2.com/fr/products/amazon-athena/reviews)

Amazon Athena est un service de requêtes interactives sans serveur qui permet aux utilisateurs d'analyser de grands ensembles de données directement dans Amazon S3 en utilisant le SQL standard. Sans infrastructure à gérer, Athena permet des requêtes ad hoc rapides sans avoir besoin de processus ETL complexes. Il s'adapte automatiquement pour exécuter des requêtes en parallèle, offrant des résultats rapides même pour des requêtes complexes et de grands ensembles de données. Caractéristiques clés et fonctionnalités : - Architecture sans serveur : Athena ne nécessite aucune gestion de serveur, gérant automatiquement la mise à l'échelle et la maintenance de l'infrastructure. - Support du SQL standard : Les utilisateurs peuvent exécuter des requêtes SQL ANSI, facilitant l'analyse des données sans avoir à apprendre de nouveaux langages. - Compatibilité avec de nombreux formats de données : Prend en charge divers formats de données, y compris CSV, JSON, ORC, Avro et Parquet, permettant une flexibilité dans le stockage et l'analyse des données. - Intégration avec AWS Glue : S'intègre parfaitement avec le catalogue de données AWS Glue pour la gestion des métadonnées, permettant la découverte et la versionnage des schémas. - Sécurité et conformité : Offre des fonctionnalités de sécurité robustes, y compris le chiffrement des données au repos et en transit, et s'intègre avec AWS Identity and Access Management (IAM) pour un contrôle d'accès granulaire. Valeur principale et solutions pour les utilisateurs : Amazon Athena simplifie le processus d'analyse de grandes quantités de données stockées dans Amazon S3 en éliminant le besoin de configuration et de gestion d'infrastructure complexe. Sa nature sans serveur et son support du SQL standard le rendent accessible aux utilisateurs avec des niveaux variés d'expertise technique. En permettant des requêtes rapides et économiques de grands ensembles de données, Athena répond aux défis liés à la vitesse d'analyse des données, à l'évolutivité et à la surcharge opérationnelle, permettant aux organisations de tirer efficacement des insights.

**Average Rating:** 4.4/5.0

**Total Reviews:** 162

#### How Do G2 Users Rate Amazon Athena?

- **the product a-t-il été un bon partenaire commercial?:** 8.7/10 (Category avg: 8.8/10)
- **Dictionnaire de données:** 8.0/10 (Category avg: 8.5/10)
- **Sauvegarde et restauration:** 8.3/10 (Category avg: 8.5/10)
- **Migration des données:** 8.0/10 (Category avg: 8.4/10)

#### Who Is the Company Behind Amazon Athena?

- **Vendeur:** [Amazon Web Services (AWS)](https://www.g2.com/fr/sellers/amazon-web-services-aws-3e93cc28-2e9b-4961-b258-c6ce0feec7dd)
- **Année de fondation:** 2006
- **Emplacement du siège social:** Seattle, WA
- **Twitter:** @awscloud  
2,232,483 abonnés Twitter
- **Page LinkedIn®:** [www.linkedin.com](https://www.g2.com/fr/external_clickthroughs/record?secure%5Bsource_type%5D=product_profile&secure%5Btoken%5D=072881eee28a2afe24f8d1bda9f20e3e146b9fb4b214f216411ce2ed6898b31e&secure%5Burl%5D=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Famazon-web-services%2F&secure%5Burl_type%5D=linkedin_company_website)  
147,094 employés sur LinkedIn®
- **Propriété:** NASDAQ: AMZN

#### Who Uses This Product?

- **Who Uses This:** Ingénieur de données, Ingénieur de données senior
- **Top Industries:** Technologie de l'information et services, Logiciels informatiques
- **Company Size:** 51% Large, 27% Medium

#### What Do G2 Reviewers Say About Amazon Athena?

_AI-generated summary from verified user reviews_

##### Pros

- Les utilisateurs trouvent que **les capacités analytiques d'Amazon Athena** sont efficaces pour analyser les données stockées dans S3 de manière efficace.
- Les utilisateurs trouvent qu'Amazon Athena est une **excellente solution pour analyser les données stockées dans S3** de manière efficace et efficiente.
- Les utilisateurs trouvent Athena idéal pour **exécuter des analyses de données** sur le stockage S3 de manière efficace et efficiente.
- Les utilisateurs trouvent Amazon Athena **très facile à utiliser** , grâce à son interface conviviale et ses capacités de requête polyvalentes.
- Les utilisateurs apprécient l' **interface conviviale** d'Amazon Athena, la rendant accessible aussi bien pour les personnes techniques que non techniques.

##### Cons

- Les utilisateurs rencontrent des **limitations fonctionnelles** avec Amazon Athena, le trouvant peu utile pour interroger et mettre à jour les données.
- Les utilisateurs ont du mal avec les **capacités SQL limitées** dans Amazon Athena, ce qui entrave leur capacité à interroger et mettre à jour les données efficacement.
- Les utilisateurs éprouvent une **mauvaise convivialité** , la trouvant peu utile lors de l'interrogation des données et de la mise à jour dans Amazon Athena.

#### What Are Recent G2 Reviews of Amazon Athena?

**["Athena rend la validation des données S3 rapide et sans infrastructure"](https://www.g2.com/fr/survey_responses/amazon-athena-review-12876937)**

**Rating:** 5.0/5.0 stars

_— mani s._

[Read full review](https://www.g2.com/fr/survey_responses/amazon-athena-review-12876937)

**["Analytique simple, évolutive et rentable avec Amazon Athena"](https://www.g2.com/fr/survey_responses/amazon-athena-review-12380769)**

**Rating:** 5.0/5.0 stars

_— Pradip G._

[Read full review](https://www.g2.com/fr/survey_responses/amazon-athena-review-12380769)

#### What Are G2 Users Discussing About Amazon Athena?

- [À quoi sert Amazon Athena ?](https://www.g2.com/fr/discussions/what-is-amazon-athena-used-for)
- [AWS Athena est-il gratuit ?](https://www.g2.com/fr/discussions/is-aws-athena-free) - 1 comment
- [Comment utiliser AWS Athena ?](https://www.g2.com/fr/discussions/how-do-i-use-aws-athena) - 1 comment
- [What is AWS Athena based on?](https://www.g2.com/fr/discussions/what-is-aws-athena-based-on)
- [What is the use of Amazon Athena?](https://www.g2.com/fr/discussions/what-is-the-use-of-amazon-athena)

### [SAS Viya](https://www.g2.com/fr/products/sas-sas-viya/reviews)

SAS Viya est une plateforme de données et d'IA native du cloud qui permet aux équipes de créer, déployer et faire évoluer une IA explicable qui conduit à des décisions fiables et sûres. Elle unit l'ensemble du cycle de vie des données et de l'IA et permet aux équipes d'innover rapidement tout en équilibrant vitesse, automatisation et gouvernance par conception. Viya unifie la gestion des données, l'analyse avancée et la prise de décision sur une seule plateforme, permettant ainsi aux organisations de passer de l'expérimentation à la production en toute confiance, en offrant un impact commercial mesurable qui est sécurisé, explicable et évolutif dans n'importe quel environnement. Les capacités clés requises pour prendre des décisions fiables incluent : • Clarté de bout en bout sur le cycle de vie des données et de l'IA, avec une traçabilité intégrée, une auditabilité et une surveillance continue pour soutenir des décisions défendables. • Gouvernance par conception, permettant une supervision cohérente des données, des modèles et des décisions pour réduire les risques et accélérer l'adoption. • IA explicable à grande échelle, afin que les insights et les résultats puissent être compris, validés et dignes de confiance par les entreprises et les régulateurs. • Analytique opérationnalisée, garantissant que la valeur se poursuit au-delà du déploiement grâce à la surveillance, au réentraînement et à la gestion du cycle de vie. • Déploiement flexible et natif du cloud, permettant aux organisations de commencer n'importe où et de s'étendre partout tout en maintenant le contrôle.

**Average Rating:** 4.3/5.0

**Total Reviews:** 774

#### How Do G2 Users Rate SAS Viya?

- **the product a-t-il été un bon partenaire commercial?:** 8.2/10 (Category avg: 8.8/10)
- **Dictionnaire de données:** 8.8/10 (Category avg: 8.5/10)
- **Sauvegarde et restauration:** 8.9/10 (Category avg: 8.5/10)
- **Migration des données:** 8.6/10 (Category avg: 8.4/10)

#### Who Is the Company Behind SAS Viya?

- **Vendeur:** [SAS Institute Inc.](https://www.g2.com/fr/sellers/sas-institute-inc-df6dde22-a5e5-4913-8b21-4fa0c6c5c7c2)
- **Site Web de l'entreprise:** www.sas.com
- **Année de fondation:** 1976
- **Emplacement du siège social:** Cary, NC
- **Twitter:** @SASsoftware  
60,863 abonnés Twitter
- **Page LinkedIn®:** [www.linkedin.com](https://www.g2.com/fr/external_clickthroughs/record?secure%5Bsource_type%5D=product_profile&secure%5Btoken%5D=64db42c044af5bbad79bd9677a620a6c31a8ff1abf4e7b2a6f1d6ed9561d105d&secure%5Burl%5D=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2F1491%2F&secure%5Burl_type%5D=linkedin_company_website)  
18,638 employés sur LinkedIn®

#### Who Uses This Product?

- **Who Uses This:** Étudiant, Biostatisticien
- **Top Industries:** Pharmaceutique, Banque
- **Company Size:** 33% Large, 33% Small

#### What Do G2 Reviewers Say About SAS Viya?

_AI-generated summary from verified user reviews_

##### Pros

- Les utilisateurs apprécient la **facilité d'utilisation** de SAS Viya, qui simplifie la visualisation des données et améliore l'efficacité de la prise de décision.
- Les utilisateurs apprécient les **capacités analytiques sophistiquées** de SAS Viya, permettant un déploiement facile et une prise de décision en temps réel.
- Les utilisateurs apprécient les **méthodes analytiques avancées** offertes par SAS Viya, améliorant les capacités de prise de décision et d'analyse des données logistiques.
- Les utilisateurs apprécient l' **outillage du cycle de vie des données de bout en bout** de SAS Viya, améliorant la compréhension des affaires et la prise de décision stratégique.
- Les utilisateurs adorent l' **interface intuitive** de SAS Viya, rendant l'analyse de données et le déploiement de modèles sans effort pour tous les niveaux de compétence.

##### Cons

- Les utilisateurs trouvent que SAS Viya présente une **difficulté d'apprentissage** , ce qui le rend difficile à naviguer efficacement pour les personnes non techniques.
- Les utilisateurs trouvent que la **courbe d'apprentissage est abrupte** , ce qui rend difficile pour les utilisateurs non techniques de naviguer efficacement dans SAS Viya.
- Les utilisateurs trouvent la **complexité de la visualisation** dans SAS Viya difficile, en particulier pour les utilisateurs non techniques et les débutants.
- Les utilisateurs ont du mal avec la **courbe d'apprentissage difficile** de SAS Viya, en particulier pour les nouveaux utilisateurs et ceux qui ne sont pas techniques.
- Les utilisateurs trouvent que le **prix élevé** de SAS Viya constitue un obstacle important à l'adoption potentielle.

#### What Are Recent G2 Reviews of SAS Viya?

**["Analyse de données efficace avec SAS Viya"](https://www.g2.com/fr/survey_responses/sas-viya-review-11872818)**

**Rating:** 4.5/5.0 stars

_— Fungai J._

[Read full review](https://www.g2.com/fr/survey_responses/sas-viya-review-11872818)

**["SAS Viya : Intelligence Artificielle Puissante et Analyse de Données avec Intégrations Transparentes"](https://www.g2.com/fr/survey_responses/sas-viya-review-11855145)**

**Rating:** 5.0/5.0 stars

_— Utilisateur vérifié à Soins hospitaliers et de santé_

[Read full review](https://www.g2.com/fr/survey_responses/sas-viya-review-11855145)

#### What Are G2 Users Discussing About SAS Viya?

- [À quoi sert SAS Visual Data Mining and Machine Learning ?](https://www.g2.com/fr/discussions/what-is-sas-visual-data-mining-and-machine-learning-used-for) - 2 comments

### [SQL Developer](https://www.g2.com/fr/products/sql-developer/reviews)

Oracle SQL Developer est un environnement de développement intégré (IDE) gratuit, conçu pour simplifier le développement et la gestion des bases de données Oracle, tant pour les déploiements traditionnels que dans le cloud. Il offre une suite complète d'outils pour le développement d'applications PL/SQL, l'administration de bases de données, la modélisation de données et la migration de bases de données tierces vers Oracle. Avec plus de 5 millions d'utilisateurs, SQL Developer améliore la productivité en proposant une interface conviviale pour des tâches allant de l'exécution de requêtes et de scripts au débogage et au test de code PL/SQL. Caractéristiques clés et fonctionnalités : - IDE PL/SQL : Un environnement complet pour écrire, compiler, déboguer et tester des applications PL/SQL. - Administration de bases de données : Outils pour gérer la performance, la sécurité, le stockage et les configurations des bases de données. - Modélisation de données : Capacités pour créer des diagrammes de relations d'entités (ERD), générer des rapports et effectuer des scripts SQL et DDL. - Plateforme de migration : Facilite la migration de bases de données depuis des plateformes comme Microsoft SQL Server, Sybase Adaptive Server, IBM DB2, MySQL, Microsoft Access et Teradata vers Oracle. - Interfaces multiples : Offre des interfaces de bureau, basées sur le navigateur (Database Actions) et en ligne de commande (SQLcl) pour répondre aux préférences variées des utilisateurs. Valeur principale et solutions pour les utilisateurs : Oracle SQL Developer répond aux complexités associées au développement et à la gestion des bases de données en fournissant un ensemble d'outils complet qui rationalise les flux de travail. Il élimine le besoin de multiples outils disparates en intégrant des fonctionnalités essentielles dans une seule plateforme, réduisant ainsi le temps de développement et les coûts opérationnels. Son support pour diverses interfaces assure une flexibilité, permettant aux utilisateurs de choisir l'environnement qui correspond le mieux à leurs besoins. De plus, les capacités de migration simplifient la transition d'autres systèmes de bases de données vers Oracle, facilitant un processus d'intégration plus fluide.

**Average Rating:** 4.3/5.0

**Total Reviews:** 246

#### How Do G2 Users Rate SQL Developer?

- **the product a-t-il été un bon partenaire commercial?:** 8.8/10 (Category avg: 8.8/10)
- **Dictionnaire de données:** 9.0/10 (Category avg: 8.5/10)
- **Sauvegarde et restauration:** 8.4/10 (Category avg: 8.5/10)
- **Migration des données:** 8.7/10 (Category avg: 8.4/10)

#### Who Is the Company Behind SQL Developer?

- **Vendeur:** [Oracle](https://www.g2.com/fr/sellers/oracle)
- **Année de fondation:** 1977
- **Emplacement du siège social:** Austin, TX
- **Twitter:** @Oracle  
827,997 abonnés Twitter
- **Page LinkedIn®:** [www.linkedin.com](https://www.g2.com/fr/external_clickthroughs/record?secure%5Bsource_type%5D=product_profile&secure%5Btoken%5D=a14fcbcd818b49d781453c19628a9479a70cc1e8e335e54c876392ab5f543da3&secure%5Burl%5D=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2F1028%2F&secure%5Burl_type%5D=linkedin_company_website)  
208,078 employés sur LinkedIn®
- **Propriété:** NYSE:ORCL

#### Who Uses This Product?

- **Who Uses This:** Ingénieur logiciel, Développeur de logiciels
- **Top Industries:** Technologie de l'information et services, Logiciels informatiques
- **Company Size:** 47% Large, 39% Medium

#### What Do G2 Reviewers Say About SQL Developer?

_AI-generated summary from verified user reviews_

##### Pros

- Les utilisateurs apprécient **l'efficacité dans la gestion des tâches de base de données** avec SQL Developer, rationalisant leur flux de travail et réduisant les erreurs.
- Les utilisateurs trouvent SQL Developer **intuitif et facile à naviguer** , rendant les tâches complexes de base de données simples et gérables.
- Les utilisateurs apprécient les **capacités analytiques** de SQL Developer pour fournir des informations claires et détecter la fraude dans l'analyse des données.
- Les utilisateurs trouvent facile de gérer **l'analyse de grandes données** dans SQL Developer, permettant une détection efficace des risques et des fraudes.
- Les utilisateurs apprécient la **documentation complète** dans SQL Developer, qui aide à comprendre et à résoudre les problèmes efficacement.

##### Cons

- Les utilisateurs éprouvent une **performance lente** avec de grandes requêtes ou bases de données, ce qui entraîne des interactions lentes et une charge système lourde.
- Les utilisateurs rencontrent des **problèmes de connexion** importants qui entraînent des temps d'attente prolongés malgré une exécution efficace des requêtes.
- Les utilisateurs trouvent que la **courbe d'apprentissage difficile** de SQL Developer affecte leur capacité à déboguer et tester efficacement des requêtes complexes.
- Les utilisateurs trouvent des **limitations fonctionnelles** dans SQL Developer, luttant avec des requêtes complexes et un support inadéquat pour les fonctionnalités avancées.
- Les utilisateurs trouvent que SQL Developer peut être **lent avec de grandes bases de données** , ce qui peut affecter les performances et l'expérience utilisateur.

#### What Are Recent G2 Reviews of SQL Developer?

**["Oracle SQL Developer : Un outil incontournable pour le travail direct sur les bases de données"](https://www.g2.com/fr/survey_responses/sql-developer-review-13077102)**

**Rating:** 4.5/5.0 stars

_— Utilisateur vérifié à Technologie de l'information et services_

[Read full review](https://www.g2.com/fr/survey_responses/sql-developer-review-13077102)

**["Le développeur SQL simplifie les grandes requêtes de schéma"](https://www.g2.com/fr/survey_responses/sql-developer-review-12738695)**

**Rating:** 4.0/5.0 stars

_— Utilisateur vérifié à Gestion d'organisations à but non lucratif_

[Read full review](https://www.g2.com/fr/survey_responses/sql-developer-review-12738695)

#### What Are G2 Users Discussing About SQL Developer?

- [À quoi sert SQL Developer ?](https://www.g2.com/fr/discussions/what-is-sql-developer-used-for) - 1 comment
- [What should a SQL developer know?](https://www.g2.com/fr/discussions/what-should-a-sql-developer-know)
- [What are the advanced features of SQL?](https://www.g2.com/fr/discussions/what-are-the-advanced-features-of-sql)
- [Is SQL Developer free?](https://www.g2.com/fr/discussions/is-sql-developer-free)
- [À quoi sert SQL Developer ?](https://www.g2.com/fr/discussions/what-is-the-use-of-sql-developer) - 1 comment

### [TiDB](https://www.g2.com/fr/products/tidb/reviews)

TiDB est une solution de base de données SQL distribuée et open-source avancée conçue pour aider les entreprises intensives en données à gérer et à faire évoluer leurs opérations de données de manière transparente. Développé par PingCAP, TiDB combine l'évolutivité des bases de données NoSQL avec la fonctionnalité complète des systèmes de gestion de bases de données relationnelles traditionnels (SGBDR). Cette architecture unique permet aux organisations de construire des clusters à l'échelle du pétaoctet tout en gérant efficacement des millions de tables, de nombreuses connexions simultanées et des changements fréquents de schéma sans subir de temps d'arrêt. Le public cible de TiDB comprend les grandes entreprises, les fournisseurs de logiciels en tant que service (SaaS) et les entreprises natives numériques qui nécessitent des capacités de gestion de données robustes. Ces organisations sont souvent confrontées à des défis liés à l'évolutivité des données, à la complexité opérationnelle et au besoin de haute disponibilité. TiDB répond à ces défis en offrant une solution qui prend en charge une large gamme de charges de travail, y compris les tâches transactionnelles, analytiques, opérationnelles et d'intelligence artificielle (IA). Son architecture multi-locataire améliore encore l'agilité opérationnelle, permettant aux entreprises de s'adapter rapidement aux demandes changeantes. Les caractéristiques clés de TiDB incluent une évolutivité transparente, qui permet aux organisations d'étendre leur infrastructure de base de données sans effort à mesure que leurs besoins en données augmentent. La compatibilité MySQL de la plateforme garantit que les développeurs peuvent facilement intégrer TiDB dans les flux de travail existants et tirer parti d'outils et de plateformes familiers. De plus, TiDB prend en charge les opérations DDL (Data Definition Language) en ligne, permettant des changements de schéma sans souci qui ne perturbent pas les processus en cours. Cette flexibilité opérationnelle est essentielle pour les entreprises qui nécessitent une disponibilité et une fiabilité constantes. TiDB priorise également la sécurité et la disponibilité des données, avec une conformité ACID (Atomicité, Cohérence, Isolation, Durabilité) intégrée et un taux de disponibilité remarquable de 99,99%. La base de données adhère à diverses normes réglementaires, y compris le RGPD, SOC, HIPAA et PCI, garantissant que les organisations peuvent faire confiance à leurs pratiques de gestion des données. Des entreprises notables telles que Databricks, Pinterest et Plaid ont adopté TiDB, leur permettant de se concentrer sur la croissance et l'innovation plutôt que sur les complexités de la gestion de l'infrastructure de données. Avec ses innovations pilotées par l'IA et ses capacités multi-cloud, TiDB se distingue comme une solution puissante pour les entreprises cherchant à améliorer leurs stratégies de gestion des données. En offrant une agilité, une résilience et une sécurité inégalées, TiDB permet aux organisations de libérer tout leur potentiel dans un monde de plus en plus axé sur les données. Pour plus d'informations, veuillez visiter TiDB.io.

**Average Rating:** 4.6/5.0

**Total Reviews:** 67

#### How Do G2 Users Rate TiDB?

- **the product a-t-il été un bon partenaire commercial?:** 9.2/10 (Category avg: 8.8/10)
- **Dictionnaire de données:** 8.5/10 (Category avg: 8.5/10)
- **Sauvegarde et restauration:** 9.0/10 (Category avg: 8.5/10)
- **Migration des données:** 9.1/10 (Category avg: 8.4/10)

#### Who Is the Company Behind TiDB?

- **Vendeur:** [PingCAP](https://www.g2.com/fr/sellers/pingcap)
- **Site Web de l'entreprise:** tidb.io
- **Année de fondation:** 2015
- **Emplacement du siège social:** Sunnyvale 
- **Twitter:** @PingCAP  
7,268 abonnés Twitter
- **Page LinkedIn®:** [www.linkedin.com](https://www.g2.com/fr/external_clickthroughs/record?secure%5Bsource_type%5D=product_profile&secure%5Btoken%5D=97feeff0f3bb4906e69c91330a88caf7e60daa531a2894ebf5640640b4467879&secure%5Burl%5D=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fpingcap&secure%5Burl_type%5D=linkedin_company_website)  
501 employés sur LinkedIn®

#### Who Uses This Product?

- **Who Uses This:** DBA, Ingénieur Logiciel Senior
- **Top Industries:** Logiciels informatiques, Technologie de l'information et services
- **Company Size:** 31% Large, 27% Small

#### What Do G2 Reviewers Say About TiDB?

_AI-generated summary from verified user reviews_

##### Pros

- Les utilisateurs louent la **scalabilité transparente** de TiDB, permettant une gestion efficace des données et une croissance sans intervention manuelle.
- Les utilisateurs apprécient la **facilité d'utilisation** de TiDB, profitant d'une intégration transparente et d'un déploiement simple sur diverses plateformes.
- Les utilisateurs apprécient la **scalabilité horizontale et la forte cohérence** de TiDB, améliorant leur expérience de gestion de base de données.
- Les utilisateurs apprécient la **compatibilité MySQL** de TiDB, facilitant une adoption fluide et une mise à l'échelle sans heurts à mesure que les données augmentent.
- Les utilisateurs louent TiDB pour ses **performances exceptionnelles** , gérant efficacement de grandes quantités de données et supportant sans faille l'analyse en temps réel.

##### Cons

- Les utilisateurs trouvent la **courbe d'apprentissage abrupte** de TiDB particulièrement difficile lorsqu'ils s'adaptent à son architecture distribuée et à l'optimisation des performances.
- Les utilisateurs signalent des **problèmes de performance** avec TiDB, en particulier dans TiFlash et les exigences globales en ressources, affectant leur expérience de développement.
- Les utilisateurs rencontrent une **performance lente** avec TiDB, surtout dans les environnements plus petits, ce qui impacte l'efficacité globale et l'utilisation des ressources.
- Les utilisateurs rencontrent une **difficile avec l'architecture distribuée de TiDB, notamment en ce qui concerne l'optimisation des performances et la compatibilité.**
- Les utilisateurs trouvent que la **documentation médiocre** de TiDB complique la compréhension des configurations complexes et l'optimisation des fonctionnalités, en particulier pour les débutants.

#### What Are Recent G2 Reviews of TiDB?

**["TiDB offre l'échelle NoSQL avec la simplicité SQL et la compatibilité MySQL"](https://www.g2.com/fr/survey_responses/tidb-review-12342698)**

**Rating:** 5.0/5.0 stars

_— yugesh K._

[Read full review](https://www.g2.com/fr/survey_responses/tidb-review-12342698)

**["Intégration transparente, fiable et évolutive"](https://www.g2.com/fr/survey_responses/tidb-review-12354194)**

**Rating:** 4.5/5.0 stars

_— Abhishek ._

[Read full review](https://www.g2.com/fr/survey_responses/tidb-review-12354194)

### [Teradata Autonomous Knowledge Platform](https://www.g2.com/products/teradata-autonomous-knowledge-platform/reviews)

Teradata Autonomous Knowledge Platform activates enterprise intelligence by unifying data, knowledge and business context to achieve tangible outcomes. With Teradata, organizations can provide agents with full context for impact when it matters. Our solution lets businesses connect and scale on premises, in the cloud, or through a hybrid approach. Teradata delivers real business value with AI. Learn more at Teradata.com.

**Average Rating:** 4.3/5.0

**Total Reviews:** 356

#### How Do G2 Users Rate Teradata Autonomous Knowledge Platform?

- **Has the product been a good partner in doing business?:** 8.2/10 (Category avg: 8.8/10)
- **Data dictionary:** 7.9/10 (Category avg: 8.5/10)
- **Backup and Recovery:** 7.9/10 (Category avg: 8.5/10)
- **Data Migration:** 8.6/10 (Category avg: 8.4/10)

#### Who Is the Company Behind Teradata Autonomous Knowledge Platform?

- **Seller:** [Teradata Autonomous Knowledge Platform](https://www.g2.com/sellers/teradata-autonomous-knowledge-platform)
- **Year Founded:** 1979
- **HQ Location:** San Diego, CA
- **Twitter:** @Teradata  
93,113 Twitter followers
- **LinkedIn® Page:** [www.linkedin.com](https://www.g2.com/external_clickthroughs/record?secure%5Bsource_type%5D=product_profile&secure%5Btoken%5D=06895b9a8db4fa478ba7da480ccd214a14ef698abd028e4642e62f189e82b650&secure%5Burl%5D=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2F1466%2F&secure%5Burl_type%5D=linkedin_company_website)  
9,901 employees on LinkedIn®
- **Ownership:** NYSE:TDC

#### Who Uses This Product?

- **Who Uses This:** Data Engineer, Software Engineer
- **Top Industries:** Information Technology and Services, Financial Services
- **Company Size:** 69% Large, 22% Medium

#### What Do G2 Reviewers Say About Teradata Autonomous Knowledge Platform?

_AI-generated summary from verified user reviews_

##### Pros

- Users highlight the **extreme performance** of the Teradata Autonomous Knowledge Platform, especially for processing large data volumes efficiently.
- Users value the **high performance query execution** in Teradata, enhancing their business analytics capabilities significantly.
- Users value the **scalability** of Teradata Autonomous Knowledge Platform, enhancing data integration and operational efficiency significantly.
- Users commend the **high performance and speed** of Teradata, efficiently processing large datasets without issues.
- Users value the **fast processing of large datasets** with Teradata, praising its performance and stability during operations.

##### Cons

- Users find the **steep learning curve** of Teradata Autonomous Knowledge Platform challenging, impacting adoption and productivity temporarily.
- Users find the **steep learning curve** of Teradata Autonomous Knowledge Platform challenging, particularly for those lacking technical expertise.
- Users find the **complexity** of Teradata's platform challenging, particularly for non-technical users and new adopters.
- Users express concerns over the **cost management requirements** needed to avoid potential misusage and performance issues.
- Users feel the **high cost** of Teradata Autonomous Knowledge Platform is a significant drawback affecting accessibility.

#### What Are Recent G2 Reviews of Teradata Autonomous Knowledge Platform?

**["Teradata Vantage Fast Query Performance and Strong Analytics for Big Data"](https://www.g2.com/survey_responses/teradata-autonomous-knowledge-platform-review-12821668)**

**Rating:** 5.0/5.0 stars

_— Muzammil M._

[Read full review](https://www.g2.com/survey_responses/teradata-autonomous-knowledge-platform-review-12821668)

**["Teradata Vantage Excels at Big Data Processing and Advanced Analytics"](https://www.g2.com/survey_responses/teradata-autonomous-knowledge-platform-review-12739181)**

**Rating:** 4.5/5.0 stars

_— Nijat I._

[Read full review](https://www.g2.com/survey_responses/teradata-autonomous-knowledge-platform-review-12739181)

#### What Are G2 Users Discussing About Teradata Autonomous Knowledge Platform?

- [What does Teradata Data Lab do?](https://www.g2.com/discussions/what-does-teradata-data-lab-do)
- [Is Teradata a premiership?](https://www.g2.com/discussions/is-teradata-a-premiership)
- [What is Teradata Vantage?](https://www.g2.com/discussions/what-is-teradata-vantage)
- [How much does Teradata cost?](https://www.g2.com/discussions/how-much-does-teradata-cost)
- [What is Sandbox in Teradata?](https://www.g2.com/discussions/what-is-sandbox-in-teradata)

### [DbVisualizer](https://www.g2.com/fr/products/dbvisualizer/reviews)

DbVisualizer est un client de base de données universel et un outil SQL pour tous ceux qui travaillent avec des données, y compris les développeurs, les analystes, les administrateurs de bases de données et les ingénieurs de données. Des développeurs indépendants et startups aux équipes professionnelles gérant des environnements complexes et multi-bases de données, DbVisualizer s'adapte à votre façon de travailler. Il offre une interface graphique et un éditeur SQL puissant pour les bases de données relationnelles et NoSQL. Posez des questions, expliquez les erreurs et analysez le code avec l'assistant IA intégré, et utilisez l'intégration Git intégrée pour gérer les scripts SQL et collaborer avec votre équipe. Connectez-vous à plusieurs bases de données, parcourez les structures, gérez des objets comme les tables et les index, et analysez les données grâce à l'exécution de requêtes et à la visualisation des résultats, le tout depuis un espace de travail unique et cohérent. Que vous écriviez votre première requête ou optimisiez des SQL complexes sur des dizaines de connexions, DbVisualizer prend en charge toute la gamme des tâches de développement et d'administration de bases de données : écrire et optimiser des requêtes, inspecter des schémas, éditer des données de table et résoudre des problèmes. Il se connecte à de nombreuses bases de données largement utilisées et fonctionne sous Windows, macOS et Linux. Avec près de 7 millions de téléchargements et des utilisateurs Pro dans plus de 150 pays, DbVisualizer est utilisé par des particuliers, des startups et de grandes organisations dans le monde entier comme leur client de base de données quotidien. Connectivité multi-bases de données Connectez-vous à MySQL, PostgreSQL, SQL Server, Oracle, Snowflake, SQLite, Cassandra, BigQuery et plus de 35 des bases de données les plus populaires. Il se connecte également à pratiquement n'importe quelle base de données compatible JDBC via le gestionnaire de pilotes JDBC intégré. Outils de développement SQL Écrivez, éditez, formatez et exécutez des requêtes avec un éditeur SQL avancé doté de l'auto-complétion, de l'historique des requêtes, de la construction visuelle de requêtes et de la gestion des ensembles de résultats. Exploration et gestion de bases de données Visualisez les schémas, parcourez les tables et les vues, inspectez les index et les contraintes, et éditez les données de table via une interface graphique intuitive. Flux de travail SQL assistés par IA Un assistant IA intégré aide à générer des requêtes, expliquer des objets de base de données, interpréter des résultats et résoudre des erreurs SQL, rendant les bases de données plus accessibles pour les nouveaux venus et plus productives pour les experts. Intégration du contrôle de version Git Le support Git intégré vous permet de gérer les scripts SQL avec le clonage de référentiels, la création de branches, le suivi des modifications et les flux de travail de collaboration directement dans l'application. Support multiplateforme DbVisualizer fonctionne sous Windows, macOS et Linux et prend en charge les bases de données basées sur le cloud et sur site. DbVisualizer est disponible en éditions Free et Pro. L'édition Pro utilise un modèle de licence perpétuelle, permettant aux utilisateurs de conserver l'accès aux versions publiées pendant la période de licence, avec des renouvellements optionnels pour des mises à jour continues et de nouvelles versions.

**Average Rating:** 4.7/5.0

**Total Reviews:** 263

#### How Do G2 Users Rate DbVisualizer?

- **the product a-t-il été un bon partenaire commercial?:** 9.4/10 (Category avg: 8.8/10)
- **Dictionnaire de données:** 8.6/10 (Category avg: 8.5/10)
- **Sauvegarde et restauration:** 7.7/10 (Category avg: 8.5/10)
- **Migration des données:** 8.0/10 (Category avg: 8.4/10)

#### Who Is the Company Behind DbVisualizer?

- **Vendeur:** [DbVis Software AB](https://www.g2.com/fr/sellers/dbvis-software-ab)
- **Site Web de l'entreprise:** www.dbvis.com
- **Année de fondation:** 2003
- **Emplacement du siège social:** Stockholm
- **Twitter:** @dbvisualizer  
343 abonnés Twitter
- **Page LinkedIn®:** [www.linkedin.com](https://www.g2.com/fr/external_clickthroughs/record?secure%5Bsource_type%5D=product_profile&secure%5Btoken%5D=0e6f15fbcd3e10111d12e1baa4f8568aca92c651eb33d4078a2f0be4b4954850&secure%5Burl%5D=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2F2337346%2F&secure%5Burl_type%5D=linkedin_company_website)  
23 employés sur LinkedIn®

#### Who Uses This Product?

- **Top Industries:** Technologie de l'information et services, Logiciels informatiques
- **Company Size:** 45% Small, 29% Large

#### What Do G2 Reviewers Say About DbVisualizer?

_AI-generated summary from verified user reviews_

##### Pros

- Les utilisateurs apprécient la **facilité d'utilisation** de DbVisualizer, soulignant des configurations simples et des fonctionnalités conviviales pour gérer les bases de données.
- Les utilisateurs louent la **facilité d'utilisation et la performance stable** de DbVisualizer, rendant la gestion de base de données simple et efficace.
- Les utilisateurs adorent les **outils puissants** et la **configuration facile** de DbVisualizer, améliorant considérablement leurs interactions quotidiennes avec la base de données.
- Les utilisateurs trouvent les **fonctionnalités d'exportation de données robustes** de DbVisualizer inestimables pour une gestion et une intégration efficaces des bases de données.
- Les utilisateurs apprécient les **capacités complètes de gestion des données** de DbVisualizer, améliorant leur productivité et l'efficacité de leur flux de travail.

##### Cons

- Les utilisateurs rencontrent une **performance lente** avec DbVisualizer, surtout avec de grandes requêtes et sur des systèmes moins puissants.
- Les utilisateurs trouvent les **problèmes d'autocomplétion** frustrants, car ils entravent la productivité et manquent de support essentiel pour les procédures stockées.
- Les utilisateurs trouvent la **version de la licence trop chère** , surtout les étudiants qui ont besoin d'un meilleur accès sans limitations.
- Les utilisateurs rencontrent **une gestion des erreurs inadéquate** , notant un manque d'outils d'autocomplétion et de support de requêtes utiles pour le dépannage.
- Les utilisateurs trouvent que les **limitations fonctionnelles** de DbVisualizer entravent la lisibilité et la facilité d'utilisation, surtout pour les grandes requêtes.

#### What Are Recent G2 Reviews of DbVisualizer?

**["Puissance professionnelle abordable : DbVisualizer parfait pour les consultants en petites entreprises"](https://www.g2.com/fr/survey_responses/dbvisualizer-review-12760287)**

**Rating:** 5.0/5.0 stars

_— Agnieszka S._

[Read full review](https://www.g2.com/fr/survey_responses/dbvisualizer-review-12760287)

**["Un outil complet et intuitif"](https://www.g2.com/fr/survey_responses/dbvisualizer-review-4394572)**

**Rating:** 4.5/5.0 stars

_— Yves V._

[Read full review](https://www.g2.com/fr/survey_responses/dbvisualizer-review-4394572)

#### What Are G2 Users Discussing About DbVisualizer?

- [À quoi sert DbVisualizer ?](https://www.g2.com/fr/discussions/dbvisualizer-what-is-dbvisualizer-used-for)
- [How does DbVisualizer connect to database?](https://www.g2.com/fr/discussions/how-does-dbvisualizer-connect-to-database) - 1 comment
- [How do I use DbVisualizer explain plan?](https://www.g2.com/fr/discussions/how-do-i-use-dbvisualizer-explain-plan)
- [DbVisualizer est-il open source ?](https://www.g2.com/fr/discussions/is-dbvisualizer-open-source) - 1 comment
- [À quoi sert DbVisualizer ?](https://www.g2.com/fr/discussions/what-is-dbvisualizer-used-for) - 2 comments

### [Azure Data Studio](https://www.g2.com/products/azure-data-studio/reviews)

Azure Data Studio is a lightweight, cross-platform data management and development tool designed for data professionals. It offers a modern editor experience with features like IntelliSense, code snippets, source control integration, and an integrated terminal, facilitating efficient database management and development. Supporting Windows, macOS, and Linux, Azure Data Studio allows connections to various databases, including Azure SQL, SQL Server, MySQL, PostgreSQL, and Cosmos DB. Its extensibility enables users to customize their experience by installing relevant extensions tailored to their workflow. Key Features and Functionality: - Modern SQL Code Editor: Provides a keyboard-focused SQL coding experience with multiple tab windows, IntelliSense, keyword completion, code snippets, code navigation, and Git integration. - Smart SQL Code Snippets: Generates proper SQL syntax for creating databases, tables, views, stored procedures, users, logins, and roles, streamlining development tasks. - Customizable Dashboards: Allows creation of rich, customizable dashboards to monitor and troubleshoot database performance bottlenecks effectively. - Integrated Terminal: Supports command-line tools like Bash, PowerShell, sqlcmd, BCP, and ssh within the user interface, enhancing workflow efficiency. - Extensibility: Offers a range of extensions to enhance functionality, including support for various databases and tools, enabling users to tailor the environment to their specific needs. Primary Value and User Solutions: Azure Data Studio addresses the need for a versatile, cross-platform database management tool that caters to the diverse environments in which data professionals operate. By integrating advanced coding features, customizable dashboards, and support for multiple databases, it streamlines database development and management tasks. Its extensibility ensures that users can adapt the tool to their specific workflows, enhancing productivity and efficiency in handling data-related tasks.

**Average Rating:** 4.5/5.0

**Total Reviews:** 35

#### How Do G2 Users Rate Azure Data Studio?

- **Has the product been a good partner in doing business?:** 9.6/10 (Category avg: 8.8/10)
- **Data dictionary:** 8.8/10 (Category avg: 8.5/10)
- **Backup and Recovery:** 8.9/10 (Category avg: 8.5/10)
- **Data Migration:** 9.2/10 (Category avg: 8.4/10)

#### Who Is the Company Behind Azure Data Studio?

- **Seller:** [Microsoft](https://www.g2.com/sellers/microsoft)
- **Year Founded:** 1975
- **HQ Location:** Redmond, Washington
- **Twitter:** @microsoft  
13,091,739 Twitter followers
- **LinkedIn® Page:** [www.linkedin.com](https://www.g2.com/external_clickthroughs/record?secure%5Bsource_type%5D=product_profile&secure%5Btoken%5D=9458f51bd6ded48ad432a804f19ad736469f007787569b63827154231c315630&secure%5Burl%5D=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fmicrosoft%2F&secure%5Burl_type%5D=linkedin_company_website)  
231,632 employees on LinkedIn®
- **Ownership:** MSFT

#### Who Uses This Product?

- **Top Industries:** Information Technology and Services, Computer Software
- **Company Size:** 43% Large, 40% Small

#### What Do G2 Reviewers Say About Azure Data Studio?

_AI-generated summary from verified user reviews_

##### Pros

- Users praise the **ease of use** of Azure Data Studio, facilitating quick application of analytics skills learned in class.
- Users praise the **ease of use** of Azure Data Studio, enabling quick application of data analytics skills.

##### Cons

- Users are frustrated with Azure Data Studio's **inability to remember credentials** , leading to inconveniences during usage.

#### What Are Recent G2 Reviews of Azure Data Studio?

**["Azure Data Studio: Seamless Azure SQL Integration and a Productivity Boost"](https://www.g2.com/survey_responses/azure-data-studio-review-12730430)**

**Rating:** 4.5/5.0 stars

_— Faouzi I._

[Read full review](https://www.g2.com/survey_responses/azure-data-studio-review-12730430)

**["Good for beginners"](https://www.g2.com/survey_responses/azure-data-studio-review-10941393)**

**Rating:** 5.0/5.0 stars

_— Verified User in Furniture_

[Read full review](https://www.g2.com/survey_responses/azure-data-studio-review-10941393)

### [Mysql workbench](https://www.g2.com/products/oracle-mysql-workbench/reviews)

MySQL Workbench is a comprehensive visual tool designed for database architects, developers, and database administrators (DBAs) to facilitate the design, development, and management of MySQL databases. It integrates data modeling, SQL development, and administrative tasks into a unified environment, streamlining workflows and enhancing productivity. Available on Windows, Linux, and macOS, MySQL Workbench offers a user-friendly interface that simplifies complex database operations. Key Features and Functionality: - Visual Database Design: Enables users to create, model, generate, and manage databases visually. It supports the creation of complex Entity-Relationship (ER) models, forward and reverse engineering, and provides tools for change management and documentation. - SQL Development: Offers a robust SQL Editor with features like syntax highlighting, auto-completion, SQL code generation, and execution history, facilitating efficient query development and optimization. - Database Administration: Provides a visual console for server configuration, user administration, backup and recovery, and performance monitoring, allowing DBAs to manage MySQL environments effectively. - Performance Tuning: Includes a Performance Dashboard and reports that help identify and address performance bottlenecks, offering insights into server performance, I/O hotspots, and expensive SQL statements. - Database Migration: Supports migration from various database systems such as Microsoft SQL Server, Microsoft Access, Sybase ASE, and PostgreSQL to MySQL, simplifying the transition process. Primary Value and Problem Solving: MySQL Workbench addresses the challenges associated with database design, development, and administration by providing an integrated, visual environment that simplifies complex tasks. For database architects and developers, it streamlines the creation and management of database schemas, reducing the likelihood of errors and improving efficiency. For DBAs, it offers comprehensive tools for server management, performance tuning, and user administration, enhancing the overall health and performance of MySQL databases. By consolidating multiple functionalities into a single platform, MySQL Workbench reduces the need for disparate tools, thereby improving workflow continuity and productivity.

**Average Rating:** 4.5/5.0

**Total Reviews:** 49

#### How Do G2 Users Rate Mysql workbench?

- **Has the product been a good partner in doing business?:** 9.3/10 (Category avg: 8.8/10)
- **Data dictionary:** 8.9/10 (Category avg: 8.5/10)
- **Backup and Recovery:** 8.2/10 (Category avg: 8.5/10)
- **Data Migration:** 9.0/10 (Category avg: 8.4/10)

#### Who Is the Company Behind Mysql workbench?

- **Seller:** [Oracle](https://www.g2.com/sellers/oracle)
- **Year Founded:** 1977
- **HQ Location:** Austin, TX
- **Twitter:** @Oracle  
827,997 Twitter followers
- **LinkedIn® Page:** [www.linkedin.com](https://www.g2.com/external_clickthroughs/record?secure%5Bsource_type%5D=product_profile&secure%5Btoken%5D=a14fcbcd818b49d781453c19628a9479a70cc1e8e335e54c876392ab5f543da3&secure%5Burl%5D=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2F1028%2F&secure%5Burl_type%5D=linkedin_company_website)  
208,078 employees on LinkedIn®
- **Ownership:** NYSE:ORCL

#### Who Uses This Product?

- **Who Uses This:** Software Engineer
- **Top Industries:** Computer Software, Information Technology and Services
- **Company Size:** 37% Small, 35% Medium

#### What Do G2 Reviewers Say About Mysql workbench?

_AI-generated summary from verified user reviews_

##### Pros

- Users appreciate the **easy database management** tools in MySQL Workbench, enhancing their understanding and implementation.
- Users find the **ease of use** in MySQL Workbench invaluable for implementing and managing databases effortlessly.
- Users value the **easy use and implementation** of Mysql Workbench, simplifying database management and SQL query writing.
- Users appreciate the **implementation ease** of MySQL Workbench, finding it straightforward for database management and query writing.
- Users appreciate the **easy learning environment** of MySQL Workbench, facilitating quick database management and SQL query writing.

##### Cons

- Users find the **missing basic features** in MySQL Workbench, such as the lack of folder creation, frustrating.

#### What Are Recent G2 Reviews of Mysql workbench?

**[""MySQL Workbench - The Go To Tool for Database Management""](https://www.g2.com/survey_responses/mysql-workbench-review-13148573)**

**Rating:** 4.0/5.0 stars

_— Sameer R._

[Read full review](https://www.g2.com/survey_responses/mysql-workbench-review-13148573)

**["Easy Data Handling with Helpful ER Diagrams, Exports, and Admin Tools"](https://www.g2.com/survey_responses/mysql-workbench-review-12711129)**

**Rating:** 4.0/5.0 stars

_— Gaurav S._

[Read full review](https://www.g2.com/survey_responses/mysql-workbench-review-12711129)

### [YugabyteDB](https://www.g2.com/products/yugabytedb/reviews)

YugabyteDB is AI-ready, turbocharged PostgreSQL for business-critical transactional applications. 100% open source, it offers built-in resilience, on-demand scaling, and more! YugabyteDB eliminates the tradeoffs you get with legacy databases by uniquely combining enterprise-grade RDBMS capabilities with the horizontal scalability and resilience of cloud native architectures. YugabyteDB delivers a single logical database that can span across any cloud (private, public or hybrid). Industry-leading companies including Kroger, GM, Rakuten, Fiserv and Wells Fargo rely on YugabyteDB for mission-critical transactional applications. PostgreSQL Compatibility: YugabyteDB is more than just wire compatible with PostgreSQL, it is code compatible. YugabyteDB achieves this by reusing PostgreSQL’s query layer to achieve a high degree of compatibility with existing PostgreSQL applications or those that can be migrated to PostgreSQL. Developers can be immediately productive with the ecosystem of PostgreSQL-compatible frameworks, applications, drivers, and tools. Advanced Relational Database Capabilities: YugabyteDB delivers a comprehensive set of advanced RDBMS features like triggers, functions, stored procedures, strong secondary indexes, and distributed ACID transactions. This means that developers don't need to choose between the horizontal scalability of NoSQL systems and the ACID guarantees of traditional SQL systems. Resilience and High Availability: With YugabyteDB, critical services remain available during node, zone, region, and data center failures with fast failovers. YugabyteDB heals itself by re-replicating data automatically, and delivers zero downtime on maintenance tasks such as software upgrades, security patching, and distributed backups. Horizontal Scalability: Operations teams can effortlessly scale out even under heavy load without disruption or downtime by simply adding nodes to their YugabyteDB cluster. The database automatically rebalances load to use available resources. YugabyteDB’s shared nothing architecture is designed with no single point of failure or bottleneck. Geographic Distribution: YugabyteDB offers the most comprehensive and flexible deployment options in geo-distributed environments. Operators can make use of synchronous and asynchronous data replication and geo-partitioning to achieve desired consistency, resilience, performance, and compliance objectives. Security: YugabyteDB is built from the ground up with data security in mind. The database enables organizations to maintain a robust security posture with built-in controls such as LDAP authentication, role-based access control (RBAC), data encryption at rest and in transit (TLS), audit logging, and column-level permissions. Advanced features such as row level security (RLS) and column-level encryption are available for more advanced use cases. YugabyteDB is 100% open source, so download and start using the full set of features for free. You can also choose a flexible cloud DBaaS consumption option based on your needs: 1. YugabyteDB Aeon: Start with a free trial and enjoy a fully-managed DBaaS service that allows you to leave the day 2 operations and management work to YugabyteDB. 2. YugabyteDB Anywhere: Deploy a self-managed DBaaS in your environment with built-in automation to deploy, scale, and monitor YugabyteDB clusters at scale. YugabyteDB Voyager is an end-to-end modernization tool that can accelerate your cloud native adoption by simplifying the migration of both schema and data from databases including Oracle, PostgreSQL, MySQL, Aurora PostgreSQL, Azure SQL for PostgreSQL, and more. Learn more about YugabyteDB: https://www.yugabyte.com/ Sign up for YugabyteDB Aeon for free: https://cloud.yugabyte.com/

**Average Rating:** 4.5/5.0

**Total Reviews:** 62

#### How Do G2 Users Rate YugabyteDB?

- **Has the product been a good partner in doing business?:** 8.8/10 (Category avg: 8.8/10)
- **Data dictionary:** 8.3/10 (Category avg: 8.5/10)
- **Backup and Recovery:** 8.7/10 (Category avg: 8.5/10)
- **Data Migration:** 8.6/10 (Category avg: 8.4/10)

#### Who Is the Company Behind YugabyteDB?

- **Seller:** [Yugabyte, Inc.](https://www.g2.com/sellers/yugabyte-inc)
- **Company Website:** www.yugabyte.com
- **Year Founded:** 2016
- **HQ Location:** Sunnyvale, CA
- **Twitter:** @Yugabyte  
9,272 Twitter followers
- **LinkedIn® Page:** [www.linkedin.com](https://www.g2.com/external_clickthroughs/record?secure%5Bsource_type%5D=product_profile&secure%5Btoken%5D=0610079f63834a2a85c51161abbc2e3f4f8c02ef33ea548b6e449a1c785255fb&secure%5Burl%5D=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2F10643910&secure%5Burl_type%5D=linkedin_company_website)  
474 employees on LinkedIn®

#### Who Uses This Product?

- **Top Industries:** Financial Services, Computer Software
- **Company Size:** 45% Medium, 40% Small

#### What Do G2 Reviewers Say About YugabyteDB?

_AI-generated summary from verified user reviews_

##### Pros

- Users value the **easy scalability** of YugabyteDB, enabling seamless growth without major downtime or headaches.
- Users praise YugabyteDB for its **high reliability** , ensuring data safety and seamless performance even under pressure.
- Users value the **high availability** of YugabyteDB, ensuring reliable performance and minimal downtime for critical applications.
- Users value the **high availability** of YugabyteDB, enabling seamless performance and minimal downtime for critical workloads.
- Users value the **outstanding performance** of YugabyteDB, enjoying scalability and resilience for high-volume applications.

##### Cons

- Users find **operational complexity** in YugabyteDB challenging, especially when dealing with distributed systems and advanced features.
- Users find the **learning curve steep** due to complex setup and operational requirements for YugabyteDB.
- Users find the **complex setup** of YugabyteDB challenging, requiring effort and time compared to simpler databases.
- Users find the **complex configuration** challenging, especially when managing distributed clusters as beginners.
- Users experience **slow performance** issues with YugabyteDB, complicating data retrieval and overall operational efficiency.

#### What Are Recent G2 Reviews of YugabyteDB?

**["Good for PostgreSQL scaling, but operational complexity can grow"](https://www.g2.com/survey_responses/yugabytedb-review-7716153)**

**Rating:** 4.5/5.0 stars

_— Otacilio Pedro S._

[Read full review](https://www.g2.com/survey_responses/yugabytedb-review-7716153)

**["Great for Learning Distributed Databases with Real-World Use"](https://www.g2.com/survey_responses/yugabytedb-review-11199640)**

**Rating:** 4.5/5.0 stars

_— Vikas Kumar S._

[Read full review](https://www.g2.com/survey_responses/yugabytedb-review-11199640)

### [BMC AMI Data](https://www.g2.com/fr/products/bmc-ami-data/reviews)

BMC AMI Data est une solution intelligente de gestion et d'optimisation des données pour les environnements IBM Z. Elle aide les entreprises à gérer, protéger et optimiser les données critiques des mainframes tout en réduisant la complexité opérationnelle, les coûts et les risques. BMC AMI Data exploite l'automatisation, l'analyse avancée et les insights prédictifs pour rationaliser la maintenance des données, améliorer les performances et garantir la disponibilité des charges de travail critiques sur Db2, IMS, VSAM et les systèmes associés. La solution permet aux équipes de données de passer d'une gestion réactive à des opérations proactives et basées sur les insights. Les principales capacités incluent : - Gestion et maintenance automatisées des données pour réduire l'effort manuel et améliorer l'efficacité opérationnelle - Analyses en temps réel et insights prédictifs pour optimiser les performances et anticiper les problèmes avant qu'ils n'impactent les charges de travail - Optimisation du CPU et des ressources pour contrôler les coûts et améliorer l'efficacité du système à grande échelle - Protection des données et réduction des risques pour sauvegarder les informations critiques et maintenir l'intégrité des données - Support pour les initiatives de modernisation en simplifiant la gestion et l'intégration des données mainframe avec les besoins évolutifs des entreprises - Traitement sur plateforme qui garde les données sécurisées et gérées directement au sein de l'environnement IBM Z En modernisant la gestion des données mainframe avec l'automatisation et l'intelligence, BMC AMI Data aide les organisations à contrôler la croissance des données, réduire les risques opérationnels et assurer une livraison haute performance d'applications critiques pour l'entreprise, toujours disponibles.

**Average Rating:** 4.4/5.0

**Total Reviews:** 39

#### How Do G2 Users Rate BMC AMI Data?

- **the product a-t-il été un bon partenaire commercial?:** 8.7/10 (Category avg: 8.8/10)
- **Dictionnaire de données:** 9.4/10 (Category avg: 8.5/10)
- **Sauvegarde et restauration:** 7.7/10 (Category avg: 8.5/10)
- **Migration des données:** 9.6/10 (Category avg: 8.4/10)

#### Who Is the Company Behind BMC AMI Data?

- **Vendeur:** [BMC Software](https://www.g2.com/fr/sellers/bmc-software)
- **Site Web de l'entreprise:** www.bmc.com
- **Année de fondation:** 1980
- **Emplacement du siège social:** Houston, TX
- **Twitter:** @BMCSoftware  
47,946 abonnés Twitter
- **Page LinkedIn®:** [www.linkedin.com](https://www.g2.com/fr/external_clickthroughs/record?secure%5Bsource_type%5D=product_profile&secure%5Btoken%5D=37ad1a63508fe2cc6db417c89a62ba6b1d6cd7d1772cc2e6b66420d74a07cabe&secure%5Burl%5D=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2F1597%2F&secure%5Burl_type%5D=linkedin_company_website)  
8,877 employés sur LinkedIn®

#### Who Uses This Product?

- **Top Industries:** Logiciels informatiques, Technologie de l'information et services
- **Company Size:** 41% Small, 38% Large

#### What Do G2 Reviewers Say About BMC AMI Data?

_AI-generated summary from verified user reviews_

##### Pros

- Les utilisateurs apprécient les **capacités analytiques** de BMC AMI Data, améliorant ainsi l'efficacité et l'efficience de leur gestion de base de données.
- Les utilisateurs apprécient l' **automatisation transparente** dans BMC AMI Data, améliorant l'intégration et garantissant les normes d'assurance qualité DDL.
- Les utilisateurs apprécient l' **interface conviviale** de BMC AMI Data, améliorant leur expérience dans la gestion de bases de données complexes.
- Les utilisateurs apprécient les **intégrations faciles** de BMC AMI Data, améliorant le flux de travail avec des outils comme Jenkins et UrbanCode.
- Les utilisateurs apprécient l' **automatisation et l'évolutivité** de BMC AMI Data, améliorant l'efficacité et l'efficience de l'administration des bases de données.

##### Cons

- Les utilisateurs sont préoccupés par la nature **coûteuse** de BMC AMI Data, ce qui affecte l'accessibilité pour certaines organisations.
- Les utilisateurs rencontrent des **difficultés d'installation** avec BMC AMI Data, citant souvent des défis dans la configuration et l'administration.
- Les utilisateurs signalent souvent une **difficile avec BMC AMI Data, ce qui impacte leur expérience utilisateur globale.**
- Les utilisateurs trouvent une **compatibilité limitée** avec les anciens systèmes Db2, ce qui entrave l'expérience d'intégration transparente qu'ils attendaient.
- Les utilisateurs expriment leur frustration face aux **options de personnalisation limitées** de BMC AMI Data, ce qui affecte leur flexibilité globale et leur flux de travail.

#### What Are Recent G2 Reviews of BMC AMI Data?

**["Essentiel pour la surveillance et l'optimisation des systèmes mainframe"](https://www.g2.com/fr/survey_responses/bmc-ami-data-review-13171612)**

**Rating:** 4.5/5.0 stars

_— Aditya K._

[Read full review](https://www.g2.com/fr/survey_responses/bmc-ami-data-review-13171612)

**["BMC AMI Data simplifie la gestion des bases de données mainframe avec une automatisation fiable"](https://www.g2.com/fr/survey_responses/bmc-ami-data-review-13133655)**

**Rating:** 5.0/5.0 stars

_— Sachin A._

[Read full review](https://www.g2.com/fr/survey_responses/bmc-ami-data-review-13133655)

#### What Are G2 Users Discussing About BMC AMI Data?

- [À quoi sert l'administration de base de données BMC AMI pour Db2 ?](https://www.g2.com/fr/discussions/what-is-bmc-ami-database-administration-for-db2-used-for)
- [À quoi sert BMC Compuware Hiperstation ?](https://www.g2.com/fr/discussions/what-is-bmc-compuware-hiperstation-used-for)
- [À quoi servent BMC AMI Application Restart et VSAM Recovery ?](https://www.g2.com/fr/discussions/what-is-bmc-ami-application-restart-and-vsam-recovery-used-for)

- ‹ Prev‹ Prev
- 1
- [2](/categories/database-management-systems-dbms?open_modal_url=%2Fproducts%2Fca-rc-update-for-db2-for-z-os%2Fwishlists%3Fhost_path%3D%252Fcategories%252Fdatabase-management-systems-dbms%26source%3Dcategory&order=g2_score&page=2#product-list)
- [3](/categories/database-management-systems-dbms?open_modal_url=%2Fproducts%2Fca-rc-update-for-db2-for-z-os%2Fwishlists%3Fhost_path%3D%252Fcategories%252Fdatabase-management-systems-dbms%26source%3Dcategory&order=g2_score&page=3#product-list)
- [4](/categories/database-management-systems-dbms?open_modal_url=%2Fproducts%2Fca-rc-update-for-db2-for-z-os%2Fwishlists%3Fhost_path%3D%252Fcategories%252Fdatabase-management-systems-dbms%26source%3Dcategory&order=g2_score&page=4#product-list)
- [5](/categories/database-management-systems-dbms?open_modal_url=%2Fproducts%2Fca-rc-update-for-db2-for-z-os%2Fwishlists%3Fhost_path%3D%252Fcategories%252Fdatabase-management-systems-dbms%26source%3Dcategory&order=g2_score&page=5#product-list)
- …
- [17](/categories/database-management-systems-dbms?open_modal_url=%2Fproducts%2Fca-rc-update-for-db2-for-z-os%2Fwishlists%3Fhost_path%3D%252Fcategories%252Fdatabase-management-systems-dbms%26source%3Dcategory&order=g2_score&page=17#product-list)
- [18](/categories/database-management-systems-dbms?open_modal_url=%2Fproducts%2Fca-rc-update-for-db2-for-z-os%2Fwishlists%3Fhost_path%3D%252Fcategories%252Fdatabase-management-systems-dbms%26source%3Dcategory&order=g2_score&page=18#product-list)
- [Next ›Next ›](/categories/database-management-systems-dbms?open_modal_url=%2Fproducts%2Fca-rc-update-for-db2-for-z-os%2Fwishlists%3Fhost_path%3D%252Fcategories%252Fdatabase-management-systems-dbms%26source%3Dcategory&order=g2_score&page=2#product-list)

Spotlight Categories

[SMS Marketing Software](https://www.g2.com/categories/sms-marketing)

[Integration Platform as a Service (iPaaS) Solutions](https://www.g2.com/categories/ipaas)

[Employee Recognition Software](https://www.g2.com/categories/employee-recognition)

[Contract Management Software](https://www.g2.com/categories/contract-management)

[Sales Tax and VAT Compliance Software](https://www.g2.com/categories/sales-tax-and-vat-compliance)

Similar Categories

- [Relational Databases](/categories/relational-databases)
- [NoSQL Databases](/categories/nosql-databases)
- [Big Data](/categories/big-data)
- [Database as a Service (DBaaS)](/categories/database-as-a-service-dbaas)

- [Database Comparison](/categories/database-comparison)
- [Desktop Database](/categories/desktop-database)
- [Real-time Analytic Database](/categories/real-time-analytic-database)
- [Structured Data Archiving and Application Retirement](/categories/structured-data-archiving-and-application-retirement)

- [Time Series Databases](/categories/time-series-databases)
- [Vector Database](/categories/vector-database)

[Browse Database Management Systems (DBMS) Themes](/categories/database-management-systems-dbms/themes)

 ![Shalaka Joshi](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Shalaka Joshi")
SJ

Researched and written by [Shalaka Joshi](https://research.g2.com/insights/author/shalaka-joshi)

Updated October 3, 2024

Database management systems (DBMS) are designed to define, store, retrieve, and manage the data within a database. It allows users to create, maintain, and manage databases. DBMS manipulates the database as per the user requirements. Using DBMS ensures that the data of an organization is clean, consistent, secure, relevant, and supports concurrency.

Along with the standard database functionalities (e.g., CRUD operations), DBMS software has much stronger management capabilities. These include functions like stronger metadata visibility and analysis, in-depth and custom reporting, performance monitoring, usage analytics, and compliance checks. Extensive solutions may offer capabilities of [database backup software](https://www.g2.com/categories/database-backup), [data replication software](https://www.g2.com/categories/data-replication), [disaster recovery software](https://www.g2.com/categories/disaster-recovery), or [disaster recovery as a service (DRaaS) software](https://www.g2.com/categories/disaster-recovery-as-a-service-draas), as well.

Typically used by database administrators, DBMS are integral to preserving database quality and integrity. They fall into a larger database-oriented stack, which can include solutions like database security and database monitoring.

DBMS is used as part of both relational and non-relational databases. DBMS software are of different types, in association with the database being managed and organized. Some of the more popular DBMS are as follows:

- Relational: Associated typically with [relational databases](https://www.g2.com/categories/relational-databases), the relational model organizes data tabularly (rows and columns approach) and is currently the most standard database model. DMBS focused on the relational model are referred to as RDBMS.
- Object oriented: [Object-oriented databases](https://www.g2.com/categories/object-oriented-databases) follow a programming-style, object-oriented approach to entering and organizing data. DBMS aligned with this model are referred to as OODMBS.
- Hierarchical: In a hierarchical model, data is organized with a tree-like structure, where associations (“branches") extend from a point of data. DBMS aligned with this model are sometimes referred to as HDBMS.
- Distributed: Under a distributed database model, data is decentralized and stored across several locations. These locations can be physically local (e.g., different servers in the same data center) or spread apart (perhaps connected via SD-WAN). DMBS aligned with the distributed database model are sometimes referred to as DDBMS.
- Non-relational DBMS or NoSQL DBMS: NoSQL DBMS support both structured and unstructured data. There is no set defined schema as compared to other data models. The key benefit of this DBMS is that users can process queries of various elements and not be limited by the structure.

To qualify for inclusion in the Database Management Systems (DBMS) category, a product must:

- Manage and align with a database model (e.g., relational, object-oriented, hierarchical, distributed, non-relational)
- Can also exist as a standalone tool to manage databases
- Provide database maintenance functionalities
- Provide extensive reporting and activity analytics

Top Tools at a Glance

| 

 | 

Microsoft-ecosystem relational data with SSMS administration

 | 

User Review

"Makes Data management simpler!!"

 |
| 

 | 

Elastic cloud data warehousing with workload isolation

 | 

User Review

"Elastic Scaling and Fast Analytics with Snowflake"

 |
| 

 | 

In-memory HTAP analytics inside SAP ecosystems

 | 

User Review

"Efficient Transactions, But Time-Intensive Setup"

 |
| 

 | 

Fully-managed relational databases inside GCP ecosystems

 | 

User Review

"Secure, Highly Available, and Scalable Cloud SQL for Diverse Workloads"

 |
| 

 | 

Serverless ad-hoc querying on S3 data lakes

 | 

User Review

"Athena Makes S3 Data Validation Fast and Infrastructure-Free"

 |
| 

 | 

Unified analytics lifecycle with in-memory processing

 | 

User Review

"Effective Data Analysis with SAS Viya"

 |
| 

 | 

Oracle-native PL/SQL development and schema administration

 | 

User Review

"Oracle SQL Developer: A Go-To Tool for Direct Database Work"

 |
| 

 | 

MySQL-compatible HTAP with horizontal scalability

 | 

User Review

"TiDB Delivers NoSQL-Scale with SQL Simplicity and MySQL Compatibility"

 |
| 

 | 

Massively parallel enterprise data warehouse analytics

 | 

User Review

"Teradata Vantage Fast Query Performance and Strong Analytics for Big Data"

 |

* * *

Show More

### Database Management Systems (DBMS) Topics

- [What are Database Management Systems (DBMS)?](#what-are-database-management-systems-dbms)
- [What are the Common Features of Database Management Systems (DBMS)?](#what-are-the-common-features-of-database-management-systems-dbms)
- [What are the Benefits of Database Management Systems (DBMS)?](#what-are-the-benefits-of-database-management-systems-dbms)
- [Who Uses Database Management Systems (DBMS)?](#who-uses-database-management-systems-dbms)
- [Challenges with Database Management Systems (DBMS)](#challenges-with-database-management-systems-dbms)
- [How to Buy Database Management Systems (DBMS)](#how-to-buy-database-management-systems-dbms)

[
### Database Management Systems (DBMS) Topics
Expand/Collapse ](#)
- [What are Database Management Systems (DBMS)?](#what-are-database-management-systems-dbms)
- [What are the Common Features of Database Management Systems (DBMS)?](#what-are-the-common-features-of-database-management-systems-dbms)
- [What are the Benefits of Database Management Systems (DBMS)?](#what-are-the-benefits-of-database-management-systems-dbms)
- [Who Uses Database Management Systems (DBMS)?](#who-uses-database-management-systems-dbms)
- [Challenges with Database Management Systems (DBMS)](#challenges-with-database-management-systems-dbms)
- [How to Buy Database Management Systems (DBMS)](#how-to-buy-database-management-systems-dbms)

## Learn More About Database Management Systems (DBMS)

### What are Database Management Systems (DBMS)?

A database management system (DBMS) is a software application that is designed to store, retrieve, define, and manage the data within a database. DBMS can be viewed as an interface between the user and the database. The software is used to manage the data, database engine, and database schema. Simply put, DBMS manipulates the database as per the user requirements. Using DBMS ensures that the data of an organization is clean, consistent, secure, relevant, and supports concurrency.

To understand database management systems, it’s important to clearly define a database. A database is a collection of structured data stored within a computer system. The control of this database is done via DBMS. Data is modeled into rows and columns to make it more structured for applications to query information as required by the user. The data can be accessed from the database via Structured Query Language (SQL) or NoSQL databases. Some popular database solutions include Oracle database (Oracle RDBMS offering), Microsoft SQL Server, IBM DB2, Amazon RDS, among others.

In addition, several DBMS products are open source in nature, which means it grants the users complete freedom to customize the data as per requirements. An open-source database has its code freely available for download, modification, and reuse. Open source is the opposite of a proprietary database wherein the code cannot be accessed by anyone. Some examples include MongoDB, MariaDB, PostgreSQL, MySQL, and so on.

**What does a database management system (DBMS) do?**

In addition to all the features shared above, DBMS supports change management, security, backup and recovery, analyzes performance management, concurrency, among several other features. All the data being generated is being logged in the database, and also undergoes continuous audits to ensure that the applications that access them get the correct data.

From a user perspective, DBMS is a unified repository where end users can access any data required. The software ensures that the end user can access the required information limited to the particular persona. The user does not have to be concerned about where the data is located, as long as they can obtain the data for running their applications. The DBMS will handle every request that comes from an end user or any application.

**Components of a DBMS**

To understand more about database management systems, it is a good idea to identify the various components that constitute a DBMS:

**Storage:** This is the database or the place where the company stores its data. DBMS will act as the interface between the computer and the user to provide the data. It acts as an interface between an operating system (OS) (such as Windows or Linux) and a file system to store any data that comes through.

**Access language:** The DBMS needs to have an access language that allows it to communicate with multiple parties. SQL is an example of this.

**Metadata catalog** : This is also known as a data dictionary. It is a storehouse of all the data objects created. This catalog serves as an index page for users to query the information, or verify data requests. This catalog can hold various levels of details such as schemas, programs, usage details, communication details, performance updates, and several others.

**Lock managers:** This component of DBMS ensures that all user access is restricted to what rights have been set for that persona. Only those with access can add, edit, or delete data.

**Changelog:** The changelog component keeps a track of all changes being made to the database application. A record of all changes is known as the log. DBMS uses a log manager to keep track of all the logs created.

**Additional features:** Some database management tools can also include other additional components such as backup, copy, data integrity checks, among several others.

**What Does DBMS Stand For?**

DBMS stands for database management systems. DBMS is involved with incoming data, or more specifically managing and running the data. Data is unprocessed and random in nature. When this data is organized, this is known as information. Database management systems involve processing or managing data, and not information. With the growth of big data, data-intensive applications and data-heavy workloads being used to drive well-informed decisions has become the new norm. Having a strong database management system in place which understands a company's data needs and manages the data accordingly is key to ensuring that the data is being used justifiably.

#### What Types of Database Management Systems (DBMS) Exist?

DBMS are based on the database models that it works with. Some of the best database management systems are as follows:

**Hierarchical data model**** :** In this data model, data elements have a 1:n (one-to-many) relationship. It is a tree structure of data. It is a good option to store data that involves features, attributes, child-parent relationships, and other types of data.

**Network data model:** In this type of data model, the data is structured as 1:1 or many-to-many. Data can have more than one parent node. A key benefit of this type of database model is that it can build several relationships among different data types, which makes it much more efficient. 

**Relational database model:** This is the most commonly used data model by companies. In this, data has a 2D relationship, where the data is organized into rows and columns. The data within the table is related to each other, hence the term relational. Data within one table can also be linked to data in another table by using keys.

**Object-Oriented data model:** In this database model, the data is stored in the form of objects and not within tables or rows. The object would contain all the required data within it, and the user needs to access the address of the object to obtain the data for usage. Object-oriented databases are highly compatible with several programming languages, key ones include Java, C++, Perl, and several others.

**No SQL data model:** NoSQL data models support both structured and unstructured data. There is no set defined schema as compared to other data models. The key benefit of this data model is that users can process queries of various elements and not be limited by the structure.

**Cloud-based data model:** Companies can also choose to store their databases online as a cloud database. Here, the DBaaS model comes into the picture, wherein databases are managed via the cloud provider, the user only needs to pay the subscription fee. There is no need for the user to procure any additional hardware, which allows companies to save a significant amount of money on initial investments.

### What are the Common Features of Database Management Systems (DBMS)?

The following are some core features within database management software that can help users in several ways:

**Data structure:** This is the key feature of DBMS. All the data is stored in a categorized structure so that it becomes easier for the user to call upon the data when it is required. It makes it easier for applications to understand the data structure. DBMS can also ensure continuous updates when the data is in a clear hierarchical structure.

**Minimized duplication and redundancy:** Databases are used across almost all functions within a company. Since there are several users, this could cause issues such as data duplication and redundancy. DBMS ensures that the data present is only in a single instance, thereby reducing redundancy significantly.

**Database maintenance:** Every transaction creates a large amount of unstructured data. Large enterprises will have tons of data that require cleaning, security, and even backup and recovery. DBMS allows enterprises to ensure that the tons of data being generated every minute are being processed and managed correctly.

**Permanent data storage:** DBMS ensures that the data being stored is permanent and that there is no loss to the data. In case a loss occurs due to any unforeseen activity, the DBMS ensures that the data is backed up and can be recovered by the user when needed.

**Data security support:** Data needs to be safe. Ensuring that the data does not fall in the wrong hands is a key concern for companies especially when there are several data breaches causing companies to lose critical information. The DBMS features allow companies to create “personas” who can access all the data or some of the data (for a specific function for example). These key personas create user identities and approve access to ensure that security is maintained to a maximum.

**Multi-user access** : In continuation of the above point, multiple users can be given access once certain limits are set. These limits ensure that the data can be accessed or viewed as per the rights given.

**Metadata support:** Metadata is defined as the data that summarizes the main data; it makes finding the actual data easier. It provides the user what all data is within it, such as related files and objects. It provides more context for the data being stored. DBMS has a key feature of providing metadata libraries, making it easier for applications to call out the required data.

### What are the Benefits of Database Management Systems (DBMS)?

**Improved process efficiency:** One of the key features of DBMS is that it ensures that there are no inconsistencies in the data, caused by duplication. This allows for a clean database and smoother data management which improves the process efficiency across the company. In addition, since data is shared, it does not require much storage space, further streamlining the process.

**Data consistency:** DBMS ensures that the data is the same which is being used across various functions within a company. There is no change to the data, regardless of who is viewing it. 

**Customization:** A key benefit of DBMS is that it keeps applications and the database separate. An application can be customized as per user requirements, but the data being called or used will remain the same. In addition, these applications need not use all the data called while using the DBMS, only the required data is used. Ideally, each employee will have different ways to access the database based on the front-end application that they have been given. For example, an employee will not be able to access other employees’ personal information but the HR department will have access to this.

**Data availability:** DBMS needs to ensure that the data is made accessible to different employees at any time and from anywhere. Multiple users can access data remotely 24 hours a day.

### Who Uses Database Management Systems (DBMS)?

Users of DBMS have an important job of ensuring that the valuable data of a company is handled efficiently. These users need to be mindful of who can/cannot access the critical data and ensure the right settings and permissions have been given. Other users are primarily developers and designers who need access to the data while creating a new product/application.

Some of the main users of DBMS have been listed below:

**Database administrator (DBA):** Key persona handling the DBMS. The schema is determined by the DBA. They are also responsible for setting up different user IDs and rights for those who can access the database. This persona also monitors the database, ensures security is maintained, monitors backup and recovery plans, tracks errors or failures, provides database support, and several other requirements.

**Database designers:** Under this persona, the designer uses the DBMS to create data tables, rows, columns, indexes, and other design structures.

**Software developers:** Programmers and software developers would need access to data when developing a software application or making changes to one. This persona will have access to the database to ensure that the software application development process goes smoothly. In addition, as long as the various programs being created use an application programming interface (API) for the database software that has been provided by the DBMS provider, developers need not modify any programs just because changes were made to a database. This API does not bother the developer to keep track of any changes done to the database, it will automatically make the modifications that the developer requires.

**Managers:** Managers can use the database temporarily or whenever they require new information. This persona doesn't use DBMS daily, as the other personas, only when the requirement arises. 

**Other users:** This includes users such as analysts, scientists who do not write a code, but use the DBMS to query some information as and when required. They have interactions with the database as per their data requirements.

### Challenges with Database Management Systems (DBMS)

DBMS software is critical for any organization that manages its data. The software needs to be effective in handling the data accurately and safely. However, DBMS software does come with its own set of challenges. 

**Security challenges:** Hacking of the database is the biggest concern companies face. Critical data, master data, financial data, and several other data points of a company could be breached by hackers, who could misuse this information. Having robust, secure, and high-performance DBMS to ensure that the database is fully protected is a necessity. Setting up user rights for the database, which limits to which section of data a user can access, is a must.

**Safety of data:** Data needs to be clean, concise, and without any errors. When data is being processed, no part of it should be lost. DBMS should ensure that the database does not have any duplicate data points, cannot be deleted without the correct user rights, and should have transactional guarantees to ensure that all the data generated by a transaction is pure.

**Increased cost:** As the amount of data increases, there is a need to purchase more memory and higher server processing power to process large amounts of data. Along with the cost of infrastructure, security costs, maintenance costs, staff training costs, and data center construction costs, several other additional costs could end up becoming a huge investment for the firm. Although the introduction of cloud database as a service (DBaaS) does alleviate the issue, not many customers might be keen to move all their critical data to cloud and would prefer it on-premises.

**Data integration:** There are numerous sources of data—from hardware points such as mobile phones, laptops, to social media to IoT and several others. Businesses need to ensure that all this valuable data is being recorded properly. It can be a huge task for the DBMS to ensure that all the data from all these various data points are being recorded properly. Ensuring that the data is clean and has no duplicates or errors is a strenuous task.

**Managing both cloud and on-premises databases:** Companies can choose to opt for a mix of cloud and on-premises databases as per requirements. This could be a major challenge for DBMS since it would need to handle requests of both the databases and treat it as one big database. The user of the database does not need to know where or how the data is located, but only how they can access it. In addition, the vendor will need to choose a DBMS that is scalable when cloud is involved.

### How to Buy Database Management Systems (DBMS)

#### Requirements Gathering (RFI/RFP) for Database Management Systems (DBMS)

When choosing a DBMS, some important criteria need to be considered. Factors such as usability, functionality, and security are key criteria that cannot be compromised on. Having features such as dashboards and visualizations is a great benefit to have, to ensure ease of analyzing the data and keeping track of several queries. Other important features to look out for are support and development—the hours when customer support is available, the willingness to solve user queries, and so on.

As a business grows, scalability is an important criterion to keep in mind. With tons of data being generated, it can get difficult for the customers’ DBMS to scale as per requirement and manage millions of rows and columns of data. Another key feature to ensure that the DBMS has is integration support. There are numerous other software that are a part of a company's environment such as CRM, ERP, and others. How these integrations are managed and how the company ensures all these software connect with the DBMS is critical for the smooth flow of data.

#### Compare Database Management Systems (DBMS) Products

**Create a long list**

In this step, buyers should keep their options open to consider the full range of products. Buyers have the freedom to explore numerous offerings that the database management software market has. In addition, this is the main step to evaluate the answers to the above questions. The long list can be made much more concise and smaller by addressing the goals.

**Create a short list**

Buyers can make much more granular comparisons on this step. In addition to this, buyers can use the G2 reviews to further narrow this list down.

**Conduct demos**

Once the list has been reduced to a couple of vendors, buyers may begin to request a demo. During the demo, buyers should seek out information that is related to their non-negotiable terms. This is a good stage where the buyer can delve more deeply into understanding how secure their database will be, if they can promise high-performance support, and what the features are—latency in loading databases, after-service support, staff training, and other additional features that can be provided when opting for their DBMS product. 

#### Selection of Database Management Systems (DBMS)

**Choose a selection team**

Choosing the right team to work together to decide the right DBMS is a critical part of the process since several personas would need to access the database applications as per requirements. The team should include a mix of different personas who have the required skills, the interest, and the time. Some roles include DBMS admins, CXOs, application developers, and others.

**Negotiation**

A buyer can choose to negotiate to trim costs. The buyer needs to note that if in the future there is a requirement for scaling, there would be additional costs or an increase to the subscription pricing. For example, in case a customer chooses to opt for DBaaS solutions in addition to on-premises DBMS, it would be a good practice to check with the DBMS vendor if they offer any cloud support, training, and other factors. Keeping such factors in mind will help the buyer to put forward better negotiation tactics for the specific functions that matter.

**Final decision**

Once all the steps are complete, the final decision is made weighing all factors and scenarios. Having a trial run of the DBMS using smaller databases is a good place to start. A small group of database admins can pass on their views to the team making the final decision.