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).
3
votes
2answers
628 views
Users cannot view tables in non-default schema in SSMS
I'm having an issue setting the VIEW DEFINITION permission appropriately at the schema level for one of my users. I've created the schema TestSchema and added some tables. The user currently has ...
4
votes
1answer
93 views
Designing Simple Schema for Disaggregation of Demand Forecast
I am doing a simple database design task as a training exercise where I have to come up with a basic schema design for the following case:
I have a parent-child hierarchy of products (example, Raw ...
3
votes
1answer
69 views
Tools and methodologies to keep to DBs aligned
2 DBs having schemas that represent the same semantic objects.
The first one is production DB (Non-RDBMS, in-house implemented in-memory DB with shitload of RAM). Other is Postgres.
Once in a while ...
2
votes
1answer
73 views
Best embed/reference/field strategy for many inserts (mongo)
I'm building a gaming backend with Mongo, and have some issues on how to best design the schema to maximize performance and database size.
My models:
User
Match
-ReferenceMany (User)
...
0
votes
1answer
23 views
Candidate key = Key = Minimal Superkey?
I got a little confused by all these keys. As I understand
A key of a relational schema =
The minimal subset of a superkey that is still a key =
A candidate key
Is this correct or not?
0
votes
1answer
55 views
Database schema design help needed
I am developing a PHP application expecting millions of records both parent and children. My goal is to design an optimized database design to achieve high speed and performance.
This application ...
0
votes
1answer
89 views
Oracle schema import is not importing all the tables present in the schema dump file
I have exported an existing oracle schema from another machine and then imported it in my local machine. Import was successful, but some tables which are present in the export dump file are not ...
2
votes
0answers
70 views
What does a multidimensional cube's internal structure look like?
We all know what a relational data model looks like, and most know what a star schema looks like, but what about the structure of a multidimensional database (OLAP cube)? I am assuming it is some sort ...
2
votes
0answers
118 views
Oracle sqldeveloper Database Diff - not seeing indexes/sequences
I am using Oracle SQL Developer's database diff tool to compare schemas. (SQL developer version : 3.2.09) It works great on some environments, but in one, I can only see differences in tables - the ...
1
vote
0answers
30 views
Is there a way to create a re-usable base table definition in InfoSphere Data Architect?
Our company has chose to use IBM's InfoSphere Data Architect (IDA) for data architecting regarding our data warehouse and data marts.
The data architects originally designed several "re-usable" ...
0
votes
0answers
92 views
How to create table set from several XSD in SQL Server 2012 or with VS 2012
Is there any solution in T-SQL or in C# how to create XML schema collection in T-SQL or C#?
Problem is I cannot use:
USE Database_test
GO
CREATE XML SCHEMA COLLECTION Collection_from_XSD AS
N'
...
0
votes
0answers
43 views
XML Data convert to SQL database,
I have an XML feed that i need to parse daily, i want to store all of the data from the XML feed in a SQL table so then that data can be queried and manipulated by my clients.
I can currently parse ...
0
votes
0answers
21 views
In regards to GS1 barcode - what size DB field are used?
In regards to GS1 barcode - what size DB field is used or is the entire GS1 typically not stored in database, but rather processed in the application layer and stored in the database as a collection ...
0
votes
0answers
67 views
How to represent class table inheritance (current DBMS-specific way please)?
I want to implement class either-or table inheritance (Account, CatAccountDetails, DogAccountDetails) in SQL Server.
I found a recommendation for MySQL here (How do I map an IS-A relationship into a ...
0
votes
0answers
29 views
Examples of a database with no consistency measures that ensures consistency through schema alone
To clarify, the database can be any type RDBMS, NoSQL/BigTable. However, it must not employ any usual consistency measures such as locks, or synchronization, but the inconsistency-invincibility must ...
0
votes
0answers
22 views
How can I represent a set of user-defined attributes in a schema file for input into a DKNF db?
I have a hyper-normalized database in DKNF. Shown below are the entities in the DB (at this revision).
AttributeKey implements the key part of the key-value pairs for ObservationValue on ...
0
votes
0answers
86 views
Database (open source) for complex queries (for analytics) like these:
In an app, I'll be storing information about events, specifically,
session_id
url
time
type
data:
foo: bar
bar: foo
The data will basically be a hashmap (need to support arbitrary types / names ...
0
votes
0answers
95 views
Schema for Google Docs-like sharing
Am trying to design a nicely normalized schema for sharing entities in a database, with good referential integrity.
It should work similarly to Google Docs sharing.
Here is what I have so far:
...
