Questions tagged [database-management]
115 questions
0
votes
2 answers
Pruning in SQL Server
I have a table which has more than 90 million rows, it has data for more than 3 years. I want to keep all the records added on Monday (or any one specific day in a week) and delete the remaining records for the data added a year before.
Can any one…
Swethu
- 37
- 10
0
votes
1 answer
How to deal with the response time from a huge mongo db database
I have a mongoDb database with one of the collection having 2300000 documents and growing. Till the database had 1000000 documents the api response time was quick and the webpage loaded quickly, as soon as it crossed the 2000000 mark it started…
user7310181
0
votes
1 answer
Should I avoid using models in django migrations?
I am working on an existing Django project that contains migration code like:
someFluffyModel.objects.all().delete()
or
someModel = SomeModel(....)
someModel.save()
Now wherever there is such code and newer migrations change the schema that…
Andreas
- 970
- 18
- 28
0
votes
4 answers
Benefits or using XML over MySQL and vice-versa?
I am currently working on a project that was not made by me but it makes use of a lot XML files instead of MySQL in place of it.
Because of that it makes me wonder if there is really any benefits of using XML over MySQL here.
The scene is, the XML…
Guapo
- 3,446
- 9
- 36
- 63
0
votes
0 answers
splitting the column fields into new columns in mysql
I need some help with some basic, i suppose, mysql.
given three columns such as the ones below:
[Events Counts Date
play 2 2017/06/05
pause 3 …
Alessandro Longo
- 1
- 3
0
votes
1 answer
Database administration tool vs database management system?
i am using Microsoft SQL Server Management Studio. I though it was a database management system, until today I realized that the database management system is actually Microsoft SQL Server.
So i would like to know what relation and differences are…
Tim
- 1
- 141
- 372
- 590
0
votes
0 answers
Scripting update for User Mapping in SQL server
OK, First it's probably important to state that i'm a noob so please forgive me for any incorrect terminology or misconceptions.
My problem is this, I have a database that I run a restore on periodically and every time I run this restore it resets…
Keifer
- 39
- 2
- 7
0
votes
2 answers
Database tables viewing and filtering app in Django
Up to this point I was using django's admin app as a base.
It seemed great at first but when I got to the point that I want to present the data from tables and enable user to search and filter columns I noted that the 'admin' app was really not…
Raff89
- 403
- 3
- 11
0
votes
1 answer
Why does returning properties in Neo4j yields unexpected results?
I got this Cypher Query:
match (c:Person)
match (c)-[:eml]->(emls:Email)
match (c)-[:phn]->(phns:Phone)
return phns.Number, emls.Value
Number of Email nodes is 13, Phone nodes is 10.
When I return the nodes the result is: 13 Email nodes and 10…
user5214718
0
votes
1 answer
Removing an area from an OpenEdge database
I'm with a Client that has half of their OpenEdge database filled with unwanted audit records (user built auditing; not OE auditing). The database is around 200GB and 97GB are these audit records. The user built auditing process is now disabled and…
Drammy
- 940
- 12
- 30
0
votes
1 answer
Should I get data from my database to create a dropdown list?
I have a form with a dropdown selection whose option are determined from a table on a database. Periodically I will (manually) add more options to the dropdown and the database. Either I can make the dropdown selection get the options from the…
KNejad
- 2,376
- 2
- 14
- 26
0
votes
1 answer
Database Entity Relationship Diagram and Enhanced Entity Relationship Diqgram
I am learning database management systems now. May I know is it required for a weak entity to have an attribute or have a primary key itself? (ERD)
Next, when transforming many to many (M:N) relationship to 1 to many relationships, the participation…
0
votes
1 answer
Lossy OR Lossless Decomposition
Consider the relation R(A,B,C,D,E) with the set of F=(A->C,B->C,C->D,DC->C,CE->A)
Suppose the relation has been Decomposed by the relations R1(A,D),R2(A,B),R3(B,E),R4(C,D,E),R5(A,E)
Is this decomposition lossy or lossless?
i tried solving this…
batman007
- 39
- 2
- 9
0
votes
1 answer
Class Table Inheritance with a hierarchy
I have 3 data types with -- a) Common columns b) a hierarchy -- and would like to know how to design the database.
Let's say at the top level, there is a Discussion. Within that, there are DiscussionMessages, Files and Comments. They all have…
chuckfactory
- 123
- 9
0
votes
1 answer
MySql - Creating Stored Function and Calling It
I need help creating this particular stored function and call it by using the single select statement. Below are the questions with my answer. I think I got the first part right but I'm not sure. Any suggestions/advice? For the second question (part…
Batman101
- 13
- 4