Anyone know of a good tool that would scan a sql database to give it a quality rating based on table design, programmability (sp/functions/etc), relationships, etc.

Posting as :
works at
You are currently posting as works at

A human.

Tools can check indexes and various other things. A lot of the rest depends on the types of queries you’re running.

like

There are tools which can scan databases and report the performance, especially about index design. But there is no tool to recommend about data model design. That depends on what you are using the database for and so can be handled only by a data modeler. Erwin is a popular data modeling tool to reverse engineer a database and show you via an ER diagram the data model (logical model) . A good modeler can scan the ER diagram and grade the database design.

Coming to other design (physical models) that includes indexes, physical storage, performance etc, Every database vendor provides very sophisticated management tools that monitor, collect metrics to point at performance issues before they grow and recommend changes. These tools are usually owned and operated DBAs or Systems folks. They can give you a comprehensive report. Example is Oracle Enterprise Manager (OEM) for Oracle databases.

Speaking of tuning SQL queries, the same tool above can collect the stats, come up with “explain plan” to show how expensive each of the queries are and recommend indexing and how to rectify the query to make it faster.

There is no one AI tool to do it all ... yet.

like

TOAD is one of the better tools that a lot of DBAs use, but it is mostly for optimizing indexes and queries, not the other things. Normalization might be something you could objectively assess, but denormalization is usually done for optimization and highly dependent on how the database is used. Programmability and relationships are much more subjective once you get out of pure query optimization.

For query optimization though, TOAD can seem like magic. I’ve seen a DBA run it on a query and have it spit out a solution in a few minutes that increased performance 100x.

I agree with Partner 1 as a human is the best performance test for a database. I have seen the best database design be brought to its knees over some bad application code. TOAD can give you some good statistics. The real test is the User pushing the button on the app and the results return in a few seconds or take forever.

Normalize until it hurts. 6NF for life! 😂

Related Posts

What is comp like at a pension fund?

like
like
like

So I had been working as medical interpreter up to the early part of this year. Today, during an interview, the Director with whom I was interviewing genuinely urged me to consider pursuing a career as a PA or even attempt to go to medical school. I had considered it in passing before but today was about the third or fourth time that someone had earnestly nudged me in that direction. Has anyone here made such a career pivot before? I love working in healthcare, there’s nothing like it.

like

Has anyone hired an assistant ( virtual or otherwise) to help them with managing their life? Any tips/tricks/stories? I’m done with myself…..

like

Any suggestion is appreciated.

Post Photo
like

Saturday night... working on a PRD deck. Sunday is for year end. Is this real life??

like

I’m trying to get an estimated ideal of what my costs would be when moving to Chicago. How much do you spend a month on “going out” (before pandemic)? Specifically referring to going to restaurants, getting drinks, take out, and coffee. Not including transportation.

like

so turns out BLR office peeps are spreading covid to fellow coworkers… leadership plz send help

Why does nobody point out the hypocrisy of Democrats nominating Garland and now being against the nomination of a Justice in an election year?

likefunny

Best way to prepare for SHRM ?
Any tips or resources that helped you pass the exam?

like

Do bulge brackets still finger print & drug test as part of the background check process? Do they check credit, too?

like

Anyone available for fit prep tomorrow at 5 pm est?

like

If a lien was placed in one persons name on a property held in joint tenancy with survivorship and the party who’s name was on the lien (one of the joint tenants) dies what is the status of the lien?

My kid is old enough now to consider a Disney trip. I am in Chicago so more inclined to Florida. Any tips or thoughts?

like

Does anyone actually shop at the designer stores in the airports?

like

How many agencies that have spent the last year talking about Black Lives Matter/equality/diversity and then don’t do a very simple thing like closing in recognition of MLK Day?

likesmart

Working in a start-up and love having an impact on the product. Things have been too chaotic tho. Thinking of recruiting for a big tech company but not sure if it's for me- anyone willing to chat?

like

Does anyone in LA want to practice cases?

Additional Posts in Technology/IT Consultants

PDM at Deloitte and recently told my current PM that I receive an offer to be on a different project and would like to rolloff my current project. They told me they have to check their WOA before they can confirm my last date. Is this a legit reason or something they made up just so I can’t leave?

What does it take to get promoted from Level 7 to Level 6 in the SAP Products stream?

like

Do any of you use Jo Malone ?

Any suggestions on good books on consulting for reading during holidays

like

Do tech consultants make market rates? Maybe my perception is a bit warped because I’m getting paid 85k 3.5 YOE. Jumping to industry as a software engineer and will make 165k. Are consulting companies just shafting tech folks?

like

I am interested in getting the AWS Cloud Practitioner cert (foundational). I’m tech-savvy, but have not been involved in Cloud work. Any idea on how difficult the exam is?

like

@microsoft my spouse is starting a new job at Microsoft and want to buy him swag. How can I find some or buy something new off someone? The Microsoft merchandise store has a steep shipping price

like

Need suggestions: A newbie in ERP, Want to push for a cert to be specialized, but unsure which one to pursue that is worth the money and time:
Oracle, SAP, Salesforce, Workday

Please explain why whichever system suggested is the best choice!

likehelpful

Looking to specialize in privacy and was considering getting the CIPP/CIPM/CIPT. I already have my CISSP and CISA. Is it worth it?

like

EY and KPMG .. Federal practice at both.. what are working hours (45 ?).. which has better work culture and work life balance

like

How is Avanade’s manufacturing & supply chain ERP consulting practice?

like

Anyone familiar with Amazon's Solution Architecture team. Sounds like pre-sales /architecture type work. inputs on work, culture, pay, etc. appreciated

Tips to clear AWS solution architect professional exam. No background in AWS

like

Looking for 2 to 8 YOE for lateral hire in Technology consulting roles. Folks with red hat, open shift, RPA, BPM, Salesforce CRM, big data & Analytics experience and certification, DM me for referrals.

like

Anyone in IBM Expert Labs Canada?

Applying for entry-level consultant role and want to know more about the team! Thanks!

IBM

like

Hi guys, I have a table with customer information. Some entries are invalid. Way to find them out is by invalid customer name like ‘dguychjki’.. no definite rule. More so like you get to know that it does seem right. How best to extract such entries for further review? What condition do I put in where clause of sql?

like

Any interview prep advice for the SAP Senior Consultant position at EY ? First step is Hireviu questions with some written portion. What to expect for the Hireviu questions and the written part?

like

Making a switch form Android to iOS. Whats the best way to get my backup messages on to the new device ?

like

What company have you worked for that has the least amount of office politics?

like

Interviewing with Oracle for Senior Director role (Strategic Client group). 18+ yoe
How is the work culture and PIP at Oracle? I have a comp discussion planned this week, any insights into their salary structure will help - base, joining bonus, RSUs, etc...

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal