Click here to Skip to main content
14,638,374 members
Home » Discussions » Design and Architecture
   

Design and Architecture

 
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
MemberC. 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
Memberqkhanhpro1-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
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 
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
professionalEddy 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
professionalEddy Vluggen30-May-19 2:32 
AnswerRe: Design an algorithm for generic database analytics Pin
Mycroft Holmes30-May-19 12:22
professionalMycroft 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
professionalMycroft 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
mveRichard MacCutchan26-May-19 21:26 
AnswerRe: What is an image map? Pin
Eddy Vluggen26-May-19 23:48
professionalEddy Vluggen26-May-19 23:48 
AnswerMessage Closed Pin
13-Dec-19 1:43
MemberMember 1468847913-Dec-19 1: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 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
mveRichard 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
mveRichard 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 

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.