180 likes | 305 Views
Ongoing Research P.Krishna Reddy IIIT, Hyderabad pkreddy@iiit.ac.in. COMAD 2008. Core Database Systems: Transaction Management. So far Transaction management Database systems Replicated databases Current work Speculative locking. T 1 releases lock on X. T 1 completes work on X.
E N D
Ongoing ResearchP.Krishna ReddyIIIT, Hyderabadpkreddy@iiit.ac.in COMAD 2008
Core Database Systems:Transaction Management • So far • Transaction management • Database systems • Replicated databases • Current work • Speculative locking
T1 releases lock on X T1 completes work on X T1: r1[X] w1[X'] r1[Y] w1[Y'] e1 c1 s1 T2: r2[X] w2[X'] r2[Z] w2[Z'] c2 s2 e2 time (i) 2PL T1: r1[X] w1[X'] r1[Y] w1[Y'] s1 e1 c1 T21 r2[X] w2[X"] r2[Z] w2[Z'] T2: s2 r2[X'] w2[X"'] r2[Z] w2[Z"] c2 e2 T22 time (ii) SL Speculative Locking: Example Speculation trades extra processing power for performance
Core Database Systems • Current work • Speculation to improve the performance of read-only transactions • Future: • Investigate how low cost CPU/main memory CLOUD to improve application and system parallelism and build • speculative operating systems. • Speculative transaction managers • Speculative web service managers
Data and Web data mining • Extraction of rare knowledge • Rare association rules • Improve search quality by extending ideas from social networks and other domains. • Recommend products which for every Indian consumer. • Create an online facility to retrieve similar judgements for lawyers and judges and reduce justice delivery period.
Data and Web data mining • User interfaces • Designing efficient data entry framework • to help e-commerce customers to reduce the time to select the product • Text mining • Exploit web directories for better text mining.
ICTs for Social Development • Through eSagu, make every Indian farmer to produce 100% export quality farm produce and increase income in the order of magnitude.
ICTs for Social DevelopmentICTs-based Agricultural Education • Existing framework • Agricultural experts visit land and learns the applied concepts • Proposed framework: • AEs learn practical knowledge by exposing themselves with huge number of farm situations captured under ICT-based learning framework • The farm situations are captured and indexed using ICTs such as data warehousing, image processing, video, and audio.
ICTs for Social DevelopmentICTs-based Agricultural Education • We have announced Post-graduate Diploma in applied agriculture and IT (PGDAAIT) • Similar to House surgeon course for MBBS students. • The ICT-based learning framework has three components • Data warehouse of crop care concepts (DWOC3) • eSagu Clinic • Field visits
ICTs for Social DevelopmentICTs-based Agricultural Education • DWOC3 contains • Data warehouse of virtual farm observation concepts which are captured through multimedia data including text, photos, video, audio. • DWOC3 contains farm situations indexed based on various concepts in a multi-dimensional manner.
ICTs for Social DevelopmentICTs-based Agricultural Education • In eSaguClinic, • a group of scientists deliver the agricultural advice based on the crop status information received in the form of digital photos and other information. • For PGDAAIT program, we will operate few eSagu local centers. • The students are exposed to eSaguClinic to learn the practical aspects. • Field visits • The students are exposed to field visits.
ICTs for Social DevelopmentBuild farmer ERP • Formal Problem Statement: Given • a region (say r1,r2…rl) , • number of farms (f1,f2…fm), • types of soil of each form (s1,s2…sn), • crop grown in each farm (c1,c2…co), • variety of the crop (v1,v2…vp), • weather type (w1,w2…wq), • water availability (wa1,wa2…war), • labor availability (la1,la2…las), • machines (c1,c2…cu) • the farmer can invest (m1,m2…mt) and • the type of market where his products can be sold. • Find the problems that can occur in the farms of a farmer, in various stages of crop cultivation. • Come up with an optimized plan for all the farms of a farmer, so that the magnitude of the problems can be reduced. Problem 6.
ICTs for Social DevelopmentImproving Literacy • Build an IT-based system to provide functional literacy (read, write, simple maths) to each and every illiterate in India without disturbing his/her daily routine (earning source or power).