Questions tagged [feature-comparison]

Examining a capability of something to determine its functionality, pros, and cons with respect to a similar alternative.

Filter by
Sorted by
Tagged with
-2 votes
0 answers
32 views

Are there any in-memory OLTP features available in SQL Server 2022 but not SQL Server 2019?

I know that in-memory OLTP has a lot of new features in SQL Server 2016, but I have heard nothing since then. Are there any in-memory OLTP features available in SQL Server 2022 but not SQL Server 2019?...
J. Mini's user avatar
  • 133
4 votes
2 answers
3k views

Are views logically redundant?

Earlier today, I realised that I had made a very stupid mistake. Rather than write a view, I wrote a parameterless inline table-valued function. This got me thinking: Interface aside, is there any ...
J. Mini's user avatar
  • 133
1 vote
3 answers
85 views

What is the Postgres Equivalent of SQL Server's Query Store?

I consider Query Store to be the best idea that Microsoft's SQL Server has had in the past ten years. I worry that I will miss it very dearly when I move to Postgres. What equivalents does Postgres ...
J. Mini's user avatar
  • 133
1 vote
1 answer
97 views

Why should I prefer Invoke-DbaQuery to its alternatives?

The documentation for Invoke-DbaQuery mentions many other similar functions This function is a wrapper command around Invoke-DbaAsync, which in turn is based on Invoke-SqlCmd2. It was designed to be ...
J. Mini's user avatar
  • 133
4 votes
1 answer
15k 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 ...
Déjà vu's user avatar
  • 473
39 votes
8 answers
84k 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(...
Evan Carroll's user avatar
-1 votes
1 answer
859 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 "...
Sybil's user avatar
  • 2,488
-1 votes
2 answers
116 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 ...
ctutte's user avatar
  • 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....
Roni Vered's user avatar
3 votes
0 answers
651 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 ...
Martin's user avatar
  • 2,420
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. ...
alfonx's user avatar
  • 827
1 vote
2 answers
751 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)...
Centurion's user avatar
  • 895
12 votes
5 answers
18k 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,...
SqlRyan's user avatar
  • 1,228
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 ...
ini's user avatar
  • 347
3 votes
2 answers
249 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 ...
a1ex07's user avatar
  • 8,990
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 ...
Michael's user avatar
  • 595
17 votes
3 answers
14k 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 ...
Ryan Charmley's user avatar
5 votes
2 answers
663 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 ...
A T's user avatar
  • 391
12 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 ...
Martin's user avatar
  • 2,420
7 votes
2 answers
541 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 ...
StanleyJohns's user avatar
  • 5,962
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 ...
rem's user avatar
  • 1,555
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 ...
René Nyffenegger's user avatar
22 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....
Joril's user avatar
  • 441
4 votes
1 answer
185 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 ...
user avatar
11 votes
3 answers
237 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 ...
TML's user avatar
  • 1,364
7 votes
6 answers
574 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 ...
TML's user avatar
  • 1,364
18 votes
3 answers
14k 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 ...
Leigh Riffel's user avatar
  • 23.9k
31 votes
3 answers
18k 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 ...
Yasir Arsanukayev's user avatar
120 votes
11 answers
138k 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 ...
Maniero's user avatar
  • 2,728
18 votes
4 answers
9k 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 ...
indyK1ng's user avatar
  • 1,111