Database Administrator

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

In the database class, I started with SQL and talked about create table and constraints. I gave them a question on the tiger bar, it is a puzzle found from the famous SQL Puzzles and Answers. The Answers in the original book are actually

Index View: Generally, all views are virtual tables, that is, the view itself does not store data and is a query. when accessing a view, SQL SERVER automatically accesses the base table data according to the view definition. Views with unique

MSSQL has launched the image function since 2005. The SQL Server image is unreadable. The entire database is in the norecovery mode. SQL Server images can only be 1-to-1 images, but images and logshipping can be used to achieve one-to-many and image

This is a summary of Oracle two years ago. It is nothing new. It is only a personal record and you are welcome to study and discuss it together. The restoration process of Oracle Database media is relatively complex. After all, as a large system,

We often use joint queries for two tables. Sometimes we use internal connections, full connections, and left and right connections. Is it very complicated? The following is a demonstration of their differences. First, there are two tables:

Infobright supports all the original MySQL Data Types. The Integer type is more efficient than other data types. Use the following data types as much as possible: TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT DECIMAL to minimize the number of DECIMAL

Many companies use data warehouses for data analysis. Generally, they extract data from online backup databases (such as mirror, logshipping, and slave) to the ods layer. From the ods layer to dw to dm, especially from the ods layer to dw, data

When the front-end time is used to migrate databases to others, some problems are encountered. Generally, if the backup database has EXTERNAL_ACCESS and UNSAFE assemblies, some strange errors may occur during the restoration process: Message 10314,

In a large database, performance has become one of the focuses of attention. How to Make the efficient and effective operation of the database become an issue that must be considered by database administrators and developers."Good

Informix-SQLVersion6.05.UD1 Application 1. Create and delete databases, base tables, and indexes 1. Syntax conventions: Indicates a required parameter.{...} Indicates required items.[...] Indicates the option(...) Indicates a part of the statement.|

Common methods for extracting DDL commands from objects such as database tables, indexes, constraints, and triggers include extracting metadata from these objects ), and store the data in the memory. Although many scripts can implement such

When upgrading ORACLE databases from 8i to 9i and above, it is generally considered that the original PLSQL program should be fully compatible, that is, the running process and the running result are completely consistent. Unfortunately, this is not

A cluster is an effective solution to achieve high availability. Sometimes it is counterproductive. Moreover, it is very expensive. Therefore, database administrators can use Log transfer instead of clusters to provide high availability. Log

If the primary database fails, Microsoft's SQL Server may crash. Let's take a look at how to deal with such events and learn how to use the Enterprise Manager and query analyzer to repair the primary database. As an administrator of Microsoft SQL

SQL Server automatically creates a database named tempdb for use as a workspace. When you CREATE a temporary TABLE during storage, for example (CREATE TABLE # MyTemp ), the SQL database engine creates the table in the tempdb database no matter which

We transplanted our Oracle database to the new environment. Some customer tables exist in two databases at the same time, but those tables in the new environment have some additional fields. Can you help me use the import/export tool? In this way, I

Bkjia.com exclusive news] on April 9, July 12, DM held the DM database genuine popularity activity. All users who download the free personal experience version of DM on the DM database website and register for use in the DM database forum can

Method 1: Log on to the MySQL Server using the MySQL Adminstrator GUI Tool, but the Server returns the error message Host '60-248-32-13.hinet-ip.hinet.net 'is not allowed to connect to this MySQL server This is because of permission issues. The

Any database may have certain security risks during its long-term use. For database administrators, a complete set of database backup and recovery mechanisms should not only be intended for the secure operation of computer operating systems. When