Fear began to unfold as Google launched yet another web clean-up update; formally named as the Penguin update. With all new algorithms and stringent methods for penalizing the web spam, Penguin upd...

The sites online network is an internet-based crowd-sourcing platform for entrepreneurs, investors and experts working on sustainable innovations for the worlds poorest and most disadvantaged population. Platform is for solutions to solve the problem of sustainability at the BoP(Base of the Economic Pyramid).
Modeled as a unique online marketplace of buyers and sellers, the network will cater to people working jointly to discover solutions for sustainability problems. Also, for people working to raise finance and get support for scaling these solutions.
The aspect of the project is allowing entrepreneurs, investors and experts to connect with relevant people for the purpose of asking and providing resources to each other. Entrepreneurs are profit-generating enterprises ranging from an idea and prototype to existing businesses promoting innovative solutions at the BoP level. Investors include angel investors, social venture funds, traditional venture capital & private equity funds, corporate & development banks and other interested institutional investors.Experts and service providers work across sectors and domains, such as Legal/IP, Finance, HR & Training, IT, Marketing and NGO professionals, on the ground with the disadvantaged populations.
The site helps entrepreneurs, investors and experts to present themselves as an individual or a company. They can showcase their offerings (Products & Services), build network, ask for resources and exchange resources.
Core entities of the system are creating member profile, defining their roles and creating/being part of any company. Creating profile-own or companys-is to showcase their expertise, area of interest, company establishment, achievements, etc. Creating profile and providing more information is likely to attract more network connection to solve various requests or challenges.
After establishing profiles, one can setup offerings (Products & Services). From the Product & Services sections, one can showcase own or companys offerings as solution, fund or services. Offerings are yet another way of demonstrating an individuals companys services or products. Posted solutions can be useful for others who have any challenge and similar requirement.
One can make request and put forth challenges to a selected group or the entire network he is part of. Request can be post based on offerings only. Requests can be responded, forwarded or referred to others. There can be a reward attached to a shortlisted response.
There is a directory listing for members, companies, solutions, funds, services, requests, events and challenges. There is filter and advanced search option available for searching and drilling to various criteria.
Team faced the following challenges:
| PHP (Server-side Language) | A suitable and managed code development environment for handling the extensive project. |
| Red hat Linux | Sturdy and stable operating system with high level functionalities for online development. |
| MySQL Engine | Versatile, low-maintenance database management system. Cross-platform compatible database component of the LAMP platform. |
| Microsoft Visio | Integrated tool best suited for modular architecture and iterative development of software. |
| Zend Studio | Versatile web development tool with exhaustive support for CSS, JavaScript and various server-side scripting frameworks. |
| Subversion (SVN) | Ideal application providing stratified storage and back up of code files. |
| Symfony Framework | Symfony is a full-stack framework, a library of cohesive classes written in PHP. |
| Project Leader | 1 |
| Developers | 4 |
| Designers | 2 |
| Quality Assurance Testers | 2 |
The following four-tier development approach was adopted to equip the site with numerous features and functionality mentioned before:
N-tier architecture was adopted to efficiently meet the needs of the enormous website. Following are the layers involved which are loosely coupled with each other:
User Interface Layer: This will include the page level layer which will be accessing the other layers beneath to present the data.
Business Specific Layer: This acts as a bridge between the User Interface layer and database layer. This will contain all the business logic for the different components involved in the project.
Database Specific Layer: This acts as a bridge between the physical database and the business logic accessing the data.
Physical Database Layer: This includes My SQL with the tables, views and stored procedures etc.
The design approach was built around PHP 5 and MySQL SERVER 5 due to the social networking nature of the website. Modules like User Profiles, company profile, offering, requests, challenge, events, fund and circle were developed in PHP such that they can be executed directly from the UI layer. In order to most effectively access the database in an object-oriented context, an interface translating the object logic to the relational logic was used to communicate with the relational databases in an object-oriented manner. An intermediary abstraction layer was created for accessing data from the database. Triggers were used only for complex update and deletion of data from multiple tables and were entirely avoided with conditional syntax to ensure smooth performance of the website. The UI layer was kept free of any business logic with images, applications and data being called from their respective servers. Web usability guidelines were strictly followed during development and the interface was made easily navigable through judicious use of AJAX, CSS and HTML controls. The site was developed and fully functional within a span of 7 months.