下载PDF
Actian > 实例探究 > On the hunt for the next big medical discovery: Oxford University Clinical Trial Service Unit reduces the data supply process from days to just minutes thanks to Actian Vectorwise
Actian Logo

On the hunt for the next big medical discovery: Oxford University Clinical Trial Service Unit reduces the data supply process from days to just minutes thanks to Actian Vectorwise

技术
  • 分析与建模 - 实时分析
  • 应用基础设施与中间件 - 数据库管理和存储
适用行业
  • 教育
  • 医疗保健和医院
  • 生命科学
适用功能
  • 产品研发
  • 质量保证
服务
  • 数据科学服务
挑战
The Clinical Trial Service Unit and Epidemiological Studies Unit (CTSU) of the University of Oxford is involved in extensive bioresearch and healthcare studies. They extract and analyze data related to the causes, prevention, and treatment of chronic illnesses such as cancer, heart disease, and strokes. However, they faced a significant challenge when they realized that their existing database platform could not cope with the large data volumes involved in their research. The legacy platform struggled with complex queries, especially when they involved several thousand fields. The analytics could take days, which was not acceptable for the fast-paced research environment. They needed a solution that could handle high-speed analytics and deliver results within extremely fast timescales.
关于客户
The Clinical Trial Service Unit and Epidemiological Studies Unit (CTSU) of the University of Oxford is an organization that conducts extensive research in the fields of bioresearch and healthcare. They study the causes and treatments of chronic illnesses such as cancer, heart disease, and strokes, which account for the majority of adult deaths in the developed world. Through their involvement with the UK Biobank project, CTSU curates many thousands of pieces of information from over half a million volunteers and makes it available anonymously to the worldwide scientific community. Scientists all over the world can then use that data to find out more about the causes of illnesses, the links between the causes and diseases, and hence improve prevention and treatment. The organization is committed to providing fast, cost-effective technology to identify, manipulate, and extract exactly the data which researchers need and make it available to them within extremely fast timescales.
解决方案
CTSU decided to implement Actian's Vectorwise, a high-speed analytic database, to improve their analytics and service to their users. After installing Vectorwise, CTSU could change the way they mined and analyzed the data. The database allowed them to do aggregations, pivot the data, and sum the columns within a few minutes instead of a few days. The database was easy to use and did not require a steep learning curve or lots of hardware to benefit from its performance. The current Vectorwise deployment contains the UK Biobank data. User requests come in via the web from approved scientists and are then turned into database queries through custom scripts. As such, CTSU does not need to use any specific ETL or BI tools to manipulate or visualize the data.
运营影响
  • Fast data loading; data loads take just minutes
  • Ad-hoc analytic queries against large data volumes accelerated dramatically from days to just seconds
  • Future-proofed analytic and reporting infrastructure with Vectorwise
数量效益
  • Data loading time reduced to minutes
  • Analytic queries against large data volumes accelerated from days to seconds
  • Complex queries that previously took days now run in just seconds or minutes

相关案例.

联系我们

欢迎与我们交流!

* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

Thank you for your message!
We will contact you soon.