ssmusoke

1,173 reputation

bio	website	ssmusoke.wordpress.com
	location	Kampala, Uganda
	age
visits	member for	1 year, 2 months
	seen	6 hours ago
stats	profile views	115

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.

	1,173 reputation	bio	website	ssmusoke.wordpress.com	visits	member for	1 year, 2 months
26 badges		location	Kampala, Uganda		seen	6 hours ago

summary answers questions tags badges favorites bounties reputation activity

128 Actions

suggestions reviews revisions comments badges posts accepts all

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
Jan 9	answered	MySQL installation and data location on Windows
Dec 20	answered	while restoring mysql database, views changed into tables
Dec 20	answered	MySQL Workbench table organisation
Dec 20	revised	How to optimize this query? Corrected the answer to remove erroneous assumptions which do not improve performance
Dec 20	comment	How to optimize this query? @MartinSmith thanks for the clarification, so I am wondering what to do with the answer, do I delete it or leave it here?
Dec 20	comment	How to optimize this query? @ypercube My understanding is that the string comparison for dates is slower, also why is (c) wrong my understanding is that indexes are better for data that is repeated as they tend to be clustered together. Thanks
Dec 20	comment	Best Way to Partition By City / State in MySQL 5.5 The user is only thinking of partitioning with regard to queries against a database table, so my answer is in attempt to solve the problem with that in mind. Why go partitioning when indexes can solve your problem?