Abstract: Embodiments for storing a JSON document tree in a single SQL database table by defining a schema to store JSON nodes in the table and converting each JSON document into a corresponding set of rows in the table using the schema to encode a hierarchical relationship of nodes and sub-nodes into a path that specifies a node path to a root node for each node. Embodiments further receiving a SQL query to retrieve a specific sub-document, responding to the query by returning all rows of the table belonging to the sub-document, and inflating the returned rows back into a JSON expression using the path to guide reconstruction of the original JSON document tree.

Abstract: Embodiments for storing a JSON document tree in a single SQL database table by defining a schema to store JSON nodes in the table and converting each JSON document into a corresponding set of rows in the table using the schema to encode a hierarchical relationship of nodes and sub-nodes into a path that specifies a node path to a root node for each node. Embodiments further receiving a SQL query to retrieve a specific sub-document, responding to the query by returning all rows of the table belonging to the sub-document, and inflating the returned rows back into a JSON expression using the path to guide reconstruction of the original JSON document tree.

Abstract: And integration of mobile communication devices and stationary communication devices is achieved by employing a computing device that is associated with a stationary communication device and that is coupled to a communications platform that can control call routing, call transfers and other message routing. When the computing device detects that a mobile communication device is proximate (i.e., such as by using paired blue tooth devices), the computing platform sends a command to the communications platform to have future calls sent to the stationary communication device and, if a call is active, to have that call transferred to the same. Similarly, if the mobile communication device is no longer proximate to the computing device, a command is sent to the communication platform to direct communications to the mobile communications device.