Database Administrator

MySQL is called one of the most widely used open-source databases in the industry, and the pluggable storage engine is one of its most important features, understanding and applying the storage engine will make it easier to use the enterprise-level

SQL Profile provides other information except system statistics and object (table and index) statistics for an SQL statement, such as the running environment and more accurate statistics, to help the optimizer select a more suitable execution plan

How to operate SQLite databases using Python and VC6.0 During this time, due to work needs, I simply learned how to operate the SQLite database. In order to easily write the collected data into the SQLite database, I used Python. However, since C is

Next, we will discuss the naive Bayesian model, linear regression, multivariate regression, and logistic regression analysis models.4. Naive Bayes model The Table query model is simple and effective, but there is a problem. As the number of inputs

Oracle 12C has been released... Next I will learn about silent installation and configuration of Oracle 12C and the example users. Installing Oracle 12C in Linux-6-64 New Features of Oracle 12C: Paging Query 12 new features of Oracle 12C 1. Obtain

The FLUSH command is often used for MySQL database backup. The following is a summary of the syntax. FLUSH syntax FLUSH [LOCAL | NO_WRITE_TO_BINLOG] flush_option [, flush_option]... If you want to clear some internal caches used by MySQL, you should

From the author's website data analysis: data-driven website management, optimization and operation: http://item.jd.com/11295690.html The funnel chart is applicable to the Process Analysis with standardized business processes, long cycles, and

The Hidden Costs of INSERT EXEC INSERT and EXEC: relational brothers in arms, helping you get your data and then put it somewhere. but like all brothers, their relationship has its ups and downs and sometimes you need to look just below the surface

The Data Pump was launched by Oracle from 10 GB and is used to replace the Data backup and restoration component of the traditional exp/imp tool. After the evolution and modification of several versions, Data Pump has become very mature and is

Steps for migrating a single Oracle DataBase instance to Oracle RAC: -------------------------------------- Split line -------------------------------------- Detailed illustration of the entire process of VMware + Linux + Oracle 10G RAC Install

See Oracle BUG: error message about the alert of Rman backup.Symptom:During database backup, the alert Log prompts an error message and provides a trc file with detailed error information. Recommended reading: RMAN: Configure an archive log deletion

(ASM Automatic Storage Management) is a data file storage mechanism dedicated to Oracle database services. By managing data files through ASM, DBAs no longer have to worry about I/O performance issues, you do not need to know the file name. At the

I haven't updated my blog for a long time. One reason is that the technologies used in the development projects are old technical points, and the knowledge I have come into contact with is the logic process of the industry, so I just made a summary

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: q a: Where did the experience come from? Answer: experience comes from practice and from some notes in life. Learn to sum up, learn to pay attention, learn to discover... you can also be reborn, jumping off the sublimation...

After one day of tossing the SQL Server image, I finally got some results. Now I have shared some of the problems I have encountered on the Internet. Now try to share all the problems encountered. I did not configure the results in the domain

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

Sybase replication server (sybase replication server) is used to meet the growing needs of enterprise customers/server computer environments. Since the replication server has been widely used, it has become the basis for enterprise-wide

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

When using a report, you need to add parameters to narrow the report scope for better analysis. You will often see that you need more than one parameter. The second parameter may depend on the first parameter. Generally, you are required to update