Phase P9: Other topics (Performance, Security, …)

• Performance analysis of complex queries, indexes.
• Data security and protections.
• Other topics (propose for approval).

Create a wiki page called OtherTopics and use the structure from this template:

Other Topics

SQL Performance

Document performance analysis for each complex query that you have produced:

• Propose indexes that could improve the performance of the query.
• Document performance analysis using EXPLAIN PLAN to execute the query before the creation of the indexes, and after the creation of the indexes.
• Document whether the indexes were truly used in the execution plan
• Conclusion about the performance gains

Security measures

• Document the security measures you have introduced in your application related to database access (prevention of SQL injection, prevention of un-authorized access to data, …)

• Document the security measures you have introduced in your database related to database access (prevention of SQL injection in dynamic queries, prevention of un-authorized access to data, …)

Other developments

…

AI Use

You are free to use an AI to improve your work, provided that you adhere to the following rules:

• you use AI in this phase of the project only to improve your own initial work
• you use AI to create alternative ideas, that you can learn from and borrow and use in your own work
• you document the changes you have made to your own work based on the ideas from the AI tool in the history above
• you document the entire usage of the AI tool in a new wiki page named OtherTopicsAIUsage linked here, that you structure according to the following template

Other Topics AI Usage

Name of AI service/solution that was used

URL:

Type of service/subscription:

Final result

Diagram:

Results in details / description:

Entire AI usage log

1. Line-by-line Log of all interactions with the AI (prompt and response)
2. …