Case Study For Data Governance Portal
Brainvire Infotech Pvt. Ltd www.brainvire.com
http://www.brainvire.com
Client Requirement
The website is the Data Governance intranet portal
Data Governance is the practice of bringing clarity around data and ensuring
Central Tool Supporting the Data Governance Department
Catalogue that holds those data items
Allows all Involved to search the catalogue and browse
Portal also supports the department in processing changes to data in a controlled and transparent manner
http://www.brainvire.com
Client’s Specific Requirements Portal is centric to Catalogues
Provide visibility around what data is being governed
list all data items under governance
For each data set under governance, a number of information elements will be captured
There are components, governance roles, quality measures, access rights, governance type, quality reports, documents and privacy defined
http://www.brainvire.com
For each catalogue, there are components defined
Defined as primary components, mandatory components or normal components
Item may create relationship with other catalogue components
Members can view or download data from the portal
Members can subscribe to public catalogue items as an email
Subscribing parties get update of new changes or addition of data
http://www.brainvire.com
Project Challenges Data in a Controlled and Transparent manner
Scalability is a key consideration
Site Labels and Static Contents in Desired Language
Ensuring more complex relation between the data and its consistency
Creating versions and reverting version
Transforming and Distributing data
http://www.brainvire.com
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 system. Cross-platform Operating Systemmanagement & compatible database component of the Server Management 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.
http://www.brainvire.com
Manpower 1 Project Leader 4 Developers 1 Designers Quality Assurance Testers
1
http://www.brainvire.com
Planning Database layer containing MySQL Server Database, Tables, triggers and so on
Data Access layer containing the Data Access DLL responsible for accessing data from database
Business Layer DLL consisting of all business logic procedures for modules
Request, Challenges, Profile, Showcase, Offerings, Directories, Fund, Circle etc
The User Interface Layer, which forms the Graphical User Interface of the website
http://www.brainvire.com
Architecture 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.
http://www.brainvire.com
Development Highlights The design approach was built around PHP 5 and MySQL SERVER 5
User Profiles, company profile, offering, requests,challenge, events, fund and circle were developed in PHP
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
The UI layer was kept free of any business logic with images, applications and data
Web usability guidelines were strictly followed during development
The site was developed and fully functional within a span of 3 months
http://www.brainvire.com
Sources : http://www.brainvire.com/website-accounts-receivablefinancing-portal
Contact Info : 1-631-897-7276 Email : info@brainvire.com Website : www.brainvire.com http://www.brainvire.com
Contact Us https://www.facebook.com/Brainvire https://twitter.com/Brainvire http://google.com/+Brainvire http://www.linkedin.com/company/brainvire-infotechpvt-ltd Contact Info : 1-631-897-7276 Email : info@brainvire.com Website : www.brainvire.com http://www.brainvire.com