Database Administrator

The following table collects almost all views or aliases in the Oracle Data Dictionary. Use the 'describe' statement to query the fields of each view or Alias. Description: In the Oracle Data dictionary, the object names are mostly "USER. "," ALL. ",

Introduction to Introduction The new MySQL 5.0 feature tutorial is intended for old MySQL users who need to know the new features of MySQL 5.0. Simply put, I introduced the "Stored Procedure, trigger, view, and Information Architecture View". I

Audit is used to monitor the database operations performed by users. Oracle stores Audit trail results in OS files or databases. 1. To use audit, you must activate audit. SQL> conn/as sysdba is connected. SQL> show parameter

DB2 stored procedure: Basic knowledge When you classify remote servers and databases on the server on the client workstation, a simple DB2 client/server environment exists. In this environment, each time an SQL statement is executed on the database

According to the definition of Bill. Inmon, "Data Warehouse is subject-oriented, integrated, stable, and time-changing, mainly used for decision-making support of database systems" ODS is a topic-oriented, integrated, variable, and current

Knowledge points that must be learned when using the IBM DB2 database: 1. After installing the DB2 database, you can operate it through the command line or graphical interface,If your database server is not on the local machine, you need to

Code for trigger Creation Create Trigger TG_ProjectNameOn table1After UpdateAsUpdate table2Set [project name] = B. Project NameFrom table2 a, inserted BWhere a. ProjID = B. ID Description of Inserted and Deleted in the trigger. Two

In database design and management, the WHERE clause is undoubtedly one of the most frequently used clauses. So are you really good at using this clause? I can't see it. The following suggestions can help you make full use of the WHERE clause

Take MySql as an example. Create two data tables in the MySQL database and insert some data respectively. The sample script is as follows: 　drop table table1;    CREATE TABLE `andrew`.`table1`    (    `name` VARCHAR(32) NOT NULL,   

Sysbase is a pioneer in column-based databases. Sysbase IQ 15 is the latest column-based database of Sybase. It has powerful functions, including fast data loading, ultra-high-speed analysis performance, powerful intelligent business analysis, and

MySQL database is an open source database based on structured data. SQL statements are the core language of MySQL databases. However, when executing SQL statements in the MySQL database, you need to be careful with two traps. Trap 1: NULL values are

Previously, we followed the author to review the query algorithm and partial Sorting Algorithm in the data structure. Now we continue to follow the author to learn some basic sorting algorithms. Select sort Usage conditions:A set of comparable sizes.

Optimizer for PL/SQL statement execution of ORACLE databases, including cost-based optimizer CBO) and rule-based optimizer RBO ). The RBO optimization method depends on a set of strict syntax rules, as long as the statements written according to the

It provides a strong guarantee for the Agricultural Bank system to collect vertical and horizontal business data in a timely manner and generate statistical reports according to different requirements for comprehensive business activity analysis.

This article uses SQL Server 2 K as an example to illustrate the specific implementation process of connecting SQL Server to the Oracle Server. 1. Install the oralce client software and sqlserver2000 software on the PC. 2. Configure the tnsnames.

I. porting process records Basic information: two minicomputers, one sun250, with solaris8 + oracle8i, jgsun, ip 10.11.1.11, running, with application connection, and one with sunv890, it is installed with Solaris9 + Oracle10g, The Machine name is

To achieve maximum performance, databases generally have a concurrency mechanism, but the problem is Data Access conflicts. To solve this problem, most databases Use Data Locking. There are two methods to lock data: Pessimistic lock and optimistic

A few days ago, due to some data corruption in the MySQL database, I tried to recover the data, and then sorted out the following documents for your reference. If you have similar problems in the future, you can avoid detours, solve the problem as

Relational databases represent data as a simple two-dimensional model, that is, records represented as rows and columns for storage and processing. Relational databases were generated earlier, but they are only suitable for the storage and

I was asked today, if we need to execute SQL Server proxy tasks in code, what is the idea? I think there are usually two ways of thinking. 1. Manage Object Model through SMOSQL Server) 2. Stored Procedures The following describes how to use SMO. 1.