张仲奇AdvancingDeclarativeQueryintheLongTailofScience.ppt

Advancing Declarative Query in the Long Tail of Science,Bulletin of IEEE Computer Society Technical Committee on Data Engineer,Abstract,Long tailRelational databaseDelivery vectorSQLShareNon-programmer,Long tail,P.Murray-Rust and J.Downing.Big science and long-tail science.http:/blogs.ch.cam.ac.uk/pmr/2008/01/29/big-science-and-long-tail-science/,term attributed to Jim Downing.,Abstract,Long tailRelational databaseDelivery vectorSQLShareNon-programmer,Summary,Compete with other lightweight languagesIncrease collaborative data sharingReduce 9-to-1 ratio of timeEven non-programmer responding positivelyA simplified interface,Introduction,9-to-1SQLShareStarter kitAllow me to do science again,Metagenomics as Set Manipulation,Illustration of the steps in an algorithm to(a)identify the surface of proteins,(b)calculate various statistics,and(c)synthesize“stealth”molecules that could mimic the protein surfaces.The use of SQLShare provided opportunities to exchange“a 10 minute 100 line script for 1 line of SQL.”,S.Tringe,et al.Comparative metagenomics of microbial communities.Science,308(5721):5547,2005 Apr 22,SQLShare System Details,No schemaUnifying Views and TablesIncremental UploadTolerance for Structural InconsistencyMetadata and TaggingAppend-only,Copy-on-WriteSimplified Views,Thanks,