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)

4
votes
1answer
70 views

How to store processed data?

I'm working on a project involving Twitter data. I have several hundreds thousand tweets downloaded and stored in files. The data was returned in json format, and the stream consumer I was using ...
0
votes
1answer
311 views

Trouble connecting to LibreOffice Base database in split database mode using HSQL 2.2.8

I am trying to install a split database (starting with a file copy) using an upgrade to HSQL 2.2.8. I got HSQL 2.2.8, and have followed the instructions from another post on this site ( How to set up ...
0
votes
1answer
797 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
120 views

Copy data from mail server to database

Is it possible to backup emails into MySQL database? Say, I have an account me@domain.com and I want to keep record of all the emails inside the mail.domain.com locally, in my computer. From what ...
0
votes
1answer
254 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
1answer
51 views

What Microsoft product is used to draw a Relational Database for MS SQL?

What Microsoft product is used to draw a Relational Database for MS SQL? For MySQL I have used MySQL Workbench what is similar for MS SQL?
0
votes
3answers
89 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 ...
2
votes
3answers
7k views

“FATAL: lock file ”postmaster.pid“ already exists”

I just reinstalled postgres via brew install postgres I ran initdb /usr/local/var/postgres -E utf8 but got this: The files belonging to this database system will be owned by user "atal421". This ...
2
votes
1answer
66 views

PostgresSQL created a user account on OSX

Hello I installed PostgresSQL on my macbook but when I restarted my macbook later I saw that instead of the usual User account and the Guest account I now have also a Postgres user in my startup page ...
2
votes
1answer
1k 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
0answers
41 views

How to migrate a CRM database to an other? Manually or with an ETL solution?

I would like to migrate a database: - from Goldmine 5.0 - SQL Server 2000 (more than 10 years old, huge quantity of datas) - to Microsoft Dynamics CRM 2011 - SQL Server 2005 ETL solutions so far I ...
0
votes
1answer
82 views

Should a dev team use a local database or a remote shared one? [closed]

I'm part of a team of developer and today, we do our developments against an Oracle 11g database installed on our own machine each. I would like to know your point of view about this way of working ...
3
votes
1answer
246 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
1answer
63 views

Relational database on a slow storage

I'm trying to pick a RDBMS for usage as a backend for KDE's Akonadi PIM framework. Problem is that the storage (/home partition) resides on a pretty slow SD card with reiser4 filesystem on it. The ...
1
vote
1answer
228 views

Copy data from “SELECT Multiple” Selection Box

I need to copy data from a selection box with the "multiple" HTML attribute that looks something like this: I have tried selecting all options and do "Ctrl-C" but it didn't work. When I go to the ...
1
vote
1answer
809 views

How to get the articles out of the RSSOwl database (db40)?

The feedreader RSSOwl saves all articles in a database rssowl.db. As far as I read, it's a "db40" database. Size of my rssowl.db is at the moment 3.9 GB. I also got another database with size of ...
0
votes
1answer
466 views

Can Access display a related field on a data entry form?

Let's say I'm building an Access database to hold recipes and calculate the cost of those recipes. I need a table of recipes, a table of possible ingredients, and a table of recipe line items. Each ...
0
votes
0answers
58 views

Configuring the mysql server

I have a mysql server installed in RHEL 6 system with 128 GB of Ram and 16 Cores. i am running 4 websites with quite heavy queries having big joins and sortings. Please suggest me a good configuration ...
1
vote
2answers
77 views

Kubuntu - how to find out what DB is installed

I'm newbie in linux, I installed latest kubuntu release. I was told that it already has sqlite on it/ How can I find out is it installed and what version of SQLite is on it?
0
votes
2answers
176 views

what is the main difference between a file with .db extension and a file with .txt extension while I save both of them from a text editor?

What is the difference between a file with .db extension and a normal file with .txt extension , leaving the fact that a .db extension is for a database file and .txt makes a normal text file. I open ...
2
votes
1answer
160 views

Do .frm files represent the entirety of a MySQL database?

So let's say I copy /var/lib/mysql and save it somewhere else, then uninstall/reinstall MySQL and put the original /var/lib/mysql back where it was. Will I have all of my databases without any ...
0
votes
2answers
2k views

How can I remove Postgres completely from my Mac?

I have been experiencing spooky behavior with Postgres after using the Mac installer for Postgres. There seems to be an existing half-baked Postgres installation that was already there and remains ...
0
votes
1answer
224 views

Mapping of child elements

I can't find one good way to solve this problem. I will try to sum the issue as best as I can: I use Hyperion Essbase Excel ad-in to navigate inside OLAP cubes. What I am trying to accomplish here is ...
1
vote
0answers
700 views

Is it possible to add a data connection to an existing table in Excel?

I have a table in Excel which has a data connection to an Access database. When the data changes, I can click "Refresh" to re-query the data and update the table. However, Excel 2008 for Mac doesn't ...
1
vote
1answer
99 views

Querying variables in Excel

I am looking to query some variables in Excel using a formula. I have a database that has some IDs in it that I need pulled out. The problem is that the IDs vary in length and type. Here are some ...
2
votes
2answers
238 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?
-2
votes
1answer
306 views

Ceridian HR-Payroll Source SQL error

We are using an old piece of software from Ceridian called Source this is a HR Payroll piece of software. I cannot phone their support as we no longer have a contract but use the software for archive ...
1
vote
1answer
695 views

Install Oracle on Mac OS X Lion 10.8

I have no experience with Oracle but need to install it on my Mac so that I can test pulling data from an Oracle database. I already have Apache, PHP, MySQL installed but have no idea where to start ...
0
votes
1answer
41 views

Cannot connect to database

I created a php file to connect to my database hosted on ipages.com with the following simple code: <?php mysql_connect('hostname', 'username', 'password'); ?> When I load this page, I get ...
1
vote
1answer
96 views

How to connect or set a specifig schema in LIBGDA database browser?

I've here a PostgreSQL based database, with a schema and some tables inside it. When I use psql I must put the schema name in front of every statement: SELECT * FROM schemahere.tablehere; Or is ...
1
vote
2answers
33 views

Best option for db installed in home dir? [closed]

My research group shares a server for which I do not have root access. I would like to install a database in my home directory to manage my results. What would the best option in terms of ease of ...
1
vote
1answer
2k views

Difficulty connecting to a database with Primavera P6

I'm having trouble connecting to Primavera P6 (project). When I enter my username and password, I receive an error: This user is already logged in... The password was never changed.
1
vote
1answer
157 views

MySQL deadlock - Adding columns

I had a nasty MySQL problem arise the other day. I added two new columns to table 'Promotions' (13 existing columns, ~750 records) using the PHPMyAdmin interface. This query ("ALTER TABLE.....") ...
1
vote
0answers
386 views

Ontology advantages and disadvantages [closed]

What distinguishes ontology from databases and knowledge bases? What are the advantages and disadvantages of ontology compared to them?
0
votes
1answer
80 views

Am I using the best/fastest method of connecting to a remote database?

In my work, I often need to connect to a remote database. so I use a virtual private network(VPN) Client called "ShrewSoft VPN Client" , and that has some configuration. Then I use Windows "Remote ...
0
votes
2answers
2k views

MySQL File viewer/editor

I'm dealing with some very massive SQL files and I need to be able to go in and edit them. Are their any editors that work on Windows I can use? I need to be able to cut out what I don't need and ...
2
votes
1answer
6k views

How do I extract excel data from multiple worksheets and put into one sheet?

In a workbook I have 7 sheets(Totals and then Mon to Sat),I want to extract rows which have the word "CHEQ" in its cell (this is a dropdown list with two options-CHEQ/PAID)from all sheets. On my front ...
1
vote
0answers
272 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 ...
0
votes
3answers
2k views

How may I retrieve data from an Excel table based on a variable number of criteria?

I have the following salary data for example: Country State 2012 2013 -> 2027 ======= ===== ==== ==== China Other 1000 1100 China Shanghai 1310 1400 China Tianjin ...
2
votes
3answers
3k 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 ...
0
votes
1answer
281 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) ...
0
votes
1answer
234 views

Why did I fail to build mariadb?

The error message is as follows: 141> Call Stack (most recent call first): 141> D:/tmp/mariadb-5.5.27/bu/cmake_install.cmake:81 (INCLUDE) 141> 141> 141> CMake Error at ...
0
votes
1answer
62 views

Did Microsoft TechNet 2005 contain Visual Fox Pro 9.0?

I'm working at a company that has an old copy of Microsoft TechnNet 2005, and I was told else where that "If you have a license to MSDN Professional (or higher) you have a license to Visual FoxPro" ...
1
vote
0answers
299 views

Info path 2003 refuses to submit - 'The form does not contain any new data to submit to the datasource'

I have this error InfoPath cannot submit the form The form does not contain any new data to submit to the datasource How can I fix this? I've made a form in InfoPath specifying an access ...
2
votes
0answers
1k views

Display primary : foreign key relationships in Visio database diagram

I've created a Database Model relationship diagram in Visio with tables and relationships. However, I can't find any way to automatically display the Primary Key :: Foreign Key relationship in the ...
2
votes
1answer
18 views

searching the database objects

How can I search SQL server database to find string in any of objects name? I have a problem when testers says this and that is not working and I can not find it by it's name.
1
vote
0answers
47 views

Visual Studio 2010 DON'T CLEAR Query if doesn't succed or syntax error

In VS2010 when you perform a query against database if the query itself has any syntax error the VS by default clears all text from screen. This makes you to type again the text and resolve syntax. ...
0
votes
1answer
101 views

Visual Studio 2010 SQL Querys how to set BIGGER default font

By default, the default font when you perform a query on a table by going to right click over table -> New Query is very small, you can increase it pressing ctrl+ but when the query is execute the ...
0
votes
1answer
1k views

Libreoffice Base: combobox keeps replacing value to 0

I have a ComboBox which loads a country list, every time i select one item and then focus in other object of the form it resets to 0. This ComboBox is linked with an Integer value in the main table ...
0
votes
1answer
476 views

Is there an easy fix to this copy/paste into Excel error?

When I attempt to paste a large spreadsheet (from a DB, ~90,000 rows) into Excel, I keep getting this error: Microsoft Excel is waiting for another application to complete an OLE action I ...