Top "Rdbms" questions

A relational database management system (RDBMS) is a database management system (DBMS) in which data is stored in tables and the relationships among the data are also stored in tables.

When to use CouchDB vs RDBMS

I am looking at CouchDB, which has a number of appealing features over relational databases including: intuitive REST/HTTP interface …

database couchdb rdbms
Can one make a relational database using MongoDB?

I am going to make a student management system using MongoDB. I will have one table for students and another …

mongodb relational-database rdbms
Two foreign keys referencing the same primary key

Is this okay to have two foreign keys in one table referencing one primary key of other table? EmployeeID is …

asp.net sql vb.net normalization rdbms
How to change a value of a field using MySQL Workbench?

I have installed MySQL Workbench and I have the following problem. I perform this simple select query: SELECT * FROM spring_…

mysql database mysql-workbench rdbms
SQL query for point-in-polygon using PostgreSQL

I have the following simple table: CREATE TABLE tbl_test ( id serial NOT NULL, poly polygon NOT NULL ) WITH (OIDS=…

sql postgresql gis rdbms postgis
Does MS-SQL support in-memory tables?

Recently, I started changing some of our applications to support MS SQL Server as an alternative back end. One of …

mysql sql-server rdbms portability
Why is Solr so much faster than Postgres?

I recently switched from Postgres to Solr and saw a ~50x speed up in our queries. The queries we run …

performance postgresql solr lucene rdbms
Difference between Relational Algebra and Relational calculus

What is the exact difference between relational algebra and relational calculus. At most of the reference, it will be Relational …

relational-database rdbms relational-algebra tuple-relational-calculus domain-calculus
Why NoSQL is better at "scaling out" than RDBMS?

I have read the following text in a technical blog discussing the advantages and disadvantages of NoSQL " For years, in …

nosql scalability rdbms
How can I check if the table behind a synonym exists

I'm trying to create a simple script to dump the results of a complex view out into a table for …

sql sql-server rdbms synonym