Questions tagged [shred]

Shredding refers to the decomposition of XML data structures into the columns of a relational database. It can also refer to overwriting the contents of a file in an attempt to prevent recovery of deleted data.

64 questions
12
votes
3 answers

Shred: Doesn't work on Journaled FS?

Shred documentation says shred is "not guaranteed to be effective" (See bottom). So if I shred a document on my Ext3 filesystem or on a Raid, what happens? Do I shred part of the file? Does it sometimes shred the whole thing and sometimes not? …
Dan
  • 9,935
  • 15
  • 56
  • 66
8
votes
1 answer

Shredding XML from table column into a view in SQL Server

I currently have this code which stores XML into an XML-type column called data, in a table called Storage. CREATE TABLE Storage ( ID INT IDENTITY(1,1) PRIMARY KEY, data XML NOT NULL ) GO INSERT INTO Storage(data)…
user1320771
6
votes
3 answers

Modify XML in SQL server to add a root node

To give some background to this problem first, I am rewriting some code that currently loops through some xml, doing an insert to a table at the end of each loop - replacing with a single sp that takes an xml parameter and does the insert in one go,…
DannykPowell
  • 1,227
  • 5
  • 18
  • 30
5
votes
3 answers

Shredding files in .NET

Is there a SDK that can be used in managed code to shred files securely? EDIT: This is the only link i could find in google that helps me EDIT: Either SDK or some kind of COM based component.
Developer
  • 17,809
  • 26
  • 66
  • 92
4
votes
2 answers

Writing a file shredder in python or ruby?

In the effort to learn python and/or ruby, I was wondering how a file shredder would be implemented? I would like it to take in a file as an argument and then employ an algorithm to make that file unrecoverable. Would possibly add the support for…
pmilb21
  • 91
  • 1
  • 3
4
votes
3 answers

Permanently delete file in Qt

I had to change the program on Qt that I did not write. I located the place in the code and know what I want it to, but I do not know what to change, so seek help. Code is as follows: QFile file(path); qint64 size = filesize(path); qint64…
user3497819
  • 41
  • 1
  • 2
4
votes
0 answers

XML Oracle - Extract Repeating Nodes

I have xml doc loaded in to xmltype column in Oracle 11g. My doc has repeating nodes that I need to flatten. I have been using XMLTable but get the singleton error. I found a solution if child nodes were involved, but cannot get it to work with…
rbgilder
  • 41
  • 3
3
votes
2 answers

Extracting a value from an XML column in SQL Server

I am trying to extract the data values present in the FirstName and LastName from the below XML which is present as a string in a column in a SQL Server table.
PSA
  • 53
  • 1
  • 3
  • 13
3
votes
1 answer

Shredding XML column in SQL Server into new tables

I have a source table, each row of which has an XML field that contains an unknown number of survey responses that I need to shred and put into output tables. I've tried nodes and OPENXML and I can't seem to get it working. From my research, I'm…
Sunny
  • 33
  • 4
3
votes
1 answer

Shredding XML file is not returning all of the data

I have an XML file that looks like this:
Gloria Santin
  • 2,066
  • 3
  • 51
  • 124
3
votes
1 answer

Parse/Shred Huge Complex XML to SQL Server 2008 Database (30+ tables)

I read this already: The Best Way to shred XML data into SQL Server database columns and Looking for a good Bulk Insert XML Shredding example for SQL 2005. The differences of why I'm posting is that I'm using BizTalk 2009 and SQL 2008. I'm…
NealWalters
  • 17,197
  • 42
  • 141
  • 251
3
votes
1 answer

sql server 2008 xml file to table

I have an xml file that I'm trying to import into a table. My xml file looks like this:
user1547369
  • 51
  • 1
  • 1
  • 4
3
votes
1 answer

Create virtual 'shredder' printer

I need to create a virtual printer that 'shreds' Basically here is my problem. I have a software program that needs to 'print' a file before it will save it. I want to be able to print to my shredder so that it saves the document, but I don't…
Usta
  • 271
  • 5
  • 14
2
votes
1 answer

Shredding XML from DB using SSIS

I am looking for a way to pull XML from a SQL database and shred the XML via SSIS in bulk. I currently have a package that can pull XML from the database and pass the XML to a stored procedure, via variable, for shredding but this only works 1…
Chris
  • 838
  • 1
  • 15
  • 27
2
votes
4 answers

File Shredding Concept question

I have a file shredder on my computer, and I wanted to know if it's possible to make one in JAVA just for learning sake. But, I'm not sure how exactly it works, so this is what I think it does, please correct me where I'm wrong. So basically it…
Austin
  • 4,801
  • 6
  • 34
  • 54
1
2 3 4 5