0
votes
0answers
8 views

Load Multiple images (BLOBs) into the Oracle Database

I have a folder with several images. My database table is a simple table with 2 fields: name (char) and image (BLOB). How can I import my images located in my C disk (e.g.: C:\Users\me\images) into my ...
2
votes
3answers
42 views

Extract string in PostgreSQL 9.2

I got the following column: full_path "gorfs"."absolute_pathname" It keeps the path of a BLOB, like on the example below: Note that the 4865 is the account_id.The path is always like: ...
2
votes
0answers
44 views

LOB_DATA, slow table scans and some I/O questions

I have a rather big table with one of the columns being an XML data with an average size of XML entry being ~15 kilobytes. All other columns are regular ints, bigints, GUIDs etc. To have some concrete ...
1
vote
2answers
12 views

Is there a list what datatype corresponds to the system_type_id in Sys.columns

Is there a list what datatype corresponds to the system_type_id in Sys.columns. I am looking for an easy way to examine the columns we have in the database and i would like to avoid the ...
0
votes
0answers
27 views

I do not see much performance between implicit & explicit transactions

DBCC SQLPERF('sys.dm_os_wait_stats', CLEAR); IF OBJECT_ID('tempdb..#wait') IS NOT NULL DROP TABLE #wait GO /************************************* ** Create a test database ...
1
vote
0answers
11 views

How to find the number of tuples that are vacuum-eligible?

I am trying to find the number of vacuum-eligible tuples in one of our postgres tables. This is the output of vacuum verbose on that table INFO: "act_msgs": found 0 removable, 2217083 nonremovable ...
0
votes
1answer
14 views

Can't figure out how to update a column in one table based on multiple boolean values in another table in postgresql

What I want to happen is boolean milestone.milestonecompleted will turn true only if ALL of the linked boolean task.taskcompleted values are True I've looked around and come up with this. Any help ...
1
vote
1answer
27 views

Looking for suggestions to model a database of Electrical Components

We have a database of electrical components and I am trying to make sure I have a good design. I am not a database designer (my comfort zone is designing with these hardware components), so I am ...
6
votes
2answers
90 views

Normalizing a table with a field that generally uniquely identifies a row, but is sometimes null

forgive me if this has been asked and answered before. I'm roughing out a schema for an inventory management system, to be implemented in PostgreSQL. All of our products and services have a sku. ...
0
votes
0answers
9 views

Workload Capture

Hopefully this is a straight forward question. But if I want to capture a workload then all I need to capture are: RPC:Completed SQL:BatchCompleted I don't need to capture SP:StmtCompleted do I, ...
1
vote
0answers
29 views

Is there ANY risk in granting a superuser CREATE and ALTER procedure permissions in a specific schema?

I have a developer who has created a set of procedures/functions/views he uses to perform configuration analysis in a large application (provides much higher productivity than using the formal ...
0
votes
1answer
16 views

Can I load a CSV into a stored procedure that inserts into multiple tables?

OK, an example is often easier to follow, so here is my procedure: delimiter // CREATE PROCEDURE mysql.insertTables (_first_name varchar(30), _last_name varchar(45), _create_time timestamp, ...
0
votes
0answers
15 views

Help with SSIS Framework- Resolve Referrences in Data Flow

LineageString and StageKey are both unmapped. SSIS is giving me an error between the OLE DB Source and the Add metadata. Add Metadata.Inputs[Derived Column Input].Columns[LineageString] has lineage ...
-6
votes
1answer
28 views

SQL Simple Question [on hold]

This looks correct to me, however I receive a table where figures exceed $40.0?
2
votes
1answer
43 views

Filtering UNION ALL result is much slower than filtering each subquery

(edit: see end for a simpler example) I'm searching in a table named "cases" (135k rows, 29 columns). Some of the rows in this table have a type of parent-child relationship (of different types), ...
0
votes
0answers
11 views

SQLite text columns

When having a table in SQLite that has a TEXT data type, is there any implication if the length of the contained string differ significantly?
0
votes
0answers
27 views

Want To Learn About MongoDB [on hold]

I am doing a little bit of research on MongoDB related to the following key points: (i) Experiment And Results (In which applications, MongoDB is used and what are the results) (ii) Threat To ...
0
votes
0answers
28 views

Move/ Migrate SQL Server 2012 Virtual machine (Win 2012) to new Physical host [on hold]

There are virtual sql servers on d/f physical hosts and I want to know what is the recommended way to move them to One physical host (Hyper-V) running multiple VM's in one data center and have same ...
0
votes
2answers
44 views

Name already been used by an existing constraint after renaming the table and creating a new one

I would like to know why, if I alter a table name to different name and then create a table with the same name, I am getting the error "name already been used by existing constraint". This is the ...
1
vote
0answers
25 views

Is this database in 1NF, 2NF and 3NF?

I'm doing a software development course and I have to normalise my tables as part of it. Can anyone double check that my data is normalised correctly? The database is for a gym. It has these tables ...
2
votes
1answer
16 views

Why does Cassandra recommend against creating an index on high-cardinality columns?

The Cassandra documentation states, Do not use an index in these situations: On high-cardinality columns because you then query a huge volume of records for a small number of results. See ...
2
votes
0answers
30 views

How do I guarantee inventory numbers are unique across all tables?

I have an assortment of physical objects which need to be inventoried and each type of object has it's own table. For two example objects, let's use 'swords' for the table containing different swords ...
0
votes
0answers
53 views

SQL Server data file growing

We have an odd situation happening with one of our tables in our database and I am hoping someone can shed some light on it. This table has 3 columns id(bigint), ...
0
votes
0answers
26 views

Postgresql BDR problem compiling pluging

I'm trying to build deb packages for postgresql BDR plugin, but I'm getting the following error: gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels ...
0
votes
0answers
14 views

For about ~50,000 - 100,000 records, how much RAM is required for analysing? [on hold]

I'm working on A Python Data Analysis Project. The Database would contain about ~50,000 to ~100,000 records. How much Ram would I need perform the processing in how much time? i'm working on 64 bit ...
1
vote
1answer
24 views

(SOLVED) Mysql bug decimal comparison

I'm currently writing unit tests for a stored procedure that calculates the amount of taxes and the tax rate based on the country/province the customer lives in. Somehow, MySQL considers that ...
0
votes
4answers
47 views

How can I use MySQL variables in subqueries?

I'm trying to run the following query, but it keeps getting "reduced" and failing. Cannot get MySQL to provide any information as to why. Here's the query: SELECT * FROM animals WHERE name IN(SELECT ...
0
votes
0answers
11 views

use Case Diagram [on hold]

There is an organization that provides residential facility to their staff and allot a colony for this purpose. There is also a school for girls and boys separate in it where the children of the ...
7
votes
0answers
52 views
+100

Keeping (Partial) Backups Small when using SQL Server FILESTREAM

I have a database with nearly 1TB of FILESTREAM data that I don't need backed up (if the data was deleted it'd be recreated automatically in a couple of hours, so it just isn't important). Most of the ...
0
votes
1answer
18 views

OLEDB provider for linked server reported change of schema version error

I am trying to run a report but its giving this message: An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'ParamYear'. ...
1
vote
1answer
17 views

Managing ibtmp1 File Growth on MySQL 5.7

We recently upgraded to MySQL 5.7, and now we're into production we're finding the ibtmp1 file is growing on a few servers. Mostly it's not a problem, but we have had a couple of scary moments where ...
2
votes
0answers
12 views

What do LC_TIME and LC_NUMERIC settings actually change in PostgreSQL?

According to the PostgreSQL 9.5 documentation, LC_TIME affects "Formatting of dates and times" and LC_NUMERIC - "Formatting of numbers", but I can't seem to see any difference from changing these. ...
-1
votes
0answers
45 views

Oracle session killed, but the table still not released [on hold]

Oracle session killed(using alter system kill session command), but the record is still not released(err : could not reserve a record), even after restarting DB server (node 1 and 2) and all ...
0
votes
1answer
19 views

How to set a mongodb node to return as the primary of a replication set?

There is this question here: How to force a mongod to become primary in a replica set? But it was not the answer I was looking for. and there is the question below, which could be related but it is ...
5
votes
0answers
19 views

Writing a query that accepts multiple sets of values in postgresql

I am trying to write a query in postgres that accepts multiple sets of values. My knowledge of postgres is brief and this below query is the most complicated I have had to put together to finish off ...
0
votes
1answer
52 views

Simple SQL question [on hold]

I'm try to resolve this but I don't understand? My query Select FirstName, City FROM Customer WHERE City NOT IN ('Paris') Error Your answer does not contain the expression <>
0
votes
0answers
3 views

variable declaration and alteration in a trigger

For instance, I have a table with 3 different columns. Those columns are all defined as varchars. I insert 2 of those columns and i want a trigger, which generates the third column by merging the 2 ...
1
vote
2answers
82 views

sys.dm_sql_referencing_entities not returning results

No doubt this is syntax or typo...but when I query sys.dm_sql_referencing_entities for a parent table, I get zero results. No error, just no results. USE [source]; GO SELECT * FROM ...
0
votes
0answers
19 views

problem with column oriented dbms features

I am currently looking for a free(or at least low cost) column oriented DBMS with really good compression abilities (at least 10:1 ratio) and fast response time. Having evaluated multiple open source ...
1
vote
1answer
21 views

Versioning entities in db with draft option, select query

I have postgresql db where i keep data for jee application. User can edit those data without creating new version of entity(draft). During edit, entity is copied as draft(version set to -1) after ...
0
votes
0answers
9 views

Algorithm of decomposition in Boyce-Codd Normal Form

I have to give the keys of the following relation, say if they are 1,2 or 3NF and give a BCNF decomposition. Yet I think I misunderstand the difference between 2NF and 3NF: R(A,B,C,D,E) with ...
0
votes
0answers
31 views

Oracle Netca is configuring IP instead of hostname in listener

I have a standardized Windows 2012 image that I'm running a build package on. On multiple servers it uses hostname in the listener file, but on one test machine it defaults to IP. Is there a reason ...
0
votes
0answers
16 views

Backup and restore specific filegroups [duplicate]

I've seen this Stack Overflow question: Backup and restore SQL Server database filegroup. However, it didn't do what I needed. I have a database with three filegroups: primary, reporting, and ...
-1
votes
0answers
33 views

normalize table data

Maybe my question is duplicate or asked many times, but it's rare, and I really need this. I have a table, which contents looks like: Id points 3 20 3 42 4 40 4 60 6 20 6 30 5 10 ...
-1
votes
0answers
11 views

Trigger to calculate one column from other table [on hold]

I have a table called employee that has these columns: id Fname lname super_id department_Num I also have another table called department, which has these columns: dep_num name manager_id (FK → ...
0
votes
0answers
40 views

Design a ER for hospital database system [on hold]

I trying to design an ER Diagram for a hospital database, and the developer of the database determent what they want in the system of the hospital .. but some of what they want I cannot understand it ...
0
votes
0answers
9 views

PostgreSQL (Sync Replication) and Pgpool Load Balancing

I am trying to configure pgpool as load balancer for synchronized replicated PostgreSQL servers. I configured PostgreSQL servers and they are running normally. But I want to send write queries to ...
0
votes
0answers
12 views

postgresql service fails to start after bad reboot

I have a postgresql 9.3 running on Ubuntu 14.04. For some reason, my fellow developer rebooted the server and since then postgresql service is failing to start. Also, the reboot didn't go smooth as it ...
0
votes
0answers
16 views

Add new data center in EC2 [on hold]

I have 3 node local data center I'm using PropertyFileSnitch, and have 1 node in EC2 using Ec2MultiRegionSnitch, and set topology Manuel when run dsetool status in each data center I get that. local ...
0
votes
0answers
5 views

MongoDB: what is the better way to implement shared record with ability to remove it by each user

I have a MongoDB record, for example, called Letter. This letter can be sent to some group of users, so many users have an access to it. A Letter can be sent in a context of Topic that is shared ...

15 30 50 per page