Wednesday 15 January 2014

sql server - Data Correlation in large Databases -


We are trying to identify the locations of some information stored in our enterprise in order to comply with our data policies . At the end of the file, we are using Nassus to search through different files, but I am thinking of ending the database.

Use of Nessus will be unusually waste as it will produce raw data and tell us what was in that table or row, or gave us very useful information, especially considering these databases. It's big enough (hundreds of gigabytes).

It is also worth noting that the system should be capable of doing pattern-based matching (such as using regular expressions) not just a dumb search engine.

I've checked the use of data mining and data storage to find this data, but it seems that rather than finding data, they are more in data analysis.

Is it a better way to find and store large amounts of data in the database to try and achieve this information? We are using both Oracle 11g and SQL Server 2008 and need to do searches on both, so I want to stay away from server-specific criteria (although if I want to translate from T-SQL to PL for something Code is rewritten / SQL, and on the contrary, I do not mind)

search for large amounts For text on SQL Server, you can see full text in search

Read more here < / P>

But if I am reading right, then you want to spice up your database equally how to find web search engine spider web sites and web pages.

You can use a set of full text queries that bring back the spread of several tables.


No comments:

Post a Comment