PHP MySQL Database Scripts – Generate Online

PHP (it originally was abbreviation of  for Personal Home Page) was first written by Rasmus Lerdorf . These were Perl scripts to track users of his Web pages. On communication and suggestions from other people he rewrote it as a scripting language and added support for forms. As its popularity grew, a core group of developers created an API for it and turned it into PHP3. Presently we have version 5. (PHP5) and its growth is likely to continue.

Plus Points of PHP.
PHP will run on all platform, including most UNIXs, Windows(95/98/NT/2000) and Macs. As this uses the same code base, all scripts will run identically on all the platforms.
PHP is similar to C. So anyone who has experience with a C-style language will easily learnd PHP. In C-style languages we can also include Javascript and Java. In fact, much of PHP’s functionality is provided by wrappers around the underlying system calls (such as fread() and strlen()) so C programmers will immediately feel at home.
PHP is extendible. This allows programmers two ways of extending PHP to do some special processing, either by writing an extension module and compiling it into the executable, or by creating an executable that can be loaded using PHP’s dynamic loading mechanism.
PHP currently will load into Apache, IIS, AOLServer, Roxen and THTTPD. Alternatively, it can be run as a CGI module.
Lots of database interfaces. PHP currently will work with MySQL, MS SQL, Oracle, Informix, PostgreSQL and many others. These are binary level interfaces, and ODBC is also provided for those situations where the database is not supported.
If a PHP user wants to interface to particular library, then it is easy to write an interface for it, and many have done so, and contributed to the main PHP source repository. So you can find modules for graphics routines, PDF files, Flash movies, Cybercash, calendars, XML, IMAP, POP and a host of others. If the library you need is not supported, you can either write one yourself, or employ your favourite programmer to do it.
PEAR. The PHP Extension and Add-on Repository. Similar to the CPAN network for Perl, although still in its infancy, the idea of PEAR is to provide a set of PHP scripts that would be installed by default with the PHP installation
Fast. PHP is normally used an Apache module and this makes it very fast. It is entirely written in C and is quite small, so loads and executes quickly with small memory footprint.
PHP is Open Source. Therefore programmers are not dependent on a particular manufacturer to fix things that don’t work.

What are the main disadvantages of PHP?
A scripting language has advantages and disadvantages. PHP also has some disadvantages. Some are direct disadvantages and some are indirect regarding functionality. PHP’s main drawback is Error Handling. PHP has a very poor ability in this regard, but even this disadvantage can be over come using a feasible advantage solution.

Why are we still pushing Semantic Web ?

SuccessesThis was the question a panelist asked at the W3C Advisory Committee meeting that I attending at the beginning of December 2004. In other words, the panelist and others discussing this question were wondering, why is it taking so long for the industry to get it (its importance)? Or that, by now, we would have expected it to have seen much wider adoption, a clear indication that the Semantic Web is here for good, transforming the Web into its next logical incarnation.

The essence of my comment at that time was that the rate of progress is quite robust and pervasive, and there are prominent signs that the Semantic Web is not just a fad, that this time, semantics as applied to information (which predates the Semantic Web as defined today) is indeed likely to affect many businesses in not-too-distant a future, and even common Web user in intermediate future. Here is an extended perspective on the adoption of the Semantic Web, which also incorporates a nice dinner discussion that some of the Semantic Web technology/product vendors (who are members of the W3C) had with the W3C Semantic Web team members (Eric Miller and others).

Research

Although funding from NSF, DARPA and the premier funding agencies have now waned, DAML program gave excellent and timely start to the Semantic Web research in the US. The funding initiative moved to Europe with Framework V, and is firmly entrenched with Framework VI. The number of new conferences, conference attendance, sessions related to the Semantic Web in older and more established conferences, number of published papers and new scientific journals devoted to the Semantic Web (such as Web Semantics, Semantic Web & Information Systems, and Applied Ontology) all point to broad and increasingly entrenched interest in this new area.

Standards

One of the nicest things that have happened to our area is timely standards activity. Note the emphasis on “timely”, as it is helpful to have basic standards before the area matures and before industry interest peaks, reducing the chances of clashes between the entrenched interests. Not having activities being taken to competing standards bodies, as is the case in Web Services area, helps too.

Technology and Products

One of the most exciting things to have happened in our area is the number of technologies commercialized from academic research (Taalee’s MediaAnywhere A/V Semantic Search and Semagix’s Freedom from University of Georgia’s SCORE technology, Network Inference’s relationship with University of Manchester, Ontoprise’s relationship with Karlsruhe, to name a few). Now, at least twenty vendors claim to use or support Semantic Web technologies, and the list is growing quite rapidly. And perhaps most importantly, scientific and business communities are building targeted (i.e., with clear purpose) and large ontologies at an impressive pace.

Industry Recognition

The informative panel at the W3C 10th anniversary celebrations (http://www.w3.org/2004/09/W3C10-Program.html) on the “Web of Meaning” illustrated how the thought leaders and industry executives buy into the vision of the Semantic Web. Panelists Tim O’Reilly (O’Reilly Media, talk) and Bill Ruh (Cisco Systems, talk) presented a fairly encouraging perspective on how Semantic (Web) technologies are needed for key applications, such as Regulatory Compliance, B2B Exchange, Workflow and BPM, and Business Intelligence. What is interesting is that some of these are “selling aspirin” rather than “selling vitamins”, something that does better in low to moderate economic growth environments.

I would add several other fields of rapid adoption, including life sciences (see the W3c workshop in Semantic Web for Life Sciences), bioinformatics, healthcare, content management, national intelligence and homeland security. Just look at the number of large ontologies that cover the broad range of schema size, descriptionbases (instances) and expressiveness of representation, developed by community or a small number of domain experts, that are now being put to practical use. Some illustrious examples are NCI Cancer Ontology with over 17,000 concepts, or GlycO ontology for complex Carbohydrates with 767 Classes that is up to 11 levels deep and utilizes all expressive power of OWL, or ontologies with over 10 million instances developed for enterprise semantic applications using Semagix Freedom. Researchers interested in finding ontoloiges to play with can consider TAP or SWETO that are based on real-world facts, or get their hands on software to generate synthetically generated ontologies.

At the industry events, such as those organized by TopQuadrant and MITRE, or the user group initiated events, such as those for the US Department of Defense or the Life Science Community, 100 to 300+ people have shown up, which indicated fairly high level of industry and user group interest.

Industry Deployment and Early Successes

Since some very early deployment examples that were discussed at the WWW2004 Developer’s day, there are now increasing number of examples of deployments both in Enterprises (e.g., see my KMWorld talk) or for more ‘common’ web users. It is this topic what garnered the main attention during our dinner discussions (mentioned above). One exciting observation that came up is the stealth inclusion of the Semantic Web technologies in applications. Eric Miller gave the example of Creative Common’s use of RDF (also see Shelly Parker’s earlier article). This is an example of simpler SW applications involving embedding license metadata and validating it so millions of content items would in essence be using at least limited Semantic Web technology for enforcing licenses! Another example is that of semantic annotation of syndicated contents and Web Services (e.g., the WSDL-S semantic proposal (early draft, currently being revised in an academic-industry partnership) and corresponding tools (e.g., MWSAF and ASSAM) for annotation of Web Services). Such applications can quickly lead to a wide spread and pervasive use of RDF in a fairly short time. What is interesting is that some of the applications are not being deployed by early adoptors; instead the SW technologies have been part of the pain killer types of main-stream IT applications and solutions (such as Anti-Money Laundering, compliance and risk management)! Enecdotal successes are starting to come. For example, a compliance related semantic application(implemented with a semantic technology platform from Semagix) is live at one of the largest banks in the world in the line of business. And I have heard of companies such as Amazon inserting ontologies in their main stream applications, so we can expect to see large scale consumer centric applications exploiting essential components of Semantic Web in the near future.

Final thoughts

One perspective that some in the community, particularly Tim Berners-Lee-TBL, seem to promote it that Semantic Web is “not interesting in the smaller scale”. As more and more things connected by a “semantic way” it becomes more and more important. This makes sense from the perspective of global scale Web and non-enterprise applications. But from an industry perspective, I believe Semantic Web is equally interesting at the intra- and inter-Enterprise scales, and for Enterprise applications. This view is the same as the adoption and importance of Web technologies in Intranets. If at all, given the ability to constrain or limit the domain, deeper domain semantics can be put to use, agreements to build ontologies can be reached faster, industry specific metadata standards can be readily used, and facts and knowledge to populate ontologies can be obtained more easily. Today’s enterprises have millions of documents, and access to massive amounts of high-quality or targeted syndicated contents and data (e.g., through Lexis-Nexis, ChoicePoint, NewsML and RSS News Feeds, and so on). The ontologies developed to support targeted enterprise scale Semantic Applications are currently exploiting ontologies with millions to tens of millions entity and relationship instances. And yes, the promise of scaling these Enterprise and industry scale islands by interconnecting them (and achieve what TBL called network effect) exists anyways.