Resumo de Php, Aspand Sql

A 3D Interactive
E-Commerce Website

Comparing PHP with the server-side technology
PHP is a scripting language based on the model of pre-processing HTML pages. When the PHP pre-processor in your Web server notices a PHP language tag, the PHP engine is invoked to execute that code. PHP will be familiar to any programmers who have worked with imperative programming languages; you'll notice syntactical similarities with Perl, C, and Java. Strictly speaking, Java is an imperative programming language, but it also makes use of object-oriented constructs and concepts. PHP borrows from this structure when it is convenient, but it is not a pure OOP language.
PHP has a few shortcomings, including its lack of exceptions, event-based error-handling instances that interrupt the normal flow of a program, jumping your code to a special error-handling section. Java also provides exceptions for error handling, while C++ provides exception handling via the try, catch, and throw syntax. You can, of course, still manage errors in PHP, but the structure is not standardized, so programmers are left to their own devices on how to implement error handling, leading to less consistency and a tendency to reinvent the wheel.
Another weakness is that PHP's function names are case insensitive. Some programmers might find this feature annoying, though this isn't a serious drawback.
PHP wasn't designed to be an object-oriented language. Some of those features were added later, although care was made to keep backward compatibility with PHP 3, so you're left with a bit of both models. In fact, many of these weaknesses are addressed in PHP 5.
What PHP lacks in a few areas, it makes up for by leaps and bounds in areas in which it excels. The price is right, so you don't have to worry about licensing issues. It's open source, too, so an entire community will keep a close eye on development, identifying bugs and making sure they get fixed. And if there's a feature you don't like, you can dabble with the code. What's more, PHP works native with Apache: It can be compiled as a module or directly into the Apache binary.
The latest incarnation of ASP, ASP.NET, is not completely backward compatible with previous versions of ASP, as it is a complete rewrite of the software. ASP.NET works with scripted languages such as VBScript, JScript, Perl script, and Python, as well as compiled languages such as VB, C#, C, Cobol, Smalltalk, and Lisp. The framework also provides for true object-oriented programming (OOP), and true inheritance, polymorphism, and encapsulation are supported.
ASP.Net?s strength lies clearly in its clean design and implementation. It is an object-oriented programmer's dream, with language flexibility, and with sophisticated object-oriented features supported. In that sense, it is truly interoperable with your programmers' existing skills. Another strength of ASP.NET is the development environment. For instance, developers can use Web Matrix, a community-supported tool, Visual Studio .NET, or various Borland tools such as Delphi and C++ Builder. Visual Studio, for instance, allows setting of breakpoints, tracing sections of code, and reviewing the call stack. All in all, it's a sophisticated debugging environment. Plenty of other third-party IDE solutions for ASP.NET are certain to surface as well.

Comparing SQL with the web database technology
Single platform dependency.
SQL server is only operable on the Windows platform, and this is a major limitation for it to be an enterprise solution. Oracle is available on multiple platforms such as Windows, all flavours of Unix from vendors such as IBM, Sun, Digital, HP, Sequent, Linux etc. and VAX-VMS as well as MVS. The multi-platform nature of Oracle makes it a true enterprise solution.
2. Locking / concurrency
SQL server has no multi-version consistency model, which means that writers? block readers and reader?s block writers to ensure data integrity. In contrast, with Oracle the rule is readers don?t block writers and writers don?t block readers. This is possible without compromising data integrity because Oracle will dynamically re-create a read-consistent image for a reader of any requested data that has been changed but not yet committed. In other words, the reader will see the data as it was before the writer began changing it (until the writer commits).
3. PROGRAMMING
a. Significant extensions to the ANSI SQL-92 standard in SQL server, which means converting applications to a different database later, will be a challenge (code re-write).
b. SQL Server has no inbuilt JAVA database engine as in Oracle. In Oracle, Java classes can be loaded and executed in the database itself, thus adding the database security and scalability to Java applications.
4. STANDBY DIFFERENCES
SQL server and Oracle have differences regarding standby databases. A standby is a database set up on a second server and to which logs are applied i.e. all database changes, so that the standby can be activated and used in the case of a fail over.
In the case of SQL server, when there is a fail over, the master and MS db databases have to be restored from backup or copied over from the primary to the standby and then the standby is activated after all logs are applied. In Oracle, there is no need for a restore to be done.

Reference
JQ Johnson. (2001). Choosing a Dynamic Web Publishing Environment.
Oregon: University of Oregon Library. Retrieved January 4, 2006,
from, http://darkwing.uoregon.edu/~jqj/presentations/cit382-2-13-01.ppt.

Resumos Relacionados