A tag is a keyword or label that categorizes your question with other, similar questions. Using the right tags makes it easier for others to find and answer your question.
Improving the performance characteristics of a database application or system.
the non-transactional storage engine for MySQL. It provides high-speed storage and retrieval, as well as fulltext searching capabilities. In addition, it is the default storage engine type f…
Searching the text of a collection of documents or free text fields in a database to find those containing a word or combination of words.
the automated or semi-automated input of data sets between different software applications.
Procedural Language/Structured Query Language is Oracle Corporation's procedural language extension for SQL. IBM supports PL/SQL for DB2 since version 9.7. Questions about PL/SQL should probably be ta…
A situation caused by two or more processes being unable to proceed (and thus release their locks) because they are blocked by locks on resources held by the other process.
A popular open-source embeddable (i.e. non client-server) RDBMS implemented as a C library.
SQL Server 2017 (major build version 14.00.xxxx). Please also tag sql-server.
a Windows service installed with the SQL Server Standard Edition and above. It provides an automated way of executing or performing administrative task against a SQL Server instanc…
Combining multiple data points into a single data point. This usually is used in reference to SQL and usually to an aggregate function of some sort.
Specifies the type of data being stored (string, date, numeric, etc).
The automated distribution of transactional changes from a publishing database to one or more subscriber databases.
A visual database design tool developed by MySQL. It is the successor application of the DBDesigner4 project.
Oracle Database 10g (not 10g R2). Please also tag oracle for search purposes.
a desktop and server operating system based on Debian GNU/Linux. Note that http://askubuntu.com is specifically dedicated to Ubuntu questions.
A declarative mechanism such as a check or foreign key that enforces some data integrity rule in a database.
applies to questions about Relational Model theory. The Relational Model for database management is an approach to managing data using a structure and language consistent with fi…
A data structure that organizes information into rows and columns.
A database system optimised for reporting, particularly in aggregate. Often, but not always implemented using a star schema.
Upgrade refers to the replacement of a product with a newer version of the same product. - replace (a software program) with a more recently released, enhanced version. - replace (a hardware devic…
an open, human and machine-readable standard that facilitates data interchange, and along with XML is the main format for data interchange used on the modern web.
A pivot (or crosstab) converts row data into columnar data, and vice versa for an unpivot. Not all databases support explicit PIVOT syntax but the functionality can be implemented, often using decisio…
A clause used in SQL SELECT statements to sort query results.
In the database structured query language (SQL), the DELETE statement removes one or more records from a table.
For questions about database mirroring - a technology used to create and maintain an exact copy of a database, synchronously or asynchronously.
Short for 'eXtensible Markup Language.' A textual markup language for transferring structured data.
generally and informally recognized as the methods and processes that have been shown over time to be superior to those achieved by other means.
SQL Server Analysis Services, an OLAP server bundled with SQL Server by Microsoft since version 7.0
A catch-all term describing database systems using various non-relational models. Such systems are usually engineered to be high-performance.
High-availability technologies mask the effects of hardware or software failure, so that perceived downtime for users and applications is minimized.