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.

learn more… | top users | synonyms (2)

0
votes
0answers
12 views

How to do block downloads of assignments from Blackboard?

For instance, see the attached image (redacted for anonymity). Does Blackboard provide any means to download all in one go? There are many guides that suggest that you can - but all of them show ...
-2
votes
0answers
8 views

which variant of cloud os that has good support for database replication? [on hold]

i'm still noobies for this problem about cloud computing. i wanna make system of private cloud that using database replication , but i dont know which one from bunch variant of cloud os (ex. ...
0
votes
3answers
61 views

Are databases more expensive to host and serve than files? [on hold]

I've observed a large percentage of hosts have very harsh limits on database space but generous limits on disk space. 100GB disk / 2 GB database seems quite common. To me, this makes little sense ...
0
votes
1answer
17 views

postgres, change data field type of a table

I am using postgres and I have a table with a column whose data type is timestamp without time zone. I would like to change the data type to bigint. I am trying to store number of seconds since 1970 ...
0
votes
0answers
9 views

pgAdmin III - how to insert data into table

How can I insert the result of some function (e.g. point(0,0) or localtimestamp) into some cell in the edit data window of pgAdmin? I keep getting an error Invalid input syntax for type ...
3
votes
1answer
36 views

How to display text in UTF8 from mysql /phpmyadmin?

I have a database with multiple tables.The datatabase and table and every row of table is set to 'utf8_romanian_ci' . Every name which I import that contain diacritics will not be displayed corectly. ...
-1
votes
0answers
19 views

ISAM DB file reader

I have a program that uses ISAM database files, but it doesn't have any way to export. It has 5 files: isI, isD, isM, OSM, & OSD. The OS- and is- files seem to be redundant, although they are ...
0
votes
0answers
4 views

ORA-01219: database not open: queries allowed on fixed tables/views only [migrated]

I Am using oracle 11g and SQL developer tool. When i tried to retrieve rows from db i am getting error message as :- ORA-01219: database not open: queries allowed on fixed tables/views only) I looked ...
0
votes
1answer
59 views

Can't import a dmp file to oracle 12c database (imp-00037)

I am trying to import a dmp file to my oracle 12c instance, while I used to do that without trouble I got a file which didn't work with both imp and impdp. After long research without a result I ...
-1
votes
1answer
26 views

What type of database is used in large softwares? [closed]

I recently made an application in Java FX. The database used in it was MySQL. When I tried to run my application a system I got some errors because MySQL was not present in that system. My doubt is ...
0
votes
1answer
21 views

Can't detach database in SQL Server Management Studio after accidentally deleted mdf file

I'm working with a bunch of *.mdf files which I'm attaching on my local computer. After I accidentally deleted the a folder containing some of the *.mdf files, I'm unable to view the databases in SQL ...
0
votes
0answers
17 views

Environment Variable ORACLE_UNQNAME not defined

I'm trying to install Oracle 11gR2 Entreprise Edition but during database creation, I got this Error : Environment Variable ORACLE_UNQNAME not defined And when I tried to lunch 'emctl.bat' From ...
-1
votes
0answers
17 views

How to disable prepared statement in heroku with postgres database

I fixed an issue on my rails project locally (with postgres config) while adding in database.yml this statement: test: prepared_statements: false It fixed a bug with the following stack trace: ...
0
votes
0answers
14 views

MS Access 2010 “The expression ”|“ you entered is invalid.”

This a very odd problem and I am hoping that someone here can figure it out. I get this error when working in a database and trying to FILTER a table by column and more than 1 value. For instance, ...
0
votes
0answers
7 views

Access Database Forms - Query placement and functionality

The question actually has two parts, the first is that I currently have a working access database and query for the database. I'm trying to make a search page for the database, but I would like the ...
0
votes
0answers
25 views

How can I use FSContact Form to send email to database as a newsletter signup?

From the FSCF website, it appears to have the capability. As you see here, you can create a newsletter signup like this (basically it is a simple contact form that says "newsletter signup" but it's ...
0
votes
0answers
15 views

MySQL SQL rules for user [migrated]

Let's say I have a MySQL database, with a table session_data containing: | ID | SESSION_KEY | SECRET_DATA | 100| ABCDEFGHIJK | bankAccountNumber=123123 Normally, users would have to authenticate ...
0
votes
1answer
23 views

How to repair .mdf file?

My sql databases in SQL Server 2014 has the status "suspend" as I saw in SQL Management Studio. I can't restore to serviceable condition sql databases through standard procedures. I need to restore ...
0
votes
0answers
35 views

How to make a database for C# in Visual Studio 2013

I have already gone to http://msdn.microsoft.com/en-us/library/ms233763.aspx and tried to follow the directions but it said to click on the service based database template when adding the new item to ...
0
votes
1answer
29 views

Is there a function in Excel or Access to reshape a table to First Normal Form, or a way to do it in SQL?

Very often tables are presented in Excel files in a non-normalized form. I have one such table which I wish to take into (somewhat) First Normal Form using either SQL commands in Access or, ...
1
vote
1answer
25 views

Stubborn “Read-only” notification in Excel won't go away

I have a table in Excel that includes a set of cells copy-pasted from a TFS bulk edit worksheet. I'm usually careful and paste values only so that I don't get any of the data validation, etc. I'd like ...
0
votes
0answers
22 views

In Mysql Workbench, where is Synchronize Model with Database

As displayed in Mysql Database Synchronization documentation. I cannot find this particular Synchronize Model with Database window / wizard under Database -> I have Mysql Workbench 6.0.9.11421 ...
0
votes
0answers
24 views

Installing BDE on XP

I have a program which connects to a Paradox db using ODBC. My old XP machine had BDE Administrator which I believe is necessary to make the connection work properly. I have a new XP machine but can't ...
0
votes
1answer
35 views

Filemaker alternatives for OS X

I'm looking for an alternative to FileMaker Pro. I've been playing with a trial for a week now. I'm looking for a rapid application development platform for small relational databases to run on iOS ...
0
votes
0answers
27 views

Access Database Tables

I have taken over responsibility for an access database not designed by me that I need to clean up. I have a table that I need to find out how it is calculating data. I can't find that it is based ...
0
votes
1answer
49 views

Comparison between Oracle RAC Cluster Database (10gR2, 11gR2 and 12cR1) and deployed Oracle DB on Linux Cluster [closed]

Oracle RAC implementation may be costly for small enterprise, but how it would be if Linux cluster is implemented and then standard Oracle DB is deployed on that cluster to achieve availability like ...
0
votes
0answers
13 views

Real-time database update in Locate32?

I think the title says it all. I have been using Locate32 for sometime now. After the database in updated, if any changes are made to files/folder, they are not reflected instantaneously in Locate32. ...
0
votes
1answer
21 views

Editing finished mysql table

I'm new to mysql and I want to edit my table. My primary key should be auto generated. So where can I get the option to edit my table? thanks
0
votes
0answers
42 views

C++ windows forms application with mysql database setup creatin do not take database with it

I have make windows forms application and connect it to mysql database. After I make setup file and install it, program is working well on my computer (computer with mysql database). After I try it on ...
0
votes
0answers
23 views

convert the saved passwords in fire fox to text

I want to copy the files and folders which store the passwords saved from within Firefox. Some sites claimed that they could be found here: ...
2
votes
1answer
22 views

MySQL “lost” all data (InnoBD)

Today I was making some work with site and I get error what MySQL can't rename file (to make changes in BD). Next I tried to restart MySQL, and it failed to stop MySQL. Then I did go to /var/lib/mysql ...
0
votes
0answers
90 views

How do you create database diagrams in Visio 2013?

I'm not trying to reverse engineer a database, simply trying to create a database diagram from scratch in Visio 2013 (Standard edition). If I choose the "Crow's Foot Database Notation.vstx" template ...
0
votes
1answer
17 views

How can I `diff` two Accumulo tables?

If I wanted to compare two similar Accumulo tables and highlight their differences, how could I do this? My first thought is creating database dumps and running Unix diff over the files, but that ...
0
votes
0answers
65 views

BDE Administrator closes unexpectedly when open database

I don't know what happened on my Windows XP Home system for doing this, always worked perfectly but now when i try open a database the DBE Administrator closes unexpectedly without showing any error. ...
1
vote
1answer
25 views

Replicate a Calculation Sheet for each customer

I created a LibreOffice sheet, with the detailed list of expenses. And a second list with the names and debts of each neighbour. However, I'd like to generate a personalise replica of the first ...
0
votes
2answers
61 views

Best way to share an Access database

A company who I admin for is looking to create a database for vendors to be able to access their trackers to follow the progress of their projects. I want to build the database in access, but my ...
0
votes
0answers
43 views

Getting data from closed files with concatenate formula

Challenge is this: Each day program is creating an excel file for me with some data for the current day. Like what is the price for products, how many people are available today and things like this. ...
2
votes
0answers
56 views

What desktop computer hardware specifications are most important for database heavy applications?

I am purchasing a new personal desktop computer with the hope of improving performance for database-heavy applications (mostly data mining). I will want versatile hardware for all sorts of future ...
1
vote
1answer
20 views

Excel 2010 - Large Practitioner Database Consolidation

I have a database of 1800 employees (1 employee per row) and a binary confirmation of whether they have 1 or more of the 105 professional certifications we track (1 certification per column). I ...
0
votes
0answers
52 views

Cannot copy-paste multiple rows in PgAdmin

I don't understand why this is not working. I have one instance of PgAdmin in which I administer multiple databases on multiple servers. I wanted to copy some rows of a table from one database on ...
1
vote
1answer
181 views

Cleared vs. Unformatted partition in GParted

I am running a database-like application that writes and reads data directly to and from a raw block device. I would like to create a new partition for this purpose, and I am using GParted. I've ...
0
votes
1answer
23 views

Split database index and table files with SSD?

I know in the good old days it was recommended that indexs and tables were placed on different drives to improve database performance. Is this still the case with SSDs when connected with SATA3? With ...
0
votes
0answers
6 views

Short cut to move in sub-mask in MS-Access

I have a mask with 3 different sub-masks in this layout main (level 0) submask1 (level 1) submask2 (level 1) submask3 (level 1) when I use to entry data I can move the cursor using TAB. After ...
0
votes
1answer
35 views

delete a MySQL database with a strange name

I started to maintain a MySQL database and I have no idea who and why this database was created: "#mysql50#backup-2012-03-01". I want to get rid of this one, but the following commands did not work: ...
1
vote
1answer
28 views

Tool for converting tables into 2nd, 3rd and 4th normal forms? [closed]

I'm looking for a tool that will convert a table, in CSV format, into 2nd and 3rd normal forms. I've found many tutorials and examples on the process, but no tools. I'm running Windows 7 on PC.
0
votes
1answer
42 views

Converting firefox bookmarks to a database [closed]

I have more than 100,000 bookmarks in firefox. I want to save them in a contacts database so that I do not lose them and also easier to manage. The size of the html file is 55meg. How would I do ...
1
vote
0answers
26 views

Excel 2010 won't remember password when importing data

After connecting an Excel workbook with an SQL server (within a company network, over a static IP address, using the data connection wizard within Excel), if I close the workbook and reopen it, it ...
0
votes
1answer
25 views

Mirror server and ignore already-processed files

Before I start writing my own app for this, maybe there is already a better solution for the problem: I need to check an HTTP Server every day for new files to download and process. Basically these ...
-1
votes
2answers
75 views

SQL Server Database Encryption [closed]

Let's say two programmers are working on a website for a store. They've created a small database for an online store. Users would have to register and provide a username(e-mail address) password,home ...
0
votes
0answers
288 views

Libreoffice Base: How have a combobox linked to a related table linked to or in the form table control

I could not sum up, what I really want in the title. But here I am going to try to explain what is it about. I have switched from MS Access to Libreoffice Base because it is open source, free and ...