Author Topic: Database Ideas  (Read 3265 times)

0 Members and 1 Guest are viewing this topic.

Offline abdulmuhsee

  • Thread Starter
  • Posts: 196
Database Ideas
« on: Mon, 01 December 2014, 18:12:45 »
So I'm taking this database class that requires me to make a database with SQL Server.  Problem is, I have no idea what to make the database on.  There are no restrictions, but I can't think of anything remotely interesting that has any reason for having a database. 

The idea of a fictional business with CUSTOMER and ORDER_NUM tables and all that jazz seems pretty lame when my options are limitless.

Offline belac

  • Posts: 62
Re: Database Ideas
« Reply #1 on: Mon, 01 December 2014, 19:52:35 »
i assume you're interested in keyboards since you're on this forum. you have a pretty good source of interesting data here. start with a simple design to catalog boards, switches, keycaps, etc. then you could expand it to include data from posts on here. then you can run business intelligence algorithms over your compiled data to find out what the most talked about items are, which board topics cause the most conversation, who derails a thread the quickest, etc. data is always interesting if you take the time to study and manipulate it. and the first step is always collecting and storing it in an intelligent way... such as a database.

Offline tp4tissue

  • * Destiny Supporter
  • Posts: 12855
  • Location: Official Geekhack Public Defender..
  • OmniExpert of: Rice, Top-Ramen, Ergodox, n Females
Re: Database Ideas
« Reply #2 on: Mon, 01 December 2014, 20:42:26 »
Dude...  pr0n star popularity database..   try and beat freeones..

Offline rowdy

  • HHKB Hapster
  • * Erudite Elder
  • Posts: 21063
  • Location: melbourne.vic.au
  • Missed another sale.
Re: Database Ideas
« Reply #3 on: Mon, 01 December 2014, 20:45:05 »
Word frequencies.  Scrape web pages or Twitter or something and store the results in the database.

Music collection - artists, albums, songs, lyrics.

Weather - gather weather stats hourly or daily and store them in a database.
"Because keyboards are accessories to PC makers, they focus on minimizing the manufacturing costs. But thatís incorrect. Itís in HHKBís slogan, but when Americaís cowboys were in the middle of a trip and their horse died, they would leave the horse there. But even if they were in the middle of a desert, they would take their saddle with them. The horse was a consumable good, but the saddle was an interface that their bodies had gotten used to. In the same vein, PCs are consumable goods, while keyboards are important interfaces." - Eiiti Wada

NEC APC-H4100E | Ducky DK9008 Shine MX blue LED red | Ducky DK9008 Shine MX blue LED green | Link 900243-08 | CM QFR MX black | KeyCool 87 white MX reds | HHKB 2 Pro | Model M 02-Mar-1993 | Model M 29-Nov-1995 | CM Trigger (broken) | CM QFS MX green | Ducky DK9087 Shine 3 TKL Yellow Edition MX black | Lexmark SSK 21-Apr-1994 | IBM SSK 13-Oct-1987 | CODE TKL MX clear | Model M 122 01-Jun-1988

Ị̸͚̯̲́ͤ̃͑̇̑ͯ̊̂͟ͅs̞͚̩͉̝̪̲͗͊ͪ̽̚̚ ̭̦͖͕̑́͌ͬͩ͟t̷̻͔̙̑͟h̹̠̼͋ͤ͋i̤̜̣̦̱̫͈͔̞ͭ͑ͥ̌̔s̬͔͎̍̈ͥͫ̐̾ͣ̔̇͘ͅ ̩̘̼͆̐̕e̞̰͓̲̺̎͐̏ͬ̓̅̾͠͝ͅv̶̰͕̱̞̥̍ͣ̄̕e͕͙͖̬̜͓͎̤̊ͭ͐͝ṇ̰͎̱̤̟̭ͫ͌̌͢͠ͅ ̳̥̦ͮ̐ͤ̎̊ͣ͡͡n̤̜̙̺̪̒͜e̶̻̦̿ͮ̂̀c̝̘̝͖̠̖͐ͨͪ̈̐͌ͩ̀e̷̥͇̋ͦs̢̡̤ͤͤͯ͜s͈̠̉̑͘a̱͕̗͖̳̥̺ͬͦͧ͆̌̑͡r̶̟̖̈͘ỷ̮̦̩͙͔ͫ̾ͬ̔ͬͮ̌?̵̘͇͔͙ͥͪ͞ͅ

Offline swill

  • * Elevated Elder
  • Posts: 3365
  • Location: Canada eh
  • builder & enabler
    • swillkb.com
Re: Database Ideas
« Reply #4 on: Mon, 01 December 2014, 20:48:13 »
Ya lots of interesting things you could do with keyboards.

You could have a keyboards table with different tables for switch types, layouts, etc that are FK key mapped to other tables.

Do you just have to design and populate the databases, or do you have to do interesting things with them as well?

Offline Wildcard

  • * Esteemed Elder
  • Posts: 1046
  • Location: Fields of Columbia
  • When caffeine isn't enough
Re: Database Ideas
« Reply #5 on: Mon, 01 December 2014, 20:48:45 »
Pull metadata out of your photos, store the GPS locations, interface with google maps API, and stock yourself!

Offline swill

  • * Elevated Elder
  • Posts: 3365
  • Location: Canada eh
  • builder & enabler
    • swillkb.com
Re: Database Ideas
« Reply #6 on: Mon, 01 December 2014, 20:51:39 »
Word frequencies.  Scrape web pages or Twitter or something and store the results in the database.

Music collection - artists, albums, songs, lyrics.

Weather - gather weather stats hourly or daily and store them in a database.
Ya. That's a cool idea. If you go this route and you need a hand with building a crawler/scraper/spider, just pm me. I have some really easy tricks for writing full blown scrapers in like 20-40 lines of code.

Offline rowdy

  • HHKB Hapster
  • * Erudite Elder
  • Posts: 21063
  • Location: melbourne.vic.au
  • Missed another sale.
Re: Database Ideas
« Reply #7 on: Mon, 01 December 2014, 20:52:36 »
Got a bar code scanner?  Scan products you buy and record prices against stores.  Write a report to select the minimum price for each item.
"Because keyboards are accessories to PC makers, they focus on minimizing the manufacturing costs. But thatís incorrect. Itís in HHKBís slogan, but when Americaís cowboys were in the middle of a trip and their horse died, they would leave the horse there. But even if they were in the middle of a desert, they would take their saddle with them. The horse was a consumable good, but the saddle was an interface that their bodies had gotten used to. In the same vein, PCs are consumable goods, while keyboards are important interfaces." - Eiiti Wada

NEC APC-H4100E | Ducky DK9008 Shine MX blue LED red | Ducky DK9008 Shine MX blue LED green | Link 900243-08 | CM QFR MX black | KeyCool 87 white MX reds | HHKB 2 Pro | Model M 02-Mar-1993 | Model M 29-Nov-1995 | CM Trigger (broken) | CM QFS MX green | Ducky DK9087 Shine 3 TKL Yellow Edition MX black | Lexmark SSK 21-Apr-1994 | IBM SSK 13-Oct-1987 | CODE TKL MX clear | Model M 122 01-Jun-1988

Ị̸͚̯̲́ͤ̃͑̇̑ͯ̊̂͟ͅs̞͚̩͉̝̪̲͗͊ͪ̽̚̚ ̭̦͖͕̑́͌ͬͩ͟t̷̻͔̙̑͟h̹̠̼͋ͤ͋i̤̜̣̦̱̫͈͔̞ͭ͑ͥ̌̔s̬͔͎̍̈ͥͫ̐̾ͣ̔̇͘ͅ ̩̘̼͆̐̕e̞̰͓̲̺̎͐̏ͬ̓̅̾͠͝ͅv̶̰͕̱̞̥̍ͣ̄̕e͕͙͖̬̜͓͎̤̊ͭ͐͝ṇ̰͎̱̤̟̭ͫ͌̌͢͠ͅ ̳̥̦ͮ̐ͤ̎̊ͣ͡͡n̤̜̙̺̪̒͜e̶̻̦̿ͮ̂̀c̝̘̝͖̠̖͐ͨͪ̈̐͌ͩ̀e̷̥͇̋ͦs̢̡̤ͤͤͯ͜s͈̠̉̑͘a̱͕̗͖̳̥̺ͬͦͧ͆̌̑͡r̶̟̖̈͘ỷ̮̦̩͙͔ͫ̾ͬ̔ͬͮ̌?̵̘͇͔͙ͥͪ͞ͅ

Offline tp4tissue

  • * Destiny Supporter
  • Posts: 12855
  • Location: Official Geekhack Public Defender..
  • OmniExpert of: Rice, Top-Ramen, Ergodox, n Females
Re: Database Ideas
« Reply #8 on: Mon, 01 December 2014, 20:55:34 »
Word frequencies.  Scrape web pages or Twitter or something and store the results in the database.

Music collection - artists, albums, songs, lyrics.

Weather - gather weather stats hourly or daily and store them in a database.
Ya. That's a cool idea. If you go this route and you need a hand with building a crawler/scraper/spider, just pm me. I have some really easy tricks for writing full blown scrapers in like 20-40 lines of code.

well that's exactly like a pr0nstar database   except the words are names... of... pr0nstars

Offline Wildcard

  • * Esteemed Elder
  • Posts: 1046
  • Location: Fields of Columbia
  • When caffeine isn't enough
Re: Database Ideas
« Reply #9 on: Mon, 01 December 2014, 21:01:32 »
Got a bar code scanner?  Scan products you buy and record prices against stores.  Write a report to select the minimum price for each item.

This I like

Offline rowdy

  • HHKB Hapster
  • * Erudite Elder
  • Posts: 21063
  • Location: melbourne.vic.au
  • Missed another sale.
Re: Database Ideas
« Reply #10 on: Mon, 01 December 2014, 21:36:06 »
Got a bar code scanner?  Scan products you buy and record prices against stores.  Write a report to select the minimum price for each item.

This I like

:)

For bonus marks, find a graphing library and graph the price of selected items over time.

If items are grouped by shopping trip, graph your weekly total grocery bill over time.
"Because keyboards are accessories to PC makers, they focus on minimizing the manufacturing costs. But thatís incorrect. Itís in HHKBís slogan, but when Americaís cowboys were in the middle of a trip and their horse died, they would leave the horse there. But even if they were in the middle of a desert, they would take their saddle with them. The horse was a consumable good, but the saddle was an interface that their bodies had gotten used to. In the same vein, PCs are consumable goods, while keyboards are important interfaces." - Eiiti Wada

NEC APC-H4100E | Ducky DK9008 Shine MX blue LED red | Ducky DK9008 Shine MX blue LED green | Link 900243-08 | CM QFR MX black | KeyCool 87 white MX reds | HHKB 2 Pro | Model M 02-Mar-1993 | Model M 29-Nov-1995 | CM Trigger (broken) | CM QFS MX green | Ducky DK9087 Shine 3 TKL Yellow Edition MX black | Lexmark SSK 21-Apr-1994 | IBM SSK 13-Oct-1987 | CODE TKL MX clear | Model M 122 01-Jun-1988

Ị̸͚̯̲́ͤ̃͑̇̑ͯ̊̂͟ͅs̞͚̩͉̝̪̲͗͊ͪ̽̚̚ ̭̦͖͕̑́͌ͬͩ͟t̷̻͔̙̑͟h̹̠̼͋ͤ͋i̤̜̣̦̱̫͈͔̞ͭ͑ͥ̌̔s̬͔͎̍̈ͥͫ̐̾ͣ̔̇͘ͅ ̩̘̼͆̐̕e̞̰͓̲̺̎͐̏ͬ̓̅̾͠͝ͅv̶̰͕̱̞̥̍ͣ̄̕e͕͙͖̬̜͓͎̤̊ͭ͐͝ṇ̰͎̱̤̟̭ͫ͌̌͢͠ͅ ̳̥̦ͮ̐ͤ̎̊ͣ͡͡n̤̜̙̺̪̒͜e̶̻̦̿ͮ̂̀c̝̘̝͖̠̖͐ͨͪ̈̐͌ͩ̀e̷̥͇̋ͦs̢̡̤ͤͤͯ͜s͈̠̉̑͘a̱͕̗͖̳̥̺ͬͦͧ͆̌̑͡r̶̟̖̈͘ỷ̮̦̩͙͔ͫ̾ͬ̔ͬͮ̌?̵̘͇͔͙ͥͪ͞ͅ

Offline dorkvader

  • Posts: 6282
  • Location: Boston area
  • all about the "hack" in "geekhack"
Re: Database Ideas
« Reply #11 on: Mon, 01 December 2014, 23:26:47 »
Got a bar code scanner?  Scan products you buy and record prices against stores.  Write a report to select the minimum price for each item.

This I like

you can use your phone as a barcode scanner so you don't have to buy one.

Some users keep databases of their keyborad purchases, usually using google docs or microsoft excel. I need to update my database now.

I keep info on company, model, model number, serial number, date of manufacture, date of acquisition, acquisition price, acquisition shipping, date sold , sold price, sold shipping, and notes.

Offline korrelate

  • Posts: 405
  • Location: Virginia
  • iubeo stultum esse libenter
Re: Database Ideas
« Reply #12 on: Mon, 01 December 2014, 23:41:47 »
Just a couple of thoughts:

1. If you really want to study SQL you're going to want to focus on the syntax and try to understand why SQL and "database" programming is so different than most other programming languages. This will take a fair amount of time. That "boring" order number idea has its merits;

a. if you don't have to worry about the data that's filling your tables you can focus on understanding the syntax.
b. sample databases (like Oracle's "scott/tiger" account) demonstrate relationships that you may not understand at the beginning of the course. And if you don't understand them you probably won't bake those relationships into your tables.

2. You really don't need (or even want) a huge database to study SQL. In fact, I'd suggest small tables: when you practice your queries you can identify, by inspection, the rows that satisfy the logic of your query IF your tables are small. If your tables are too large to inspect manually you're almost wasting your time in an intro course.

Don't get me wrong, though: I almost jumped at the p0rnstar DB.


TLDR: If you want to focus on learning SQL just use the data for one of the many sample databases you can find on the web. Make sure it's small.



HTH,

K
« Last Edit: Mon, 01 December 2014, 23:43:19 by korrelate »
All keysets ought to have blank "Windows" and "Menu" keys.



Custom Filco MJ2: Krytox-ed Switches + "Green" LEDs
RIP Leopold: You served me well.

Offline Oobly

  • * Esteemed Elder
  • Posts: 3929
  • Location: Finland
Re: Database Ideas
« Reply #13 on: Tue, 02 December 2014, 06:05:32 »
Character frequencies in different languages. :D

Nope, actually I agree with korrelate, use a small data set so you can see what the queries actually do. Perhaps a database of keyboards you like, with supporting tables of keyswitch type (one to many) and keyboard part colours (many to many). Could even take it further to include spring types, keycap profile, removable cable or not, etc.
Buying more keycaps,
it really hacks my wallet,
but I must have them.

Offline Wildcard

  • * Esteemed Elder
  • Posts: 1046
  • Location: Fields of Columbia
  • When caffeine isn't enough
Re: Database Ideas
« Reply #14 on: Tue, 02 December 2014, 16:22:18 »
I should have mentioned that if anyone is using SQL Server there are already good sample databases that have been created for you to use. Granted, not really related to abdulmuhsee's use case.

AdventureWorks --> http://msftdbprodsamples.codeplex.com/

Offline abdulmuhsee

  • Thread Starter
  • Posts: 196
Re: Database Ideas
« Reply #15 on: Tue, 02 December 2014, 21:36:58 »
Most of the other people in the class have accepted their fate and gone with fictional businesses, i.e. - mechanic shop, snow plow business, car wash, blah blah.  Essentially, their databases will end up as virtual clones of the sample databases we used in the first class.  I'm just trying to do something with a more unique structure/subject that hasn't been done a million times and isn't just available on the internet.  I'm not actually interested in becoming a database admin (barring something amazing happens during this class that changes my mind); it's just one of the class sets I have to take along the way.

The bar code thing sounds like it could actually have a useful reason for having a database if it becomes large enough to really warrant it, and heck, I would envision that research for the XXX database would at least be enjoyable.

Offline tchevass

  • Posts: 333
  • Location: Montreal/Canada
  • open wide
Re: Database Ideas
« Reply #16 on: Sun, 11 January 2015, 07:31:03 »
Most of the other people in the class have accepted their fate and gone with fictional businesses, i.e. - mechanic shop, snow plow business, car wash, blah blah.  Essentially, their databases will end up as virtual clones of the sample databases we used in the first class.  I'm just trying to do something with a more unique structure/subject that hasn't been done a million times and isn't just available on the internet.  I'm not actually interested in becoming a database admin (barring something amazing happens during this class that changes my mind); it's just one of the class sets I have to take along the way.

The bar code thing sounds like it could actually have a useful reason for having a database if it becomes large enough to really warrant it, and heck, I would envision that research for the XXX database would at least be enjoyable.
You could always do a database about users and their keyboards, you could do a pool on this forum and ask people some information like their keyboard, keycaps, switch type etc..
I want clacks