Click here to Skip to main content
16,016,669 members
Home / Discussions / Database
   

Database

 
GeneralRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Nathan Minier12-Dec-17 7:10
professionalNathan Minier12-Dec-17 7:10 
GeneralRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Richard MacCutchan12-Dec-17 8:01
mveRichard MacCutchan12-Dec-17 8:01 
GeneralRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Schudi12-Dec-17 8:13
Schudi12-Dec-17 8:13 
QuestionCTE Sub-Sort Pin
Stan Lake11-Dec-17 11:52
professionalStan Lake11-Dec-17 11:52 
AnswerRe: CTE Sub-Sort Pin
Richard Deeming12-Dec-17 1:56
mveRichard Deeming12-Dec-17 1:56 
GeneralRe: CTE Sub-Sort Pin
Stan Lake12-Dec-17 2:35
professionalStan Lake12-Dec-17 2:35 
GeneralRe: CTE Sub-Sort Pin
Mycroft Holmes12-Dec-17 12:45
professionalMycroft Holmes12-Dec-17 12:45 
QuestionTable Design Suggestion Pin
Manish K. Agarwal7-Dec-17 19:42
Manish K. Agarwal7-Dec-17 19:42 
I have to maintain some metadata lists in DB, I have 2 options to design underlying simple table,
1st:

NAME   VALUE
-------------------
dept   HR
dept   fin
role   engineer
role   designer


UNIQUE CONSTRAINT (NAME, VALUE) and some other columns like auto generated ID, etc.

2nd:

NAME   VALUE_JSON_CLOB
-------------------
dept   {["HR", "fin"]}
role   {["engineer", "designer"}]


UNIQUE CONSTRAINT (NAME) and some other columns like auto generated ID, etc.

There is no DELETE operation, only SELECT and INSERT/UPDATE. In first advantage is only INSERT is required but SELECT (fetch all values for a given NAME) will be slow. In second SELECT will be fast but UPDATE will be slow. By considering there could be 1000s of such lists with 1000s for possible values in the system with frequent SELECTs and less INSERTs, which TABLE design will be good in terms of performance.

Thanks in advance.
AnswerRe: Table Design Suggestion Pin
Nathan Minier8-Dec-17 1:33
professionalNathan Minier8-Dec-17 1:33 
GeneralRe: Table Design Suggestion Pin
Manish K. Agarwal10-Dec-17 17:46
Manish K. Agarwal10-Dec-17 17:46 
GeneralRe: Table Design Suggestion Pin
Nathan Minier11-Dec-17 1:38
professionalNathan Minier11-Dec-17 1:38 
AnswerRe: Table Design Suggestion Pin
Richard Deeming8-Dec-17 1:35
mveRichard Deeming8-Dec-17 1:35 
GeneralRe: Table Design Suggestion Pin
Manish K. Agarwal10-Dec-17 17:53
Manish K. Agarwal10-Dec-17 17:53 
AnswerRe: Table Design Suggestion Pin
Mycroft Holmes9-Dec-17 0:00
professionalMycroft Holmes9-Dec-17 0:00 
QuestionCan the Pivot operator be used with text columns? Pin
Richard Andrew x646-Dec-17 4:14
professionalRichard Andrew x646-Dec-17 4:14 
AnswerRe: Can the Pivot operator be used with text columns? Pin
Richard Deeming6-Dec-17 9:51
mveRichard Deeming6-Dec-17 9:51 
GeneralRe: Can the Pivot operator be used with text columns? Pin
Richard Andrew x646-Dec-17 12:16
professionalRichard Andrew x646-Dec-17 12:16 
AnswerRe: Can the Pivot operator be used with text columns? Pin
Jörgen Andersson6-Dec-17 10:05
professionalJörgen Andersson6-Dec-17 10:05 
GeneralRe: Can the Pivot operator be used with text columns? Pin
Richard Andrew x646-Dec-17 12:17
professionalRichard Andrew x646-Dec-17 12:17 
QuestionSQL and database tutorials Pin
MikeTheFid4-Dec-17 11:52
MikeTheFid4-Dec-17 11:52 
AnswerRe: SQL and database tutorials Pin
Mycroft Holmes4-Dec-17 13:17
professionalMycroft Holmes4-Dec-17 13:17 
GeneralRe: SQL and database tutorials Pin
MikeTheFid5-Dec-17 0:33
MikeTheFid5-Dec-17 0:33 
QuestionSQL SERVER script Pin
Member 1355160430-Nov-17 23:08
Member 1355160430-Nov-17 23:08 
AnswerRe: SQL SERVER script Pin
Richard MacCutchan30-Nov-17 23:31
mveRichard MacCutchan30-Nov-17 23:31 
AnswerRe: SQL SERVER script Pin
Simon_Whale4-Dec-17 5:33
Simon_Whale4-Dec-17 5:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.