On the Naming of Database Objects in the SQL Databases of Some Existing Software

E Eessaar - Computer Science On-line Conference, 2023 - Springer
Database users refer to database objects by using their identifiers, ie, names. Good names
of database objects facilitate understanding of the data in the database and its usage by …

Do People Use Naming Conventions in SQL Programming?

A Papamichail, AV Zarras, P Vassiliadis - … on Current Trends in Theory and …, 2020 - Springer
In this paper, we investigate the usage of naming conventions in SQL programming. To this
end, we define a reference style, consisting of naming conventions that have been proposed …

[PDF][PDF] Name management strategy for database integration

A Arcelus - 1990 - Citeseer
In this thesis, two cases of database integration are analyzed to study the problem of name
management. Name management is defined as the capability to recognize that two names …

Nested Named Sets in Information Retrieval

M Burgin, HP Zellweger - Advances in Data Science and Information …, 2021 - Springer
An important problem for databases is amplifying efficiency of human-database interaction.
This goal can be achieved on different levels where queries form the top level and data …

A tool for access to relational databases in natural language

N Papadakis, P Kefalas, M Stilianakakis - Expert Systems with Applications, 2011 - Elsevier
Many DB management systems use SQL syntax in order to provide a mechanism for data
accessing. Although SQL is widely used, its syntax is not very comprehensive to a typical …

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 …

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 …

Comparing database management systems with SQLAlchemy: A quantitative study on database management systems

M Fredstam, G Johansson - 2019 - diva-portal.org
Knowing which database management system to use for a project is difficult to know in
advance. Luckily, there are tools that can help the developer apply the same database …

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 …

[PDF][PDF] How to find sql server objects

A Kaushal - The Best of SQLServerCentral. com Vol. 3, 2005 - Citeseer
How many times do we as SQL developers or DBAs find ourselves shuffling through objects
in Enterprise Manager or expanding the left pane of Query Analyzer, trying to find a table or …