Previous in Forum: Excel / Visual Basic Cell Fill Color   Next in Forum: MS Windows Problem
Close
Close
Close
8 comments
Rate Comments: Nested
Associate

Join Date: Jul 2009
Posts: 36
Good Answers: 2

Push, Pull, and...?

07/29/2010 3:00 PM

Hello CR4,

I'm working on some database stuff and wondering if a third relationship between two systems can exist, on top of the two infamous push and pull. Any thoughts? Currently, I am working with the following pseudo-definitions:

  • Push: System A sends out data to System B. "System A pushes to System B"
  • Pull: System A receives data from System B after System A talks to System B, requesting the desired info. "System A pulls data from System B"
  • System A receives information from System B without previous knowledge that data were going to be passed. Slight variation of pull. This would be the same as "System B pushes data to System A", but how would System A view it? "System A ??? from System B"

Maybe my definition of 'pull' is a bit skewed, maybe not. Thoughts? Thanks!

Register to Reply
Pathfinder Tags: push pull relation more
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

"Almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, vote them!
Power-User
United States - Member - American all the way Hobbies - Target Shooting - Aint nuthin like killing an innocent soup can!!!

Join Date: Jun 2010
Location: Brownsville, Oregon, USA
Posts: 345
Good Answers: 10
#1

Re: Push, Pull, and...?

07/29/2010 4:44 PM

Are you thinking like in a CAN-BUS system of communication between sending and recieving units like in an automobile or a farm tractor?

__________________
Give me enough duct tape and I can fix anything!
Register to Reply
Associate

Join Date: Jul 2009
Posts: 36
Good Answers: 2
#2
In reply to #1

Re: Push, Pull, and...?

07/30/2010 9:15 AM

Well not specifically, just a very general sense of the terms. Really just any form of communications between two systems.

Register to Reply
Commentator

Join Date: Jan 2010
Location: Jamestown, North Dakota
Posts: 62
Good Answers: 1
#3

Re: Push, Pull, and...?

07/30/2010 9:29 AM

If "A" has no choice, it will pull. If there are instructions for "A" to pull only when it needs the "whatever," the system remains in stasis: fatal error. In other words, "B" will be pushing a rope up a hill. If this discussion turns philosophical, more terms need to be defined, and cases need to be delineated.

__________________
"Careful planning followed by rapid execution." Napoleon
Register to Reply
Associate

Join Date: Jul 2009
Posts: 36
Good Answers: 2
#4
In reply to #3

Re: Push, Pull, and...?

07/30/2010 9:47 AM

Hmm, so you're saying that in the situation where "System B pushes data to System A", the same can be said: "System A pulls the data from System B"

So, according to your definition, push/pull relations are only based on the direction of data flow? And, the difference in the two situations mentioned right above are only different because of different frames of reference (and the syntax to follow it). AND, your definition does not take into consideration whether the systems had a 'hand shake' before data flow started?

Register to Reply
Commentator

Join Date: Jan 2010
Location: Jamestown, North Dakota
Posts: 62
Good Answers: 1
#5
In reply to #4

Re: Push, Pull, and...?

07/30/2010 11:03 AM

Here, then, is where the real discussion begins. Did "A" request to give or to receive? Did "B" agree to the relationship of being the giver or the receiver? Is there a moderator between the two? The handshake can be seen as the moderator which gives instructions to both "A" and "B." In this case, an outside agency decides who will push and who will pull. If one does not have instructions to push, the other cannot pull, and the other way around. Think of a man pushing a cart while another is pushing it from the other end. If both agree that the one behind is to push while the one in front is to pull, then the information to both is correct. That information has to come from the moderator (or, the handshake). Indeed, an agreement has to be reached before an outcome can be predicted: that is, the end desired. In this case, you're right in assessing that syntax is critical. A second definition, therefore, that has to be clarified is whether "A" or "B" can act alone. Certainly, this last concern enters the domain of the Koan.

__________________
"Careful planning followed by rapid execution." Napoleon
Register to Reply
Associate

Join Date: Jul 2009
Posts: 36
Good Answers: 2
#7
In reply to #5

Re: Push, Pull, and...?

07/30/2010 2:25 PM

To answer your questions:

Did "A" request to give or to receive?

  • System A did not request to receive the data. System B just forced it to System A.

Did "B" agree to the relationship of being the giver or the receiver?

  • Not quite sure what you meant in this question. But, B is not necessarily exclusively a giver or receiver system, this example, both systems could be both a giver and a receiver.

Is there a moderator between the two?

  • No moderator between the two. Only very basic system-to-system connection, with no limitations based on certain 'roles' (either a giver or receiving) for each system.

Thanks for the input on the cart pushing example. Let me try to give another example though.

Let's say system Foo has expense reports for a company. On a weekly basis, Foo pushes the expense report data to system DataBase, which happens to be the enterprise database containing all of the company's records. DataBase simply stores data as it receives it, and therefore, we can assume it takes on no other roles. At the end of the week, Foo pushes the week's data to DataBase.

Now, the underlined section is 100% right (if there are concerns, I will start to really question how much I actually know about technology ). BUT, how would the DataBase system look at the data transaction? *Would it be appropriate to say "DataBase pulls from Foo", even though DataBase never sends out a request for the data? *

Whenever I hear the term 'pulling', I think of what you said J-Rod, an member acting on something (data in this case, a cart in your example) and bringing that thing closer to itself, which implies an active state of action from the source. But DataBase just happens to be idle and all suddenly receives this data from Foo without prior knowledge; it had no active action in the transaction. So Foo would be the guy pushing the cart, DataBase would be the guy laying on the ground, about to get hit by the cart. I hope that makes sense . Thoughts?

Register to Reply
Guru

Join Date: Dec 2009
Posts: 581
Good Answers: 15
#6

Re: Push, Pull, and...?

07/30/2010 2:21 PM

There's client-server, master/slave, peer-to-peer and shared storage. (I'm not familiar with a more commonly accepted term for the latter.) I can't think of any other arrangement. There's "gray" between the arrangements. Before a server fulfills a client's request, it may request identification or authorization. A P2P device may function exclusively as a server to the other, and either side might play the role of master or slave, or switch around as needed.

In a shared storage arrangement, both sides write and read data to/from the same medium. Some mechanism is needed to prevent collisions (writing to the same location at the same time), and it's often nice to be notified of updates, but it otherwise works wonderfully in appropriate roles.

__________________
Ignorance is no sin. Willful ignorance is unforgiveable.
Register to Reply
Guru
Popular Science - Biology - life lover Hobbies - Musician - music lover Safety - Hazmat - better safe than sorry United Arab Emirates - Member - desert trek Technical Fields - Procurement - procurement

Join Date: Sep 2008
Location: Dubai, UAE
Posts: 744
Good Answers: 58
#8

Re: Push, Pull, and...?

08/01/2010 5:07 AM

I'm thinking in simplistic terms here and am attempting to re-define the transactions between the 2 systems, named FOO & BAR:

  • PUSH: FOO sends data to BAR. "FOO pushes to BAR";
  • PULL: FOO requests data from BAR. "FOO pulls data from BAR" (during the transaction, naturally, a PUSH from BAR occurs, but let's ignore that for the moment);
  • PULSH: FOO sends data to BAR. BAR receives data and also pushes data to FOO. "FOO and BAR shares data and updates each other simultaneously".

Assumptions:

  • standard handshake before each transaction;
  • standard log-off and link-off after each transaction;
  • all transactions are automatic as programmed.

so you see that I've entirely changed the definition according to which system initiates the transaction. this is the key word. "pulling" is not exactly synonymous to "extracting", only similar. IOW, the initiating system PULLS only after getting an approval for the REQUEST to pull. Extracting does not require authorization.

in plain terms, PUSH happens when the initiating system sends out data.

a PULL happens when the initiating system requests for the data.

a PULSH happens when a PUSH or PULL is taking place, but both systems are updated in the process.

just 2 cents from an antiquated systems man.

__________________
Now the darkness only stays the night-time, in the morning it will fade away. -- George Harrison (All Things Must Pass)
Register to Reply Score 1 for Good Answer
Register to Reply 8 comments

"Almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, vote them!
Copy to Clipboard

Users who posted comments:

farmatt (1); J-Rod (2); langyaw (1); Lynn.Wallace (1); RScincy (3)

Previous in Forum: Excel / Visual Basic Cell Fill Color   Next in Forum: MS Windows Problem

Advertisement