Tagged Questions

0
votes
0answers
120 views

TPC benchmarks for MySQL and PostgreSQL database

Are there any existing TPC benchmarks for MySQL and PostgreSQL DBMS? Is there a lack of benchmarks just because it is too expensive to run or because the database performance is not up to par with ...
1
vote
1answer
1k views

oracle - grant all privileges to schema

i've used mysql before and i'm now switching to oracle. I've already created a user in oracle. Now i want to give it "all privileges" for a schema. In mysql i can give all privileges (DML/DDL) for a ...
5
votes
4answers
2k views

Why “Begin Transaction” before “Insert Query” locks the entire table?

I wrote a stored procedure to insert a record. I added "Begin Transaction" just above the Insert Query and execute the query. I noticed that another application that was showing a web page with ...
0
votes
4answers
542 views

SQL server Vs MySql vs Oracle for a large government project [closed]

I am in charge of deciding which database to use for a big government project with: 100 Million records (estimated in one big table) Availability and data reliability is paramount. Performance not ...
1
vote
1answer
69 views

lock table syntax from mysql to oracle

I've a mysql sql locking some tables with different permission (read or write). I've to adapt it for oracle, but I did't found any clear documentation to do this job right. this is an example: LOCK ...
3
votes
3answers
185 views

Is there a way to communicate DBMS with raw memory block or binaries

I am trying to communicate a numerical matrix operations library like LAPACK with any DBMS. Is it possible to send/receive complete matrices as binary or as a direct memory pointers to process them ...
1
vote
4answers
93 views

Database security

What aspects should be considered in order to have a secure database? Along with avoiding sqlInjection, what else should be considered? What should not be done?
0
votes
1answer
179 views

Configuring ASR and Oracle Clusterware

I have a four server cluster with Oracle Clusterware managing 4 MySQL instances on them. On failure Clusterware will move the MySQL instance to another server. I am on Proliant servers and also have ...
0
votes
5answers
3k views

What are the most popular database vendors based on market share? [closed]

I am wondering if anyone can point me to research or a link to statistics regarding popularity of database deployment. Obviously, MySQL, Oracle, SQLServer are some of the major players but I am ...
3
votes
3answers
176 views

Suggestions for spatial database systems [closed]

I'm looking for suggestions on a database for large sets of spatial master data. The data itself is not relational, but could be formulated as such. The data as-is is structed as: latitude, ...
1
vote
6answers
160 views

What DBMS' have tight integration with a dedicated OS'?

It has always been my strong conviction that a large-scale multi-user DBMS should reside, stand-alone, on a dedicated server or clusters, with no other unecessary apps, processes or services which ...
2
votes
2answers
604 views

Replicate Oracle to MySQL

I am developing a web apps, this web application will be using MySQL. Now I need to replicate my client's Oracle database into MySQL, only a few tables will be involved.. a table can be up to 2-3 ...
1
vote
2answers
643 views

export from Oracle into SQL Server/mySQL

I have an Oracle database which we will be removing shortly. But I would like to store some of the data somewhere else so if can be accessed if required. Is there a standard/recommended method of ...
2
votes
1answer
180 views

Good Oracle book for MySQL users?

Just started using Oracle, no previous experience. I do have a good amount of experience with MySQL (and played a little with PostgreSQL). Could you recommend me a good introductory book to Oracle ...