GAE DataStore与适用于企业管理系统的Google Cloud SQL [英] GAE DataStore vs Google Cloud SQL for Enterprise Management Systems

问题描述

我正在构建一个使用gae的企业管理系统应用程序.我已经使用gae和数据存储构建了多个应用程序，但是从来没有一个应用程序需要大量用户输入交易以及管理和管理报告.我最大的担心是，当我需要创建交叉表和其他详细报告(或商业智能报告和数据处理)时，我将面临gae的数据存储区查询和数据提取限制的一系列问题.真的只是架构偏好，还是这里有数量方面的顾虑?

I am building an application that is an enterprise management system using gae. I have built several applications using gae and the datastore, but never one that will require a high volume of users entering transactions along with the need for administrative and management reporting. My biggest fear is that when I need to create cross-tab and other detailed reports (or business intelligence reporting and data manipulation) I will be facing a mountain of problems with gae's datastore querying and data pull limits. Is it really just architectural preference or are there quantitative concerns here?

过去，我已经针对Oracle/MySql/MSSql使用C ++/c#/Java构建了系统(并在其中添加了缓存层，以提高复杂或经常访问的数据库结果的性能)

In the past I have built systems using C++/c#/Java against an Oracle/MySql/MSSql (with a caching layer sprinkled in for some added performance on complex or frequently accessed db results).

我一直在阅读，我们将抛弃关系数据的旧思维，将新的世界转移到空中的大型McHashTable……但是新事物并不一定总会更好……对上述内容的任何见解或经验都会会有所帮助.

I keep reading that we are to throw away the old mentality of relational data and move to the new world of the big McHashTable in the sky... but new isnt always better... Any insight or experience on the above would be helpful.

推荐答案

来自 Cloud SQL常见问题解答:

我应该使用Google Cloud SQL还是App Engine数据存储区?

Should I use Google Cloud SQL or the App Engine Datastore?

这取决于应用程序的要求.数据存储区提供高度可扩展的NoSQL键值>存储，但不支持SQL数据库提供的复杂查询. Cloud SQL支持复杂的查询和ACID事务，但这意味着数据库充当固定管道"，并且性能可扩展性较差.许多应用程序同时使用两种类型的存储.

This depends on the requirements of the application. Datastore provides NoSQL key-value > storage that is highly scalable, but does not support the complex queries offered by a SQL database. Cloud SQL supports complex queries and ACID transactions, but this means the database acts as a ‘fixed pipe’ and performance is less scalable. Many applications use both types of storage.

如果您需要使用分布式密钥对数据库实体进行大量写入(〜XXX per/s)，那么Google App Engine数据存储区便是真正的亮点.

If you need a lot of writes (~XXX per/s) to db entity w/ distributed keys, that's where the Google App Engine datastore really shine.

如果您需要支持复杂的和随机的用户手工查询，那么Google Cloud SQL就更方便了.

If you need support for complex and random user crafted queries, that's where Google Cloud SQL is more convenient.

这篇关于GAE DataStore与适用于企业管理系统的Google Cloud SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！