If where,about PHP/Oracle development model Myers Internet shortens the check study that uses program lifecycle.
To main by the company of drive of model of receivable money business character, one of business functions of its core are an input, dog and record order. It is OK that outstanding company is compared in this respect adjustable their orgnaization, increase their profit, and the limitation that won’t encounter fundamental framework. When order processing makes mistake very troublesomely, easily or abhorrent when, the company manufactures what because direct cost is mixed,reduce efficiency and incur economically loss.
In my company Myers Internet, the business item of core around move build client base, provide persistent service for Myers and help it solve a problem when client problem appears. The company is using a lot of different systems to processing order is inputted and carry out each periodic respects. These systematic both neither are each other are compositive, also do not have the mechanism that ensures each order gets correct keep account.
Myers order dogs system (MOTS)
Resemble other a lot of orgnaizations are same, myers grows from a small-sized company for a medium-sized company, be in at the same time its whole same process and system were preserved from beginning to end during growing. When these processes are building great majority, all clerical processing are recorded through email, paper quality and visit bearer building site to finish on the spot. 5 or 6 years ago, the Cold Fusion that an engineer of Myers uses Allaire and database of a Microsoft SQL Server assembled a system to dog order is carried out, this system calls MOTS (Myers order dogs system) , it allows sale and order of input of account management department, implement these order by system of support, project, design, information and accounting department next. Although this system is the important one step of forward stride, but it still stays have a lot of artificial move, and do not have the business system with any other compositive together.
Be in probably same time, still established a system, in this system client and sale represent the product of website of the OK and online Myers that order. This system can found new Web site, calculate the summation of the installation that offerred Web site program includes and repeatability charge. Next it sends email to give each departments, each branches can go to order input in MOTS, establish information of chalk it up in account management system.
Architecture obstacle
The architecture of this kind of type suffers the pain of issue of a few kinds of systems. In Myers, one of more obvious questions include to start order to dog requires manual data input, and the mistake of as the result of this kind of artificial process generation. Another problem is the order in the company input, order dogs and between system of chalk it up be out of line, the error that missing, information forgets order and its cause.
Another problem that appears on occasion only is MOTS system itself has immanent drawback. Because write the kind of MOTS, can input the order that perhaps lost sectional allocation information without sectional allocation information. When this kind of circumstance happening, order will be lost finally in the system. When order is missing, accurate, seasonable chalk it up came true harder.
As business grow, the blemish in architecture becomes more and more apparent, and be mixed as the client order what measure oddly to increase, the frequency that loses the order that inputs with the mistake to appear is taller and taller, brought the impact that is hard to assess to company income thereby. In addition, the amount of the data of manual input brought about defer and processing efficiency low.
Because be inside executive orgnaization,be increased to the influence of income and loss of efficiency, must want to one replaces a system to rise all connection apparently, rise efficiency and lower wrong rate. Old system graphic representation is as follows.
Graph 1: Old systematic architecture
This graph showed all extent that need manual data input. Because these systems are not compositive, the possibility with missing or so fuzzy data is very large. Global demand becomes apparent immediately rise.
Order system need is mixed directly carry out dog systematic connection rises. This system needs safe protection to prevent order to be in without the system is being severed before processing. Need maintains an accuracy, in order to ensure accurate chalk it up and proper order form are carried out. The system needs to make in-house cost the smallest change. So, want to achieve that goal, need apace establishs a system, but the system must have complete function.
Although a good order input is mixed,dog the system can be helped reduce cost, but itself does not create income.
Thorough structure
Before beginning mode to design, need solves a few main architecture problems. The first rock-bottom technology demand is a system must can configure, and need not code additionally. Substantially, this means need to embed working shedding in the database, is not to use an explanation / processing code will have hard code. The 2nd, the database needs to contain enough information, what so that can behave order,input an interface is main (and can change) respect and executive processing.
In the process that solves afore-mentioned problems hard, this system agrees with gradually two parts—Order input and order dog, be in both between the connection that offerred specific definition. Order inputs a system to need to know how to use accurate product code, discount and price clause to represent order. Order executive system needs to know how to dog the task of all sorts of types, relevant exercise and each branches, with handle and recording every order. Finally, need is mixed regularly can forecast the ground to change order form into executive exercise. Next graphs showed the structure of the new system that exists at present.
Graph 2: New systematic architecture
This graph showed all information way that leads to new order system, new order system is located in the portal management site of back end. All initiative data are inputted only one-time finish, data of each level test and verify that and need every group only processing. Transmit through introducing the automatic data that runs a system to account from order system, crucial number also turns into according to another when transmit main field automation.
Depend on PHP
On the level of pure technology, inchoate decision uses PHP to serve as main development language and Oracle to regard systematic data as information library, this has a few main reasons. Above all, almost completely the Oracle database that has according to with PHP writes the back end portal with existing Myers, this need arises the potential source of incompatible sex besides. This still is meant should establish this new system, myers can use the capacity of oneself, these ability founded existing back end portal.
The 2nd, experimental test shows, develop language photograph to compare with other, PHP provided a higher performance level. Because PHP is the data-base that serves as a dynamic to load,be stationed in those who stay in Apache server interior, so every time and systematic join need not start time additionally. In addition, the improvement that PHP optimizes (through Zend project) mean the general operation that executes in code interior to won’t slow apparently. Finally, be compiled with C code and the OCI interface module that writes for PHP is optimized, this makes visit Oracle database very efficient.
The 3rd, because PHP code embedded its oneself,our understanding arrives in HTML environment, to the design so personnel is mixed process designing personnel, found code of function of synergic user interface to become more natural. Although the server of this characteristic other carries script language to also be had finally, but Myers discovers PHP is more impossible to bring the conflict between development staff and design personnel. In addition, the grammar of PHP and offerred code library mean it to be able to do it to need all businesses that do.
Finally, will all code embeds another advantage in HTML code is, need to undertake modification controlling can controlling source code to standard text file only. We revise control system as its standard with CVS. Because PHP code must not use some to plant,means undertakes compiling, “ that establishs a system so compiles ” to be involved only retrieve file of text source code from inside information library, put them to Web server next. The test that this means us to be able to use the control mechanism in CVS to be it and manufacturing environment release the Bug patch of increment, and need not found compile a system complexly.
Design mode will support can configure a gender afresh
The fundamental pattern sketch map below showed order system is how compose builds. Two kinds of main mode are divided express for archetypal watch and general affairs. Whenever when business situation produces change, archetypal watch allows to deploy a system afresh, and need not code afresh. General affairs expresses the order detailed information that contains actual client order for goods and exercise detail.
Graph 3: Fundamental pattern sketch map
Graph 4: Fundamental pattern sketch map
These mode sketch map look very complex, of course, they are very complex really. Nevertheless, if part them, make an occurrence prototype watch (the watch that ends with _def) , so the basic structure of this architecture becomes very clear. Order is comprised by travel series, these travel serieses include detailed information, order travel or both. Order can establish operation at will all right, exercise is comprised by alignment of a task, and contain a few detailed information. Need to input these detailed information for all sorts of tasks surely. The task appears in different alignment, these alignment can have a visit by the specific user of different branch.
To examine system, strategy is grading changes order system prototype. The first part that the system should examine is it express from order prototype alone in the ability that establishs a clear order. Once finished original mode definition, order builder can look a part the first times of the system that original shape changes namely.
Forms to compose is built and deploy this system group is divided contain the manager that gets this system to affect each the largest departments besides, still include 3 development personnel. Develop the division of labor of personnel to be respectively: Compose builds configuration function, indication function and clerical processing function. Cycle is built in whole and first form inside, sectional manager was offerred about the interface (these interfaces make the user can be inputted with processing data) the valuable feedback of the type.
Use PHP scale user interface
Wanting the initiative order that prototype dissolves is basic Web site order for goods, offer on Webwiz.myersinternet.com/ . Gotten order is founded inside the time that develops personnel to be in with PHP 3 days by. If order prototype is defined—Rely on a code of a PHP between database and browser, with respect to the exterior that can define order completely to input and behavior, what need certain level in database design so is eclectic. For this, the structure of and so on of series of travel of such as order must support two use: (1) is offerred on input watch sheet distinguish visibly, with making similar product group OK scale is together (2) is opposite from the function similar goods in group, made the goods of certain discount for example, or an option list, can make only choice from which.
Because PHP is development language, so prototype is established quite fast, thereby can the modification that place of the apace mode that finish needs and code afresh to express only maker (one before one hind) . In addition, because mode is the user interface that considered scale and of the design, should build in archetypal compose so when new visible requirement appearing in the process, undertake mode is revised easily and adapt. The generated outward appearance that express sheet is as similar as next graphs:
Graph 5: Order is generated
Establish the system with a complete function
After offerring order form, need makes it becomes the function is complete. Above all, the order data that the system needs to save what input in order to be used at general affairs to handle. The 2nd, fill in the person need of order can fill in according to having medium order data.





