Best Database Design

The concept of blockchain to technology has been around for a long time, but with the heat of the past two years, it has gradually become known by the market and many technicians.

A good database product is not equal to have a good application system, if can not design a reasonable database model, not only will increase the client and Server section program programming and maintenance of the difficulty, and will affect the actual performance of the system. Generally speaking, in an MIS system analysis, design, test and trial run stage, because the data quantity is small, designers and testers often only notice the realization of the function, but it is difficult to notice the weak performance, until the system put into actual operation for some time, only to find that the performance of the system is decreasing, At this point to consider improving the performance of the system will cost more ...

In fact, in order to ensure the Oracle database running in the best performance state, the database optimization strategy should be considered before the http://www.aliyun.com/zixun/aggregation/32730.html "> Information system development." Optimization strategy generally includes server operating system parameter adjustment, Oracle database parameter adjustment, network performance adjustment, application SQL statement analysis and design, in which the application analysis and design is before the information system development ...

April 24, we released a preview version of the SQL Database base level (preview) and standard (preview) new service levels and new business continuity features. In this blog post, we delve into the performance of new levels in SQL Database. Begin with the need for change. We focus on performance (specifically predictable performance) in new service levels, driven primarily by strong customer feedback on SQL Database Web-Level and enterprise-class performance. Web-and enterprise-level performance ...

The development of the big data industry has been included in the National Development plan, and in 2014, "Big Data" first appeared in this year's "Government work Report". 　　"Government work Report" pointed out that to set up new industries entrepreneurial innovation platform, in large data and other aspects of overtaking advanced, leading the future industrial development. Large data construction is inseparable from high-performance database software, unfortunately, the current database market in China, Oracle [micro-BO], ibm[Micro-BO] as the representative of the foreign database software is still in the dominant position, a lot of database software for the government procurement is still accustomed to using foreign products, ...

Storing them is a good choice when you need to work with a lot of data. An incredible discovery or future prediction will not come from unused data. Big data is a complex monster. Writing complex MapReduce programs in the Java programming language takes a lot of time, good resources and expertise, which is what most businesses don't have. 　　This is why building a database with tools such as Hive on Hadoop can be a powerful solution. Peter J Jamack is a ...

It was easy to choose a database two or three years ago. Well-funded companies will choose Oracle databases, and companies that use Microsoft products are usually SQL Server, while budget-less companies will choose MySQL. Now, however, the situation is much different. In the last two or three years, many companies have launched their own Open-source projects to store information. In many cases, these projects discard traditional relational database guidelines. Many people refer to these items as NoSQL, the abbreviation for "not only SQL." Although some NoSQL number ...

After more than eight years of practice, from Taobao's collection business to today to support all of Alipay's core business, and in the annual "Double Eleven Singles Day" continue to create a world record for the transaction database peak processing capacity.

1.1: Increase the secondary data file from SQL SERVER 2005, the database does not default to generate NDF data files, generally have a main data file (MDF) is enough, but some large databases, because of information, and query frequently, so in order to improve the speed of query, You can store some of the records in a table or some of the tables in a different data file. Because the CPU and memory speed is much larger than the hard disk read and write speed, so you can put different data files on different physical hard drive, so that the execution of the query, ...

In the siege of large manufacturers such as Oracle, IBM and Microsoft, domestic database makers are still struggling to survive. This is an undeniable fact that the database market is close to saturation, especially in the face of the relationship between the transaction database field, foreign manufacturers start early, rich in resources, and also continue to encroach on the market segments, has formed a huge advantage. Faced with this situation, the South's general CTO Vounie that the domestic database manufacturers have missed the best time, should not take their own short board (OLTP) to go head-to-head, but should be in the direction of OLAP. Accompanied by large data ...