Random talk on database (1)

Time:2021-2-23

From studying in university to working on the performance optimization of professional database in the past 10 years, I have been in touch with database for 20 years. During this period, I have made countless mistakes and gained a lot, but they are all complicated. Every time I train new colleagues or talk with my peers, I have a myriad of ideas. In the aftertaste, I was very upset.

Recently, because I have a little spare time, I began to fall in love with writing some online articles, so I decided to write a series of database ramble, and take this opportunity to sort out my experience over the years. If you don’t ask for a lot of fans, it would be very gratifying to let others take less detours.

Let’s talk about the history of the database first, even if it is an introduction to this series of articles.

The development of database is closely related to the development of computer technology, but there is a demand for database before the computer is made. From the earliest rope to modern account books, they are all the rudiments of database.

If you want to say that historical records like Lisao is also the rudiment of database, I will not object. But in this chapter, I mainly talk about the traditional concept of database, namely relational database system (RDBMS), so I unconsciously think of Mr. accountant’s account book.

After computers were made, people found it much more convenient to use them to record data such as books. So all kinds of data are quickly recorded into the computer’s hard disk.

However, with the increase of the amount of data, the search, update and daily maintenance of data are becoming more and more complex, so smart computer engineers think of developing a general structured query language.

Then, the famous SQL language was born.

By the way, the birth of SQL was not achieved overnight. Since 1966, Edgar Frank “Ted” Codd, a British computer scientist working at IBM, published the theory of relational database.

Then we developed the original relational database prototype system R in 10 years, and realized the initial design of SQL language. The paper was published in 1976《System R: Relational Approach to Database Management》

Unfortunately, system R is not a real commercial relational database. However, in 1981, corder won the Turing prize for his contribution to relational database, which is also a commendation to this legendary figure who served as an air force and participated in World War II.

Not long after koder published his paper, another computer legend, Larry Ellison, discovered its great commercial value and developed Oracle, the most commercial relational database, with the fastest speed.

At that time, Ellison had just left his last company, ampex, for the reason that “I know more about technology and market than the company’s leaders. If they can run the company, I can.”

So in 1977, he and two colleagues (Bob miner and Edward Oates) founded the software development laboratory In 1978, the company moved to Silicon Valley and changed its name to “relational software company” (RSI). In 1979, it released a commercial Oracle product, which integrates a relatively complete SQL implementation, including sub query, connection and other features. At this time, the CIA wanted to buy a set of such software to meet their needs, but after consulting IBM, they found that IBM had no commercial products available, so they contacted RSI. So RSI had its first customer.

As for why IBM developed its own prototype system, published papers, but did not develop commercial products. There are many possible reasons, but the following two are the main ones:

  1. Most of the IBM researchers have academic background, and they are most interested in theories rather than products that are put into the market. Academically, research results should be made public, because publishing papers and speeches can make them famous. Why not?
  2. IBM had a well-selling hierarchical database product IMS at that time. Launching a competitive product would affect the work of IMS sales staff.

It wasn’t until 1985 that IBM released relational database DB2, and Ellison had become a multimillionaire by then.

In 1982, Ellison also changed the company name to Oracle. Since then, the era of relational database king has come.

As for Oracle’s Chinese Name: Oracle Bone Inscriptions, it is because the Chinese Archaeological vocabulary “oracle bone” (tortoise shell and animal bone used to carve divination characters in Shang Dynasty) is translated into “oracle bone”. Oracle appears among them, and Oracle can express the business characteristics of Oracle: “oracle” literally means the record of data and information, which is consistent with the data stored in Oracle database. On April 26, 2002, Oracle announced the official use of “oracle” as the company’s Chinese registered trademark.

Because Oracle’s logo is mainly red and IBM’s is mainly blue, it is known as the “giant red” and “giant blue” in the computer industry. Now let’s take a look at the development of giant red.

In 1984, within three years, it successively entered Canada, the Netherlands, the United Kingdom, Austria, Japan, Germany, Switzerland, Sweden, Australia, Finland, France, Hong Kong, Norway and Spain. When it was listed in 1986, its annual income soared to 55 million US dollars. In March of the same year, it raised 31.5 million US dollars.

In 1987, its revenue reached 131 million US dollars. One year later, Oracle became the fourth largest software company in the world. Within two years, it will enter Mexico, Brazil, China, Cyprus, Malaysia and New Zealand. A year later, revenue doubled to $282 million.

In 1990, Oracle moved into Chile, Greece, South Korea, Portugal, Turkey, Venezuela, Taiwan, Belgium, Argentina, Colombia, Costa Rica and the Philippines within two years. However, in that year, Oracle's performance suffered a loss for the first time, and its market value plummeted by 80%. Ellison arranged senior managers to participate in the operation for the first time.

In 1992, the flagship product Oracle 7 came out, which put the company's business back on track with an annual revenue of $1.179 billion. Raymond lane, who was seen as Oracle's successor but was later ousted, served as coo.

In 1995, Ellison announced that PC was dead, pushed all products to the development of Internet, and set up another "network computer" company to sell "network computer", which was finally eliminated.

In 2000, when the science and technology network came to an end, it launched E-Business Suite to seize the market of application products, which constituted a serious conflict of interest with its former business partners. During the same period, Microsoft and IBM data technology improved. Since then, Oracle's share of the number of new orders fell by 6.6% in two years, and its business regressed by 10%.

In 2003, the hostile takeover of Renke software company caused a stir in the industry. Controversial news of the two companies emerged one after another. In the same year, the American judicial tribe case prevented the acquisition of Oracle.

In 2004, after 18 months of tug of war, we finally acquired Renke software company.

In 2007, it acquired bea systems.

On April 20, 2009, Oracle announced its acquisition of Sun Microsystems for $7.4 billion at $9.50 per share.

On February 4, 2013, acme packet, a manufacturer of network transmission products, was acquired at a price of US $29.25 per share, with a transaction scale of about US $1.7 billion.

Since July 15, 2013, Oracle has officially transferred from Nasdaq to New York Stock Exchange for listing. After the transfer to the New York Stock Exchange, Oracle will continue to use the trading code of "orcl".

In 2013, Oracle has surpassed IBM and become the second largest software company in the world after Microsoft.

On June 7, 2017, Oracle ranked 81st in the 2017 Fortune 500, with an operating revenue of $37047 million. 

In December 2018, the "2018 World Top 500 brands" compiled by the world brand laboratory was announced, and Oracle ranked 31st.

In May 2019, after Oracle laid off hundreds of employees in China, the company's Seattle office will lay off about 300 employees, and the total number of employees at the overall company level will reach thousands.

On September 14, 2020, Oracle confirmed that it had reached an agreement with the Chinese owner of tiktok to become its "trusted technology provider", but the agreement still needs us government approval.

At the end of this article, a speech delivered by Larry Ellison in July 2000 at Yale graduating class is attached. This undergraduate who has studied in three universities and has not got a degree severely mocks Yale University’s son of heaven. Because he did not stop talking, he was invited off the platform by Yale security.

A classmate left me a message saying that this speech was made up to make eye-catching fake news. I also investigated it on the Internet, and there was such a statement.
However, in this era when everything can be ruled by capital, no one can tell who is telling the truth. Quan should leave an egg for this article,
Keep it. ha-ha!!

Speech manuscript

Yale graduates, I’m sorry – if you don’t like the opening. I want you to do something for me.

Please take a good look around, look at the students standing on your left, look at the students standing on your right. Imagine this: five years from now, 10 years from now, or 30 years from now,

The person on your left today will be a failure; the person on your right is also a failure. And you, the guy in the middle, what do you think? They are also losers. The experience of failure. Failing top students.

To be honest, I stand here today and don’t see the bright future of a thousand graduates. I don’t see a thousand outstanding leaders in a thousand industries, I only see a thousand losers.

You are understandably depressed. Why am I, Ellison, a dropout, so brazenly spreading heresy in the most prestigious institution in America?

I’ll tell you why. Because I, Ellison, the second richest man on the planet, am a dropout, and you are not. Because Bill Gates, the richest man on the planet – for now – is a dropout, not you.

Because Allen, the third richest man on the planet, dropped out of school, and you didn’t. Just a little more evidence, because Dale, the ninth richest man on the planet, is still on the rise and a dropout. And you, not

You are understandably depressed. You need these useful work habits in the future. You need this treatment in the future. You need them because you haven’t dropped out of school, so you’ll never be the richest person in the world.

Oh, of course, you can, maybe, go your way to 10th, 11th, just like Steve. But I didn’t tell you who he was working for, did I? According to the records, he dropped out of graduate school and became a bit civilized later.

Now, I guess a lot of you, maybe most of you, are thinking, what can I do? Do I have a future? Of course not. It’s too late. You’ve absorbed so much that you think you know too much.

You’re not 19 anymore. You have built-in hats. Oh, I’m not talking about the degree hats on your heads.

Well You are already very depressed. This is understandable. So it’s probably time to talk about substance – not for you, 2000 graduates. You have been reimbursed and will not be considered.

I think you can sneak into that miserable job with an annual salary of 200000 yuan, where the payroll is signed by your classmates who dropped out of school two years ago.

In fact, I’m pinning my hopes on my classmates who haven’t graduated yet. I want to say to them, get out of here. Pack your stuff, bring your ideas, and don’t come back. Drop out and get moving.

I want to tell you, a hat and a suit of degree clothes will surely make you worse Just as these security guards are going to kick me out of this platform, it’s inevitable (at this point, Larry.Ellison Taken off the stage)

English manuscript

“Graduates of Yale University, I apologize if you have endured

this type of prologue before, but I want you to do something for

me. Please, take a good look around you. Look at the classmate on

your left. Look at the classmate on your right.

Now, consider this: five years from now, 10 years from now, even thirty

years from now, odds are the person on your left is going to be a

loser. The person on your right, meanwhile, will also be a loser.

And you, in the middle? What can you expect? Loser. Loserhood.

Loser Cum Laude. In fact, as I look out before me today, I don’t

see a thousand hopes for a bright tomorrow. I don’t see a

thousand future leaders in a thousand industries. I see a

thousand losers. You’re upset. That’s understandable. After all,

how can I,Lawrence “Larry” Ellison, college dropout, have the

audacity to spout such heresy to the graduating class of one of

the nation’s most prestigious institutions?

I’ll tell you why. Because I, Lawrence “Larry” Ellison, second

richest man on the planet, am college dropout, and you are not.

Because Bill Gates, richest man on the planet-for now anyway-is a

college dropout, and you are not. Because Paul Allen, the third

richest man on the planet, dropped out of college, and you did

not. And for good

measure, because Michael Dell, No.9 on the list and moving up

fast, is a college dropout, and you, yet again, are not.

Hmm … you’re very upset. That’s understandable. So let me stroke your

Egos for a moment by pointing out, quite sincerely, that your

diplomas were not attained in vain. Most of you, I imagine, have

spent four to five years here, and in many ways what you’ve

learned and endured will serve you well in the years ahead.

You’ve established good work habits. You’ve established a network of people that

will help you down the road. And you’ve established what will be lifelong

relationships with the word “therapy.” All that of is good.

For in truth, you will need that network. You will need those

strong work habits. You will need that therapy. You will need them

because you didn’t drop out, and so you will never be among the

richest people in the world. Oh sure, you may, perhaps, work your

way up to #10 or #11, like Steve Ballmer. But then, I don’t have

to tell you who he really works for, do I? And for the record, he dropped out of

grad school. Bit of a late bloomer.

Finally, I realize that many of you, and hopefully by now most of

you, Are wondering, “Is there anything I can do? Is there any hope

for me at all? Actually, no. It’s too late. You’ve absorbed too

much, think you know too much. You’re not 9 anymore. You have a

built-in cap,and I’m not referring to the mortarboards on your

heads. Hmm … you’re really very upset. That’s understandable. So

perhaps this Could be a good time to bring up the silver lining. Not for you,

Class of ’00. You are a write-off, so I’ll let you slink off to

your pathetic $200,000-a-year jobs, where your cheques will be signed by

former classmates who dropped out two years ago. Instead, I want to give

hope to any underclassmen here today. I say to you, and I can’t

stress this enough: leave. Pack your things and your ideas and don’t come

back. Drop out. Start up. For I can tell you that a cap and gown

will keep you down just as surely as these security guards

dragging me off this stage are keeping me down…”

(At this point The Oracle CEO was ushered off stage.)