best database for large data

I. Brief introduction of the expertsVOLTDB's chief technology officer, Ryan Betts, says that SQL has won widespread deployments of large companies, and that big data is another area that it can support.NoSQL is a viable option and, in many ways, it's the best choice for big data, especially when it comes to scalability, says Bob Wiederhold, chief executive of Cou

Tags: Online factor cpu accurate 3.2 determines creat memory self-incrementdatabase optimization includes the following three parts, database optimization, database table optimization, program operation optimization. This article is the first part Database performance Optimization One: Database self-optimization optimi

Boss said that we should try to avoid using join to query a large amount of data at ordinary times. We would rather query the data in a table at a time and then use the data for query. We should not use join to divide the data into multiple queries as much as possible, pleas

in that area, and we know that the number of numbers in this area is just the median number. And then the second scan we only count the numbers that fall in the area. In fact, if not int is int64, we can go through this division 3 times to reduce to acceptable levels. That is, the int64 can be divided into 2^24 areas first, then determine the number of regions, in the area into the 2^20, and then determine the number of sub regions, and then the number of 2^20 in the subregion can be directly

4. Importance of clustered indexes and how to select clustered Indexes In the title of the previous section, I wrote: The general paging display stored process for small data volumes and massive data. This is because when we apply this stored procedure to the "office automation" system, the author finds that the third stored procedure has the following phenomena when there is a small amount of

session cache, this is the first level of cache, if we have been running the save and other operations, the cache will be more and more things, the speed is more and more slow, the server has been hibernate, naturally will increase the load. This is hibernate is not good at the place, and the first-level cache can not be used, if we want to save the amount of data is very large, then in the program to add,

Boss said that the usual query data large data to avoid using the join would rather once the data of a table to find out to use this data to do the query and do not use too much of the join as much as possible into the query to do, please the big God to say that the SQL opti

table belongs to the user, MySQL database has many databases, the table belongs to the database, the database set different access rights for different users.Seven, Sqoop and flume the same and different:Same: Sqoop and Flume are data acquisition engines.Different: Sqoop features: Batch

A few days ago, I used the database separation method to clear the database logs corresponding to a MOSS site (the log file expands too fast, and the correct method is compressed ). I found that the database corresponding to a MOSS site has crashed. Although I have backed up the complete mdf and ldf files, put them in the dat