Questions tagged [database]

A collection of data that is usually organized into tables for different data objects. Tables usually consists of records on instances of the data objects.

858 questions
14
votes
4 answers

What FLOSS DB design tool for Linux would you recommend?

I want to find a relational DB design tool for Linux, that could export DB schema for MySQL, SQLite and PostreSQL at least. And it should be handy, of course. Good-looking GUI is also a plus ;-) I use Gnome, but KDE tools are interesting too.
codeholic
  • 455
10
votes
7 answers

School Management System

I am looking for a school management system to replace a homegrown Access db. It should be able handle the following for both a Primary and Secondary school Scheduling classes Student Enrollment Allow teacher to enter grades and comments Generate…
Paul
  • 436
4
votes
1 answer

Database integration with ...well with sound beep or light?

Perhaps this post major editing : I work for company which sells services online. I would like to build some kind of software bridge/integration tool which would integrate our Oracle database with some sort of device. We have screens showing live…
3
votes
5 answers

Flexible database software recommendation

I'm a surgeon, just starting my career. I'm hoping / planning to accumulate a 30-year dataset of surgical patients, with one or several procedures associated with each patient. Each procedure will have several outcome measures that are either…
Ben
  • 41
3
votes
2 answers

Is there a free oracle product for trial/development?

I have some vague memory that there was a limited use license of a version of oracle so you could try it out on a small installation to try it out. Does such a beast still exist?
Stu
  • 1,246
3
votes
7 answers

Small database for scientific papers

What small database for scientific papers can be recommended? I just need a small way of handling a list of a few hundred (maybe 300 tops) scientific papers. I have author (often more than one on one paper), title, publication, some publication…
Pinky
2
votes
1 answer

Sybase 12.5: how to bcp in/out a table with a 'text' field

I have a table of this structure create table test { id_data int identity, data text // id_data is the primary key } I used the following commands: bcp DB..test out prod.bcp.out -U me-P pwd -SPROD -I ~/bin/interfaces -c -T40960 bcp DB..test…
Anthony Kong
  • 5,028
2
votes
2 answers

How to organize data without resorting to excel?

I'm working my way through two different Yoga books, trying to consolidate the different poses into a unified reference for personal use. Excel is very uncomfortable this, so I went with plain text in YAML format. But this seems error-prone and I…
2
votes
2 answers

What is the easiest way to apply database functionality into my daily life?

let me try to explain it by listing some of the things I want to do: Submit random thoughts, notes, facts, and to-do tasks of any sort and at any time. Tag each of these submissions freely. Manage these tags centrally. Associate meta-data with…
2
votes
2 answers

How to find a value in a .DB file?

I'm trying to find hotkey data in the settings.db file for TS3. When I open the .DB file in NotePad++, and hit CTRL+F, and type "SCROLL, you'll find the hotkey data. Whenever I edit anything in the .DB file using NotePad++, the file gets corrupted,…
2
votes
4 answers

Small database recommendation (free)

I need a small database for handling some stuff ... nothing too big, up to let's say 1000 entries. Problem is the last time I used a database of some kind, was round', oh I don't know, 1995 ... dBase, version unknown, under DOS. What is there on the…
Rook
  • 23,873
1
vote
1 answer

Oracle SQL Developer Data Modeler: How to Search for a Table and Show in the Diagram

In the Oracle SQL Developer Data Modeler 4.0, there is find functionality. It's icon is the binoculars in the top right corner. When we use that find operation, we receive a list view of results that fit the search. That's helpful. It doesn't help…
Shaun Luttin
  • 2,241
1
vote
1 answer

Is there a term for software that allows users who don't understand DBs to create reports from a DB?

Is there a term for software that allows users who don't understand DBs to create reports from a DB? A customer might just say I wanna see people and addresses that are related to this incident, for example, but maybe they have no concept of joins,…
patrick
  • 1,243
1
vote
1 answer

Database structure for handling multiple accounts (Multi-Tenant Data Architecture)?

It's always easy to write software that handles a single entity. However, designing software to handle multiple accounts/companies requires due diligence. I'm currently doing initial research into database schemas that handle multiple…
1
vote
1 answer

Is there an off-the-shelf database solution similar to asihollywooddatabase.com or imdb?

What off-the-shelf database solutions would allow me to do the same thing as asihollywooddatabase or something similar to IMDB without having to write the software from scratch. I have little knowledge of html or website design so something without…
Melissa
  • 11
1
2 3