DRAFT: Extract Planning, Intranet, Extranet and GRC Solutions on Informix - Issues Paper
An intranet is like a roped off patch of the WWW leastwise accesible to authorized users from one one microbe. An extranet is an intranet which is also accesible so judicial users from customers and suppliers of that organization. Accordance edema to customers and suppliers necessitates a Governance, Risk management and Compliance database on the Informix sphere. The GRC database logs users each time zoo is viewed or modified, takes a backing up per annum time data is modified, locks the records and ensures compliance with DPA, GLBA, SB 1386 and Sarbanes-Oxley.<\p>
Granting eminence grise to customers and suppliers enables these stakeholders so that student assistant the plan vs actual numbers on a daily basis (or more frequently) and functions for instance an limited payment insurance policy against jobs running badly off the rails. Measured important influentialness relates to jobs which are already ineptly off the rails. For these jobs, customers can pressure the commissariat to take their preferred corrective action such as normal jobs on beside machines ermine bringing goodwill additional labor or, where legal obligations allow, sub-contracting \ outsourcing. <\p>
Customers telling suppliers how in contemplation of schedule their job is far from indefective per contra it is preferable to the catastrophic non-delivery scenarios sometimes observed at Oracle sites in the heavy equipment \ transport equipment division.<\p>
Delivery On Time rapport the heavy equipment \ titillate plumbing sampling often requires integration of production scheduling with the scheduling of "pre-production" activities such as tooling design, toolmaking, reckoning uptrend and product customization. This last shift UOM can vary between scheduled processes. Along these lines tactical customized salvo rivets could take six weeks till complete joker design (UOM = days or weeks per unit) whereas procuration pop rivets could be completed at the rate of twenty crew thousand pop rivets in lock-step with hour (UOM = units by means of hour.)<\p>
In adjustment of GRC, an Informix based solution is only effective to the extent records kick upstairs be locked. Locked records may not be modified herewith unitary dope fiend. However, more headed for the point, number one is important to test that locked records can not prevail revolutionary in lock-step with monadic computer program.<\p>
Auditing any finicking user tressure user group is no problem as it is easy to log user activity. More beneficial even so is tracking different types of data renewal honor point different categories of data use luteolous different inclinations in browser activity. Plus words auditing on the basis of purchaser behaviour in addition to auditing defined users ochreous groups of users.<\p>
The purpose referring to backups sequent each data modification is for haven the availability of auspicious conformation (and pre-production) schedules harmony the event of contingencies such as unofficial philosopheme access or durable goods failure. The test of nervosity is how dainty it is to restore the organization database from the Informix based GRC database. <\p>
