An example application of design patterns in the software industry


A common type of mechanism used to solve problems in the software industry is the workflow mechanism. at least in a very broad manner of description. A service has to do a particular job, but to do that particular job it has to query a couple of other services, and then process all the information, persist it and then update a downstream service with the processed information. I'll give an example from the advertising domain.

Any advertising platform must find out a way to filter out bad ads, could be because of vulgar test, photo not following resolution guidelines etc. The seller interface registers the new ads in the main database. The ad quality service periodically gets the new ads from the registration service which are marked as under processing. The ad quality service has to make the ad go through multiple local checks with local persistence, and then finally it has to update the ad server with the final verdict on whether the ad follows all guidelines and is good to go, or update the ad server with the reason the ad was rejected. This final update itself can be a combination of many service calls, like one service update that the ad text is good, the other to update ad photo does not follow policy guidelines, and another to update which regions this ad can be shown and so on. If any of these steps fail, it can lead to an inconsistent state of the complete ad information.

This scenario requires reverting all the changes done by the ad quality service if any of the steps failed. This is solved by using the undo pattern, where all steps are implemented with their inverse/reverse also implemented in the class/service and when any step fails all the previous steps are reverted. As patterns are named differently in different sources, I am using Gang of Four as a reference and the patterns from this book used are 'Chain of Responsibility' and 'Command' patterns in combination. I like to call it 'Chain of Command'.

Comments

Post a Comment

Popular posts from this blog

Connect to MySQL 5.7 from Python using SSL

In the previous blog we saw how to connect to MySQL Server 5.7 from PHP using SSL. In this entry I will describe the steps I took to connect to MySQL Server 5.7 from Python code. I used mysql-connector as the Python library. The default install (version 2.2.3) failed, so I had to install the previous version (v. 2.1.6). sudo pip install mysql-connector==2.1.6 The code to connect using Python is similar to PHP with similar parameters which have to be set. I did run into a few issues with my query not getting parsed if I passed query parameters as parameters. So I had to prepare the whole query and send it as a single complete query with no parameters in the 'execute' function. Below is my piece of working code. As I went further and tried to put data fetched from WoW API, I faced further problems with text encoding. I also had problems with creating multi line queries. I could not find a lot of discussion material on Stackoverflow. I found out though that Python 2...
Read more

Performance improvement of MySQL inserts in Python using batching

In this blog entry we will see how much performance improvement we can get by using batching for inserts in MySQL 5.7 from a Python3 client. In this example the number of rows to be inserted is around 140K. The json blob for this data has a size of around ~25MB. First we will insert them one by one. Note even in this case, I am inserting all of them and finally doing a single commit. The default behavior of the mysql-connector library is that autocommit is false. This is good for performance. If we commit after each insert, the performance will be even worse. Below are the code and performance details. Number of auctions: 139770 Number of rows affected : 139770 Time taken for insert: 34.17 s For my use case, I was okay with around 30 seconds of insert time for the bulk update, but thought of trying out the batch insert. I ran into a problem because of the default max packet size for MySQL execute statements. I had to change it in my.cnf file by adding max packet siz...
Read more

Connect to MySQL Server 5.7 from PHP 7.0 using SSL

It took me from late morning to evening to be able to connect to MySQL Server 5.7 from PHP 7.0 over SSL on an EC2 machine with Amazon Linux OS image. There were many steps and each had its own challenge. Below I am mentioning the steps and how I worked around the problems. Step 1: Upgrading PHP from 5.6 to 7.0. First one has to remove the existing version of PHP and then install a newer version. I tried installing version 7.1 first but I ran into dependency issues like libpng15 for which the easiest way to install is to build from source. To avoid falling into this dependency cycle, I tried installing version 7.0 and this one installed smoothly. # Remove PHP 5.6 [ec2-user@ ~]$ sudo yum remove php5* # Install PHP 7.0 [ec2-user@ ~]$ sudo yum install php70 php70-mysqlnd php70-imap php70-gd \ php70-pecl-memcache php70-pecl-apcu Step 2: Upgrading MySQL server from 5.6 to 5.7. The default repos did not have MySQL 5.7. I also could not install it by adding repos, as ev...
Read more