Database Administrator

H2 database functions and data types I. Common H2 Database Data Types INT type: corresponding to java. lang. Integer REAL Type: corresponding to java. lang. Float DOUBLE Type: corresponding to java. lang. Double DECIMAL type: corresponding to java.

Several causes of MySQL garbled characters MySQL is garbled for the following reasons: 1. garbled characters before they are stored in the database 2. garbled Characters During database saving 3. garbled characters after being stored in the

XtraBackup and InnoBackupex online backup XtraBackup online backup: A hot standby tool dedicated to InnoDB and XtraBackup. It is a C language program dedicated to backing up InnoDB and XtraDB engine objects. Efficient, complete, and available

Use of MongoDB stored procedures and performance tuning Solutions Although MongoDB provides us with a lot of drivers, it is not convenient to use the mongodb shell. For example, the recently needed DBRef nested data must be CRUD. If the mog driver

Oracle analysis functions (notes) Analytics functions are new types of functions introduced by Oracle Database in 9i and are continuously enhanced in later versions. The analysis function provides the ability to aggregate reference values across

Requirement and introduction of ACCESS Database booster, access Database 0. Requirements 0.1 questions about cs Encapsulation In this thesis, access database is used, and MVC design mode is used for design. data entities must be encapsulated into

Path to mathematics-python Data Processing (2)-python Data Processing Insert column #-*-Coding: UTF-8 -*- """ Created on Mon Mar 09 11:21:02 2015 @ Author: myhaspl@myhaspl.com """ Print u "python data analysis \ n" Import pandas as pd Import numpy

Oracle asm alias file alias, asmalias Today, I saw a friend on the Internet asking: Why did I set log_archive_dest_1 In the ASM storage management mode to specify the archiving path, but I found two archived log files in ASM? (Not flashing back)

Configure listening _ 1521 port occupation, and listening _ 1521 port occupation Statement:Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the

JAVA write Mysql Chinese garbled solution, java write mysql garbledMethod 1:When the page value contains Chinese characters, you can use the filter to compile it. However, it is easy to use System. out. println to output Chinese characters and

MySQL Distributed Database Service middleware-Cobar research 3, mysql middleware-cobar In practical applications, you often need to deploy a Cobar cluster and then combine the soft load LVS or the Hardware load device F5 to provide external services.

Redis cluster _ 1. redis installation, redis cluster _ 1. redisRedis introduction:Redis is a high-performance key-value storage system. Similar to Memcached, But it supports more storage value types, including string, list, set, and zset ). These

How to disable the deadlock process in PostgreSQL, postgresql Process The PostgreSQL database used has no information. Google had to proceed. Finally, a solution was found in an English forum. As follows: 1. Retrieve the ID of the deadlock

Implementation of Redis multi-host database and redis Database 1. Copy In Redis, You can execute the SLAVEOF command or set the slaveof option to let one server copy another server. We call the copied server as the master server ), the server that

[ORACLE] processing of oracle time objects and oracle object processing 1.1 Use of oracle date objects (1) Create A date Field For example, Create table foo_7 (d1 date ); (2) Use the to_date function to insert a date object. To_date ('string',

Mysql database permission issues, and solutions, mysql Permissions In the past, after directly installing mysql database and using the root user, you can log on to the command line or remotely perform operations. Since mysql was acquired by oracle,

A Simple and Easy join method for complex multi-data source reports to be computed after join Complex data sources are common issues in report development. For example, join operations are performed on different database tables before filtering and

Oracle lock 3: DDL lock, oracle lock 3ddlWhen an ongoing DDL operation is executed or a schema object (Note) is referenced, the Data dcictionary (DDL) Lock is used to protect the definition of the schema object, only a single schema object is locked

MySQL5.5.21, mysql5.21 MySQL is required for a recent project. By the way, I have picked up a database that has not been completed for a long time! You may need to write a series of study notes on MYSQL! When it comes to database installation, it is

Enable postgresql remote permissions and enable postgresql Preface: Previously, only the remote permission of the specified IP address of postgresql will be configured. Later, a client wants to remotely connect to postgre and view data, but her IP