DATABASE SECURITY IMPLEMENTATION

 DATABASE SECURITY

It is the mechanisms that protect the database against intentional of accidental threats. Database security should provide controlled and protected access to the members and also should preserve the overall quality of the data. This protects data from unknown access, prevent unauthorized disclosure and helps recover from hardware and software errors. Database security also refers to the measures used in protecting and securing a database or database management software from illicit use and vindictive threats. It is a broad term that includes a large processes, tools and methodologies that certain a security within a database environment.


There are ways database security is analyzed and implemented:

· Restricting of unknown access and use by implementing strong access and data management controls.


· Load testing and capacity testing of a database to make sure it does not crash in a user overload.


· Physical security of the database server and backup equipment from theft and natural disasters.




 DATABASE TOOLS


· Adminer - Adminer is a database controlling tool that permits you to manage database, table, columns, relations, index, users, permissions, and more from a web-based user interface.

· DBComparer - DB Comparer is a database comparison tool for studying the differences in Microsoft SQL Server record structures from an easy-to-use UI.

· EMS SQL Manager Lite for SQL Server - EMS SQL for SQL Server lets you to make and control SQL Server database objects and create, edit, execute and save SQL queries.

·FireBird - Firebird is a influential basis SQL relational database management system for Windows and Linux.

· SQuirel SQL - SQuirel SQLt is a JAVA-based database management tool for JDBC compliant database. Its allow you to view the database structure and problem SQL commands.

· SQLite Database Browser - SQLite Database Browser is an exposed source tool that allows you to make , design and edit databases files. Structures include the ability to make and modify database, table, index and record, search for accounts as well as import and export data

· DBeaver - DBeaver is an exposed source universal database tool for designers and database officers that has a low memory footprint. It maintenances JDBC compliant records such as MySQL, Oracle, PostgreSQL, SQL Server, Firebird, SQLite, and Sybase.



· DBVisualizer Free - DB Visualizer is a common database tool that permits you to manage a wide range of database including Oracle, Sybase, SQL Server, PostgreSQL, DB2, MySQL, Informix, H2, and SQLite.

· HeidiSQL - Heidi SQL is a database query tool that support MySQL , Microsoft SQL Server and PostgreSQL database. Its allow you to browse and control files, create and edit tables, views, processes, generates and scheduled events.

· FlySpeed SLQ Query - Fly Speed SQL Query is a database query tool that goals to make working with data easy. It supports common database servers such as MySQL, SQL Server, and Postgre SQL as well as office file formats like CSV and Excel.

Researchers :

· Ang, Francis Nicole G.
· Ferrer, James Dominic R.

· Suarez, Johnchris D.

Comments