Transcript DBMS Lab Projects - Indian Institute of Technology Kharagpur

DBMS Lab Projects
Information System Design
Auction Portal
•
•
•
•
•
•
Items
Bidders
Bid
Managers
Lowest Bid
Incremental Bidding
Resume Posting Service
•
•
•
•
•
Resume
Posts
Employers
Managers
Matching
Tourism Information System
•
•
•
•
Data Integration
Location Aware Services
Map Based Interface
Travel Information
Web Based Dictionary
• Data Organization
• Graph Structure
Financial Portfolio Managers
• Users
• Projections
• Web based data access
Automatic Time Table and Course
Management System
•
•
•
•
Courses
Class rooms
Hard constraints
Soft Constraints
Social Network of IIT Alumni
•
•
•
•
Friends
Communities
Blogs
Events
Web 2.0
Mashup is a web application that combines
data from more than one source into a
single integrated tool via a local database;
an example is the use of cartographic data
from Google Maps to add location
information to real-estate data from
Craigslist, thereby creating a new and
distinct web service that was not originally
provided by either source.
Domain Specific Databases
Spatial Database
• GIS
• Spatio-temporal data
• Implement spatial queries and schemas
Multimedia Databases
• Content Based Retrieval
• Geometric Data Structures
• Music Databases
Streaming Data
• Network Monitoring
• Streaming Queries
XML Databases
• Query processor for restricted XQuery
• XML to RDBMS Converter
• XML database design
– Biological data
– Financial data
Sequence Databases
• Proteins, Gene sequences
• Motif, structure finding
• http://rdp.cme.msu.edu/
OODB
• Build a gaming framework using MyOODB
Fuzzy Databases
• FSQL
Text Databases
• Indexing – Zipfs law
• Search
Data warehousing
• Datacube materialization
• Warehouse design
• OLAP queries
Data Mining
• http://mill.ucsd.edu/
Database Security
• Checking a SQL query for SQL injection
vulnerability
•
statement := "SELECT * FROM users WHERE name = '" + userName + "';"
•
setting the "userName" variable as a' or 't'='t , renders
•
SELECT * FROM users WHERE name = 'a' OR 't'='t';
• If this code were to be used in an authentication
procedure then this example could be used to
force the selection of a valid username because
the evaluation of 't'='t' is always true.