Monday, March 26, 2007

14th entry - Structured Query Language (SQL)

Structured Query Language is another computer language for database. It enable user to create, retrieve, update and delete from the database server. It is important to implement SQL database to ease the problem of managing big amount of database in business online transaction.

SQL practically is an ANSI (American National Standard Institute) standard for the computing database language. As mentioned SQL enable user to from creating records to deleting records. SQL is widely use by organization around the world to maintain their databases and it also able to works with multiple types of database program, such as Oracle, MySQL, Microsoft SQL server and etceteras.

Reference
W3Schools (2007), "SQL Introduction",
http://www.w3schools.com/sql/sql_intro.asp

13th entry - NetBeans UML Features in detail

Refering from the NetBeans (2007), UML not only provide features such as shown in previous entry. It provide features such as forward engineering and reverse engineering. Developer able to produce code from the UML model for more details coding and functionality towards the application the developer creating. None the less it also able design an UML models diagram by refering to previous existing code.

As the UML diagram are being created, there will be no any artificial tag. Sometimes those tag can be annoying to certain developer, this is because the developer will need to delete those marker if it is not the marker that the developer desire to be in the coding. Marker tag such as comment tag that always auto generated when ever a new set of code being enter.

NetBeans UML supports up to 8 diagrams, Activity, Class, Collaboration, Component, Deployment, Sequence, State and Use Case diagram. Diagram are very important for the initial design stage, because it will reflects the overall functionality of the system incorporate with the hardwares, softwares and users.

It also allow requirement gathering through it together with predefine and extensible design pattern. Developer able to import the design requirement into xml file for viewing. With this method it allow web reporting to be created directly from the UML model to make sharing the report with others easier and faster in this way.

Reference
NetBeans (2007) , "uml: NetBeans UML Modeling",
http://uml.netbeans.org/features.html