HammerDB: The industry standard open-source database benchmark.
ãªããSQLã¯éãããªãã®ãï¼ââãSQLããã©ã¼ãã³ã¹è©³è§£ãã®ç¿»è¨³è ãæããåå ã¨å¯¾ç ãSQLããã©ã¼ãã³ã¹è©³è§£ãã®ç¿»è¨³è ã®æ¾æµ¦é¼äººããã«ã8ã¤ã®ãSQLãéãããªãåå ã¨ãã®å¯¾çããèãã¾ãããã·ã¹ãã ã®ããã«ããã¯ã«ãªããããªãåé¡ã®ããSQLããåé¿ãããã¦ãã¦ãå¦ã³ã¾ãããã ãã¼ã¿ã®æä½ãå®ç¾©ãããè¨èªãSQLãã¯ãã©ã®ãããªé åãæ ãã¨ã³ã¸ãã¢ã«ã¨ã£ã¦ãå¿ ä¿®ç§ç®ã§ãããããããã®ä»æ§ããã¡ãã¨çè§£ããããã©ã¼ãã³ã¹ã«åªããSQLãæ¸ããæ¹ã¯ããã»ã©å¤ãããã¾ãããåé¡ã®ããSQLãæ¸ãã¦ãã¾ããç¥ãã¬éã«ãããã·ã¹ãã ã®ããã«ããã¯ã«ãªã£ã¦ãã¾ãäºæ ã¯ããçºçãã¾ãã ã§ã¯ãã©ãããã°ããããäºæ ãåé¿ã§ããã®ã§ããããï¼ ãã®ãã¦ãã¦ãå¦ã¶ãããä»åã¯ãSQLããã©ã¼ãã³ã¹è©³è§£ãã®ç¿»è¨³è ã§ãããèªèº«ãã¨ã³ã¸ãã¢ã§ãããæ¾æµ¦é¼äººï¼ã¾ã¤ããã»ã¯ãã¨ï¼@dblmktï¼ããã«8ã¤
SQLã®ããã©ã¼ãã³ã¹åé¡ã¯ãSQLãã®ãã®ã¨åããããã®æ´å²ãããââ ãã人ã¯ãSQLã¯ããããé ããã®ã ã¨ããè¨ãããããã¾ãããããã¯ãSQLã®æ´å²ãå§ã¾ã£ãé ã¯æ£ããã£ãããããã¾ããããä»ã¨ãªã£ã¦ã¯å ¨ã å½ã¦ã¯ã¾ããªãã§ããããã«ãããããããSQLã®ããã©ã¼ãã³ã¹åé¡ã¯ä»ãä¸è¬çã§ãããããã¨ã§ããã©ããã¦ãããªã£ã¦ãã¾ãã®ã§ããããï¼ SQLè¨èªã¯ãæããæãæåãã第4ä¸ä»£è¨èª(4GL)ã§ãããããã®æå¤§ã®å©ç¹ã¯ããä½ããã¨ãã©ã®ããã«ã ãåé¢ã§ãããã¨ã§ããSQLæã¯ãã©ã®ããã«ãããå®è¡ããããè¨è¿°ããã«ãåç´ã« ä½ãå¿ è¦ã¨ãã¦ãããã®ã¿ã®è¨è¿°ã«ãªã£ã¦ãã¾ãã以ä¸ã®ãããªä¾ãèãã¦ã¿ã¾ãããã SELECT date_of_birth FROM employees WHERE last_name = 'WINAND'SQLã®ã¯ã¨ãªã¯ããã¼ã¿ãè¦æ±ããè±èªã®æã¨ãã¦èª
SQL Server ã®ãã³ããã¼ã¯ã½ããã¨ãã¦ã¯ãSQLIOSIM ã SQLIO ãããã¾ããã ãããã®ã½ãã㯠SQL Server ã¨åæ§ã® I/O ãã¿ã¼ã³ã SQL Server ãã¤ã³ã¹ãã¼ã«ããªãã¦ã試ããã¨ãã§ãããã¼ã«ã«ãªãã¾ãã SQL Server ãã¤ã³ã¹ãã¼ã«ããå¾ã«ãã³ããã¼ã¯ãè¡ãããå ´åã«ã¯ãç§ã¯ HammerDB ã¨ãã TPC ã®ãã³ããã¼ã¯ãã§ããã½ããã使ç¨ãã¦ãã¾ãã æ¥æ¬èªç°å¢ã® OS / SQL Server ã§ HammerDB ã® TPC-H ã®ãã³ããã¼ã¯ãå®è¡ããéã«å°ã注æããç¹ãããã¾ããã®ã§ã¡ã¢ã¨ãã¦æ®ãã¦ããããã¨æãã¾ãã TPC-C ãå®è¡ããå ´åã¯ãç¹ã«ã¨ã©ã¼ã«ã¯ãªããªãã£ãã®ã§ãããTCP-H ãå®è¡ããå ´åã«ã¯ãã¹ãç¨ã®ã¹ãã¼ãã使ãã¦ããéä¸ã§ã¨ã©ã¼ã¨ãªã£ã¦ãã¾ãã¾ããã ã¨ã©ã¼ãè§£æ¶ããããã«ã¯ ODBC ã®
ã©ã³ãã³ã°
ã©ã³ãã³ã°
ã¡ã³ããã³ã¹
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}