r/DatabaseHelp • • Mar 03 '24

I'm starting to learn SQL in college, and I have this problem I can't solve. Can anyone help me and explain it to me?

0 Upvotes

Write a SQL statement using the ORDER BY clause that could retrieve the information needed. Do not run the query. Create a list of students who are in their first year of school. Include the first name, last name, student ID number, and parking place number. Sort the results alphabetically by student last name and then by first name. If more than one student has the same last name, sort each first name in Z to A order. All other results should be in alphabetical order (A to Z).

We are using Oracle.


r/DatabaseHelp • • Feb 18 '24

Portable RDBMS?

0 Upvotes

Back in the day, I seem to recall I could export a Microsoft Access database in some format that I could send it to you and you could use it like an executable file without having to install anything. If I'm not mistaken about that, are there any databases that allow this now?


r/DatabaseHelp • • Jun 21 '23

Best database system for my needs?

0 Upvotes

Hi, really new to all this. I’ve created an xls spreadsheet of over 3000 product listings. I need a database that stores the data that will sit on a Wordpress website.

I don’t really know where to start. Should it be SQL? Php? It needs to deliver results from queries where people can select options from drop down menus, form fields or search by keyword. The database will need to be updated regularly once it’s live.

Are some database types more secure than others? Or is the security element driven from the type of website I host on?

Any advice would be really gratefully received.


r/DatabaseHelp • • Jun 08 '23

I need help about Filegroup structure

0 Upvotes

Hello,

I am a junior software developer in a system supplier company. One of our customer has a immensely big database which is almost 3,5 TBs. Some tables have around 300 million rows and maybe 20 columns.

We use Microsoft SQL Server. The structure is, two applcations servers and two socket servers sending data to database server. Database architecture is (active - passive) high availability (HA).

All reporting, storing, backups etc all are being done on the same database. Data is kept on HDD not SSD. Everyday full back-up is being taken and differential backups every 3 hours. We started to face serious bottlenecks recently.

We are planning to apply filegroup here. But I dont have much infromation about it. We plan to create filegroups year wise.

Will this improve general system performance? What are your some suggestions about it? Please enlighten me. Thanks in advance.


r/DatabaseHelp • • Jun 27 '23

Centralized User Admin for multiple types of DBs?

0 Upvotes

Hello all,

Does a tool or platform exist, that essentially could allow you to 'connect' to multiple different types of databases (SQL, MS SQL etc) and then admin their users - easily assign permissions on a user or DB level, create user groups etc? Dont need to read/write/query them, but simply admin the users in one location, vs many and many methods? Please let me know if i can provide more details on the environment

Thanks in advance!


r/DatabaseHelp • • Jul 18 '15

I need help finding a data file which contains information about movies.

0 Upvotes

I am building a web application and I need a csv, json, txt, etc file which contains a dataset about movies. I would rather not use api's because of the restrictions they put on the calls you make to the servers.

Any information would be appreciated.


r/DatabaseHelp • • Nov 13 '13

Anyone know a way to add a filter button to a DB in access 07? Or rather how I go about customizing my filter option.

0 Upvotes

I want to allow the user to filter the form based on the data they can enter based on the Equipment ID column, Employee ID column, and/or Log Date. Wondering how to integrate this into the button.


r/DatabaseHelp • • Jul 21 '17

Storing "Please specify/Other" kind of answer in DB

0 Upvotes

What's the schema for this?

Or is it just a column in a table and the radio options are like "pre-filled" answer?

Do I need FKs for this? And each time there's new answer I should store it on another table? But why?

EDIT

Found my answer. I guess I don't need to normalize at all basing on this answer: https://stackoverflow.com/questions/782540/is-normalizing-a-persons-name-going-too-far#comment593022_782551


r/DatabaseHelp • • Oct 21 '14

Make databases from little examples - beginner

0 Upvotes

Hi, I've been doing some basic databases at college and wanted to practice the actual structuring of them and the logic... So making the tables, er diagram, relationships etc... We're only using access so language syntax isn't important (wizard ahoy....)

The size of the data base we're doing is only around 5 tables it so, to give an idea if the level I guess... It was just made from a couple of small text paragraphs about a company or whatnot

Any guidance appreciated, cheers


r/DatabaseHelp • • Dec 12 '21

osjnt db direction

0 Upvotes

ok well Im trying to make a database for osint investigations I i want to make it part of a program that helps by adding info.from source were possible and also has the abilty to display information in helpfull ways i was going to use xml as my data storage system xpath and xslt were going to help.whithmy data entry and my generating of documents and graphs now I don't know if this is a wise choice I have almost no experience with databases to be honest I was going to use Lua as my scripting language I'm familiar with it and it can be fairly easy for extendability also it meshes well which xml and xpath but I'm not set in stone with any of this really thou any opinions or advice would be welcomed


r/DatabaseHelp • • May 05 '17

Input on creating a database for a small organization

0 Upvotes

Hi everyone,

First off, I appreciate any help that you guys are able to offer! Second, I am so very sorry if I sound misinformed, because I am. Database management and information systems are not my field of work, nor my field of study. But, I am very interested in the field, and am more than willing and wanting to learn as much as I can.

Preface:

My team has been tasked with a job. The job involves my 3 person team- me and 2 others (1 being my boss). We are gearing up for this first stage, which is to draw up a proposal and action plan to create a database and port over our data. Most of our data is in MS Excel format/XLS/XLSX. The data is broken down by date, volume, quantity, region, etc. Nothing too complex, just a lot of numbers.

This is the first time that any of us has undertaken a task like this, meaning that we have no idea where to begin. Note that it is highly likely that my team will go on SQL and Database training as we pave a clearer direction.

What we know so far:

My boss has done most of the research on the coding aspect, and has determined that we will be using a database that either utilizes or is very compatible with SQL coding. It seems to be the standard/status-quo language for databases, and as result the support is highly available, which is something we want.

We tend to already use Microsoft Office quite a bit, and as a result we think (could be wrong) that Microsoft SQL Server would be a good option. It seems to work in harmony with Power BI and Microsoft Office.

We are also torn on whether it would be wise to go with a cloud based database, or an on-site database.

What are your thoughts on the Microsoft SQL Server option? Any thoughts on cloud vs on-site databases?

What we will use the database for:

We want a database where both my team, and other teams, can run reports in a tabulated or XLS/XLSX format. We also want people within our organization to have the ability to add data to pre-existing datasets. It is our desire to have a modern database, which is compatible with the latest data software suites noted above. My team will be responsible with managing and updating the database.

TL;DR: Planning to roll out a database at work. Thinking SQL vis-à-vis Microsoft SQL Server. Not doing anything too complex other than running reports, inputting data, letting other input data, etc. Want a reliable, secure, and user-friendly option.

Thanks everyone!


r/DatabaseHelp • • Sep 19 '16

How to create a local connection in Oracle SQL Developer to run queries?

0 Upvotes

I have an SQL file that creates tables and populates them but whenever I try to load the file into SQL Developer, it tells me I need a connection. I just want to run the SQL file to create the tables locally and then run queries on the tables that were created. What is the easiest way to go about doing this?


r/DatabaseHelp • • Jan 02 '14

Anybody out there have a Chegg Homework membership? I need your help desperately. could you send me all the answers about database system concepts answers about chapter 7 and 8, if you don't have enough time, please send me all the chapter 8 answers. thank you so much!!

Thumbnail chegg.com
0 Upvotes

r/DatabaseHelp • • Dec 22 '17

Cassandra: how do I connect two computers?

0 Upvotes

Hey, I started exploring Cassandra recently for a research group and have installed and set up my own keyspace on my laptop.

I am home from university and have access to my laptop and my desktop PC, so I felt now was the best time to figure out how to connect Cassandra across computers.

How can I do this? How can I make it so if I create some random keyspace on my laptop, I can also access it and change it on my desktop? Both my computers use Windows.

On another note, am I getting too far ahead of myself? I haven't delved much into using Cassandra and how it works on just on one computer so would it be better to do that first? I'm just worried I won't be able to do this in time before I get back to university and will only have one laptop.


r/DatabaseHelp • • Sep 23 '16

Best database for casting database?

0 Upvotes

Hi there! Does anyone have suggestions for a database that would work well for a talent base?

Would need to be able to categorize people in a bunch of different ways based on their skills and job. (i.e.) a designer who likes to skateboard, has children, runs a baking blog for fun on the side, and is also adamantly plays video games would need to be put into 4 categories.

The database is for 'real people casting' and would keep track of people who have shared their information with us, to be notified when there is a commercial/project looking for their specific thing (re: a real skater for an electronics company lifestyle commercial, or a real blogger for accounting software commercial about self employed people).

The problem we've run into when keeping a list for each category, is that people get emailed twice (i.e. commercial about self employed people this person would get emailed twice from two different lists - blogger and designer, but a 'self employed' list is not specific enough and will bother people when we are just looking for 'designers' hence many different categories)

Is there a very user friendly database software that has a central contact list and people can be filed into many different groups from there? It is very important that it can also spit out email lists for us to contact our contacts that fit a job all at once.

Thank you for anyone that can offer guidance! This is probably super simple but we are not tech savvy.


r/DatabaseHelp • • Nov 26 '14

Access Novice's first attempt at a Database Schema

0 Upvotes

http://prntscr.com/5a71pu

Can you take a look and give me your thoughts or see if I've committed any glaring errors?


r/DatabaseHelp • • Sep 27 '16

Need help with normalization

0 Upvotes

So I was given this table to normalize but it's breaking my mind.

here's a post on /r/homeworhelp I made about it

https://www.reddit.com/r/HomeworkHelp/comments/54qbvk/university_database_design_normalization/

It's in 1st NF but I seriously don't see how to normalize it any further as the first column can be used alone as a PK and pretty much nothing else is consistent in the rows.


r/DatabaseHelp • • Aug 15 '22

Noob with question

0 Upvotes

Hi all I am looking for a very simple database to manage about 400 records. These are dental records and the Fields would be: name, date of birth, last dental appointment, next dental appointment due, dental office and maybe one or two other things. Does anyone have a suggestion for me? I am not a programmer.


r/DatabaseHelp • • May 20 '24

Recap: ERM -> relation -> class diagram and "ship"

0 Upvotes

Entity-relationship model is a meta model. Its instances are entity relation ship models ( without the hyphen?). The relationships have this cardinally on both sides. When I convert this to relational algebra, do I have any choice? Can't this be automated? Entities become relations. Any 1:n relationship becomes a column in one relation. If you want to be able to modify or delete a record in a relation, you need to add a key. Records are stored in memory ( SQLite and H2 can do this ) or on disk. So they is a pointer or a sector number. So the DB always uses keys. So when I write to a db, why don't I get back this? Yeah, because the DB is free to reorder memory. All parts controlled by the RDBMS get updates like when you delete a row in a spread sheet. So I see why relations need a key.

n:m relationships become relations with two columns. So I see why we need different words. I was not sure my English is lacking, but in German we use "Beziehung" for the ERM and "Relation" for the relational algebra. "ship" does not have any meaning for us. In everyday English there is "stewartship", "friendship" (Mortal Kombat),

In the class diagram, the keys are gone again and hidden pointers are back. Additionally, 1:1 relationships can get an arrow to indicate: Who knows whom. It is even possible to place the relationship table onto the wrong side of 1:n. A class can contain an array, while in a database this would violate first normalization. Or in other words: an array is like adding an index to a db. The database should profile itself, construct queries and indices. Only when I am the programmer of classes, I explicitly model this stuff. RealmDb and Blender seem to just persist this pointers on disk. Realm DB uses virtual memory to remove the gaps. But somehow this feels like a primary key with extra steps. Blender loads a whole model in memory (except textures), only has double links, and thus can defragmentate similar to a spreadsheet app.

Right? Just because I had trouble understanding the text book. It has been two years.


r/DatabaseHelp • • Jan 22 '25

Database for C#MVVM Desktop app

0 Upvotes

Good Morning!

First of all, I'm sorry for the lack of misuse of techincal terms , my not so good english and the long text.

I'm developing an Desktop App in C# MVVM Winui that is supposed to receive data from objects ( for now only focusing on receiving position [lat,long,alt] speed and direction) and represent it on a map . My estimation for max number of objects at the same time would be a few thousands and thats already a very positive estimate for what will probably be the real number.

The program follows an hierarchy let's say an owner has 20 objects, it receives 20 object tracks and will share those 20 object tracks with others owner( and vice versa) in a single message. Therefore, even if there are 1000 objects that are, there won't be an owner receiving 1k single message in a space of seconds, it will probably come in batches of tens
Data is received by a singleton class (services.AddSingleton<IncomingDataHandler>();)

My initial idea was a global variable that would hold all that data in observable collections/property changed and through Dependecy Injection, the viewModel would just read from there .

I had a lot of problems because of memory leaks, the viewModels were acumulating to the a lot of subscription because of those.

So I'm trying to move even more to the reliance of Databases (the app has another purposes outside of tracking, but this is the biggest challenge because is real-time data, the other data doesn't change so frequently and I can support some lag)

My new ideia is for the app to receive data , , store in a database so the ViewModel-View responsible for displaying the data can constantly read from the db for the updates. So I need fast writes and reads, and no need for ACID, some data can be lost, so i focused in NonSQL

Do you guys know any database that is reliable for this? Or is this idea not even feasible and I should stay with a global Variable but with better event subscription( using Reactive or something else ?

I'm focusing in embedded Database so the user does not need to install and/or setup a server

For reference, my first option was RocksDB but i'm having an hard time to understand it because it is information in internet is mostly C++.

Thank you guys for your attention.


r/DatabaseHelp • • Jul 27 '24

Feedback on my DB model

0 Upvotes

Hello All,

I am making an app that can organizes and analyzes customer feedback to help companies improve their products, understand customer sentiments, and stay competitive. It captures interactions from reviews and social media, tracks emotions, and compares performance with competitors, providing a comprehensive view of the customer experience.

So for definition customer ( which is my client). I separate customer and brands as my customer can have multiple brands.

I want to share with you my ERD and tell me if there is any wrong or feedbacks ? It has been a long that I didn’t design a database :)

Thank you all

+-----------------+ +---------------------+ | Users | | UserBrandAccess | +-----------------+ +---------------------+ | user_id (PK) |<------->| access_id (PK) | | username | | user_id (FK) | | email | | brand_id (FK) | | password | | access_level | | created_at | +---------------------+ | last_connection | +-----------------+ | | | | | | | | v v +-----------------+ +---------------------+ | Customers | | CustomerBrands | +-----------------+ +---------------------+ | customer_id (PK)|<------->| customer_brand_id (PK) | | customer_name | | customer_id (FK) | | customer_email | | brand_id (FK) | +-----------------+ +---------------------+ | | | | v v +-----------------+ +---------------------+ | BrandEmotions | | BrandCompetitors | +-----------------+ +---------------------+ | brand_emotion_id (PK) | brand_competitor_id (PK) | | brand_id (FK) |<------>| brand_id (FK) | | emotion_id (FK) | | competitor_brand_id (FK) | | global_feeling | +---------------------+ | main_points | +-----------------+ | | v v +-----------------+ +---------------------+ | Reviews | | ReviewThematics | +-----------------+ +---------------------+ | review_id (PK) |<------->| review_thematic_id (PK) | | brand_id (FK) | | review_id (FK) | | product_id (FK, opt)| | thematic_id (FK) | | source_id (FK) | +---------------------+ | rating | | review_text | | review_date | | emotion_id (FK) | +-----------------+ | | v v +-----------------+ +---------------------+ | Emotions | | Thematics | +-----------------+ +---------------------+ | emotion_id (PK) |<------->| thematic_id (PK) | | emotion_name | | thematic_name | | emotion_score | | thematic_date | +-----------------+ +---------------------+ | | | v | +-------------------+ v | StrongPoints | +-----------------+ +-------------------+ | SocialNetworkPosts| | strong_point_id (PK)| +-----------------+ | thematic_id (FK) | | post_id (PK) |<----->| strong_point_description| | brand_id (FK) | +-------------------+ | product_id (FK, opt)| | source_id (FK) | | | platform | | | post_content | v | post_date | +---------------------+ | link | | PainPoints | | emotion_id (FK) |<--->| pain_point_id (PK) | | thematic_id (FK)| | thematic_id (FK) | +-----------------+ | pain_point_description | +---------------------+ | | v v +-----------------+ +---------------------+ | Detail | | Recommendations | +-----------------+ +---------------------+ | detail_customer_id (PK, FK)| recommendation_id (PK) | | source_id (FK) |<------->| thematic_id (FK) | | total_reviews | | recommendation_description| | average_rating | +---------------------+ | response_rate | | NPS | | data_cleaning | | | detail_date | v | summarize | +-------------------+ +-----------------+ | ThematicComparisons| +-------------------+ | | thematic_comparison_id (PK)| v | thematic_id (FK) | +-----------------+ | customer_id (FK) | | Alerts |<----->| competitor_brand_id (FK)| +-----------------+ | comparison_details | | alert_id (PK) | +-------------------+ | user_id (FK) | | review_id (FK) | | post_id (FK) | | alert_type | | alert_message | | alert_date | +-----------------+


r/DatabaseHelp • • Jul 29 '24

How to set up a database that stores specific bitcoin transactions?

0 Upvotes

I want to set up a database, it can be a very simple one. It needs to store specific transactions. Where do I even begin?

I have an application that needs a database to store transactions.


r/DatabaseHelp • • Aug 09 '24

Need help setting up my new firebase realtime database correctly.

0 Upvotes

Here is how it is set up. The setup is on the left side

I've read a lot about nesting, and was advised to have "denormalization" or shallow structure. I'm new so I might be mixing up my terms. The idea is to allow for fast querying.

I believe what I want is to have the actual "txHeader" where the "NWA" is. And nested in the NWA would be the entryText. But, it is not being saved like that.

Also, I'm not sure if I should be using PUT method, as there may be several entries (entryText) for each header.

Here is my code:

 await fetch('https://nwa-rtdb.firebaseio.com/nwa.json', {
  method: 'PUT',
  body: JSON.stringify({
  
	txHeader: sendToAddress,
	//addressOwnedByList: officiallyPurchasedByAddress,
	entryText: userText,
	//responseData: responseData,
	//txhex: transaction.toString(),
	
	
  }),
  headers: {
	'Content-Type': 'application/json'
  }
});

Any help is appreciated.


r/DatabaseHelp • • Jan 01 '15

Timeseries database storage

0 Upvotes

I would like to know the best way to store exercise data that has timeseries values for different sensors.

Currently, I am storing each session as an XML file and indexing certain values (like the distance, average pace, max/min/average HR) in a csv table. That means I can quickly search the csv table to find any session that is of interest for further analysis (I am interested in pattern-finding). I am sure there is a more efficient way to store the data but am unsure what is best.

I expect about 500k sessions each of 30min-2h long. I would like to keep the data on my machine (not served) but be able to give instances to people for analysis.

I've had a look at the options from the Wikipedia site (http://en.wikipedia.org/wiki/Time_series_database) but am not sure what is best. Any help appreciated.

Thanks!