Visual manipulation of database schema
First Claim
Patent Images
1. A method comprising:
- providing for display on a touch-sensitive surface of a mobile device a schema view and a data view, the schema view displaying a schema of a database and comprising one or more data fields, the data view displaying at least one data record, the data record including a first data field defined by the schema;
receiving a touch input on the touch-sensitive surface, the touch input dragging a second data field from the schema view into the data view, the second data field being a component of the data record that was hidden from the data view before receiving the touch input;
in response to the received touch input,updating the schema view and the data view, including;
shifting a display location of the first data field to create space for the second data field in the data view; and
providing content of the second data field of the data record for display in the space created by shifting the first data field.
0 Assignments
0 Petitions
Accused Products
Abstract
Methods, program products, and systems for visual manipulation of database schema are disclosed. In general, in one aspect, a system can display a schema view and a data view in graphic representation in an integrated GUI on a display device. The system can display a schema in the schema view, and one or more data records in the data view. The system can receive a touch input from the display device in the schema view, or the data view, or both. In response to the touch input, the system can modify the schema, or the data records, or both. The system can update the schema view and data view substantially simultaneously to reflect the modification in the schema or data records.
17 Citations
18 Claims
-
1. A method comprising:
-
providing for display on a touch-sensitive surface of a mobile device a schema view and a data view, the schema view displaying a schema of a database and comprising one or more data fields, the data view displaying at least one data record, the data record including a first data field defined by the schema; receiving a touch input on the touch-sensitive surface, the touch input dragging a second data field from the schema view into the data view, the second data field being a component of the data record that was hidden from the data view before receiving the touch input; in response to the received touch input, updating the schema view and the data view, including; shifting a display location of the first data field to create space for the second data field in the data view; and providing content of the second data field of the data record for display in the space created by shifting the first data field. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A system comprising:
-
one or more processors; a non-transitory storage device storing instructions operable to cause the one or more processors to perform operations comprising; providing for display on a touch-sensitive surface of a mobile device a schema view and a data view, the schema view displaying a schema of a database and comprising one or more data fields, the data view displaying at least one data record, the data record including a first data field defined by the schema; receiving a touch input on the touch-sensitive surface, the touch input dragging a second data field from the schema view into the data view, the second data field being a component of the data record that was hidden from the data view before receiving the touch input; in response to the received touch input, updating the schema view and the data view, including; shifting a display location of the first data field to create space for the second data field in the data view; and providing content of the second data field of the data record for display in the space created by shifting the first data field. - View Dependent Claims (8, 9, 10, 11, 12)
-
-
13. A non-transitory storage device storing instructions operable to cause one or more processors to perform operations comprising:
-
providing for display on a touch-sensitive surface of a mobile device a schema view and a data view, the schema view displaying a schema of a database and comprising one or more data fields, the data view displaying at least one data record, the data record including a first data field defined by the schema; receiving a touch input on the touch-sensitive surface, the touch input dragging a second data field from the schema view into the data view, the second data field being a component of the data record that was hidden from the data view before receiving the touch input; in response to the received touch input, updating the schema view and the data view, including; shifting a display location of the first data field to create space for the second data field in the data view; and providing content of the second data field of the data record for display in the space created by shifting the first data field. - View Dependent Claims (14, 15, 16, 17, 18)
-
Specification