Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is meant by schema comparison?

April 26, 2017comparison meant schema

0

10 Posted

What is meant by schema comparison?

1 Answer

0

Posted

Schema comparison simply means comparing two database schemas to determine structural differences. The data contained in these schemas (if any) is not compared. Applications often span more than a single schema. TOYS allows comparison of one logical database against another logical database. Each logical database is one or more schemas. If you had a financial application, you might have General Ledger, Accounts Receivable and Accounts Payable installed in Oracle schemas “GL”, “AR” and “AP” respectively. TOYS allows you to compare these to some reference schemas on an individual basis (that is to compare say “GL” to reference “GL” and then in a separate comparison, compare “AP” with “AP”, etc.). Alternatively, TOYS allows you to compare all schemas in the application as a single logical database.