Development of the software for company. Database security

Слайд 2

Content ● Goals and tasks ● Overview of similar analogues ●

Content

● Goals and tasks
● Overview of similar analogues
● Tools for

tasks
● Architecture of program
● Prototype of program
Слайд 3

Goals are: • Protection of relational database against unauthorized access and

Goals are:
• Protection of relational database against unauthorized access and prevent

forms of unlawful interference with information resources;
• provide receiving of general and detailed reports about results of the database work ;
• provide receiving information without significant delay;
Tasks are:
•Implement user-client architecture
•Implement database and do some cryptography operations
•Monitoring database activity of users
•Two level of authentification

Goals and tasks

Слайд 4

Actuality In the modern world databases are widely used in application

Actuality In the modern world databases are widely used in application

software and web applications, providing a convenient solution for storing information. In some cases, this information may be harvested, so it needs to be protected.

Novelty
Software provide the ability to protect database through cryptography and two level authentication.

Слайд 5

1.the ability to selectively encrypt the database 2. the possibility of

1.the ability to selectively encrypt the database
2. the possibility of

monitoring.

Two-factor authentication system
Centralized management of authentication functions.

• Easy to deploy and manage
• Provide a complete collection of information
• Reducing risk by preventing attacks
• Management of database security with a centralized console

Слайд 6

Architecture of program

Architecture of program

Слайд 7

CLASS DIAGRAM OF PROJECT

CLASS DIAGRAM OF PROJECT

Слайд 8

4) Web-Server: 3) IDE : 2) Programming language : 1) DBMS :

4) Web-Server:

3) IDE :

2) Programming language :

1) DBMS

:
Слайд 9

ALGORITHM OF CRYPTOGRAPHY MD5

ALGORITHM OF CRYPTOGRAPHY MD5

Слайд 10

body { background: #c7b39b ; color: #343d46; background-size: cover; } Home





Home page


Login


Registration Form




Prototype of program: “Home page”

Слайд 11

label class="sr-only login-label" for="exampleInputEmail2">Login Password Enter Prototype of program: “Login page”

label class="sr-only login-label" for="exampleInputEmail2">Login










Prototype of program: “Login page”

Слайд 12

FIRST NAME LAST NAME EMAIL PHONE BIRTH DATE PASSWORD ADDRESS Prototype of program: “Registration page”

AUTOFOCUS>














Prototype of program: “Registration page”

Слайд 13

Слайд 14

Prototype of program: “second password page” UserDAOImpl dAOImpl = new UserDAOImpl();

Prototype of program: “second password page”

UserDAOImpl dAOImpl = new UserDAOImpl();

String fname = request.getParameter("fname");
String password = request.getParameter("password");
String code = request.getParameter("code");
System.out.println("Welcome" + fname + password);
if (fname != null && password != null && code!=null) {
if (dAOImpl.CheckLogin(fname, password)) {
if (dAOImpl.checkPass(code)){
Users u = dAOImpl.getUserDataByLogin(fname);
request.getSession().setAttribute("users", u);
}request.getRequestDispatcher("/userpage.jsp").forward(request, response); }
else {
response.sendRedirect("index.jsp?error=1");
}
}
else {
response.sendRedirect("index.jsp?error=1");
Слайд 15

Prototype of program: “Database”

Prototype of program: “Database”

Слайд 16

Conclusion Goals and objectives of this diploma project have been successfully

Conclusion Goals and objectives of this diploma project have been successfully carried

out. It was conducted market analysis and comparison of analogues that helped to create more high-quality product that helps protect the database. The project was realized on the windows platform using the javaee programming language. During the implementation of the project the analysis of methods, approaches, market situation analysis, labor safety and making the performance of the application were worked in the most optimal way.