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.
Questions tagged [shred]
64 questions
2
votes
2 answers
SQL: Using XML as input to do an inner join
I have XML coming in as the input, but I'm unclear on how I need to setup the data and statement to get the values from it. My XML is as follows:
246
247
248
And I want to do the…
JTR
- 25
- 4
2
votes
1 answer
Data destroy using shred agains ext4 filesystem
I'm running shred against blockdevice with couple of etx4 filesystems on it.
The blockdevices are virtual drives - RAID-1 and RAID-5. Controller is PERC H710P.
command
shred -v /dev/sda; shred -v /dev/sdc ...
I can understand from shred man(info)…
etharendil
- 83
- 1
- 3
- 7
2
votes
1 answer
TSQL Shred XML - Working with namespaces
Here's a link to my previous question on this same block of code with a working shred example
Ok, I'm a C# ASP.NET dev following orders: The orders are to take a given dataset, shred the XML and return columns. I've argued that it's easier to do the…
jcolebrand
- 15,889
- 12
- 75
- 121
2
votes
1 answer
XML Shredding into SQL Server
I have an XML doc in the following format.
US CDB GI MMPS
…
RagePwn
- 411
- 2
- 8
- 22
2
votes
2 answers
Does an XML schema or DTD exist for PerformancePoint's Xml Metadata?
I wrote several XQuery statements to shred existing KPI and Dashboard metadata but I would like to validate my queries by reviewing the corresponding Xml Schema or DTD if it exists. I searched online but could not find what i was looking for.
The…
Athens Holloway
- 2,183
- 3
- 17
- 26
2
votes
1 answer
Sql Server - XML shredding where xmlns is defined
I have problem shredding an XML file if xmlns is defined in a document as seen here:
DECLARE @XML XML
SET @XML=N'
Janka P
- 57
- 1
- 5
2
votes
1 answer
Looking for a good Bulk Insert XML Shredding example for SQL 2005
A little help needed. I'm receiving an xml file similar to this:
mrankin
- 2,373
- 3
- 25
- 29
2
votes
1 answer
XML Shredding to include attribute and inner element value
Consider the following XML fragment:
56.89
10.75
0.00
67.64
TelJanini
- 835
- 9
- 25
1
vote
1 answer
Row numbers when shredding XML in SQL Server
I'm trying to add row numbers in the DAY_VALUE column that reset after each inventorymodel. I have a start, but I can't them to reset or count up instead of having ties. It would look something like…
owneyjs
- 73
- 1
- 8
1
vote
0 answers
Securely delete Docker container or image
I need to securely delete all persistent data abount containers and docker images.
For example for a certain temporary container runned.
I mean secure deletion performed by tools like shred or srm, repeated overwriting zero ora random data on…
stefcud
- 2,220
- 4
- 27
- 37
1
vote
1 answer
Shredding XML in using OpenXML
I am trying to shred the following XML, but I am unable to get any results using the OPENXML construct but my output does not look correct. Any suggestions on how I can re-write this?
…
Sarath
- 221
- 2
- 9
1
vote
1 answer
Using tail to monitor an active logging file
I'm running multiple 'shred' commands on multiple hard drives in a workstation. The 'shred' commands are all run in the background in order to run the commands concurrently. The output of each 'shred' is redirected to a text file, and I also have…
Knightshift97
- 21
- 2
1
vote
2 answers
How to create a new list item with FLOWR and XQuery?
I'm looking to select non-numerical data from an XML file towards shredding it into database columns, or at least an xmltable-like structure. This FLWOR gives a somewhat useful result:
xquery version "3.0";
declare namespace…
Thufir
- 8,216
- 28
- 125
- 273
1
vote
2 answers
How to add shred to KDE context menu for safe deletion of file/folder?
How to add the shred utility to the context menu in Dolphin (Linux Mint 18 KDE) for removing files and folders?
mixalbl4
- 3,507
- 1
- 30
- 44
1
vote
1 answer
XML shredding in VB6 / find max attribute value
I'm new to SO--I hope I'm posting this in the right place.
As an update to my post below, I've found one way of getting the City portion of the address. I don't really need the max value as suggested in my original post; I just need the last value…
BRW
- 187
- 1
- 10