We know that there is a lot of data to be stored in finance, in fact, not only in finance, with the development of the information age, we generate more and more data, we use these data analysis, forecast future trends, make our life more convenient. So, how do we usually manage the data? Here, we need a tool-the database.
Common database Tools are Microsoft SQL Server, Oracle and MySQL Oracle. Of course there are a lot of other database management tools that we don't list here. Let's take a rough look at these three common database tools.
The first is Microsoft's SQL Server:
Because it is Microsoft's product, SQL Server and Microsoft's Microsoft BackOffice can be well assembled. SQL Server is also fully integrated with Windows NT, leveraging many of the features of NT, such as sending and receiving messages, managing login security, and more.
It is generally used in large database management, supporting XML, that is, our tabular files, powerful web-based analysis, these are the advantages of SQL Server;
Next is Oracle for Oracle:
Highly efficient and reliable database solution for high throughput. Its schema objects include structures such as tables, views, sequences, stored procedures, synonyms, indexes, clusters, and database chains. Logical storage structures include table spaces, segments, and scopes that describe how to use the physical space of a database.
If you are interested, you can check the development of this company, it is very interesting. Perhaps you did not know before, but, after checking, you may be impressed, than read the novel is also wonderful, although this is standing in my point of view, Hee ^_^.
Finally, MySQL:
MySQL, originally not Oracle, was developed by the Swedish MySQL AB company, but was later acquired by Oracle as the market share increased. The way this acquisition is also an interesting story, you can find a time to find out.
Next, we say the advantages of MySQL, mainly lightweight, free, free, and free, MySQL is one of the most popular relational database management system, in the WEB application, MySQL is the best RDBMS, although I always think it is because of free is the premise, O (∩_∩) o haha ~ MySQL is open source software, so you can significantly reduce your total cost of ownership. It is written in C and C + + and tested with a variety of compilers to ensure the portability of the source code.
OK, today's content is here!
(if the article image and part of the content is infringed, please contact the author to delete)
Database Small Science