Fast and Seamless Data Access using FILESTREAM

liangcixingmajia 2008-08-21 03:36:52
One of the factors behind the need for speed in accessing data is that race teams collect so much information. “A racing team might collect 2 or 3 terabytes of data per year, and need the ability to access 4 or 5 years worth of data,” says Spence. “So the volumes are large. SQL Server 2008 enables us to use the FILESTREAM mechanism to point to a BLOB and stream it, providing much faster access than we would get through a typical table query.”

The unpredictability of racing is another major force behind the need for immediate access to large volumes of ECU data.

“The reasons teams gather so much information is that you're never absolutely certain as to what you will need to look at during a race or during a test,” says van Manen. “What you do know is that any decision making, especially during a race, will have to be made nearly immediately. A team has a massive amount of data to guide their decisions, but they need the ability to access that data swiftly and precisely. If they need to compare data points with earlier runs, all of the earlier examples need to be immediately accessible for comparison. With Formula One, you are operating within a very impatient world.”

Spence agrees about the demands of working within an impatient world: “The most important thing to the team is the speed of access. “We all know how frustrating it is if you load something on a computer and you have to wait for a minute. When you're in the racing environment the pressure is intense. You need a robust, high-performance system when you’ve got someone shouting at you, ‘We need to know what to do before the car goes!’ The proof of concept demonstrated that SQL Server 2008 and FILESTREAM clearly outperformed our file system, while greatly improving data integrity.”

The combination of performance, data integrity, and robustness has made McLaren Electronics eager to offer its database solution to all Formula One teams.

“To support the racing teams we need three things from a database: performance, integrity, and robustness,” says van Manen. “If you can find all three, you’ve got a winner. SQL Server 2008 wins on all three points.”
...全文
84 8 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
8 条回复
切换为时间正序
请发表友善的回复…
发表回复
正宗老冉 2008-08-22
  • 打赏
  • 举报
回复
很有前景的功能...打算一试.....
primer_programer 2008-08-22
  • 打赏
  • 举报
回复
up
yangkunjie 2008-08-21
  • 打赏
  • 举报
回复
接着跟
wolfgang_l 2008-08-21
  • 打赏
  • 举报
回复
[Quote=引用 3 楼 liying1985 的回复:]
又来?
[/Quote]
sxn19811006 2008-08-21
  • 打赏
  • 举报
回复
[Quote=引用 2 楼 woaisf 的回复:]
up
[/Quote]
AI码农客服 2008-08-21
  • 打赏
  • 举报
回复
又来?
woaisf 2008-08-21
  • 打赏
  • 举报
回复
up
stonekind 2008-08-21
  • 打赏
  • 举报
回复
so? wht do u want 2 talk abt?

6,128

社区成员

发帖
与我相关
我的任务
社区描述
MS-SQL Server 新技术前沿
社区管理员
  • 新技术前沿社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧