word版可編輯-數(shù)據(jù)庫(kù)設(shè)計(jì)文檔模板精心整理(參考版)
2025-05-16 22:40本頁(yè)面
【正文】 優(yōu)先級(jí) 優(yōu)化對(duì)象（目標(biāo)） 措施8 數(shù)據(jù)庫(kù)管理與維護(hù)說(shuō)明提示：在設(shè)計(jì)數(shù)據(jù)庫(kù)的時(shí)候，及時(shí)給出管理與維護(hù)本數(shù)據(jù)庫(kù)的方法，有助于將來(lái)撰寫出正確完備的用戶手冊(cè)。（ 2）當(dāng)優(yōu)化對(duì)象（目標(biāo)）之間存在對(duì)抗時(shí)，給出折衷方案。角色 可以訪問(wèn)的表與列 操作權(quán)限可訪問(wèn)所有表 完全控制權(quán)限例如：管理員角色 B7 優(yōu)化提示：分析并優(yōu)化數(shù)據(jù)庫(kù)的 “時(shí)－空 ”效率，盡可能地 “提高處理速度 ”并且 “降低數(shù)據(jù)占用空間 ”。每個(gè)角色擁有剛好能夠完成任務(wù)的權(quán)限，不多也不少。例如：用戶帳號(hào)采用 MD5 進(jìn)行數(shù)據(jù)加密后再錄入數(shù)據(jù)庫(kù)，以防止任何地方密碼的安全性要求。 防止用戶直接操作數(shù)據(jù)庫(kù)的方法提示：用戶只能用帳號(hào)登陸到應(yīng)用軟件，通過(guò)應(yīng)用軟件訪問(wèn)數(shù)據(jù)庫(kù)，而沒(méi)有其他途徑操作數(shù)據(jù)庫(kù)。例如：應(yīng)用級(jí)的用戶帳號(hào)密碼不能與數(shù)據(jù)庫(kù)相同，防止用戶直接操作數(shù)據(jù)庫(kù)。 ]：CREATE PROCEDURE Enter_storage_GetMaxIdASDECLARE TempID intSELECT TempID = max([ESID])+1 FROM [Enter_storage]IF TempID IS NULLRETURN 1ELSERETURN TempIDCREATE PROCEDURE Enter_storage_ExistsESID intASDECLARE TempID intSELECT TempID = count(1) FROM [Enter_storage] WHERE ESID=ESID IF TempID = 0RETURN 0ELSERETURN 1CREATE PROCEDURE Enter_storage_ADDESID int output,product varchar(50),date smalldatetime,num varchar(6),storageManagerId nvarchar(50) AS INSERT INTO [Enter_storage]([product],[date],[num],[storageManagerId])VALUES(product,date,num,storageManagerId)SET ESID = IDENTITYCREATE PROCEDURE Enter_storage_UpdateESID int,product varchar(50),date smalldatetime,num varchar(6),storageManagerId nvarchar(50) AS UPDATE [Enter_storage] SET [product] = product,[date] = date,[num] = num,[storageManagerId] = storageManagerIdWHERE ESID=ESID CREATE PROCEDURE Enter_storage_DeleteESID int AS DELETE [Enter_storage]WHERE ESID=ESID CREATE PROCEDURE Enter_storage_GetModelESID int AS SELECT ESID,product,date,num,storageManagerIdFROM [Enter_storage]WHERE ESID=ESID CREATE PROCEDURE Enter_storage_GetList AS SELECT ESID,product,date,num,storageManagerIdFROM [Enter_storage]CREATE PROCEDURE Exit_storage_GetMaxIdASDECLARE TempID intSELECT TempID = max([ExitStorageId])+1 FROM [Exit_storage]IF TempID IS NULLRETURN 1ELSERETURN TempIDCREATE PROCEDURE Exit_storage_ExistsExitStorageId intASDECLARE TempID intSELECT TempID = count(1) FROM [Exit_storage] WHERE ExitStorageId=ExitStorageId IF TempID = 0RETURN 0ELSERETURN 1CREATE PROCEDURE Exit_storage_ADDExitStorageId int output,product varchar(50),date smalldatetime,num varchar(6),storageManagerId nvarchar(50) AS INSERT INTO [Exit_storage]([product],[date],[num],[storageManagerId])VALUES(product,date,num,storageManagerId)SET ExitStorageId = IDENTITYCREATE PROCEDURE Exit_storage_UpdateExitStorageId int,product varchar(50),date smalldatetime,num varchar(6),storageManagerId nvarchar(50) AS UPDATE [Exit_storage] SET [product] = product,[date] = date,[num] = num,[storageManagerId] = storageManagerIdWHERE ExitStorageId=ExitStorageId CREATE PROCEDURE Exit_storage_DeleteExitStorageId int AS DELETE [Exit_storage]WHERE ExitStorageId=ExitStorageId CREATE PROCEDURE Exit_storage_GetModelExitStorageId int AS SELECT ExitStorageId,product,date,num,storageManagerIdFROM [Exit_storage]WHERE ExitStorageId=ExitStorageId CREATE PROCEDURE Exit_storage_GetList AS SELECT ExitStorageId,product,date,num,storageManagerIdFROM [Exit_storage]CREATE PROCEDURE Login_ExistsuserId varchar(10)ASDECLARE TempID intSELECT TempID = count(1) FROM [Login] WHERE userId=userId IF TempID = 0RETURN 0ELSERETURN 1CREATE PROCEDURE Login_ADDuserId varchar(10),password varchar(16),userName varchar(20),tel varchar(20),birthday smalldatetime,registerTime smalldatetime,type nvarchar(50) AS INSERT INTO [Login]([userId],[password],[userName],[tel],[birthday],[registerTime],[type])VALUES(userId,password,userName,tel,birthday,registerTime,type)CREATE PROCEDURE Login_UpdateuserId varchar(10),password varchar(16),userName varchar(20),tel varchar(20),birthday smalldatetime,registerTime smalldatetime,type nvarchar(50) AS UPDATE [Login] SET [password] = password,[userName] = userName,[tel] = tel,[birthday] = birthday,[registerTime] = registerTime,[type] =
研究報(bào)告相關(guān)推薦
鄂ICP備17016276號(hào)-1