Click here to Skip to main content
14,691,601 members
Home » Discussions » Design and Architecture
   

Design and Architecture

 
AnswerRe: How to get applicable OOP / software structure knowledge Pin
OriginalGriff1-Jul-19 22:46
mveOriginalGriff1-Jul-19 22:46 
AnswerRe: How to get applicable OOP / software structure knowledge Pin
Gerry Schmitz2-Jul-19 7:41
mveGerry Schmitz2-Jul-19 7:41 
AnswerRe: How to get applicable OOP / software structure knowledge Pin
Benktesh Sharma7-Aug-19 19:55
MemberBenktesh Sharma7-Aug-19 19:55 
QuestionDesign an algorithm for generic database analytics Pin
Michael Sterling30-May-19 0:18
MemberMichael Sterling30-May-19 0:18 
AnswerRe: Design an algorithm for generic database analytics Pin
Eddy Vluggen30-May-19 1:04
professionalEddy Vluggen30-May-19 1:04 
GeneralRe: Design an algorithm for generic database analytics Pin
Michael Sterling30-May-19 2:42
MemberMichael Sterling30-May-19 2:42 
PraiseRe: Design an algorithm for generic database analytics Pin
Eddy Vluggen30-May-19 3:32
professionalEddy Vluggen30-May-19 3:32 
AnswerRe: Design an algorithm for generic database analytics Pin
Mycroft Holmes30-May-19 13:22
professionalMycroft Holmes30-May-19 13:22 
The trouble here is that you are going to be querying the database architecture and that will change between each database type. I would also rank the importance of the tests to reduce the amount of work your system is going to have to do. Assuming SQL Server.

1. You can query the system to get the physical size and or the row count of each table using SMO
2. Query the system views to get the FK count (and possibly the links to the 1 tables)
3 As Eddy said 0 or null fields indicate a badly designed database. This is going to be costly to query against the large tables (if it is the small tables you REALLY have a problem)
4. Again Eddy has it right, do you store/audit the change information.
5. Sounds like 3 all over again - extend the definition of meaningful
6. In your dreams - if you can design something for forward requirements you are better than the rest of us.

What you are proposing is a rules engine and they are excellent while the rule count is small, once it grows too large the entire thing becomes unsupportable. There are MANY commercial rules engines out there.

I would approach this by demanding the business case for such a tool, what are the benefits and who is going to support, extend and pay for it. When that is not forthcoming I would shelve the entire thing.

I can't see how AI would help here (my AI knowledge is zero) but it would be a major exercise for each database you are going to support. I would also break it into 2 major projects, the database querying project that will need to be extended with each one you support and the analytical project that should be generic, accepting data from all the database types.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

GeneralRe: Design an algorithm for generic database analytics Pin
Michael Sterling1-Jun-19 3:17
MemberMichael Sterling1-Jun-19 3:17 
GeneralRe: Design an algorithm for generic database analytics Pin
Mycroft Holmes1-Jun-19 14:43
professionalMycroft Holmes1-Jun-19 14:43 
AnswerRe: Design an algorithm for generic database analytics Pin
Gerry Schmitz30-May-19 15:11
mveGerry Schmitz30-May-19 15:11 
QuestionWhat is an image map? Pin
Shraddha_Patel26-May-19 21:36
MemberShraddha_Patel26-May-19 21:36 
AnswerRe: What is an image map? Pin
Richard MacCutchan26-May-19 22:26
mveRichard MacCutchan26-May-19 22:26 
AnswerRe: What is an image map? Pin
Eddy Vluggen27-May-19 0:48
professionalEddy Vluggen27-May-19 0:48 
AnswerMessage Closed Pin
13-Dec-19 2:43
MemberMember 1468847913-Dec-19 2:43 
QuestionLooking to figure out how to design a desktop and theme for an operating system based off of Linux. Can anyone point me in the right direction on how to do this? Anyone know of any books? Any tips? Any pointers? Any Forums? etc. The other parts are a Pin
justinsloan3217-May-19 23:18
Memberjustinsloan3217-May-19 23:18 
AnswerRe: Looking to figure out how to design a desktop and theme for an operating system based off of Linux. Can anyone point me in the right direction on how to do this? Anyone know of any books? Any tips? Any pointers? Any Forums? etc. The other parts a Pin
Richard MacCutchan17-May-19 23:19
mveRichard MacCutchan17-May-19 23:19 
GeneralRe: Looking to figure out how to design a desktop and theme for an operating system based off of Linux. Can anyone point me in the right direction on how to do this? Anyone know of any books? Any tips? Any pointers? Any Forums? etc. The other parts a Pin
justinsloan3217-May-19 23:26
Memberjustinsloan3217-May-19 23:26 
GeneralRe: Looking to figure out how to design a desktop and theme for an operating system based off of Linux. Can anyone point me in the right direction on how to do this? Anyone know of any books? Any tips? Any pointers? Any Forums? etc. The other parts a Pin
Richard MacCutchan18-May-19 0:35
mveRichard MacCutchan18-May-19 0:35 
AnswerRe: Looking to figure out how to design a desktop and theme for an operating system based off of Linux. Can anyone point me in the right direction on how to do this? Anyone know of any books? Any tips? Any pointers? Any Forums? etc. The other parts a Pin
jschell18-May-19 7:54
Memberjschell18-May-19 7:54 
AnswerRe: Looking to figure out how to design a desktop and theme for an operating system based off of Linux. Can anyone point me in the right direction on how to do this? Anyone know of any books? Any tips? Any pointers? Any Forums? etc. The other parts a Pin
Gerry Schmitz18-May-19 8:15
mveGerry Schmitz18-May-19 8:15 
AnswerRe: Looking to figure out how to design a desktop and theme for an operating system based off of Linux. Can anyone point me in the right direction on how to do this? Anyone know of any books? Any tips? Any pointers? Any Forums? etc. The other parts a Pin
Dar Brett18-May-19 17:50
MemberDar Brett18-May-19 17:50 
QuestionSend Purchase Order and Verify Email Pin
Kevin Marois13-May-19 14:03
professionalKevin Marois13-May-19 14:03 
AnswerRe: Send Purchase Order and Verify Email Pin
Mycroft Holmes13-May-19 16:24
professionalMycroft Holmes13-May-19 16:24 
GeneralRe: Send Purchase Order and Verify Email Pin
Kevin Marois13-May-19 18:07
professionalKevin Marois13-May-19 18:07 

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.