뗚8뻭뗚4웚8No142009쓪11퓂ꆡ뮴틵쪦랶톧풺톧놨(ퟔ좻뿆톧냦)JOURNALOFHUAIYINTEACHERSCOLLEGE(NATURALSCIENCEEDITIONꆡVol1)ꆡꆡꆡꆡꆡꆡ싃폎쒿뗄뗘펪쿺쾵춳(DMS)훐틬릹쫽뻝벯돉훐볤볾뗄짨볆샮ퟚ뮨,컢뿋솦(뮴틵쪦랶톧풺볆쯣믺뿆톧폫벼쫵톧풺,붭쯕뮴낲ꆡ223300)햪ꆡ튪:럖컶쇋싃폎쒿뗄뗘펪쿺쾵춳(DMS)뗄쫽뻝뿢쿖ힴ,첽쳖쇋웤쫽뻝뿢풴뗄쳘뗣뫍싃폎헟ꆢ싃폎웳튵뛔쫽뻝벯돉뗄탨쟳.춨맽뛔늻춬쫽뻝벯돉랽낸뗄뇈뷏럖컶,닉폃믹폚WebSer2vice틬릹쫽뻝벯돉훐볤볾벼쫵,짨볆쇋DMS뗄틬릹쫽뻝벯돉훐볤볾,럖컶룃훐볤볾뗄짨볆쮼슷폫쪵쿖쇷돌.닻쫶쇋훐볤볾엤훃맜샭ꆢ닩톯릹퓬ꆢ닩톯럖뷢ꆢ닩톯횴탐뫍훘ퟩ뗈쒣뿩뗄짨볆.룃틬릹쫽뻝벯돉닟싔,뿉틔쪹DMS쾵춳쫽뻝뿢폫싃폎웳튵ퟔ짭쫽뻝뿢솬뷓,틔쪵쿖싃폎탅쾢풴뗄릲쿭.맘볼듊:DMS;틬릹쫽뻝벯돉;훐볤볾훐춼럖샠뫅:TP393ꆡꆡ컄쿗뇪쪶싫:Aꆡꆡ컄헂뇠뫅:167126876(2009)04202882050ꆡ틽퇔싃폎쒿뗄뗘펪쿺쾵춳쫇틔볆쯣믺죭ꆢ펲볾캪믹뒡,쪵쿖쒿뗄뗘룷훖싃폎풴ꆢ짨쪩폫럾컱뗄쫽뻝뫍뢨훺탅쾢뗄쫤죫ꆢ듦뒢ꆢ룼탂ꆢ닩톯ꆢ볬쯷ꆢ럖컶ꆢ풤뚩ꆢ펦폃뫍쿔쪾뗄뿕볤탅쾢쾵춳.웤훷튪쪹폃뛔쿳냼삨룷벶싃폎맜샭믺릹ꆢ싃폎쿠맘웳튵뫍늿쏅ꆢ싃폎쿻럑헟뗈.내헕럾컱뛔쿳뗄늻춬,뿉럖캪솽훖:튻훖쫇쏦쿲폎뿍뗄탅쾢쒣쪽,훷튪쫇캪폎뿍햹쪾룷훖싃폎쒿뗄뗘탅쾢,랽뇣폎뿍;쇭튻훖쫇쏦쿲싃폎쒿뗄뗘룷맜샭늿쏅벰싃폎릩펦짌뗄맜샭쒣쪽,쪵쿖룷늿쏅ꆢ룷탐튵횮볤뗄탅쾢룼탂ꆢ뒫뗝\[1\].DMS뗄춻돶쳘헷쫇뛔싃폎쒿뗄뗘뷸탐헻쳥탎쿳뗄쯜퓬뫍탻뒫,늢캪쒿뗄뗘뗄싃폎웳튵쳡릩췸짏붻틗욽첨,듙쪹쟸쓚룷싃폎웳튵ꆢ싃폎믺릹ꆢ쎽쳥퓚쟸폲뮷뺳뗄믹뒡짏탎돉쒿뗄뗘싃폎닺튵뗄뚯첬뮯췸싧쾵춳.퓚싃폎웳튵탅쾢뮯붨짨맽돌훐,평폚룷훖틲쯘,떼훂웳튵퓚랢햹맽돌훐믽샛쇋듳솿닉폃늻춬듦뒢랽쪽뗄튵컱쫽뻝,듓볲떥뗄컄볾쫽뻝뿢떽뢴퓓뗄췸싧쫽뻝뿢,릹돉쇋웳튵뗄틬릹쫽뻝풴.퓚DMS붨짨횮돵,룷듳훐탍싃폎웳튵붨짨뗄맜샭쾵춳닉폃늻춬뗄듦뒢쒣쪽.벴쪹뚼쫇맘쾵쒣쪽,떫쫽뻝뿢맜샭쾵춳늢늻튻훂,죧DB2ꆢOracleꆢSybaseꆢInformixꆢSQLServer뗈.룷벶싃폎탐헾맜샭늿쏅뗄쓚늿쫂컱맜샭쾵춳훐쫽뻝풴쯹틀삵뗄튵컱펦폃쾵춳ꆢ쫽뻝뿢맜샭쾵춳짵훁닙ퟷ쾵춳튲뚼늢늻튻훂.떱잰맺쓚뗄DMS췸햾믹놾짏닉폃벯훐쫽뻝맜샭뗄쒣쪽,평싃폎훷맜늿쏅쫕벯룷싃폎웳튵뗄탅쾢,좻뫳내헕춳튻뗄쫽뻝쒣쪽맜샭룷싃폎웳튵탅쾢,쪹뗃DMS쾵춳뗄붨짨릤ퟷ솿뻞듳ꆢ붨짨훜웚뎤,늢쟒폎뿍퓚DMS췸햾짏뿉믱뗃뗄뿉폃탅쾢튲뇈뷏폐쿞.죧퓚샋싾듳솬ꆢ쳬쳃쯕훝뗈DMS췸햾짏,폃뮧믹놾짏컞램쇋뷢쒳튻뻆뗪뗄쿪쾸쟩뿶.틲듋,폃뮧웚췻쓜릻춨맽DMS욽첨뛔죎틢싃폎뗘탅쾢쪵쿖춳튻닩톯,늢웚췻헢훖닩톯쓜릻캪폃뮧쳡릩튻룶춳튻뛸볲떥뗄럃컊쫽뻝뗄죫뿚.틲듋,폐뇘튪뛔DMS뷸탐뫏샭헻뫏,틬릹쫽뻝벯돉쫇튻훖폐킧뿉탐뗄랽쪽,늢쟒뿉틔뛔싃폎쒿뗄뚯첬뮯췸싧쾵춳쳡릩뿉탐뗄뷢뻶랽낸.1ꆡDMS뗄틬릹쫽뻝벯돉랽낸럖컶쫽뻝벯돉쫇냑늻춬살풴ꆢ룱쪽ꆢ쳘뗣탔훊뗄쫽뻝퓚싟벭짏믲컯샭짏폐믺뗘벯훐,듓뛸캪웳튵쳡릩좫ꆡ쫕룥죕웚:2009209209ꆡ믹뷰쿮쒿:뮴낲쫐뿆벼횧독볆뮮쿮쒿(HAG09054216)ꆡퟷ헟볲뷩:샮ퟚ뮨(19812),얮,훘쟬죋,붲쪦,쮶쪿,퇐뺿랽쿲캪죭볾쾵춳럖컶벰훐볤볾벼쫵.
뗚4웚샮ퟚ뮨뗈:싃폎쒿뗄뗘펪쿺쾵춳(DMS)훐틬릹쫽뻝벯돉훐볤볾뗄짨볆289쏦뗄쫽뻝릲쿭.틬릹쫽뻝풴뗄쫽뻝헻뫏뫍벯돉뗄쒿뗄쫇캪DMS쳡릩벯돉뗄ꆢ춳튻뗄ꆢ낲좫뗄ꆢ뿬뷝뗄탅쾢닩톯ꆢ쫽뻝췚뻲뫍뻶닟횧돖럾컱.캪싺ퟣ헢퇹뗄탨쟳쳵볾,헻뫏ꆢ벯돉뫳뗄쫽뻝뇘탫놣횤튻뚨뗄벯돉탔ꆢ췪헻탔ꆢ튻훂탔뫍럃컊낲좫탔.퓚웳튵쫽뻝벯돉쇬폲,틑뺭폐쇋뫜뛠돉쫬뗄뿲볜뿉틔샻폃,쒿잰춨뎣닉폃솪냮쪽ꆢ믹폚훐볤볾쒣탍뫍쫽뻝닖뿢뗈랽램살릹퓬벯돉뗄쾵춳,헢킩벼쫵닠훘폚늻춬뗄ퟅ훘뗣뫍펦폃랽쏦뷢뻶쫽뻝릲쿭뫍캪웳튵쳡릩뻶닟횧돖.1)솪냮쫽뻝뿢쾵춳(FDBS).쫇튻룶뇋듋킭ퟷ좴폖쿠뮥뛀솢뗄떥풪쫽뻝뿢(춨뎣돆쿠뮥뛀솢퓋탐뗄쫽뻝뿢쾵춳캪떥풪쫽뻝뿢쾵춳,볲돆CDBS)뗄벯뫏.솪냮쫽뻝뿢쾵춳뗄훷튪쳘헷쫇,튻룶CDBS퓚볌탸놾뗘닙ퟷ뗄춬쪱뿉틔닎볓솪냮쾵춳뗄믮뚯.떥풪DBMS뗄벯돉뿉틔평솪냮쾵춳뗄폃뮧살맜샭,튲뿉틔평솪냮쾵춳뗄맜샭풱뫍떥풪DBS뗄맜샭풱릲춬맜샭,헻쳥쾵춳벯돉뗄돌뛈좡뻶폚솪냮쾵춳폃뮧뗄튪쟳,틔벰볓죫솪냮쾵춳늢릲쿭솪냮쾵춳쫽뻝뿢훐떥풪DBS뗄맜샭풱뗄튪쟳.냼몬뛠훖쫽뻝뿢쾵춳뗄FDBS웤쳘헷뮹쳥쿖퓚럖늼ꆢ틬릹뫍뛀솢3룶랽쏦.뿉볻,룃벼쫵평냫ퟔ훎쫽뻝뿢쾵춳릹돉,뿉틔춨맽춳튻뗄폯퇔럃컊쫽뻝풴,떫쫇웤뫋탄뇘탫뷢뻶쯹폐쫽뻝풴폯틥짏뗄컊쳢\[2,3\].2)쫽뻝닖뿢.쫽뻝닖뿢뿉틔붫룷훖쫽뻝헻뫏퓚튻룶훐퇫듦뒢뿢훐,웤듦뒢뿢훐냼삨쇋늻춬샠탍ꆢ늻춬쇬폲ꆢ늻춬뷡릹뗄뛠훖쫽뻝.캪쇋뇣폚쫽뻝쳡좡뫍럖컶,탨튪뛔쫽뻝닖뿢훐뗄쫽뻝뷸탐훘탂헻샭뫍업쇐.떱쫽뻝놻떼죫쫽뻝닖뿢뫳,뷨훺튻킩쫽뻝뿢솬뷓뫍닙ퟷ릤뻟,뇈죧솪믺럖컶뒦샭(OLAP)릤뻟,믹폚뷇즫뗄럃컊뿘훆랽램,쪹뗃늻춬샠탍뫍좨쿞뗄폃뮧뿉틔쟡쯉뗄닙ퟷ쫽뻝뿢늢뗃떽쯹탨뗄쫽뻝.쫽뻝닖뿢쯹싺ퟣ뗄쫇뻶닟뗄럖컶탨쟳,쫽뻝닖뿢뛔틑벯훐뗄쫽뻝뷸탐짮뛈럖컶틔췚뻲샺쪷쫽뻝훐틾몬뗄쟷쫆ퟟ쿲.떫쫇돉릦뗘쪵쪩튻룶쫽뻝닖뿢쿮쒿,춨뎣탨튪뫜뎤뗄쪱볤.죧맻쫽뻝룼탂늻벰쪱,퓲늻쓜싺ퟣ쪵쪱탔튪쟳룟뗄쫽뻝벯돉\[4\].3)훐볤볾쒣쪽.훐볤볾틔WebService뗄랽쪽뛔췢쳡릩붻뮥,Web펦폃뿍뮧뛋뫍웤쯼펦폃돌탲뿍뮧뛋듓늻춬뗄욽첨ꆢ늻춬뗄죭볾뾪랢뮷뺳뗷폃룃훐볤볾뗄WebService뷓뿚,듓뛸믱뗃살ퟔ늻춬쫽뻝풴뗄쫽뻝,쪵쿖쫽뻝뗄춸쏷럃컊.훐볤볾쫇쒿잰뇈뷏쇷탐뗄쫽뻝벯돉랽램,쯼춨맽퓚훐볤닣쳡릩튻룶춳튻뗄쫽뻝싟벭쫓춼살틾님뗗닣뗄쫽뻝쾸뷚,쪹뗃폃뮧뿉틔냑벯돉쫽뻝풴뾴캪튻룶춳튻뗄헻쳥.헢훖쒣탍쿂뗄맘볼컊쳢쫇죧뫎릹퓬헢룶싟벭쫓춼,늢쪹뗃늻춬쫽뻝풴횮볤쓜펳짤떽헢룶훐볤닣\[5,6\].닉폃훐볤볾뗄쒣쪽뷢뻶쫽뻝벯돉뻟폐솽듳폅뗣.웤튻,룃랽램늻탨튪룄뇤풭쪼쫽뻝뗄듦뒢뫍맜샭랽쪽,훐볤볾쾵춳쳡릩폃뮧튻룶좫뻖쒣쪽,폃뮧뿉틔늻뇘횪뗀쫽뻝풴뗄캻훃ꆢ뷡릹벰럃컊랽램뛸쪵쿖뛔룃쫽뻝풴뗄럃컊;웤뛾,WebService샻폃뇪ힼ췸싧킭틩(죧HTTP)뫍XML쫽뻝룱쪽뷸탐춨탅,뻟폐췪뫃뗄럢ힰ탔ꆢ쯉뫏ꆢ뿧욽첨뗄벯돉쓜솦뗈.퓚틬릹쫽뻝벯돉뮷뺳쿂,벯돉뗄뛔쿳쏦쇙늻춬폯퇔뫍늻춬욽첨뗄쒣탍.WebService뷡뫏쇋쏦쿲ퟩ볾랽램뫍Web벼쫵뗄폅쫆,샻폃뇪ힼ췸싧킭틩뫍XML쫽뻝룱쪽뷸탐춨탅,뻟폐솼뫃뗄웕쫊탔뫍쇩믮탔,죎뫎횧돖헢킩뇪ힼ뗄쾵춳뚼뿉틔놻뚯첬뚨캻틔벰폫췸싧짏뗄웤쯼WebService붻뮥,폃뮧뿉틔뗷폃죎뫎럾컱뛸컞싛쯼쏇뒦퓚뫎뒦.틲듋,닉폃믹폚WebService뗄틬릹쫽뻝벯돉훐볤볾릹붨쫇뷏캪샭쿫뗄쫽뻝벯돉랽낸,쓜릻뷏뫃뗄쪵쿖DMS쾵춳뗄뚯첬뮯릲쿭췸싧.2ꆡDMS쫽뻝벯돉훐볤볾뗄짨볆211ꆡ쾵춳짨볆쮼슷훐볤볾틔WEB럾컱뗄랽쪽뛔췢쳡릩붻뮥,WEB펦폃뿍뮧뛋뫍웤쯼펦폃돌탲뿍뮧뛋듓늻춬뗄욽첨,늻춬뗄죭볾뾪랢뮷뺳뗷폃룃훐볤볾뗄WEB럾컱뷓뿚,듓뛸믱뗃살ퟔ늻춬쫽뻝풴뗄쫽뻝,쪵쿖쫽뻝뗄춸쏷럃컊.헫뛔DMS쾵춳,룷싃폎웳튵,죧랹뗪ꆢ싃탐짧ꆢ닍틻ꆢ폩샖ꆢ뺰뗣(쟸)럖뇰낲ힰ벯돉훐볤볾,뷸탐놾뗘엤훃,럖뇰솬뷓ퟔ짭뗄탅쾢쫽뻝뿢,춬쪱엤훃폫웤쯼춬샠벯돉훐볤볾뫍놾뗘뗄DMS췸햾벯돉훐볤볾뗄솬뷓,듓뛸릹돉튻룶싃폎웳튵탅쾢릲쿭췸싧.폃뮧춨맽DMS쾵춳(췸햾)쳡릩뗄럾컱뷓뿚,춨맽죎튻훐볤볾,쳡붻닩톯,닩톯뺭맽럖뷢,슷평떽췸싧짏뗄웤쯼훐볤볾,횴탐,ퟮ훕략믘뷡맻룸뿍뮧뛋.212ꆡ쾵춳쳥쾵뷡릹DMS쾵춳닉폃럖닣쳥쾵뷡릹랽쪽,듓짏떽쿂뗄닣듎럖뇰캪폃뮧뷧쏦닣ꆢ펦폃럾컱닣ꆢ쫽뻝훐탄닣ꆢ
290뮴틵쪦랶톧풺톧놨(ퟔ좻뿆톧냦)뗚8뻭쫽뻝벯돉훐볤볾닣뫍쫽뻝뿢닣.웤쳥쾵뷡릹볻춼1.웤훐,폃뮧뷧쏦닣쳡릩Web뷓뿚뗄랽쪽,폃뮧뿉틔춨맽룃뷓뿚럃컊DMS쾵춳뗄뚯첬뮯췸싧쫽뻝탅쾢.쫽뻝벯돉훐볤볾쪵쿖췸싧짏틬릹쫽뻝뗄벯돉릦쓜,냼삨훐볤볾엤훃맜샭웷ꆢ닩톯릹퓬웷ꆢ닩톯럖뷢웷ꆢ풪쫽뻝맜샭웷뫍쫽뻝뮺듦맜샭.뗗닣캪쫽뻝뿢닣,냼삨쇋늻춬싃폎웳튵쟒샠탍늻튻훂뗄쫽뻝뿢,냼삨DB2ꆢOracleꆢSybaseꆢInformixꆢSQLServer뗈쫽뻝뿢.춼1ꆡ믹폚틬릹쫽뻝벯돉훐볤볾뗄DMS쾵춳쳥쾵뷡릹쾵춳뗄믹놾릤ퟷ쇷돌쫇:쫗쿈평훐볤볾엤훃맜샭웷뛔룷쫽뻝풴뷸탐엤훃ꆢ솬뷓뫍맜샭,좻뫳폃뮧뿉틔춨맽DMS췸햾뗄Web튳쏦쳡돶닩톯쳵볾,춨맽WebServer뷓뿚뗷폃쫽뻝벯돉훐볤볾.릹퓬웷룹뻝폃뮧쳡돶뗄닩톯튪쟳릹퓬쿠맘뗄SQL닩톯쳵볾,늢룹뻝SQL릹퓬웤폯램쫷.럖뷢웷룹뻝SQL닩톯쳵볾뛔웤뷸탐럖뷢뫍폅뮯,쪵쿖뿧뿢닩톯.횴탐뷡맻뫳,평뷡맻훘ퟩ웷훘ퟩ닩톯뷡맻,늢략믘Web튳쏦.213ꆡ쾵춳쒣뿩짨볆21311ꆡ훐볤볾엤훃맜샭웷훐볤볾엤훃맜샭웷쒣뿩훷튪쫇쪵쿖폫웤쯼훐볤볾믲헟틬릹쫽뻝풴횮볤뗄솬뷓릦쓜.웤릦쓜캪:1)엤훃떱잰훐볤볾뫍틬릹쫽뻝뿢뗄솬뷓탅쾢:냼삨쫽뻝뿢뗘횷,뗇슽쫽뻝뿢뗄폃뮧쏻,쏜싫,틔벰쫽뻝뿢쏻.췪돉듋쿮엤훃뫳,떱잰훐볤볾쓜릻쪹폃닩톯횴탐쒣뿩믱뗃뺭맽엤훃쫽뻝뿢훐뗄쿠맘쫽뻝.죧퓚놾뗘DMS쾵춳훐닩톯웤쯻DMS쾵춳쫽뻝뿢.2)엤훃떱잰훐볤볾뫍웤쯼훐볤볾뗄솬뷓탅쾢:냼삨솬뷓웤쯼훐볤볾뗄폃뮧쏻,쏜싫.췪돉듋쿮엤훃뿉틔쪹훐볤볾쪵쿖뮥솬,릹돉쫽뻝릲쿭췸싧.죧퓚놾뗘DMS쾵춳훐솬뷓놾뗘뗄싃폎웳튵쫽뻝뿢\[7,8\].21312ꆡ닩톯릹퓬웷캪쪵쿖닩톯뗄룟킧싊,닩톯릹퓬웷쒣뿩캪폃뮧쳡릩춳튻뗄뷧쏦쫓춼,룃쫓춼캪탩쓢쫓춼,쪵쿖쇋틬릹쫽뻝쒣쪽떽춳튻쫽뻝쒣쪽횮볤뗄펳짤.쪹뗃폃뮧늻탨튪쇋뷢듓쪲쎴뗘랽믱좡쫽뻝풴틔벰틔쪲쎴랽쪽믱좡쫽뻝.놾훐볤볾닉폃붨솢탩쓢쫓춼뗄랽램,쪵쿖뿧뿢솬뷓닩톯.헫뛔폃뮧쳡돶뗄닩톯쳵볾,뿉틔뷸탐놾뗘닩톯뫍럇놾뗘닩톯;뿉틔뷸탐떥룶쫽뻝풴닩톯뫍뛠룶쫽뻝풴닩톯,틔벰횸뚨쫽뻝풴닩톯뫍럇횸뚨쫽뻝풴닩톯.죴쪵탐뛠룶쫽뻝풴닩톯,웤닩톯쫽뻝풴쏻뛔펦쫽뻝뇭쏻,풼쫸쳵볾뿉틔닉폃ꆰANDꆱꆢꆰORꆱ뷸탐솬뷓,뛔뛠뇭뗄닩톯뿉틔쪹폃ꆰJOINONꆱ솬뷓.떱좻튲뿉틔쫇ퟩ뫏풼쫸쳵볾,떫튪힢틢웤폅쿈벶뗄컊쳢.틔폃뮧퓚DMS췸햾짏닩톯힡쯞탅쾢캪샽,폃뮧쳡돶닩헒ퟸ실퓚쒳쫐쟸뗄뛾탇벶틔짏뗄볛룱늻뎬맽300풪뗄뇪ힼ볤뻆뗪뗘횷벰뗧뮰.룃닩톯뗄SQL캪:ꆡꆡSELECTname,address,telꆡꆡFROMHotel,Roomꆡꆡ=ꆱ쫐쟸ꆱANDꆡꆡ>2ANDꆡꆡ<300ANDꆡꆡ=ꆱ뇪ힼ볤ꆱꆡꆡꆡꆡ룃닩톯폯뻤헫뛔떥룶쫽뻝풴쫽뻝뗄닩톯.21313ꆡ닩톯럖뷢웷닩톯럖뷢쒣뿩쫇뛔폃뮧쳡붻뗄닩톯뷸탐럖뷢,틔쳡룟횴탐킧싊.폃뮧쫤죫닩톯쳵볾틔뫳,룃쒣뿩쫗
뗚4웚샮ퟚ뮨뗈:싃폎쒿뗄뗘펪쿺쾵춳(DMS)훐틬릹쫽뻝벯돉훐볤볾뗄짨볆291쿈튪볬닩웤뫏램탔,웤볬닩훷튪헫뛔풼쫸ퟖ뛎뗄WHERE쳵볾,죧><2뗄닩톯쳵볾,죧맻돶쿖럇램뗄쳵볾,퓲룦쯟폃뮧웤닩톯쟫쟳늻뫏샭.횻폐춨맽볬닩뗄닩톯닅뿉틔퓚닩톯럖뷢쒣뿩뷸탐닙ퟷ.닩톯럖뷢내헕틔쿂풭퓲뷸탐:풭퓲1:뛀솢닩톯럖쇑:틔쯹탨솬뷓훐볤볾캪떥캻,붫닩톯럖뷢캪튻ퟩퟓ닩톯,쎿튻ퟩퟓ닩톯뚼뛔펦튻룶떥뛀뗄쫽뻝풴.풭퓲2:틀헕쿠맘탔뷸탐뛠뿢닩톯럖쇑:솽룶훐볤볾쫽뻝탨튪뷸탐욥엤뗄닩톯쫗쿈럖뷢캪뛔웤훐떥튻훐볤볾뗄뛀솢ퟓ닩톯,좡돶룃뛀솢ퟓ닩톯뗄뷡맻쫽뻝짺돉욥엤쇭튻훐볤볾쫽뻝뗄ퟓ닩톯,듓뛸쪵쿖솽룶훐볤볾쯹솬뷓쫽뻝탨튪욥엤뗄닩톯닙ퟷ\[7\].춬퇹,틔폃뮧퓚DMS췸햾짏닩톯힡쯞탅쾢캪샽,폃뮧쳡돶닩헒ퟸ실퓚쒳쫐쟸뗄뛾탇벶틔짏뗄볛룱늻뎬맽300풪뗄뇪ힼ볤뻆뗪뗘횷벰뗧뮰.내헕룃풭퓲,릹퓬웤폯램쫷볻춼2:평폚폃뮧퓚DMS췸햾쳡돶틔짏닩톯튪쟳,웤닩톯뗄맽돌믡짦벰탭뛠싃폎뻆뗪뗄쫽뻝뿢.틲듋,내헕틔짏럖뷢풭퓲뛔틔뛠뿢닩톯뷸탐럖뷢.웤닩톯폯뻤캪:ꆡꆡCREATEVIEWHotelViewꆡꆡASselectnameascl,addressasc2,telasc3ꆡꆡ,ꆡꆡ=ꆱ쫐쟸ꆱANDꆡꆡ>2ANDꆡꆡ<300ANDꆡꆡ=ꆱ쫐쟸ꆱANDꆡꆡ>2ANDꆡꆡꆡ춼2ꆡ닩톯럖뷢폯램쫷쪾샽<300ANDꆡꆡ룹뻝럖뷢풭퓲,럖뷢죧쿂:쫗쿈,붫닩톯쳵볾럖샫돉뛀솢뗄ퟓ닩톯,늢캪탂뗄닩톯붨솢탩쓢쫓춼.ꆡꆡCREATEVIEWH1ViewꆡꆡASselectnameascl,addressasc2,telasc3ꆡꆡꆡꆡ=ꆱ쫐쟸ꆱANDꆡꆡ>2ANDꆡꆡ<300ꆡꆡCREATEVIEWH2ViewꆡꆡASselectnameascl,addressasc2,telasc3ꆡꆡꆡꆡ=ꆱ쫐쟸ꆱANDꆡꆡ>2ANDꆡꆡ<300웤듎,퓚뛀솢ퟓ닩톯뗄믹뒡짏뷸탐뿧뿢럖쇑닩톯,붫닩톯뷡뫏ퟩ뫏돉탂뗄탩쓢쫓춼.ꆡꆡCREATEVIEWHotelViewꆡꆡASꆡꆡSELECTH31View3.,H2View.ꆡꆡ닩톯뷡쫸,HotelView쫓춼훐볇슼닩톯뷡맻.21314ꆡ닩톯횴탐뫍뷡맻훘ퟩ웷놾뗘ퟓ닩톯뗄횴탐퓚놾훐볤볾훐닉폃OLEDB벼쫵쪵쿖,놾뗘ퟓ닩톯룹뻝늻춬뗄쫽뻝풴샠탍,볓퓘뛔펦뗄OLEDBPROVIDER,쪵쿖뛠룶쫽뻝풴뗄닩톯릤ퟷ.
292뮴틵쪦랶톧풺톧놨(ퟔ좻뿆톧냦)뗚8뻭횴탐닩톯뫳,닩톯뷡맻훘ퟩ쒣뿩쫕벯놾뗘ퟓ닩톯폫럇놾뗘ퟓ닩톯뗄뷡맻,좻뫳뒴붨튻룶뷡맻쫓춼볇슼헻룶뿧뿢닩톯쓚죝,늢틔DataSet뗄랽쪽짺돉XML컄볾뒫룸Web튳쏦,듓뛸췪돉헻룶닩톯쇷돌.3ꆡ킡뷡평틬릹쫽뻝벯돉훐볤볾릹돉뗄쫽뻝릲쿭췸싧뻟폐벫룟뗄쇩믮탔,웤쯻싃폎웳튵횻탨낲ힰ벯돉훐볤볾,엤훃뫍릲쿭췸싧뗄솬뷓뻍뿉틔뫜랽뇣뗄삩돤쫽뻝릲쿭췸싧.틔틬릹쫽뻝벯돉훐볤볾캪뫋탄뗄짨볆랽낸,쓜릻퓚튻뚨돌뛈짏룄뇤떱잰DMS췸햾훐붨솢춳튻쫽뻝뿢뗄쿖ힴ.믹폚듋,놾컄틔싃폎쒿뗄뗘펪쿺쾵춳DMS캪뛔쿳,ퟛ뫏뇈뷏쇋DMS뗄틬릹쫽뻝벯돉랽낸럖컶,닉폃틬릹쫽뻝벯돉훐볤볾쒣쪽릹붨쇋싃폎쒿뗄뗘펪쿺쾵춳뗄짨볆,릹붨쇋쾵춳뗄쳥쾵뷡릹쇷돌,뻟쳥럖컶쇋쾵춳뗄룷룶닣듎,닉폃쪵샽럖컶쇋웤믹놾쪵쿖랽쪽.룃랽낸뿉틔쪹뗃룷싃폎웳튵퓚햹쪾웤웳튵탅쾢쪱룼볓랽뇣,횻탨룼탂룶죋쫽뻝뿢쫽뻝뫳벴뿉,늻탨쯦쪱뗇슽룷DMS쏅뮧췸햾짏룼탂웳튵탅쾢.뛔폚싃폎헟뛸퇔,쓜닩톯떽ퟮ탂뫍룼캪좫쏦뫍쫽뻝탅쾢;뛔폚싃폎훷맜늿쏅살쮵,튲뿉틔폃룼랽뇣뗄맜샭룷싃폎웳튵.떫춬쪱,퓚좫맺싃폎웳튵풴뗄벯돉짏,튲탨튪뾼싇틬뗘쫽뻝뿢듳맦쒣ꆢ췸싧랱쎦뗈쟩뿶.틲듋,ퟛ뫏퓋폃룷훖쿈뷸뗄벼쫵,쪹닩톯뗄킧싊쳡룟뫍쾵춳탔쓜룄짆,퓲탨튪뷸튻늽뗄췪짆폫쳡룟.닎뾼컄쿗:\[1\]ꆡ훜뒺쇖,솺훐.싃폎맜샭탅쾢쾵춳\[M\]놱.뺩:뿆톧돶냦짧,2007,2102212.\[2\]ꆡ훜쓈쓈,싞뻼.퓚MIS쾵춳훐릹붨솪냮쫽뻝뿢뗄뷢뻶랽낸\[J\]볆.쯣믺릤돌폫짨볆.2006,27(22):429724299.\[3\]ꆡ샮뾡,샮폂.솪냮쪽틬릹쫽뻝뿢펦폃쾵춳뗄벯돉뿲볜뫍쪵쿖벼쫵뗄퇐뺿\[J\]볆.쯣믺펦폃퇐뺿.2001,4:19222.\[4\]ꆡ탬삼랼,헅듳쪥뗈.쫽뻝닖뿢뗄럃컊뿘훆닟싔퇐뺿\[J\]볆.쯣믺펦폃폫죭볾.2007,24(12):34235.\[5\]ꆡ헅뷠,슫뗂쳆.틬릹쫽뻝벯돉랽낸뗄폅뮯짨볆폫쪵쿖\[J\]볆.쯣믺뢨훺릤돌.2008,17(1):77280.\[6\]ꆡ뎣럡럥,쇵퇞.췸룱뮷뺳쿂뗄쫽뻝벯돉훐볤볾뗄짨볆폫쪵쿖\[J\]볆.쯣믺펦폃퇐뺿.2006,5:1312133.\[7\]ꆡ쯯폑닖,쯎닊샻.튻훖믹WebService뗄틬릹쫽뻝벯돉훐볤볾\[J\]컷.낲뿆벼듳톧톧놨.2008,23(1):972100.\[8\]ꆡ샮죳훞,쯎닊샻.킣풰췸룱쫽뻝벯돉훐볤볾쳥쾵뷡릹퇐뺿\[J\]컷.낲뿆벼듳톧톧놨.2006,26(4):,WUKe2li(SchoolofComputerScienceandTechnology,HuaiyinNormalUniversity,HuaianJiangsu223300,China)Abstract:ꆡByanalyzingthedatabaseofthecurrenttourismDestinationMarketingSystem(DMS),(HDIM)wasdesignedbasedontheWebServicetoconstructthetourismdestinationmarketingsystem,anditꆯ,themaincomponentsoftheHDIMasconfigurationmanagement,queryconstruction,querydecomposing,,:ꆡdestinationmarketingsystem;heterogeneousdataintegration;middleware[퓰죎뇠벭:샮뒺뫬]
