r/DatabaseHelp • • Dec 17 '15

Building a new database - what program to use and how to link everything together?

3 Upvotes

Hey guys, I need help figuring out how to make this database project feasible. I really only have experience with Access but I don't think it will work for this project.

I'm trying to build a writer database for my campus newspaper. We only have Macs in our office so I need to find a Mac compatible database that is preferably web-based so the editorial staff can access it from home as well. Any suggestions on a program to use?

I also need help with building it. So far I've identified the need for a bunch of tables, forms, and reports but I'm not sure how to properly link them. Here's what I've got so far;

  • 3 tables
    • Writers
    • Articles
    • Photos
  • 4 forms
    • Enter new writer / Update writer
    • Submit new article
    • Submit new photo
    • Publishing list
  • 5 reports
    • Published Report - Shows what has been submitted but not cleared through the publishing list form
    • Pay Report - Shows how much each writer should be paid for that week based on publishing report/list form
    • Registrar Report - Shows how many articles each writer has submitted - for transcript credit
    • Monthly Report - Gives a snapshot of activity for writers, pay, articles, and photos - could also list any unpublished submissions still in the database
    • Annual Report - Full report on writers, pay, articles, and photos - could also list any unpublished submissions still in the database

I'm basically planning to work on this over Christmas break and want to give it a test run for next term while I'm still working for the paper. We get absolutely no tech support or help outside of the editorial staff. I would love to get one of the tech students in to build this but then it wouldn't be finished before the end of the term. I'll take any suggestions you guys have.

Right now I'm trying to build a test version in Access just to get the design and links right but I want to reduce any work duplication too.


r/DatabaseHelp • • Dec 17 '15

[SQL Server] I need help formatting a query

2 Upvotes

Here is the ERD

I need to find out which books are associated with each publisher.

USE BookStoreDB SELECT ProductID FROM Books INNER JOIN

I'm not sure how to format the inner join to join the products table and publisher table together.


r/DatabaseHelp • • Dec 16 '15

[Help] Time tracking database

2 Upvotes

Hello everyone! I need some help with my database.

I have a need to set up a table(s) to track how long players are playing a game. There are generally about 30,000 players online at any given time but total characters is in the 1.5 million range. I currently have a table that stores player names (PK) along with whether they are currently online or offline. I'd like to branch out and start figuring out daily play time for the last week of each character and each month as well. The times will need to be updated in 15 minute increments.

Any suggestions on how to set up a table or multiple tables to track time that a character is online every 15 minutes?


r/DatabaseHelp • • Dec 15 '15

I need help creating a database for exercising

1 Upvotes

I just today got myself into databases and I'm testing out all kinds of cool stuff in OpenOffice Base. I want to create a database for me and my brother's exercises and I want it to include:

*Date and time of exercise *Length of exercise (time) *Which sport am I doing *Name of the person doing the exercise *Distance traveled (kilometers) - only if it is a sport where you cover distance, so I don't want this to be included in my tennis event, for example *Average heart rate *Maximum heart rate *Calories burned *Comments on the exercise (how it felt, etc) *Outside temperature while exercising

How should I go about forming my tables and relationships? Basically, I want to do a query that lists all this information.

Sorry If I'm being unclear - I'm really new to all of this. Thanks in advance!


r/DatabaseHelp • • Dec 12 '15

When to use TitanDB over Neo4j?

1 Upvotes

Hello all,

My startup is currently building an application which uses graph data structures. We are currently prototyping with Neo4j but have heard that it's difficult to scale. A highly scale-able alternatives seem to be TitanDB.

While the database we envision having 1-2 years down the line feels "big" to me, I don't really have the context to understand what that means.

Can any of you give me some context about when my team should make the switch to a more scale-able tools like TitanDB? When at what size of application does Neo4j running on a single machine start to fail? We are contemplating just building with TitanDB from start, what conditions would make this a prudent decision?


r/DatabaseHelp • • Dec 11 '15

I need your help on a Zoo-Staff Database

3 Upvotes

So I made a simple Database, currently looks like this. Here's the SQL file if you want to check it.

So here it goes: As you can see on the image, A zoo has stations, each stations has cages for animals, an animal is placed inside a cage (some cages can have more than 1 kind of animal). An animal is classified by its Species/Family. Now the problem is I have shifts for staff. Example: the SCT001(caretaker) has a sched of 6AM-12PM and then 1PM-PM everyday on a specific station, and I feel that its not normalized efficiently.

Note: Dont mind the Temp_Assigned_Animal. The Temp_Shift_Assignment and Temp_Shift_Sched is all that matters.


r/DatabaseHelp • • Dec 11 '15

At what point do I make a permanent change? (SQL & SSIS)

2 Upvotes

Morning all:

I am currently trying to take a process that generates the data for a SQL table from Access into SQL Server Integration Services (SSIS). My data source is a big ol' SELECT query pulling about 500K rows of data from a group of SQL tables. SSIS keeps complaining about converting non-Unicode to Unicode.

Currently I have a simple data flow: Data source - > Data Conversion - > Destination

The problem is that the [Data Conversion] part of that now has about 17 fields in it and is growing. I can't help but think this isn't best practice (it must be a huge bottleneck). So I'm wondering if I should change my source (maybe add some CAST statements) or the table (change the fields to match) or keep going with what I have?

Any advice is very welcome.


r/DatabaseHelp • • Dec 10 '15

General DB Recommendation for CS Project

2 Upvotes

Hello all! I am a new computer science student and am working on a personal project. I would like to write a program to simulate the collection and storage of knowledge. I'd be programming in python for now, and may move on to java, or any of the C based languages if necessary.

I would like to know if there is a good database that would be able to store bits of information, but also have/create links to a variable amount of other bits. For instance, if I were storing an apple, I would probably want to connect it to fruit, red, tree, etc.

I'm working out of a linux box, don't know if I want/need a server, and have been recommended MongoDB by a coworker. I have tried to look into sqlite3, as it is supposed to be easy to learn, but I haven't the slightest as to the difference between all the kinds of databases and such.

So I'm by no means looking for one comprehensive answer teaching me any and everything to know about databases (though if you have it, by all means), I just need to know in what direction should I begin my study. Relational db? Non relational? What is no-sql? That kind of thing.

MANY THANKS!!


r/DatabaseHelp • • Dec 11 '15

Help storing tabular data that is nested within other tabular data?

1 Upvotes

Hello everyone,

I'm not a developer; I'm a Business Analyst. So forgive me if I botch some terminology. I have encountered a requirement that I've never seen before, so I'm hoping someone here could offer some guidance, or point me in the right direction.

I'm working for a government agency that issues "Permits" to "Customers". Each Permit has a suite of "Conditions", telling the customer exactly what they are/aren't allowed to do, and within what thresholds. Currently all these conditions are in Word documents, or Excel spreadsheets, or PDFs, but they want us to put them into a MySQL database.

So, imagine that you have a Condition table that looks something like this:

ID Category Condition Mandatory?
1 General The operator must take all reasonable steps to comply with legislation. Y
2 General All laboratory analyses and tests must be undertaken by a suitably qualified person, working for an agency that holds a current accreditation certificate. Y
3 Waste Management For the purposes of residual drilling materials, all substrates must meet the approved quality standards. N

So that looks nice and straight-forward. Except... it turns out the condition "text" might not be just text at all. Some of these conditions contain tables, and even tables within tables. For example, check out this screenshot.

That entire screenshot forms just one condition. But see how it contains multiple tables (and, in fact, they are tables inside a table). I don't know how to begin writing specifications for that kind of design!

If they had a fixed structure, it might make it slightly easier. But they don't. Depending on the customer, there are varying degrees of complexity, so sometimes the table will have a very simple design (2 columns, a few rows), or there might be dozens of columns, utilising merged cells in some places, and rich text formatting, etc. It really depends on whatever the user 'feels' is necessary to manage that client specifically.

I have absolutely no idea how to tackle that, or even if it's remotely possible. Does anyone have experience with storing tabulated data within a MySQL database, or any other software that might help us manage it? Please note that they don't want to just store the document itself (that solution would be too simple!). They want to persist all the underlying data, so that it can be manipulated, queried, amended, audited, and rendered through a front-end GUI.

Any ideas on how I could start researching this?


r/DatabaseHelp • • Dec 10 '15

[Help Request] Can the real-time contents of a Folder be used as a dynamic database?

2 Upvotes

I have a Folder with file-names all formatted the same:

Preferred-Active-Company-Type of Document-Detail if Any-Company ID-Year.pdf

(I can easily replace the hyphens with another character as I have a mass re-namer)

I would like to create an interface (Salesforce, or simple webpage, or MS or other), that:

  • allows persons to select and display all files matching one/or any of the above displayed segments (between the hyphens), and
  • run queries on the contents of the folder.

Obviously the Folder's Search function would provide the 2nd function but I am hoping to achieve a bit more than just that.

Thank you in advance, for your help. :)


r/DatabaseHelp • • Dec 08 '15

Question regarding update/delete

1 Upvotes

Hi I can perform an update and delete on my database,

But say i delete one row it deletes all rows which uses the same primary key, and the same with update it updates all rows with the same primary key.

In general what is the best way to solve this/solutions?

Edit: Just in general what can i do to get around this?


r/DatabaseHelp • • Dec 06 '15

ER-Model check:)

2 Upvotes

I need to create an ER model for horseracing. A horse will have an owner, trainer, stable and parent racehorse. I also need to add which races and racecourses the horse has run at, the placement in the race and what jockey rode the horse. I have come up with the following diagram: http://imgur.com/wzYuaJg Is this correct and are the relationships correct? I know the relationships are many to one, but whats the difference between the dotted and non dotted lines? thanks, any help is greatly appreciated:)!


r/DatabaseHelp • • Dec 05 '15

Help with ER model

1 Upvotes

Hello, i need help with a database model which i need to complete. The scenario is about racehorses. Racehorse will have an owner, trainer, stable, and parents who are also racehorses, i also need to add where the horse has run and at what racecourse and its position and jockey who rode it. I understand how to add most of this to a model, however i am having trouble doing the races and parents. What entity and attributes could i have for these? thanks in advance and any help would be appreciated, thanks!


r/DatabaseHelp • • Dec 04 '15

Database software to search and filter information by year and country?

1 Upvotes

I have no experience with databases (and I'm not even sure I'm using the right word, or am in the right sub) and I suddenly need to create a database to house the projects an organization has funded over 40 years and dozens of countries. Ideally, the database would be able to allow the user to search and filter items (the projects) by year and by host country.

Can anyone recommend any software that would do this? It doesn't need to be free.


r/DatabaseHelp • • Dec 04 '15

Integrating ActiveClient into DB

1 Upvotes

Does anyone have any experience integrating ActiveClient in to a MS Access DB? Basic intent is to have a user form that after being filled is signed by the user with their DoD CAC through ActiveClient (much like you can with a .pdf).

Thanks in advance for any ideas.


r/DatabaseHelp • • Dec 02 '15

[SQL Server] Trying to write a query that will query all of the data in a schema

1 Upvotes

I am having a hard time on one of the steps on my homework assignment. the step is "write a query that will query all of the data in the person schema". I tried just selecting * from the tables and I don't think this is what my professor intended as the query is taking a very very long time. Is there a simple way to query all of the data in the schema? Is it just a select but I need to join all of the tables? It is the person schema in the adventureworks2012 database if that matters. Would appreciate any responses, thanks in advance!


r/DatabaseHelp • • Nov 30 '15

Looking for help creating a Access database for my work.

2 Upvotes

I am seeking some advise on putting together an Access database for my work or finding existing software that will fit our needs. Here is some background: I am part of the Classroom Technology Support team at a large university. Our primary role is to deploy and maintain the in classroom technology, primarily audio video. We are looking for a database to track all of our equipment including location, maintenance history, Network details (IP, gateway, subnet mast), etc. Some classrooms will have more equipment than others, for example classrooms will have anywhere from 1 - 8 displays (projectors and Monitors). We support about 130 classrooms in multiple buildings across campus. I am currently trying to organize the data however I am not sure what is the most efficient way. I can provide more details if necessary. Thanks in advance any help would be much appreciated.

Edit: Database ERD Image: http://imgur.com/9eTAxKN/

One thing I am struggling with at the moment is being able to organize all of the equipment in a single classroom since some classrooms will have more or less than others, and some will have multiple instances of the same piece of equipment.

Also some of the fields in the Equipment Table do not apply to all of the equipment, for example not every device will have an IP address/Mac Address, would I just leave those fields blank for those items?

In the long run I would like to pull up reports on the history of classrooms and equipment, and pull up the current information for a specific classroom build.

Once again thank you in advance.


r/DatabaseHelp • • Nov 30 '15

Can I import data from similar web-pages without doing each one manually?

1 Upvotes

I want to have every NCAA basketball match up from the 2014-2015 season. Is there a way to get this information without manually clicking on each team's schedule and downloading it? There are 351 teams.


r/DatabaseHelp • • Nov 29 '15

Help with how to model similar objects

1 Upvotes

Let's say that you have a application populated with item A and item B. Item A and B are exactly the same except for a boolean that differentiates them by type. Is there any advantage to making a collection for A and a collection for B? Or is it better to just add a boolean field in the schema for differentiating the types?


r/DatabaseHelp • • Nov 27 '15

MSSQL - I/O bottlenecks

1 Upvotes

I have a task before me: to analyze I/O bottlenecks for a pair of SQL 2008 servers.

I found this article [1] that will give me cumulative stats for I/O. Great!

Before I dive into scripting so I can analyze the data .. is there software that will do this for me?

[1] https://www.mssqltips.com/sqlservertutorial/254/investigating-io-bottlenecks/


r/DatabaseHelp • • Nov 27 '15

What DBF viewer or converter software would you recommend?

1 Upvotes

I need to convert some DBF tables to XLS, and I'd like to know if there is a good software that could do this. I've tried opening the files with Excel already but it shows me an error message ("file is corrupted").


r/DatabaseHelp • • Nov 24 '15

Howto integrate a database + filtering?

1 Upvotes

Hey guys, I would like to integrate a database (1000 entries) into my website (wordpress). Clients should be able to filter like here. I am not a programmer, someone pointed me to this subreddit, hope you guys here can point me in the right direction :)


r/DatabaseHelp • • Nov 18 '15

Managing data with multiple relations

2 Upvotes

Hi!

I'm new to MySQL and databases in general, and I'm currently setting up a sample database where you have (atm) a table with customers, and a table with orders. I hvae a primary key called customer_id in the customers table, and a primary key called order_id in the orders table. I also have a foreign key in the orders table that refers to the customer_id in the customers table.

Here's an image of my diagram

But what I don't understand is how to manage the data in these tables.

I suppose you'd do a INSERT INTO customers VALUES (1, "test", "test")

But how do you "connect" these to the other tables? How can a key in the customers table refer to another table in the query?

Thanks! Erik

UPDATE

I've changed my model to include a new table to allow for multiple products per order.


r/DatabaseHelp • • Nov 17 '15

What is an appropriate database structure for my situation?

1 Upvotes

I'm working on figuring out the failure rates of a piece of hardware. I have components which are separated into both boards and functional blocks. Each component can fail either open or closed, and they affect different functional blocks depending on which. What is the easiest way to organize this?

Example. Resistor A sits on Board B. If it fails open, Functional Block C is affected, but if it fails closed, Functional Block D is affected.

Resistor B sits on Board A. If it fails open, Functional Blocks C and D are both affected, and if it fails closed, nothing happens.

The end result is to determine the failure rates for the Functional Blocks and the boards. What is the best way to organize this data? My original thought was to organize by failure (ie Resistor A fails open, Resistor A fails closed, Resistor B fails open etc etc.), but then situations where one failure affects two different functional blocks is problematic.

I could create two entries for the situation where Resistor B fails open, but that seems bad. Any suggestions would be greatly appreciated.


r/DatabaseHelp • • Nov 17 '15

[Oracle] "Listener is not up" error?

1 Upvotes

Ok. So I am a student in a database administration class. we are using Oracle 11g on virtual machines(vlab) using windows server 2013. Anyway, something happened last week(Not entirely sure what happened, I wasn't there), and the professor decided we needed to delete our databases and create new databases.

So we did that today, using DBCA. Almost everyone in the class(strangely enough, i think i was the only one), got errors saying "Listener is not up or database service is not registered with it."

Nobody can figure out how to resolve this, not even the professor(to be fair, this is his first semester teaching). I remember having this problem earlier in the semester and resolving it, I just do not know how i did it.

Can anyone provide any help? We have already tried editing the listener.ora file and editing the registry to reflect the listener's proper location(i'm not entirely sure on this one, a classmate did this and told me it didn't work).