One of the Oracle Learning Starter Series Database development and history

One of the Oracle Learning Starter Series

Database Development and history

This Oracle Learning Starter series is based on some of the notes and projects I work on. On the one hand is the accumulation of their own knowledge, to facilitate the upgrading of skills, on the other hand, and the small partners with the exchange of exchange, do a love to share the good citizens. Of course, at the end of the mix with their own a small wish, to change their own not to re-article the smell of the problem. Think about the time of the examination, if Chinese English more than a few, now may not fall to so ... (cough ~ ~), it is also very good. So let's cut into the opening.

Since learning the database, you have to throw a few questions.

1. Why a database is needed and what is a database

2. How has the database been developed and how it has gone through several processes

These two questions are also this note toad needs to answer, let us carry forward with the problem, this series of toads will adopt this problem-driven model.

I e-mail:[email protected]

Public Number: Hoptoad

Welcome to communicate with all

1 Why a database is needed

Let's go back to the beginning of 20th century, imagine the Coca-Cola Company's small partner A is busy to tidy up the day's sales data, to the customer classification, ordered by order size, and then count how many bottles of drinks sold today, after the small partner a put this bill into the security cabinet left. (Is it classified, sorted, counted, stored?) ）

After 10 years, IBM was founded in 1911 and partner a joined IBM. IBM has three companies that are list companies (founded in 1896 in Washington, D.C.), the Computing Watch Company (founded in 1901 in Ohio ) and the International Times record company ( 1900 founded in New York State Endicott). IBM was not called IBM but Ctr. Look at 3 companies, Toad said a little drunk, the first two companies are like-minded, the third company is clearly selling CDs.

With the company they started to make products, and what are the products? Do not be surprised to say, automatic meat cutting machine (to the cafeteria like the common), scales, etc., the most important is the punch card, and as the company's focus, small partner a can work hard. After more than 10 years, Ctr finally changed its name to IBM in 1924, and also to Canada, we know IBM finally appeared.

By the beginning of the 1932, that was Roosevelt eminence period, because of the economic depression, hardship ah, eat rice is difficult, not to mention the bread and beef, and do not mention doing scientific research products. IBM is able to devote to the card machine, not a few years to occupy the card machine market 80~90% share, is simply a monopoly. IBM took the opportunity to start a big splurge, basically the rhythm of a wealthy overnight.

In this way, after 7-8 years, in 1939, the Second World War broke out, but also has made a fortune opportunity ah. Before the Tuen had so much money not to spend it is not too wasteful, decisive IBM began to generate firearms and ammunition. Small partner A also began to produce M1 carbine and the Browning Automatic rifle . So the IBM hands are full of blood .... But Toad felt that even if IBM didn't do the gun, Coca-Cola would do it.

After the Second World War, IBM made another fortune. More money, IBM began to cooperate in the university, what computer ah, burning money or something.

A look, wrote a big half of all, the database has not yet, sorry ah, everyone, then go fast into the.

IBM developed the storage in the 50, this is a milestone thing ah, so that the electronic system can replace the card.

1964 IBM launched the System/360 mainframe. IBM was not investigated by the Justice Department in the middle of the 60 because it was too big for the computer industry.

Let the time freeze in 60, with the storage of the computer, the following, with him to do?

Here first to mention the subject of computer science and mathematics, in fact, the development of mathematics is very fast, think of that year Euler display a pen a piece of paper can be completed proof. The development of computer is based on mathematics, and its real advance is the development of basic science such as physical chemistry and the progress of manufacturing process.

Back in the middle of the 60, with the storage, the computer, and then what? Playing games? Sweep mine?

No,no,no

The real purpose is how to replace the small partner a when buying cola things (classification, sorting, statistics, storage)

Finally in 1969 IBM developed the first generation of databases, is the hierarchical model. The product is called IMS.

In addition a group of American database system language negotiations codasyl presented a mesh model, no products. (NET, just looks like a net, and the net does not have the relationship in fact) don't ask where Oracle was, Oracle founder Larry Ellison Something 25, estimated to be in school for girls.

to finally answer the first question, why do I need a database?

In fact, even if there is no database software, we actually long ago in the database this set in practice, such as 20th century out of the Coca Cola small partner a work content, but we with human development, science and technology Progress (storage, computer appearance), we crown and stately to those who used to be accustomed to things, work carried out some abstractions, It then redefined and added some rules.

2 Database development experience

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

The first generation of the database developed a period of time, IBM's small partner A also died, but there are small partners b,c,d it. Small partner B day with night following the research data model, finally a night dream of Mr Euler after Epiphany. In 1970, partner B published a relational model of data for Large shared data banks in the publication "Communication of the ACM" (the relational models for large shared databases ) "In this paper, the concept of relational model of database is put forward for the first time. This little buddy B is the "father of relational database", Edgar . Frank · cod (Edgar Frank codd or E. F. Codd). At this point finally led to my Dr. Codd, do not live doctor Ah, learn the database incredibly finally just asked out C odd Dr. name. In 1981, Codd won the Turing Award, the computer industry Nobel, because the Nobel did not set the data prize to mention the computer award.

Then, in spite of the fact that the contract was not due, Larry Ellison 1978 years to create a company called RSI; before the company was created, Larry also made code for the contracts that were not due to expire in other companies. Do you have any questions about what Larry is doing in the 7 years between 1970 and 1977? The Vietnam War? The Vietnam War was just over in 1975, just 2 years after the break. No,no,no. Larry is in the old club to work, is to achieve Codd master's database theory, they are implementing the database name is called Oracle (Larry later set up the company also named Oracle). By 1977, I probably think this theory can be realized when the sneak run, do not know some carry code to escape, if it is the history of the database is the first code theft case AH.

Then there was in the summer of 1979 RSI company launched the Oracle Software, 1982 company renamed Oracle.

IBM also launched the DB2 in 1983.

From this relational database to the high-speed development of the road, so far toad hand is still relational data software.

In this article, the next note, "Database Basics"

One of the Oracle Learning Starter Series Database development and history