Click here to Skip to main content
14,207,050 members

Design and Architecture

 
QuestionMessage Closed Pin
1-Jun-19 15:27
memberMember 144772171-Jun-19 15:27 
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 
QuestionSend Purchase Order and Verify Email Pin
Kevin Marois13-May-19 13:03
professionalKevin Marois13-May-19 13:03 
AnswerRe: Send Purchase Order and Verify Email Pin
Mycroft Holmes13-May-19 15:24
memberMycroft Holmes13-May-19 15:24 
GeneralRe: Send Purchase Order and Verify Email Pin
Kevin Marois13-May-19 17:07
professionalKevin Marois13-May-19 17:07 
GeneralRe: Send Purchase Order and Verify Email Pin
Mycroft Holmes13-May-19 18:05
memberMycroft Holmes13-May-19 18:05 
GeneralRe: Send Purchase Order and Verify Email Pin
Kevin Marois13-May-19 18:53
professionalKevin Marois13-May-19 18:53 
GeneralRe: Send Purchase Order and Verify Email Pin
Mycroft Holmes13-May-19 20:53
memberMycroft Holmes13-May-19 20:53 

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.


Advertise | Privacy | Cookies | Terms of Service
Web06 | 2.8.190612.1 | Last Updated 1 Jun 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid