Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [database-engine]

25 questions
18
votes
2 answers

What exactly is a database engine?

I have gone through the Wikipedia definition several times: A database engine (or "storage engine") is the underlying software component that a database management system (DBMS) uses to create, read, update and delete (CRUD) data from a…
Lazer
  • 3,361
  • 15
  • 43
  • 53
15
votes
1 answer

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 made across all databases and then I started a…
Pablo Matias Gomez
  • 253
  • 1
  • 6
12
votes
5 answers

How to check what Database Engine is installed on the DataBase server that I have acces to run queries on?

I want to check what type of sql is running on a Datasase server that I can access. I only have access to a web interface and a list of tables. Through the interface I can run queries on the tables that are present on a list. How can I get more…
yoyo_fun
  • 255
  • 1
  • 2
  • 7
6
votes
3 answers

How database engine of SQL swap two columns values?

I want to swap values of two columns in a table, And I found that in SQL we can do that by using Update: update the_table set first_name = last_name, last_name = first_name; It works But I wonder How SQL can do that without overwrite data in a…
TAHER El Mehdi
  • 292
  • 2
  • 9
3
votes
1 answer

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 error but did not work. I just want to know why this…
Ajay Bhojak
  • 151
  • 6
3
votes
2 answers

How to connect to a local SQL Server instance by IP Address in SQL Server Management Studio?

I'm writing some test code that is required to connect to a local SQL Server instance (SQL Server 2017 - Developer Edition) by IP address. I have the SQL Server instance up and running on my machine, but can't figure out the correct IP + Port to use…
J.D.
  • 40,776
  • 12
  • 62
  • 141
2
votes
2 answers

Differences between EDU and thread

In DB2, there is this command that shows active EDUs (engine dispatchable units): db2pd -edus There are two fields in the respective output: EDU ID and TID. According to this db2pd page from the DB2 knowledge center, each is defined as…
user164007
1
vote
1 answer

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 occupies 145MB, not to mention that ArchiveEngine only…
Bryan Agee
  • 801
  • 1
  • 8
  • 16
1
vote
1 answer

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 skip-innodb Afterwards, I found some errors in…
user209827
  • 13
  • 3
1
vote
1 answer

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 is? My guess is that a constraint based engine…
PMay
  • 11
  • 1
  • 2
1
vote
4 answers

Scalability of Postgres for table with large number of indexed columns

I have a Postgres table with a large number of indexed columns (roughly 100 indexed columns total, and yes, I need them all, and yes, they all need to be separately indexed). Any row update causes all indexes to be updated, which is a lot of work…
Luke Hutchison
  • 141
  • 7
1
vote
3 answers

Is there a mechanism inside of database engines to avoid collisions of non-sequential keys? If so, how does it work?

Say that I create a table that that has a random uuid for a primary key. Is there typically a mechanism inside of the database to gracefully deal with collisions? How does it work? My mind is picturing something simple like "generate a key and check…
RackAttack
  • 111
  • 1
1
vote
2 answers

Compatibility levels and reported engine versions

I'm seeking a bit of clarification around SQL Azure versions and upgrades. Upon trying to use some specific functionality it came to my attention that the compatibility level of the database was 100 (I needed 130). Upon looking a bit further I see…
slugster
  • 145
  • 1
  • 6
1
vote
0 answers

Non RAM based in-browser database solutions?

I want to decentralize my databases and upload it to Sia Skynet to give the users the ability to search on front-end. It is important to be able to deal with large amounts of data, but the RAM-based in-browser SQL engines (MiniSearch, AlaSQL, etc)…
DaWe
  • 119
  • 2
1
vote
1 answer

Connecting to database engine again when a new query or running view

When I connect to a server via SSMS, I can connect fine albeit a slow. When I click on a new query or try to run a view in a database on this server, the same prompt comes up but with everything greyed out and then after a while the prompt…
Stl
  • 21
  • 1
  • 2
1
2