High Capacity Databases

by Anthony T
The article is about Fusion-io and the capabilities it has been able to achieve through integration of a 64 core server. The company boasts over one million transactions per second which was made possibly by a Microsoft SQL Server database. The article mentions the importance of this milestone in regards to the shopping season. It also mentions details to how this immense number of transactions was achieved. The test they ran consisted of 150 billion rows which were placed on one table in Microsoft SQL Server. The outcome was over one million singleton inserts per second. The article went on to talk a little about the actual company and gave a very brief overview. Fusion-io focuses on data decentralization which significantly increases the processing capabilities of data centers. Data decentralization is basically the process of changing the location of “active” data from a central location to the server.

 

This article really puts into perspective the immense processing capabilities that servers are able to achieve. It is really interesting to learn that companies are currently experimenting with technology that we are learning about in class such as Microsoft SQL. It has actually motivated me to want to learn how to use and implement Microsoft SQL.

Fusion-io demo runs the equivalent of all global credit card transactions from a single server. (2011, Nov 30). PR Newswire, pp. n/a. http://search.proquest.com/docview/906629706?accountid=10357

2 thoughts on “High Capacity Databases”

  1. That is amazing how much capacity one server can process. I would think that this server has several terabytes of storage on top of the 64 core. Do you think the length of each row was long or short?

  2. I would assume the length would be long considering that each row has to have all the data involved in a credit card transaction from customer information like address, bank routing number, etc to sellers information. It is pretty amazing that all transactions made world wide can be done by one server, but at the same time it is kind of scary. Imagine the damage possible if that one server was to have a key logger or some other kind of security risk.

Comments are closed.