MiniSQL

1/5MiniSQL1SQL(DBMS)MiniSQLSQL////MiniSQL22.1intchar(n)floatchar(n)1=n=25532uniqueB+uniqueSQL/B+B+and2.2MiniSQLSQLSQLSQLcreatecreatecreatetable(,,,primarykey());createtablestudent(snochar(8),snamechar(16)unique,2/5sageint,sgenderchar(1),primarykey(sno));droptable;droptablestudent;createindexon();createindexstunameidxonstudent(sname);dropindex;dropindexstunameidx;select*from;select*fromwhere;opandopandopop===select*fromstudent;select*fromstudentwheresno=‘88888888’;select*fromstudentwheresage20andsgender=‘F’;insertintovalues(1,2,,n);insertintostudentvalues(‘12345678’,’wy’,22,’M’);deletefrom;deletefromwhere;3/5deletefromstudent;deletefromstudentwheresno=‘88888888’;MiniSQLquit;SQLexecfile;SQL8SQLMiniSQLSQL33.1MiniSQL1MiniSQL3.23.2.1InterpreterInterpreter1.àà2.4/5API3.2.2APIAPISQLInterpreterInterpreterCatalogManagerRecordManagerIndexManagerCatalogManagerInterpreter3.2.3CatalogManagerCatalogManager1.2.3.CatalogManagerInterpreterAPI3.2.4RecordManagerRecordManager3.2.5IndexManagerIndexManagerB+B+B+B+3.2.6BufferManagerBufferManager1.2.3.4.pinI/O4KB8KB3.2.7DBFilesDBFilesCatalog43-51.20%30%50%2.5/53.4.5.InterpreterAPIInterpreterAPICatalogManagerIndexManagerRecordManager6.7.8.