How To Create Database Schema

As a software developer or DBA, one of the essential tasks is to deal with databases, such as MS SQL Server, MySQL, Oracle, PostgreSQL, MongoDB, and so on. As we all know, MySQL is currently the most widely used and the best free open source database, in addition, there are some you do not know or useless but excellent open source database, such as PostgreSQL, MongoDB, HBase, Cassandra, Couchba ...

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 ...

Editor's note: This article from Liouville Contribution (micro-blog @ Liouville Life Road), engaged in the cloud computing industry for many years, from personal experience, and with some Google, Jingdong and other companies cloud computing architects to share the experience of the summary, for you to analyze what is a "shared database." What is a shared database talking about "shared databases", what puzzles us most is "sharing" three words. "Sharing" lets us think of the antonym "exclusivity". Yes, the shared database is a comparison of the exclusive database of the user resource ownership of the database title, it is the companion ...

In real life, backing up the database regularly is a very important thing. 　　When we use MySQL, there is a lot of choice in database backup, and this article will show readers how to use MySQL's mysqldump to back up the database. First, the importance of data backup work, if the accidental deletion of important files or directories, then the result will be miserable. Especially when the data that is accidentally deleted involves important customers or key projects, and the data can't be recreated easily, it doesn't have to be what I say you can imagine. Unfortunately ...

&http://www.aliyun.com/zixun/aggregation/37954.html ">nbsp; For Telecom Enterprises, database security is very important. Just imagine the problem with the recharge system? What happens to the system when a mobile phone user checks the bill at the end of the month? The following is a telecom enterprise database operators in the database security aspects of some of the experience, as well as the star-Chen database security experts to give suggestions, hope to have some inspiration and reference. Database version ...

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, ...

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.

"51CTO exclusive feature" 2010 should be remembered, because the SQL will die in the year. This year's relational database is on the go, and this year developers find that they don't need long, laborious construction columns or tables to store data. 2010 will be the starting year for a document database. Although the momentum has been going on for years, now is the age when more and more extensive document databases appear. From cloud-based Amazon to Google, a number of open-source tools, along with the birth of Couchdb and MongoDB. So what ...

HBase is a distributed, column-oriented, open source database based on Google's article "Bigtable: A Distributed Storage System for Structured Data" by Fay Chang. Just as Bigtable takes advantage of the distributed data storage provided by Google's File System, HBase provides Bigtable-like capabilities over Hadoop. HBase Implements Bigtable Papers on Columns ...

Dzo is a database object that processes the source code of the application in the same way, and can develop, revise http://www.aliyun.com/zixun/aggregation/9591.html "> Version control and deploy the application. Dzo uses a text file to create local statements for all database objects and compares them to the actual database schema. Dzo can create SQL statements that need to update the database schema (or you can let Dzo execute SQL statements directly). If in ...