Database Administrator

First recognized undo type Log System The log system is the basic mechanism to ensure that the database management system correctly executes transactions. Based on different functions, the log system can be divided into undo and redo. This article

SYSTEM tablespace AUD $ solution to excessive space usage Problem: The SYSTEM tablespace usage exceeds 99%. During the preliminary design, the SYSTEM tablespace is fixed to 10 GB and cannot be automatically expanded.1. query the usage of the SYSTEM

Basic Introduction to Oracle and common SQL * PLUS commands Run Database Configuration Assistant as an administrator to create a Database instance. To use Oracle, you must first start the Oracle service, find the service in the task manager, and

Notes on installing MongoDB using yum in CentOS 6.5 Recently, I want to try Intel's WebRTC-based collaborative communication development kit. CS_WebRTC_Conference_Server_MCU depends on MongoDB. What is MongoDB? MongoDB is a distributed file

MongoDB insert document The data structure of the document is basically the same as that of JSON. All data stored in the set is in BSON format. BSON is a type of json Binary storage format, referred to as Binary JSON.Insert document MongoDB uses the

Hive processes count distinct to produce data skewProblem description The problematic data is skewed to the category, but it cannot be joined on the Map side, and special keys are excluded for processing. set hive.groupby.skewindata=true;insert

TPCC-MySQL Benchmark Test 1. Brief IntroductionThe output result of TPCC-MySQL includes five business logics, which constitute the entire transaction processing process of TPCC-MySQL testing. The details are as follows: New-Order: New Order Payment:

What is Redis? What is it used? What are its advantages and disadvantages ?, What does redis do? Question guidance:1. What is Redis?2 What is Redis used?3 What are the advantages of Redis?4 What are the disadvantages of Redis?Objective: To

An example of creating a table using sqlalchemy in python: pythonsqlalchemy How to Create a table instance using sqlalchemy in python Creating a table through sqlalchemy requires three elements: Engine, base class, and element. from sqlalchemy

Sql9.3 graphic tutorial for installing PostgreSQL9.3 in CentOS 7, postgresql9.3 For example, this blog record the entire process of installing PostgreSQL in CentOS 7 and the database configuration. in Linux, PostgreSQL can be installed in two ways: 1

In fact, the bottleneck of project applications is still on the db end. With only a small amount of data and a small amount of concurrency, we don't need much skill to get the desired results, however, when the amount of data reaches a certain level,

Flowdock is a Web-based team communication tool. all software developers should use it for communication, rather than using tools such as Campfires, Skype Chats, or IRC. because it can better support their real workflows. Last week, we made a

In the last issue, I introduced MongoDB and introduced the MongoDB installation method. In this issue, we will continue to follow the instructions of the author to implement basic data operations through the samus driver. Traditional relational

DatabaseOfNameYou can change the database name according to your habits. The following describes how to change the database name. Step 2 Click Start in Windows and select programs. Select Microsoft SQL Server console from the list. Step 2

To masterDatabaseFirst, we need to learn the most basic knowledge of the database. The database objects in Section 9 below will be explained as the basic knowledge of the database, it is suitable for beginners of databases. nine types of databases

Before talking about the locking mechanism of SQLServer, let's think about the following scenario: When you ride your car to your destination during the hot summer, there are several long red lights on the road, is it depressing? Sometimes you may

Overview Like other advanced languages, the T-SQL also has statements used to control the flow. The flow control statement in the T-SQL further extends the power of the T-SQL ...... This allows most of the business logic to be performed at the

This article discusses how to improve the performance of MySQL databases, and provides specific solutions from eight aspects. 1. select the most suitable field attribute MySQL can support access to large data volumes, but generally, the smaller the

This article describes Oracle cross-platform migration, such as migrating data from Oracle to other types of databases, but retaining the original structure. This reduces the workload of DBAs. I hope this article will help you better understand

We know that the website background needs to verify the user input. If this is not done, the user can even enter some SQL statements to operate the background database. Such a fun thing has never been really experienced. A few days ago, the School