Click here to Skip to main content
14,493,689 members
   

Database

 
AnswerRe: Error in Restoring SQL Server Backup of v 2012 to v 2008 Pin
Victor Nijegorodov1-Jun-18 20:46
MemberVictor Nijegorodov1-Jun-18 20:46 
AnswerRe: Error in Restoring SQL Server Backup of v 2012 to v 2008 Pin
Eddy Vluggen2-Jun-18 0:21
professionalEddy Vluggen2-Jun-18 0:21 
GeneralRe: Error in Restoring SQL Server Backup of v 2012 to v 2008 Pin
indian1434-Jun-18 6:10
Memberindian1434-Jun-18 6:10 
GeneralRe: Error in Restoring SQL Server Backup of v 2012 to v 2008 Pin
Eddy Vluggen4-Jun-18 7:08
professionalEddy Vluggen4-Jun-18 7:08 
QuestionA Control flow Task is appearing in the SSIS Packages xml even after disabling and the deleting it. Pin
indian14331-May-18 13:34
Memberindian14331-May-18 13:34 
QuestionThe following Query is taking too long to execute Pin
indian14330-May-18 13:33
Memberindian14330-May-18 13:33 
SuggestionRe: The following Query is taking too long to execute Pin
CHill6031-May-18 2:53
mveCHill6031-May-18 2:53 
GeneralRe: The following Query is taking too long to execute Pin
indian14331-May-18 13:26
Memberindian14331-May-18 13:26 
GeneralRe: The following Query is taking too long to execute Pin
Eddy Vluggen1-Jun-18 0:10
professionalEddy Vluggen1-Jun-18 0:10 
QuestionGraph Database vs Dimensional Pin
DADom24-May-18 21:32
MemberDADom24-May-18 21:32 
AnswerRe: Graph Database vs Dimensional Pin
Eddy Vluggen26-May-18 2:45
professionalEddy Vluggen26-May-18 2:45 
DADom wrote:
So much so that he asserted, if they’d been invented, Ralph Kimball would never have become involved with dimensional modelling and would have used graph databases instead.
Keep any evangelists away from these discussions. You don't need a salesman on your team.

DADom wrote:
Would be interested in you views.
My strength is identifying relationships too, so I prefer to store relational data in a RDBMS in a structure that is at least in BCNF. It is a proven way which guarantees consistency and correctness.

According to the wiki, a graph db excells where data is "difficult to model" (and I agree with the comment "according to whom"). So, to evaluate it, you come looking for anecdotes.

I suggest you make a list (and check it twice) with advantages and disadvantages of both, and decide which are more important to you. THAT is the correct way out of these discussions - you will need to justify your choice, which is not done by pointing to an anecdote on codeproject, but by showing which of the two choices is the better fit in your specific case.

Personally, I'd say that the choice is obvious; Most RDBMSs are stable and well-optimized for data storage and retrieval, and there are a lot of resources on SQL92 (talk about backward compatibility eh?) Graph-databases would require something else than SQL probably, adding to the costs (and riscs).
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

GeneralRe: Graph Database vs Dimensional Pin
John 1356415428-Jun-18 9:07
MemberJohn 1356415428-Jun-18 9:07 
GeneralRe: Graph Database vs Dimensional Pin
Eddy Vluggen28-Jun-18 9:19
professionalEddy Vluggen28-Jun-18 9:19 
QuestionHow to create a insert trigger on just one table? Pin
Member23621-May-18 23:02
MemberMember23621-May-18 23:02 
QuestionRe: How to create a insert trigger on just one table? Pin
CHill6022-May-18 1:34
mveCHill6022-May-18 1:34 
AnswerRe: How to create a insert trigger on just one table? Pin
Richard Deeming22-May-18 2:30
mveRichard Deeming22-May-18 2:30 
AnswerRe: How to create a insert trigger on just one table? Pin
Mycroft Holmes22-May-18 14:09
professionalMycroft Holmes22-May-18 14:09 
GeneralRe: How to create a insert trigger on just one table? Pin
CHill6022-May-18 22:56
mveCHill6022-May-18 22:56 
GeneralRe: How to create a insert trigger on just one table? Pin
Mycroft Holmes23-May-18 13:20
professionalMycroft Holmes23-May-18 13:20 
GeneralRe: How to create a insert trigger on just one table? Pin
Member23622-May-18 23:04
MemberMember23622-May-18 23:04 
GeneralRe: How to create a insert trigger on just one table? Pin
Mycroft Holmes23-May-18 13:23
professionalMycroft Holmes23-May-18 13:23 
QuestionFOR XML PATH is not creating Child elements if they are coming with null values Pin
indian14316-May-18 12:39
Memberindian14316-May-18 12:39 
AnswerRe: FOR XML PATH is not creating Child elements if they are coming with null values Pin
CHill6022-May-18 1:32
mveCHill6022-May-18 1:32 
QuestionEquivalent of the following query without FOR XML PATH Pin
indian14314-May-18 12:03
Memberindian14314-May-18 12:03 
SuggestionRe: Equivalent of the following query without FOR XML PATH Pin
CHill6015-May-18 0:11
mveCHill6015-May-18 0:11 

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.