Skip to content
Free planNo credit card requiredStart writing
AI for Research home
AI for Research home
Dashboard
Sign inGet started

Search 250 million research papers

Read the abstract, see who wrote it and who cites it, and get the citation in APA, MLA, Chicago or Harvard.

About 10,000 papers for “Relational database”

Relational database

E. F. Codd · ACM eBooks · 2007

It is well known that the growth in demands from end users for new applications is outstripping the capability of data processing departments to implement the corresponding application programs. There are two complementary approaches to attacking this problem (and both approaches are needed): one is to put end users into direct touch with the information stored in computers; the other is to increase the productivity of data processing professionals in the development of application programs. It is less well known that a single technology, relational database management, provides a practical foundation for both approaches. It is explained why this is so.

Cited by 12Open access

learn2therm relational database

Evan Komp, Humood N. Alanzi, Ryan M. Francis et al. · Figshare · 2023

DescriptionA dataset of prokaryotes, proteins, organism pairs, and protein homologous pairs across temperature, up to 102 celsius. The data is presented in the form of a duckdb relational database, and contains 24 million proteins belonging to 9.5k prokaryotes. The proteins have been pairs by homology, producing 70 millions pairs of mesophilic-thermophilic proteins. Please see the README contained within the zipped file for instructions on usage and access of the relational data file. See the code repository, in this Figshare project and the main paper (TODO) for details on how this data was created<br>Contents`learn2therm.ddb` - duckdb file containing the data`environment.yaml` - minimal conda environment necessary to access the data`README.md` - instructions on accessing the data, including some example queries. Also contains the schema of the tables in the relational database.- `csvs/` , Colon-seperated dump files from the data tablesAll material in this project:- Database pipeline source code: 10.6084/m9.figshare.23589390- (here) Database: 10.6084/m9.figshare.23581932- Classifier source code: 10.6084/m9.figshare.23589210- Trained classifier: 10.6084/m9.figshare.23582325<br>ManuscriptTODO

Cited by 2Open access

learn2therm relational database

Komp, Evan, Alanzi, Humood, Francis, Ryan et al. · Figshare · 2023

DescriptionA dataset of prokaryotes, proteins, organism pairs, and protein homologous pairs across temperature, up to 102 celsius. The data is presented in the form of a duckdb relational database, and contains 24 million proteins belonging to 9.5k prokaryotes. The proteins have been pairs by homology, producing 70 millions pairs of mesophilic-thermophilic proteins. Please see the README contained within the zipped file for instructions on usage and access of the relational data file. See the code repository, in this Figshare project and the main paper (TODO) for details on how this data was created<br>Contents`learn2therm.ddb` - duckdb file containing the data`environment.yaml` - minimal conda environment necessary to access the data`README.md` - instructions on accessing the data, including some example queries. Also contains the schema of the tables in the relational database.- `csvs/` , Colon-seperated dump files from the data tablesAll material in this project:- Database pipeline source code: 10.6084/m9.figshare.23589390- (here) Database: 10.6084/m9.figshare.23581932- Classifier source code: 10.6084/m9.figshare.23589210- Trained classifier: 10.6084/m9.figshare.23582325<br>ManuscriptTODO

Cited by 0Open access

Relational database design

János Demetrovics, Attila Sali · SZTAKI Publication Repository (Hungarian Academy of Sciences) · 2007

Cited by 0

Relational database problems

Konstantin Alekseev · Кибернетика и программирование · 2020

The relevance of this article lies in the fact that today's databases are the basis of numerous information systems.&amp;nbsp;The information accumulated in them is extremely valuable material, and today database processing methods are widely spread in terms of extracting additional methods, knowledge from them, which are interconnected with generalization and various additional methods of information processing.The object of research in this work is relational databases and DBMS, the subject of research is the features of their use in applied programming.In accordance with the set goal, it is necessary to solve the following tasks:1) to consider the concept and essence of a relational database;2) to analyze the problematic aspects of relational databases in modern conditions. Relational databases are among the most widespread due to their simplicity and clarity at the creation stage and at the user level. It should also be noted that the main advantage of RDB is its compatibility with the main query language SQL, which is intuitive for users.Nevertheless, with all the variety of approaches, there are still some canons, violation of which greatly affects both the design of the database and its operation. For example, the problem of database normalization is very relevant. Neglecting normalization makes the database structure confusing and the database itself unreliable.Promising directions include the development of queries to a relational database using heuristic methods, as well as the method of accumulating previously optimized queries with subsequent verification of the derivability of the current query from the accumulated ones.Finally, a very slow decline in relational databases is probably happening. While they are still the primary storage medium, especially in large enterprise projects, they are gradually being replaced by non-relational solutions that will become the majority over time.

Cited by 0Open access

Relational database design.

David Wesley · PubMed · 2000

Relational databases are the predominant method for storing repetitive data in computers because they allow efficient and flexible storage of that data. While medical directors and underwriters are more likely to use a spreadsheet than a database program to analyze their business, the data they wish to study are often stored in corporate databases. Or the data may be complex enough to require being keyed into or downloaded into a personal computer (PC) database program for storage, even if the data are then output to a spread-sheet for numerical analysis. In many circumstances, one can benefit from an understanding of efficient database design. After a brief overview, the reader is led step-by-step through a practical explanation of database design, from a flat file to a relational model.

Cited by 2

A Method for Rough Relational Database Transformed into Relational Database

Wei Lingling, Wei Zhang · 2009

It is decomposed the data of rough relational database and transformed into relational database according to the characteristic of rough relational database and relational database and in virtue of multiplication principle and Descartes of basic operation of relational algebra. Then deleted redundant data and optimized RDB. Finally, it is designed translation arithmetic and applied in soil example, then proved the arithmetic validity.

Cited by 6