摘要:
The subject matter disclosed herein provides methods and apparatus, including computer program products, for providing software updates. In one aspect there is provided a method. The method may include receiving a command for execution at a database. Moreover, a determination may be made as to whether the received command is one of a set of extended commands. The set of extended commands includes lock read, lock write, migrate, copy, and log changes. The received command is executed at the database. Related systems, apparatus, methods, and/or articles are also described
摘要:
The invention relates to a method for controlling a relational database system by executing, using a database language, a database inquiry in a relational database which comprises as the assigned data structure a plurality of data tables interlinked by relations, a table of said relations being available. A processable database instruction without relation-specific operations is established by indicating those data tables to which the processing functions should be applied and also indicating the order of the selected data tables which should be used for processing. An access path is determined which concretely specifies an access order to the database. For this purpose, a partial access path is calculated using the table of relations between two successive, selected data tables based on the relations existing between the two successive data tables. The access path is then put together from all the calculated partial access paths.
摘要:
(N+Q) dimensions of data can be analyzed in an N-dimensional native OLAP cube (12) by submitting an (N+Q)-dimensional custom query and converting the (N+Q)-dimensional custom query into an N-dimensional query for submission to the N-dimensional native OLAP cube (12). An N-dimensional result of the N-dimensional query is provided and converted into an (N+Q)-dimensional result of the (N+Q)-dimensional custom query. The (N+Q) dimensional result is then provided as an answer to the (N+Q) dimensional custom query.
摘要:
In a method for linking data using permanent tokens (10), the tokens may be used to link data pertaining to a customer, a business, an address, an occupancy, or a household. The tokens are created in a central repository (24), which maintains an identification class (30) for each entity. The identification class contains all available information concerning the entity. The tokens may be applied to a data storage system to allow real-time construction of a total customer view. The tokens may also be used to link the data storage system to a repository, such that the total customer view contains all available information concerning the customer. The total customer view may be used to formulate a response to customer input, such as a purchase or access to an Internet web page maintained by the data owner. By matching tokens instead of names and addresses, potential ambiguities and erroneous duplicates are eliminated. Data updates may be performed incrementally, and may be pushed from the repository to the data owner as new information is received.
摘要:
Distributed storage systems support SQL while also providing scalability and fault tolerance by utilizing an SQL library (the SQL execution component) layered on top of a transactional key-value system (the storage component). The SQL library comprises a parser and an execution engine running at the client, while the storage component comprises a key-value system for storing the data. The SQL library parses SQL queries received from client applications and maps them to transactions on the key-value system. The key-value system stores data items identified by key and provides concurrency control mechanisms to handle concurrent transactions. The key-value system may be a distributed system with several storage servers, each attached to one or more storage devices.
摘要:
The subject disclosure is directed towards enriching database query responses using data from external data sources. When processing a database query seeking enriched data from an external data source, a request is communicated to the external data source based on the database query. An enriched database query response is generated based on data provided by the external data source. The enriched database query response may be combined with data returned via an internal database query operation, and/or inserted into a local database table.
摘要:
A machine-executed method and apparatus for displaying relationships between records in one or more databases in a browseable format is disclosed. Each database comprises one or more tables. Each table includes one or more fields and one or more records. The method entails: (a) displaying, on a display, a field value of a selected record in a table of a selected database; (b) displaying on the display a list of possible relationships between the selected record and other records in the database, where each possible relationship defines a pathway from the selected record to a list of other records; (c) receiving a user input signal designating one of the possible relationships as a selected relationship; (d) adding to the display at least a portion of a list of records that are related to the selected record through the selected relationship, referred to as the related-records list; and (e) adding to the display a list of possible relationships between the related-records list and other records in the database, where each possible relationship defines a pathway from the related-records list to a list of other records.
摘要:
A method and a system for accessing data in a computer-based data processing system. The method comprises the steps of initiating and maintaining data access nodes in a variable access structure. Each access node is provided with references to other access nodes and/or to data items representing an object, each data item carrying only the amount of information which is relevant for its purpose. The data items or the references are provided with a time parameter thus enabling version control and the possibility to handle static or slowly changing data and frequently changed and updated data in a conform manner. The access nodes comprises access control parameters for access control from safety point of view as well as for enabling different views of the access structure and underlying data and objects.
摘要:
A computer-implemented method for determining an index of an object in a sequence of objects, the method comprising the steps of: obtaining (110) a unique identifier value of a given object O; obtaining (111) a query definition Q of a sequence, the Q query including an order definition according to a parameter of the O object; constructing (112) a Q' query based on the Q query, the Q' query being different from the Q query by having a reversed ordering of results, with respect to the Q query, and providing results having said parameter value of objects preceding or matching the parameter value of the object O in the sequence of objects in the Q query result set; executing (113) the Q' query by a query execution engine; checking (114) whether the object O is matched exactly with the first item in Q' result set and in case it is not matched, requesting (115) one object at position P and one object at position P + 1, the position P being the position of an object from Q result set corresponding to the first item of Q' result set; and in case the Q' result set is empty, choosing (116a) an object at the first position in Q result set as the closest one to the object O; in case only one of the requested objects is available, choosing (116b) the object at the last position of Q result set as the closest one to the object O; in case both objects at position P and position P + 1 are available, determining which of these objects is closer with respect to the object O and choosing (116c) this object as the closest object; and determining (117) the index of the selected closest object in Q sequence as the index of the closest object to the O object.