@liang-yao
Active 1 year, 2 months ago-
Liang Yao commented on the post, Week 3 Questions, on the site 8 years, 2 months ago
One reason database can provide fast query results is via indexing. How does index work? Can you find out and explain during the class?
-
Liang Yao commented on the post, Week 3 Questions, on the site 8 years, 2 months ago
From IT audit aspects, can you list a few key controls auditors must to take into consideration while auditing a relational database?
-
Liang Yao commented on the post, Week 3 Questions, on the site 8 years, 2 months ago
Any security implications or improvements?
-
Liang Yao commented on the post, Week 3 Questions, on the site 8 years, 2 months ago
Yu Ming – Can you provide an example of how normalization works during the class? Let me know. Thx
-
Liang Yao commented on the post, Week 3 Questions, on the site 8 years, 2 months ago
Correct. DBMS should be placed behind the firewall. However, they are not immune from the attacks. We will discuss the concept of “layers of defense” during this course.
-
Liang Yao commented on the post, Week 3 Questions, on the site 8 years, 2 months ago
Paul – Think about what controls can be implemented to mitigate those risks…let’s discuss during the class.
-
Liang Yao commented on the post, Week 3 Questions, on the site 8 years, 2 months ago
Can you think about a scenario that RDMS is not idea and bring to the class?
-
Liang Yao commented on the post, Week 3 Questions, on the site 8 years, 2 months ago
What types of relationship among tables? What’s the need to establish relationship among tables?
-
Liang Yao commented on the post, Week 3 Questions, on the site 8 years, 2 months ago
Sorry, miss-spelled your name, Priya.
-
Liang Yao commented on the post, Week 3 Questions, on the site 8 years, 2 months ago
Pyria, challenge question: prepare to discuss types of database constraints during the class.
-
Liang Yao commented on the post, Week 3 Questions, on the site 8 years, 2 months ago
not try to go too deep into application development territory, but do you familiar with multi-tier architecture for application development?
-
Liang Yao commented on the post, Week 3 Questions, on the site 8 years, 2 months ago
RDMS provides better security features…but controls need to be implemented to prevent unauthorized users’ access. Can you identify some security controls related to a database system and explain during the class? Thx
-
Liang Yao commented on the post, Week 3 Questions, on the site 8 years, 2 months ago
Said, prepare to elaborate each of the benefit listed during our next class…:)
-
Liang Yao commented on the post, Week 3 Questions, on the site 8 years, 2 months ago
How about the “relationship” please?
-
Liang Yao commented on the post, Week 3 Questions, on the site 8 years, 2 months ago
Correct. RDMS provides better security than unstructured data. However, it also made itself a target for malicious users. DBMS is usually an important IT audit entity within the audit universe.
-
Liang Yao commented on the post, Week 3 Questions, on the site 8 years, 2 months ago
Yes, RDMS provides better security feature, but not via spliting the data into tables…please research what RDMS can offer from secuerity aspect,..
-
Liang Yao commented on the post, Week 3 Questions, on the site 8 years, 2 months ago
What types of relationship may exist among tables within a database?
-
Liang Yao commented on the post, Week 3 Questions, on the site 8 years, 2 months ago
Through what process, a RDMS can reduce/eliminate redundant data?
-
Liang Yao commented on the post, Week 3 Questions, on the site 8 years, 2 months ago
please research what “data independent” means…
-
Liang Yao commented on the post, Week 3 Questions, on the site 8 years, 2 months ago
some of the risks you mentioned here were reduced significantly due to the technology advance in recently years. e.g. hardware and software resource requirement. 10 years ago, cost for storage and memory were very high, management needed to consider the resource allocation when implementing RDMS, but it changed significantly due to the low cost of…[Read more]
- Load More
