Abstract: Approaches for preserving customizations made to a data management system. Metadata that identifies a mapping between data fields of one or more data source schemas to columns of one or more data tier schemas is maintained. Each of the one or more data tier schemas stores data retrieved from the one or more data source schemas. Values from the metadata are read to dynamically generate software processes. The software processes may update one or more existing ETL processes to reflect an updated state of the one or more data tier schemas and may generate any new ETL processes required to retrieve data stored in the one or more data source schemas and load the retrieved data into the one or more data tier schemas. Customizations made to portions the data management system are preserved in an automated fashion when new versions of system components are deployed.

Abstract: A method of operating a community parking system includes generating sensor data with a plurality of vehicles corresponding to vehicle parking spaces and parked vehicles located in a region, transmitting the sensor data to a parking data system, and generating parking map data with the parking data system based on the sensor data, the parking map data including a location of the vehicle parking spaces. The method also includes generating parking service data with the parking data system based on the sensor data, the parking service data identifying a status of each vehicle parking space as either occupied or unoccupied, and transmitting the parking service data to a particular vehicle of the plurality of vehicles to assist an operator of the particular vehicle in locating one of the vehicle parking spaces having an unoccupied status.

Abstract: Systems and methods for diagnosing a vehicle using sound data. One system includes a server storing a plurality of models and a communication device including a microphone. The communication device is configured to receive sound data received through the microphone associated with the vehicle and wirelessly transmit a diagnosis request to the server. The server is configured to receive the diagnosis request and select a model based on the vehicle data. The server is also configured to apply the selected model to the sound data to generate a response to the diagnosis request and wirelessly transmit the response to the diagnosis request to the communication device. The communication device is further configured to output at least a portion of the response on an output mechanism of the wireless communication device, the response including at least one diagnosis of the vehicle.

Abstract: An automated system for defining a star schema for a data source. The system based on automatically gathered information from the data source such as entities and columns, entity column types and lengths, entity keys, relationships between and within entities, measures, workflow and correlated attributes, specialized entities, an update frequency of entities and columns, and grouping of entity and column updates associated with the source database automatically determines facts, dimensions, dimension hierarchies, measures, workflow specific measures (if data source has workflows) and workflow correlated attribute specific measures (if data source has temporal, priority, ownership and progress tracking attributes) to come up with a star schema for the data source.

Abstract: Approaches for automatically determining of correlation for incident, problem and change items. Approaches may perform the steps of: (i) automatically extracting relevant information that includes any of (a) a time of occurrence, (b) important keywords, (c) a category, or sub-category classification, (d) related configuration items, (e) a group membership of the user who worked on, and (f) outage records associated with the incident, problem, and change items; and (ii) automatically analyzing persisted correlation maps using the essence key phrases associated with the incidents to identify essence key phrases of contributing problems, and changes; and (iii) automatically clustering the incidents, optionally with (A) the problems, and (B) the changes to identify clusters of related incident, problem and change items based on the relevant information associated with the incident, problem, and change items.

Abstract: An automated system for validating and refining a template warehouse star schema for a customized data source.

Abstract: A source computing environment administering business intelligence (BI) processing at a target computing environment. The source computing environment storing intermediate design plans for creating dimensional models, reports, and ETL jobs for deployment in a plurality of different computing environments. At the source computing environment, target specific modules translating the one or more intermediate design plans into one or more target specific plans for dimensional models, reports, and ETL job plans which are interpretable or executable by the target computing environment. The source computing environment, in consultation with a workflow engine, instructing the target computing environment to provision data repositories, create reports, and perform ETL processing based on the one or more target specific plans.

Abstract: Systems and processor-implemented methods of S-expression based computation of lineage and change impact analysis. An SQL expression is converted into an S-expression tabular structure. A function table including a plurality of functions associated with S-expression tabular structure tabulated against at least one of a function name, a derived column and a derived table and an argument table including plurality of arguments associated with the S-expression tabular structure tabulated against at least one of an argument type, a function identifier linking the arguments to the function table, a computed from function, a reference to entity or a literal value, is generated based on the S-expression tabular structure. At least one of lineage or change impact analysis for an entity is determined based on the function table and the argument table, where lineage provides a provenance of the entity or attribute from a source entity or a source attribute.

Abstract: In various embodiments, an automatic presentation/document builder is disclosed, where in a first phase a database/datastore is constructed from previously assembled presentations and documents including ratings/rankings for components/segments based on actions of viewers of the previously assembled presentations. In a second phase, a new presentation/document is automatically created based on interactive guidance with respect to desired goals, points, and storylines. Presentation components are automatically chosen and/or automatically suggested based on search functionality using Content Rank Scores that include weighted parameters. Newly created documents are thus assembled from segments of previously assembled presentations/documents with the new draft presentation/document based on user guidance and a stated desired outcome. In the last phase, the user is provided with machine assisted recommendation to enhance the automatically assembled presentation/document.

Abstract: Approaches for providing a customizable external data feed to a recipient. Metadata that identifies a plurality of configuration parameters that define characteristics of the external data feed are stored. A plurality of executable jobs using the configuration parameters defined in the metadata are programmatically generated. At least a first portion of executable jobs are executed to extract a data set identified by the configuration parameters from a persistent data store. At least a second portion of executable jobs are executed to format and transform the data set according to the configuration parameters. The external data feed, which comprises the formatted and transformed data set, is provided to the recipient.

Abstract: Approaches for a persistent data store that may be used to service data queries originating from data warehousing applications, operational reporting applications, or data archiving and data feed applications. At periodic intervals, data may be extracted from one or more disparate data sources. The extracted data may be stored in the persistent data store in a tabular format. A backward delta data set is generated. The backward delta data set identifies what additions, deletions, and modifications need to be made to the data stored in the persistent data store to return the data to a most recent version. Backward delta data sets are stored and maintained in accordance with a policy that instructs two or more backward delta data sets, associated with a continuous interval of time, be combined into a single backward delta data set after the expiration of a specified amount of time.

Abstract: Approaches for S-expression tabular structure based language conversion. An SQL expression is converted into an S-expression tabular structure. A function table including a plurality of functions associated with S-expression tabular structure tabulated against at least one of a function name, a derived column and a derived table and an argument table including plurality of arguments associated with the S-expression tabular structure tabulated against at least one of an argument type, a function identifier linking the arguments to the function table, a computed from function, a reference to entity or a literal value, is generated based on the S-expression tabular structure. One or more functions associated with the S-expression tabular structure is converted to a pre-determined SQL based language, based on a language map of the pre-determined language and the function table and the argument table.

Abstract: Systems and methods for diagnosing a vehicle using sound data. One system includes a server storing a plurality of models and a communication device including a microphone. The communication device is configured to receive sound data received through the microphone associated with the vehicle and wirelessly transmit a diagnosis request to the server. The server is configured to receive the diagnosis request and select a model based on the vehicle data. The server is also configured to apply the selected model to the sound data to generate a response to the diagnosis request and wirelessly transmit the response to the diagnosis request to the communication device. The communication device is further configured to output at least a portion of the response on an output mechanism of the wireless communication device, the response including at least one diagnosis of the vehicle.

Abstract: An automated system for defining a star schema for a data source. The system based on automatically gathered information from the data source such as entities and columns, entity column types and lengths, entity keys, relationships between and within entities, measures, workflow and correlated attributes, specialized entities, an update frequency of entities and columns, and grouping of entity and column updates associated with the source database automatically determines facts, dimensions, dimension hierarchies, measures, workflow specific measures (if data source has workflows) and workflow correlated attribute specific measures (if data source has temporal, priority, ownership and progress tracking attributes) to come up with a star schema for the data source.

Abstract: An automated system for validating and refining a template warehouse star schema for a customized data source.

Abstract: An automated input gathering system for defining, refining or validating a data warehouse star schema for a given data source. The automated data input gathering system includes a source metadata analysis module, an operational reporting environment analysis module, a usage analysis module and a data profiling module.

Abstract: Approaches for a user-driven warehousing approach are provided, wherein usage patterns for business intelligence applications are gathered, for example in an automated recording fashion, allowing the automated scheduling of jobs in a manner that prioritizes jobs that populate the most-used tables and scheduling those jobs in a manner to ensure that the data is up-to-date prior to when it is generally accessed. The usage pattern analysis also allows for the automated identification of more focused data marts for particular situations. The usage pattern analysis also provides for automated data warehouse/data mart creation and customization based on usage patterns that may be used as a seed, as well as for on-the-fly latitudinal analysis across prepackaged domain-specific applications.

Abstract: A method is presented for use in correctional facilities to manage resources. Particularly, the method includes using a scheduling engine capable of receiving scheduling requests from other systems or direct entry of scheduling data and which is equipped to provide reports that inform the facility of the schedules of all inmates, transportation requirements, and space accommodations. The method may be employed for evaluating the needs for transportation and space and may also be used to generate reports that show relationships between inmates based on activities, locations, and time.

Abstract: A method is presented for use in correctional facilities to manage resources. Particularly, the method includes using a scheduling engine capable of receiving scheduling requests from other systems or direct entry of scheduling data and which is equipped to provide reports that inform the facility of the schedules of all inmates, transportation requirements, and space accommodations. The method may be employed for evaluating the needs for transportation and space and may also be used to generate reports that show relationships between inmates based on activities, locations, and time.

Abstract: Video visitation systems and methods for correctional facilities include an audio/video processor element interconnecting an inmate station and a remote visitor station. The audio/video processor element adjusts audio and/or video feeds to facilitate monitoring by a plurality of officers at remote monitoring stations without experiencing network bandwidth and latency issues.