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)

1
vote
1answer
34 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
94 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
59 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
47 views

Is it possible to manually edit/view KDE's Nepomuk database?

I'd like to know if there's a way to edit the content of the Nepomuk database, ideally with some simple tool. Some times ago I have recently the indexing of the email, in order to save system ...
1
vote
0answers
914 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 ...
0
votes
0answers
55 views

Converting base64 encoded database

I have a dadabase whose structure is really simple. <ws> <e> <k>base64_encoded_string</k> <v>base64_encoded_string</v> </e> ...
0
votes
0answers
141 views

MySQL database on external encrypted hard drive

I want to move MySQL database installed on my "Windows 7 Enterprise" PC to an external hard drive which is PGP 2.0 encrypted. Could you please suggest how to do this?
0
votes
0answers
43 views

Stanford Wrangler ideal, but imposes limits, what are other options?

Stanford Wrangle tool is quite amazing, and I solved a giant problem with it, but it limits me to very small size. My file is about 500MB, and it allows me to process less than 1MB, the remaining data ...
0
votes
1answer
41 views

Linking two entries in a list

I'm a keen DOTA 2 player. It's a 5-a-side team video game where you play one from a pool of about 100 heroes with different abilities and strengths and weaknesses. I often play team captain and it's ...
1
vote
1answer
416 views

mysqldump not on wamp server

I am trying to use mysqldump on my wamp server mysql console however, it doesn't seem to have mysqldump included. I found the mysqldump.exe file in this location: ...
0
votes
0answers
53 views

phpMyAdmin only shows two databases

Having a weird problem where mysql is showing multiple databases when I go SHOW DATABASES; I get 5 results. When I go to phpMyAdmin I only get two: information_schema and test. If you could ...
1
vote
0answers
281 views

Getting complement of two text files on the Unix command line

Is there a fast Unix-based utility (ideally written in C) for getting efficient, streaming intersection/union of tab-delimited text files? For example, allow queries such as "give me the all the ...
0
votes
0answers
13 views

SQL server- Solid state hard drive transfer

I have a 4TB hard drive that contains my current database. Is it possible to allow my solid state to act as a buffer between HD and RAM? Other option- Is it possible to allocate my entire Solid state ...
0
votes
0answers
63 views

IBM DB2 Command line Window - Administrator disappears on windows server 2008 r2?

I have installed IBM DB2 version 10 on windows server 2008 r2 machine. However i am unable to open it's command line window. For example: Whenever i try to open Command Windows - Administrator it ...
0
votes
0answers
77 views

Google Contacts to ODBC

I want to import my Google contacts into a linked database on MS Access 2010 and I think an ODBC driver is the easiest way to do it. Is there a driver authenticated by Google? Also which are the ...
1
vote
0answers
56 views

Best personal search engine? [closed]

I have large amount of data files which I continuously need to run search queries on. Previously the best solution to searching a large personal database was google desktop search. But now, the ...
0
votes
3answers
634 views

Is there any disadvantage of vacuuming sqlite dbs?

Are there any disadvantages of vacuuming sqlite databases? If not, why don't applications vacuum their dbs?
1
vote
1answer
4k views

How can I show data types in a Visio database diagram

How can I display the column types in a Visio database diagram?
8
votes
5answers
6k views

Linux GUI Database Manager [closed]

Does anyone Know any KDE application for working with databases in a unified way? It must support several DBs (sqlite, MySQL, Oracle). GTK apps are also welcome :)
0
votes
6answers
19k views

Convert Excel Text string to Time

I'm trying to Export from an OLD System that stored Time in / Time out as a text string in 24 hour time. For example 3pm, is entered as 1500 (no colon) Is there a simple way I can convert these ...
0
votes
1answer
226 views

How to calculate max_connections for PostgreSQL and default_pool_size for pgbouncer?

Is there a rule or something I can use to calculate a good number for max_connections, default_pool_size and max_client_conn? The defaults are odd. PostgreSQL defaults to max_connections=100 while ...
0
votes
2answers
225 views

Where to retrieve MySQL Database Backup? Centos 6

Had taken a look at: Where Are Databases Located - MySQL File Location Didn't seem to help much. I used this for a single MySQLDatabase backup: ...
1
vote
0answers
53 views

SQL Server - Database with strange storage space

I have a strange problem with one SQL server database: The database takes 180GBs on disk, with no space available; while the only table it contains should use only sth like 25GBs: EDIT: database ...
1
vote
3answers
773 views

What is the equivalent of MSSQL to Open Source

I want the equivalent of MSSQL to opensource DB?
0
votes
0answers
40 views

Deleting sentences in database file

I'm writing a MD5 based antivirus, and my friend send to me a document with thousands of samples and their MD5. All is fine, but I have to delete all sentences what contain "File does not exists:" ...
0
votes
0answers
137 views

Ubuntu FTP Server - Hetzner

I have an FTP Backup Server in Hetzner with details Backup Server: u*****.your-backup.de I am trying to connect to it through my ubuntu server using command $ ftp u*****.your-backup.de and i see ...
2
votes
1answer
5k views

automatically tag mp3 collection using shazam-like acoustic fingerprint

is there any software freely available to clean up the tags in your music collection , based on some sort of audio fingerprint type technology (like how 'shazam' app works on the iphone) combined with ...
3
votes
1answer
44 views

SQL Server 7 Transaction Logs Issues

Over the week my database server transaction log was full. With our app people could select from the database but could not update or insert into the database. In the past we have just truncated the ...
0
votes
1answer
500 views

excel macro to look up data from a database and copy it to another excel file or sheet

I have an excel file which looks up and calculates data for a given date. It works as follows: You enter the date in a specific cell (input) and in the same sheet the required data appears (20 cells). ...
0
votes
2answers
814 views

Using sqlplus as tnsping alternative

Is it possible to use sqlplus as an alternative for tnsping since tnsping wasn't installed with the oracle setup. I simply want to check via batch script, whether the definitions from the tnsnames.ora ...
0
votes
1answer
1k views

Form no longer updates table; what'd I do?

I've been working on an "Enter Scores" type of form for a database that's used in a competition. What should happen is - I pick a team from a combobox, enter their score in a text box, then upon the ...
1
vote
1answer
180 views

How can I connect to an InterBase database using Excel?

There is an InterBase database that I'd like to connect to using Excel. I have the database name, address, and login info. IB, as I understand it, is a form of SQL. Using the SQL connect mode under ...
2
votes
1answer
932 views

how to connect to pervasive sql through odbc?

I am trying to add a linked server to a sql server 2012 database using ssms 2012. the linked server is pervasive sql. here's how i am trying to do it: EXEC sp_addlinkedserver @server = ...
1
vote
1answer
68 views

database statistics and reporting with or without parsing of built in logs

I prefer a generic statistical utility / plugin / application, but don't limit myself as specific might do well too. I want to see a way by which I can see query statistics for ALL queries. e.g ...
0
votes
2answers
72 views

Is MyIsam safer than InnoDB?

Is MyIsam engine safer than InnoDB about loss of data due to FileSystem error? It seems that InnoDB is not reparable with MySQL tool. I had to choose my engine and I chose InnoDB because of foreign ...
3
votes
5answers
7k views

Free Mac OS X MySQL GUI [closed]

I'm looking for a good GUI app like Heidi SQL on windows for mac os x, snow leopard specifically. It can support more DBs than MySQL but needs to at least that. I'd like to be able to manipulate DBs, ...
1
vote
1answer
121 views

Which is better for multi-use auth, MySQL, PostgreSQL, or LDAP? [closed]

I want to set up an Oracle Linux 6 server that gives users secure IMAP email (with dovecot), Jabber IM, FTP (with vsftpd), and calDav. However, I want each user logon to be able to authenticate all ...
0
votes
0answers
57 views

Way to access Palm Zlib DB files (.pdb) on Windows or Debian

Is anyone aware of a way to access the data in zlib database files for Palm? The file extension is .pdb, but that extension covers a whole range of formats, so a generic 'pdb viewer' won't necessarily ...
1
vote
1answer
161 views

Excel access.Vlookup? IF?

What im looking to do, is move stuff from one excel sheet, to another sheet in the same workbook. We will call the sheet with the data the "suppliers list" and the sheet where i want it to go, the ...
1
vote
0answers
45 views

Database for Quotes needed: Tags, multi-language support?

Dear superuser userbase! Almost every website now supports tags. I want to harness the power of tags for a private database, can you help? Ideal: A database of quotes (columns: English | German | ...
4
votes
3answers
603 views

How are sites like Pinterest able to hold all those pictures?

Does anyone know how sites hold massive numbers of pictures in general? I tried researching this, but it seems like they would need massive storage spaces to hold all these, unless there was a trick ...
-2
votes
1answer
184 views

Can I give access to database without access to cpanel

I'm going to give a freelancer access to the database. The idea was to give him the access with SSH (MySQL Workbench). But it came out that to do so, I would need to give him the password to my cpanel ...
1
vote
1answer
392 views

What does the output of this “source” command mean?

Unix newbie here, installing MYSQL. Per the directions from the server admin, I just added two lines to the end of my .cshrc file to create 2 new environment variables: setenv MYSQL_UNIX_PORT ...
2
votes
1answer
209 views

What's a good database-backed X.509 certificate authority on Linux

I've been using OpenSSL as an X.509 certificate authority. Because multiple machines will need to create certificates, I've exported the certificate authority folder on a distributed filesystem. When ...
1
vote
0answers
44 views

How to dump all MySQL databases for one specific user?

I need to export a particular user's databases so that they can take them to a different server. I have 30 or so users and many dozens of databases. This particular user alone has about 20 or so. ...
2
votes
1answer
1k views

Is SQLCMD part of the DB Engine or Client Tools?

We have hundreds of locations where our software is installed, and it used to use SQL 2005 Express. As part of an upgrade to our software, we are doing an automated upgrade to the DB Engine to SQL ...
1
vote
1answer
96 views

Excel reference - connecting a list to a database

I am trying to create a database. I have 2 columns, if I enter a number in the first column, the matching name should appear in the second column automatically. The list of numbers and names is on a ...
1
vote
0answers
33 views

Visual Studio: Tables always added offscreen when editing EDMX files

I have a number of ASP.NET projects which utilise .edmx files to access tables on the relevant database for each app. If I add a new table, I have to open the .edmx and click Update Model from ...
2
votes
1answer
1k views

How to add new customized columns to windows 7 explorer (or find a similar application that is more customizable)

I like the way windows 7 explorer allows me to organize all my files by sorting columns - except there is little room for customization: I can't add my own types of columnns that can then be directly ...
1
vote
0answers
254 views

CDX currupt index file & Windows 2003 Server

We're experiencing almost everyday database index corruption on Windows Server 2003. I wonder if it can be somehow connected with caching or other server settings. We are running an old application ...