Database Access Controller
QueryPie DAC ã¯ãã¯ã©ãŠãç°å¢ãšãªã³ãã¬ãã¹ç°å¢ã®äž¡æ¹ããµããŒãããããŒã¿ä¿è·ããã³ã¢ã¯ã»ã¹å¶åŸ¡ãœãªã¥ãŒã·ã§ã³ã§ãã
ã©ãã«ããŠããããŒã¿ã»ãã¥ãªãã£ãšã¢ã¯ã»ã¹å¶åŸ¡ãå®å
šã«ç®¡çã§ããQueryPie DAC ããå§ããŠã¿ãŸãããïŒ
DAC ã®æ³šç®æ©èœ
QueryPie DAC ã¯ãRBACïŒããŒã«ããŒã¹ã¢ã¯ã»ã¹å¶åŸ¡ïŒãšABACïŒå±æ§ããŒã¹ã¢ã¯ã»ã¹å¶åŸ¡ïŒã掻çšããåçãªã¢ã¯ã»ã¹å¶åŸ¡ãæäŸããé«åºŠãªæš©é管çããµããŒãããŸãããŠãŒã¶ãŒã¯Web SQL ãšãã£ã¿ã䜿ã£ãŠã¹ã ãŒãºã«ããŒã¿ããŒã¹äœæ¥ãè¡ãããšãã§ãã管çè ã¯å€æ§ãªããŒã¿ãœãŒã¹ã«ããããŠãŒã¶ãŒã®æŽ»åããªã¢ã«ã¿ã€ã ã§ç£æ»ããããšãå¯èœã§ãã
RBAC / ABAC ããŒã¹ã®ã¢ã¯ã»ã¹å¶åŸ¡
ãŠãŒã¶ãŒããŒã«(RBAC: Role-Based Access Control)ã«ãã£ãŠåºæ¬æš©éãèšå®ã§ããã ãã§ãªããæéãææ¥ã ã¢ãã¬ã¹ãSQL ã¿ã€ããªã©æ§ã ãªå±æ§(ABAC: Attribute-Based Access Control)ã«åºã¥ãã詳现ãªã¢ã¯ã»ã¹å¶åŸ¡ãå¯èœã§ãã
Web SQL ãšãã£ã¿å¯Ÿå¿
ãŠãŒã¶ãŒã®ãªãã¬ãŒãã£ã³ã°ã·ã¹ãã ãäœã§ãã£ãŠããIDE ããŒã«ããªããŠãããŠãŒã¶ãã¬ã³ããªãŒãª Web SQL ãšãã£ã¿ã§ãã©ãŠã¶ããçŽæ¥ããŒã¿ããŒã¹ã«æ¥ç¶ããããšãã§ããŸãã ã¯ãšãªã®å®è¡ããããŒã¿ã®ã€ã³ããŒããšãšã¯ã¹ããŒããŸã§ããã¹ãŠã®ã¿ã¹ã¯ãç°¡åã«åŠçã§ããŸãã
ããŒã¿ç£æ»ãšç°åžžå åã®éç¥
ãã°ã€ã³ãããŒã¿ããŒã¹ã¢ã¯ã»ã¹ãæš©é倿ŽãSQL ã³ãã³ããã¯ãšãªçµæãªã©ããã¹ãŠã®ãŠãŒã¶ãŒæŽ»åã远跡ããç°åžžãªè¡åãçŽ æ©ãæç¥ããããŒã¿ã»ãã¥ãªãã£ã培åºçã«ç¶æããããšãã§ããŸãããŸããSlack ã®ãããªãã£ã³ãã«ã§ãªã¢ã«ã¿ã€ã éç¥ãåããŠéèŠãªã€ãã³ãã確èªããããšãã§ããŸãã
ããŒãã« / ã«ã©ã åäœã®ã¢ã¯ã»ã¹å¶åŸ¡
æ©å¯æ å ±ãä¿è·ããããã«ããŒã¿ãã¹ãã³ã°ããªã·ãŒãé©çšããç¹å®ã®ã¯ãšãªã«ãŒã«ã«ãã£ãŠéèŠãªããŒãã«ãšã«ã©ã ãžã®ã¢ã¯ã»ã¹å¶éãèšå®ããŠããŒã¿ã»ãã¥ãªãã£ã匷åããããšãã§ããŸãã
ãžã£ã¹ãã€ã³ã¢ã¯ã»ã¹èŠæ±åŠç
ãŠãŒã¶ãŒãå¿ èŠãªæç¹ã§ã¢ã¯ã»ã¹æš©ãèŠè«ãã管çè ãçŽã¡ã«æ¿èªåã³æš©éãä»äžããããšãã§ããŸãã Slack ã®ãããªã·ãŒã ã¬ã¹ãªçµ±åã«ãããç°¡åã§å¹ççãªã¢ã¯ã»ã¹ç®¡çãå¯èœã§ãã
QueryPie DACã®ä»çµã¿
QueryPieã¯ãã客æ§ã®åºæã®ç°å¢ã«åãããŠæè»ãªã¯ãŒã¯ã¹ããŒã¹ãæäŸããã»ãã¥ãªãã£ãäžå±€åŒ·åããŸãã
ãã©ãŠã¶ããŒã¹ã®Web SQLãšãã£ã¿ã«ãããããŒã¿æŒæŽ©å¶åŸ¡ãç°¡åã«ç®¡çã§ããã ãã§ãªãã
ãµãŒãããŒãã£ãŒããŒã«ã®äœ¿çšãå¯èœã«ãããšãŒãžã§ã³ããŸãã¯ãšãŒãžã§ã³ãã¬ã¹(URLãããã·)æ¹åŒããµããŒãããŸãã

QueryPie ãŠãããŒãµã«ã¢ãã©ã€ã¶ãŒ:
ããããã¯ãšãªèšèªã«å¯Ÿå¿
QueryPie ãªãã§ã¯ã®æŠåšãã¯ãšãªãŒã¢ãã©ã€ã¶ãŒã«ãã£ãŠæ§ã
ãªããŒã¿ãœãŒã¹éã®å·®éãè§£æ¶ããŸãã
ãããªãè€éãªã¯ãšãªãQueryPie ã¢ãã©ã€ã¶ãŒãåæããŠè§£æããã·ã³ãã«ãªåœ¢åŒã«å€æããŸãã

ç°¡åã€ã³ã¹ããŒã«ãç°¡åæäœ
QueryPie ã¯ã¯ã©ãŠããã€ãã£ãæè¡ãšWebããŒã¹ã®ã€ã³ã¿ãŒãã§ãŒã¹ãçµã¿åãããããŸããŸãªãªãã¬ãŒãã£ã³ã°ã·ã¹ãã ã§ç°¡åã«ã€ã³ã¹ããŒã«ããã³éçšã§ããããèšèšãããŠããŸããDocker ããã±ãŒãžã³ã°ã«ãã容æã«é åžå¯èœã§ããªã³ãã¬ãã¹ã®ã»ãã¥ãªãã£ãšSaaS ã®ãããªå©äŸ¿æ§ã®é«ãã¢ããããŒãæ¹åŒãçµã¿åããããã€ããªããã¢ãããŒãããµããŒãããŠããŸãããã®èšèšã«ãããéèãå»çãå ¬å ±éšéãªã©ã§ã®ã³ã³ãã©ã€ã¢ã³ã¹ãæ¯æŽãããšãšãã«ãåé¡ãçºçããéã«ã¯å³åº§ã«ããŒã«ããã¯ããæ©èœãæäŸããŸããQueryPie ã¯ãSaaS ã®å©äŸ¿æ§ãšãªã³ãã¬ãã¹ãœãªã¥ãŒã·ã§ã³ã®åŒ·åºãªã»ãã¥ãªãã£ãèåãããããšã§ã顧客ã«å€§ããªäŸ¡å€ãæäŸããããšãç®æããŠããŸãã

ãŠãŒã¶ãŒãã¬ã³ããªãŒãª
Web SQLãšãã£ã¿
ãããIDE ãåå¥ã«çšæããå¿ èŠãããŸããïŒ QueryPie ã®Web SQL ãšãã£ã¿ã䜿çšããã°ã䜿çšããOS ã«é¢ä¿ãªãããã©ãŠã¶äžã§ç°¡åã«ã¯ãšãªã®å®è¡ãã€ã³ããŒãããšã¯ã¹ããŒããããã³ããŸããŸãªã¿ã¹ã¯ãå®è¡ã§ããŸãã


ãµãŒãããŒãã£ãŒ ããŒã«ã®ããã®
å®å
šãªãããã·æ¥ç¶ããµããŒã
ãããŸã§å©çšããŠããããŒã«ããã®ãŸãŸããŒã¿ããŒã¹ã«æ¥ç¶ããå¿ èŠãããå Žåã®ããã«ãQueryPie ã¯å®å šãªãããã·ãµãŒãã§ã®ã¢ãããŒãããµããŒãããŸãã ãšãŒãžã§ã³ãåã³ãšãŒãžã§ã³ãã¬ã¹æ¹åŒããã¹ãŠãµããŒãããQueryPie ãšåæ§ã®åŒ·åãªã¢ã¯ã»ã¹å¶åŸ¡ãšããªã·ãŒããå©çšããã ããŸãã
ããŒã¿ããŒã¹ã
çµ±åããæ§æå¶åŸ¡æ¯æŽ
æšæºSQLã«åºã¥ããŠããŒã¿ããŒã¹ãçµ±åããæ§æå¶åŸ¡ãå¯èœã§ããRDBMSãããŒã¿ãŠã§ã¢ããŠã¹ãNoSQL ãªã©ãäžè²«ããæš©éããªã·ãŒã§ç®¡çããRedis ã¯200以äžã®ã³ãã³ãããMongoDB Shell ã¯æšæºSQL ã«å¯Ÿå¿ããŠæ§æçµ±å¶ããµããŒãããŸãã


éèŠããŒã¿ã®ãã¹ãã³ã°åŠçãšä¿è·
äºåå®çŸ©ããããã¿ãŒã³ãšæ£èŠåœ¢åŒã§æ©å¯æ å ±ããŒã¿ã®ãã¹ãã³ã°åŠçããµããŒãããŸãã ã«ã¹ã¿ã ãã¿ãŒã³èšå®ãéããŠæè»ãªãã¹ãã³ã°ããªã·ãŒãæ§æãããã¥ãŒäœæããã³é¢æ°äœ¿çšæã«ããŒã¿ã鮿ããããªã·ãŒã«åŸã£ãŠå人æ å ±ãå®å šã«ä¿è·ããŸãã åäžã«ã©ã ã ãã§ãªããJSON 圢åŒã®ããŒã¿ãåŠçããŸãã
å åž³ããŒãã«ã®ã¢ã¯ã»ã¹å¶åŸ¡
éèŠãªããŒãã«ãžã®å€æŽãæ¿èªããã¯ãŒã¯ãããŒãåããŠãããããŒã¿ãç°¡åã«ç®¡çã§ããŸãã å åž³ããŒãã«ããªã·ãŒ(Ledger Table Policy) ã«æ€åºãããå Žåãäºåå®çŸ©ãããæ¿èªããã»ã¹ãèªåçã«è¡ãããŸããÂ å€æŽååŸã®çµæã远跡ããã¹ã ãŒãºãªæ§æç®¡çãå®çŸããŸãïŒ


æš©éä»äžãšSQLæ¿èªã®
ããã»ã¹ã®èªåå
管çè ãæ¿èªããã»ã¹ãèšå®ã§ããã«ã¹ã¿ãã€ãºå¯èœãªãã³ãã¬ãŒãã䜿çšããŠãã¯ãŒã¯ãããŒãã·ã³ãã«ã«ããŸãïŒæš©éã®ãªããŠãŒã¶ãŒãããŒã¿ããŒã¹ãžã®ã¢ã¯ã»ã¹ã倿ŽãèŠæ±ããå Žåãèªååãããã¯ãŒã¯ãããŒããã¹ãŠãã¹ã ãŒãºã«å®è¡ãããããã«ããŸãã
QueryPie ã¯SaaS ãµãŒãã¹ã§ããïŒ
çŸåšãQueryPie ã¯ã¯ã©ãŠããšãªã³ãã¬ãã¹ç°å¢ã®äž¡æ¹ã§ã€ã³ã¹ããŒã«å¯èœãªãœãªã¥ãŒã·ã§ã³ãšããŠæäŸãããä»åŸSaaS ããŒã¹ã®ãµãŒãã¹ã®ãæäŸãèšç»ããŠããŸããããã«ãããã客æ§ã¯æ¢åã®ã€ã³ãã©ã¹ãã©ã¯ãã£ãšã·ãŒã ã¬ã¹ã«çµ±åãããSaaS ãžã®ç§»è¡ãµããŒããåããããšãã§ããŸãã
QueryPie ã¯ãŠãŒã¶ãŒèªèšŒãã©ã®ããã«åŠçããŸããïŒ
QueryPieã¯ãSAMLããŒã¹ã®SSOãå€èŠçŽ èªèšŒ(MFA)ãLDAP çµ±åããµããŒããããŠãŒã¶ãŒãã·ã¹ãã ã«å®å šã«ã¢ã¯ã»ã¹ã§ããããã«ããŸããéäžç®¡çæ©èœã«ããã管çè ã¯ã·ã¹ãã éã®æš©éãå¹ççã«åŠçã§ããã»ãã¥ãªãã£ã匷åãããŠãŒã¶ãŒã¢ã¯ã»ã¹ã«å¯Ÿããçµ±å¶ãåäžãããããšãã§ããŸãã
QueryPie ã¯ã©ã®ãããªã»ãã¥ãªãã£æšæºãéµå®ããŠããŸããïŒ
QueryPie ã¯ISO27001ãSOC2ãGDPRãCSA-STAR ãšãã£ãã°ããŒãã«ã»ãã¥ãªãã£æšæºãéµå®ããããã«èšèšãããããŒã¿ã»ãã¥ãªãã£ãšèŠå¶èŠä»¶ãæºãããŠããŸããããã«ãããçµç¹ã¯ã¢ã¯ã»ã¹ç®¡çæ©èœã匷åããã³ã³ãã©ã€ã¢ã³ã¹èŠä»¶ãæºãããç£æ»æºåãè¡ãããšãã§ããŸãã
QueryPie ã¯æ¢åã®ã»ãã¥ãªãã£ãœãªã¥ãŒã·ã§ã³ãšäºææ§ããããŸããïŒ
QueryPie ã¯API ãéããŠæ§ã ãªå€éšã»ãã¥ãªãã£ãœãªã¥ãŒã·ã§ã³ãšåæ»ã«çµ±åãããããã«èšèšãããŠããŸããããã«ãããæ¢åã®ã€ã³ãã©ã¹ãã©ã¯ãã£ãšã®äºææ§ãä¿èšŒãããæ¢åã®ã»ãã¥ãªã㣠ãã¬ãŒã ã¯ãŒã¯ã匷åããã远å ã®ã»ãã¥ãªã㣠ãœãªã¥ãŒã·ã§ã³ãªãã§å¹ççãªéçšãå¯èœã«ãªããŸãã
ãã£ã3åã§åºäŒãæ°ããäžçïŒ
ããŒãã£ã«ãã¢ãŒã§ãé©ãã¹ãäžçãä»ããã芧ãã ããïŒ