{"id":1085,"date":"2020-12-09T17:31:38","date_gmt":"2020-12-09T10:31:38","guid":{"rendered":"https:\/\/vticloud.io\/?p=1085"},"modified":"2021-09-20T09:34:15","modified_gmt":"2021-09-20T02:34:15","slug":"babelfish-cho-postgresql-buoc-ngoat-lon-cua-co-so-du-lieu","status":"publish","type":"post","link":"https:\/\/vticloud.io\/en\/babelfish-cho-postgresql-buoc-ngoat-lon-cua-co-so-du-lieu\/","title":{"rendered":"Babelfish cho PostgreSQL – B\u01b0\u1edbc ngo\u1eb7t l\u1edbn c\u1ee7a c\u01a1 s\u1edf d\u1eef li\u1ec7u"},"content":{"rendered":"

<\/p>\n

Ng\u00e0y 01\/12 v\u1eeba qua, trong chu\u1ed7i s\u1ef1 ki\u1ec7n re:Invent 2020<\/a><\/span><\/strong><\/em><\/span>, Amazon Web Services \u0111\u00e3 th\u00f4ng b\u00e1o v\u1ec1 vi\u1ec7c s\u1ebd cung c\u1ea5p m\u00e3 ngu\u1ed3n m\u1edf cho “Babelfish cho PostgreSQL” trong Qu\u00fd I-2021 d\u01b0\u1edbi Apache License 2.0. Trong b\u00e0i ph\u00e1t bi\u1ec3u gi\u1edbi thi\u1ec7u v\u1ec1 Babelfish cho PostgreSQL, Andy Jassy – CEO c\u1ee7a Amazon Web Services c\u0169ng tuy\u00ean b\u1ed1 th\u1eb3ng th\u1eebng v\u1ec1 \u00fd \u0111\u1ecbnh c\u1ee7a AWS: “H\u00e3y ng\u1eebng chi tr\u1ea3 chi ph\u00ed license kh\u00f4ng c\u1ea7n thi\u1ebft cho SQL server”.<\/p>\n

Babelfish cho PostgreSQL l\u00e0 d\u1ecbch v\u1ee5 cho ph\u00e9p c\u01a1 s\u1edf d\u1eef li\u1ec7u PostgreSQL (database) request v\u00e0 giao ti\u1ebfp m\u00e0 kh\u00f4ng c\u1ea7n ghi l\u1ea1i ho\u1eb7c \u0111i\u1ec1u ch\u1ec9nh SQL schema.<\/p>\n

V\u1edbi nh\u1eefng ng\u01b0\u1eddi l\u00e0m vi\u1ec7c v\u1edbi c\u01a1 s\u1edf d\u1eef li\u1ec7u, \u0111\u00e2y l\u00e0 m\u1ed9t b\u01b0\u1edbc ngo\u1eb7t l\u1edbn v\u00e0 l\u00e0 \u0111\u1ed9ng th\u00e1i r\u00f5 r\u00e0ng c\u1ee7a Amazon \u0111\u1ec3 gi\u00fap vi\u1ec7c d\u1ecbch chuy\u1ec3n kh\u1ecfi SQL Server. Vi\u1ec7c chuy\u1ec3n d\u1ecbch sang PostgreSQL s\u1ebd tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n bao gi\u1edd h\u1ebft. \u0110\u00e2y c\u0169ng l\u00e0 m\u1ed9t \u0111\u00f2n c\u1ee7a Amazon Web Service h\u01b0\u1edbng v\u00e0o \u0111\u1ed1i th\u1ee7 Microsoft trong n\u1ed7 l\u1ef1c th\u00fac \u0111\u1ea9y vi\u1ec7c d\u1ecbch chuy\u1ec3n c\u01a1 s\u1edf d\u1eef li\u1ec7u (database) ra kh\u1ecfi Microsoft.<\/p>\n

Trong nhi\u1ec1u qu\u00e1 kh\u1ee9 \u0111\u00e3 c\u00f3 nhi\u1ec1u n\u1ed7 l\u1ef1c \u0111\u1ec3 th\u00fac \u0111\u1ea9y vi\u1ec7c d\u1ecbch chuy\u1ec3n c\u01a1 s\u1edf d\u1eef li\u1ec7u, tuy nhi\u00ean ph\u1ea7n l\u1edbn \u0111\u1ec1u \u0111i v\u00e0o ng\u00f5 c\u1ee5t. Ch\u01b0a th\u1ef1c s\u1ef1 c\u00f3 m\u1ed9t \u0111\u00f2n b\u1ea9y n\u00e0o \u0111\u1ee7 l\u1edbn \u0111\u1ec3 th\u00fac \u0111\u1ea9y vi\u1ec7c d\u1ecbch chuy\u1ec3n c\u01a1 s\u1edf d\u1eef li\u1ec7u b\u1edfi m\u1ee9c \u0111\u1ed9 r\u1ee7i ro cao, v\u00e0 vi\u1ec7c d\u1ecbch chuy\u1ec3n kh\u00f4ng th\u1ec3 cam k\u1ebft v\u1ec1 kh\u1ea3 n\u0103ng ho\u1ea1t \u0111\u1ed9ng, hi\u1ec7u n\u0103ng c\u0169ng nh\u01b0 \u0111\u1ea3m b\u1ea3o vi\u1ec7c ti\u1ebft ki\u1ec7m chi ph\u00ed cho danh nghi\u1ec7p.<\/p>\n

T\u1ea1i sao l\u1ea1i l\u00e0 PostgreSQL?<\/strong><\/h2>\n

V\u1eady \u0111i\u1ec1u g\u00ec l\u00e0m cho Babelfish cho PostgreSQL kh\u00e1c bi\u1ec7t?<\/p>\n

\u0110i\u1ec1u \u0111\u1ea7u ti\u00ean ph\u1ea3i k\u1ec3 \u0111\u1ebfn ch\u00ednh l\u00e0 vi\u1ec7c PostgreSQL linh ho\u1ea1t h\u01a1n nh\u1eefng c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u00f3 quan h\u1ec7 (relational databases) trong vi\u1ec7c qu\u1ea3n l\u00fd d\u1eef li\u1ec7u v\u1ec1 \u0111\u1ecba l\u00fd v\u00e0 hi\u1ec7n \u0111ang tr\u1edf n\u00ean kh\u00e1 ph\u1ed5 bi\u1ebfn.<\/p>\n

Th\u1ee9 hai, PostgresSQL hi\u1ec7n x\u1ebfp th\u1ee9 4 trong b\u1ea3ng x\u1ebfp h\u1ea1ng c\u1ee7a DB-Engines<\/a> t\u00ednh \u0111\u1ebfn ng\u00e0y 01\/12\/2020.\u00a0 PostgresSQL c\u00f3 t\u1ed1c \u0111\u1ed9 t\u0103ng tr\u01b0\u1edfng v\u1ec1 l\u01b0\u1ee3ng user kh\u00e1 nhanh. Do \u0111\u00f3 nhu c\u1ea7u s\u1eed d\u1ee5ng PostgreSQL l\u00e0m c\u01a1 s\u1ee1 d\u1eef li\u1ec7u transactional l\u00e0 ho\u00e0n to\u00e0n kh\u1ea3 thi.<\/p>\n

\"\"<\/p>\n

Nhu c\u1ea7u t\u1ea1o v\u00e0 l\u01b0u tr\u1eef d\u1eef li\u1ec7u \u0111ang ti\u1ebfp t\u1ee5c gia t\u0103ng theo c\u1ea5p s\u1ed1 nh\u00e2n, \u0111\u00e3 qua r\u1ed3i giai \u0111o\u1ea1n m\u00e0 ch\u00fang ta ch\u1ec9 c\u00f3 m\u1ed9t s\u1ef1 l\u1ef1a ch\u1ecdn duy nh\u1ea5t nh\u01b0 \u0111\u00e3 t\u1eebng v\u1edbi ki\u1ebfn tr\u00fac monolithic. Ng\u00e0y nay, kh\u00e1ch h\u00e0ng \u0111\u00e3 c\u00f3 nhi\u1ec1u l\u1ef1a ch\u1ecdn v\u00e0 thay \u0111\u1ed5i linh ho\u1ea1t d\u1ef1a tr\u00ean d\u1eef li\u1ec7u v\u00e0 \u0111i\u1ec1u ki\u1ec7n kinh doanh c\u1ee7a doanh nghi\u1ec7p.<\/p>\n

M\u1ed9t trong nh\u1eefng kh\u00eda c\u1ea1nh quan tr\u1ecdng khi d\u1ecbch chuy\u1ec3n sang Babelfish cho PostgreSQL l\u00e0 v\u1eabn d\u00f9ng T-SQL, c\u00f3 stored procedure, ngo\u00e0i ra kh\u00f4ng ph\u1ea3i ch\u1ec9nh s\u1eeda nhi\u1ec1u v\u1ec1 code. Babelfish cho PostgreSQL hi\u1ec3u ph\u01b0\u01a1ng ng\u1eef truy v\u1ea5n \u0111\u1ed9c quy\u1ec1n (proprietary dialect) c\u1ee7a SQL server (T-SQL) v\u00e0 giao th\u1ee9c giao ti\u1ebfp (TDS). \u0110i\u1ec1u n\u00e0y lo\u1ea1i b\u1ecf nhu c\u1ea7u vi\u1ebft l\u1ea1i c\u00e1c schemas v\u00e0 code cho nh\u1eefng \u1ee9ng d\u1ee5ng \u0111ang s\u1eed d\u1ee5ng SQL server.<\/p>\n

\"\"<\/p>\n

V\u1ec1 m\u1eb7t v\u1eadn h\u00e0nh, d\u1ec5 d\u00e0ng nh\u1eadn th\u1ea5y PostgreSQL s\u1ebd d\u1ec5 d\u00e0ng qu\u1ea3n l\u00fd h\u01a1n SQL Server, \u0111\u1ed3ng th\u1eddi c\u0169ng linh \u0111\u1ed9ng h\u01a1n trong vi\u1ec7c d\u1ecbch chuy\u1ec3n v\u00e0 host c\u01a1 s\u1edf d\u1eef li\u1ec7u.<\/p>\n

V\u1ec1 m\u1eb7t t\u00e0i ch\u00ednh, PostgreSQL s\u1ebd gi\u00fap doanh nghi\u1ec7p ti\u1ebft ki\u1ec7m \u0111\u1ebfn 60% chi ph\u00ed v\u1ec1 b\u1ea3n quy\u1ec1n cho c\u01a1 s\u1edf d\u1eef li\u1ec7u, v\u1edbi c\u00e1c doanh nghi\u1ec7p \u0111ang c\u00f3 c\u01a1 s\u1edf d\u1eef li\u1ec7u t\u0103ng nhanh th\u00ec \u0111\u00e2y s\u1ebd l\u00e0 m\u1ed9t m\u1ee9c c\u1eaft gi\u1ea3m chi ph\u00ed \u0111\u00e1ng k\u1ec3 theo th\u1eddi gian. \u00a0<\/p>\n

C\u00f9ng x\u00e2y d\u1ef1ng t\u01b0\u01a1ng lai tr\u00ean PostgreSQL<\/strong><\/h2>\n

Babelfish s\u1ebd ch\u01b0a s\u1eb5n s\u00e0ng cho vi\u1ec7c s\u1eed d\u1ee5ng trong v\u00e0i th\u00e1ng t\u1edbi, trong l\u00fac ch\u1edd \u0111\u1ee3i Babelfish cho PostgreSQL s\u1eb5n s\u00e0ng, ch\u00fang ta c\u00f3 th\u1ec3 tr\u1ea3i nghi\u1ec7m Babelfish tr\u00ean Amazon Aurora \u0111\u1ec3 c\u1ea3m nh\u1eadn v\u1ec1 c\u00e1ch th\u1ee9c translations v\u00e0 truy\u1ec1n d\u1eef li\u1ec7u, \u0111i\u1ec1u n\u00e0y s\u1ebd cho ph\u00e9p b\u1ea1n \u0111o l\u01b0\u1eddng m\u1ee9c \u0111\u1ed9 tr\u01b0\u1edfng th\u00e0nh v\u00e0 s\u1eb5n s\u00e0ng c\u1ee7a Babelfish.<\/p>\n

T\u1eeb concept, c\u00e1ch th\u1ef1c thi, v\u00e0 gi\u00e1 tr\u1ecb c\u1ee7a Babelfish \u0111\u1ec1u ph\u00f9 h\u1ee3p v\u1edbi kh\u00e1ch h\u00e0ng thay v\u00ec m\u1ed9t n\u1ed7 l\u1ef1c n\u1eb7ng n\u1ec1 nh\u1eb1m bu\u1ed9c kh\u00e1ch h\u00e0ng ph\u1ea3i d\u1ecbch chuy\u1ec3n v\u00e0 t\u0103ng doanh thu c\u1ee7a nh\u00e0 cung c\u1ea5p. Babelfish s\u1ebd l\u00e0 s\u1ef1 ki\u1ec7n c\u00f3 s\u1ee9c \u1ea3nh h\u01b0\u1edfng l\u1edbn v\u00e0 s\u1ebd t\u00e1c \u0111\u1ed9ng \u0111\u1ebfn vi\u1ec7c d\u1ecbch chuy\u1ec3n c\u01a1 s\u1edf d\u1eef li\u1ec7u trong th\u1eddi gian t\u1edbi \u0111\u00e2y, d\u1ec5 d\u00e0ng nh\u1eadn th\u1ea5y r\u1eb1ng Babelfish s\u1ebd ph\u00f9 h\u1ee3p cho c\u01a1 s\u1edf d\u1eef li\u1ec7u v\u1edbi quy m\u00f4 nh\u1ecf (TB) v\u00e0 transactional th\u1ea5p.<\/p>\n

N\u1ebfu b\u1ea1n l\u00e0 m\u1ed9t developer c\u00f3 ki\u1ebfn th\u1ee9c v\u1ec1 SQL server v\u00e0 PostgreSQL b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 gi\u00fap \u0111\u00f3ng g\u00f3p v\u00e0o d\u1ef1 \u00e1n m\u00e3 ngu\u1ed3n m\u1edf n\u00e0y. Link GitHub c\u1ee7a d\u1ef1 \u00e1n<\/a><\/span><\/span><\/em><\/strong><\/p>\n

V\u1ec1 VTI Cloud<\/strong><\/h2>\n

VTI Cloud<\/strong>\u00a0l\u00e0 \u0110\u1ed1i t\u00e1c c\u1ea5p cao\u00a0(Advanced Consulting Partner<\/span>)<\/a>\u00a0c\u1ee7a AWS, v\u1edbi \u0111\u1ed9i ng\u0169 h\u01a1n 50+ k\u1ef9 s\u01b0 v\u1ec1 gi\u1ea3i ph\u00e1p \u0111\u01b0\u1ee3c ch\u1ee9ng nh\u1eadn b\u1edfi AWS. V\u1edbi mong mu\u1ed1n h\u1ed7 tr\u1ee3 kh\u00e1ch h\u00e0ng trong h\u00e0nh tr\u00ecnh chuy\u1ec3n \u0111\u1ed5i s\u1ed1 v\u00e0 d\u1ecbch chuy\u1ec3n l\u00ean \u0111\u00e1m m\u00e2y AWS, VTI Cloud t\u1ef1 h\u00e0o l\u00e0 \u0111\u01a1n v\u1ecb ti\u00ean phong trong vi\u1ec7c t\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p, ph\u00e1t tri\u1ec3n ph\u1ea7n m\u1ec1m v\u00e0 tri\u1ec3n khai h\u1ea1 t\u1ea7ng AWS cho kh\u00e1ch h\u00e0ng t\u1ea1i\u00a0Vi\u1ec7t Nam<\/strong>\u00a0v\u00e0\u00a0Nh\u1eadt B\u1ea3n.<\/strong><\/p>\n

X\u00e2y d\u1ef1ng c\u00e1c ki\u1ebfn tr\u00fac an to\u00e0n, hi\u1ec7u su\u1ea5t cao, linh ho\u1ea1t, v\u00e0 t\u1ed1i \u01b0u chi ph\u00ed cho kh\u00e1ch h\u00e0ng l\u00e0 nhi\u1ec7m v\u1ee5 h\u00e0ng \u0111\u1ea7u c\u1ee7a\u00a0VTI Cloud<\/strong>\u00a0trong s\u1ee9 m\u1ec7nh c\u00f4ng ngh\u1ec7 h\u00f3a doanh nghi\u1ec7p.<\/p>\n

B\u00e0i vi\u1ebft li\u00ean quan:<\/strong><\/p>\n

Forrester predicts 2021: Cloud computing accelerates business transformation after the COVID pandemic<\/a><\/p><\/blockquote>\n