Yellow Pages Based Business Networking Application

Categories : All, Case Study, Social Networks

Client Requirement


The site is a Yellow Pages Based Business Networking Application exclusively aimed towards helping people find the right services on the net.

Through its online ‘Yellow Pages’ resource it will gather people’s collective intelligence and network them to locate the best possible businesses. Targeted to be the ultimate resource for locating local businesses the site will offer a range of features such as Google Maps, location-centric searches and extensive user reviews in the form of articles, images and videos.

Through its community section, users will be encouraged to create an accurate profile and build a trustworthy community that helps them find and offer reliable services on the net.

The site will offer a range of tools for enhancing offline interactions between users along with bidding tools for getting the best deals.

The site will provide numerous customization options with easy navigation and user-friendly features to ensure access for members of all experiences.

Project Challenges

Team faced the following challenges:
  • Incorporating web usability principles while developing numerous features designed for enhancing the users’ community networking experience.
  • The implementation of a highly flexible and robust database that smoothly handles already millions and constantly increasing online business records.
  • Providing a robust framework for handling extensive amount of data, ratings, statistics and options like bidding etc.
  • Sustaining good load balance for a feature-heavy website that is available 24/7 and accessed by thousands of users simultaneously.
  • Developing a fully comprehensive business portal offering all the benefits of a community website along with crucial business-locating features such as Google Maps, Video Reviews and Bidding Tools among others.
  • Ensuring user privacy and safeguarding their content.

Technologies Used

Operating System & Server Management Red Hat Linux OS, Multi-Server Architecture with Staging & Production Environment through Version Controlling releases, Server Optimization, Security & SSL Implementation, Scheduler for Back-ups, Alert Monitoring System Integration, Server Performance Tuning at regular intervals, Software Firewall Configuration & Maintenance
Development Tools & Environments PHP5+, Apache Web Server, AJAX, Java Script, HTML5, CSS3 etc.
Database MYSQL Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Scheduler for Backups


Project Leader 1
Developers 5
Designers 2
Quality Assurance Testers 3


Keeping in mind the enormous structure of the website and the challenges involved a four- tier development approach was adopted consisting of:
  • The Database layer containing MySQL Server Database, Tables, Stored Procedures and so on.
  • The User Interface layer which forms the Graphical User Interface of the website.
  • The Interface layer and Database Abstraction layer for converting data between incompatible type systems in databases and accessing data from the database respectively.
  • The Business Logic layer consisting of all the business logic procedures for modules like User Profiles, Invitations, Forums, Blogs etc.


The design approach was built around PHP and MySQL Server due to the social networking nature of the website. Modules like User Profiles, Invitations, Forums and Blogs 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. Stored procedures were used only for complex retrieval 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. Sub-domains were used for the different areas of the website to guarantee scalability.

Development Highlights

The sturdy architecture was equipped with an exhaustive yellow pages database to fulfill the business networking aspect of the site. The optimized database was synergized with superior query features to offer accurate results through comprehensive search & browse options. Category-based and location-centric searches were enhanced by the inclusion of Google Maps and image-accompanied reviews. The site employed numerous user and service ranking tactics to encourage user participation and ensure the authenticity of reviews.

Extensive bidding options provided by the site helped users to locate the best services for cheap. Besides the integration of coupons systems, the site was equipped with numerous video options for supporting video reviews of services. 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 5 months.

[Total: 0    Average: 0/5]

Client Saying

Chad Gundry, the CEO of says that he has worked extensively with Brainvire team since last 6 to 7...
Mr. Chad Gundry
Daniel Coburn, the president of gives the honest opinion regarding his experience working with Brainvire for developing his social...
Mr. Daniel Coburn
One of my friend recommended me Brainvire. It was an immense pleasure to work with them. I found their team...
Mr. Umesh ranglani
I am truly happy with Brainvire’s exceptional service. Whenever I had a question they answered it without delay. With extreme...
Mr. Richard Desilva
When the world was moving at a very speedy pace, Brainvire helped us stay connected. Thanks to their unique services...
Travis French

Latest Happenings

  • 04 Oct 2016
    Brainvire Making great Strides with Symfony Development Services [ + ]
  • 29 Sep 2016
    Brainvire augments its List of Offerings with Magento Sears Integration Services [ + ]