The tag has no usage guidance.

learn more… | top users | synonyms

10
votes
1answer
503 views

Do databases make a delete and an insert when having to update rows?

So today a professor told us that when the database has to make an update, internally (at low level) it makes a delete and then an insert with the updated fields. He then said that this is something ...
1
vote
2answers
50 views

Is there a sql database engine that support “specific value duplicate restriction”?

For example, in the brand column of a product database, the brand value "unknown" should only exist once while other brand values can exist many times. Is there a sql database engine that supports ...
0
votes
0answers
63 views

MariaDB engine choice (Aria vs. XtraDB

I am trying to choose the better of two engines for my particular application: I want to have the DB in Raspberry Pi 1 model B, on a USB pendrive. Limitations are pretty obvious: slow storage access, ...
0
votes
1answer
44 views

Database engine that share a row among multiple tables

I'm wondering whether exists any database engine that can share cells or rows amongst many tables. For example: TABLE Customer ( CID: int Fullname: nvarchar(50) Age: int ) TABLE Group ( ...
1
vote
1answer
1k views

InnoDB to MyISAM Conversion Problem

I have a dedicated server based on CentOS 5 OS , mysql 5 and phpmyadmin I was trying to convert all database tables from InnoDB to MYISAM. I tried to do it by setting in /etc/my.cnf file the value ...
3
votes
1answer
785 views

Alter mysql database engine doesn't work from cluster to other

I got into this issue when I tried to alter my database table engine to InnoDB from ndbcluster, It did not work. But When I changed engine from InnoDB to ndbcluster it worked. It did not throw any ...
1
vote
1answer
2k views

Constraint based rules engine

I am evaluating software systems which configure products that tout constraint based versus rules based engines. Can someone explain (with maybe an example or two) to a non-expert what the difference ...
1
vote
1answer
1k views

What are some good methods of structuring a MySQL audit trail to be both immutable, and perform well for usage?

In one application, we have an audit table that uses the ArchiveEngine in conjunction with a few triggers to capture 100% of the changes that occur. The upside to this is that 20+ million rows ...
8
votes
2answers
4k views

What exactly is a database engine?

I have gone through the definition on http://en.wikipedia.org/wiki/Database_engine several times: A database engine (or "storage engine") is the underlying software component that a database ...