17th entry - Reason to use MySQL 2nd part

This is the second portion of the reason to use MySQL as referring to MySQL AB (2007), as one of the database management application for businesses purposes. Below are the reason shown;

• Strong data protection. MySQL offers unique security features to ensure database informations are kept safe in the database management servers. It also support SSH (Secure SHell) and SSL (Secure Socket Layar) secure connection to prevent data being tapped by unauthorized user.
• Comprehensive application development. MySQL provide wide variety of tools and functionality to able to support every application development need. Embedded plug-in libraries, connectors and drivers are also included in MySQL.
• Management Ease. With all the tools and functionality provided, it will ease up the administration and management of the database server. Indirectly, huge amount of time are being saved.
• Open source freedom and support 24 x 7. With open source, developer able to modify or tune the code according to their desire without any much difficulty or legal protocol required for it. MySQL also provide services support and professional services to assist the developer.
• Lowest total cost of ownership. MySQL database server application is freeware and it can save thousand of dollars for the businesses organization. Not only in term of the cost of purchasing the application but also save time, does not require to purchase expensive hardware or software to operate the database management server, easy to maintain, avoid wasting time for troubleshooting and to name a few.

Reference
MySQL AB (2007), "MySQL AB :: Top 10 Reasons to Use MySQL",
http://www.mysql.com/why-mysql/toptenreasons.html

16th entry - Reason to use MySQL 1st part

There are quite some number of concrete reason to use MySQL as referring to MySQL AB (2007), as one of the database management application for businesses purposes. Below are the reason shown;

• Scalability and flexibility. Enable developer to have the flexibility to scale the application he/she desire for storing database warehouse in the servers.
• High performance. The MySQL database server allow developer to configure the desired capacity requirement server to enable to maximize the performance of the output.
• High availability. Provide the reliability and constant uptime availability through out the day, everyday, 24 hours a week.
• Robust transaction support. Provide multiple level of support for example transaction support, deadlock support, multi-version support, distributed transaction capability and to name a few.
• Web and data warehouse strength. Capable to withhold tremendous amount of data with reliable and high speed data transaction and processing without much difficulty.

Reference
MySQL AB (2007), "MySQL AB :: Top 10 Reasons to Use MySQL",
http://www.mysql.com/why-mysql/toptenreasons.html

15th entry - MySQL database

As discussed in the previous entry regarding SQL, it is a language that been used in the database management server systems. Thus MySQL is an open source database application for data management.

It is one of the popular database language for web application and database component for platform such as Linux, Mac, Windows, Apache, PHP, Perl, Python.

The business benefit referring from MySQL AB (2007), that uses MySQL are:

• Reducing the cost of database licensing costs over by 90%
• Prevent system downtime by more than 50% to 60%
• Reducing hardware spending
• Reducing administration cost
• Reducing engineering cost
• Reducing support cost
• Ease the management of database
• Improve network bandwidth transmission

Reference
MySQL AB (2007), "MySQL AB :: About MySQL AB",
http://www.mysql.com/company/

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

12th entry - NetBeans UML(UniField Modeling Language)

According to NetBeans (2007), it also provide feature such as object modeling diagram or UML. This will allow analyst and designer to able to design and plan for the application before entering into the coding stage for the application. With such features on NetBeans, developer able to make changes or update their UML and coding application in collaboration from the code generated from UML intergrated it with the application coding procedure. Below are some screen shot of the NetBeans UML Modelling.

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

11th entry - NetBeans for Web Application Development

According to the NetBeans(2007) also provide features for Web Application Development incorporate with Java Enterprise Edition (J2EE) that had been discussed in entry 8th regarding J2EE characteristic. NetBeans support the Sun Application, Weblogic 9 and JBoss 4. The J2EE version that are able to use with NetBeans are from J2EE version 1.3 to 1.5.

NetBeans IDE application tools are very useful for web application development because it able to support variety of other application beside discussed in paragraph above. Tools such as context help for HTML syntax, JSP syntax, visual editing for the web layout to be build, debugging tools and etceteras.

It also allow the developer to run or preview the layout of the web application being build in the web browser. Validation can take place by using J2EE Verifier with NetBeans IDE application to build a reliable web application without any certification difficulty.

Reference
NetBeans (2007), "NetBeans IDE Features", http://www.netbeans.org/products/ide/
features.html#Web_Application_Development_Java