Click here to Skip to main content
14,659,852 members
Home » Discussions » Database
   

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
mveRichard 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
mveZurdoDev4-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
mveCHill6029-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
professionalEddy 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
professionalEddy 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
professionalMycroft 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
professionalEddy 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
professionalMycroft 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
mveRichard 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
mveRichard 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
mveRichard 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.