2,240 reputation
69
bio website systemajik.com
location Gatineau, Canada
age 58
visits member for 3 years, 2 months
seen 2 days ago
I have over 30 years experience in all phases of software development and delivery. I have administered a variety of midrange servers, and worked with systems from PCs to Mainframes.

Apr
16
answered Create one-to-many to two fields in different table
Apr
14
answered Table join inheritance
Apr
4
revised Database Normalization: A Case Of The NULLs
Clarify
Apr
3
answered Database Normalization: A Case Of The NULLs
Feb
14
awarded  Yearling
Feb
5
comment Is there a well-known name for this “poor man's ref. integrity” schema design pattern?
I don't see any referential integrity at all. This is an non-normalized column with no integrity.
Jan
30
answered Database is slow once in a while
Jan
28
comment Wrong index used in Postrgres
@StelianIancu The where clause is important here. It adds an implicit join on part of the ext_product_id column, and then adding the metadata. Index statistics may not be trusted, or may suggest a table scan is required. You may get better results by adding a function based index.
Jan
27
answered Wrong index used in Postrgres
Jan
23
awarded  Nice Answer
Jan
12
comment Is Oracle's dbms_utility.get_hash_value algorithm documented do reverse engineered anywhere?
Have you looked into ass-Through authentication?. Oracle would need to work as a sasl validator.
Jan
4
answered Simple yet multilingual flashcards - proper database design
Dec
19
comment Is a Junction Table the same as a Weak Entity?
@AirThomas I believe may not would imply likely is which I did not want to do. Similarly I would state A coin may be a quarter rather than A coin may not be a quarter.
Nov
28
answered To normalize or not to normalizde? (10 fields)
Nov
22
revised Low Cardinality of Index performing better than High Cardinality?
Add cardinality of range test.
Nov
21
answered Low Cardinality of Index performing better than High Cardinality?
Nov
11
answered Combine results from two queries?
Aug
4
revised What's better/faster? MySql or FileSystem?
added 9 characters in body
Jul
24
comment Relationship between professor and course
@JoeJeanJJ Yes, that would be a good starting point.
Jul
24
answered Relationship between professor and course