Database Workbench

Last updated
Database Workbench
Original author(s) Upscene Productions
Stable release
6.2.0 [1] / April 24, 2023;2 months ago (2023-04-24)
Operating system Windows
Type Database design, management, development
License Trialware
Website www.upscene.com/database_workbench/

Database Workbench is a software application for development and administration of multiple relational databases using SQL, with interoperationality between different database systems, developed by Upscene Productions.

Contents

Because Databases Workbench supports multiple database systems, it can provide software developers with the same interface and development environment for these otherwise different database systems and also includes cross database tools. [2] [3]

Development

Database Workbench started out as a developer tool specifically for InterBase, "InterBase Workbench", initially modeled after the SQL Navigator tool for Oracle Database by Quest Software. [4] [5] During its early years, InterBase became open-source for a short while, and soon after Firebird was created as a fork from the InterBase code base. The main developer of Database Workbench, Martijn Tonies, [6] was closely involved in the early development of Firebird, has been a committee member of the Firebird Foundation and continues to be a Foundation member and sponsor. [7]

Database Workbench continued to support both database systems, initially through a separate "Firebird Workbench" release. [8] Not long after, the program became interoperational between the different database systems and this initial support for multiple database systems led to the renaming of the product to its current title "Database Workbench" in 2003. It also opened the path to the inclusion of support for more database systems: support for Microsoft SQL Server and MySQL was added in 2003; in 2005, support for Oracle Database and NexusDB was added and SQL Anywhere support followed in 2008. Early 2010, a full Unicode version of Database Workbench was released and version 5 of Database Workbench was released in August 2014. [9] In December 2021, Database Workbench 6 was released with a revamped user interface including a more consistent look and feel and the multi-threaded loading of database metadata. This version introduced the Enterprise Edition with its TeamServer component. A free version with limited functionality, [10] Data Workbench Lite, based on Data Workbench 4 is also available. [11] [12] [13]

Supported databases and environments

Database Workbench supports the following relational databases: Oracle Database, Microsoft SQL Server, SQL Anywhere, Firebird, NexusDB, InterBase, MySQL, MariaDB and PostgreSQL [14] [15] [16] Version 6 of Database Workbench is a 64-bit application for Windows platforms, previous versions were 32-bit. [17] Under Linux, FreeBSD or Mac OS X Database Workbench can operate using Wine. [18]

Features

Database Workbench can be used to view, create and edit tables, indexes, stored procedures and other database meta data objects. It also supports: [19]

It includes several productivity features:

History

Related Research Articles

<span class="mw-page-title-main">MySQL</span> SQL database engine software

MySQL is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.

<span class="mw-page-title-main">PostgreSQL</span> Free and open-source relational database management system

PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley. In 1996, the project was renamed to PostgreSQL to reflect its support for SQL. After a review in 2007, the development team decided to keep the name PostgreSQL and the alias Postgres.

<span class="mw-page-title-main">IBM Db2</span> Relational model database server

Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON and XML. The brand name was originally styled as DB/2, then DB2 until 2017 and finally changed to its present form.

<span class="mw-page-title-main">Firebird (database server)</span> Relational database management system

Firebird is an open-source SQL relational database management system that supports Linux, Microsoft Windows, macOS and other Unix platforms. The database forked from Borland's open source edition of InterBase in 2000 but the code has been largely rewritten since Firebird 1.5.

An XML database is a data persistence software system that allows data to be specified, and sometimes stored, in XML format. This data can be queried, transformed, exported and returned to a calling system. XML databases are a flavor of document-oriented databases which are in turn a category of NoSQL database.

The following tables compare general and technical information for a number of relational database management systems. Please see the individual products' articles for further information. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs.

ADOdb is a database abstraction library for PHP, originally based on the same concept as Microsoft's ActiveX Data Objects. It allows developers to write applications in a consistent way regardless of the underlying database system storing the information. The advantage is that the database system can be changed without re-writing every call to it in the application.

<span class="mw-page-title-main">MySQL Workbench</span> Database design graphical tool

MySQL Workbench is a visual database design tool that integrates SQL development, administration, database design, creation and maintenance into a single integrated development environment for the MySQL database system. It is the successor to DBDesigner 4 from fabFORCE.net, and replaces the previous package of software, MySQL GUI Tools Bundle.

ER/Studio is data architecture and database design software developed by IDERA, Inc. ER/Studio is compatible with multiple database platforms and is used to create and manage database designs, as well as to document and reuse data assets. In 2015, Embarcadero Technologies was acquired by database and infrastructure management software company IDERA, Inc. Since the acquisition by IDERA, Inc., ER/Studio has been renamed to ER/Studio Data Architect with updated features.

In relational databases, the information schema is an ANSI-standard set of read-only views that provide information about all of the tables, views, columns, and procedures in a database. It can be used as a source of the information that some databases make available through non-standard commands, such as:

 => SELECT count(table_name) FROM information_schema.tables;  count   -------  99    => SELECT column_name, data_type, column_default, is_nullable  FROM information_schema.columns WHERE table_name='alpha';  column_name | data_type | column_default | is_nullable   -------------+-----------+----------------+-------------  foo | integer | | YES  bar | character | | YES    => SELECT * FROM information_schema.information_schema_catalog_name;  catalog_name   --------------  johnd
<span class="mw-page-title-main">Navicat</span> SQL database management software

Navicat is a series of graphical database management and development software produced by CyberTech Ltd. for MySQL, MariaDB, MongoDB, Oracle, SQLite, PostgreSQL and Microsoft SQL Server. It has an Explorer-like graphical user interface and supports multiple database connections for local and remote databases. Its design is made to meet the needs of a variety of audiences, from database administrators and programmers to various businesses/companies that serve clients and share information with partners.

An embedded database system is a database management system (DBMS) which is tightly integrated with an application software; it is embedded in the application. It is a broad technology category that includes:

A database shard, or simply a shard, is a horizontal partition of data in a database or search engine. Each shard is held on a separate database server instance, to spread load.

<span class="mw-page-title-main">Db4o</span>

db4o was an embeddable open-source object database for Java and .NET developers. It was developed, commercially licensed and supported by Actian. In October 2014, Actian declined to continue to actively pursue and promote the commercial db4o product offering for new customers.

<span class="mw-page-title-main">DatabaseSpy</span> SQL database profiling tool and GUI

DatabaseSpy is a multi-database query, design, and database comparison tool from Altova, the creator of XMLSpy. DatabaseSpy connects to many major relational databases, facilitating SQL querying, database structure design, database content editing, and database comparison and conversion.

<span class="mw-page-title-main">Couchbase Server</span> Open-source NoSQL database

Couchbase Server, originally known as Membase, is an open-source, distributed multi-model NoSQL document-oriented database software package optimized for interactive applications. These applications may serve many concurrent users by creating, storing, retrieving, aggregating, manipulating and presenting data. In support of these kinds of application needs, Couchbase Server is designed to provide easy-to-scale key-value, or JSON document access, with low latency and high sustainability throughput. It is designed to be clustered from a single machine to very large-scale deployments spanning many machines.

<span class="mw-page-title-main">Apache Drill</span> Open-source software framework

Apache Drill is an open-source software framework that supports data-intensive distributed applications for interactive analysis of large-scale datasets. Built chiefly by contributions from developers from MapR, Drill is inspired by Google's Dremel system, also productized as BigQuery. Drill is an Apache top-level project. Tom Shiran is the founder of the Apache Drill Project. It was designated an Apache Software Foundation top-level project in December 2016.

The following outline is provided as an overview of and topical guide to MySQL:

<span class="mw-page-title-main">DBeaver</span> Multi-platform database administration software

DBeaver is a SQL client software application and a database administration tool. For relational databases it uses the JDBC application programming interface (API) to interact with databases via a JDBC driver. For other databases (NoSQL) it uses proprietary database drivers. It provides an editor that supports code completion and syntax highlighting. It provides a plug-in architecture that allows users to modify much of the application's behavior to provide database-specific functionality or features that are database-independent. This is a desktop application written in Java and based on Eclipse platform.

References

  1. ↑ "Database Workbench 6.2.0 released". Upscene Productions. April 24, 2023. Retrieved 2023-06-24.
  2. ↑ Miguel van de Laar (Sep 12, 2010). "Database Workbench, productiviteits tool voor database ontwikkelaars en netwerkbeheerders". Blaise Pascal Magazine (in Dutch). DelphiGG (93). Retrieved 2014-09-19.
  3. ↑ Borrie, Helen (2004). "Appendix V: Administration Tools". The Firebird Book: A Reference for Database Developers . APress. p.  937. ISBN   1-59059-279-4 . Retrieved 2014-09-19. Database Workbench.
  4. ↑ Marco Cantù (2003). "Introducing InterBase". Mastering Delphi 7. SYBEX Inc. ISBN   078214201X . Retrieved 2014-09-23.
  5. ↑ Christian Ullenboom (2003). "20.5.1 Datenbank Interbase und Firebird". Java ist auch eine Insel (2. Aufl.) (in German). Galileo Press GmbH. ISBN   978-3-8362-2873-2 . Retrieved 2014-09-23.
  6. ↑ "About Us". Upscene Productions. Retrieved 2014-09-23.
  7. ↑ Matthew Hicks (Sep 2, 2004). "Mozilla Renames Browser, Revs New Releases". eWeek. Retrieved 2014-09-23.
  8. ↑ Sean Leyne. "FirebirdSQL Project Update" (PDF). IBPhoenix. Retrieved 2014-09-23.
  9. ↑ Martijn Tonies (Sep 3, 2014). "Database Workbench 5.0 now available". Firebird News. Retrieved 2014-09-19.
  10. ↑ "Database Workbench available editions and feature matrix". Upscene Productions. Retrieved 2016-01-06.
  11. ↑ Cristina Jitaru (Feb 18, 2014). "Database Workbench Lite for Firebird (Review)". Softpedia. Archived from the original on 2015-05-22. Retrieved 2014-09-19.
  12. ↑ "Database Workbench Lite for Firebird" (in Polish and Czech). Dobreprogramy. Aug 19, 2015. Retrieved 2016-01-06.
  13. ↑ Cristina Jitaru (Jun 26, 2015). "Database Workbench Lite for Firebird". Software.informer. Retrieved 2016-01-06.
  14. ↑ Roberto Jimenez. "Database Workbench Pro (Editorial Review)". Software Informer. Retrieved 2014-09-19.
  15. ↑ Astrid Wagner (13 August 2012). "Database Workbench 4.3.0 Pro mit Debugger für MySQL erhältlich" (in German). PHPmagazin. Retrieved 2014-09-23.
  16. ↑ Harald M. Genauck (14 August 2012). "Database Workbench 4.3.0 mit hilfreichen neuen Features" (in German). heise.de. Retrieved 2015-07-14.
  17. ↑ "Database Workbench Pro (Review)" (in French). commentcamarche.net. 5 May 2012. Retrieved 2014-09-23.
  18. ↑ "Running Database Workbench 5 under Wine, how to manuals". Upscene Productions. Sep 2014. Retrieved 2014-10-16.
  19. ↑ "Database Workbench learn how it's useful for you". Upscene Productions. Retrieved 2014-09-23.
This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.