Navicat

This is a standalone product for developers to create data models for MySQL, SQL Server, Oracle, PostgreSQL and SQLite databases. Navicat Data Modeler allows users to visually design database structures, perform reverse/forward engineer process, import table structures from ODBC data sources, generate SQL files and print models to files, etc. In June 2015, added the support of MariaDB databases and several features such as Model Conversion, Physical/Logical/Conceptual model types and Navicat Cloud. In August 2014, PremiumSoft released a new product - Navicat iOS.

Prepared statement

bind variableparameterised queriesparameterized queries
Major DBMSs, including MySQL, Oracle, DB2, Microsoft SQL Server and PostgreSQL widely support prepared statements. Prepared statements are normally executed through a non-SQL binary protocol for efficiency and protection from SQL injection, but with some DBMSs such as MySQL prepared statements are also available using a SQL syntax for debugging purposes. A number of programming languages support prepared statements in their standard libraries and will emulate them on the client side even if the underlying DBMS does not support them, including Java's JDBC, Perl's DBI, PHP's PDO and Python's DB-API.

ADO.NET data provider

ADO.NET Providerdata providers
ADO.NET data providers are analogous to ODBC drivers, JDBC drivers, and OLE DB providers. ADO.NET providers can be created to access such simple data stores as a text file and spreadsheet, through to such complex databases as Oracle Database, Microsoft SQL Server, MySQL, PostgreSQL, SQLite, IBM DB2, Sybase ASE, and many others. They can also provide access to hierarchical data stores such as email systems. However, because different data store technologies can have different capabilities, every ADO.NET provider cannot implement every possible interface available in the ADO.NET standard.

Snapshot isolation

serializable snapshot isolationtransaction snapshots
In databases, and transaction processing (transaction management), snapshot isolation is a guarantee that all reads made in a transaction will see a consistent snapshot of the database (in practice it reads the last committed values that existed at the time it started), and the transaction itself will successfully commit only if no updates it has made conflict with any concurrent updates made since that snapshot. Snapshot isolation has been adopted by several major database management systems, such as InterBase, Firebird, Oracle, MySQL, PostgreSQL, SQL Anywhere, MongoDB and Microsoft SQL Server (2005 and later).

QUEL query languages

QUELIngres QUELPOSTQUEL query language
QUEL is a relational database query language, based on tuple relational calculus, with some similarities to SQL. It was created as a part of the Ingres DBMS effort at University of California, Berkeley, based on Codd's earlier suggested but not implemented Data Sub-Language ALPHA. QUEL was used for a short time in most products based on the freely available Ingres source code, most notably in an implementation called POSTQUEL supported by POSTGRES. As Oracle and DB2 gained market share in the early 1980s, most companies then supporting QUEL moved to SQL instead.

Data definition language

DDLdata definitionCREATE
Select (SQL). Insert (SQL). Update (SQL). Delete (SQL). Truncate (SQL). Oracle ALTER TABLE MODIFY column. DDL Commands In Oracle.

PL/SQL

PLSQLMetatranz StepSqlitePL/SQL (Oracle)
T-SQL. SQL PL. SQL/PSM. Relational database management systems. Oracle FAQ: PL/SQL. Oracle Technology Center. Oracle Tahiti Search Engine. Morgan's Library. ORACLE-BASE: PL/SQL Articles.

Stored procedure

stored proceduresproceduresdatabase procedures
Stored Procedures in MySQL FAQ. An overview of PostgreSQL Procedural Language support. Using a stored procedure in Sybase ASE. PL/SQL Procedures. Oracle Database PL/SQL Language Reference. SAP HANA SQLScript Reference.

Select (SQL)

SELECTSQL query keyword
By introducing SQL window function to the SELECT-statement. {rows} = Number of rows in a page. {page_number} = Number of the current page. {begin_base_0} = Number of the row - 1 where the page starts = (page_number-1) * rows. Windowed Tables and Window function in SQL, Stefan Deßloch. Oracle SELECT Syntax. Firebird SELECT Syntax. Mysql SELECT Syntax. Postgres SELECT Syntax. SQLite SELECT Syntax.

SQL/PSM

Persistent Stored Modules
Oracle developed PL/SQL and released it in 1991, basing the language on the US Department of Defense's Ada programming language. However, Oracle has maintained a distance from the standard in its documentation. IBM's SQL PL (used in DB2) and Mimer SQL's PSM were the first two products officially implementing SQL/PSM. It is commonly thought that these two languages, and perhaps also MySQL/MariaDB's procedural language, are closest to the SQL/PSM standard. However, a PostgreSQL addon implements SQL/PSM (alongside its other procedural languages like the PL/SQL-derived plpgsql), although it is not part of the core product.

HTSQL

Hyper Text Structured Query Language (HTSQL) is a schema-driven URI-to-SQL query language that takes a request over HTTP, converts it to a SQL query, executes the query against a database, and returns the results in a format best suited for the user agent (CSV, HTML, etc.) The HTSQL language is implemented on "HTSQL servers," which use HTSQL to convert web requests into equivalent SQL, executes requests on a server-side database, and returns results in XML, HTML, CSV, JSON, or YAML formats. The current implementation as of April 2010 uses Python and works with PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server databases.

Data manipulation language

DMLData Manipulation Language (DML)manipulation
A data manipulation language (DML) is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database. A DML is often a sublanguage of a broader database language such as SQL, with the DML comprising some of the operators in the language. Read-only selecting of data is sometimes distinguished as being part of a separate data query language (DQL), but it is closely related and sometimes also considered a component of a DML; some operators may perform both selecting (reading) and writing. A popular data manipulation language is that of Structured Query Language (SQL), which is used to retrieve and manipulate data in a relational database.

Online analytical processing

OLAPROLAPMOLAP
The Microsoft SQL Server 7.0 OLAP Services supports a hybrid OLAP server Each type has certain benefits, although there is disagreement about the specifics of the benefits between providers. The following acronyms are also sometimes used, although they are not as widespread as the ones above: Unlike relational databases, which had SQL as the standard query language, and widespread APIs such as ODBC, JDBC and OLEDB, there was no such unification in the OLAP world for a long time. The first real standard API was OLE DB for OLAP specification from Microsoft which appeared in 1997 and introduced the MDX query language. Several OLAP vendors – both server and client – adopted it.

SQL injection

SQL injection attack SQL injection attacksBlind SQL injection
Therefore, without parameterized queries, anyone could put any kind of SQL code into the field, and have the database erased. But if the parameters were to set to '@username' then the person would only be able to put in a username without any kind of code. Using object-relational mapping libraries avoids the need to write SQL code. The ORM library in effect will generate parameterized SQL statements from object-oriented code. A straightforward, though error-prone way to prevent injections is to escape characters that have a special meaning in SQL.

Sphinx (search engine)

Sphinx
Direct indexing of SQL databases. Native support for MySQL, MariaDB, PostgreSQL, MSSQL, plus ODBC connectivity. XML document indexing support. Distributed searching support out-of-the-box. Integration via access APIs. SQL-like syntax support via MySQL protocol (since 0.9.9). Full-text searching syntax. Database-like result set processing. Relevance ranking utilizing additional factors besides standard BM25. Text processing support for SBCS and UTF-8 encodings, stopwords, indexing of words known not to appear in the database ("hitless"), stemming, word forms, tokenizing exceptions, and "blended characters" (dual-indexing as both a real character and a word separator).

List of TCP and UDP port numbers

well-known portportwell-known ports
This is a list of TCP and UDP port numbers used by protocols of the Internet protocol suite for operation of network applications.

PyQt

PyQt5PyQt4Python
. * * Tutorial a substantial set of GUI widgets. classes for accessing SQL databases (ODBC, MySQL, PostgreSQL, Oracle, SQLite). QScintilla, Scintilla-based rich text editor widget. data aware widgets that are automatically populated from a database. an XML parser. SVG support. classes for embedding ActiveX controls on Windows (only in commercial version). The QtCore module contains the core non-GUI classes, including the event loop and Qt's signal and slot mechanism. It also includes platform independent abstractions for Unicode, threads, mapped files, shared memory, regular expressions, and user and application settings. The QtGui module contains the majority of the GUI classes.

SQLObject

SQLObject is a Python object-relational mapper between a SQL database and Python objects. It is experiencing community popularity, and forms a part of many applications (e.g., TurboGears). It is very similar to Ruby on Rails' ActiveRecord in operation in that it uses class definitions to form table schemas, and utilizes the language's reflection and dynamism to be useful. SQLObject supports a number of common database backends: included in the distribution are MySQL, PostgreSQL, SQLite, Sybase SQL Server, MaxDB, Microsoft SQL Server and Firebird. The first version of SQLObject was publicly released in October 2002. * TurboGears. SQLAlchemy. Storm.

Outline of databases

outline
Database abstraction layer – application programming interface which unifies the communication between a computer application and databases such as SQL Server, DB2, MySQL, PostgreSQL, Oracle or SQLite. Object-relational mapping (ORM, O/RM, and O/R mapping) – in computer software is a programming technique for converting data between incompatible type systems in object-oriented programming languages. Database virtualization – it is the decoupling of the database layer, which lies between the storage and application layers within the application stack. Database tuning – describes a group of activities used to optimize and homogenize the performance of a database.

Virtual column

Virtual Columns in Oracle Database 11g Release 1. Computed Columns in SQL Server 2008.

PhpCodeGenie

It can communicate with multiple databases such as: MySQL, PostgreSQL, ODBC, SQLite, Oracle, DB2, MS SQL Server, MaxDB, Visual FoxPro, FrontBase, InterBase, Firebird, Informix, LDAP, Netezza, SAP DB, Sybase, and generate code from them. * Comparison of web frameworks PHPCodeGenie Sourceforge site. (401 KiB). List of opensource software from Nilesh Dosooye. PHPCodeGenie profile in Code Generation Network. PHPCodeGenie profile in FSF/Unesco Free Software Directory.

IBM

International Business MachinesIBM CorporationInternational Business Machines Corporation
IBM has also released code under different open source licenses, such as the platform-independent software framework Eclipse (worth approximately US$40 million at the time of the donation), the three-sentence International Components for Unicode (ICU) license, and the Java-based relational database management system (RDBMS) Apache Derby. IBM's open source involvement has not been trouble-free, however (see SCO v. IBM).

Data Moving Tool

DMT supports any ODBC compliant database, e.g. Oracle, SQL Server, Sybase, IBM DB2 / Informix, MySQL, MS Access and many more including old ones (Visual FoxPro, DBase, etc.) * Official website Run SQL statements or stored procedures. Execute external programs (i.e. run a command line). Upload or download files via FTP. Send emails (with attachment containing exported or loaded data). Check the result of an SQL statement. Check the presence or content of a file.

World Programming System

World Programming System (WPS Analytics)World Programming System (WPS)WPS Analytics
Access: Actian Matrix (previously known as ParAccel), DASD, DB2, Greenplum, Hadoop, Informix, Kognitio, MySQL, Netezza, ODBC, OLEDB, Oracle, PostgreSQL, SAND, SPSS/PSPP, SQL Server, Sybase, Sybase IQ, Teradata, VSAM, Vertica and XML. Support for SAS Tape Format. Direct output of reports to CSV, PDF and HTML. Support to connect WPS systems programmatically, remote submit parts of a program to execute on connected remote servers, upload and download data between the connected systems. Support for Hadoop. Support for R. Support for Python.

Merge (SQL)

MERGEupsertSQL Merge
Join (SQL). join (Unix). Oracle 11g Release 2 documentation on MERGE. Firebird 2.1 documentation on MERGE. DB2 v9 MERGE statement. Microsoft SQL Server documentation. HSQLdb 2.0 Data Change Statements. H2 (1.2) SQL Syntax page.