1 / 7

Student : Tigran Budaghyan Professor: Manana Khachidze

TBILISI STATE UNIVERSITY . Student : Tigran Budaghyan Professor: Manana Khachidze . Faculty of Exact and Natural Sciences “ DATABASE NORMALIZER AND TUNER ” . Tbilisi 2014. Main Relational Database Issues. Database Performance Issue Anomalies, data redundancies, misconfigurations

dacia
Download Presentation

Student : Tigran Budaghyan Professor: Manana Khachidze

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. TBILISI STATE UNIVERSITY Student: Tigran Budaghyan Professor: Manana Khachidze Faculty of Exact and Natural Sciences “DATABASE NORMALIZER AND TUNER” Tbilisi 2014

  2. Main Relational Database Issues • Database Performance Issue • Anomalies, data redundancies, misconfigurations • Security Vulnerabilities • Complicated Management • How to proceed??

  3. What am I suggesting? • By two words – Complex Database Analyzer • Facilitate the work of DBA’s • 2 Parts – Normalizer (Data) and Tuner (Instance) • Detects… • Anomalies and redundancies • Security Vulnerabilities • Misconfigured system configurations, buffers and caches • Database Fragmentations • Indexes • Not changing nothing, but giving only recommendations and scripts to execute manually

  4. How does it work? • Make a database connection • Read all tables column by column • Gives suggestions how to normalize in 2NF,3NF or BCNF (by choice) • Generates SQL Scripts for normalizing • Read database instance configurations from system tables, then database usages, in result gives recommendations • Lists all database users with permissions and warns if one of them does not have password assigned • Find index issues by looking in logs, warns if there are operations that performed without indexes • Find database fragmentations • Detects hardware configurations and warns if there are hardware lacks

  5. Supported Database Systems (for initial release) • MySQL • Oracle • MSSQL • MSACCESS

  6. Application Interface

  7. THANK YOU FOR YOUR ATTENTION!!

More Related