Vs
.Net Analysis
A team of 2 developers rebuilt the “Sun Microsystems’ Java Pet Store J2EE BluePrint Application” using .Net in 4 weeks with 25% of the code. When tested in a lab, the .Net application ran %1000 faster than a tuned version of the Java application. The same Pet Store application was rebuilt by both Microsoft and Sun for an independent competition sponsored by The Middleware Company. Below is a comparison of the results:
.Net 1.1/Windows 2003 | J2EE/Windows 2000 | |
Lines of Code | 2,096 | 14,004 |
Time required for tuning and optimization prior to performance test | 2 man-weeks | 10 man-weeks |
Price/Performance Ratio – the cost per server divided by the maximum transactions per second the server could handle | $316 – in other words, for a Java application to handle the same amount of website traffic as a .Net application, and additional $989 would need to be spent on server hardware. | $1,305 |
Maximum Pages served per Second | 1,400 | 600 |
Maximum Number of Concurrent Users | 6,000 | 4,000 |
Maximum Number of Transactions per Second | 117 | 59 |
Test Notes: Each application was executed on identical Compaq Proliant servers; J2EE was tested on two Application Servers, one of which crashed midway and did not complete the test; J2EE used an Oracle 9i database while .Net used a SQL Server 2000 database; J2EE ran on Windows 2000 because it outperformed RedHat Linux 7.2 in a trial test. For the complete study, visit: http://www.middleware-company.com/documents/j2eedotnetbenchmark.pdf.
NET Vs Java Vs Cold Fusion MX Vs PHP
Feature | .Net | Java | Cold Fusion MX | PHP |
Compiled Code – Increases website speed (precompiled is the fastest) | Yes – both precompiled and dynamically compiled when a page is requested | Yes – both precompiled and dynamically compiled when a page is requested | Yes – dynamically compiled when a page is requested | No – a 3rd party accelerator can be used to increase performance but it is not installed on most shared hosting servers. |
Scripted Language – results in poor website performance | No | No | Somewhat | Yes – a 3rd party accelerator can be used to increase performance but it is not installed on most shared hosting servers. |
Object Oriented – Increases the ability for code reuse and provides enhanced features as well as reduced development time; since code is more reusable, results in fewer bugs that can be discovered by any client and fixed for everyone; encourages developers to write more maintainable code. | Yes | Yes | Somewhat | No |
Supported Development Languages – easier to find developers | C++, C#, Visual Basic.NET, Jscript.NET, Python, Perl, Java (J#), COBOL, Eiffel, Delphi – 25 languages supported currently | Java | CFML and CFScript | PHP |
Browser Specific HTML Rendering – different HTML is automatically sent to IE than to Netscape, reducing incompatibility issues | Yes | No | No | No |
Open Source | No | Yes | Somewhat | Yes |
Horizontal Vs Vertical portal (Vortals)
Two broad categorizations of portals are horizontal portals and vertical portals(vortal).
horizontal portals : cover many areas (another meaning: used as a platform to several companies in the same economic sector or to the same type of manufacturers or distributors.)
vertical portals : which are focused on one functional area(another meaning : a specialized entry point to a specific market or industry niche, subject area, or interest.
SQL 2005 Vs SQL 2008
This is NOT an exhaustive list but just representative list which are categorized for your references only.
SQL Server 2005 | SQL Server 2008 | |
Section | Product Features | Product Features |
Analysis Services | OLAP | Analysis Scale and Performance |
Data Mining | Block Computations | |
KPI Framework | Writeback | |
MDX | Scale-Out Analysis | |
Unified Dimensional Model | Sub-Space Computation | |
Proactive Caching | New Cube designer | |
BI Development Studio | ||
Translations | ||
Perspectives | ||
Real Time BI | ||
Hetegenerous Data Source Support | ||
Data Warehousing | Relational Data Warehouse | Backup Compression |
Multidimensional Data Warehouse | Partitioned Table Parallelism | |
Proactive Caching | Star Join Query Optimizations | |
Partitioning | Grouping Sets | |
Online Index Management | Change Data Capture | |
Partial Backup and Restore | MERGE SQL Statement | |
Management Studio | ||
Indexed Views | ||
Query Optimizations | ||
Optimized Statistics | ||
Star Join Optimizations | ||
Shared Scalable Databases | ||
High Availability | Database Mirroring | Enhanced Database Mirroring |
Failover Clustering | Automatic Recovery of Data Pages – Mirroring | |
Peer-to-Peer Transactional Replication | Log Stream Compression | |
Log Shipping | Peer-to-Peer – Conflict Resolution | |
Partial Database Availability | ||
Database Snapshots | ||
Online Operations | ||
Fast Database Recovery | ||
Partitioning | ||
Snapshot Isolation | ||
Online Operations | ||
Database Snapshots | ||
Checksum on Data Pages | ||
Instant File Initialization | ||
Checksum on Backups | ||
Piecemeal Restore | ||
Page-level Restore | ||
Dedicated Administrator Connection | ||
CPU Affinity | ||
AWE Memory | ||
Attach/Detach | ||
Backup Media Mirroring | ||
Integration Services | Merging Data from Heterogeneous Data Stores | Pipeline Improvements |
Populating Data Warehouses and Data Marts | Persistent Lookups | |
Cleaning and Standardizing Data | Lookup Caching | |
Building Business Intelligence into a Data Transformation Process | Performance Counters Import | |
Automating Administrative Functions and Data Loading | ||
Extensible, open APIs for integration with third party applications | ||
Manageability | Management Studio | Policy Based Management (PBM) |
Dynamic Management Views | Streamlined Installation | |
SQL Server Agent | Data Collector | |
SQL Management Objects | Server Group Management | |
Table and Index Partitioning | Multi-Server Query and Management | |
SQL Server Profiler | ||
Database Engine Tuning Advisor | ||
MOM Management Pack | ||
Best Practice Analyzer | ||
SQL Server Configuration Manager | ||
Copy Database Wizard | ||
Management Studio Standard Reports | ||
Management Studio Custom Reports | ||
MSX/TSX | ||
Surface Area Configuration | ||
Upgrade Advisor | ||
Database Maintenance Plan | ||
Database Mail | ||
Security configuration Manager | ||
Usage and Error Reporting | ||
Replication Monitor | ||
SQLCMD | ||
Programmability | Common Language Runtime (CLR) | Language Integrated Query (LINQ) |
XML and Web Services | ADO.Net Object Services | |
Enhanced Query and Data Access | DATE/TIME | |
Integrated VS Tools | HIERARCHY ID | |
Service Broker | FILESTREAM Data | |
Connectivity: ADO.NET | Integrated Full Text Search | |
Connectivity: JDBC | Sparse Columns | |
Connectivity: OLE DB | Large User Defined Types | |
Connectivity: ODBC | Spatial Data Types and Virtual Earth Integration | |
Technologies: LINQ | ||
SMO, AMO, NMO, RMO | ||
Reporting Services | Enterprise Managed Reporting Environment | Enterprise Reporting Engine |
Report Designer | Microsoft Office Integration | |
Report Manager | Manage Reporting Infrastructure | |
Model Designer | Report Builder Enhancements – New V2 version | |
Report Builder | Built-in Forms Authentication | |
BI development Studio | IIS Agnostic Report Deployment | |
Report Authoting | Word Rendering and Improved Excel Rendering | |
Report Management | Tablix Style Reports | |
Report Delivery | ||
Managed Reporting | ||
Ad-hoc Reporting | ||
Data Integration (SAP DW/Essbase/Oracle) | ||
Report Controls | ||
UDM support | ||
Scalability + Performance | Snapshot Isolation | Resource Governor |
Scalable Shared Database (DSS) | Predictable Query Performance | |
Query Notifications / CacheSync | Data Compression and Backup compression | |
Partitioning | Hot Add CPU | |
Extended Events | ||
Security | Surface Area Reduction | Transparent Data Encryption |
Off-By-Default | Extensible Key Management | |
Native Encryption | Auditing Framework | |
CLR Integration Security | Change Data Capture – Logging Infrastructure | |
Authentication | ||
Fine-Grained Access Control | ||
User and Schema Separation | ||
Execution Context |