What is a DBA's definition of “batch”?










2















I've heard it being used in relation to SQLite sometimes but never completely understood what it means.










share|improve this question




























    2















    I've heard it being used in relation to SQLite sometimes but never completely understood what it means.










    share|improve this question


























      2












      2








      2








      I've heard it being used in relation to SQLite sometimes but never completely understood what it means.










      share|improve this question
















      I've heard it being used in relation to SQLite sometimes but never completely understood what it means.







      sqlite terminology






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 13 '18 at 6:07









      Evan Carroll

      32k969219




      32k969219










      asked Nov 13 '18 at 5:49









      KentKent

      141




      141




















          4 Answers
          4






          active

          oldest

          votes


















          2














          A batch is a series of SQL commands that are sent to the database server at once. This can be faster than sending each command individually because there is less network communication.



          SQLite is an embedded database; SQL commands are executed directly by the SQLite library.
          There is no separate server, so it would not make sense to have batches. SQLite does not have such batches.




          Another meaning of "batch" might be the multi-row form of the INSERT command:



          INSERT INTO MyTable(ID, Name) VALUES (1, 'this'), (2, 'that'), (3, 'whatever');





          share|improve this answer






























            2














            A group of one or more TSQL commands, such as SELECT or UPDATE, together can form a batch. GO SSMS instruction is used to indicate the end of a batch hence has a role of a separator. You can use multiple GOs to split the statements into multiple batches. Batches are useful during compilation time because SQL Server considers a batch a single unit and assigns a single execution plan to each batch. Batch differs from transaction because its statements are executed separately though they are the same execution plan. So if you have two batches, even if there is an error in the first batch the second batch is going to be execute. Note that both the batch itself and the GO command are not part of the TSQL instead they are useful facilities of SSMS.






            share|improve this answer




















            • 3





              This is an answer when working with Microsoft SQL Server and as such is only slightly relevant for OP. The question is asking for an answer related to SQLite.

              – hot2use
              Nov 13 '18 at 10:30


















            1














            "Batch" is typically a verb, though it may also be a noun. Oftentimes, the technical term for the result of batching is a "transaction." And, more often then not, "batching" is to get around excessive commits with rollback points, or the need to cache or lock for a very long modification.



            If used in the context outside of writes to a database, it can be said that you're batching "jobs" (as the units of work inside a batch). However, in the database the unit of work is normally a DML Statement and those are never referred to as jobs.



            For more information see also Batch Processing (wikipedia)






            share|improve this answer
































              -4














              Batch means "a BUNCH of TASKS"






              share|improve this answer






















                Your Answer








                StackExchange.ready(function()
                var channelOptions =
                tags: "".split(" "),
                id: "182"
                ;
                initTagRenderer("".split(" "), "".split(" "), channelOptions);

                StackExchange.using("externalEditor", function()
                // Have to fire editor after snippets, if snippets enabled
                if (StackExchange.settings.snippets.snippetsEnabled)
                StackExchange.using("snippets", function()
                createEditor();
                );

                else
                createEditor();

                );

                function createEditor()
                StackExchange.prepareEditor(
                heartbeatType: 'answer',
                autoActivateHeartbeat: false,
                convertImagesToLinks: false,
                noModals: true,
                showLowRepImageUploadWarning: true,
                reputationToPostImages: null,
                bindNavPrevention: true,
                postfix: "",
                imageUploader:
                brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
                contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
                allowUrls: true
                ,
                onDemand: true,
                discardSelector: ".discard-answer"
                ,immediatelyShowMarkdownHelp:true
                );



                );













                draft saved

                draft discarded


















                StackExchange.ready(
                function ()
                StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f222395%2fwhat-is-a-dbas-definition-of-batch%23new-answer', 'question_page');

                );

                Post as a guest















                Required, but never shown

























                4 Answers
                4






                active

                oldest

                votes








                4 Answers
                4






                active

                oldest

                votes









                active

                oldest

                votes






                active

                oldest

                votes









                2














                A batch is a series of SQL commands that are sent to the database server at once. This can be faster than sending each command individually because there is less network communication.



                SQLite is an embedded database; SQL commands are executed directly by the SQLite library.
                There is no separate server, so it would not make sense to have batches. SQLite does not have such batches.




                Another meaning of "batch" might be the multi-row form of the INSERT command:



                INSERT INTO MyTable(ID, Name) VALUES (1, 'this'), (2, 'that'), (3, 'whatever');





                share|improve this answer



























                  2














                  A batch is a series of SQL commands that are sent to the database server at once. This can be faster than sending each command individually because there is less network communication.



                  SQLite is an embedded database; SQL commands are executed directly by the SQLite library.
                  There is no separate server, so it would not make sense to have batches. SQLite does not have such batches.




                  Another meaning of "batch" might be the multi-row form of the INSERT command:



                  INSERT INTO MyTable(ID, Name) VALUES (1, 'this'), (2, 'that'), (3, 'whatever');





                  share|improve this answer

























                    2












                    2








                    2







                    A batch is a series of SQL commands that are sent to the database server at once. This can be faster than sending each command individually because there is less network communication.



                    SQLite is an embedded database; SQL commands are executed directly by the SQLite library.
                    There is no separate server, so it would not make sense to have batches. SQLite does not have such batches.




                    Another meaning of "batch" might be the multi-row form of the INSERT command:



                    INSERT INTO MyTable(ID, Name) VALUES (1, 'this'), (2, 'that'), (3, 'whatever');





                    share|improve this answer













                    A batch is a series of SQL commands that are sent to the database server at once. This can be faster than sending each command individually because there is less network communication.



                    SQLite is an embedded database; SQL commands are executed directly by the SQLite library.
                    There is no separate server, so it would not make sense to have batches. SQLite does not have such batches.




                    Another meaning of "batch" might be the multi-row form of the INSERT command:



                    INSERT INTO MyTable(ID, Name) VALUES (1, 'this'), (2, 'that'), (3, 'whatever');






                    share|improve this answer












                    share|improve this answer



                    share|improve this answer










                    answered Nov 13 '18 at 11:57









                    CL.CL.

                    2,70511115




                    2,70511115























                        2














                        A group of one or more TSQL commands, such as SELECT or UPDATE, together can form a batch. GO SSMS instruction is used to indicate the end of a batch hence has a role of a separator. You can use multiple GOs to split the statements into multiple batches. Batches are useful during compilation time because SQL Server considers a batch a single unit and assigns a single execution plan to each batch. Batch differs from transaction because its statements are executed separately though they are the same execution plan. So if you have two batches, even if there is an error in the first batch the second batch is going to be execute. Note that both the batch itself and the GO command are not part of the TSQL instead they are useful facilities of SSMS.






                        share|improve this answer




















                        • 3





                          This is an answer when working with Microsoft SQL Server and as such is only slightly relevant for OP. The question is asking for an answer related to SQLite.

                          – hot2use
                          Nov 13 '18 at 10:30















                        2














                        A group of one or more TSQL commands, such as SELECT or UPDATE, together can form a batch. GO SSMS instruction is used to indicate the end of a batch hence has a role of a separator. You can use multiple GOs to split the statements into multiple batches. Batches are useful during compilation time because SQL Server considers a batch a single unit and assigns a single execution plan to each batch. Batch differs from transaction because its statements are executed separately though they are the same execution plan. So if you have two batches, even if there is an error in the first batch the second batch is going to be execute. Note that both the batch itself and the GO command are not part of the TSQL instead they are useful facilities of SSMS.






                        share|improve this answer




















                        • 3





                          This is an answer when working with Microsoft SQL Server and as such is only slightly relevant for OP. The question is asking for an answer related to SQLite.

                          – hot2use
                          Nov 13 '18 at 10:30













                        2












                        2








                        2







                        A group of one or more TSQL commands, such as SELECT or UPDATE, together can form a batch. GO SSMS instruction is used to indicate the end of a batch hence has a role of a separator. You can use multiple GOs to split the statements into multiple batches. Batches are useful during compilation time because SQL Server considers a batch a single unit and assigns a single execution plan to each batch. Batch differs from transaction because its statements are executed separately though they are the same execution plan. So if you have two batches, even if there is an error in the first batch the second batch is going to be execute. Note that both the batch itself and the GO command are not part of the TSQL instead they are useful facilities of SSMS.






                        share|improve this answer















                        A group of one or more TSQL commands, such as SELECT or UPDATE, together can form a batch. GO SSMS instruction is used to indicate the end of a batch hence has a role of a separator. You can use multiple GOs to split the statements into multiple batches. Batches are useful during compilation time because SQL Server considers a batch a single unit and assigns a single execution plan to each batch. Batch differs from transaction because its statements are executed separately though they are the same execution plan. So if you have two batches, even if there is an error in the first batch the second batch is going to be execute. Note that both the batch itself and the GO command are not part of the TSQL instead they are useful facilities of SSMS.







                        share|improve this answer














                        share|improve this answer



                        share|improve this answer








                        edited Nov 26 '18 at 9:33









                        Michael Green

                        14.5k83060




                        14.5k83060










                        answered Nov 13 '18 at 7:12









                        Eleonora GrigoryanEleonora Grigoryan

                        58314




                        58314







                        • 3





                          This is an answer when working with Microsoft SQL Server and as such is only slightly relevant for OP. The question is asking for an answer related to SQLite.

                          – hot2use
                          Nov 13 '18 at 10:30












                        • 3





                          This is an answer when working with Microsoft SQL Server and as such is only slightly relevant for OP. The question is asking for an answer related to SQLite.

                          – hot2use
                          Nov 13 '18 at 10:30







                        3




                        3





                        This is an answer when working with Microsoft SQL Server and as such is only slightly relevant for OP. The question is asking for an answer related to SQLite.

                        – hot2use
                        Nov 13 '18 at 10:30





                        This is an answer when working with Microsoft SQL Server and as such is only slightly relevant for OP. The question is asking for an answer related to SQLite.

                        – hot2use
                        Nov 13 '18 at 10:30











                        1














                        "Batch" is typically a verb, though it may also be a noun. Oftentimes, the technical term for the result of batching is a "transaction." And, more often then not, "batching" is to get around excessive commits with rollback points, or the need to cache or lock for a very long modification.



                        If used in the context outside of writes to a database, it can be said that you're batching "jobs" (as the units of work inside a batch). However, in the database the unit of work is normally a DML Statement and those are never referred to as jobs.



                        For more information see also Batch Processing (wikipedia)






                        share|improve this answer





























                          1














                          "Batch" is typically a verb, though it may also be a noun. Oftentimes, the technical term for the result of batching is a "transaction." And, more often then not, "batching" is to get around excessive commits with rollback points, or the need to cache or lock for a very long modification.



                          If used in the context outside of writes to a database, it can be said that you're batching "jobs" (as the units of work inside a batch). However, in the database the unit of work is normally a DML Statement and those are never referred to as jobs.



                          For more information see also Batch Processing (wikipedia)






                          share|improve this answer



























                            1












                            1








                            1







                            "Batch" is typically a verb, though it may also be a noun. Oftentimes, the technical term for the result of batching is a "transaction." And, more often then not, "batching" is to get around excessive commits with rollback points, or the need to cache or lock for a very long modification.



                            If used in the context outside of writes to a database, it can be said that you're batching "jobs" (as the units of work inside a batch). However, in the database the unit of work is normally a DML Statement and those are never referred to as jobs.



                            For more information see also Batch Processing (wikipedia)






                            share|improve this answer















                            "Batch" is typically a verb, though it may also be a noun. Oftentimes, the technical term for the result of batching is a "transaction." And, more often then not, "batching" is to get around excessive commits with rollback points, or the need to cache or lock for a very long modification.



                            If used in the context outside of writes to a database, it can be said that you're batching "jobs" (as the units of work inside a batch). However, in the database the unit of work is normally a DML Statement and those are never referred to as jobs.



                            For more information see also Batch Processing (wikipedia)







                            share|improve this answer














                            share|improve this answer



                            share|improve this answer








                            edited Nov 13 '18 at 6:06

























                            answered Nov 13 '18 at 6:00









                            Evan CarrollEvan Carroll

                            32k969219




                            32k969219





















                                -4














                                Batch means "a BUNCH of TASKS"






                                share|improve this answer



























                                  -4














                                  Batch means "a BUNCH of TASKS"






                                  share|improve this answer

























                                    -4












                                    -4








                                    -4







                                    Batch means "a BUNCH of TASKS"






                                    share|improve this answer













                                    Batch means "a BUNCH of TASKS"







                                    share|improve this answer












                                    share|improve this answer



                                    share|improve this answer










                                    answered Nov 13 '18 at 8:17









                                    Erdinc AyErdinc Ay

                                    1249




                                    1249



























                                        draft saved

                                        draft discarded
















































                                        Thanks for contributing an answer to Database Administrators Stack Exchange!


                                        • Please be sure to answer the question. Provide details and share your research!

                                        But avoid


                                        • Asking for help, clarification, or responding to other answers.

                                        • Making statements based on opinion; back them up with references or personal experience.

                                        To learn more, see our tips on writing great answers.




                                        draft saved


                                        draft discarded














                                        StackExchange.ready(
                                        function ()
                                        StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f222395%2fwhat-is-a-dbas-definition-of-batch%23new-answer', 'question_page');

                                        );

                                        Post as a guest















                                        Required, but never shown





















































                                        Required, but never shown














                                        Required, but never shown












                                        Required, but never shown







                                        Required, but never shown

































                                        Required, but never shown














                                        Required, but never shown












                                        Required, but never shown







                                        Required, but never shown







                                        Popular posts from this blog

                                        Use pre created SQLite database for Android project in kotlin

                                        Darth Vader #20

                                        Ondo