Database Administrator

Key New Features of MySQL 8 MySQL's eighth version is coming soon and is expected to be released in 2018. Within 28 months after MySQL 5.7.9's first general-purpose version was launched, MySQL 8 released five candidate versions from 8.0.0 to 8.0.4.

Implementing the median Algorithm in MySQL Purpose: MySQL does not have a specific median algorithm. For those unfamiliar with SQL, median can only be written in Java or other languages. It is not recommended that you use MySQL to complete median

Implementation of Redis database read/write splitting Redis is a NoSQL document database. It is stored in memory through the key-value structure. Redis reads 110000 times/s and writes 81000 times/s, high Performance and wide application scope. The

Preliminary understanding of MySQL prefix index and index Selectivity Sometimes you need to index long character columns, such as BLOB, TEXT, or long VARCHAR columns. This will make the index very large and cause slow query. In this case, we can use

Mysql-related applicationsCommonly used MySQL commands are full. Connection MySQL format: mysql-h host address-u username-p User Password 1. Example 1: connect to MYSQL on the local machine. First, open the DOS window, enter the directory mysqlbin,

1. Create a database DB2_GCB Create database DB2_GCB on g: ALIAS DB2_GCBUsing codeset gbk territory cn collate using system DFT_EXTENT_SZ 32 2. Connect to the database Connect to sample1 user db2admin using 8301206 3. Create an alias Create alias db2

BKJIA quick translation] when I see this question, I don't think there is a definite answer! The reason is that SQL Server has jumped from a simple desktop-based application to an important enterprise-level database management system product, but it

I have always felt that I should learn about another database except Oracle, but I am really not interested in SQL Server. I think MySQL or PostgreSQL is an open source database after all, it is difficult to compete with commercial databases in the

1. Database Security 1, ms SQL Server database security Sa-level users are not allowed to connect to the database on the Web. Solution: Delete the sa user and create a new user with the sa permission. the user name and password are as complex as

Preface Currently, all applications that use Oracle as the database support platform have a large amount of data, that is, the data volume of tables is generally more than one million data volume. Of course, creating partitions in Oracle is a good

Database ProgrammingIf there is an uglyWriting specificationsNot only is the readability poor, but it also gives people a sense of reverence, that is, you are a hero, and good writing standards give people a pleasant and artistic experience. This

Editor's note: when using SQL Server, a small error occurs in backup and database restoration. What should you do? Here are a few tricks. Let's take a look at them with the author! An unknown error occurred while backing up the database. the error

Today, I will explain the new features of Oracle 11g Database-virtual Columns Introduction In the old Oracle version, when we need expressions or some calculation formulas, we will create a database view. If we need to use indexes on this view, we

In Oracle9i, Oracle renamed the rollback segment and uses it as the log for revocation. In traditional operations, the rollback segment stores the revocation information of the exchange until the system sends a response or rollback statement. Manual

When a WHERE clause uses a function for a column, the Oracle optimizer cannot use the index in the query unless this simple technology is used to force the index. Generally, if you do not use functions such as UPPER, REPLACE, or substrd in the where

Robert Thornton has six years of Java language development experience and is currently a consultant for Daugherty Business Solutions. He served in St. louis, Mo ., developers and architects who use Java EE applications on various clients in the

Security Vulnerabilities Databases distributed throughout the company collect and store a variety of key personal privacy data, such as social insurance numbers, credit card numbers, birthdays, and bank account information, at the same time, the

The Oracle database provides a default user operation environment. For example, the number of rows extracted from the database, the delimiter between columns, the maximum width of each line, and the default number of lines displayed on each page.

Server clusters take advantage of the built-in cluster functions in Enterprise Edition of the Windows Server series. In fact, Windows Server 2003 is much better for clusters than Windows 2000 Advanced Server. To maximize the benefits you get from

BKJIA Summary: in the previous article, we read performance considerations for DB2 concurrent connections. This time we will focus on performance optimization in the complex DB2 application environment. The current production environment is very