1 / 0

CS 440 Database Management Systems

CS 440 Database Management Systems. Project Definitions. “Avatar” DB. Brian Holmes 1/21/2014. The Team. Me! For proprietary reasons , I will be working alone on this project. Presentations in this will class contain abstract information in order to protect IP. Data Set.

kairos
Download Presentation

CS 440 Database Management Systems

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CS 440 Database Management Systems

    Project Definitions
  2. “Avatar” DB Brian Holmes 1/21/2014
  3. The Team Me! For proprietary reasons, I will be working alone on this project. Presentations in this will class contain abstract information in order to protect IP.
  4. Data Set Based on start-up company at Oregon State Data set is customer, supplier, & developer provided Customer: user account information Supplier: product and service assets Developer: statistics, metrics, optimization
  5. DB Operations Customers will be querying for concatenated results of their account and supplier products Suppliers will be querying for metrics about the customers
  6. Advanced Integration with 3D applications / 3D web environments Storage and retrieval of images Plan to migrate the project to Amazon S3

  7. NOAA Weather Data

    Taylor Friesen, Keenon Ono
  8. Project Description We will be creating a database to hold information about Oregon’s weather data This will function as an almanac that users can search using general queries We will import weather data to our database then create a frontend to allow interaction
  9. Special Feature Advanced Weather Search Search by keyword Search by string of text Example: “High temperatures in Corvallis for the last year”
  10. Group Member(s): Just Erich Merrill Offline Riot API Explorer
  11. Riot Games recently opened up their JSON web API to the public The API reveals information and details about games played and the players participating This data could (and is!) being used to let the players examine trends or interesting results from analysis of the data. ...
  12. Long-running Backend Web Application / Frontend Adjustable List of Users of Interest More Usable Processed Databases? Rate-limited Web API API Responses Interesting Queries! Local 'Clone' Databases
  13. Sample queries: What characters is a certain player most/least effective with? What teammates is a certain player most/least effective playing with or against? How do in-game item choices correlate with the games' results, the player's character, the opponents' character, etc?
  14. Advanced features/queries? ML to imply the role of a character in a game based on that character's teammates or opponents (or any other non-obvious relationship)? Combine/process results from 'clone' database into a more usable, easy-to-query format for the frontend?

  15. Online Shopping Website

    Conway Tang
  16. The Idea Users will upload information on an item they would like to sell Name of the item Description Category of item Price Photos Etc. Users would be able to browse or search through these items and purchase them Buyers could leave feedback for items Like a mix between eBay and Craigslist without the auctions or dealing with the seller in person
  17. User Queries Add an item for sale Edit item information Remove an item for sale Purchase an item Cancel a purchase Add feedback for an item
  18. Advanced Feature Keyword Search Item name Item category User Description Price Range

  19. Ingress Agent Roster

    Landon Abney, Brent Evans, Robert Partch
  20. What it’s all about Ingress is an ARG created by Google. The game has statistics that are tracked and displayed to the “Agents” playing it. Players will be entering in their own statistics to see how they compare to others in their area.
  21. Database Interactions Updates: Users will be inserting/updating records holding information on their in game stats.
  22. Database Interactions Queries: The main usage for this data Finding out other agent’s stats Seeing how their own stats change over time
  23. Advanced Features Pulling data for use in graphs Advanced searching/sorting to explore the data Calculated statistics

  24. Movie Ranking Database

    CS 440 1/21/2014
  25. Team X Jaerod Case Kellie Suehisa Hussain Alabudeeb Ryan Susnjara
  26. Concept Overview Movie meta-data is easily accessible but can be difficult to thoroughly search. Our project will take titles, actors, genres, and ratings and make this information easy to explore.
  27. Basic Features Search by: Year Actor/Director Awards Genre Also users may enter their own rating data
  28. Advanced Search Methods Possible features include: Best movies by year Movies by actor preference Actor’s best movies Any ideas?

  29. BUSQUEST

    A database of busses. Great!
  30. Group members Adam Gigstad David Keith Brian Ringeisen
  31. Description Database of estimated times Not a “tracking” database Expandable beyond Corvallis
  32. Data Bus Schedule information is publicly available.
  33. Queries/user interaction Bus stop list Time estimates Trip instructions
  34. Advanced features Full routing Delay reporting/dynamic estimates
More Related