woensdag 14 oktober 2009

Database technology vs. Search technology

Today I read this article on Beyond Search about strugling with large datasets in a database.

Search technology can scale very easy with products like Autonomy IDOL and Exalead.
Oracle RDBMS is good (the best?) at managing structured data but is not capable of handling transactions AND queries at the same time.

Using search technology in conjunction with database technology simplifies the managing of an Oracle environment. Much time is spend in optimizing the databases to serve both transactions and querying.
The path that is needed for updating and inserting records is totally different from the path that must be followed to find information. Many hours of database administrators are spend on this subject.

My advise:Invest in optimizing the RDBMS to handle transactions and VERY specific questions on detailed data. Invest in a good and scalable solution based on search technology to handle the queries.
With this "database offloading" strategy you will be able to let your dataset grow and still be able to manage it as well as make it usable for all processes and users in your company that need the data.

Geen opmerkingen: