Examining a capability of something to determine its functionality, pros, and cons with respect to a similar alternative.
2
votes
1answer
80 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.
...
1
vote
0answers
56 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
votes
1answer
537 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.
...
1
vote
2answers
128 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 ...
0
votes
0answers
79 views
Evaluation of end user reporting tools and capabilities
I tried to find a reliable software review that compares the Reporting tools which provide end users to create their own reports. However couldn't find any. The reviews were either too old, or they ...
7
votes
4answers
3k views
SQL Server equivalent to functionality of Oracle RAC?
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 ...
2
votes
1answer
533 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 ...
3
votes
2answers
113 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
votes
3answers
3k 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 ...
4
votes
2answers
362 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 ...
11
votes
5answers
1k 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 ...
6
votes
2answers
296 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 ...
10
votes
5answers
2k 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 ...
3
votes
4answers
1k 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 ...
11
votes
4answers
1k 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 ...
3
votes
1answer
128 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 ...
9
votes
3answers
180 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 ...
6
votes
6answers
441 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 ...
12
votes
3answers
2k 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 ...
7
votes
4answers
6k views
Feature comparison: Oracle Database and Microsoft SQL Server
Many companies have a heavy influence on market and technologies around them, and you often compare the products before you choose, e. g. I liked Oracle APEX, its flexibility and features, and we're ...
4
votes
2answers
2k 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 ...
35
votes
7answers
6k 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 ...
15
votes
3answers
2k 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 ...
