Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
COURSE of the MONTH
11 days, 1 hour left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Where is your data?
Posted on 2011-03-25
I attended a good speech the other day on database security and one issue the guy asked was whether folk knew where their data was. I think some folk have a one dimensional view that data resides in the MS-SQL, Oracle DB and no where else.
As DBA’s can you give me a big list of everywhere corporate data for a specific system can go/end up. For example at a top level if you ask me you information system
1) gets/obtains data (online forms, data feeds, data extracts)
2) stores it and makes it available to the end user via some GIU (web app, intranet app, report viewer i.e. crystal)
3) exports data/processes it further (reports, test databases, extracts, backups)
Are there any more stages? Also where can your data come from? Some systems can obtain the data via online forms, but there must be other apps that get data from other means, i.e. not directly from the user.
Can you give me some examples in the lifecycle of database/information system, everywhere that “data”, intended for the database, can reside in your IT environment? From one extreme to the other, any where data could be stored in the IT environment for stages 1, 2, or 3.
As DBA’s can you give me a big list of everywhere corporate data for a specific system can go/end up. For example at a top level if you ask me you information system
1) gets/obtains data (online forms, data feeds, data extracts)
2) stores it and makes it available to the end user via some GIU (web app, intranet app, report viewer i.e. crystal)
3) exports data/processes it further (reports, test databases, extracts, backups)
Are there any more stages? Also where can your data come from? Some systems can obtain the data via online forms, but there must be other apps that get data from other means, i.e. not directly from the user.
Can you give me some examples in the lifecycle of database/information system, everywhere that “data”, intended for the database, can reside in your IT environment? From one extreme to the other, any where data could be stored in the IT environment for stages 1, 2, or 3.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
2
5 Comments
I would add message queues into the mix - think enterprise service buses. When it comes to security, i'd add in excel, emails, print outs, flat files etc as people often use these systems when looking at or dealing with data.
Active 2 days ago
Hi Dave, not familiar with:
"message queues into the mix - think enterprise service buses."
Can you clarify in lay persons terms?
"message queues into the mix - think enterprise service buses."
Can you clarify in lay persons terms?
A message bus is an asynchronous way of sending data between services which can be on completely different platforms. e.g. you could have data being generated by a variety of different mechanisms and they all stick their data onto the bus/queue. Then you configure listeners to pick up and retrieve/make use of this data.
See here for more info - http://msdn.microsoft.com/en-us/library/ff647328.aspx
or here - http://en.wikipedia.org/wiki/Enterprise_service_bus
re: flat files, they are just files outside of the database. e.g. someone connects to sql server and exports all of a particular tables data to a .txt or .csv file.
See here for more info - http://msdn.microsoft.com/en-us/library/ff647328.aspx
or here - http://en.wikipedia.org/wiki/Enterprise_service_bus
re: flat files, they are just files outside of the database. e.g. someone connects to sql server and exports all of a particular tables data to a .txt or .csv file.
also, really depending on how tight you want your security to be, but if someone has emailed data then the email will reside in multiple places - the sender, the exchange server (or similar) and the target destination. On top of that, if you have indexing services on your computer (such as google desktop) then the contents of the files will also be in those indexes.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes. We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses
Course of the Month11 days, 1 hour left to enroll
770 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.