top 10 database software

This article has been tested by ourselves. The system is Ubuntu 14.04 server, and the Mysql database is Mysql 5.5. We are preparing to migrate it to Maria DB 10.1, for details about the migration methods of other versions, go to the official website. Here I will only talk about what I have tested.As to why oracle migrated to MariaDB, users who know Oralce's acquisition of Sun should know that, of course, this has been a thing a few years ago. I ha

Use Oracle Database 10 GInternal ETL infrastructure Http://www.oracle.com/technology/global/cn/obe/10gr2_db_single/bidw/etl2/etl2_otn.htm -- Some basic concepts and types of CDC are introduced in Change Data Capture (1. This article mainly demonstrates the basic steps of implementing the synchronization mode CDC through a practical example. -- Create table Create table SALES ( ID NUMBER, Product

Quickly install Oracle Database 10 GB on RedHat AS3: Su-root Dd if =/dev/zero of = tmpswap bs = 1 k count = 900000 Chmod 600 tmpswap Mkswap tmpswap Swapon tmpswap Check the tmp space and run the command: $ df/tmp If the temporary space is insufficient, you can create or specify another file to store the temporary file as follows: Su-root Mkdir/tmp Chown root. root // tmp Chmod 777 // tmp Export TEMP =/ Expo

If you want to restore a database on a colleague's machine to your own machine, the DMP file provided by the colleague cannot be used. I suddenly thought of Oracle 10 Gb, and I was still in the Oracle 9I stage. Back up again with your own 9I client, resulting in a EXP-00003 error. I checked on the Internet that the BLOB field is used in the table (it seems that this field does not affect Data Storage). By t

The following article mainly describes the actual comparison between the Oracle database and DB2 and MySQL with the first 10 records. The following article mainly uses Oralce as an example to explain their differences, the following is a detailed description of the article. I hope you will get some benefits. 1. Best Choice: use analysis functions row_number()over(partitionbycol1orderbycol2) For exa

View Current Character Set ReferenceSQL> select * from nls_database_parameters where parameter like '% SET % '; PARAMETER VALUE----------------------------------------------------------------------NLS_CHARACTERSET WE8ISO8859P1NLS_NCHAR_CHARACTERSET AL16UTF16 ReferenceSQL> select userenv ('language') from dual; USERENV ('language ')----------------------------------------------------AMERICAN_AMERICA.WE8ISO8859P1 Try to modify character set directly ReferenceSQL> ALTER

Label:Designing Highly available systemsThe target of replication is:1. Provide one or more replication databases to ensure that the data can be used by the application2. Provide a replication database for recovery3. Load Balancing4. Non-disruptive software upgrades and maintenance Classic replication Scheme supports the following forms:Unidirectional-Is this and the ASP different and will switch roles?Bidi

Do you still remember the concept of saving points in SQL? In a transaction, you can create a save point, make some modifications, create another save point, and so on. If these changes are not what you want, all you need to do is roll them back to a specific save point. Now we will introduce a new feature introduced in Oracle Database 10 GB-Flashback database. W

any one article9. How to use the C # language to get rid of all the tags in HTML for plain text (html2txt)10. How to compile multiple HTML files into CHM (Html2chm) using the C # language11. How to use the C # language to publish articles remotely to Sina Blog12. How to develop a static site builder using the C # language13. How to build a program framework using the C # language (Classic WinForm interface, top menu bar, toolbars, left tree list, rig

Today, let's take a look at how convenient it is to use the batch processing command to back up a table during database backup in oracle 10 Gb. Today, let's take a look at how convenient it is to use the batch processing command to back up a table during database backup in oracle 10 Gb. Note: 1. I use an oracle

This article introduces the 10 features of SQL Server 2005 database management and analyzes the benefits of its application. 1. Database Mirroring The new database mirroring method is used to extend the performance of record file transfer. You will be able to use database mi

data verification Step 7: Simple Analysis of the cryptographer encryption module, custom encryption interfaces, and usage-Part 1 Step 7: Simple Analysis of the cryptographer encryption module, custom encryption interfaces, and usage-Part 2 Step 8. Use the configuration setting module and other methods to classify and manage enterprise database configuration information Step 9: Use the policyinjection module for AOP-PART1-basic usage St

: Introduce the EntLib. Validation module information, the implementation level of the validators, and the use of various built-in validators-Part 1 Step 5: Introduce the EntLib. Validation module information, the implementation level of the validators, and the use of various built-in validators-Part 2 Step 6: Use the Validation module for server-side data verification Step 7: Simple Analysis of the Cryptographer encryption module, custom encryption interfaces, and usage-Part 1 Step 7: Simpl

Oracle 10gBasic Database Query statements-above--Reference: Zhang lie Zhang Jianzhong Database Administrator training handout Principles for writing SQL statements The case is not sensitive, but the case sensitivity of single and double quotes. Remember! Keyword cannot be abbreviated It can be written by branch, but keywords cannot be written across lines. Generally, each clause is a row. Supports typograph

Database optimization tutorial (10) [excellent chapter] solve the four ways in which indexes are not used when like '% str', tuning % strIii. Index 7. Four methods to solve like '% str' without fuzzy query As mentioned above, the index will not be used as long as the fuzzy search value is prior to the string, neither '% aaa' nor' _ aaa' will be used! As follows: It should be said that this is a joke tha

First,python operation MySQL databasePython3 operating MySQL data requires a third-party module to be installed, Pymysql, and installed with Pip install Pymysql　　Second,python operation Redis　　Redis is a nosql type of database with data in memory, with fast read and write speedsPython3 operation Reids need to install a third-party module, Redis, using PIP install Redis installation can　　　　Python Learning Notes 10