data-integrity
Preventing inapropriate rows from being inserted into SQL Server database
I have a table for tent rents with the following columns: RentID, DateStarted, DateEnded, CustomerID, etc.[详细]
2023-02-22 11:32 分类:问答DataSet Serialization Problem in .Net
I have a dataset containing several tables, which is populated from a stored procedure. I want to make it nested for the GetXml() method.[详细]
2023-02-21 17:41 分类:问答Data Integrity attack
I need to construct three examples of different kinds of attacks against the CIA model. Now C and A I had no problems finding lots material for, but I\'m having no luck at all[详细]
2023-02-17 18:16 分类:问答In a SQLite database is it better to use tirggers to handle cascading table changes, or is it better to do it programmatically?
Background I have a couple of projects that use a SQLite DB for data. The data stored in the databases are obviously stored across several tables, linked by key/foreign key values.[详细]
2023-02-15 00:40 分类:问答File integrity check
We have large sets (10+) of very large files (> 1 GB) that we share across our network. There are occasionally a few smaller files too.[详细]
2023-02-14 18:01 分类:问答MongoDB data integrity on a create command with a preceeding validation command
A website I\'m creating lets users have a unique subdomain on the site eg; gaz123.mywebsite.com. They enter their subdomain when they register on the site. In the code before I create the account re[详细]
2023-02-08 09:07 分类:问答Opening Hours Database Design
We are currently developing an application in which multiple entities have associated opening hours. Opening hours may span multiple days, or may be contained within a single day.[详细]
2023-02-06 12:25 分类:问答How to "test" MySQL server integrity?
I\'ve been having trouble with some of my sites on shared web hosting losing data bound for their respective MySQL databases. My provider doesn\'t provide access to the MySQL logs. They\'re having a s[详细]
2023-02-06 01:58 分类:问答Triggers: How can I make this integrity restriction in Oracle?
I want to make it so each time a register of type Pilot or type Flight_Attendant is added, a register of type Crew is added. I\'m working on Oracle\'s SQL Developer on top of 10开发者_开发知识库g, sho[详细]
2023-02-04 18:18 分类:问答column not null deferrable
In Oracle deferred constraints are checked only at the point of commit. What is the meani开发者_如何学Cng of DEFERRABLE clause in a case of NOT NULL constraint?[详细]
2023-02-04 13:13 分类:问答