Tag: oracle

Apache Solr: How to efficiently index large amounts of data?

Apache Solr provides means to search through indexed resources extremely quickly. The indexing process itself, however, can take a lot of time. When one googles “solr indexing efficiency” or “solr efficient indexing” one can find a lot of information on RAM

Tagged with: , , , , , , , , , , , , , , , ,

Advanced faceted search in SQL database using MyBatis

Faceted search is popular technique used in online retailers. Users can search for product using multiple filters, called facets, narrowing result list in each step. In addition to that, filters can show number of products matching each facets for selected conditions.

Tagged with: , , , , , , , , , , , , , , , , , ,

How to create report from XLSX file in Oracle APEX?

In many companies XLSX files (file format that is created by MS Excel 2003+) are used as a standard report data carrier. In some cases this files even replaces simple tables in databases. But almost always there comes a time when

Tagged with: , , , , , , , , , , , ,

How to avoid hard-coding in your PL/SQL code?

Hard-coding – common sense definition Hard-coding appears in our software when we (programmers) write inflexible code with special “magic” values that are meaningful to original coder when written, but when times goes by no one knows what they stand for.  In effect we got code

Tagged with: , , , , , , , , , , ,

How to use MyBatis to effectively perform batch database operations?

During your software projects you must have come across an issue which includes bulk operations on relational database (mass updates, inserts, deletes). As it occurs, performing single statements for bulk operations is lengthy due to the fact that each database action involves using (setting

Tagged with: , , , , , , , , , , , , ,

Hire us!

Pretius is a software development company.
We create web applications using: Java, Oracle DB, Oracle Apex, AngularJS.
Contact us to talk about how we can help you with your software project!