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

来自女性百科
跳转至： 导航、 搜索
（新页面: SQL 2012 and Oracle are relational database management programs (RDBMS) built to present, organize, and store considerable amounts of data in tables. Customers must look into their organi...）
 
 
（未显示另一用户的1个中间版本）
第1行： 第1行：
−
SQL 2012 and Oracle are relational database management programs (RDBMS) built to present, organize, and store considerable amounts of data in tables. Customers must look into their organization's needs, active software infrastructure, and specialized expertise when evaluating both systems. Except for their handling of "Big Data," SQL 2012 and Oracle present comparable features, although the variety of Microsoft's Business Intelligence pc software will make it a far more attractive alternative for several users.Oracle's trump over past SQL incarnations was usually grounded in-the former's power to evaluate and store Big Data [http://www.lgnetworksinc.com/windows-server-2012-is-here/ Server 2012 Support]. Microsoft's response was to include Hadoop into SQL 2012, this provides you with SQL the ability to examine and coherently present overwhelming amounts of unrelated datasets. It should be observed, nevertheless, that Hadoop will not be accessible for SQL 2012 until mid-2012. It remains to be seen whether this integration will match consumer expectations for Big Data analysis. Until such time, Oracle has recently launched their Big Data Appliance featuring Hadoop and Cloudera; customers with the immediate need to review unstructured significant datasets during thousands of networked computers mightn't want to wait for Hadoop's incorporation into SQL 2012.One easy point to consider is the problem of the user's os. SQL 2012 runs only on PCs running Server 2008, Windows 7, or Vista. Oracle's supported techniques tend to be more versatile; these include Linux, Windows, Unix, OS/390, Mac OSX, and OpenVMS. This broad approach, while flexible, also possibly gift suggestions a far more convoluted installment method than the narrowly-focused SQL 2012.Microsoft's hegemony allows SQL 2012 consumers their overall Business Intelligence (BI) selection. SQL combines with SharePoint, PowerPivot, Excel, Analysis Services, Integration Services, Master Data Services, and others. As does the singularity in their os, the common usage of these resources makes finding on the web help not at all hard. Oracle Enterprise Edition (Oracle XE) presents equivalent performance, however if your company or consumer has already licensed much of Microsoft's BI pc software, they could balk at the cost of obtaining yet another license.Along with cost, people should consider the variety and setting of probable use whenever choosing between the two programs. SQL 2012 requires licensing fees on a "per-core" basis. Oracle supplies a free version of Oracle XE with a few caveats. These restrictions include a 4 GB issue on stored data, a 1 GB cover on Random Access Memory application, and the variation won't use more than on Central Processing Unit, even though the host device contains more. The edition of Oracle XE also bases its price about the "per-core" structure.Users should think about their os, budget, present BI infrastructure, and Big Data needs before investing either SQL 2012 or Oracle. From the performance point of view, many users will discover either to be satisfactory for their Business Intelligence needs if Microsoft properly combines Hadoop into SQL 2012.
+
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”