But yeah
it is debatable on how much moderization we take.
With Cloudspanner ( require less modernisation compared to Datastore)
With Cloud SQL ( Require less modernisation compared to Datastore)
With datastore - Best solution eventually - but the most tricky migration and modernisation.
very subjective question
Technical Requirements
• Assess key application for cloud suitability.
• Modify application for the cloud. **(Which means possible to change the code or database when it migrate to GCP
)
D is ok
https://cloud.google.com/datastore/docs/concepts/overview
Datastore is ideal for applications that rely on highly available structured data at scale. You can use Datastore to store and query all of the following types of data:
Product catalogs that provide real-time inventory and product details for a retailer.
User profiles that deliver a customized experience based on the user’s past activities and preferences.
Transactions based on ACID properties, for example, transferring funds from one bank account to another.
The requirement is Global and also they nedd relational database which cloud datstore doesn't allow and bigquery is datawarehouse and for analysis and cloud sql support upto 30 TB relational database.So A should be correct.
Since it is relational data, it should be A or C.
Cloud SQL is the only that supports the Oracle SQL features, like Procedures and triggers, etc. I also think Cloud Spanner seems to be an overkill since it is a 20TB database, which Cloud SQL easily handles
IMO, C is the cheapest and easiest, while A would require some refactorings and longer migration, which doesnt pay off for the current database's size
A: Spanner retains the RDBMS compatibility and helps to reduce latency for any Asia resources
B: BigQuery no good for OLTP
C: CloudSQL, the closest option we have to Oracle
D: Significant architectural change but potentially a great alternative to RDBMS, document database typically a good fit for user data & as others have said it can eliminate the complex RDBMS structure and queries
The problem I have with Spanner is the cost, it is extremely expensive compared to the other options, so is it really needed?
But when I review the requierments I don't see cost as being up there whilst latency to Asia it is, so whilst I intuitively picked Datastore I'll revise to Spanner.
Cloud Spanner is a fully managed, scalable, and globally distributed relational database service. It provides strong consistency, high availability, and low-latency capabilities, which would be suitable for JencoMart's User Profiles database requirements.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
JJu
Highly Voted 4 years, 8 months agoIshu_awsguy
1 year, 11 months agoIshu_awsguy
1 year, 11 months agovvillar
3 years, 3 months agodabrat
Highly Voted 4 years, 8 months agoVishalB
3 years agonitinz
3 years, 5 months agoDrLu
4 years, 8 months agotartar
3 years, 12 months agomasterchief735
Most Recent 2 weeks, 3 days agodecw
7 months, 1 week agoMahAli
7 months, 4 weeks agoJannchie
8 months agothewalker
8 months, 1 week agocchiaramelli
9 months, 1 week agodman69
1 year, 1 month agodman69
1 year, 1 month agoBiddlyBdoyng
1 year, 1 month agoBiddlyBdoyng
1 year, 1 month agoTheCloudGuruu
1 year, 2 months agogeekgirl007
1 year, 3 months agotaer
1 year, 4 months agoHD2023
1 year, 4 months agoDeb2293
1 year, 4 months ago