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
votes
0answers
12 views

Install & Host Cassandra DB [on hold]

I want to install & host Cassandra DB. I want to do this to try & do a petty project & learn some concepts of Big Data. Where would be a good start for this ?
0
votes
0answers
3 views

CQL for Cassandra [on hold]

I am looking for some CQL Query examples apart from the documentation provided in Apache Docs site.
-1
votes
0answers
10 views

Can't access Couchbase Web Console

After having used the Couchbase Web Admin Console I was logged out after a page refresh. I have tried to log in again with password and username but it didn't work. Does anyone have any idea what ...
0
votes
0answers
3 views

Unable to restore testcase database of quality center 9.2

We are using quality center 9.2 for storing test cases. Recently the Quality center server had some issues, so we took back up of entire C drive and formatted the PC and installed OS newly. Now we ...
0
votes
1answer
8 views

How to recover my database in DBF?

I'm getting the following error on starting oracle database throught the enterprise manager console : ORA-01122 : database file 2 failed verification check ORA-01110 : datafile 2 ...
0
votes
0answers
21 views

How to live-update query/view data for order-status update. MS Access [closed]

If anyone remembers File Express by Expressware (a DOS program), this is what I'm trying to replace. I need to create a database to keep track of different custom jobs. (This is not used to print ...
-2
votes
2answers
17 views

Repair Corrupt Access Database File

I am using MS Access 2010 and one of my databases on our shared network does not open for any user. Shows "Unrecognized Database Format." error message. I can't even get it to the point of opening. Is ...
0
votes
0answers
17 views

MS Access .mdb & .ldb database corrupted

I am using a A.mdb database. You know when connecting the databae Microsoft automatically create a .ldb file. Unfortunately my pc shutdown when connecting the database. As a resutl after restart the ...
3
votes
3answers
64 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
9 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?
0
votes
0answers
4 views

Personal queryable address book with document management

Please suggest me any freeware software or cloud solutions that allows: Create and manage a person date (like in address book) Attach any documents to the persons Query the system, e.g. to select ...
0
votes
0answers
19 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 ...
-1
votes
0answers
13 views

Excel 2007 huge data to be filtered and pasted at some other sheet

I have two (and sometime more than two) different files in excel 2007 from which i need to extract data based on some criteria and paste the filtered data to another excel sheet. I was looking for ...
0
votes
2answers
39 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
23 views

SQL database recovery from corrupt database file. What to do next?

Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which contained copies of my SQL Server databases. A few days ago I lost some part of my data due to accidental ...
0
votes
1answer
29 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 ...
0
votes
0answers
13 views

How to create installer for my visual basic project with sql server 2008 database?

Hi guys I have a visual basic project and I developed it using visual studio 2010 and sql server 2008 for my database. Now, I want to make an installer that will include my sql server database. I ...
0
votes
0answers
11 views

How to repair backup of .mdf file database? [migrated]

One of our clients gets the following error when trying to backup a database: System.Data.SqlClient.SqlException: SQL Server detected a logical consistency-based I/O error: incorrect checksum ...
3
votes
1answer
26 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
29 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 ...
-1
votes
0answers
17 views

Excel or R: Make 1 file for each line of a table, preserving the headers

I have 200 lines in an excel table that I'd like to split into 200 files (csv), with the headers maintained in each file. Is there a way I can do this using VBA in excel, or even R? Many thanks
0
votes
1answer
32 views

Access Database design when changing course fee after certain period of time

I currently have three tables: student id (pk) , name course id (pk) , course_name , course_duration , course_fee student_course student_course_id (pk) , student_id (fk) ...
0
votes
2answers
48 views

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

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 ...
1
vote
0answers
26 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 ...
0
votes
1answer
14 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
17 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
3answers
59 views

I'd like to create a database of pictures. Where to begin? [closed]

I'd like to create a searchable database of images. I'd like something a little expandable, meaning I'd like to define my own fields and be able to search on them, but I'd also like to be able to ...
0
votes
1answer
37 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 ...
-5
votes
2answers
60 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
93 views

Installing Oracle 12c on CentOs 6.4

I need to install Oracle DB 12c on Centos 6.5/6.4 that has no GUI (or xserver) installed, Is there a way to do it? Can you point me to a manual? Thanks
0
votes
1answer
28 views

Strategy for Incremental Datasource fetchings in Excel

I am in an scenario with a table that is refresh by a third app every week. I need to keep accumulating all data in Excel, using an ODBC connection to the database. I am wondering Approach 1: Is ...
0
votes
1answer
18 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 ...
2
votes
1answer
37 views

Should I install SQL Server on a SSD drive (educational purposes only)?

I have just started using a 120 GB SSD drive on my laptop. I wonder if it is a good idea to install SQL-Server on this partition. I am sure I will want to install Management Studio there but what ...
1
vote
1answer
27 views

Oracle database block diagram or map

I have an Oracle database. It has multiple schemas, and each schema has many tables. Is there a way to generate a tree diagram or block diagram, such as this image, to visualize the database? I ...
2
votes
1answer
46 views

How can I sync Access databases and keep them up-to-date?

I have an Access database on my server. We split it up and use the front-end database for search data and adding new records or reports in local computer. If we update or add a new record, that writes ...
1
vote
2answers
60 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
50 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 ...
0
votes
0answers
5 views

Inline images in RTF Memo field or other methods for dealing with inline graphics in MS Access

I want to use Access to organize some testing information. I will have normal data fields, but I need some type of way of having text combined with images stored in a memo field. I have already ...
0
votes
0answers
11 views

how to set default data type for create table in dbvisualizer

I am creating a postgresql database in DBVisualizer. Things would go faster if I could gain control over the default data type I get when I create a column. For Postgresql, it defaults to bigint and ...
0
votes
0answers
40 views

Access database shows as read-only on one workstation (unless logging in with domain admin privileges)

We have an Access database stored on a central server on our LAN, accessed by 20 domain-joined PCs (15x Windows 7, 5x XP). For some reason, one of our XP workstations only allows users to access the ...
1
vote
0answers
44 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
0answers
26 views

Database columns dependent on another table column

For illustrate suppose I have two tables, let's say "Client" and "Cart": Client: ID; Primary; Autovalue Name; Debt; Cart: ID; Primary; Autovalue Client; value of Client->ID Product; Value; ...
0
votes
2answers
115 views

Configuring PHPMyAdmin to connect to remote database

After Googling the possibility of using PHPMyAdmin to connect to remote databases, I found this article, which confirms that this is supported after a simple config edit. In the article, the author ...
0
votes
0answers
30 views

How can data collation from different sources in Excel file be accomplished?

I am trying to make a main database Excel file from 5 different colleagues in the same company using Office 2013. The format is going to be same, but how to keep this automatically updated in the Main ...
0
votes
0answers
79 views

Difference between AWS RDS and AWS Opsworks MySql layer?

We are migrating everything over to opsworks and presently we have an RDS server setup for our database. Our plan for deployments is this: Have our production stack (Stack-A) Have our staging stack ...
0
votes
3answers
76 views

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

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
34 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
107 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
191 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. ...
0
votes
1answer
164 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 ...