DbVisualizer Pro 資料庫管理工具

£100.00

DbVisualizer Pro 是一款功能全面且易於使用的資料庫管理和開發工具,特別適合需要管理多種資料庫的專業用戶。它的強大查詢功能、高級管理工具和視覺化功能,使其成為開發人員、資料庫管理員和數據分析師的重要工具。

無論是處理日常的資料庫操作,還是進行深度的性能優化和資料分析,DbVisualizer Pro 都能提供卓越的支持。

貨號: DbVisualizer 分類: , 標籤: ,

描述

DbVisualizer Pro 資料庫管理工具

功能介紹

“用戶滿意度最高的數據庫客戶端,享受真正通用數據庫工具的所有功能”

DbVisualizer Pro對於公司中常用的資料庫,增加了對資料庫特定功能的支持。並能在Windows,Linux和macOS上運行。支援多種不同的資料庫系統,是一套給開發者、DBAs、分析師使用的通用的資料庫管理工具。

DbVisualizer 擁有構建、管理和維護最先進的數據庫技術所需的一切。

  • 簡單的編碼。

借助智能自動完成、可視化查詢生成器、變量等功能,我們能夠讓用戶花更少的時間在日常編碼任務上,而將更多時間花在實際問題解決上。

  • 對最流行的數據源的廣泛支持。

您將能夠連接到最流行的數據源並直接在客戶端中使用其自定義對像類型。

  • SQL 的力量。電子表格的簡單性

DbVisualizer 可讓您利用 SQL 的強大功能和電子表格的簡單性來可視化、管理和編輯數據。

  • 根據您的工作流程量身定制。

您可以設置 DbVisualizer 以完美匹配您想要的工作方式。應用程序內部和外部。

  • 專為滿足嚴格的安全標準而設計。

DbVisualizer 旨在滿足最嚴格的安全標準。加密數據、限制訪問等等。

功能特色

 

Supported Databases

 

 Extended support 

Oracle
Oracle Autonomous Database is an all-in-one cloud database solution for data marts, data lakes, operational reporting, and batch data processing.
Version 8i – 21c validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

MySQL
MySQL is an Oracle-backed open source relational database management system (RDBMS) very popular with web applications and online publishing.
Version 3.23, 4, 5, 8 validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

PostgreSQL
PostgreSQL also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance.
Version 8+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

Microsoft SQL Server
Microsoft SQL Server is a industry standard relational database management system (RDBMS) used in a wide variety of BI and analytics applications.
Version 2000+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

ClickHouse
ClickHouse is a fast open-source column-oriented database management system that allows generating analytical data reports in real-time using SQL queries.
Extended support: DbVisualizer supports database-specific object types, functions and features.

SQLite
SQLite implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.
Version 3.6+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

MongoDB
MongoDB is a cross-platform document-oriented and NoSQL database.
Version 5.0 validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

Cassandra
Apache Cassandra is an open source NoSQL distributed database trusted by thousands of companies for scalability and high availability.
Version 4.x+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

Google BigQuery
BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data. It is a Platform as a Service (PaaS) that supports querying using ANSI SQL.
Extended support: DbVisualizer supports database-specific object types, functions and features.

Microsoft Access
Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE) with a graphical user interface and software-development tools.
Extended support: DbVisualizer supports database-specific object types, functions and features.

Oracle Cloud
Oracle Autonomous Database is an all-in-one cloud database solution for data marts, data lakes, operational reporting, and batch data processing.
Version 8i – 21c validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

Azure SQL Database
Azure SQL Database is a SQL Server database engine, based on the latest stable Enterprise Edition of SQL Server and fully managed by Azure.
Extended support: DbVisualizer supports database-specific object types, functions and features.

Db2
Db2, or Database 2, is a set of relational database products built and offered by IBM to store, analyze and retrieve data with maximum performance.
Version 8.2+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

Derby
Apache Derby is a rdbms developed by the Apache Software Foundation focusing on easy installation and usage with a minimal disk-space footprint.
Version 10.2+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

Elasticsearch
Elasticsearch is the world’s leading free and open search and analytics solution with an emphasis on speed and scalability.
Version 7.15+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

Exasol
Exasol is a high-performance, in-memory, MPP database specifically designed for analytics of large data sets in real time.
Version 6.0+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

Greenplum
Greenplum Database (GPDB) is an advanced, fully featured, open source data warehouse, based on PostgreSQL.
Version 6.13.0+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

H2
H2 is a open source rdbms that can be embedded in Java applications or run in client-server mode.
Version 1.3 – 1.4, 2.x+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

IBM Db2 on Cloud
IBM Db2 on Cloud is a fully managed SQL cloud database with point-in-time recovery and high-availability disaster recovery (HADR).
Extended support: DbVisualizer supports database-specific object types, functions and features.

Informix
IBM Informix is an embeddable, high-performance database for integrating SQL, NoSQL, JSON, time-series and spatial data that’s designed for analytics int the cloud.
Version 9+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

MariaDB
MariaDB is an open source relational database management system (DBMS) that is a compatible drop-in replacement for the widely used MySQL.
Version 10.4+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

Mimer SQL
Mimer SQL is a high performance database engine, targeted at mission-critical client/server environments while offering scaleable performance on multiple plattforms.
Version 9.1 – 11 validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

MySQL Cloud
MySQL is an Oracle-backed open source relational database management system (RDBMS) very popular with web applications and online publishing.
Version 3.23, 4, 5, 8 validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

Netezza
IBM Netezza is a powerful and highly parallelized Data Warehousing system that is simple to administer and to maintain.
Version 7.2+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

NuoDB
NuoDB is an SQL-oriented transactional database management system (DBMS) designed for distributed deployment in the cloud.
Version 2.0.4 – 4.3 validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

Presto
Presto is a distributed query engine for big data using the SQL query language.
Version 0.270+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

Redshift
Redshift is a data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services.
Version 1.0.7804+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

SAP ASE
SAP ASE is a relational model database server developed by Sybase Corporation.
Version 12.5+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

Snowflake
The Snowflake Cloud Data Platform includes a pure cloud, SQL data warehouse.
Version 3.56+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

Trino
Trino is an ANSI SQL compliant query engine, that works with a wide variety of BI tools.
Version 360+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

Vertica
Vertica is a columnar data storage platform designed to handle large volumes of data, which enables very fast query performance in traditionally intensive scenarios.
Version 6.1.3+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

Yellowbrick
Yellowbrick Data Warehouse is an advanced, massively parallel processing (MPP) SQL database designed for batch, real-time, ad hoc, and mixed workloads.
Version 4.1+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

SingleStore
SingleStore (formerly MemSQL) is a cloud-native database designed for data-intensive applications. A distributed, relational, SQL database management system (RDBMS) that features ANSI SQL support.
Version 7.6+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.

 Basic support 

Hive
Apache Hive is a distributed, fault-tolerant data warehouse system that enables analytics at a massive scale.
Basic support: Users have validated that they can use DbVisualizer to work with the database.

Solr
Solr is a fast, open source enterprise search platform built on Apache Lucene™
Basic support: Users have validated that they can use DbVisualizer to work with the database.

Salesforce.com
The Salesforce Database is powered by Oracle. There are a number of languages that are used for the Salesforce Database including SQL.
Basic support: Users have validated that they can use DbVisualizer to work with the database.

Firebird
Firebird is an open-source SQL relational database management system that runs on Linux, Microsoft Windows, macOS and several Unix platforms.
Basic support: Users have validated that they can use DbVisualizer to work with the database.

Teradata
Teradata is a Relational Database Management System (RDBMS) suitable for large data warehousing applications.
Basic support: Users have validated that they can use DbVisualizer to work with the database.

CrateDB
CrateDB is a open-source distributed SQL database management system that integrates a fully searchable document-oriented data store.
Basic support: Users have validated that they can use DbVisualizer to work with the database.

HSQLDB
HSQLDB (HyperSQL DataBase) is a SQL relational database system written in Java. It offers a small, fast multithreaded and transactional database.
Version 1.7+ validated
Basic support: Users have validated that they can use DbVisualizer to work with the database.

InterSystems IRIS
Iris is an object-oriented database management system being developed at Hewlett-Packard Laboratories.
Basic support: Users have validated that they can use DbVisualizer to work with the database.

MaxDB
MaxDB is a heavy-duty, SAP-certified open source database that offers high availability, scalability and a comprehensive feature set.
Basic support: Users have validated that they can use DbVisualizer to work with the database.

Actian X (Ingres)
Actian X is a combination of Ingres transactional and Vector analytic databases, integration and a monitoring tool.
Basic support: Users have validated that they can use DbVisualizer to work with the database.

CData Software JDBC Drivers
Easy-to-use JDBC Drivers with powerful Enterprise-level features. Connect JDBC with Salesforce, NetSuite, SharePoint, Secure File Transfer, and more.
Basic support: Users have validated that they can use DbVisualizer to work with the database.

DataDirect’s Autonomous REST Connector
Progress DataDirect Autonomous REST Connector is an intelligent, customizable data connectivity solution enabling build and deploy of data connectors without coding.
Basic support: Users have validated that they can use DbVisualizer to work with the database.

FrontBase
FrontBase is a relational database management system written in ANSI C to be scalable and fast.
Version 4+ validated
Basic support: Users have validated that they can use DbVisualizer to work with the database.

HPE NonStop SQL
NonStop SQL is a relational database management system designed for fault tolerance and scalability, offered by HP.
Basic support: Users have validated that they can use DbVisualizer to work with the database.

IBM Db2 iSeries
IBM Db2 is a family of data management products, including the Db2 relational database.
Basic support: Users have validated that they can use DbVisualizer to work with the database.

IBM Db2 z/OS
IBM Db2 for z/OS is a relational database management system that runs on the mainframe.
Basic support: Users have validated that they can use DbVisualizer to work with the database.

IBM IMS
IBM IMS is a hierarchical database management software system for online transaction processing (OLTP) and online batch processing.
Basic support: Users have validated that they can use DbVisualizer to work with the database.

JDBC Drivers for CSV, XML, dBase, MS Access
JDBC driver from Sesame Software for connecting to CSV, XML, dBase and MS Access.
Basic support: Users have validated that they can use DbVisualizer to work with the database.

Pervasive
Pervasive PSQL is a relational database developed by Pervasive Software mostly used as embedded database.
Version 9+ validated
Basic support: Users have validated that they can use DbVisualizer to work with the database.

Progress
Progress OpenEdge RDBMS supports modern, mission-critical, business applications developed using the OpenEdge application development platform.
Basic support: Users have validated that they can use DbVisualizer to work with the database.

SAP IQ (Sybase IQ)
SAP IQ is a column-based, petabyte scale, relational database software system used for BI, data warehousing, and data marts. Replaced by Yellowbrick.
Basic support: Users have validated that they can use DbVisualizer to work with the database.

SAP SQL Anywhere (Sybase SQL Anywhere)
SAP SQL Anywhere is a proprietary relational database management system (RDBMS) product from SAP.
Version 11+ validated
Basic support: Users have validated that they can use DbVisualizer to work with the database.

新功能 v25.2.5 介紹

DbVisualizer 的最新版本(版本 25.2.5)現已推出,並附帶一系列重要更新。

DbVisualizer 25.2 引入了與 Git 的集成,增加了對 Redis 的支持,改進了價值、記錄和聚合視圖,增強了自動完成功能,簡化了驅動程式處理等等。讓我們來詳細了解一下。

使用 Git 進行版本控制

從本次發布版本開始,DbVisualizer 整合了對 Git 版本控制的支持,讓您可以安全且有效率地共享和追蹤資料庫腳本的變更。您可以複製遠端倉庫或掛載現有倉庫,切換分支、推送變更、取得更新並查看提交歷史記錄——所有基本功能一應俱全,為您打造舒適且有效率的工作流程。如果您使用 GitHub,則可以使用基於 Web 的驗證流程。

支持 Redis

DbVisualizer 擴展了其 NoSQL 功能,新增了對 Redis 的支援。 Redis 是一款廣泛使用的記憶體鍵值資料庫。您可以瀏覽鍵和資料(包括雜湊表、清單和集合),並直接從 SQL Commander 執行 Redis 命令,從而提高您使用 Redis 資料庫的效率。 DbVisualizer 同時支援普通鍵視圖和層級鍵視圖。

使用結果集

此版本對資料網格進行了重大改進,包括改進了值和記錄視圖、快速聚合以及改進了對唯讀結果集的支援。

價值、記錄和聚合視圖

現在,借助結果網格右側新增的側邊欄,處理大型表格和複雜資料物件(例如影像 BLOB 和 JSON)變得更加便捷。這簡化了資料網格中與值、行和統計資訊的交互,取代了先前使用的浮動視窗。

快速聚合

「聚合」視圖顯示目前所選資料的全面統計資料。為了加快分析速度,狀態列中新增了一個聚合指示器,允許使用者選擇最多三個指標進行跟踪,而無需打開「聚合」視圖。

只讀結果集

通常情況下,結果集中的資料可以編輯,並且變更可以直接套用到資料庫。但根據底層查詢的不同,有時可能無法做到這一點。對於這些情況,現在有一個專門的指示器來解釋為什麼不允許編輯。

改進的資料庫支持

對Denodo的支持

DbVisualizer 25.2 為 Denodo 平台新增了基本的資料庫支援。使用驅動程式管理員中包含的驅動程式即可輕鬆上手。

denodo 標誌

在 Snowflake 中解釋計劃

新版本透過添加樹狀和圖狀執行計劃視圖擴展了對 Snowflake 的支持,從而更容易分析查詢效能。

H2 中的 JSON 值

透過增加對 JSON 值的支持,擴展了與 H2 的整合。

各方面都有更多改進。

擴充自動完成功能

自動補全功能變得更加智能,能夠補全目錄和模式名稱,並在必要時自動添加標識符的引號。此外,它還能更好地處理區分大小寫的資料庫,從而支援更進階的使用場景。

資料庫驅動程式自動下載

首次使用驅動程式時,必要的 Maven 工件將自動下載,更容易上手。

測試連接

資料庫連線測試變得更加便捷和全面。其中,支援 SSH 隧道和基於檔案的資料庫等多種連接方式。

支援透過命令列更改連接

現在可以使用 dbviscmd 來變更現有資料庫連線中的密碼和使用者 ID,從而簡化集中管理場景中的自動化。

安全性更新

與 DbVisualizer 的功能版本更新一樣,本次更新包含了第三方相依性和範本驅動程式的最新安全性升級。

 

版本比較

系統需求

System Requirements:

OS Support:

Windows 64-bit 11/10/8/7
Linux
macOS 10.11+

Windows 64-bit: Java 17 is required
macOS: Java 17 is required
Linux: Java 17 is required
至少需要2GB RAM
300MB 磁碟空間