Software Engineering Stack Exchange
Software Engineering Stack Exchange

Questions tagged [dbms]

11 questions
10
votes
4 answers

Difference between data models and schemas

I was just starting with reading a book about databases and encountered schemas and data models. I read that schema is the structural design of a database and data model is a set of conceptual tools to describe the data and the relationships like Er…
user1369975
  • 1,259
  • 4
  • 15
  • 24
6
votes
4 answers

Can age be a composite attribute in DBMS?

my question would be can age be considered a composite attribute? Because name is a composite attribute and it can be divided into first name, middle name and last name. And therefore can age be a composite attribute since you can divide it into…
Chandima Gayan
  • 87
  • 1
  • 5
3
votes
1 answer

Where can I obtain the specification for Distributed Relational Database Architecture?

I'm developing a DBMS that should be able to connect to IBM DB2 via the DRDA protocol. I found a DRDA reference manual that mentions "DRDA Implementation Programmer's Guide, SC21-9529" as a publication about DRDA, and seems that this manual is…
dtumaykin
  • 133
  • 4
2
votes
2 answers

SQL query or C# .net code for csv files import?

My aim here is to find out the best possible and feasible solution for my dilemma. I want to import some csv file (may contain around 50~60K records) into database after some manipulation into the files, manipulation includes comparison such as one…
Shilpa Soni
  • 121
  • 5
1
vote
3 answers

What is a single word I can use to describe a non-query SQL statement?

I'm trying to come up with a good name for a data access object that executes non-query SQL statements. I know DML is a valid term, but I wanted to make sure it is the best. Right now we have OracleNonQuery, but I'm hoping to find something…
Jordan Parmer
  • 203
  • 1
  • 7
1
vote
3 answers

How to choose DB and/or DBMS for own application?

I'm creating application in C++ and found out that storing information in XML file was very prodigally. Despite the possibility to read it without any specific application, random access via DOM or VTD library and possibility to backup by simple…
Eugene
  • 169
  • 4
0
votes
1 answer

How is B-Tree used in DBMS-s if WHERE condition can be anything?

The most of the database management systems use B-tree as a data structure for increasing the performance. Let's imagine that we have a table users with the following columns: id (int), name (string), email (string), password (string), age (int). We…
Vega TV
  • 111
  • 4
0
votes
1 answer

Using sql triggers over higher level scripts

I recently came across a set of possibilities for creating rows in a table in my database. the scenario is that I am trying to populate a notifications table by different types of notifications data based on different tables. Adding to the…
Kaki Master Of Time
  • 139
  • 5
-2
votes
2 answers

Is a JVM based dbms like Neo4J implemented ideally?

Since Neo4J is implemented in Java and therefore uses the JVM, wouldn't an equivalent graph database that is written in C++ / Rust or GoLang be more performant? Why would one decide to build a DBMS in a medium "high level" language like Java?
Martin Nowosad
  • 109
  • 4
-2
votes
1 answer

In DBMS are Secondary Indices ordered?

I've read that the Heap File Organization is usually used to structure a secondary index. This makes me suspect that usually, a secondary index is unordered, as opposed to the primary index, that is ordered by the primary key attribute. Is this true…
AleWolf
  • 113
  • 1
-3
votes
1 answer

How to draw an E-R diagram?

I am learning DBMS in my college. Recently I was given an assignment to draw a E-R Model of a Bus Reservation system which handles Reservations, Ticketing and cancellations. I understand the theory about E-R model when I study from a book, but it…
progammer
  • 751
  • 3
  • 11
  • 15