One of the oracle learning starter series, database development and history, one of the oracle Series

One of the oracle learning starter series, database development and history, one of the oracle Series

 

Oracle learning starter Series

Database development and history

 

This oracle learning getting started series is based on some of my work notes, projects to recall and organize. On the one hand, it is the accumulation of knowledge to facilitate the improvement of skills; on the other hand, it is a good citizen to share with friends. In the end, of course, it is also mixed with your own small wish to get rid of your own bad habits. When I think about the reading exam, if I had more than a few minutes of Chinese and English at that time, this might not happen now... (Cough ~~), IT is also good. Let's start with the opening remarks.

Since we are learning databases, we have to leave a few questions behind.

1. Why database? What is database?

2. How has the database been developed now? It has gone through several processes.

These two questions need to be answered in this document. Let's move forward with the question. This series will adopt this problem-driven model.

My mailbox: appdevzw@163.com

Public Account: HopToad

Welcome from all walks of life

1. Why database?

Let's go back to one day at the beginning of the 20th century. Imagine that Coca-Cola's partner A is busy sorting out the sales data for the day, classifying the customer into categories, and sorting them by order size, count how many bottles of drinks are sold today. After the completion, partner A puts the Bill into the confidentiality cabinet and leaves. (Isn't that classification, sorting, statistics, and storage ?)

After 10 years, IBM was founded in 1911, and partner A joined IBM. IBM has three companies:Host Machine Company (founded in Washington in 1896), computing table Company (founded in 1901 in Ohio)DaytonAnd international time recording Corporation (founded in 1900 in the New York State of endecot). At that time, IBM was not called IBM but CTR. Looking at the three companies, toad said it was a bit drunk. The first two companies are still like-minded, and the third company is clearly selling CDs.

With the help of the company, they began to make products. What are the products? Don't be surprised. Automatic meat cutter (as you may often see when you go to the buffet), scales, etc. The most important thing is punch cards, and as the company's focus, partner A can also work hard. After more than a decade, the CTR finally changed its name to IBM in 1924 and entered Canada. The IBM we knew finally appeared.

In the early 1932 s, it was the time when Roosevelt unified the world. Due to the great economic recession, it was difficult for people to eat a mouthful of food, not to mention bread and beef. IBM has invested a lot in the card machine, and has occupied the card machine market 80 ~ in a few years ~ A 90% share is a monopoly. When IBM took the opportunity to make a fortune, it was basically a big fortune.

In this way, another 7 ~ In 1939, World War II broke out, and it was another opportunity to make a fortune. It was a waste of money to pay for it. IBM began to generate guns and ammunition. Little partner A also began to produce M1 cabin guns and bronzing automatic rifles. In this case, IBM's hands are full of blood .... But even if IBM doesn't do a gun, Coca-Cola will do it.

After World War II, IBM made another fortune. With more money, IBM began to cooperate with universities to create computers and burn money.

A glance, I 've written a lot of data, and the database is still blank. SORRY, ladies and gentlemen, the next step is coming soon.

In 1950s, IBM developed storage. This is a milestone that allows electronic systems to replace cards.

In 1964, IBM launched the System/360 mainframe. IBM was not investigated by the Ministry of Justice in the middle of 1960s, because the computer industry is too big.

Let's set the time to 60 years. If we have a computer with storage, what should we do with it?

Here we will first mention Computer Science and Mathematics. In fact, the development of mathematics is very fast. Think of the year when Euler showed a pen and a piece of paper to complete the proof. The development of computer science is based on mathematics, and its true progress relies on the development of basic science such as physical chemistry and the progress of manufacturing technology.

Back in the middle of 60 years, now we have storage and computers. What then? Playing games? Sweeping the floor?

NO, NO, NO

The real purpose is how to replace the things (classification, sorting, statistics, and storage) When partner A bought cola)

Finally, in 1969, IBM developed the first-generation database, namely the hierarchical model. The product is called IMS.

In addition, a group of us Database System Language negotiations CODASYL proposed a mesh model without products. (Mesh, it just looks like a network, but it doesn't matter to the Internet.) Don't ask where ORACLE was at that time. ORACLE founder Larry herison is 25 years old. It is estimated that he is still working at school.

Now I can finally answer the first question. Why do I need a database?

In fact, even if there is no database software, we have already been implementing this set of databases, such as the content of the work of the cola sales partner A in the 20th century, however, with the development of mankind and the advancement of science and technology (the emergence of storage and computers), we have made a great abstraction of things and work that we used to do, then, some rules are redefined and added.

 

2 database development experience

The database development experience is quite easy to write, and then continue.

The first generation of database has been developing for A period of time. IBM's little friend A is also dead, but there are still little friends B, C, D. Little friend B's overnight research data model finally dreamed of Mr. Euler's epiphany overnight. In 1970, Partner B published A paper entitled "A Relational Model of Data for Large Shared Data banks (Relational Model of Large Shared databases)" in the publication "Communication of the ACM, this document first introduces the concept of a relational model for databases. This partner, B, is known as "father of relational databases", Edgar Frank Codd or E. F. Codd ). At this point, I finally introduced my even Doctor Codd. I can't help my doctor, but I finally asked Dr. C odd to learn about the database. In 1981, Codd won the Turing Award and the Nobel Prize in the computer industry. Don't mention the computer award because there is no data prize.

Then, despite the fact that the contract has not expired, Larry herison ran out in 1978 to create a company called RSI. At the early stage of the company's creation, Larry made code in other companies because the contract has not expired. Do you have any questions about what Larry is doing for the seven years between 1970 and 1977? Vietnam War? The Vietnam War ended in 1975, just two years later. NO, NO, NO. Larry is working at Laidong's house, that is, implementing the database theory of Master Codd. The database they are implementing is called oracle (Larry later named the company that was founded oracle ). In 1977, Larry probably thought that this theory could be achieved when he secretly ran it. He did not know that some of the Code he carried had escaped. If so, it would be the first code theft case in the database history.

Then RSI launched oracle software in the summer of 1979, and renamed ORACLE in 1982.

IBM also launched DB2 in 1983.

Since then, relational databases have embarked on a path of rapid development and are still relational data software.

This is a small note here. Next I will take a note of "basic database knowledge".