Database Administrator

I. sqlserverAdvantages:Ease of use, scalability suitable for Distributed organizations, data warehouse functions for decision-making support, integration closely related to many other server software, and good cost-effectiveness;It brings

Recently, I was working on a graduation design. It was a small system developed with powerbuilder. This system is similar to vb I learned two years ago, but it is not the same. I started to do it when I was familiar with the environment, now the

Will DBAs still exist in the NoSQL world? Author: chszs, reprinted with note. Blog homepage: http://blog.csdn.net/chszs Gartner, a consulting firm, published a survey earlier this month targeting adoption of NoSQL in various positions. The results

For all relational databases, the optimizer undoubtedly makes the core part of it, because the optimizer is responsible for parsing SQL, And we all access data stored in relational databases through SQL. The quality of all optimizers directly

Note: All operations in this article are performed under the root user. 1. Install sqlite3 Install sqlite3 in ubuntu and run the following command directly on the terminal:# Apt-get install sqlite3View version information:# Sqlite3-version2. Common

I. unreasonable index design---- For example, a table with 620000 rows of record and rows with different indexes has the following SQL statements:---- 1. A non-cluster index is created on date.Select count (*) from record where date>'20140901' and

Many Access and SQL Server developers often face the problem of upgrading an Access database to the SQL Server database. Because of the existing Access Upgrade Wizard, this transformation process becomes quite simple, especially when you create an

Ii. Improve SQL statementsMany people do not know how SQL statements are executed in SQL server. They are worried that the SQL statements they write will be misunderstood by SQL SERVER. For example:Select * from table1 where name = 'hangsan' and tID>

Here we want to summarize the previous index learning notes: First, understand why the index increases the speed. When DB executes an SQL statement, the default method is to scan the entire table based on the search conditions, and add the matching

I. Description 1. Database Information Operating system version: OEL6.5 x64Database Version: Oracle 11.2.0.4 x64 RAC This document describes how to change the publiic/private/VIP/scan IP address on oracle 11.2.0.4 x64 for OEL6.5. The detailed

-- ==================================== -- Oracle backup recovery concept -- ==================================== During database maintenance, backup or recovery is the top priority. Although the database system runs slowly in many cases, it is

Yesterday, a friend encountered a problem when developing SSIS in a 64-bit environment: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no ole db provider is available.   Because there is no 64-bit Microsoft ole db

I. background Structured Query Language (SQL) is a common Language used to access relational databases. It belongs to the fourth-generation Language, 4GL). The execution features of Structured Query Language are non-procedural, that is, you do not

From Shard to Sharding The word "Shard" means "Fragmentation" in English. As a database-related technical term, it seems that it was first seen in massively multiplayer online role-playing games (MMORPG) "Sharding" in is called "Sharding ". Sharding

This article describes how to perform physical backup by taking the implementation of automatic physical backup for Oracle databases in Linux as an example. We hope to help more Oracle Database Administrators understand this physical backup process,

INFORMIX uses the lock technology to solve the concurrency control problem of accessing the same object when multiple users access the database. INFORMIX supports complex and scalable locking technologies. Lock type INFORMIX has three different

Java database connection JDBC) APIs are a series of interfaces that allow Java programmers to access the database. Different developers have different interfaces. After using JDBC from Oracle for many years, I have accumulated many skills that allow

This article attempts to provide a common diagnosis method for CPU consumption problems through a case adjusted in the actual business system. In most cases, system performance problems are caused by poor SQL code. As a DBA, how to discover and

Among the many Oracle problems, the most important one is the buffer busy wait (buffer busy wait) event. Buffer busy waiting is the most common phenomenon in the I/O-bound Oracle system, especially in the first five busy (sequential/distributed)

1. Use the Thin driver in client software development In terms of Java software development, Oracle database provides four types of drivers, two of which are used for application software, applets, servlets, and other client software, the other two