|
Comparison Of Database Tools
The following tables compare general and technical information for a number of available database administration tools. Please see individual product articles for further information. This article is neither all-inclusive nor necessarily up to date. Systems listed on a light purple background are no longer in active development. General Features Legend * User Interface: ** Browser based - executes on a Server (computing), computer server and is accessed via a computer network, network using a web browser ** desktop - executes on a personal computer * Create/alter table: ** Yes - can create table, alter its definition and data, and add new rows ** Some - can only create/alter table definition, not data * Browse table: ** Yes - can browse table definition and data ** Some - can only browse table definition * Multi-server support: ** Yes - can manage from the same window/session multiple servers ** Some - can manage from a different window/session multiple servers * Monitoring s ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Database Administration
Database administration is the function of managing and maintaining database management systems (DBMS) software. Mainstream DBMS software such as Oracle, IBM Db2 and Microsoft SQL Server need ongoing management. As such, corporations that use DBMS software often hire specialized information technology personnel called database administrators or DBAs. Responsibilities * Installation, configuration and upgrading of Database server software and related products. * Evaluate Database features and Database related products. * Establish and maintain sound backup and recovery policies and procedures. * Take care of the Database design and implementation. * Implement and maintain database security (create and maintain users and roles, assign privileges). * Database tuning and performance monitoring. * Application tuning and performance monitoring. * Setup and maintain documentation and standards. * Plan growth and changes ( capacity planning). * Work as part of a team and pr ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Microsoft Access
Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational database, relational Access Database Engine (ACE) with a graphical user interface and software-development tools. It is a member of the Microsoft 365 suite of applications, included in the Professional and higher editions or sold separately. Microsoft Access stores data in its own format based on the Access Database Engine (formerly Jet Database Engine). It can also import or link directly to data stored in other applications and databases. Software developers, data architects and power users can use Microsoft Access to develop application software. Like other Microsoft Office applications, Access is supported by Visual Basic for Applications (VBA), an object-based programming language that can reference a variety of objects including the legacy DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components. Visual objects used in forms and reports expose thei ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Redis
Redis (; Remote Dictionary Server) is an in-memory key–value database, used as a distributed cache and message broker, with optional durability. Because it holds all data in memory and because of its design, Redis offers low- latency reads and writes, making it particularly suitable for use cases that require a cache. Redis is the most popular NoSQL database, and one of the most popular databases overall. The project was developed and maintained by Salvatore Sanfilippo, starting in 2009. From 2015 until 2020, he led a project core team sponsored by Redis Ltd. Salvatore Sanfilippo left Redis as the maintainer in 2020. In 2021 Redis Labs dropped the Labs from its name and now is known simply as "Redis". In 2018, some modules for Redis adopted a modified Apache 2.0 with a Commons Clause. In 2024, the main Redis code switched from the open-source BSD-3 license to being dual-licensed under the Redis Source Available License v2 and the Server Side Public License v1. On May ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Apache Derby
Apache Derby (previously distributed as IBM Cloudscape) is a relational database management system (RDBMS) developed by the Apache Software Foundation that can be embedded in Java programs and used for online transaction processing. It has a 3.5 MB disk-space footprint. Apache Derby is developed as an open source project under the Apache 2.0 license. For a time, Oracle distributed the same binaries under the name Java DB. In June 2015 they announced that for JDK 9 they would no longer be doing so. History Apache Derby originated at Cloudscape Inc, an Oakland, California, start-up founded in 1996 by Nat Wyatt and Howard Torf to develop Java database technology. The first release of the database engine, then called JBMS, was in 1997. Subsequently, the product was renamed Cloudscape and releases were made about every six months. In 1999, Informix Software, Inc., acquired Cloudscape, Inc. In 2001 IBM acquired the database assets of Informix Software, including Cloudscape. The d ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Amazon Redshift
Amazon Redshift is a data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services. It is built on top of technology from the massive parallel processing (MPP) data warehouse company ParAccel (later acquired by Actian), to handle large scale data sets and database migrations. Redshift differs from Amazon's other hosted database offering, Amazon RDS, in its ability to handle analytic workloads on big data data sets stored by a column-oriented DBMS principle. Redshift allows up to 16 petabytes of data on a cluster. Redshift uses parallel processing and compression to decrease command execution time. Amazon Redshift is based on an older version of PostgreSQL 8.0.2, and Redshift has made changes to that version. An initial preview beta was released in November 2012 and a full release was made available on February 15, 2013. Amazon has listed a number of business intelligence software proprietors as partners and tested tools in their " ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Hypersonic SQL
HSQLDB (''Hyper SQL Database'') is a relational database management system written in Java. It has a JDBC driver and supports a large subset of SQL-92, SQL:2008, SQL:2011, and SQL:2016 standards. It offers a fast, small (around 1300 kilobytes in version 2.2) database engine which offers both in-memory and disk-based tables. Both embedded and server modes are available. Additionally, it includes tools such as a minimal Web server, command line and GUI management tools (can be run as applets), and a number of demonstration examples. It can run on Java runtimes from version 1.1 upwards, including free Java implementations such as Kaffe. HSQLDB is available under a BSD license. It is used as a database and persistence engine in many open source software projects, such as descendants of OpenOffice.org Base (i.e., Apache OpenOffice Base, LibreOffice Base, etc.), and the Jitsi VoIP and video-conference client since version 2.6. It is also used in commercial products, such as ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
H2 (DBMS)
H2 is a relational database management system written in Java. It can used as an embedded database in Java applications or run in client–server mode. The software is available as open source software Mozilla Public License 2.0 or the original Eclipse Public License. History The development of the H2 database engine started in May 2004, and first published in December 2005. The database engine was written by Thomas Mueller. He also developed the Java database engine Hypersonic SQL. In 2001, the Hypersonic SQL project was stopped, and the HSQLDB Group was formed to continue work on the Hypersonic SQL code. The name H2 stands for Hypersonic 2, however H2 does not share code with Hypersonic SQL or HSQLDB. H2 is built from scratch. Version 2.0.x was released in January 2022. Features A subset of the SQL (Structured Query Language) standard is supported. The main programming APIs are SQL and JDBC, however the database also supports using the PostgreSQL ODBC driver by acting like ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
DataGrip
JetBrains s.r.o. (formerly IntelliJ Software s.r.o.) is a Czech software development private limited company which makes tools for software developers and project managers. The company has its headquarters in Amsterdam, and has offices in China, Europe, and the United States. Jetbrains offers a variety of integrated development environments (IDEs), such as IntelliJ IDEA, PyCharm, WebStorm and CLion. It also created in 2011 the Kotlin programming language, which can run in a Java virtual machine (JVM). ''InfoWorld'' magazine awarded the firm "Technology of the Year Award" in 2011 and 2015. History JetBrains, initially called IntelliJ Software, was founded in 2000 in Prague by three Russian software developers: Sergey Dmitriev, Valentin Kipyatkov and Eugene Belyaev. The company's first product was IntelliJ Renamer, a tool for code refactoring in Java. In 2012 CEO Sergey Dmitriev was replaced by Oleg Stepanov and Maxim Shafirov. In 2021 ''The New York Times'' stated th ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Delphi (software)
Delphi is a general-purpose programming language and a software product that uses the Delphi dialect of the Object Pascal programming language and provides an integrated development environment (IDE) for rapid application development of desktop, mobile, web, and console software, currently developed and maintained by Embarcadero Technologies. Delphi's compilers generate native code for Microsoft Windows, macOS, iOS, Android and Linux ( x64). Delphi includes a code editor, a visual designer, an integrated debugger, a source code control component, and support for third-party plugins. The code editor features Code Insight (code completion), Error Insight (real-time error-checking), and refactoring. The visual forms designer has the option of using either the Visual Component Library (VCL) for pure Windows development or the FireMonkey (FMX) framework for cross-platform development. Database support is a key feature and is provided by FireDAC (Database Access Components). D ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
MariaDB
MariaDB is a community-developed, commercially supported Fork (software development), fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License. Development is led by some of the original developers of MySQL, who forked it due to concerns over its takeover, acquisition by Oracle Corporation in 2009, but in 2024 MariaDB plc was itself bought by the K1 private equity group, which appointed a new CEO. MariaDB is intended to maintain high compatibility with MySQL, with exact matching with MySQL Application programming interface, APIs and commands, allowing it in many cases to function as a drop-in replacement for MySQL. However, new features are diverging. It includes new storage engines like Aria (storage engine), Aria, InfiniDB, ColumnStore, and MyRocks. Its CTO is Michael Widenius, Michael "Monty" Widenius, one of the founders of MySQL AB and the founder of Monty Program AB. On 16 January ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
NexusDB
NexusDB is a relational commercial database engine for the Delphi, C++ Builder and .NET programming languages created by NexusDB Pty Ltd. It was developed as a successor to the TurboPower FlashFiler system for Delphi (still available for free download {{As of, 2017, lc=on). The database engine supports the SQL:2003 standard alongside Core SQL Structured Query Language (SQL) (pronounced ''S-Q-L''; or alternatively as "sequel") is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling s ... functionality as well as direct cursor based data access. NexusDB also provides database connectors for easy access from various development and application environments: * ADO.NET Provider for Visual Studio; supports Windows, Android, iOS, MacOSX targets * ODBC/CLI Driver for Windows * PHP Connector for Windows The website has a Client/Server trial edition and an online manual. A free vers ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Firebird (database Server)
Firebird and fire bird may refer to: Mythical birds * Phoenix (mythology), sacred firebird found in the mythologies of many cultures ** Fenghuang, sometimes called Chinese phoenix * Vermilion bird, one of the four symbols of the Chinese constellation representing fire * Bennu, Egyptian firebird * Huma bird, Persian firebird * Firebird (Slavic folklore) Automobiles * Pontiac Firebird, American pony car * General Motors Firebird, series of concept cars Aviation * AAM-A-1 Firebird, an American air-to-air missile of the 1940s * Chengdu J-10 (NATO reporting name: Firebird), a Chinese combat aircraft * Northrop Grumman Firebird, an American recon/surveillance aircraft * CargoLogicAir, a defunct British airline (callsign: FIREBIRD) Film and television * ''Firebird'' (film), a 2021 film directed by Peeter Rebane * ''The Firebird'' (1934 film), a murder mystery directed by William Dieterle * ''The Firebird'' (1952 film), a musical drama film directed by Hasse Ekman * "Fireb ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
