Transcript P.K. Reddy - CSE, IIT Bombay

Ongoing Research
P.Krishna Reddy
IIIT, Hyderabad
[email protected]
COMAD 2008
Core Database Systems:
Transaction Management
• So far
– Transaction management
• Database systems
• Replicated databases
• Current work
– Speculative locking
Speculative Locking: Example
T1 releases
lock on X
T1 completes
work on X
T1:
r1[X] w1[X'] r1[Y] w1[Y']
e1
s1
T2:
c1
r2[X] w2[X'] r2[Z] w2[Z']
s2
time
(i) 2PL
T1:
r1[X] w1[X'] r1[Y] w1[Y']
e1
s1
T21
T2:
c2
e2
s2
T22
c1
r2[X] w2[X"] r2[Z] w2[Z']
r2[X'] w2[X"'] r2[Z]
w2[Z"]
e2
c2
time
(ii) SL
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.
Sample Photographs 2
Sample Photographs 3
Sample advices generated by Agricultural Externs
ICTs for Social Development
ICTs-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 Development
ICTs-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 Development
ICTs-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 multidimensional manner.
ICTs for Social Development
ICTs-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 Development
Build 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 Development
Improving 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).