wyxDBMS:使用Java实现了一个关系型数据库,DBMS数据库管理系统,可使用常用增删改改查的S​​QL语句,具有数据字典,数据索引文件,并且实现了启发式查询优化

上传者: 42165980 | 上传时间: 2022-05-18 23:42:57 | 文件大小: 35KB | 文件类型: ZIP
wyxDBMS是一个用Java实现的关系型数据库 实现功能 1,用Java语言建立数据库表。 (1)数据文件和字典文件存储结构和访问方法为按行访问,数据为字符型可直接阅读。 (2)属性的个数任意,属性的类型包括整数int,字符串varchar,双精度浮点double。 (3)表的相关信息存入数据字典。 2,为关系表插入元组。 (1)用VALUES子句为新建立的关系插入元组。 (2)用VALUES子句在关系模式修改之后按照新的模式插入元组。 (3)不指定属性,插入元组的所有属性值; (4)插入元组的指定属性的值。 (5)修改相应的索引文件。 3,实现属性的添加和删除功能。 (1)为基本表添加属性并维护数据字典。 4,实现表中元组的删除和修改功能,维护索引文件。 (1)实现删除数据库记录的功能。 a)没有WHERE条件,删除关系中的所有元组。 b)指定WHERE条件,删除满足条件的元组。 (2)实现修改数据库记录的功能。 a)没有WHERE条件,修改所有元组的指定属性的值。 b)指定WHERE条件,修改满足条件的元组的指定属性的值。 (3)修改相应的索引文件。 5,实现表的删除功能

文件下载

资源详情

[{"title":"( 39 个子文件 35KB ) wyxDBMS:使用Java实现了一个关系型数据库,DBMS数据库管理系统,可使用常用增删改改查的S​​QL语句,具有数据字典,数据索引文件,并且实现了启发式查询优化","children":[{"title":"wyxDBMS-master","children":[{"title":"wyxDBMS.iml <span style='color:#111;'> 507B </span>","children":null,"spread":false},{"title":"src","children":[{"title":"Join.java <span style='color:#111;'> 6.51KB </span>","children":null,"spread":false},{"title":"User.java <span style='color:#111;'> 3.69KB </span>","children":null,"spread":false},{"title":"JoinCondition.java <span style='color:#111;'> 2.93KB </span>","children":null,"spread":false},{"title":"Test.java <span style='color:#111;'> 145B </span>","children":null,"spread":false},{"title":"Field.java <span style='color:#111;'> 532B </span>","children":null,"spread":false},{"title":"Table.java <span style='color:#111;'> 24.04KB </span>","children":null,"spread":false},{"title":"IndexKey.java <span style='color:#111;'> 1.66KB </span>","children":null,"spread":false},{"title":"SingleFilter.java <span style='color:#111;'> 1.68KB </span>","children":null,"spread":false},{"title":"StringUtil.java <span style='color:#111;'> 7.22KB </span>","children":null,"spread":false},{"title":"Index.java <span style='color:#111;'> 381B </span>","children":null,"spread":false},{"title":"IndexTree.java <span style='color:#111;'> 3.37KB </span>","children":null,"spread":false},{"title":"Relationship.java <span style='color:#111;'> 6.17KB </span>","children":null,"spread":false},{"title":"Operating.java <span style='color:#111;'> 16.83KB </span>","children":null,"spread":false},{"title":"IndexNode.java <span style='color:#111;'> 702B </span>","children":null,"spread":false}],"spread":false},{"title":".idea","children":[{"title":"misc.xml <span style='color:#111;'> 273B </span>","children":null,"spread":false},{"title":"uiDesigner.xml <span style='color:#111;'> 8.59KB </span>","children":null,"spread":false},{"title":"inspectionProfiles","children":[{"title":"Project_Default.xml <span style='color:#111;'> 1.41KB </span>","children":null,"spread":false}],"spread":true},{"title":"modules.xml <span style='color:#111;'> 254B </span>","children":null,"spread":false},{"title":"vcs.xml <span style='color:#111;'> 180B </span>","children":null,"spread":false}],"spread":true},{"title":"dir","children":[{"title":"sql.txt <span style='color:#111;'> 370B </span>","children":null,"spread":false},{"title":"user1","children":[{"title":"user.info <span style='color:#111;'> 95B </span>","children":null,"spread":false},{"title":"db1","children":[{"title":"table1","children":[{"title":"table1.index <span style='color:#111;'> 2.61KB </span>","children":null,"spread":false},{"title":"table1.dict <span style='color:#111;'> 80B </span>","children":null,"spread":false},{"title":"data","children":[{"title":"1.data <span style='color:#111;'> 356B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"table2","children":[{"title":"table2.dict <span style='color:#111;'> 71B </span>","children":null,"spread":false},{"title":"table2.index <span style='color:#111;'> 3.11KB </span>","children":null,"spread":false},{"title":"data","children":[{"title":"1.data <span style='color:#111;'> 332B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"employee","children":[{"title":"employee.index <span style='color:#111;'> 33.89KB </span>","children":null,"spread":false},{"title":"employee.dict <span style='color:#111;'> 127B </span>","children":null,"spread":false},{"title":"data","children":[{"title":"3.data <span style='color:#111;'> 935B </span>","children":null,"spread":false},{"title":"5.data <span style='color:#111;'> 949B </span>","children":null,"spread":false},{"title":"1.data <span style='color:#111;'> 579B </span>","children":null,"spread":false},{"title":"2.data <span style='color:#111;'> 952B </span>","children":null,"spread":false},{"title":"4.data <span style='color:#111;'> 925B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"table3","children":[{"title":"table3.index <span style='color:#111;'> 941B </span>","children":null,"spread":false},{"title":"data","children":[{"title":"1.data <span style='color:#111;'> 15B </span>","children":null,"spread":false}],"spread":true},{"title":"table3.dict <span style='color:#111;'> 24B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"README.md <span style='color:#111;'> 3.32KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}]

评论信息

免责申明

【只为小站】的资源来自网友分享,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【只为小站】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,zhiweidada#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明