Select your font size 
 
about us products & services consulting & support news & events contact us
Paul Meagher shows how to use a database query to calculate conditional probability.

Conditional Probability and SQL - Alaska

print this article 
 

P(A | B) can be mapped onto database-query operations. For example, the probability of cancer given a positive test result, P(+cancer | +test), can be obtained by issuing this SQL query then doing some tallies on the result set like this:

SELECT cancer_status FROM Data WHERE test_status='+test'

If I gather information about how several boolean-valued tests co-vary with a boolean-valued diagnosis (like that of cancer or not cancer), then I can perform slightly more complex queries to study how diagnostically useful other factors are in determining whether a patient has cancer, such as in the following:

SELECT cancer_status FROM Data WHERE genetic_status='+' AND age_status='+' AND biopsy_status='+'

In the case of detecting e-mail spam, I might be interested in computing P(+spam | title_word='viagra' AND title_word='free'), which could be viewed as a directive to issue the following SQL query:

SELECT spam_status FROM Emails WHERE email_title LIKE 'viagra' AND email_title LIKE 'free' 

After enumerating the number of e-mails that are spam and have "viagra" and "free" in the title (like so):

count_emails(spam_status='+spam' AND email_title LIKE 'viagra' AND email_title LIKE 'free')

and dividing by the overall number of e-mails with the words "viagra" and "free" in the title:

count_emails(email_title LIKE 'viagra' AND email_title LIKE 'free')

I might arrive at the conclusion that the appearence of these words in the title strongly and specifically co-varies with the message being spam (after all, 18/18 = 100 percent) and this rule might be used to automatically filter such messages.

In Bayes spam filtering, you need to initially train the software in which e-mails are spam and which are not. One can imagine storing spam_status information with each e-mail record (for example, email_id, spam_status, email_title, or email_message) and doing the previous queries and counts on this data to decide whether to forward a new e-mail into your inbox.



Page:   1  2  3  4  5  6  7  8  9  10  11 Next Page: Frequency versus probability format

The content shown in this page was first published by IBM developerWorks and is reprinted with permission from Paul Meagher (www.datavore.com)


Most Recent Website and Regional Updates

 Transparen Toronto Office Locations
Addresses of Transparen Corporation offices in Toronto, Ontario.

 
 High Scalability - Large Systems Optimization
Transparen Corporation lends its expertise to clients experiencing rapid and sudden growth in traffic or server utilization, bottlenecks, systems instability, downtime during peak traffic, or which would like to plan to avoid such issues.

 
 Throughput (or Bandwidth) vs. Latency
This document uses the example of Bill Gates purchasing Google to explain the difference between bandwidth (or throughput) and latency.

 
 Emergency Management Services
The prototypical emergency involves a shutdown of essential services for a finite period of time. What will your organization do when a world-wide financial crisis strikes?

 
 Fast RAID Server Data Recovery Service
Transparen's Vancouver International Response Team provides the option in Canada and USA to get a raid server back running in hours - eliminating costly waiting associated with typical RAID recoveries.

 
 Data Recovery Service
Have you deleted a mission critical file? Accidentally dropped a computer, or formatted a hard drive? No recent backup? Mistakes can happen, but the data might still be there.

 
 About Transparen
Transparen is committed to serving its clients.

 
 Short Term Forecast - Cape Fairweather to Cape Suckling Coastal Area (Alaska)
Short Term Forecast Issued At: 2009-01-07T14:45:00 Expired At: 2009-01-07T20:00:00 Issuing Weather Forecast Office Homepage: http://paya.arh.noaa.gov

 
 Special Weather Statement - Cape Fairweather to Cape Suckling Coastal Area (Alaska)
Special Weather Statement Issued At: 2009-01-07T00:29:00 Expired At: 2009-01-08T01:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Winter Weather Advisory - Taiya Inlet, Klondike Highway (Alaska)
URGENT - WINTER WEATHER MESSAGE Issued At: 2009-01-07T14:17:00 Expired At: 2009-01-08T15:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Special Weather Statement - Taiya Inlet, Klondike Highway (Alaska)
Special Weather Statement Issued At: 2009-01-07T00:29:00 Expired At: 2009-01-08T01:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Short Term Forecast - Taiya Inlet, Klondike Highway (Alaska)
Short Term Forecast Issued At: 2009-01-07T16:55:00 Expired At: 2009-01-07T22:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Winter Weather Advisory - Haines Borough, Lynn Canal (Alaska)
URGENT - WINTER WEATHER MESSAGE Issued At: 2009-01-07T14:17:00 Expired At: 2009-01-08T15:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Special Weather Statement - Haines Borough, Lynn Canal (Alaska)
Special Weather Statement Issued At: 2009-01-07T00:29:00 Expired At: 2009-01-08T01:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Winter Storm Watch - Haines Borough, Lynn Canal (Alaska)
URGENT - WINTER WEATHER MESSAGE Issued At: 2009-01-07T14:17:00 Expired At: 2009-01-10T03:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Short Term Forecast - Haines Borough, Lynn Canal (Alaska)
Short Term Forecast Issued At: 2009-01-07T16:55:00 Expired At: 2009-01-07T22:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Short Term Forecast - Glacier Bay (Alaska)
Short Term Forecast Issued At: 2009-01-07T16:55:00 Expired At: 2009-01-07T22:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Winter Storm Watch - Glacier Bay (Alaska)
URGENT - WINTER WEATHER MESSAGE Issued At: 2009-01-07T14:17:00 Expired At: 2009-01-10T03:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Special Weather Statement - Glacier Bay (Alaska)
Special Weather Statement Issued At: 2009-01-07T00:29:00 Expired At: 2009-01-08T01:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Wind Advisory - Glacier Bay (Alaska)
URGENT - WEATHER MESSAGE Issued At: 2009-01-07T16:05:00 Expired At: 2009-01-08T06:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Short Term Forecast - Eastern Chichagof Island (Alaska)
Short Term Forecast Issued At: 2009-01-07T16:55:00 Expired At: 2009-01-07T22:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Special Weather Statement - Eastern Chichagof Island (Alaska)
Special Weather Statement Issued At: 2009-01-07T00:29:00 Expired At: 2009-01-08T01:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Special Weather Statement - Salisbury Sound to Cape Fairweather Coastal Area (Alaska)
Special Weather Statement Issued At: 2009-01-07T00:29:00 Expired At: 2009-01-08T01:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Short Term Forecast - Salisbury Sound to Cape Fairweather Coastal Area (Alaska)
Short Term Forecast Issued At: 2009-01-07T16:55:00 Expired At: 2009-01-07T22:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Special Weather Statement - Cape Decision to Salisbury Sound Coastal Area (Alaska)
Special Weather Statement Issued At: 2009-01-07T00:29:00 Expired At: 2009-01-08T01:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Short Term Forecast - Cape Decision to Salisbury Sound Coastal Area (Alaska)
Short Term Forecast Issued At: 2009-01-07T16:55:00 Expired At: 2009-01-07T22:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Special Weather Statement - Eastern Baranof Island, Southern Admiralty Island (Alaska)
Special Weather Statement Issued At: 2009-01-07T00:29:00 Expired At: 2009-01-08T01:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Short Term Forecast - Eastern Baranof Island, Southern Admiralty Island (Alaska)
Short Term Forecast Issued At: 2009-01-07T16:55:00 Expired At: 2009-01-07T22:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Winter Storm Watch - Juneau Borough, Northern Admiralty Island (Alaska)
URGENT - WINTER WEATHER MESSAGE Issued At: 2009-01-07T14:17:00 Expired At: 2009-01-10T03:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Special Weather Statement - Juneau Borough, Northern Admiralty Island (Alaska)
Special Weather Statement Issued At: 2009-01-07T00:29:00 Expired At: 2009-01-08T01:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Wind Advisory - Juneau Borough, Northern Admiralty Island (Alaska)
URGENT - WEATHER MESSAGE Issued At: 2009-01-07T16:05:00 Expired At: 2009-01-08T06:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Short Term Forecast - Juneau Borough, Northern Admiralty Island (Alaska)
Short Term Forecast Issued At: 2009-01-07T16:55:00 Expired At: 2009-01-07T22:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Special Weather Statement - Inner Channels from Kupreanof Island to Etolin Island (Alaska)
Special Weather Statement Issued At: 2009-01-07T00:29:00 Expired At: 2009-01-08T01:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Short Term Forecast - Inner Channels from Kupreanof Island to Etolin Island (Alaska)
Short Term Forecast Issued At: 2009-01-07T16:55:00 Expired At: 2009-01-07T22:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Winter Storm Watch - Inner Channels from Kupreanof Island to Etolin Island (Alaska)
URGENT - WINTER WEATHER MESSAGE Issued At: 2009-01-07T14:17:00 Expired At: 2009-01-09T09:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Wind Advisory - Inner Channels from Kupreanof Island to Etolin Island (Alaska)
URGENT - WEATHER MESSAGE Issued At: 2009-01-07T16:05:00 Expired At: 2009-01-08T06:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Short Term Forecast - Dixon Entrance to Cape Decision Coastal Area (Alaska)
Short Term Forecast Issued At: 2009-01-07T18:15:00 Expired At: 2009-01-08T00:00:00 Issuing Weather Forecast Office Homepage: http://pant.arh.noaa.gov

 
 Winter Storm Watch - Dixon Entrance to Cape Decision Coastal Area (Alaska)
URGENT - WINTER WEATHER MESSAGE Issued At: 2009-01-07T14:17:00 Expired At: 2009-01-09T09:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Special Weather Statement - Dixon Entrance to Cape Decision Coastal Area (Alaska)
Special Weather Statement Issued At: 2009-01-07T00:29:00 Expired At: 2009-01-08T01:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Short Term Forecast - Southern Inner Channels (Alaska)
Short Term Forecast Issued At: 2009-01-07T18:15:00 Expired At: 2009-01-08T00:00:00 Issuing Weather Forecast Office Homepage: http://pant.arh.noaa.gov

 
 Winter Storm Watch - Southern Inner Channels (Alaska)
URGENT - WINTER WEATHER MESSAGE Issued At: 2009-01-07T14:17:00 Expired At: 2009-01-09T09:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Special Weather Statement - Southern Inner Channels (Alaska)
Special Weather Statement Issued At: 2009-01-07T00:29:00 Expired At: 2009-01-08T01:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Short Term Forecast - Misty Fjords (Alaska)
Short Term Forecast Issued At: 2009-01-07T18:15:00 Expired At: 2009-01-08T00:00:00 Issuing Weather Forecast Office Homepage: http://pant.arh.noaa.gov

 
 Winter Storm Watch - Misty Fjords (Alaska)
URGENT - WINTER WEATHER MESSAGE Issued At: 2009-01-07T14:17:00 Expired At: 2009-01-09T15:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Special Weather Statement - Misty Fjords (Alaska)
Special Weather Statement Issued At: 2009-01-07T00:29:00 Expired At: 2009-01-08T01:00:00 Issuing Weather Forecast Office Homepage: http://pajk.arh.noaa.gov

 
 Short Term Forecast - Northeast Prince William Sound (Alaska)
Short Term Forecast Issued At: 2009-01-07T13:45:00 Expired At: 2009-01-07T20:00:00 Issuing Weather Forecast Office Homepage: http://pavw.arh.noaa.gov

 
 Wind Chill Advisory - Northeast Prince William Sound (Alaska)
URGENT - WINTER WEATHER MESSAGE Issued At: 2009-01-07T13:29:00 Expired At: 2009-01-09T21:00:00 Issuing Weather Forecast Office Homepage: http://pafc.arh.noaa.gov

 
 Wind Chill Advisory - Copper River Basin (Alaska)
URGENT - WINTER WEATHER MESSAGE Issued At: 2009-01-07T13:29:00 Expired At: 2009-01-09T21:00:00 Issuing Weather Forecast Office Homepage: http://pafc.arh.noaa.gov

 
 Wind Chill Advisory - Susitna Valley (Alaska)
URGENT - WINTER WEATHER MESSAGE Issued At: 2009-01-07T13:29:00 Expired At: 2009-01-09T21:00:00 Issuing Weather Forecast Office Homepage: http://pafc.arh.noaa.gov

 
 Wind Chill Advisory - Kuskokwim Delta (Alaska)
URGENT - WINTER WEATHER MESSAGE Issued At: 2009-01-07T13:14:00 Expired At: 2009-01-08T02:00:00 Issuing Weather Forecast Office Homepage: http://pafc.arh.noaa.gov

 
 Short Term Forecast - Pribilof Islands (Alaska)
Short Term Forecast Issued At: 2009-01-07T15:17:00 Expired At: 2009-01-07T21:00:00 Issuing Weather Forecast Office Homepage: http://pasn.arh.noaa.gov

 
 Short Term Forecast - Northern Arctic Coast (Alaska)
Short Term Forecast Issued At: 2009-01-07T17:56:00 Expired At: 2009-01-07T23:00:00 Issuing Weather Forecast Office Homepage: http://pabr.arh.noaa.gov

 
 Wind Chill Advisory - Lower Yukon Valley (Alaska)
URGENT - WINTER WEATHER MESSAGE Issued At: 2009-01-07T13:11:00 Expired At: 2009-01-08T03:00:00 Issuing Weather Forecast Office Homepage: http://pafg.arh.noaa.gov

 
 Short Term Forecast - Middle Tanana Valley (Alaska)
Short Term Forecast Issued At: 2009-01-07T16:41:00 Expired At: 2009-01-07T21:00:00 Issuing Weather Forecast Office Homepage: http://pafg.arh.noaa.gov

 
 Dense Fog Advisory - Middle Tanana Valley (Alaska)
URGENT - WEATHER MESSAGE Issued At: 2009-01-07T12:01:00 Expired At: 2009-01-08T15:00:00 Issuing Weather Forecast Office Homepage: http://pafg.arh.noaa.gov

 

Google
 
Web transparen.com

Contact Information

Related Information

 
   
 
E C M | © 2003-2007 Transparen Corp.      

Standardized Services: Data Recovery Service / Creative Services / Premium Web Hosting Services / System Administration Tech Support Services
Recent Projects: Full-Service Mortgage and Financing Company / System to manage flights from Vancouver to Tofino / Photo exchange verification service
Our Vancouver BC Server Proudly Hosts: automated parking and revenue control systems, leafside lane at southlands, cost effective alternative power sources, Higher Grade Learning Centres, pacific forage bag supply, sunburst medical, neosonic design, roger mahler photography - passionate, intriguing, desirable, the connection between east and west, affordable flights to victoria and tofino, low interest mortgage brokers in vancouver, richmond, surrey, toronto, Toronto Calgary and Vancouver IT staffing and talent search
* Adak * Akhiok * Akiak * Akutan * Alakanuk * Aleknagik * Allakaket * Ambler * Anaktuvuk Pass * Anchorage (municipality) * Anderson * Angoon * Aniak * Anvik * Atka * Atqasuk * Barrow * Bettles * Bethel * Brevig Mission * Buckland * Chefornak * Chevak * Chignik * Chuathbaluk * Clark's Point * Coffman Cove * Cold Bay * Cordova * Craig * Deering * Delta Junction * Dillingham * Diomede * Eagle * Eek * Egegik * Ekwok * Elim * Emmonak * Fairbanks * False Pass * Fort Yukon * Galena * Gambell * Golovin * Goodnews Bay * Grayling * Gustavus * Haines * Holy Cross * Homer * Hoonah * Hooper Bay * Houston * Hughes * Huslia * Hydaburg * Juneau (City and Borough) * Kachemak * Kake * Kaktovik * Kaltag * Kasaan * Kenai * Ketchikan * Kiana * King Cove * Kivalina * Klawock * Kobuk * Kodiak * Kotlik * Kotzebue * Koyuk * Koyukuk * Kupreanof * Kwethluk * Larsen Bay * Lower Kalskag * Manokotak * Marshall * McGrath * Mekoryuk * Mountain Village * Napakiak * Napaskiak * Nenana * New Stuyahok * Newhalen * Nightmute * Nikolai * Nome * Nondalton * Noorvik * North Pole * Nuiqsut * Nulato * Nunam Iqua (formerly Sheldon Point) * Nunapitchuk * Old Harbor * Ouzinkie * Palmer * Pelican * Petersburg * Pilot Point * Pilot Station * Platinum * Point Hope * Port Alexander * Port Heiden * Port Lions * Quinhagak * Ruby * Russian Mission * St. George * St. Mary's * St. Michael * St. Paul * Sand Point * Savoonga * Saxman * Scammon Bay * Selawik * Seldovia * Seward * Shageluk * Shaktoolik * Shishmaref * Shungnak * Sitka (City and Borough) * Skagway * Soldotna * Stebbins * Tanana * Teller * Tenakee Springs * Thorne Bay * Togiak * Toksook Bay * Unalakleet * Unalaska * Upper Kalskag * Valdez * Wainwright * Wales * Wasilla * White Mountain * Whittier * Wrangell * Yakutat (City and Borough)