Click here to Skip to main content
14,331,586 members

Design and Architecture

 
QuestionMessage Closed Pin
7hrs 55mins ago
memberMember 146280677hrs 55mins ago 
QuestionTraditional architecture, SOA, or serverless Pin
Darina Smartym15-Oct-19 22:28
memberDarina Smartym15-Oct-19 22:28 
AnswerRe: Traditional architecture, SOA, or serverless Pin
Eddy Vluggen17-Oct-19 23:21
mveEddy Vluggen17-Oct-19 23:21 
GeneralRe: Traditional architecture, SOA, or serverless Pin
ZurdoDev18-Oct-19 1:08
professionalZurdoDev18-Oct-19 1:08 
GeneralRe: Traditional architecture, SOA, or serverless Pin
Eddy Vluggen18-Oct-19 2:01
mveEddy Vluggen18-Oct-19 2:01 
AnswerRe: Traditional architecture, SOA, or serverless Pin
ZurdoDev18-Oct-19 1:10
professionalZurdoDev18-Oct-19 1:10 
QuestionMultiple resource files per culture Pin
agolddog1-Oct-19 9:43
memberagolddog1-Oct-19 9:43 
AnswerRe: Multiple resource files per culture Pin
Gerry Schmitz1-Oct-19 10:36
mveGerry Schmitz1-Oct-19 10:36 
AnswerRe: Multiple resource files per culture Pin
Eddy Vluggen1-Oct-19 14:59
mveEddy Vluggen1-Oct-19 14:59 
QuestionMessage Removed Pin
31-Jul-19 14:57
memberUFC 242 Khabib vs Poirier31-Jul-19 14:57 
QuestionLoading Dropdown Pin
chennaiprince13-Jul-19 3:18
memberchennaiprince13-Jul-19 3:18 
AnswerRe: Loading Dropdown Pin
Gerry Schmitz13-Jul-19 8:23
mveGerry Schmitz13-Jul-19 8:23 
AnswerRe: Loading Dropdown Pin
Mycroft Holmes13-Jul-19 11:06
memberMycroft Holmes13-Jul-19 11:06 
AnswerRe: Loading Dropdown Pin
C. David Johnson13-Sep-19 7:58
memberC. David Johnson13-Sep-19 7:58 
GeneralRe: Loading Dropdown Pin
Eddy Vluggen13-Sep-19 8:02
mveEddy Vluggen13-Sep-19 8:02 
QuestionMessage Removed Pin
4-Jul-19 21:22
professionalContact Official Support4-Jul-19 21:22 
QuestionHow to get applicable OOP / software structure knowledge Pin
qkhanhpro1-Jul-19 21:34
memberqkhanhpro1-Jul-19 21:34 
AnswerRe: How to get applicable OOP / software structure knowledge Pin
OriginalGriff1-Jul-19 21:46
protectorOriginalGriff1-Jul-19 21:46 
AnswerRe: How to get applicable OOP / software structure knowledge Pin
Gerry Schmitz2-Jul-19 6:41
mveGerry Schmitz2-Jul-19 6:41 
AnswerRe: How to get applicable OOP / software structure knowledge Pin
Benktesh Sharma7-Aug-19 18:55
memberBenktesh Sharma7-Aug-19 18:55 
QuestionDesign an algorithm for generic database analytics Pin
Michael Sterling29-May-19 23:18
memberMichael Sterling29-May-19 23:18 
AnswerRe: Design an algorithm for generic database analytics Pin
Eddy Vluggen30-May-19 0:04
mveEddy Vluggen30-May-19 0:04 
GeneralRe: Design an algorithm for generic database analytics Pin
Michael Sterling30-May-19 1:42
memberMichael Sterling30-May-19 1:42 
PraiseRe: Design an algorithm for generic database analytics Pin
Eddy Vluggen30-May-19 2:32
mveEddy Vluggen30-May-19 2:32 
AnswerRe: Design an algorithm for generic database analytics Pin
Mycroft Holmes30-May-19 12:22
memberMycroft Holmes30-May-19 12: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

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.