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

来自女性百科
跳转至： 导航、 搜索
 
第1行： 第1行：
−
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 [http://www.lgnetworksinc.com/it-outsourcing/microsoft-system-center-configuration-manager/ 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.
+
SQL 2012 and Oracle are relational database management techniques (RDBMS) built to present, arrange, and store large amounts of information in tables. People must look into their organization's needs, existing application structure, and specialized expertise when considering the two tools. Except for their managing of "Big Data," SQL 2012 and Oracle present related features, although the preponderance of Microsoft's Business Intelligence application will make it an even more appealing alternative for several users.Oracle's trump over previous SQL incarnations was generally rooted in the former's ability to evaluate and store Big Data [http://www.lgnetworksinc.com/windows-server-2012-features-what-to-expect/ Microsoft Server 2012]. Microsoft's reaction was to incorporate Hadoop in to SQL 2012, this provides SQL the capability to study and coherently existing overwhelming amounts of unrelated datasets. It ought to be noted, however, that Hadoop will not be available for SQL 2012 until mid-2012. It remains to be seen whether this incorporation may meet consumer expectations for Big Data analysis. Until such time, Oracle has produced their Big Data Appliance presenting Hadoop and Cloudera; users with the immediate need to review unstructured significant datasets through the duration of hundreds of networked computers mightn't want to watch for Hadoop's integration into SQL 2012.One simple point out consider is the problem of the user's operating system. SQL 2012 works only on PCs managing Server 2008, Windows 7, or Vista. Oracle's supported systems tend to be more versatile; these include Linux, Windows, Unix, OS/390, Mac OSX, and OpenVMS. This broad strategy, while variable, also probably presents an even more complicated installation procedure than the narrowly-focused SQL 2012.Microsoft's hegemony allows SQL 2012 users their entire Business Intelligence (BI) room. SQL integrates with SharePoint, PowerPivot, Excel, Analysis Services, Integration Services, Master Data Services, and others. The common utilization of these methods makes discovering online support relatively simple, as does the singularity of their operating system. Oracle Enterprise Edition (Oracle XE) gives comparable efficiency, nevertheless if a organization or person has already certified a lot of Microsoft's BI pc software, they might balk at the cost of obtaining another license.Along with cost, users should consider the typ-e and range of likely use when selecting between the two programs. Over a "per-core" foundation sql 2012 needs licensing fees. Oracle offers a free version of Oracle XE with a few caveats. These constraints incorporate a 4 GB limit on stored data, a 1 GB cap on Random Access Memory application, and the free edition won't use more than on Central Processing Unit, even if the host machine contains more. The accredited version of Oracle XE also bases its cost about the "per-core" structure.Users should think about their operating system, budget, present BI structure, and Big Data requirements before investing in either SQL 2012 or Oracle. From a efficiency standpoint, if hadoop is successfully integrated by Microsoft into SQL 2012 most customers will discover often to become adequate for his or her Business Intelligence needs.

2013年5月21日 (二) 17:37的最新版本

SQL 2012 and Oracle are relational database management techniques (RDBMS) built to present, arrange, and store large amounts of information in tables. People must look into their organization's needs, existing application structure, and specialized expertise when considering the two tools. Except for their managing of "Big Data," SQL 2012 and Oracle present related features, although the preponderance of Microsoft's Business Intelligence application will make it an even more appealing alternative for several users.Oracle's trump over previous SQL incarnations was generally rooted in the former's ability to evaluate and store Big Data Microsoft Server 2012. Microsoft's reaction was to incorporate Hadoop in to SQL 2012, this provides SQL the capability to study and coherently existing overwhelming amounts of unrelated datasets. It ought to be noted, however, that Hadoop will not be available for SQL 2012 until mid-2012. It remains to be seen whether this incorporation may meet consumer expectations for Big Data analysis. Until such time, Oracle has produced their Big Data Appliance presenting Hadoop and Cloudera; users with the immediate need to review unstructured significant datasets through the duration of hundreds of networked computers mightn't want to watch for Hadoop's integration into SQL 2012.One simple point out consider is the problem of the user's operating system. SQL 2012 works only on PCs managing Server 2008, Windows 7, or Vista. Oracle's supported systems tend to be more versatile; these include Linux, Windows, Unix, OS/390, Mac OSX, and OpenVMS. This broad strategy, while variable, also probably presents an even more complicated installation procedure than the narrowly-focused SQL 2012.Microsoft's hegemony allows SQL 2012 users their entire Business Intelligence (BI) room. SQL integrates with SharePoint, PowerPivot, Excel, Analysis Services, Integration Services, Master Data Services, and others. The common utilization of these methods makes discovering online support relatively simple, as does the singularity of their operating system. Oracle Enterprise Edition (Oracle XE) gives comparable efficiency, nevertheless if a organization or person has already certified a lot of Microsoft's BI pc software, they might balk at the cost of obtaining another license.Along with cost, users should consider the typ-e and range of likely use when selecting between the two programs. Over a "per-core" foundation sql 2012 needs licensing fees. Oracle offers a free version of Oracle XE with a few caveats. These constraints incorporate a 4 GB limit on stored data, a 1 GB cap on Random Access Memory application, and the free edition won't use more than on Central Processing Unit, even if the host machine contains more. The accredited version of Oracle XE also bases its cost about the "per-core" structure.Users should think about their operating system, budget, present BI structure, and Big Data requirements before investing in either SQL 2012 or Oracle. From a efficiency standpoint, if hadoop is successfully integrated by Microsoft into SQL 2012 most customers will discover often to become adequate for his or her Business Intelligence needs.

取自“https://www.8beauty.com/wiki/index.php?title=Microsoft_SQL_Server_2012_Versus_Oracle&oldid=68834”