Tagged Questions

A schema of a database system is its structure described in a formal language supported by the database management system (DBMS) and refers to the organization of data to create a blueprint of how a database will be constructed (divided into database tables).

Is it harmful in some way to have multiple schemas with the same name in a database cluster, specifically Redshift?
I want to create multiple databases, and then create a schema "tables" or "data" or ...

In context of Platform as a Service (PaaS),
we would like to offer our clients a private platform.
A platform includes a website and a database.
A platform is not 100% separated. Users could "travel" ...

I have customer table in public schema. And I have a schema named after each customer. Each customer schema contains different tables like portals, plugin, ... When I want to select portals used by ...

I am working on designing a schema to support the development of a miniature railway reservation system, using oracle 11g XE.
This is for a project purpose, I am need to be sure about the correctness ...

I have already created a database design with a set schema.
The database schema is for a web quotation form. PS it is not a simple quotation form and hence need to customise the form, form builders ...

I am building an app which allows users to do some "tasks" to earn points. The "tasks" are part of a "campaign" which themselves are a part of "brands". I am confused about the schema for storing the ...

Given a table with a PRIMARY KEY definition (acting as the clustered index), I want to efficiently change the definition of the PRIMARY KEY (or at a minimum, just the clustered index) online.
I would ...

I'm not a dba but a php programmer, so that I'm not an SQL pro. Now, I have searched in both programmers and dba stackexchange sites but the answers are too specific or not conclusive.
My question is ...

I am new in the database design and I'm facing this problem, I hope somebody can help me.
In my domain we have 3 roles, Non-Supervisor, Supervisor, Manager.
I created a Person table and a role table ...

I would like to know, which is best in fast retrieval and reporting as numbers of records will increase with time. So lower the record better would be the performance.
Priority would be fast response ...

I am really curious about the infrastructure of Amazon. When I create a new instance of RDS, it gives me a host, username, password.. Everything. Behind the curtains, how do they do this? It´s some ...

On the percona-5.6 and MariaDB-10.0 servers, the NOT NULL declared on table field are being ignored. I am able to leave fields declared as NOT NULL empty when inserting data and the servers are not ...

I am facing database error Incorrect string value: '\xC5\xABt\xC4\x97'. I did a lot search and tries a few ways, include move from utf8 to utf8mb4. But still not able to solve it.
Following are the ...

I am developing an app that send messages (email and sms) to users. The db must also maintains the list of messages send to users. And also the status of messages send to user like send or failed.
I ...

We have an old DB server, running Oracle 11g on Solaris.
We also have a new DB server, also running Oracle 11g, but on RHEL.
We want to move a schema to the new db - but we need everything it refers ...

I have a question with a MySQL 5.6 master-slave setup. If I were to modify the master's schema with an ALTER TABLE SQL query, then when the slave tries to execute that ALTER TABLE statement too, would ...

Is there away to stream certain part of collection in MongoDB or TokuMX from master server to another server? I need to duplicate only certain collection
Or if it isn't possible, are there any other ...

I am moving a schema from one server to another using pg_dump + pg_restore + drop schema cascade. I need to know that no applications are writing to it (or at least that the writes will fail) during ...

I have an entity with millions of instances. Each instance has to reference an ordered list of items. The lists have to be unique so no list will be stored more than once. But once created, both lists ...

Is there a portable way or best practice to access a version number for a schema at runtime?
Rationale: you have multiple systems (development, QA, etc.) where you push schema changes from one system ...

What is the simplest way to log in as user X and see all tables,... of schema Y as if they belonged to X?
With an Oracle 11g database, I would like to log into the database using user X but all the ...