Database Administrator

There are many ways to search for text in Oracle databases without using the Oracle text function. You can use standard INSTR functions and LIKE operators. SELECT *FROM mytext WHERE INSTR (thetext, 'Oracle') > 0;SELECT * FROM mytext WHERE

Multi-version concurrency control technology has become the trend of database development in the future. Currently, multi-version concurrency control is adopted by many database or storage engines, such as Oracle, ms SQL Server 2005 +, PostgreSQL,

MySQL databases can be said to be one of the most common and common databases for DBAs. The wide application of MySQL also adds more people to the ranks of them. The following are some of the most common and frequently used MySQL Databases

Just after lunch, I took a break. I saw a problem in the QQ group. I told you a date without a year and figured out the constellation of the date; the first idea at the beginning was to compare the start time and start time of the constellation to

In this article, we will introduce you in detail how to upgrade the dynamic InnoDB Plugin, how to upgrade the InnoDB Plugin with static compilation, and how to convert the compressed tables created in versions earlier than 1.0.2. I. Overview Thanks

Guidance:Unable to open userDefault Database, Login Failed, which is one of the issues that SQL Server users are familiar. When using Enterprise Manager, query analyzer, various tools and application software, you may encounter this problem as long

After installing Mysql, use VS to open the source code. I just need to open it. How is the difference between this code and the imagination? I felt that the code was a little messy, and the comments and codes were written at random. There seemed to

Previously, I shared with you "using with statements to write a slightly complex SQL statement". This time I made a Performance Comparison Between with statements and subqueries. As instructed by Boyou SingleCat, perform some performance tests on

In project development, the core work of most developers is how to store and access data. To perform data operations, we must first solve several basic problems: 1. How to establish a connection with a database. 2. How to read data from the database.

I recently modified a paging storage process. As a newbie, I still benefited a lot from it. Now I will start my paging journey today.1. Start Restoration Next, let's take a look at the original paging stored procedure. Alter procedure [dbo].

Test Case Description The test case is in the B2C field. A product order information table is used to store the purchased items. However, some other fields are removed for testing and the data items in the table are not described in detail, field

◆ Introduction Before reading this article, I must clearly tell you that I am not a master in the database design field. The 11 points listed below are my personal opinions on my experience gained from project practice and reading. I personally

Transaction Log Transaction Log Transaction logs) is a very important but often ignored part of the database structure. Since it is not as active as the schema in the database, few people are concerned about transaction logs. Transaction logs are

The database and application software branch of the China Software Industry Association was established at Peking University in March 16. This will attract the attention of national securities, insurance and other industries and database vendors

At the same time, the increase in the number of online traffic is obviously difficult for servers with 1 GB of memory. In severe cases, even the server crashes every day or gets stuck from time to time. This problem has plagued me for more than half

1. DBWR Process: This process writes the buffer to a data file. It is an Oracle background process responsible for Buffer Storage zone management. When a buffer in the buffer zone is modified, it is marked as "dirty". The main task of DBWR is to

SQL Server 2000 makes it easier to export data in XML, but it is troublesome to import and process XML data in SQL Server 2000. If you refer to Books Online (BOL), you will find related entries, including OPENXML and OPENROWSET. All of these

Introduction Every program using a relational database may encounter data deadlocks or unavailability, which need to be programmed in the Code; this article mainly introduces the retry logic concepts related to Database Transaction deadlocks and

I. MySQL: indexes are saved in B-tree format. The Memory storage engine can select Hash or BTree indexes. Hash indexes can only be used for Equality comparison of = or . 1. Common index: create index On Tablename (column list) Alter table

During Oracle development, If you test your application independently, deploy the application, and submit it to dozens of concurrent users, it is very likely that the concurrency problems that were not previously detected will suffer. For example,