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.
A schema of a database system is its structure described in a formal language supported by the database management system (DBMS) and refers to the organization of data to create a blueprint of how a d…
MySQL version 5.7 - please also tag with mysql for search purposes.
Splitting a database table into multiple segments for performance or manageability.
Oracle Database 12c. Please also tag oracle for search purposes.
UPDATE changes the values of the specified columns in all rows that satisfy the condition. Only the columns to be modified need be mentioned in the SET clause; columns not explicitly modified retain t…
A widely-used open-source operating system that is particularly popular on servers.
SQL Server 2017 (major build version 14.00.xxxx). Please also tag sql-server.
A type of integrity constraint used in a RDBMS platform to ensure that a value in a column matches one of a range of key values from another table.
Performance issues with PostgreSQL queries
Amazon Relational Database Service is a web service that makes it easy to set up, operate, and scale a relational database in the cloud.
the process of moving databases or data from one place to another
Azure SQL Database is a relational database-as-a-service from Microsoft. This tag is for questions about Azure SQL Database, NOT SQL Server hosted in an Azure VM (use azure-vm).
The process of determining which indexes are useful and which are not.
A mechanism for managing concurrent access to shared data or resources by granting temporarily exclusive access to the processes requesting the lock.
Transaction log is a list/history of modification executed by a database management system to guarantee ACID properties over crashes or hardware failures.
Db2 is a family of relational database management servers developed by IBM. It runs on multiple platforms, including Unix (namely AIX), Linux, IBM i (formerly OS/400), z/OS and Windows.
A core statement in SQL that does what it says on the tin: inserts data into a table.
Oracle Database 11g (not 11g R2). Please also tag oracle for search purposes.
MySQL's Standard Dump/Backup Utility
When used in the context of databases, memory refers to RAM directly addressable by the CPU as opposed to going through the I/O subsystem.
A cluster consists of a group of computers connected so that in many respects they can be viewed as a single system.
GROUP BY : SQL Aggregation for Common Values
A function performs some specified work, usually taking parameters as input. In terms of databases these may be specific to SQL or to the database vendor.
A mechanism for committing a consistent set of changes into a database atomically.
Microsoft Access is a relational database management system that is part of the Microsoft Office suite.
The choice of settings for hardware, firmware, software or other components of a database system.
Use ONLY if PHP is directly relevant to the question and likely to be the source of your problem, not just because you're using a PHP library to connect to a database. PHP stands for Professional Hype…
SQL term used to describe when a `SELECT` statement is used as part of a larger SQL statement. The larger statement may be DML and is always found within brackets or parenthesis.
Normalization is the process of organizing columns into tables within a relational database in such a way as to minimize redundancy and avoid insertion, update and deletion anomalies.
A virtual table that represents the data in one or more tables in an alternative way.
Operating system produced by Microsoft. Windows is produced in various desktop and server versions. Please also add a version-specific tag like windows-10 if that is relevant to the question.
Installation (or setup) of a database application, is the act of putting the application onto a computer system so that it can be executed.
A popular open-source embeddable (i.e. non client-server) RDBMS implemented as a C library.
PostgreSQL version 9.3
Improving the performance characteristics of a database application or system.
Linked server allows operation to multiple server as one query.