Tag: rdbms

Found 77 results for 'rdbms'.

1) performance - in SQL databases does an update rewrite all columns in the row or only those in the SET tuple?
2) postgresql - Design: similar tables and foreign keys
3) locking - How does optimistic locking actually enforce re-read/update?
4) postgresql - Is normalizing further to index on INT FK rather than VARCHAR worth it?
5) postgresql - What are best practices for storing many iterations of a product in an RDBMS?
6) database-design - Organizing a comments table: How to justify the choice?
7) postgresql - Table design and query Optimization: Query to find the suitable work from a list of work items
8) mysql - Use MySQL to regularly do multi-way joins on 100+ GB tables?
9) database - Why don't relational databases support returning information in a nested format?
10) design - Should a surrogate key ever be exposed to a user?
11) database - Should I use NoSQL (MongoDB) or SQL (postgresql) database for my application?
12) database-design - Why should a column in a Relational Database have a single purpose?
13) java - Using MongoDB for not scalable application?
14) database-design - Is there a canonical source supporting "all-surrogates"?
15) sql - Why is filesystem preferred for logs instead of RDBMS?
16) database - Isn't data migration a major benefit of MongoDB compared to the commonly used relational databases?
17) web-development - Chat-service database design
18) architecture - Combining relational and document database for movies
19) sql - MongoDB: Replicate data in documents vs. “join”
20) database - Can traditional SQL databases be fully replaced by NewSQL?
21) mysql - Should I define the relations between tables in the database or just in code?
22) mysql - Type of Foreign Keys for a Dimensional Model Fact Table?
23) postgresql - Best approach to apply a long list of LIKE patterns?
24) synchronization - What's a good scheme for multi-user database synchronization?
25) mysql - Need help about giving relationships in database design
26) mysql - How to insert values in junction table for many to many relationships?
27) postgresql - _Batch_ priorities in PostgreSQL
28) sql-server - Database design appoach confirmation
29) mysql - Modelling the structure of a database involving products with multiple barcodes
30) performance - Why is optimistic locking faster than pessimistic locking?
31) database-design - Why can't I take RDBMS Database Design practices, and use for NoSQL MongoDB Database Designs?
32) sql-server - Storing daily yield curve data in SQL table
33) database-design - soft delete common attributes with regards to cascade recovery
34) primary-key - efficient primary key that does not expose business internals
35) object-oriented - Why aren't Object Oriented databases used as much as Relational Databases?
36) rdbms - Why a transaction retrieve the same row more than one time?
37) mysql - Restriction on self referencing on insert in MYSQL?
38) data-structures - What is a good datastructure for localizable tags? (Like a blog post or questions at SE getting tagged with)
39) mysql - MySQL very slow query when changing one WHERE field despite no index/key
40) database-design - Is it acceptable to have circular foreign key references\How to avoid them?
41) database-design - Using RDBMS with pseudo foreign keys VS using NoSQL solutions
42) oracle - Can inserting new rows make the RDB not use an index?
43) mysql - Should I repeat UNIQUE constraint on similar multi-index?
44) nosql - Inconsistency in Relational Databases
45) index - Why don't databases create their own indexes automatically?
46) mysql - Why do we need a Unique key when we have a Primary key?
47) database-design - Optimised Schema for City-to-City Distance Table
48) database-design - Database design: confuse on Len Silverston's concept
49) design - Why many designs ignore normalization in RDBMS?
50) mysql - How to achieve many to many relationship in this database design?