Database administration

database automationadministrationDBA
Navigational database. Network model. Object model. Object database (OODBMS). Object-relational database (ORDBMS). Run Book Automation (RBA). Relational model (RDBMS). Comparison of relational database management systems. Comparison of database tools. SQL is a language for database management.

Presto (SQL query engine)

Presto
Presto offers connectors to data sources including files in Alluxio, Hadoop Distributed File System, Amazon S3, MySQL, PostgreSQL, Microsoft SQL Server, Amazon Redshift, Apache Kudu, Apache Phoenix, Apache Kafka, Apache Cassandra, Apache Accumulo, MongoDB and Redis. Unlike other Hadoop distribution-specific tools, such as Apache Impala, Presto can work with any flavor of Hadoop or without it. Presto supports separation of compute and storage and may be deployed both on premises and in the cloud. Presto Software Foundation website. Facebook Presto website.

CLSQL

CLSQL is an SQL database interface for Common Lisp. It was created in 2001 by Kevin M. Rosenberg, and initially based substantially on the MaiSQL package by Pierre R. Mai. After being orphaned by onShore Development, Marcus Pearce ported the UnCommonSQL package to CLSQL, which provides a CommonSQL-compatible API for CLSQL. CLSQL can be used to query and interface with MySQL, PostgreSQL, ODBC, AODBC, SQLite version 2 and 3, and Oracle OCI. * Official git repo

Flyway (software)

Flyway
Supported databases are Oracle, SQL Server, DB2, MySQL (including Amazon RDS, Aurora MySQL, MariaDB), Percona XtraDB, PostgreSQL (including Amazon RDS and Heroku), Aurora PostgreSQL, CockroachDB, Redshift, Informix, H2, Hsql, Derby, SQLite, SAP HANA, Sybase ASE, Phoenix and Firebird. Flyway received 11,500,000 downloads in 2018 alone. In January 2015, Flyway was placed in the "Adopt" section of the Thoughtworks Technology Radar. In June 2019, Flyway was acquired by Redgate * Liquibase * Flyway Home

Oracle TopLink

TopLinkTopLink Essentials
Extensive mapping support using relational, object-relational data type and XML. Advanced query capability including native SQL, Java Persistence Query Language (JPQL) and EclipseLink Expressions framework. RESTful Services. Just-in-time reading. Tenant Isolation. NoSQL. Various Optimistic and pessimistic locking policies and options. JSON. Integration with commonly used application servers and databases. External Metadata Sources. TopLink Grid. Oracle JDeveloper. Oracle Enterprise Pack for Eclipse. Eclipse. NetBeans. EclipseLink. Hibernate (framework). Apache Cayenne. IBATIS. Oracle TopLink Official Home. Oracle TopLink Quick Tour. Oracle TopLink Forum. Oracle TopLink Wiki.

TOra

TOra (Toolkit for Oracle) is a free software database development and administration GUI, available under the GNU General Public License. It features a PL/SQL debugger, an SQL worksheet with syntax highlighting, a database browser and a comprehensive set of database administration tools. In addition to Oracle Database support, support for MySQL, PostgreSQL and Teradata databases has been added since the initial launch. It uses the Qt, and can use the qScintilla2 library. The Oracle connector uses the Oracle Template Library. TOra was originally written by Henrik Johnson and copyright by GlobeCom AB, which was acquired by Quest Software.

NeoLoad

It monitors the newest web, database and application servers such as JBoss application server, HP-UX 11, Weblogic, WebSphere, Apache Tomcat, and MySQL database. Its "scripts" are developed via a GUI, which provides conditions, loops, and other programming structures. JavaScript may be inserted for more advanced uses, such as password encryption. It supports basic, digest, NTLM and form-based authentication. It can record HTTPS requests, play them back and supports client certificate authentication. It supports ActiveX components as long as communication with the server is via the HTTP protocol.

Query Abstraction Layer

QAL (Query Abstraction Layer)
Sources and destinations include different database backends, file formats like, XML and spreadsheets. Even untidy HTML web pages can be used as both a source and destination. For, it has a database abstraction layer that supports basic connectivity to Postgres, MySQL / MariaDB, DB2, Oracle and MS SQL Server. It uses XML formats (the SQL schema is self-generated) for representation of queries, transformation and merging, making it all processable by scripts. With regards to SQL, QAL uses a subset of SQL features and data types, which while obviously not complete however is sufficient for most usages.

Truncate (SQL)

TRUNCATE TABLETRUNCATE
In Microsoft SQL Server 2000 and beyond in full recovery mode, every change to the database is logged, so statements can be used for tables involved in log shipping. IBM Db2 supports in 9.7 or later.

DatabaseSpy

PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1, 9.4. Oracle 9i, 10g, 11g, 12c. MySQL 5, 5.1, 5.5, 5.6. IBM DB2 8, 9.1, 9.5, 9.7, 10.1, 10.5. IBM DB2 for iSeries v6.1, 7.1. Informix 11.70. Sybase ASE 15. Microsoft Access 2003, 2007, 2010, 2013. SQLite 3.x. Firebird 2.5. Progress OpenEdge 11.6. And others. Altova website. Altova blog.

LogicalDOC

Multiple Database support: MySQL, PostgreSQL, Oracle, Microsoft SQL Server. Documents full preview. Integrated OCR and Barcode recognition. Integrated TWAIN scanner support. Clustering support. Infoworld Bossie Awards 2010 in category: best open source applications. CMS Critic Awards 2016 in category: Best Document Management System. Document Management. List of content management systems. List of collaborative software.

WebORB Integration Server

It is used in SOA/Rich Internet Application development projects to connect browser clients (Adobe Flex, Adobe Flash, AJAX, Java, .NET, Silverlight, JSON) and mobile clients (Android, Windows Phone 7, BlackBerry PlayBook) with backend services (.NET, Java, PHP and Ruby on Rails) and databases (MySQL, Microsoft SQL Server, SQL Azure, PostgreSQL, ODBC and Oracle database). It combines technologies that provide developer productivity tools, AMF remoting, real time messaging, code-level security and real time streaming media.

Apache Empire-db

Apache Empire DBEmpire-db
Apache Empire-db is a Java library that provides a high level object-oriented API for accessing relational database management systems (RDBMS) through JDBC. Apache Empire-db is open source and provided under the Apache License 2.0 from the Apache Software Foundation. Compared to Object-relational mapping (ORM) or other data persistence solutions such as Hibernate, iBATIS or TopLink Empire-db does not use XML files or Java annotations to provide a mapping of plain (old) Java object (POJO's) to database tables, views and columns.

DUAL table

Beginning with 10g Release 1, Oracle no longer performs physical or logical I/O on the DUAL table, though the table still exists. DUAL is readily available for all the users in database. Several other databases (including Microsoft SQL Server, MySQL, PostgreSQL, SQLite, and Teradata) enable one to omit the FROM clause entirely if no table is needed. This avoids the need for any dummy table. ( What is the Oracle equivalent of “Dual” table in SqlServer?) Firebird has a one-row system table RDB$DATABASE that is used in the same way as Oracle's DUAL, although it also has a meaning of its own. IBM DB2 has a view that resolves DUAL when using Oracle Compatibility.

Sqlmap

In addition to mapping and detecting vulnerabilities, the software enables access to the database, editing and deleting data, and viewing data in tables such as users, passwords, backups, phone numbers, e-mail addresses, credit cards and other confidential and sensitive information. sqlmap has full support for multiple DBMSs, including MySQL, Oracle, PostgreSQL, Microsoft SQL Server, Microsoft Access, IBM DB2, SQLite, Firebird and SAP MaxDB. And full support for all injection techniques: Boolean, Error, Stack, Time, Union.

Django (web framework)

DjangoDjango web frameworkDjango framework
Django officially supports four database backends: PostgreSQL, MySQL, SQLite, and Oracle. Microsoft SQL Server can be used with django-mssql on Microsoft operating systems, while similarly external backends exist for IBM Db2, SQL Anywhere and Firebird. There is a fork named django-nonrel, which supports NoSQL databases, such as MongoDB and Google App Engine's Datastore. Django may also be run in conjunction with Jython on any Java EE application server such as GlassFish or JBoss. In this case django-python must be installed in order to provide JDBC drivers for database connectivity, which also can provide functionality to compile Django in to a .war suitable for deployment.

List of PHP extensions

free and open-source libraries
MS-SQL. mSQL. muscat. MySQL. Ncurses. ODBC. OpenSSL. Oracle. Ovrimos SQL. PayFlow Pro. PDF. PDO. Phalcon. POSIX. PostgreSQL. Printer. Pspell. QT-Dom. GNU Readline. GNU Recode. Regular expressions. Semaphores. SESAM. Session Handling. Shared memory. SMTP. SNMP. SimpleXML. Sockets. SQLite. Streams. Sybase. Token. vpopmail. WDDX. Win32 API. xajax. XML (Xpath). XML-RPC. XSLT. YAZ. Yellow pages / NIS. ZIP. Zlib. Wjs.

IBM WebSphere Application Server Community Edition

Community EditionWebsphere Application Server Community EditionWebSphere AS Community Edition
Other difference from Apache Geronimo is that WASCE comes with DB2 and Informix database drivers, better XML parser libraries (XML4J and XLXP) and contains the latest patches from unreleased upstream versions. Over 30 WASCE developers are committers in the Apache Geronimo project. IBM announced that September 20, 2013, WASCE will be withdrawn from marketing and support will be withdrawn September 30, 2016. Java EE 6 programming model. Eclipse plug-in for developers. Embedded Apache Derby database. External database support for IBM DB2, Informix, Oracle, Microsoft SQL Server, PostgreSQL and MySQL.

Hint (SQL)

hintshint
Postgres Plus® Advanced Server (a proprietary version of PostgreSQL from EnterpriseDB) offers hints compatible with those of Oracle. Microsoft SQL Server offers hints via the OPTION keyword. Query optimizer. Query plan.

Pivot table

pivot tablespivotingPivot
Database support. PostgreSQL, an object-relational database management system, allows the creation of pivot tables using the tablefunc module. MariaDB, a MySQL fork, allows pivot tables using the CONNECT storage engine. Microsoft Access supports pivot queries under the name "crosstab" query. Oracle database supports the PIVOT operation. Some popular databases that do not directly support pivot functionality, such as Microsoft SQL server and SQLite can usually simulate pivot functionality using embedded functions, dynamic SQL or subqueries.

IP address management

IPAM
IP address management (IPAM) is a methodology implemented in computer software for planning and managing the assignment and use of IP addresses and closely related resources of a computer network. It does not typically provide Domain Name System (DNS) and Dynamic Host Configuration Protocol (DHCP) services, but manages information for these components.

Quick Objects

*List of object-relational mapping software * Microsoft SQL Server / SQL CE. Microsoft Access. Oracle. MySQL. VistaDB.

ADOdb

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. ADOdb supports the following databases: In addition to the Database Abstraction Layer, ADOdb includes the following features: * ActiveX Data Objects. Firebird. Foxpro. FrontBase. IBM DB2. Informix. Interbase. Lightweight Directory Access Protocol (LDAP). Microsoft Access. Microsoft SQL Server. MySQL. Netezza. Oracle database.

Pervasive PSQL

Pervasive.SQL or PSQLrelational database engine
The second database engine, the SQL Relational Database Engine or SRDE, operates in a manner similar to other relational database engines, that is, through the support of Structured Query Language queries. SRDE parses SQL queries and sends them to the MKDE to run. The SRDE implements SQL-92. Significant other features include relational integrity, database security, and temporary tables. SRDE extends its functionality by supporting stored procedures, user-defined functions, and triggers. In addition to its support for SQL-92, the SRDE supports several significant features of COBOL: COBOL data types and COBOL OCCURS and VARIANT records.

Bulk Copy Program

Bulk Copy Program (BCP) is a command-line tool used to import or export data against a Microsoft SQL Server or Sybase database. The tool is often more efficient than more recent GUI-based applications, such as DTS, to import and extract data. Some common uses of BCP are: Stage a raw text file in a table for further data scrubbing. Create a delimited or fixed-width file for exchange with another party. Backup data from a database vendor specific format, to a common text format. Oracle uses SQL*LOADER, implemented on the command-line as. DB2 uses the LOAD/EXPORT commands. MySQL uses LOAD DATA INFILE. PostgreSQL uses the COPY command.