Database Administrator

Integrity constraints of Database Design Data integrity is the correctness, completeness, and consistency of the index data. It is a standard for measuring the quality of the database. Database integrity is guaranteed by various integrity

Source code analysis of page Structure in PostgreSQL Source code analysis of page Structure in PostgreSQL In PG, the smallest Management Unit in disk storage and memory is page, which is also commonly referred to as block. Generally, the size of the

Write the redis script and the redis script togetherI. redis script Environment To write redis scripts, we should first set up its script environment. Redis uses lua as its scripting language. Therefore, building a lua environment becomes the first

Use the API to convert the unknown incoming amount of AR receipts to the unverified status. apiar DECLARE p_api_version NUMBER; required VARCHAR2 (200); p_commit VARCHAR2 (200); Limit NUMBER; x_return_status VARCHAR2 (200); x_msg_count NUMBER; x_msg_

The mongodbmongod installation command is not an internal or external command. 1: Installation Go to the official mongodb website http://www.mongodb.org/downloadsto download the 32bitpackage After decompression, the following files will

How to do a master table with a foreign key Association The primary and Foreign keys are mandatory associations between two tables provided by the database. They can also be implemented at the application layer. Advantages

MySQL conversion/modification table Storage Engine MySQL table conversion (convert/modify table storage engine ): There are several ways to transfer a table from one engine to another, all of which have their own advantages and disadvantages. The

Create and publish Datazen charts and create datazen chartsZookeeper Datazen is a full-platform data presentation solution for mobile terminals acquired by Microsoft. This article describes how to create and publish charts.   As described above,

Find the name, salary, Department name, salary level in the company and name of the leadership, salary of the leadership, level corresponding to the leadership, and employee name of each employee. Example: The employee's name, salary, Department

Thoughts on the data operation report system and operational report Purpose: Data indicators are the pulse of the product. Managers can understand the Product Operation overview by feeling the pulse changes. Fragment Tracking: The ultimate

[Solution] solve the Mysql Character Set Problem and solve the mysql Character Set Problem. [Author]: kwu Solve Mysql Character Set Problems 1. Add the following content to vi/etc/my. cnf: [Client] port = 3306 socket =/var/lib/mysql. sock

Mysql user permission management and mysql permission management [Author]: kwu Mysql user permission management 1. Modify the root user name and password Set password for 'root' @ '%' = password ('123 ');% Indicates all IP addresses. The

For Oracle RAC node eviction caused by heartbeat Network (not instance eviction), oraclerac Node eviction of Oracle RAC caused by heartbeat Network (not instance eviction)   Q:Suppose the following scenario: for the four node rac, the heartbeat

Data cleansing note Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. You must specify the source when you repost them. Otherwise, you have the right to pursue legal liability for copyright. Deep Blue blog: http://

Mysql time operation functions and stored procedures, mysql function stored procedures Because the business needs to collect a batch of data, mysql time operation functions and stored procedures are used, and the problem has been basically solved.

SQL query beginner's Guide Reading Notes (I) Introduction to relational databases and SQL, beginner's Guide Reading Notes Part I: Relational Databases and SQL Chapter2, Ensuring Your Database Structure IsSound. Database Design Guidelines   What is

Features of mysql Data Table engine InnoDB and MyISAM, innodbmyisam1. MyISAM Table Engine Features (1) MyISAM is the default storage engine of MySQL. (2) Most tools with table checking and repair. (3) tables can be compressed. (4) full-text search

Group by of 13-SQLite, 13-sqlitegroupbyI. group by Overview Literally, "group by" refers to grouping data according to the rules specified By "by". The so-called grouping refers to dividing a "dataset" into several "small areas ", then data is

Oracle physical storage structure, oracle physical storageOracle physical storage structure The database is actually composed of a pile of physical files, mainly including four:1. control files)2. Data files (Date files)3. redolog)1. Control

TNSPING time out/slow response, tnspingout E: \ s01 \ app \ oracle \ product \ 11.2.0 \ dbhome_1 \ BIN> tnsping CENORCLTNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0-Production on 25-MAY-2015 10: 26: 59 Copyright (c) 1997,201 0, Oracle.