Db2 administration tool software#

C#гЂЃ.net Such language is often used, And WinNT Fully integrated, It can also work well with Microsoft BackOffice Product integration. SQL Server It is a large commercial database developed by Microsoft, Born in 1989 year. Now Oracle Our annual income has reached 400 Billion dollars, Enough to prove that пј€ charge пј‰ The value of database software.

Db2 administration tool software#

Дў013 year, Oracle goes beyond IBM, To become a successor Microsoft The second largest software company in the world. signify Oracle At the same time, I have MySQL The management of, thus Oracle Become an absolute leader in the field of database. Previous 2008 year ,SUN With 10 US $100 million acquisition MySQL. Дў007 year, A total of 85 US $100 million acquisition BEA Systems.Дў009 year, A total of 74 US $100 million acquisition SUN. With Oracle Software is becoming more and more famous, The company also changed its name to Oracle company. Here are 2021 year DB-Engines Ranking The statistical results of the survey on the popularity of each database пјљпј€ Check the latest ranking of the database :пј‰ДЎ979 year ,Oracle 2 Be born, It was the first commercial RDBMSпј€ Relational database management system пј‰.

Дatabase management system гЂЃ The relationship between database and table is shown in the figure пјљДў.3 Ranking of common database management systems (DBMS)ДЄt present, the common database management software on the Internet is OracleгЂЃMySQLгЂЃMS SQL ServerгЂЃDB2гЂЃPostgreSQLгЂЃAccessгЂЃSybaseгЂЃInformix These kinds of.

To save the data of the entity in the application, In general, multiple tables will be created in the database, To save the data of entity users in the program. Дў.2 The relationship between database and database management systemДatabase management system (DBMS) You can manage multiple databases, Generally, developers will create a database for each application. SQLпјљ Structured query language пј€Structured Query Languageпј‰ДЄ language designed to communicate with a database. The user accesses the data in the table in the database through the database management system. It is a kind of large-scale software for manipulating and managing database, For building гЂЃ Use and maintain database, Manage and control the database in a unified way. ДBMSпјљ Database management system пј€Database Management Systemпј‰ That is, where data is stored вЂњ Warehouse вЂќ, Its essence is a file system. Database and database management system 2.1 Database related concepts DBпјљ database пј€Databaseпј‰

The main role of persistence is Store the data in memory in a relational database, Of course, it can also be stored in disk files гЂЃXML In the data file.

Most of the time, Especially for enterprise applications, Data persistence means saving the data in memory to the hard disk вЂќ curing вЂќ, The implementation process of persistence is mostly accomplished through various relational databases.

Persistence (persistence)пјљ Save data to a power down storage device for later use.

MySQL The first 01 Chapter _ Database Overview