On the design of base tables in the SQL Databases of some existing software
E Eessaar - Computer Science On-line Conference, 2022 - Springer
We investigated the quality of database conceptual schemas of PostgreSQL databases of
four existing programs, three of which were open source. We automated the process with a …
four existing programs, three of which were open source. We automated the process with a …
Using SQL queries to evaluate the design of SQL databases
E Eessaar, J Voronova - New Trends in Networking, Computing, E …, 2015 - Springer
The system catalog of a database with explicit schemas contains among other things
information about the structure of the database. Queries based on the system catalog allow …
information about the structure of the database. Queries based on the system catalog allow …
On query-based search of possible design flaws of SQL databases
E Eessaar - Innovations and Advances in Computing, Informatics …, 2015 - Springer
Abstract System catalog, which is a part of each SQL database, is a repository where the
data in its base tables describes the SQL-schemas (schemas) in the database. The SQL …
data in its base tables describes the SQL-schemas (schemas) in the database. The SQL …
Automating detection of occurrences of PostgreSQL database design problems
E Eessaar - Databases and Information Systems: 14th International …, 2020 - Springer
SQL is a very resilient and widely used software language. In case of building a SQL
database, one has to design schemas of the database so that the database management …
database, one has to design schemas of the database so that the database management …
[图书][B] What Is Database Design, Anyway?
CJ Date, CJ Date - 2019 - Springer
An early version of this appendix appeared as a foreword to the book Oracle SQL Developer
Data Modeler for Database Design Mastery, by Heli Helskyaho (Oracle Press, 2015), and a …
Data Modeler for Database Design Mastery, by Heli Helskyaho (Oracle Press, 2015), and a …
SQL: Beauty and the Beast
S Ardeleanu, S Ardeleanu - Relational Database Programming: A Set …, 2016 - Springer
SQL: Beauty and the Beast | SpringerLink Skip to main content Advertisement SpringerLink
Account Menu Find a journal Publish with us Track your research Search Cart Book cover …
Account Menu Find a journal Publish with us Track your research Search Cart Book cover …
Stored Procedures
J Brimhall, D Dye, J Gennick, A Roberts… - SQL Server 2012 T-SQL …, 2012 - Springer
Almost every database has one thing in common: they all use tables to store data. In this
chapter, I'll present recipes that demonstrate table creation and manipulation. Tables are …
chapter, I'll present recipes that demonstrate table creation and manipulation. Tables are …
[PDF][PDF] DBLint: A Tool for Automated Analysis of Database Design
B Krogh, A Weisberg, M Bested - 2011 - projekter.aau.dk
Evaluating the quality of a database schema by manual review is timeconsuming, error-
prone and requires a good overview. To accommodate these problems, we propose DBLint …
prone and requires a good overview. To accommodate these problems, we propose DBLint …
Relational Database Principles
N Matthew, R Stones - … Databases with PostgreSQL: From Novice to …, 2005 - Springer
In this chapter, we considered how a single database table is much like a single
spreadsheet, with four important differences: All items in a column must have the same type …
spreadsheet, with four important differences: All items in a column must have the same type …