How well do you know your data?
Join Boston PHP and Chhean Saur for an exciting and riveting presentation on a big claim that you really don't need SQL anymore, and we will prove it...
SQL is defined as "Structured Query Language", but is your data really that well structured? For example, an address field doesn't always have a city and state. An international address can have province, town, or district as well. How should we store this in a database? (It seems inefficient to have a column just for province to be empty for all U.S. addresses).
Analytics and business intelligence are growing in importance to help make better decisions. How easy is it to do the following queries for your business:
A new feature has been added to product X. Find all customers that have NOT purchased product X within the last 6 months that have at least seen product X so we can notify them of a new feature. How many new customers bought the product as a result of the new feature?
- Real Estate:
Show me all emails and phone call logs that mention house X and the realtors that have shown the property within the last 3 months for every 10k in price change.
How many more students did better on the exam after restructuring the lesson within more/less content for each teacher?
There are other complex queries in Travel, Advertising, Marketing, Social Media, etc...
This presentation will talk about the NoSQL movement and how it helps to re-examine our data. We'll look at strengths and weaknesses of different databases like MySQL, MongoDB, Cassandra, Riak. We'll also talk about CAP theorem to help you make the best decision possible when selecting a database.
Spread the word
Our hashtag is #bostonphp.
6:00 - 7:00 : Doors open, Intro to FirePHP
7:00 - 8:45 : Main Presentation
8:45 - 9:00 : Questions
9:00 - ???? : Beers somewhere?