1. Technology Requirements – High level requirements. The architecture for this project should be the latest most robust technology available to manage the complexity of heavy traffic environment. If this can be established in a cloud-based server where the integrity of the members’ information and data will not be compromised, then cloud is acceptable. The objective is to build an environment that offers security for member data as well as security and management for the contracts, requests for proposals (RFP), and other bid notifications documents. Other common security threats should be anticipated such a SQL injection, common attacks, and user rights and permissions. Recommended technology:
ASP.Net, Windows Server 20082, and MS SQL Server 2012 Standard Edition .Net Framework 4.0 and Internet Information Server (IIS) 7.5
File size – The type of information imported from DGS is primarily text files. It should be expected that each document could consist of at a minimum of 80 pages which could be a .pdf file or .doc file. These files should be archived in some manner up to one year. Therefore storage and retrieval capabilities are required within the search capabilities.
2. Front-end Design – The front-end design should be a standard/intermediate landing page that displays text, images, basic navigation, about us, contact us, bid notifications, My Account link, registration, links to other partners, CALBCC, CALBCCF, news feeds, integration with social media. Typical pages should include the following:
About Us Industry Compliance
Industry types Open bids Closed bids
Type of Subscription Registration (Specific names of corporate members posting)
3. Database – The database should be designed and developed as a strong storage and retrieval instrument with upload and down load speeds adequate for optimal functionality. Storage of membership applications and the ability to update information as the user deems necessary. Retrieval accessibility. The design should be congruent with the DGS spreadsheet in which the data is fed into Opportunity-Link. (Please review DGS spreadsheet). There should be unique identifiers for minority data and small businesses. KEY: THIS SYSTEM IS UNIQUE
BECAUSE IS HOUSES MINORITY DATA WHICH IS UNLIKE ANY OTHER DATABASE OFFERING MINORITY INFORMATION ON SMALL BUSINESSES. THEREFORE THERE HAS TO BE A UNIQUE QUALIFIER THAT MAY NOT BE IN DGS’ SPREADSHEET. Key language (SQL?) should speak to matching industry types from data fed to member’s identification code. Retrieval should be accessible by queried reports.
4. Bid notification/Data Feed – The system should be able to feed from DGS which houses all the vendors (public utilities, banks, educational institutions, government agencies). Request for Proposals (RFPs)/Contracts will feed into the database and matched according to the link. There needs to be verification from DGS prior to establishing this feed. (DONE) We need to ensure that there are identifying codes UNSPSC that will link the RFP/contracts to the members’ profiles. Please refer to the attached correspondence between DGS and me. Therefore, there needs to be a close review of the DGS spreadsheet to determine the relational identifier.
Reports can be purchased. Therefore, there should be a corresponding price list for pre- determined or general reports. The types of reports will be determined during the later phase of this project.
Further more details through PM.