Database Administrator

I. development componentsBefore introducing how to deploy the PB component to the Jaguar CTS server, we will first introduce how to develop a component using PowerBuilder 7. This step is very important because many options need to be set here, and

1. Cold Standby (Cold Standby)Cold backup usually backs up production system databases on a regular basis and stores the backup data on tape, disk, and other media. The backed up data is usually in an inactive state and is activated only when the

MySQL is a semi-commercial database widely favored by the Linux community. MySQL can run on most Linux platforms (i386, iSCSI, etc), as well as a few non-Linux or even non-Unix platforms. 1. license fee The popularity of MySQL is largely due to its

The following describes how to use common data dictionaries for Oracle users by category. I. Users View the default tablespace of the current user SQL> SELECT username, default_tablespace FROM user_users; View the role of the current user SQL>

MySQL provides standard SQL mode matching and an extended regular expression mode matching format based on Unix utilities such as vi, grep, and sed. Standard SQL mode matching SQL pattern matching allows you to use "_" to match any single character,

In the DB2 database, cataloguing catalog) is difficult to understand. I often do not understand this word when I was learning DB2, until now, I personally feel that the term catalog in DB2 is not very well used. Specifically, cataloguing includes

If you are familiar with Oracle databases, I think you will not be familiar with ThomasKyte. The asktom.oracle.com website hosted by Tomas has been well-known in the Oracle field for decades and is far from Lucky. Recently in the library by the

BKJIA exclusive Article] low carbon index: here we use Intel Xeon X7500 processor TDP as the standard for computing power consumption TDP = 130 W/h = 2.167 W/m = 0.036 W/s) to facilitate computing and visualization ). In addition, according to data

Sybase adaptive server enterprise 1500 FOR WINDOWS Prerequisites: windows classic theme. If you have installed sybase incorrectly before, uninstall the sybase folder and related registry keys !) Run setup.exe for installation. If you need to use

We have analyzed the Infobright architecture and briefly introduced the compression process and working principle of Infobright. Now we will discuss the issue of query optimization. 1) configure the environment In Linux, you can configure the

Use of Oracle Application Server ApplicationsSec_Manager.Secure_PackageThe routines in the package store private data in encrypted format, if usedSecure_Package.Secure_DataStorage CARD_NO data ). According to the custom encryption package definition

In large commercial applications, Remote Disaster Recovery and backup of data are very important and necessary. Based on my practical experience, I have designed a simple method to implement automatic backup of remote data for the reference of

Informix-Online databases are widely used for their high performance, high reliability, and support for data integrity definition/check. For databases in use, the security and reliability of data backup has become the focus of attention. Based on

In principle, the recycle bin is a data dictionary table that stores information about database objects dropped by users. the Drop object is not deleted by the database and will still occupy space. unless the user Purge manually or the database is

In Oracle databases, DBAs can observe tables or views to understand the usage of the current space and make possible adjustments. I. Free Space for tablespace By observing the free space of a table space, you can determine whether the space

Oracle partitioning improves the manageability, performance, and availability of many applications. Through the partition function, you can further segment the table, index, and index organization table to more accurately manage and access these

In application systems, especially online transaction processing systems, data query and processing speed have become the criteria for measuring the success or failure of application systems. Using indexes to accelerate data processing has become an

In the past decade, Oracle has become one of the world's most professional databases. For IT experts, IT is to ensure that their company's productivity is improved by leveraging the powerful features of Oracle. One of the most effective methods is

1. Export/Import (Export/Import) The Export can be used to extract data from the database, and the Import can be used to send the extracted data back to the Oracle database. 1. Simple Export of data (Export) and Import of data (Import) Oracle

Database optimization is a complex task, because it requires a good understanding of system optimization. Although the optimization effect is good if you do not know much about the system or application system, you need to know more about it if you