959 reputation
412
bio website vancouverdata.blogspot.com
location Vancouver, Canada
age
visits member for 2 years, 3 months
seen 2 hours ago
stats profile views 65

MBA Finance
BA Econ
Data Mining
C#, Javascript, VB, SQL


Jun
11
comment How to create fault tolerant databases?
Netflix would disagree with you: thenextweb.com/insider/2013/03/03/…
Jun
11
comment This certain MySQL database organisation
use the Party Model with Table Inheritance. essentialstrategies.com/publications/modeling/advanceddm.htm
May
17
answered BI and Self Service Reporting Tools that Support Web (HTML) Interface?
May
10
comment How should I set up my social network database design?
Read up on Table Inheritance. You can likely group together very similar things into the same tables.
May
10
answered Table design when one data is dependant of another and the second one has repeated values
May
7
answered pros/cons of different ways to store whether a record is one of two options?
May
2
revised Database design - People and Organisations
added 318 characters in body
May
2
answered Database design - People and Organisations
May
2
awarded  Excavator
May
2
revised Possible to make MySQL use more than one core?
"then" to "than", added question mark. Pedantic Knight Rises.
May
2
suggested suggested edit on Possible to make MySQL use more than one core?
May
2
comment How to handle “many columns” in OLAP RDBMS
text mining app?
May
2
comment How to handle “many columns” in OLAP RDBMS
mind if we ask what you're storing?
May
2
answered Database Design Confusion
Apr
29
comment Table for optional parent/child relationship
can you describe what you are actually going to store in the database? it may help
Apr
28
comment Proper Use of Lookup Tables
+1 for ISO standard
Apr
28
comment Is Oracle not suited as the database behind websites like Stackoverflow?
The co-founders of Stackoverflow are Joel Spolsky, who worked for Microsoft (and wrote VBA for Excel), and Jeff Atwood, who started as a hacker using MS Basic.
Apr
28
revised How to sync a database with an external full text engine?
deleted 37 characters in body
Apr
17
comment mySQL- large database
you could consider Solr, which is useful for storing and searching text documents. can be clustered among multiple machines.
Apr
10
comment Trying to create a Data Model
Yup, I know what you mean. There are three kinds of inventory though. Those without serial numbers that are tracked only by quantity, those without serial numbers that are tracked by weight or volume, and those with serial numbers whose quantity is always 1.