|
un 12, 2015 5:19:14 PM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory
INFO: HHH000397: Using ASTQueryTranslatorFactory Jun 12, 2015 5:19:14 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute INFO: HHH000228: Running hbm2ddl schema update Jun 12, 2015 5:19:14 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute INFO: HHH000102: Fetching database metadata Jun 12, 2015 5:19:14 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute INFO: HHH000396: Updating schema Jun 12, 2015 5:19:15 PM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000261: Table found: .ADMIN.ENTITY Jun 12, 2015 5:19:15 PM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000037: Columns: [element_id, id, valuedata, incomingvertex_id, dtype, removed, label, keyname, outgoingvertex_id, version] Jun 12, 2015 5:19:15 PM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000108: Foreign keys: [fk_9r4w6h2jlb9a4e9pt3d95girc, fk_wb8dqej10hriw3o6m72yj9p, fk_ay9plo3t1cprfwdwjvp6fdwi6] Jun 12, 2015 5:19:15 PM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000126: Indexes: [uk_7hyan3asmdvrxrlywl7v0lj6e, sql150612170336740, uk_e
jspyse8mcceolr4vps96aohp, sql150612170337000, sql150612170337030, sql150612170336940] Jun 12, 2015 5:19:15 PM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000261: Table found: .ADMIN.INDEX_BASE Jun 12, 2015 5:19:15 PM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000037: Columns: [id, bpjpakeyindex_id, indexclassname, elementtype, dtype, removed, elementid, keyname, indexvalue, bpjpaindex_id, propertyid, indexname, version] Jun 12, 2015 5:19:15 PM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000108: Foreign keys: [fk_7ipiov9b2bb97hkncnl76mkkm, fk_olnpc5iekqlpsk6n61ucruk96] Jun 12, 2015 5:19:15 PM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000126: Indexes: [sql150612170337100, uk_o7ehuddxk2u2rgtqv9c8kbj75, uk_fd9ey72b1ypwplyllo410siv1, sql150612170337080, sql150612170336780, uk_l9wg7u7fi95namecr9p3apnn5, uk_tidr0ggw8dtylnj1ldr1oy4gb, uk_bke0r11vg7q6vtfud90jnfx4, uk_2u6spckbs5deg5048qfvxg5ca] Jun 12, 2015 5:19:15 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute INFO: HHH000232: Schema update complete Jun 12, 2015 5:19:15 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper$StandardWarningHandler logWarning WARN: SQL Warning Code: 10000, SQLState: 01J01 Jun 12, 2015 5:19:15 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper$StandardWarningHandler logWarning WARN: Database 'db/HibernateUnit_test_perf' not created, connection made to existing database instead. zhangsan:1 lisi:2 wangwu:3 create finish Jun 12, 2015 5:19:16 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl stop INFO: HHH000030: Cleaning up connection pool [jdbc:derby:db/HibernateUnit_test_perf;create=true] Process finished with exit code 0
对数据进行CRUD没有问题。
4，总结
代码就一个pom和java类，非常简单的就把图的数据存储到了数据库中。
存储到mysql里面类似，需要修改下jdbc连接即可。
如果作为业务服务，现在的代码再加点就基本满足了。
虽然数据库存储的比neo4j，solr等稍微慢点，但是运维成本低，数据库可以做主从复制，保护数据，同时多个服务访问一个数据库也可以解决单点服务问题。
数据库的优化非常多，非常方便，同时索引速度也挺快的。这个存储的是关系，一般情况先数据不太大，再使用mycat进行分库分表就可以扩展了。
|