Click here to Skip to main content
15,914,500 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
AnswerRe: Minimize the risk that (bad) programmers call specific functions? Pin
Mycroft Holmes21-Dec-19 11:29
professionalMycroft Holmes21-Dec-19 11:29 
AnswerRe: Minimize the risk that (bad) programmers call specific functions? Pin
cjb11011-Feb-20 23:45
cjb11011-Feb-20 23:45 
QuestionTraditional architecture, SOA, or serverless Pin
Darina Smartym15-Oct-19 22:28
Darina Smartym15-Oct-19 22:28 
AnswerRe: Traditional architecture, SOA, or serverless Pin
Eddy Vluggen17-Oct-19 23:21
professionalEddy 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
professionalEddy Vluggen18-Oct-19 2:01 
AnswerRe: Traditional architecture, SOA, or serverless Pin
ZurdoDev18-Oct-19 1:10
professionalZurdoDev18-Oct-19 1:10 
GeneralRe: Traditional architecture, SOA, or serverless Pin
Eddy Vluggen20-Oct-19 8:04
professionalEddy Vluggen20-Oct-19 8:04 
GeneralRe: Traditional architecture, SOA, or serverless Pin
Dar Brett20-Oct-19 14:58
Dar Brett20-Oct-19 14:58 
GeneralRe: Traditional architecture, SOA, or serverless Pin
Eddy Vluggen21-Oct-19 1:37
professionalEddy Vluggen21-Oct-19 1:37 
GeneralRe: Traditional architecture, SOA, or serverless Pin
Dar Brett21-Oct-19 13:30
Dar Brett21-Oct-19 13:30 
QuestionMultiple resource files per culture Pin
agolddog1-Oct-19 9:43
agolddog1-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
professionalEddy Vluggen1-Oct-19 14:59 
AnswerRe: Multiple resource files per culture Pin
Leon Swift21-Nov-19 1:40
Leon Swift21-Nov-19 1:40 
QuestionLoading Dropdown Pin
chennaiprince13-Jul-19 3:18
chennaiprince13-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
professionalMycroft Holmes13-Jul-19 11:06 
AnswerRe: Loading Dropdown Pin
C. David Johnson13-Sep-19 7:58
C. David Johnson13-Sep-19 7:58 
GeneralRe: Loading Dropdown Pin
Eddy Vluggen13-Sep-19 8:02
professionalEddy Vluggen13-Sep-19 8:02 
QuestionHow to get applicable OOP / software structure knowledge Pin
qkhanhpro1-Jul-19 21:34
qkhanhpro1-Jul-19 21:34 
AnswerRe: How to get applicable OOP / software structure knowledge Pin
OriginalGriff1-Jul-19 21:46
mveOriginalGriff1-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
Benktesh Sharma7-Aug-19 18:55 
QuestionDesign an algorithm for generic database analytics Pin
Michael Sterling29-May-19 23:18
Michael Sterling29-May-19 23:18 
Hi all,

I would like to build an algorithm that gets as an input a SQL database (for example SQL Server or mysql) and returns the most Important tables/views/fields in it .

Now, important is described as follows:

1. Large tables (whereas Large is not not an absolute value , but rather larger in comparison to other tables)
2. Tables with many linked tables attached (for example orderHeaders orderDetails etc.)
3. Fields with large variance (fields that all values within are null or 0 NOT important)
4. Frequently changed fields ( If users updated table records yesterday and a day before it is important)
5. Fields with Meaningful text inside
6. more properties I'm not thinking about right now....

Ideally , I would like to tweak the importance of each property above and get different results

How would you approach and design this kind of algorithm ? since it involves data modeling , analytics and AI all together...
Any known service or APIs I can use to shorten development time ?

Thank you all in advance
Michael

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.