1,441 reputation
37
bio website ssmusoke.com
location Kampala, Uganda
age
visits member for 2 years, 9 months
seen Jun 18 at 5:46

A results-driven, customer-focused, and analytical Software Engineer who can think “out of the box”. Strong in application and database design and integration problem solving skills in web based environments.

Experienced in LAMP and J2EE web application design, development and operations, database analysis and design. Skilled in identifying and documenting business requirements, user documentation, and integration with third party systems and applications with strong written and verbal communications. Has worked with OOP both in PHP and Java, Zend Framework, MySQL, and Spring Framework.

Fan of Re-factoring and Patterns of Enterprise Architecture by Martin Fowler, Agile manifesto and practices by Scott Ambler, Simplified Java/Application Design by Rod Johnson focusing on POJOs (Plain Old Java Objects).

Intrigued by modular architecture of Symfony 2, worried about ORMs but is loving the Doctrine2 Data Mapper, inspired by shark and pirranah focus of Oracle Corp, uses the glue by Zend Framework and Apache Commons, reads the Design Patterns from the Gang of Four like a bible.

I love data, learning about what it means, designing it, cleaning it up, modelling it, extracting it from one source, transforming it and loading it into another ...

I enjoy looking for bad smells in code and database designs learning new ways to solve old problems in the process.


Jun
16
answered Review database schema / thought process
Jun
14
comment Review database schema / thought process
1. Are nodes shared across graphs or does each graph have its own nodes? 2. Are there any patters for users or groups gaining access to graphs, or it totally random?
Apr
4
comment Foreign key with multiple table options
You can try to use triggers which can lead to a host of problems, however I would recommend putting that kind of logic into the application code or middle layer since its not native database functionality
Feb
27
awarded  Yearling
Aug
25
answered Managing constants changes to database
Aug
25
answered Restrict access to rows by usename
Aug
22
awarded  Revival
Mar
26
comment InnoDB best index practises
You also want to create indexes on columns with similar data which can be grouped together to make the indexes more efficient
Mar
25
revised Rent weekly cost database design
updated to accomodate new rules for using coefficients based on the building in which the room is located
Mar
25
comment How to write this self join based on three columns
Are there any instances in which an id can have a different parent for each language, say id 5 has parent with id 1 for language 1 and parent with id 4 for language 2?
Mar
25
comment Rent weekly cost database design
@LeighRiffel oops sorry I had not seen that modification. However the approach is still the same, either have a table with the week number/coefficient/building unit (adds up to 52 x number of building units) or have a stored procedure that computes that information if the combinations have some logic to them based on other features or data (any more than 10 different combinations makes this a nightmare)
Mar
25
comment Rent weekly cost database design
My suggestion would be to have either a table with a number corresponding to output from WEEKOFYEAR function on a specific date matched to a week coefficient (will have 52 values) or write a stored function which takes a date and matches the coefficient if there are few values specified by a range
Mar
16
comment Rent weekly cost database design
Yes the idea is to store the actual rental details in this table and compute the costs from the data in this and other tables in the system
Mar
15
answered Rent weekly cost database design
Feb
27
awarded  Yearling
Feb
19
answered An admin (GUI or shell tool) for managing all kinds of databases
Jan
29
comment Is it OK to keep a value which updates in a table?
Chris and @JNK very well put, explained it a lot better than I did
Jan
29
answered Is it OK to keep a value which updates in a table?
Jan
29
comment Coding an accounting database from scratch?
To add onto what @Catcall is saying, pick an off the shelf accounting software specifically for the type of practice you are running, down to having it hosted online so that all you pay is a monthly/annual subscription fee and spend your time healing people and growing your practice
Jan
25
comment What MySQL storage engine should I choose?
@brabertaser1992 I am not sure whether the InnoDB cache is persisted after a server restart, however this may help for the latest 5.6 version of MySQL which is going GA in a few weeks dev.mysql.com/doc/refman/5.6/en/innodb-performance.html and dev.mysql.com/doc/refman/5.5/en/innodb-performance.html for 5.5