Questions tagged [feature-comparison]
Examining a capability of something to determine its functionality, pros, and cons with respect to a similar alternative.
27
questions
0
votes
0
answers
18
views
What's the practical difference between these two triggers?
Say I have a table with a column to inform whether its row is a default of the application or not:
CREATE TABLE IF NOT EXISTS "mytypes" (
"idx_type" INTEGER NOT NULL,
&...
- 123
0
votes
1
answer
3k
views
MariaDB and MySQL versions equivalence
Is there any kind of equivalence between MariaDB versions and MySQL versions?
Obviously the 2 DBMS are different, but I was hoping the MariaDB team to "catch up" with MySQL when starting a ...
- 395
34
votes
8
answers
61k
views
Does SQL Server support GREATEST and LEAST, if not what is the common workaround?
Reviewing this question it seems like that's a lot of work that shouldn't be needed. They're trying to extend a range with a date. In other databases, you would just use greatest and least..
least(...
- 55.7k
-1
votes
1
answer
702
views
why are NoSQL databases better suitable for container platforms (cloud)?
In the article from Linux-Magazin 04/2017 Relationale Datenbanken als Container (sorry German and paywall) there is written in conclusion that NoSQL DBs are better suitable for containers than the "...
- 2,178
-1
votes
2
answers
115
views
DBA responsibilities: should they include suggesting a database engine for a new project? [closed]
I need your opinion on a subject.
I have been working as DBA for a short time and I have been asked by the Project Manager which database engine I recommend for a new critical project. The options ...
- 69
2
votes
1
answer
1k
views
Does SQL Server have a reference partitioning equivalent?
Oracle 11g has introduced a new feature that is called Reference Partition.
Using reference partitioning, a child table can inherit the partitioning characteristics from a parent table.
http://www....
- 575
3
votes
0
answers
355
views
Why is dynamic pivoting not supported?
TL;DR What is the reason that in 2013 we still can't define a VIEW that displays some pivoted data with a dynamic column set.
TL;DR/2 Is pivoting data a denormalization technique?
First: Not going ...
- 2,391
4
votes
1
answer
5k
views
Using Solr/Lucene for searching non-text tables?
I am creating a web application to retrieve subsets of one large (4m rows) table. The 4m rows only change once a year. The table has 200+ columns of types boolean and numeric. It has no text columns.
...
- 707
1
vote
2
answers
629
views
What are the alternatives for prefixed indexes in Oracle?
You can create an index and define prefix length, so the index will store only first starting symbols from each of column value. It looks like this in MySQL:
CREATE INDEX table_idx ON emp(last_name(8)...
- 895
12
votes
5
answers
17k
views
SQL Server equivalent to functionality of Oracle RAC? [closed]
I did some Googling and couldn't find an answer to this question more recent than a few years ago, so I thought I'd ask. Oracle's RAC feature offers load-balancing for both read and write transactions,...
- 1,218
2
votes
1
answer
4k
views
What are the differences between Cognos and SPSS modeler products?
My school wants to start doing some data mining, and probably go with an IBM product. I've done a fair amount of searching, but the differences between the two products seem cloudy to those of us who ...
- 347
3
votes
2
answers
230
views
How can I mimic functionality of SQL Server `TYPE` in Oracle?
I apologize if question title is vague, but I was not able to formulate it better. What I'd like to have is an alternative to TSQL CREATE TYPE, so I can use it in column definition.
For instance, I ...
- 8,661
10
votes
3
answers
7k
views
Where can I find example databases for MySQL, SQL Server and Oracle?
I want to experiment with the 3 large database management systems.
For this purpose it would be cool to have the same database (the same tables, etc.) for each of those.
Where can I find sql scripts ...
- 595
17
votes
3
answers
12k
views
PostgreSQL vs. MySQL: spatial feature comparison
We are the in the process of building out a web application that has a spatial data component. In the beginning our spatial data comparisons will take a given point and return matched overlapping ...
- 271
5
votes
2
answers
654
views
Learning Oracle, does it matter if I install 10g or 11g?
I'm taking a class in Databases, they're using Oracle 10g in class, but I'm having some trouble installing the database here in Windows 8 (auth problems), so I thought I'd attempt 11g.
Is 11g ...
- 391
13
votes
5
answers
3k
views
What features of Oracle make it an attractive choice for small projects?
Given Oracle's licensing handling[a] (and, to a lesser extent, cost) I have always been wondering what the deciding factors would be for choosing Oracle over PostgreSQL or MySQL.
My company is nearly ...
- 2,391
7
votes
2
answers
478
views
In Oracle, can we restore a database onto the same instance with a different name?
In SQL server I can restore a database onto the same instance with a different name. Eg: If there is a database DB_prod, I can take a full backup and restore it on the same instance with a different ...
- 5,928
17
votes
6
answers
4k
views
Redgate SQL Compare vs Visual Studio 2010 Premium/Ultimate database project
I currently use the Visual Studio Professional Edition which has the database project as a project template, but some of its features are not available, for example Schema Compare tool. The schema ...
- 1,505
7
votes
5
answers
5k
views
How different are the top DB vendor's SQL (DML-) dialects from each other?
Does someone who has worked extensibly SQL-wise with at least two top DB products (such as Oracle, SQL Server, Informix, Sybase, DB2, Teradata) know how different the DB vendor's SQL dialects are from ...
- 3,633
21
votes
4
answers
4k
views
Why won't some DBMS's allow rollback for certain DDL statements?
Recently I found out that MySQL doesn't support rollback of DDL such as "alter table"... Being used to PostgreSQL, that struck me as odd, but a friend of mine told me that even Oracle doesn't allow it....
- 431
4
votes
1
answer
181
views
Oracle setup required for heavy-ish load
I am trying to make a comparison between a system setup using Hadoop and HBase and achieving the same using Oracle DB as back end. I lack knowledge on the Oracle side of things so come to a fair ...
FvV
11
votes
3
answers
233
views
Are there any database engines which will intuit the join condition based on the existing foreign keys?
It seems strange to me that, when I've defined a foreign key, the engine cannot use this information to automatically figure out the correct JOIN expressions, but instead requires me to re-type the ...
- 1,334
6
votes
6
answers
518
views
Which database engines will allow me to GRANT/REVOKE on a specific column?
If I have a table with a single column of sensitive data, and I want to grant broad use of the table without exposing that one column, I know that I can create a VIEW that gives them access to all the ...
- 1,334
18
votes
3
answers
12k
views
What other databases have a feature similar to Oracle's Flashback Query?
I am interested to know what other databases have features similar to Oracle's Flashback Query. It would seem that any database that supports MVCC could have the feature, but which do? SO has this ...
- 23.5k
27
votes
3
answers
17k
views
Mnesia: advantages and differences
What are the advantages of Mnesia over major SQL database implementations and how it differs to them?
Can I use the database to hold really huge amounts of data without noticeable performance ...
- 3,055
106
votes
11
answers
113k
views
When to use NULL and when to use an empty string?
I'm interested mainly in MySQL and PostgreSQL, but you could answer the following in general:
Is there a logical scenario in which it would be useful to distinguish an empty string from NULL?
What ...
- 2,538
17
votes
4
answers
8k
views
Traversing tree-like data in a relational database using SQL
Is there a way to traverse tree data in SQL? I know about connect by in Oracle, but is there another way to do this in other SQL implementations? I'm asking because using connect by is easier than ...
- 1,101