BlobCity DB comes with complete capability for running stored procedures. These procedures can be Java or Scala code snippets that follow API standards defined by BlobCity DB. Stored procedures are a way of executing important business logic that interacts closely with the data and has the lowest latency of connectivity with the actual data store.
The types of stored procedures available in BlobCity are listed below:
Simple Stored Procedure
A generic single node execution stored procedure. Can take user defined input
Invoked on any DML operation performed on the data. Can be invoked pre or
A ultra high speed select all with search criteria. Will test all records in a
Used only during data insert operations for finer control on how database
You can create and deploy web-service end points into the database. This
Used to export data from BlobCity in a custom format. The stored procedure produces a data object of the desired format, which is then written to a file as a data export. The file can be accessed using FTP from the database server.
Updated 2 years ago