Click here to Skip to main content
14,237,950 members

Design and Architecture

 
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 
QuestionMessage Closed 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 
QuestionDesign an algorithm for generic database analytics Pin
Michael Sterling29-May-19 23:18
memberMichael 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
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 
GeneralRe: Design an algorithm for generic database analytics Pin
Michael Sterling1-Jun-19 2:17
memberMichael Sterling1-Jun-19 2:17 
GeneralRe: Design an algorithm for generic database analytics Pin
Mycroft Holmes1-Jun-19 13:43
memberMycroft Holmes1-Jun-19 13:43 
AnswerRe: Design an algorithm for generic database analytics Pin
Gerry Schmitz30-May-19 14:11
mveGerry Schmitz30-May-19 14:11 
QuestionWhat is an image map? Pin
Shraddha_Patel26-May-19 20:36
memberShraddha_Patel26-May-19 20:36 
AnswerRe: What is an image map? Pin
Richard MacCutchan26-May-19 21:26
protectorRichard MacCutchan26-May-19 21:26 
AnswerRe: What is an image map? Pin
Eddy Vluggen26-May-19 23:48
mveEddy Vluggen26-May-19 23:48 
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 22:18
memberjustinsloan3217-May-19 22: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 22:19
protectorRichard MacCutchan17-May-19 22: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 22:26
memberjustinsloan3217-May-19 22: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 MacCutchan17-May-19 23:35
protectorRichard MacCutchan17-May-19 23: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 6:54
memberjschell18-May-19 6: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 7:15
mveGerry Schmitz18-May-19 7: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 16:50
memberDar Brett18-May-19 16:50 

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.