2. The amount of data is large, such as tens of millions of levels. Using postgresql, known as benchmark testing Oracle, it is still possible to process tens of millions of levels of data, and it is also easy to learn and use.
3. The amount of data is average, such as millions. With mysql, mysql can handle this level of data faster.
4. The amount of data is small, such as100000 or less, and both sqlite and access can be used.
The above data is based on single table operation, so you can choose it at will.
Which is better, an easy-to-use database? It depends on your purpose. If the amount of data is small (about 65438+ ten thousand), you can pursue simple and free sqlite. If the amount of data is large, professional mysql and postgresql can be used in consideration of high concurrency and distribution. Let me give you a brief introduction. Interested friends can try it:
Small and flexible sqlite is a lightweight relational database developed based on C language. It is short and pithy, free and open source, and can be used directly by individuals without complicated configuration. It provides rich API interfaces for various programming languages, and java, python, c# and so on can be easily operated. If the amount of data stored is very small, and it is only a local simple operation (read more and write less), you can use this database, which takes up a lot of memory.
Professional and powerful mysql This is a relational database that should be widely used at present. It is free and open source, cross-platform, and has always occupied a major position in the development of information systems. If you are engaged in web development or website background construction, then this database must be very familiar and support high concurrency and distribution. Compared with sqlite, it stores more data and is more secure. Indexes, triggers, stored procedures and other functions are very good, supporting data import, export, backup and recovery, as long as you are familiar with the basic use process.
Free and open source postgresql is an object-relational database (free software) developed by the Computer Department of the University of California. It is free, open source and cross-platform, and supports streaming computing, full-text retrieval, pattern search, parallel computing, stored procedures, spatial data and K-V types. Compared with mysql, it is more stable and superior in performance under complex queries and high concurrency, and has very good scalability and maintainability.
Of course, in addition to the above three databases, there are many other databases, such as mssql and oracle, which are also very good and are more than enough for data storage and processing. As long as you are familiar with the basic use process, you will soon be able to get started. There are also related tutorials and materials on the Internet, which are very detailed. You can search if you are interested. I hope the content shared above can help you, and welcome your comments and comments to supplement it.
Access is the most suitable for beginners to understand and get started, because it and Excel are originally a suite, and it is easy to convert each other, just copy and paste, and it is very easy to understand the concepts of library, table, field and key.
If the amount of data is not large, it is highly recommended to try Filemaker, script programming and freely customize the input interface and workflow, which is very convenient and efficient.
Recently, Airtable is concise and efficient, with beautiful interface, equivalent to spreadsheet operation, and its development momentum is also very rapid.
The focus of the two is different, and users can choose according to their needs.
As a software developer, I need to deal with databases for a long time. I prefer MySQL. Although some people may suggest that you use Access database because of your Excel, based on my personal opinion, I don't recommend that. The specific reasons for adopting MySql are as follows:
1.MySQL is universal. In the domestic environment, the vast majority of Internet companies use MySQL. With a broad user base, we can find better ways to solve various problems online.
2.MySQL is lighter than Oracle, and you don't need to use Oracle for data of the order of Excel. At the same time, MySQL is completely free, so don't worry about copyright and fees. It is a good choice for individuals and enterprises with limited budgets.
3.MySQL is highly compatible with standard SQL, which can greatly reduce the learning cost of migrating to other databases in the future.
I hope my answer can help you! ! ! [yeah] [yeah] [yeah]
Excel office is really convenient and can do some simple data analysis, but it involves many complicated data operations, and it will encounter the same problems as the topic, and the operation speed is slow. If the host performance is not very good, it may also face problems such as computer crash and data loss.
How can we solve this situation? The importance of the database is obvious!
Now, I will spend 3 minutes discussing with you what kind of database to choose and why. Is there a better solution?
MySQL database, 90% of enterprises will choose it. Choose a good database to ensure the data security and asset security of the enterprise. So how do you choose a database? This is closely related to your business volume and business service industry.
If you just punch in at work, use SQL server.
If you want to store session information, user configuration information and shopping cart data, it is recommended to use NoSQL database;
However, 90% of enterprises or individuals prefer MySQL database.
Why do you say that? Because it has the characteristics of low cost, high availability, strong reliability, easy use, small size and fast open source, it occupies unique advantages in the application fields of finance, finance, website and data processing.
This is why almost all enterprises choose it to store data.
In addition, MySQL database supports a variety of storage engines, supports large databases, can handle thousands of records, and also provides tools for managing, checking and optimizing database operations.
Therefore, MySQL is especially respected by individuals and small and medium-sized enterprises.
Although MySQL database is very useful, I still won't deploy it. What should I do? Don't worry, there is a new office software with its own database on the market now.
For example, the more powerful excel-compatible office software Yun Biao Enterprise Application Platform is embedded with MySQL database. (There is a free access method at the end of the article)
What are the advantages of MySQL database embedded in Yun Biao? 1. The performance is more optimized and more compatible with the system. Because R&D personnel in Yun Biao constantly update and maintain MySQL database.
2. Save yourself the trouble of manual deployment. However, if you are familiar with the deployment database and want to change the database to a database such as Oracle or SQL server, you can also set it up. (However, I suggest that Xiaobai should use it directly. )
3. Fast real-time calculation. The real-time interaction of data analysis fully meets the temporary analysis, changeable business requirements and frequent result refresh in management decision-making.
4. With its own in-memory computing engine, the IT department will bid farewell to the report delay analysis and billion-dollar data second-level response without establishing cubes in advance.
Is the embedded MySQL database reliable? Yun Biao is not only an office software, but also a development tool.
Through it, you will solve the following problems:
Complex data operation, authority control accurate to rank, workflow, a large number of users working online at the same time, data perspective, making sales orders, contract negotiations and other forms and reports, making one may lead to repeated employment. ......
You can also use it to connect electronic scales, weighbridges and so on. , and integrate with UFIDA Kingdee and other three-party systems to generate bar codes, scan codes and store them, and generate mobile phone apps ... Basically, you can trust it to complete all the functions required by the business.
Its biggest highlight is that it can use excel to develop business applications.
Moreover, after visual drag and drop, ERP, WMS, OA, invoicing and other business applications. It also inherits the functional characteristics of MySQL database addition, deletion and query.
Yes, the business application developed by Yun Biao can be re-developed, and the function can be added, deleted and queried at any time, which can easily meet the demand of refined data management and control of large groups.
However, everyone should be most concerned about data security.
The data is stored in MySQL database embedded in Yun Biao, so it is safe and not lost. It provides a variety of data storage methods, including local deployment, cloud deployment and mixed deployment, for you to choose from!
Therefore, large groups such as Hengyi Petrochemical, Xuji Electric, Science, Technology and Industry Committee for National Defense, China Railway, China Metallurgical Group and Yunnan Komatsu encourage their internal employees to learn from Yunbiao.
Space is limited, so far, you won't read too much.
The free soft access method is as follows:
Databases are very useful. It can not only realize data sharing and reduce data redundancy, but also realize centralized control of data and maintain data consistency and maintainability. Choose a simple and easy-to-use database. Any good suggestions? Let's take a look at the message!
The theme emphasizes simplicity and ease of use. So I recommend the simplest three.
1. Enter.
2.Excel .
3. Flying books, Tencent documents, graphite documents and other forms.
If you want to do analysis, the amount of data is relatively large, it is recommended that Access is better, or professional. There are also many online tutorials, which are relatively easy to learn. And it is recommended to use an earlier version, such as 2003 or 2007. In recent years, Microsoft has been trying to remove Access from office. But there are still many people using it, so they dare not open it. However, a disgusting method is used to make users give up, that is, every time a new version is released, some useful functions are removed, so the earlier the access, the stronger the function.
Another recommendation is the express version of SQL Server, which is a free version of SQL Server. It is free, has basic functions and is much more powerful than sqllite.
It depends on your actual situation. If you have a computer foundation and know a little about databases, all the software on the market can be used, such as oracle, sqlserver, mysql and so on. Getting started or sqlserver is faster and the interface operation is more intuitive. If you have no foundation at all, but want to analyze the data, you can use an access that comes with Microsoft, which is faster to get started. After deciding which one to use, you need to buy some teaching materials. Simple sql query can improve work efficiency after proficiency.
If individuals use databases, SQLite is enough to store data without analysis.