Click here to Skip to main content
14,123,558 members
   

Database

 
QuestionHow do I remove the error message when I add file attachments database ? Pin
Member 245846729-Nov-18 21:17
memberMember 245846729-Nov-18 21:17 
AnswerRe: How do I remove the error message when I add file attachments database ? Pin
Richard MacCutchan29-Nov-18 22:56
protectorRichard MacCutchan29-Nov-18 22:56 
AnswerRe: How do I remove the error message when I add file attachments database ? Pin
ZurdoDev4-Dec-18 2:25
professionalZurdoDev4-Dec-18 2:25 
QuestionERD Help Pin
Prytol29-Nov-18 4:28
memberPrytol29-Nov-18 4:28 
SuggestionRe: ERD Help Pin
CHill6029-Nov-18 6:10
protectorCHill6029-Nov-18 6:10 
GeneralRe: ERD Help Pin
Prytol29-Nov-18 9:10
memberPrytol29-Nov-18 9:10 
AnswerRe: ERD Help Pin
Eddy Vluggen29-Nov-18 9:03
mveEddy Vluggen29-Nov-18 9:03 
QuestionWhat is the right database technology for this simple outlined BI tool use case? Pin
Member 1407009628-Nov-18 1:55
memberMember 1407009628-Nov-18 1:55 
Reaching out to the community to pressure test our internal thinking.

We are building a simplified business intelligence platform that will aggregate metrics (i.e. traffic, backlinks) and text list (i.e search keywords, used technologies) from several data providers.

The data will be somewhat loosely structured and may change over time with vendors potentially changing their response formats.

Data volume may be long term 100,000 rows x 25 input vectors.

Data would be updated and read continuously but not at massive concurrent volume.

We'd expect to need to do some ETL transformations on the gathered data from partners along the way to the UI (e.g show trending information over the past five captured data points).

We'd want to archive every single data snapshot (i.e. version it) vs just storing the most current data point.

The persistence technology should be readily available through AWS.

Our assumption is our requirements lend themselves best towards DynamoDB (vs Amazon Neptune or Redshift or Aurora).

Is that fair to assume? Are there any other questions / information I can provide to elicit input from this community?

AnswerRe: What is the right database technology for this simple outlined BI tool use case? Pin
Eddy Vluggen28-Nov-18 2:22
mveEddy Vluggen28-Nov-18 2:22 
GeneralRe: What is the right database technology for this simple outlined BI tool use case? Pin
Mycroft Holmes28-Nov-18 13:11
memberMycroft Holmes28-Nov-18 13:11 
GeneralRe: What is the right database technology for this simple outlined BI tool use case? Pin
Eddy Vluggen28-Nov-18 23:30
mveEddy Vluggen28-Nov-18 23:30 
AnswerRe: What is the right database technology for this simple outlined BI tool use case? Pin
Mycroft Holmes28-Nov-18 13:13
memberMycroft Holmes28-Nov-18 13:13 
QuestionSQL SERVER 2012 - pull data from only, if value date is available Pin
joflo26-Nov-18 23:30
memberjoflo26-Nov-18 23:30 
AnswerRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
Richard MacCutchan27-Nov-18 0:31
protectorRichard MacCutchan27-Nov-18 0:31 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
joflo27-Nov-18 0:48
memberjoflo27-Nov-18 0:48 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
Richard MacCutchan27-Nov-18 1:07
protectorRichard MacCutchan27-Nov-18 1:07 
AnswerRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
Richard Deeming27-Nov-18 1:21
mveRichard Deeming27-Nov-18 1:21 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
joflo27-Nov-18 1:48
memberjoflo27-Nov-18 1:48 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
Richard Deeming27-Nov-18 2:12
mveRichard Deeming27-Nov-18 2:12 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
joflo27-Nov-18 2:18
memberjoflo27-Nov-18 2:18 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
James Walsh Jr1-Jan-19 9:09
professionalJames Walsh Jr1-Jan-19 9:09 
QuestionOnly begin select if value is found in dataset sql Pin
Joanna Webster16-Nov-18 4:31
memberJoanna Webster16-Nov-18 4:31 
AnswerRe: Only begin select if value is found in dataset sql Pin
Richard MacCutchan16-Nov-18 22:10
protectorRichard MacCutchan16-Nov-18 22:10 
AnswerRe: Only begin select if value is found in dataset sql Pin
jschell21-Nov-18 7:43
memberjschell21-Nov-18 7:43 
QuestionCollecting data to make a excel graph Pin
Michael Clinton12-Nov-18 10:42
memberMichael Clinton12-Nov-18 10:42 

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.


Advertise | Privacy | Cookies | Terms of Service
Web02 | 2.8.190518.1 | Last Updated 20 May 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid