Dark Mode

kontentsunisukitsupu

obuziekutoWen iHe waseYan Yu

Chu Dian : huri-Bai Ke Shi Dian {uikipedeia(Wikipedia)}
(OQLkaraZhuan Song )

obuziekutoWen iHe waseYan Yu (obuziekutotoiawasegengo, obuziekutoZhao Hui Yan Yu , OQL, Ying : Object Query Language) ha, Object Data Management Group (ODMG) niZhun Ju shitaobuziekutode-tabe-suniDui suruWen iHe wasetoGeng Xin woXing utamenoXuan Yan Xing noWen iHe waseYan Yu (de-tabe-suYan Yu ) dearu. OQLha, Xuan Yan Xing Yan Yu deari, Shou Sok kiXing Yan Yu dehanai. OQLha, Guan Xi de-tabe-su (rire-shiyonarude-tabe-su) noWen iHe waseYan Yu (de-tabe-suYan Yu ) SQL womotonishiteiru. OQLha, ODMGniyotsuteKai Fa sareBiao Zhun Shi Yang toshiteGong Kai sareta. OQLha, Quan Ti De niShi Yang gaFu Za dearutame, koremadenotokoroOQLwoWan Quan niShi Zhuang shiteiruobuziekutode-tabe-suKai Fa Qi Ye ha, Yi She monai. OQLha, ikutsukanoOQLYi Jiang niKai Fa saretaWen iHe waseYan Yu noShe Ji niYing Xiang woataeta. soushitaWen iHe waseYan Yu noLi toshiteha, JDOQLtoEJBQLgaaru. shikashinagara, JDOQLtoEJBQLha, OQLkaraPai Sheng shitaJi Shu tohaWei Zhi dukerareteinai.

SQLtonoWei i

[Bian Ji ]

OQLtoSQLtonoZhong Yao naWei iwoShi su[1].

  • OQLha, Biao Nei deobuziekutohenoCan Zhao woXi ukotogadekiru. obuziekutoha, Ru reZi Gou Zao nisurukotogadekiru (nesutosaserukotogadekiru) .
  • SQLnosubetenoki-wa-dogaOQLdemoShi eruwakedehanai. Netcool/Precision IP tohaGuan Lian nonaiki-wa-doha, OQLnoWen Fa karaChu Qu sareteiru.
  • OQLha, OQLWen nonakadeShu Xue De naJi Suan woXing ukotogadekiru.

OQLnoYi Ban De naTe Zheng

[Bian Ji ]

OQLWen nihaCi noTe Zheng gaaru.

  • OQLnoWan Quan naWen noLian nariha, semikorondeZhong Liao suru.
  • OQLWen nonakanoentorinorisutoha, Duo kunoChang He hakonmadeQu Qie rareruga, konmadeZhong Liao surukotohanai
  • tekisutonoWen Zi Lie ha, shingurukuo-te-shiyonnopeamoshikuhadaburukuo-te-shiyonnopead ekukurareru.

Jian Dan naLi

[Bian Ji ]

Ci noLi ha, subetenopa-sonarukonpiyu-ta (PC) nouchiZhu Ji Yi Zhuang Zhi (RAM) ga64MBYi Shang dearumononoCPUnoSu Du wo, Jia Kong noPCde-tabe-sukaradonoyouniWen iHe waserukawoShi su.

SELECT pc.cpuSpeed
FROM PCs pc
WHERE pc.ram > 64

guru-puHua toJi Yue wotomonauWen iHe wase

[Bian Ji ]

Ci noLi ha, Zhu Ji Yi Zhuang Zhi (RAM) noRong Liang noPing Jun wo, Zhi Zao Zhe gotoni, donoyouniWen iHe waserukawoShi su.

SELECT manufacturer, AVG(SELECT part.pc.ram FROM partition part)
FROM PCs pc
GROUP BY manufacturer: pc.manufacturer

partition ki-wa-dowoShi tsuteirukotoniZhu Yi . Cong Lai noSQLtohaNi noFang Fa deJi Yue woXing tsuteiru.

Guan Lian Xiang Mu

[Bian Ji ]

Jiao Zhu

[Bian Ji ]
  1. ^ IBM OQLRu Men : http://publib.boulder.ibm.com/infocenter/tivihelp/v8r1/index.jsp?topic=/com.ibm.netcool_precision.doc/pr35se/xF1118340.html