Os Cloud Vendors garantem as propriedades do ACID enquanto oferecem serviços de Banco de Dados Relacional?

1

As propriedades do ACID são importantes para os aplicativos RDMS. Há muitos serviços de bancos de dados relacionais oferecidos pelos provedores de nuvem, como o AMAZON RDS e o Microsoft SQL Azure.

Estou curioso sobre se as propriedades do ACID são fornecidas ou não?

obrigado.

    
por Berkay 02.05.2010 / 03:17

3 respostas

1

Na verdade eu li um bom trabalho que fala sobre a minha pergunta, eu queria postar aqui para outros usuários. DAVID CHAPPELL OUTUBRO 2008, INTRODUZINDO A PLATAFORMA DE SERVIÇOS AZURE UM OLHAR ANTECIPADO NO WINDOWS AZURE, SERVIÇOS .NET, SERVIÇOS SQL E SERVIÇOS VIVOS

SQL Data Services, formerly known as SQL Server Data Services, provides a database in the cloud. As the figure suggests, this technology lets on-premises and cloud applications store and access data on Microsoft servers in Microsoft data centers. As with other cloud technologies, an organization pays only for what it uses, increasing and decreasing usage (and cost) as the organization’s needs change. Using a cloud database also allows converting what would be capital expenses, such as investments in disks and database management systems (DBMSs), into operating expenses. A primary goal of SQL Data Services is to be broadly accessible. Toward this end, it exposes both SOAP and RESTful interfaces, allowing its data to be accessed in various ways. And because this data is exposed through standard protocols, SQL Data Services can be used by applications on any kind of system—it’s not a Windows-only technology. Unlike the Windows Azure storage service, SQL Data Services is built on Microsoft SQL Server. Nonetheless, the service does not expose a traditional relational interface. Instead, SQL Data Services provides a hierarchical data model that doesn’t require a pre-defined schema. Each data item stored in this service is kept as a property with its own name, type, and value. To query this data, applications can use direct RESTful access or a language based on the C# syntax defined by Microsoft’s Language Integrated Query (LINQ).

There’s an obvious question here: Why not just offer SQL Server in the cloud? Why instead provide a cloud database service that uses an approach different from what most of us already know? One answer is that providing this slightly different set of services offers some advantages. SQL Data Services can provide better scalability, availability, and reliability than is possible by just running a relational DBMS in the cloud.

The way it organizes and retrieves data makes replication and load balancing easier and faster than with a traditional relational approach. Another advantage is that SQL Data Services doesn’t require customers to manage their own DBMS. Rather than worry about the mechanics, such as monitoring disk usage, servicing log files, and determining how many instances are required, a SQL Data Services customer can focus on what’s important: the data. And finally, Microsoft has announced plans to add more relational features to SQL Data Services. Expect its functionality to grow.

    
por 03.05.2010 / 10:10
1

O AWS RDS parece ser baseado no mysql 5.1, e o SQL Azure é baseado no SQL Server. Ambas as plataformas são compatíveis com ACID, parece uma boa aposta que o RDS / SQL Azure também.

    
por 02.05.2010 / 07:01
1

Essas ofertas são escalonáveis não em virtude da arquitetura (como a maioria das lojas de chave / valor); mas simplesmente porque eles podem oferecer grandes servidores se você pagar por eles, e eu acho que ambos têm uma instalação bem ajustada e uma equipe experiente para mantê-los funcionando.

Como Tony disse , eles são baseados em servidores SQL tradicionais (MySQL e MSSQLServer, respectivamente), não se engane, este é um software real e pode realmente ser entregue quando devidamente ajustado no hardware apropriado.

    
por 02.05.2010 / 07:18