Logo
Unionpedia
Communication
Get it on Google Play
New! Download Unionpedia on your Android™ device!
Free
Faster access than browser!
 

Database tuning

Index Database tuning

Database tuning describes a group of activities used to optimize and homogenize the performance of a database. [1]

24 relations: Backup, Block (data storage), Central processing unit, Communication protocol, Concurrency (computer science), Data striping, Database, Database caching, Defragmentation, Expansion card, Histogram, Host system, Insert (SQL), Join (SQL), Operating system, Paging, Parallel computing, Query language, Query plan, RAID, Server (computing), Software, Storage area network, Transaction log.

Backup

In information technology, a backup, or the process of backing up, refers to the copying into an archive file of computer data so it may be used to restore the original after a data loss event.

New!!: Database tuning and Backup · See more »

Block (data storage)

In computing (specifically data transmission and data storage), a block, sometimes called a physical record, is a sequence of bytes or bits, usually containing some whole number of records, having a maximum length, a block size.

New!!: Database tuning and Block (data storage) · See more »

Central processing unit

A central processing unit (CPU) is the electronic circuitry within a computer that carries out the instructions of a computer program by performing the basic arithmetic, logical, control and input/output (I/O) operations specified by the instructions.

New!!: Database tuning and Central processing unit · See more »

Communication protocol

In telecommunication, a communication protocol is a system of rules that allow two or more entities of a communications system to transmit information via any kind of variation of a physical quantity.

New!!: Database tuning and Communication protocol · See more »

Concurrency (computer science)

In computer science, concurrency refers to the ability of different parts or units of a program, algorithm, or problem to be executed out-of-order or in partial order, without affecting the final outcome.

New!!: Database tuning and Concurrency (computer science) · See more »

Data striping

In computer data storage, data striping is the technique of segmenting logically sequential data, such as a file, so that consecutive segments are stored on different physical storage devices.

New!!: Database tuning and Data striping · See more »

Database

A database is an organized collection of data, stored and accessed electronically.

New!!: Database tuning and Database · See more »

Database caching

Database caching is a process included in the design of computer applications which generate web pages on-demand (dynamically) by accessing backend databases.

New!!: Database tuning and Database caching · See more »

Defragmentation

In the maintenance of file systems, defragmentation is a process that reduces the amount of fragmentation.

New!!: Database tuning and Defragmentation · See more »

Expansion card

In computing, the expansion card, expansion board, adapter card or accessory card is a printed circuit board that can be inserted into an electrical connector, or expansion slot, on a computer motherboard, backplane or riser card to add functionality to a computer system via the expansion bus.

New!!: Database tuning and Expansion card · See more »

Histogram

A histogram is an accurate representation of the distribution of numerical data.

New!!: Database tuning and Histogram · See more »

Host system

Host system is any networked computer that provides services to other systems or users.

New!!: Database tuning and Host system · See more »

Insert (SQL)

An SQL INSERT statement adds one or more records to any single table in a relational database.

New!!: Database tuning and Insert (SQL) · See more »

Join (SQL)

An SQL join clause combines columns from one or more tables in a relational database.

New!!: Database tuning and Join (SQL) · See more »

Operating system

An operating system (OS) is system software that manages computer hardware and software resources and provides common services for computer programs.

New!!: Database tuning and Operating system · See more »

Paging

In computer operating systems, paging is a memory management scheme by which a computer stores and retrieves data from secondary storage for use in main memory.

New!!: Database tuning and Paging · See more »

Parallel computing

Parallel computing is a type of computation in which many calculations or the execution of processes are carried out concurrently.

New!!: Database tuning and Parallel computing · See more »

Query language

Query languages or data query languages (DQLs) are computer languages used to make queries in databases and information systems.

New!!: Database tuning and Query language · See more »

Query plan

A query plan (or query execution plan) is an ordered set of steps used to access data in a SQL relational database management system.

New!!: Database tuning and Query plan · See more »

RAID

RAID (Redundant Array of Independent Disks, originally Redundant Array of Inexpensive Disks) is a data storage virtualization technology that combines multiple physical disk drive components into one or more logical units for the purposes of data redundancy, performance improvement, or both.

New!!: Database tuning and RAID · See more »

Server (computing)

In computing, a server is a computer program or a device that provides functionality for other programs or devices, called "clients".

New!!: Database tuning and Server (computing) · See more »

Software

Computer software, or simply software, is a generic term that refers to a collection of data or computer instructions that tell the computer how to work, in contrast to the physical hardware from which the system is built, that actually performs the work.

New!!: Database tuning and Software · See more »

Storage area network

A storage area network (SAN) is a Computer network which provides access to consolidated, block level data storage.

New!!: Database tuning and Storage area network · See more »

Transaction log

In the field of databases in computer science, a transaction log (also transaction journal, database log, binary log or audit trail) is a history of actions executed by a database management system used to guarantee ACID properties over crashes or hardware failures.

New!!: Database tuning and Transaction log · See more »

References

[1] https://en.wikipedia.org/wiki/Database_tuning

OutgoingIncoming
Hey! We are on Facebook now! »