The history of programmers ' struggles (38)--University dynastic History (ii)--My story with the database

article/. Wen soldier

Inert people have, but also is a human nature. A few days before the idea of this article, Zennai daily chores, today only to mention pen, make this article. This article talks about my story with the database.

Talking about and database, but also from the freshman. Freshman first started to touch the C language, immersed in endless code every day. In the process of online search information, see others in C language wrote a small book operating procedures, the database is SQL Server, run out of the very dazzle, Marvel originally can also manage the data. Familiar with the C language of the students are certainly not unfamiliar with the file operation, when we write the program if there is static data, are placed in the file. Until later do the C language course design, I am also a lot of files to save static data. At this point in the heart has a small seed, who knows will later take root germination.

Freshman year, the summer of the next, began a laboratory tour. In the lab every day is self-taught, which comes into contact with SQL Server and MySQL, about the laboratory of all kinds of things, will be in detail later. The first contact with SQL Server, I used my broken network to download the number G large database installation files, later only to know our school Sun Software Station has, and download speed of up to more than 10 m per second. After spending a few days to download the software, in the Baidu Library to find a installation instructions, follow the steps. The whole process is not so smooth, and SQL Server is very memory-intensive, several times the machine is not responding to the state, a toss, finally fixed, not to mention how excited. Then start the service, open SQL Server manageorgiament Studio, the database is not the only thing I even a log on a half-day toss. Enter the main interface, do not know what to do. Later, at the suggestion of the lab teacher and seniors, I began to learn the basic knowledge of SQL on the world of Science. Write a query, the data that satisfies the specified conditions is presented in front of you; with an INSERT, you can insert the data you want into the database, update it to the data you want, and write a delete to delete the unwanted data. Such a simple statement can realize the original thought very powerful function, have to lament the magic of the database. Later read Brother project source code, found that the database is using MySQL, so began to toss MySQL. MySQL is easier to install under Windows, but it is a long time to do so, and many of the database configuration options are not very clear. But with some of the basics of SQL Server, it's relatively easy to learn MySQL. Having contacted these two databases and had a bit of knowledge of the Java Web, I began to do the project. The beginning of the project is practiced hand, nothing more than to connect to the database, and then to make additional deletion check. Connect to the database using JDBC, this process also encountered a lot of problems, such as the driver version is not correct, Chinese garbled, not correctly submitted data and so on. I have a habit, is to encounter problems like their own, in the case of a last resort, do not ask others questions. Enter the laboratory soon, due to find information online, many links are directed to Csdn, so opened the CSDN blog, this is the beginning of the right thing.

The sophomore year began contacting Oracle. Oracle is also a huge software, after downloading the installation files on the Internet, follow the installation documents on the Internet, step by step to start the operation. When the installation is complete, Oracle is started, and the database software runs pretty tough, 2G of memory represents the pressure, and anything else you do after running Oracle is not going to happen. Learn Oracle First in accordance with the predecessors of the blog gradually, from the basic SQL, to PL SQL, to the simple optimization, the whole process of learning is smooth, there will be no very strenuous situation. At this time I have great enthusiasm and interest in the database, and gradually formed the future values of struggle.

Sophomore opened a database-related course, remember the course called "Database principle." Before the formal class has a little time to prepare, the database is more familiar with me in front of the students have a sense of superiority, many students to my there copy database installation files, and trouble me to install the database for them. After several times of help, the whole operation has reached the point of knowing. The teacher who teaches database principles is very humorous, and occasionally bursts out a cold joke in class to make people laugh. Because of the previous contact with the database, so the database introduction, the basic theory of relational database, basic SQL and so on knowledge learning is relatively easy. Sophomore I like to soak in the library, often read the computer books on the four floor, see two huge books, one is Abraham Silberschatz "database system Concept", and the other is David M. Kroenke "Database principle", so thick of the book is a long time to read , not to mention the creation. I carefully took my hands off the bookshelf, happily holding the desk to read, for one or two hours, the author can not help but awe. These books are classics, certainly have his reason, want to go into the database, these books are must read.

In the process of learning database knowledge, we will inevitably encounter a variety of problems. After encountering the problem, I first try to solve their own, I can not solve the other people's solution, after the solution and then use their own way to summarize, and then in the form of blog post. The benefits of this learning approach are so great that readers may wish to learn from it. Later, learning the database is a bit more in-depth. For example, after working, became a SQL Server DBA, began to look at SQL optimization knowledge, and used in practice. A lot of T-SQL is also written to check performance bottlenecks during the work. MySQL, for example, learned about MySQL's high-availability, high-performance technology, such as master-slave replication in replication, dual-master replication, a master-multi-slave, highly available, high-performance clustering scheme, such as Lvs+keepalived+mysql, MySQL Proxy, drbd+ Heartbeat+mysql, MySQL MMM, MySQL Cluster, MySQL MHA, and so on, but also access to MySQL backup and recovery, such as cold, hot spare, incremental backup, thermal copy, delayed backup, etc., also exposed to the MySQL architecture, Familiar with the common storage engine, later also read a lot of MySQL related books, read some of the MySQL source code, so profound technology, know Rome cold day, but also need to spend a lot of kung Fu. Oracle, for example, is exposed to the installation and configuration of Oracle under Linux, Oracle's architecture, Oracle Backup and Recovery, DG, RAC, Oracle optimization, and more. Read a lot of Oracle Daniel's books during the period, such as Gai, eel with and so on. In the csdn of private messages, know, OSC, itpub, often someone asked me questions, I help others to solve the problem while also get a relatively big improvement. In this process learned how to quickly seek "help", how to share their own ideas, how to communicate effectively with others, but also learned that learning technology is not learning technology itself, but the essence of technology behind the problem. In the future to engage in the database industry there is a long way to go, with a "long way to repair the road, I will be up and down and quest" to motivate themselves.

Writing here has completed the entire university database journey, looking back at the whole journey, there are plenty of places to think about. Here is only one thought, that is why to learn and drill into the database, and regard him as the future career direction, the individual is considered an interest problem. As to what the interviewer thinks about me. An interviewer asked me this question, I answer is the interest, he said in fact very simple, is only for money, then I can only use hehe to smile, can only say that everyone's pursuit is not the same. Some people run for money, some people to achieve their own value and struggle, some people in the life of mediocrity, some people have accomplished many achievements in life.

Combined with their own experience, in the future want to engage in the database industry to learn younger brothers have a few suggestions. The first is to understand the motive, want to know whether they are suitable for this industry, do not because of the database pay to follow blindly. The database industry appearance is bright, the substance bitter force, and did not imagine so beautiful. The second is to master good learning methods, such as the previous mentioned through the blog to form their own knowledge base, to learn from the predecessors, practice and summarize and so on. The third is to encounter problems in the way of help, do not encounter problems to ask others, if not through their own thinking, then your ascension will be very small. If you have to ask for help, you can use the form of post or with the technical Daniel, but please pay attention to the way you ask questions, the cause of the problem, what conditions lead to such errors, the wrong platform, the corresponding error message and code to speak clearly, but also need to pay attention to the format of the message and the necessary etiquette. Do not only want to make oneself comfortable, more important is to make others comfortable. The other is to grasp the basic skills. Studies have shown that many of the most successful entrepreneurs have sold newspapers before, as a child of the formation of the entrepreneurial lad will play a vital role in the future development. The basic knowledge of a certain field is the basic skill, and the lad work has a very similar function. The foundation is not strong, why become towering building. To implement, the database of the classic books must be found to read, there is the more simple things need to figure out why. Five is not to be ambitious. In my usual job search process, I see a lot of companies pay, with 2 years of experience in the monthly salary of more than 20,000 of the minority. Other people can drive so high salary, sure you do the job worthy of this salary. The higher the pay, the greater the responsibility. On the other hand, down-to-earth can make a difference in the future, when you have the ability to worry about pay. Yesterday on the microblog saw a sentence, cattle b talent do not have to find a job, think it is not unreasonable. The sixth is to find like-minded friends, learn from each other, and this will be greatly improved. For example, I was fortunate to meet @ Lin Shubin, in peacetime he gave me a lot of help, in this thanks! The seventh is to find the database related work do not be discouraged, do not abandon themselves, do not blame the injustice of God, why do you say so? Because fresh graduates find database related work is relatively difficult, a hard indicator of experience will shut you out. To believe that everything is able to live, you have the ability, good luck, and the company is willing to train you, that congratulations to you, the future is bright. If the graduation can not immediately find database-related work, you can do other industries, and then consider the transformation. The direction is there, always wrong. I hope this article will bring a little help to the readers.

Poetry and distance exist forever. Writing a shocking poem, the heart can be overlooking the distance, accompanied by the scenery along the way, walking alone.