“Microsoft SQL Server 2012 Versus Oracle”的版本间的差异

2013年5月12日 (日) 17:10的版本

Oracle and sql 2012 are relational database management programs (RDBMS) made to organize, store, and present considerable amounts of information in tables. People should think about their organization's needs, active application infrastructure, and specialized knowledge when considering both tools. Except for their managing of "Big Data," SQL 2012 and Oracle offer equivalent functions, although the variety of Microsoft's Business Intelligence pc software could make it a more desirable alternative for many users.Oracle's trump over past SQL incarnations was often seated in the former's power to analyze and store Big Data. Microsoft's reaction was to include Hadoop in to SQL 2012, this provides you with SQL the capacity to study and coherently present overwhelming amounts of unrelated datasets. It ought to be noted, however, that Hadoop will not be around for SQL 2012 until mid-2012. It remains to be viewed whether this integration will match user expectations for Big Data analysis. Until such time, Oracle has released their Big Data Appliance featuring Hadoop and Cloudera; customers with the immediate must examine unstructured enormous datasets for the duration of thousands of networked computers might not desire to watch for Hadoop's integration into SQL 2012.One simple point to consider is the issue of the user's operating-system. SQL 2012 runs only on PCs operating Server 2008, Windows 7, or Vista. Oracle's recognized programs tend to be more versatile; these generally include Linux, Windows, Unix, OS/390, Mac OSX, and OpenVMS. This broad strategy, while flexible, also potentially presents an even more complicated installation procedure as opposed to narrowly-focused SQL 2012.Microsoft's hegemony allows SQL 2012 people their overall Business Intelligence (BI) package. SQL integrates with SharePoint, PowerPivot, Excel, Analysis Services, Integration Services, Master Data Services, and others. As does the singularity in their operating system, the widespread use of these methods makes finding on line support relatively simple. Oracle Enterprise Edition (Oracle XE) presents identical performance, though if your organization or individual has licensed a lot of Microsoft's BI computer software, they may balk at the cost of acquiring yet another license.Along with cost, users must consider the variety and scope of probable use whenever choosing between the two platforms. On the "per-core" basis sql 2012 demands licensing fees. Oracle supplies a free version of Oracle XE with a few caveats. These limitations incorporate a 4 GB limit on stored knowledge, a 1 GB hat on Random Access Memory usage, and the version won't use more than on Central Processing Unit, even though the host machine contains more. The qualified version of Oracle XE also bases its charge about the "per-core" structure Microsoft System Center.Users should consider their operating system, budget, current BI infrastructure, and Big Data needs before committing to either SQL 2012 or Oracle. From the functionality standpoint, if Microsoft efficiently integrates Hadoop into SQL 2012 many consumers will see either to be adequate for his or her Business Intelligence requirements.