411 reputation
25
bio website porqueafoto.blogspot.com
location Sao Paulo, Brazil
age 42
visits member for 3 years, 5 months
seen Dec 9 at 21:20

Apr
23
awarded  Commentator
Apr
23
comment MySQL schema for recurring events - Query by specific date
Please, don't forget to share with us your 'slight modification'. Have a nice work.
Apr
22
awarded  Yearling
Apr
20
awarded  Yearling
Apr
20
answered Efficient way to write query for multiple table which depends on column value of a table in mysql?
Apr
20
comment How can one improve the performance of a query that selects on a low cardinality column in MySQL?
It does not make much sense defining an index to a VERY low cardinality column as in your example - just three possible values. Indexes serve to narrow queriable data. But, I bet your queries rely on other columns, don't they? Can you enrich your problem, with the actual schema and query samples?
Apr
20
answered MySQL schema for recurring events - Query by specific date
Oct
24
comment How to translate high level entity relationship into schema
Hm... my bad. Actually I'd better issue 'Authentication', not 'Authenticating'. Rounded rectangles here have no information value. They came rounded just because. I will review my post as soon as I get home.
Oct
4
comment Probable circular dependency, but query still runs
You're welcome. Accueil to the wonderful world of modeling and administering databases.
Oct
4
answered Foreign key with multiple references
Oct
4
answered How to design database for polymorphic relationships
Oct
4
answered E/R diagram for sports league database
Oct
4
revised How to translate high level entity relationship into schema
Some adjusts
Oct
4
answered How to translate high level entity relationship into schema
Oct
4
comment Probable circular dependency, but query still runs
One more thing. My models always consider end_date = 2100/jan/01 as from now on. This provide simpler, more straightforward, queries: ... WHERE TODAY BETWEEN start_date AND end_date. The natural way of setting end_date = NULL leads to ... WHERE start_date <= TODAY AND (end_date >= TODAY OR end_date IS NULL). Of course, for input controls at the user interfaces, the code has to interpret 2100/jan/01 as blank, and vice-versa.
Oct
4
answered Probable circular dependency, but query still runs
Oct
4
comment SQL Server Analysis Studio naive Bayes attribute has too many states
Could you provide us a snapshot displaying part of the model as shown at the SSAS' Naive Bayes viewer?
Sep
9
awarded  Revival
Jan
13
comment Design Pattern - One of Many Parent Tables
The DRI acronym got me. For you all, it stands for Declarative Referential Integrity, the technique behind referential data integrity which is commonly implemented as... (drum roll)... DDL FOREIGN KEY statements. More on en.wikipedia.org/wiki/Declarative_Referential_Integrity and msdn.microsoft.com/en-us/library/…
Jan
13
comment Design Pattern - One of Many Parent Tables
Reviewing this, I began to doubt the correctness of my solution... anyway, it's been voted up twice, which I thank. Although I believe my design is valid but not suitable for the problem given, as the 'n' unions/joins are not addressed...