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
1answer
425 views

Oracle local database product (like MS Access)

Is there a Oracle, local database product (which I can run on my laptop like MS Access) which is free for developers, and in which I can Create tables, Load data from file, Run SQL (oracle's syntax) ...
-1
votes
1answer
54 views

Linking two entries in a list [closed]

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 ...
0
votes
1answer
1k views

How to extract numerical value after a certain string within a sentence in Excel cell?

I want to extract the numerical value immediately following the string "ABS" (Case sensitive) within a bulk of text in a cell from an Excel table. Not all the cell may contain the the string I'm ...
1
vote
1answer
130 views

Excel - auto-fill blank cells or 0 in B:B to a dummy e-mail address which changes sequentially

I am creating a database in Excel that requires an e-mail address to be assigned to each row or user. While some users have an e-mail address in the original CSV file the majority do not. Each e-mail ...
1
vote
1answer
96 views

Host a database server with a different hosting company [closed]

I am hosting my app and database in Linode. I want to scale it by having a separate database server, but I reckon I don't need to pay $10/month for another VPS with Linode for the database server. I ...
0
votes
2answers
45 views

Data modelling, calculation and visualization tools?

I often need to make decisions based on various kinds of data and their calculation results/visualizations respectively. For simple, tabular data I usually make Excel spreadsheets, however most of the ...
3
votes
1answer
62 views

Index files and folders in windows

I want to create a database of all files and folders within a specific location (say, E:\movies). How can I do this? Is there any software which can do this for me? Otherwise do I need to write code ...
1
vote
0answers
167 views

How to fix botched Outlook CSV data export 2013

When I exported contacts from outlook into a CSV file (to later upload it to Insightly database), it placed company names as part of the email address, it looks like this: Column named "E-mail" ...
1
vote
0answers
77 views

Why are there limits to scaling relational databases? [closed]

It is often repeated that the Big Data problem is that relational databases can not scale to process the massive volumes of data that are now being created. But what are these scalability limitations ...
1
vote
0answers
1k views

The best way to sync an MS Excel file with DB data (including saving it)

I have an Excel file that is supposed to mirror some data from an MS SQL DB. This file is synced automatically to a remote location. I would like that whenever the Excel file is synced, the data that ...
-1
votes
1answer
5k views

Convert a line graph into data [duplicate]

Am looking for a tool that will import a line graph (chart) image and convert the line into numerical data, either in a spreadsheet or a database. For example, given an image like this: It might ...
0
votes
0answers
959 views

OpenFire connect to SQL Server Database: Network error IOException: Connection refused

I am trying to get OpenFire to run with my SQL Server. I am following the instructions at Instructions. I have created a new database, named it OpenFireDB, and have created a new login and user, both ...
1
vote
1answer
442 views

manipulate unknown database file

I have a database file ending in .dat, which says nothing to me. Given that it uses a file per database, I assumed that it had to be some sort of sqlite, so tried to open with sqlite3 and has not been ...
-2
votes
1answer
140 views

How does social media sites store posts [closed]

Do social media sites such as Facebook and twitter, store posts in a database? Like mysql? Wouldn't the database be extremely large? Does Facebook or social media sites remove old post?
0
votes
1answer
696 views

Photo Organizer that works from many computers to one file server

I have a file server in the closet. It runs Ubuntu, and exports my photo library as NFS4 and SMB. I have children and a wife who all also want access to these photos. Right now, the archive has the ...
0
votes
0answers
19 views

Extending an formula over multiple cells

I want to set up an excel table where: A:A is my 1st data table B:B is my result table C:C is my "Column" table D:D is my "Row" table E:E is my 2nd data table I want the result of the function to ...
-1
votes
1answer
167 views

Are Intel i7 core mobile processors decent enough for software development? [closed]

I'm reaching out because I'm in the market for a new laptop, and I would like something light that I can take with me for a job interview or meet clients, so I can demonstrate my source code and ...
0
votes
0answers
120 views

Auto-Fill Textfields in PDF from external sites?

So I've got an editable PDF with 2 text fields. Name and EMail. The PDF is locally as in on my current PC. The database is remote, and has 2 fields called "Name" and "EMail". However it is not a ...
0
votes
0answers
105 views

Recover back end database password from front end connection string

I built an MS Access database about a year ago and set separate passwords for the "front end" and "back end" components of the database. It's been a long time since I've had to access the back end ...
3
votes
1answer
69 views

SFTP transfer a file from server to desktop

I am trying to compete an assignment for school and I have one final step. I have use the "put" command to load the file. Then ran a spool and the file followed by ending the spool. Now I am back at ...
1
vote
0answers
56 views

Database-based word document

I will take an example, it'll be easier: So I have a database about classrooms. There is student db which contains all the students like so: id name surname slug class 0 John ...
2
votes
3answers
5k views

Can an Excel 2007 Pivot Table merge data from different tables like a database?

I want to analyze data with a pivot table in Excel 2007. I tried to construct an easy example to explain my question below: I have a table (Table2) with data sorted by Person. I want to analyze ...
1
vote
1answer
1k views

how do I alter the structure of a table in SugarCRM CE?

How do I add fields to the opportunities table so that they propagate? From within Studio > Opportunities > Fields I added fields. Pardon, I don't understand the next step to effect a change ...
3
votes
1answer
308 views

Which program does *this instance* java.exe belong to? Why is it there, and can I remove it safely?

Since I'm stuck in deciding for sure if I should just delete C:\WINDOWS\system32\java.exe ... (I use the java.exe from C:\Program Files\Java[javaversion]\bin, which I explicitly set in my path ...
0
votes
3answers
126 views

I have a mysql table with 150k rows and do regular updates. Updates can take 1-3seconds. What options do i have to reduce this?

I have a table (mysql) that has 150k rows. During the day there are multiple updates (1000s) that change an int value to another int value (update table set field = ? where table.id = ?). nothing ...
17
votes
1answer
48k views

How to: Database Model in Visio 2013

I am unable to find the "Database Model" in Visio 2013 and upon linking an existing database to Visio, there is no option to Reverse Engineer. Where do I find this functionality?
1
vote
1answer
306 views

Is there a way to change the query a report uses in Libreoffice Base or better yet to select the query at the time a report is run?

I have a standard set of data that I always want out of a report, however it could be based on a query of any of the values. Is it possible to set it up so I double click on a report and it would let ...
3
votes
3answers
761 views

How to split one row in Excel into multiple rows for database management

I have a set of data that is currently 39,000 rows and 27 columns. The first column is the ID number. The subsequent columns correspond to elections, with the date of the election in row 1 (cells ...
0
votes
0answers
21 views

Are there any NULL bytes in an MS Access database?

Mercurial diffs files only if it is "not binary", where "binary" is defined as "contains a NULL byte". Do databases in MS Access (.mdb) contain null bytes?
4
votes
1answer
4k 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
2answers
153 views

Pulling out data from a spreadsheet

I need to add information of clients who have visited the office, which department, who they were referred by, who they were referred to etc. I have linked a screenshot of what I have currently made ...
0
votes
1answer
349 views

mysql backup verification

Im not a dabase admin or advanced database user or advanced linux user.. but I would like to know how to verify mysql dumps because I am backing up my own sites manually. Normally when backing up lot ...
3
votes
2answers
3k views

Can I use SQL to build an Excel data table from other Excel files?

I know SQL well enough to perform basic queries and manipulate data split into multiple tables in a database. I know Excel 2007 a bit better and use it frequently to manage my mechanical engineering ...
0
votes
2answers
2k views

How do I connect to some local DB server in MS SQL Server 2012? [closed]

I installed MS SQL Server and now want to create some tables and do some queries ... I need to have some local DB Server running to do that right? When I installed SQL Server there was no option to ...
3
votes
1answer
241 views

Excel ODBC - General 'How does it work?'

Thinking of moving a couple of linked spreadsheets into a database model instead. However, I have a lot of non-technical uses who can just barely use Excel but having them use something like MS Access ...
-1
votes
1answer
418 views

getting error in mysql— #1064 error while creating trigger

I need to create a trigger for a table called try.. which will execute after something is entered into the table..(I am using phpmyadmin mysql) But i am getting #1064 error while creating it.. My ...
0
votes
2answers
3k 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
1answer
54 views

How to create a database from psql user (not linux user)

I' ve studied some PostgreSQL. In the principle i' ve been teach to create a postgress's user with same name of my linux's user. Now i want to try to make an application, and for this reason i would ...
0
votes
1answer
518 views

Transactions per second in a database (say PostgreSQL)

I refer to 2 documentation pages on PostgreSQL's site: #1 and #2. From these, we see the transaction log is flushed to disk 5 times per second (wal_writer_delay = 200ms), and we also see the RDBMS ...
0
votes
1answer
6k views

Creating user with password or changing password doesn't work in PostgresQL

I'm trying to create a new user role or change existing one's password to be able to work locally with PostgresQL. I'm working on Ubuntu. I can modify the attributes of an user, but for some reason ...
1
vote
1answer
514 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 ...
-4
votes
2answers
4k views

How do I convert a .csv file to a database?

I have an 8GB .csv file with 6 columns and 202,176,000 rows. How would I convert that to an OpenOffice database(.db) file?
0
votes
1answer
100 views

Pull Couchbase database over ssh from remote server

I am working on a Debian environment and I have to pull a Couchbase database from a remote server location into my local Dev environment. I wasn't able to find any kind of details on this topic so ...
0
votes
1answer
581 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, ...
2
votes
2answers
403 views

Record bash_history to private database for all users?

I want to be able to setup a MySQL database and record all commands issued on my server by username and command. Is this possible, and if so, how would I set it up?
1
vote
2answers
277 views

Is there such thing as a portable database that runs easily OsX and Windows?

I need to make a small database for a project at school (not computer related at all, I'm indexing and categorizing paper documents of a research projet). The thing is that in september, my semester ...
0
votes
0answers
1k views

Use Excel to query Sybase database

Excel offers the ability to connect to external data sources. I am told I can connect to a Sybase database to import some data into excel from a query. How do I do this? I have the following: Query ...
4
votes
1answer
6k views

How to display text in UTF8 from mysql /phpmyadmin?

I have a database with multiple tables. The database and table and every row of table is set to utf8_romanian_ci. Every name which I import that contains diacritics will not be displayed correctly. ...
1
vote
0answers
163 views

SQLite GUI for my grandma

I created a SQLite database for my grandmother to store all her poems because I was tired to see her search/copy/paste across many different Word documents. Yet I have still to convince her to use it. ...
0
votes
1answer
951 views

Wordpress Creating Empty database

WordPress is creating an empty database, there is a database but with out any values. I am on local WAMP Server 2.4 (PHP 5.4) Windows 8 Wordpress 3.6 (also tried 3.5.1) WAMP Apache is Giving some ...