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.
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…
Improving the performance characteristics of a database application or system.
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.
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.
Oracle Database 10g (not 10g R2). Please also tag oracle for search purposes.
Specifies the type of data being stored (string, date, numeric, etc).
A visual database design tool developed by MySQL. It is the successor application of the DBDesigner4 project.
The automated distribution of transactional changes from a publishing database to one or more subscriber databases.
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…
SQL Server 2017 (major build version 14.00.xxxx). Please also tag sql-server.
A database system optimised for reporting, particularly in aggregate. Often, but not always implemented using a star schema.
A data structure that organizes information into rows and columns.
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…
For questions about database mirroring - a technology used to create and maintain an exact copy of a database, synchronously or asynchronously.
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…
generally and informally recognized as the methods and processes that have been shown over time to be superior to those achieved by other means.
Short for 'eXtensible Markup Language.' A textual markup language for transferring structured data.
In the database structured query language (SQL), the DELETE statement removes one or more records from a table.
A clause used in SQL SELECT statements to sort query results.
A catch-all term describing database systems using various non-relational models. Such systems are usually engineered to be high-performance.
SQL Server Analysis Services, an OLAP server bundled with SQL Server by Microsoft since version 7.0
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.
High-availability technologies mask the effects of hardware or software failure, so that perceived downtime for users and applications is minimized.
Determining what database product best fits the requirements and limitations in a specific situation. This is advice that generally requires much more insight into requirements than can easily be gle…