Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ʹÓÃJena½«±¾Ìå´æÈëMySQL——ÎĵµºÍÀý×Ó


 iMarine http://iMarine.blog.163.com
×¢Ã÷£º±¾Îĵµ²Î¿¼Jena 2.5Îĵµ£¬Ê¹ÓÃJena 2.5 APIºÍMySQL 5.0.4-beta-ntÊý¾Ý¿â¡£MySQLÇý¶¯°üʹÓõÄÊÇmysql-connector-java-3.1.10-bin.jar¡£
1 JenaµÄÊý¾Ý¿â½Ó¿Ú
JenaÌṩÁ˽«RDFÊý¾Ý´æÈë¹ØÏµÊý¾Ý¿âµÄ½Ó¿Ú£¬Model¡¢Resource¡¢QueryµÈ½Ó¿Ú¿ÉÒÔÓÃÓÚ·ÃÎʺÍά»¤Êý¾Ý¿âÀïµÄRDFÊý¾Ý¡£ÔÚ´¦ÀíÊý¾Ýʱ£¬Ó¦ÓóÌÐò²»±ØÖ±½Ó²Ù×÷Êý¾Ý¿â£¨¶øÊÇͨ¹ýJenaµÄAPI£©£¬Ò²²»±ØÖªµÀÊý¾Ý¿âµÄģʽ¡£
JenaÌṩÁËÖ§³ÖMySQL¡¢HSQLDB¡¢PostgreSQ¡¢OracleºÍMicrosoft SQL ServerµÄ³ÌÐò½Ó¿Ú¡£ÓÐЩµÚÈý·½ÌṩÆäËûÊý¾Ý¿â½Ó¿ÚµÄÖ§³Ö¡£¿ÉÒԲο¼JenaÊý¾Ý¿âÎĵµ»ñµÃÊý¾Ý¿â°æ±¾ÒÔ¼°¶ÔÓ¦µÄJDBCÇý¶¯ËµÃ÷¡£
2 JenaµÄÊý¾Ý¿âģʽ
¹ØÏµÊý¾Ý¿â´æ´¢RDFÊý¾ÝµÄÒ»°ãģʽÊÇ“ÈýÔª×锣¬±íÓÐÈýÁУ¨Ö÷Ì塢ν´Ê¡¢¿ÍÌ壩ÿ¸öRDF³ÂÊö£¨sataement£©Õ¼ÓÃÒ»ÐС£ÓÐʱºò£¬Ìí¼ÓµÚËÄÁÐÒÔ±íʾ¿ÍÌåÊÇ×Ö·û³£Á¿»¹ÊÇURI¡£
Jena 2²ÉÓÃÒ»ÖÖdenormalizedµÄÈýÔª×é´æ´¢·½·¨£¬ÊÇ´æ´¢¿Õ¼äºÍ·ÃÎÊʱ¼äµÄÒ»ÖÖȨºâ·½·¨£¨a space-time trade-off£©¡£JenaʹÓÃÁ½ÀàÆß¸ö±í´æ´¢±¾Ì壬µÚÒ»ÀàÊÇasserted statements£¬µÚ¶þÀàreified statements¡£
Statement Tables ³ÂÊö±í
1)         Asserted Statement Table (Jena_GiTj_Stmt)£º´æ´¢±¾ÌåÊý¾Ý
2)         Reified Statement Table (Jena_GiTj_Reif)£º¾­¹ý´¦ÀíµÄ±¾ÌåÊý¾Ý
System Tables ϵͳ±í£º´æ´¢ÔªÊý¾ÝºÍ³ÂÊö±íÖÐʹÓõĽϳ¤µÄÎÄ×Ö»òÕß×ÊÔ´
3)         System Statement Table (Jena_Sys_Stmt)£º´æ´¢ÏµÍ³ÔªÊý¾Ý
4)         Long Literals Table (Jena_Long_Lit)£º´æ´¢³ÂÊö±íÖв»±ãÓÚÖ±½Ó´æ´¢µÄ³¤×Ö·û´´³£Á¿£¨Literals£©
5)         Long Resources Table (Jena_Long_URI)£º´æ´¢³ÂÊö±íÖв»±ãÓÚÖ±½Ó´æ´¢µÄ³¤×ÊÔ´URI
6)         Prefixes Table (Jena_Prefix)£º´æ´¢URIµÄǰ׺¡£Ç°×ºÖ»´æ´¢Ò»´Î£¬½ÚÊ¡¿Õ¼ä¡£
7)         Graph Table (Jena_Graph)£º´æ´¢Ã¿Ò»¸öÓû§Í¼µÄÃû×ÖºÍΨһ±êÖ¾·û¡£
8)         Lock Table (Jena_Mutex)£ºÒ»¸öûÓÐÄÚÈÝµÄ±í¡£Èç¹û¸Ã±í´æÔÚ£¬ÔÚÒ»¶¨Ê±¼ä¶ÎÀï


Ïà¹ØÎĵµ£º

ÈÃMySQLÊý¾Ý¿â·þÎñÆ÷Ö§³ÖÔ¶³ÌÁ¬½Ó

1¡¢ÔÚ¿ØÖÆÌ¨Ö´ÐÐ mysql -u root -p mysql£¬ÏµÍ³ÌáʾÊäÈëÊý¾Ý¿ârootÓû§µÄÃÜÂ룬ÊäÈëÍê³Éºó¼´½øÈëmysql¿ØÖÆÌ¨£¬Õâ¸öÃüÁîµÄµÚÒ»¸ömysqlÊÇÖ´ÐÐÃüÁµÚ¶þ¸ömysqlÊÇϵͳÊý¾ÝÃû³Æ£¬²»Ò»ÑùµÄ¡£
2¡¢ÔÚmysql¿ØÖÆÌ¨Ö´ÐÐ GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'MyPassword' WITH GRANT OPTION;
3¡¢ÔÚmysql¿ØÖÆ ......

MYSQL·þÎñÎÞ·¨Æô¶¯1067½â¾ö°ì·¨


ÔÚÔËÐÐmysql administratorµÄʱºò,ÎÞ·¨µÇ¼mysql·þÎñÆ÷,²éÕÒ´íÎó,ÀÏÊÇÎÞ·¨½øÐÐ.ÔÚ½øÈëwindowsϵĹÜÀí¹¤¾ßµÄ·þÎñÖÐ,ÒÀÈ»ÎÞ·¨Æô¶¯,Ìáʾ˵ÊÇ´íÎó1067.½â¾ö·½°¸ÈçÏÂ:
1\½øÈëÃüÁîÌáʾ·û,ÊäÈë sc delete mysql
ÌáʾÈôÊÇdelete service success,Ö¤Ã÷ɾ³ý·þÎñ³É¹¦;
2\ÔËÐÐmysqlµÄbinĿ¼ÏÂÃæµÄmysqlinstanceconfig,¶Ômysql½øÐ ......

MySQL 5.5 m2 VS MS Sql Server 2000 SE BenchMark

×÷Õߣº°½Ê¿Î°
·þÎñÆ÷£ºIBM X346
CPU:Intel Xeon 3.0 *4
Äڴ棺2GB
Ó²ÅÌ£ºRAID5
OS£ºwin2003 SE
Ò»¡¢MySQL 5.5 M2
MySQL ĬÈÏÒýÇæInnoDB£¬ÓÅ»¯Ç°ºó¼¸ºõÎÞ²î±ð
¶þ¡¢SQL SERVER 2000 SE
     ´ÓÕâû´Î²âÊÔ¿´£¬MysqlÔÚÊÂÎñÐÔÄܱíÏÖ²»ÈçSQL SERVER¡£Í¬Ê±£¬Á½ÕßÔÚĬÈÏÇé¿ö£¬ÅúÁ¿Insert£¬Mysql±íÏ ......

cmdÏÂmysqlÐÂÊÖÁ·ÊÖʵÀý

1,ÔÚcmdÏÂÓÃmysql¿Í»§»úÁ¬½Ómysql·þÎñÆ÷ php³ÌÐòÔ±Õ¾
´ò¿ªcmdºó,ÊäÈë php³ÌÐòÔ±Õ¾
mysql -h localhost -u root -p
phperz.com
Óï·¨: mysqlµ±È»ÊǸæËßcmd,ÕâÊÇmysqlµÄÃüÁîÁË php³ÌÐòÔ±Ö®¼Ò
²ÎÊý -h ÊÇ·þÎñÆ÷µØÖ·,ÔÚ´ËÎÒÃÇÒÔ±¾»úΪÀýÊäÈëlocalhost
-u ÊÇmysqlµÄÓû§Ãû  ÎÒÃÇÓÃmysql µÄĬÈÏÓû§Ãû root phperz ......

¹ØÓÚmysqlÖеÄint£¨m£©


<!--
/* Font Definitions */
@font-face
{font-family:ËÎÌå;
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-alt:SimSun;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
@font-face
{font-family:"\@ËÎÌå" ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ