United States : Microsoft preps SQL Server for battle in two enterprise arenas.Byline: Mamta03 New Intel suit could open doors for rivals AT&T's lawsuit over Verizon ads could backfire, some argue Three-year-old Office patch stymies most attacks Mozilla plans Firefox interface overhaul Cisco results top estimates Computerworld - Routinely accused of bloating bloating Vox populi A lay term for post-prandial abdominal fullness or swelling Windows and Office, Microsoft Corp. has acted more like a skinny teenage boy with enterprise apps like SQL Server An earlier relational DBMS from Sybase and from Microsoft. Sybase introduced SQL Server in 1988 for various Unix versions. In that same year, with help from IBM, Sybase created an OS/2 version that Microsoft licensed and branded as Microsoft SQL Server. : desperate to bulk up. King of the middleweight databases, SQL Server has yet to be fully accepted by the big boys, admits Bob Muglia, president of Microsoft's Server & Tools division. "Really large data warehouses and extremely large scale-up apps are the last high-end problems" remaining for SQL Server, Muglia said in a keynote at the Professional Association of SQL Server (PASS) users' conference in Seattle on Monday. A year ago, Microsoft announced plans to add heft to SQL Server. On Monday, it added some detail when it announced two new versions for when SQL Server 2008 R2 ships by the middle of next year. One is a Datacenter edition aimed at companies needing to scale-up their online transaction processing See transaction processing and OLCP. (OLTP (OnLine Transaction Processing) See transaction processing and OLCP. OLTP - On-Line Transaction Processing ). Used in conjunction with Windows Server 2008 R2, the Datacenter version can support up to 256 logical processors (physical CPUs multiplied by the number of threads they can support) and what Microsoft claims is "unlimited virtualization An umbrella term for enhancing a computer's ability to do work. Following are the ways virtualization is used. Hardware Virtualization Partitioning the computer's memory into separate and isolated "virtual machines" simulates multiple machines within one physical computer. ". It also supports complex event processing Complex Event Processing, or CEP, is a technology for building and managing event-driven information systems. CEP is primarily an event processing concept that deals with the task of processing multiple events from an event cloud with the goal of identifying the meaningful (CEP CEP congenital erythropoietic porphyria. CEP abbr. congenital erythropoietic porphyria ). The other is a new Parallel Data Warehouse version that can immediately support tens to hundreds of terabytes of data in clusters scaling out to about 24 nodes, according to senior vice-president, Ted Kummert. That still pales compared to companies like Teradata Corp., which released a 50-petabyte data warehousing appliance last fall. Today, Microsoft can only claim one SQL Server data warehouse in the petabyte One quadrillion bytes (one trillion kilobytes). Also PB, Pbyte and P-byte. See peta, binary values and space/time. (unit) petabyte - 2^50 = 1,125,899,906,842,624 bytes = 1024 terabytes or roughly 10^15 bytes. 1024 petabytes is one exabyte. range. But, said Kummert, "Our intent is to build data warehouses of all sizes, including well over 100TB." Future plans include enabling parallelized SQL Server data warehousing clusters of 100 nodes, according to Fausto Ibarra, director of product management, SQL Server, as well as working with partners to optimize SQL Server for servers using solid-state disks (SSDs) for storage. Along with increased capabilities comes an increase in price for SQL Server, though only slightly and only for some customers. Copyright : Euclid Infotech Pvt. Ltd. Provided by Syndigate.info an Albawaba.com company |
|
||||||||||||||
Printer friendly
Cite/link
Email
Feedback
Reader Opinion