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...
- home
-
community portal for financial trading and stock Investment
Client Requirement
The site will be an exhaustive financial trading community website which will enable users to discuss stocks and learn about investing, track tips from star investors, and gauge market sentiment through polls.
The site will offer up-to-the-minute information, news, statistics and expert opinions on the current happenings in the stock market.
It will track picks by professional analysts and various financial experts, so users can see how well they are perform against the experts. This will allow users to assess the reliance that they should put on an individual's advice and to benchmark their own investment performance against them.
The site will help users to share investment ideas, exchange market research, and track peers' investment performance.
The site will allow members to participate in market polls and provide rating for other members for their market picks.
In addition to the business-related attributes, the site will also focus on enhancing the users' online trading experience through numerous convenient features like blogs, discussion forum and market research reports, among others.
Challenges
The team faced the following challenges:
- Incorporating and managing up-to-date information, news, statistics and related data on the backend through 3rd party API and RSS feeds.
- Developing a sturdy & dependable framework to support the real-time updating of content on the site.
- Allowing the site to handle millions of users at the same time without slowing down.
- Incorporating web usability principles while developing numerous features designed for enhancing the users' community networking experience.
- Harmonizing the simultaneous execution of various integrated features and options while maintaining consistent load balance.
- Ensuring safe and secure transfer of data while integrating RSS feeds and 3rd party APIs.
Technologies Used
| PHP (Server-side Language) | A suitable 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 JDBC 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 |
Manpower
| Project Leader | 1 |
| Developers | 2 |
| Designers | 2 |
| Quality Assurance Testers | 1 |
Planning
The following four-tier development approach was adopted to equip the site with numerous features and functionality mentioned before:
- The Database layer containing MySQL Server Database, Tables and so on
- The Data Access layer containing the Data Access Objects responsible for accessing data from database
- The Business Layer DLL consisting of all business logic procedures for modules like Offices, Properties, Maps etc
- The User Interface Layer which forms the Graphical User Interface of the website.
Development Highlights
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, 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. 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 6 months.
Download PDF