DBMS Lab Projects Information System Design Auction Portal
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 My. OODB
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 = '" + user. Name + "'; " • setting the "user. Name" 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.
- Slides: 23