Ӧо
APPLICATION RESEARCH OF COMPUTERS
2000 Vol.17 No.3 P.43-44,65




ϵݿӻ
ӧ
ժҪϵݿм򵥡һݽṹͳѧۻõ㷺Ӧáǣݽṹļ򵥡һԶʧϢΪ۵ģԹϵݿĲ㣬һֽڻϵݽṹϵĿӻķʵֶԹϵݿ䡣
ؼʣϵݿ  ӻ
1
ϵģ;ϸѧϸߵĳ󼶱رļ򵥡һݽṹûʹãҲڻʵˣϵ͵DBMSΪݿϵͳк¿DBMS ͼеķֲʽDBMSǹϵ͵ġڼ򵥵ݽṹӵʵԵĲ㣬Ҫڲܺܺõʵƶ﷽棬Ҫ²㣺
ٲȻķʾʵϵϵģͨʾʵϵĹϵ򹫹ʾʵϵġʵϵʽģԹԵĶҲܴݽṹзӳ ּ򵥡һݽṹϲֳЩǱʾʵĹϵЩǱʾʵϵĹϵңȱʵϵʵвͬʵϵͬݽṹ
ڹϵģ͵ļ¼ԼϵڹϵеλҲ޷ڹϵݽṹбʾ˵ӶάʽĹϵݽṹ޷õԼϵȷϵһ棬ڵһʽϵģͻȱԱʵԵֵơԵԵȡ
ݽṹܺܺõԼԡ
Թϵģ͵⣬70Ⱥ˼ʮģͣдԵE-Rģ͡RM/Tģ͡ģ͡߼ģ͵ȡЩµģоҪѭ;һǶԹϵģ͸졢䡣ȻܽϺõ߼ʵּ仹ȱȻֱӵϵE-RģͣȻɽϺõģʵ磬ת߼ʽʱԴ(Ķʧ)һ;µģ͡еĹϵݽṹݵ⣬Ͼݽṹ̫󡣲µݽṹӣʵֵѶȺϵͳԴ⣬µģͶδ漰֧µ֧ݿơЩģͺʵϵͳеõӦõҪԭ򡣼ԴĹʮ־޴󣬽ݿӦϵͳĿҪɸרҵԱеҪµģӦûûֱӿΪˣݿϵͳиĽԹϵݿ䱾˼·
ݽṹϼݴͳĹϵݿ⣬ʹôԭеԴõãͨݵ壬ݵӦüֵ
ڽԹϵݽṹΪ߼洢ܣݿǰԿӻʽṩûûȫ߼ṹ͹ϸڣüʽ⡣
͹ϵݿӻеҪ̽֡
2ݿϢ
2.1ʵϢ
ʵ翴ʵɣĵʵйصУ
1)ʵ
ʵıʶ͡ԡܡṹ״̬Ϣ
2)ʵɵ
ʩʵϵĸֲϵĶ塣
3)ʵڲʵϵ
ϵͬϵɫϵϵ߼̺ϵȡ
4)ʵϵԼ
ڽṹԼĻԼͲԼȵ嶨塣
ʵơӦݿʵҪ塣Ҫָǣǲ޵ʽֶαȫʵ˷ḻ塣ˣʵӦȡӦѭз
ٸҪʵھɸѡ͹ࡣ
ͨԤȵķඨͼֶνʵ
۶ʵг󡢹鲢ԤʽĳݽṹĴ洢
2.2 ƺģʽļ߼ʵе͹ϵģ͵
ϵݿϵͳĸƽ׶ͨE-RģΪƹߡΪҪʵ˾DBMSE-RģȻȴͳģ͸Ȼģʵ磬Ȼ⣺
ĲܲҲûҪҪһģͱе壬E-RģȻδһЩҪġӦ壬ʱ䡢ռı仯ĸԡ״̬塣
E-RģͼģûṩġԶ()ܣҲûרŵԣE-Rģ޷ġɢġʶġ
E-RģͼģЯϢתΪϵģʱʧ磺ʵϵͬһݽṹʾʵ仯µϵʵϵı仯ڹϵģҲܵõӳʵԼĹϵҲʽرʾ嶪ʧԭǹϵģ͵ݽṹڼ򵥣һʼͲ-ʵģʵֵġԣ͹ϵģͱļԶԣȻĲ㡣ǣһӻǰ˵ĳ㣬пֱ۵رʾࡢḻϢˡ
2.3ڹϵģ͵
1)ݵԼ
Լ(Domain integrity constraint)ʵԼ(Entity integrity constraint)Լ(Referential integrity constraint)
2)ϵģʽƵ
ҪԼϵ壬(Functional dependency)ֵ(Multivalued dependency)(Join dependency)ȡ
ɴ˿ɼԹϵģ͵䣬Ӧؽ⣺һǽһֻƣʹܹܶرе壻ǽһֿûԸ䡣
3ϵݿӻĽṹ͹ԭ
3.1ݷֲͼ
ANSI/SPARCģ͹涨(ֱ䵽Ĳ)ͼЩͼûרŵı˵Ӹģ͵ĽǶȿϵݿҪ漰ͼеģʽģʽڲģʽԣΪϵݿ䣬ͼгӦͼǴݷֲͼͼ1

3.2ϵݿӻĽṹԭ
1)DBMS
DBMS䣬֧ģʽе嶨ģʽеӻֺ֧άӦڲģʽڲ洢DBMSʵӦǰˡģʽʾģʽ嶨ڲģʽڲ洢ӳ䣬ṩϢݲѯݿάĲ
2)ģʽ(ӻ嶨)
ͳݿƼģʽļ߼ʵֹɵģȲݿƵЧʺҲרҵԱؽݿƣ಻ϵͳ嶨͹ԣģʽ嶨ģʽһӻģʽ/ƶͬʱɡģʽƽ£
ٻڴ(Form)Ŀӻģʽ/嶨ģ
DBMSṩһؿӻģʽ/嶨ԪصĴ塣ô屾ṩԿӻģʽ/嶨ԪصɾĵȹṩһĻʵԪغԪؿ⡣
ڻʵԪغԪ
ģʽ漰ʵ塢ʵԡʵϵȳͺ͹ʵĳ(ʵıʶ͡ԡܡṹ״̬ʵڲʵϵԼʵȵ)ӦĻԪ(ͼ)ͨڴá塢ЩԪʵģʽƺӦıﶨ塣ṩŵܣûԶӻͼء
3)ģʽ
ڻڴĿӻģʽ/嶨ģУֱӶģʽӦ壬µģʽ塣
ģʽнģʽĵģʽ޶άDBMSģάģʽģʽе嶨һԡ
4)ӦòĿӻͲ
ӦòĿӻͨһڴĿӻѯǰʵ֡ÿӻѯǰ˰ٶSQLѯԹṹѯ(SSQL, Semantic Structural Query Language )SSQLݱ׼SQLͬʱṩΪĲѯڻĲڴֱʵֻѯõȲ
5)ڲ洢
ԿӻݽṹӦǵʽ࣬磺塢塢ȡԲͬ͵ԶӦĹϵ洢塣DBMSģԶģʽ嶨塢ɾڲ洢ӳ䡣
4
ǿϵݿϵݿƺӦģϵݿӻⷽ湤һֳԡĿӻڱ˼򵥡һĻϵݽṹĻϣһ㣬ͨһӳƽḻϢʽԼ򵥵ݽṹС⣬ĿӻڶԻϵݽṹܻʹһ¿ԱʹԱعĵײݽṹͨһܻ߹άݿģʽͻϵݽṹӳ䣬ʵҲרҵԱݿơ
ϵݿ⽫δݿⷢչĻȼݼΪװû(Ա)ṩ͸͸Ŀ/Ӧƽ̨⣬ĿӻʵҲڷֲʽϵͳInternetԴеõӦá
ӧ(ѧԺϵ ƽ353001)
ο
1 Adam, N. R. A Form-based Natural Language Frond-end to a CIM Database, IEEE Transactions on Knowledge and Data Engineering, Vol.9, Iss:2 p.238250
2 Lenke, N. Object-oriented Database Systems as the Basis for Machine-readable Lexicons, KONVENS'94. Verarbeitun
3  , , ܱ. WWWֲԴо-ģͺͲѯ. ѧ, 1998.6
4 ʯ,  ,  , ֣Զ. ģʽĲѯ. ѧ, 1998.5
5 Ωһ. ȵģ. ѧ, 1997, 8
6 ܱ. ݿϵͳ. ӹҵ, 1995.10, һ
ոڣ1999922
