Please use this identifier to cite or link to this item:
https://open.uns.ac.rs/handle/123456789/14259
DC Field | Value | Language |
---|---|---|
dc.contributor.author | Ivankovic Z. | en |
dc.contributor.author | Markoski, Branko | en |
dc.contributor.author | Ivkovic M. | en |
dc.contributor.author | Radosav, Dragica | en |
dc.contributor.author | Berkovic I. | en |
dc.date.accessioned | 2020-03-03T14:55:33Z | - |
dc.date.available | 2020-03-03T14:55:33Z | - |
dc.date.issued | 2010-10-26 | en |
dc.identifier.issn | 18401503 | en |
dc.identifier.uri | https://open.uns.ac.rs/handle/123456789/14259 | - |
dc.description.abstract | Bulk operations are the advantage enabled by Oracle database. They are used through PL/SQL programming language and significantly decrease time necessary to fulfill statements on large amount of data. Their advantage is that a large amount of data is transferred in a single step into SQL where they are executed, data are retrieved from it. In this way, it is avoided that for every row from a table a change of context is being done between PL/SQL engine and SQL engine. Difference in execution time is increasing with the number of rows to process. Bulk operations may be used also with a predefined maximal number of rows that will be transferred between two engines in a single step. In this way a memory overload is avoided, which improves performances additionally. Performances comparison will be shown at a PL/SQL block which will execute without bulk operation and then with it. These executions will be done on a table with different number of rows so the differences in performance over different amount of data could be measured. | en |
dc.relation.ispartof | Technics Technologies Education Management | en |
dc.title | Use of bulk operation to speed up queries | en |
dc.type | Journal/Magazine Article | en |
dc.identifier.scopus | 2-s2.0-77958088312 | en |
dc.identifier.url | https://api.elsevier.com/content/abstract/scopus_id/77958088312 | en |
dc.relation.lastpage | 494 | en |
dc.relation.firstpage | 484 | en |
dc.relation.issue | 3 | en |
dc.relation.volume | 5 | en |
item.fulltext | No Fulltext | - |
item.grantfulltext | none | - |
crisitem.author.dept | Katedra za informacione tehnologije | - |
crisitem.author.dept | Katedra za informacione tehnologije | - |
crisitem.author.parentorg | Tehnički fakultet "Mihajlo Pupin" u Zrenjaninu | - |
crisitem.author.parentorg | Tehnički fakultet "Mihajlo Pupin" u Zrenjaninu | - |
Appears in Collections: | TFZR Publikacije/Publications |
Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.