公开(公告)号：US20060100969A1

公开(公告)日：2006-05-11

申请号：US10984323

申请日：2004-11-08

申请人： Min Wang ,  Sriram Padmanabhan ,  Like Gao

发明人： Min Wang ,  Sriram Padmanabhan ,  Like Gao

IPC分类号： G06F17/00

CPC分类号： G06Q30/0283 ,  G06F16/24542 ,  G06F16/24568

摘要： A learning-based method for estimating costs or statistics of an operator in a continuous query includes a cost estimation model learning procedure and a model applying procedure. The model learning procedure builds a cost estimation model from training data, and the applying procedure uses the model to estimate the cost associated with a given query. The learning procedure uses a feature extractor and a cost estimator. The feature extractor collects relevant training data and obtains feature values. The extracted feature values are associated with costs and used to create the cost estimator. When applying the cost estimator to a continuous stream of data, the feature extractor extracts feature values from the data stream and uses the extracted feature values as inputs into the cost estimator to obtain the desired cost values.

摘要翻译： 用于估计连续查询中的运营商的成本或统计的基于学习的方法包括成本估计模型学习过程和模型应用程序。 模型学习过程从培训数据建立成本估算模型，应用程序使用模型来估计与给定查询相关联的成本。 学习过程使用特征提取器和成本估算器。 特征提取器收集相关的训练数据并获取特征值。 提取的特征值与成本相关联，并用于创建成本估计。 当将成本估计器应用于连续数据流时，特征提取器从数据流中提取特征值，并将所提取的特征值作为输入到成本估计器中以获得期望的成本值。

公开(公告)号：US20060190425A1

公开(公告)日：2006-08-24

申请号：US11064605

申请日：2005-02-24

申请人： Yuan-Chi Chang ,  Christian Lang ,  Apostol Natsev ,  Sriram Padmanabhan ,  Min Wang ,  Ioana Stanoi

发明人： Yuan-Chi Chang ,  Christian Lang ,  Apostol Natsev ,  Sriram Padmanabhan ,  Min Wang ,  Ioana Stanoi

IPC分类号： G06F17/30

CPC分类号： G06F16/5838 ,  G06F16/24549

摘要： Systems and methods for conducting attribute-based queries over a plurality of objects using bounded memory locations and minimizing costly input and output operations are provided. A plurality of attributes are associated with each object, and a plurality of data groups, one each for the identified attributes are created. The objects associated with the attributes are placed into the appropriate data groups, and the objects contained within each data group are sorted into blocks such that each block within a given attribute contains that objects having the same attribute value. Results to the query are created by loading blocks into a primary memory location in a middleware system and combining the loaded blocks to create the desire query results. Block combinations are created based upon the fit of the given block combination to the query as expressed in an aggregation function. A second dedicated memory location can also be provided to hold multiple block combinations to optimize the order in which blocks are loaded and combined. Empty block buffers and external storage devices can also be provided to further enhance the generation of query results.

摘要翻译： 提供了使用有限存储器位置对多个对象进行基于属性的查询并最小化昂贵的输入和输出操作的系统和方法。 多个属性与每个对象相关联，并且创建多个数据组，每个数据组各自用于所识别的属性。 与属性相关联的对象被放置到适当的数据组中，并且每个数据组中包含的对象被排序成块，使得给定属性中的每个块包含具有相同属性值的对象。 通过将块加载到中间件系统中的主存储器位置并组合加载的块以创建期望查询结果来创建查询的结果。 基于给定块组合对于在聚合函数中表达的查询的拟合来创建块组合。 还可以提供第二专用存储器位置以保持多个块组合以优化块被加载和组合的顺序。 还可以提供空块缓冲区和外部存储设备，以进一步增强查询结果的生成。

公开(公告)号：US07269729B2

公开(公告)日：2007-09-11

申请号：US10036196

申请日：2001-12-28

申请人： Jingmin He ,  Sriram Padmanabhan ,  Min Wang

发明人： Jingmin He ,  Sriram Padmanabhan ,  Min Wang

IPC分类号： H04L9/00 ,  G06F11/30 ,  G06F7/04

CPC分类号： G06F17/30595 ,  H04L9/0825 ,  H04L9/0894

摘要： Disclosed is a method of internally encrypting data in a relational database, comprising the steps of providing a security dictionary comprising one or more security catalogs, receiving data from a user associating said data with a database column and at least one authorized user, generating a working encryption key, internally encrypting said working encryption key using a public key from an authorized user, storing said encrypted working key in a security catalog, and using said working key to internally encrypt said data.

摘要翻译： 公开了一种在关系数据库中内部加密数据的方法，包括以下步骤：提供包括一个或多个安全目录的安全词典，从用户接收数据，将所述数据与数据库列和至少一个授权用户相关联，生成工作 加密密钥，使用来自授权用户的公钥对所述工作加密密钥进行内部加密，将所述加密的工作密钥存储在安全目录中，并使用所述工作密钥对所述数据进行内部加密。

公开(公告)号：US20050246262A1

公开(公告)日：2005-11-03

申请号：US10834767

申请日：2004-04-29

申请人： Charu Aggarwal ,  Murray Campbell ,  Yuan-Chi Chang ,  Matthew Hill ,  Chung-Sheng Li ,  Milind Naphade ,  Sriram Padmanabhan ,  John Smith ,  Min Wang ,  Kun-Lung Wu ,  Philip Yu

发明人： Charu Aggarwal ,  Murray Campbell ,  Yuan-Chi Chang ,  Matthew Hill ,  Chung-Sheng Li ,  Milind Naphade ,  Sriram Padmanabhan ,  John Smith ,  Min Wang ,  Kun-Lung Wu ,  Philip Yu

IPC分类号： G06F17/30 ,  G06Q10/00 ,  H04L12/18 ,  H04L12/58 ,  H04L29/08 ,  G06F17/60

CPC分类号： H04L12/1859 ,  G06Q10/06 ,  G06Q10/10 ,  G06Q40/04 ,  G16H50/80 ,  H04L51/14 ,  H04L67/125 ,  H04L67/2823

摘要： Interoperability is enabled between participants in a network by determining values associated with a value metric defined for at least a portion of the network. Information flow is directed between two or more of the participants based at least in part on semantic models corresponding to the participants and on the values associated with the value metric. The semantic models may define interactions between the participants and define at least a portion of information produced or consumed by the participants. The determination of the values and the direction of the information flow may be performed multiple times in order to modify the one or more value metrics. The direction of information flow may allow participants to be deleted from the network, may allow participants to be added to the network, or may allow behavior of the participants to be modified.

摘要翻译： 通过确定与为网络的至少一部分定义的值度量相关联的值来在网络中的参与者之间启用互操作性。 至少部分地基于与参与者对应的语义模型以及与值度量相关联的值，在两个或多个参与者之间引导信息流。 语义模型可以定义参与者之间的交互，并定义参与者产生或消费的信息的至少一部分。 可以多次执行信息流的值和方向的确定，以便修改一个或多个值度量。 信息流的方向可以允许从网络中删除参与者，可以允许参与者被添加到网络中，或者允许参与者的行为被修改。

公开(公告)号：US09605250B2

公开(公告)日：2017-03-28

申请号：US14111531

申请日：2012-04-12

申请人： Chemira B. Appaiah ,  Sriram Padmanabhan ,  R. Sanjeev Saravanan ,  Bharathi Sriram

发明人： Chemira B. Appaiah ,  Sriram Padmanabhan ,  R. Sanjeev Saravanan ,  Bharathi Sriram

IPC分类号： A61K38/43 ,  C12N9/24 ,  C12N9/36 ,  C12N1/06 ,  C12N15/62 ,  C07K14/47 ,  C12N9/48 ,  C07K14/005 ,  A61K38/00

CPC分类号： C12N9/2462 ,  A61K38/00 ,  C07K14/005 ,  C07K14/47 ,  C07K14/4742 ,  C07K2319/03 ,  C12N1/06 ,  C12N9/24 ,  C12N9/48 ,  C12N15/62 ,  C12N2795/00022 ,  C12N2795/00033 ,  C12N2795/10122 ,  C12N2795/10133 ,  C12N2795/10322 ,  C12N2795/10333 ,  C12Y302/01017 ,  Y02A50/475 ,  Y02A50/483

摘要： Provided herein are antibacterial compositions and methods of making and using the compositions.

公开(公告)号：US09298787B2

公开(公告)日：2016-03-29

申请号：US13292234

申请日：2011-11-09

申请人： Manish Anand Bhide ,  Srinivas Kiran Mittapalli ,  Sriram Padmanabhan

发明人： Manish Anand Bhide ,  Srinivas Kiran Mittapalli ,  Sriram Padmanabhan

IPC分类号： G06F17/30

CPC分类号： G06F17/30563 ,  G06F17/30589 ,  G06F17/30592

摘要： A computer-implemented method, computer program product and a system for supporting star and snowflake data schemas for use with an Extract, Transform, Load (ETL) process, comprising selecting a data source comprising dimensional data, where the dimensional data comprises at least one source table comprising at least one source column, importing a data model for the dimensional data into a data integration system, analyzing the imported data model to select a star or snowflake target data schema comprising target dimensions and target facts, generating a meta-model representation by mapping at least one source table or source column to each target fact and target dimension, automatically converting the meta-model representation into one or more ETL jobs, and executing the ETL jobs to extract the dimensional data from the data source and loading the dimensional data into the selected target data schema in a target data system.

公开(公告)号：US20130124454A1

公开(公告)日：2013-05-16

申请号：US13618158

申请日：2012-09-14

申请人： Manish A. Bhide ,  Srinivas Kiran Mittapalli ,  Sriram Padmanabhan

发明人： Manish A. Bhide ,  Srinivas Kiran Mittapalli ,  Sriram Padmanabhan

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30563

摘要： A computer-implemented method, computer program product and a system for identifying and handling slowly changing dimension (SCD) attributes for use with an Extract, Transform, Load (ETL) process, comprising importing a data model for dimensional data into a data integration system, where the dimensional data comprises a plurality of attributes, identifying via a data discovery analyzer one or more attributes in the data model as SCD attributes, importing the identified SCD attributes into the data integration system, selecting a data source comprising dimensional data, automatically generating an ETL job for the dimensional data utilizing the imported SCD attributes, and executing the automatically generated ETL to extract the dimensional data from the data source and loading the dimensional data into the imported SCD attributes in a target data system.

摘要翻译： 一种计算机实现的方法，计算机程序产品和用于识别和处理与提取，变换，加载（ETL）过程一起使用的缓慢变化的维度（SCD）属性的系统，包括将维数据的数据模型导入数据集成系统 其中尺寸数据包括多个属性，通过数据发现分析器将数据模型中的一个或多个属性识别为SCD属性，将所识别的SCD属性导入到数据集成系统中，选择包括尺寸数据的数据源，自动生成 用于使用导入的SCD属性的维数据的ETL作业，以及执行自动生成的ETL以从数据源提取尺寸数据，并将维数据加载到目标数据系统中的导入的SCD属性中。

公开(公告)号：US07937541B2

公开(公告)日：2011-05-03

申请号：US11548889

申请日：2006-10-12

申请人： Bishwaranjan Bhattacharjee ,  Christian A. Lang ,  Timothy R. Malkemus ,  Sriram Padmanabhan ,  Kwai Wong

发明人： Bishwaranjan Bhattacharjee ,  Christian A. Lang ,  Timothy R. Malkemus ,  Sriram Padmanabhan ,  Kwai Wong

IPC分类号： G06F12/06

CPC分类号： G06F12/0866 ,  G06F12/123 ,  G06F17/30448

摘要： Disclosed are a method, information processing system, and computer readable medium for scanning a storage medium table. The method includes retrieving location information associated with at least one other storage medium table scan. A storage medium table scan is started at a location within a storage medium table based on at least a location of the one other storage medium table scan. A weight is assigned to at least one storage medium block based on at least a current scanning location within the storage medium table relative to the location of the one other table scan. The method determines if a distance between the current scanning location and the location of the one other table scan is greater than a first given threshold. A current scanning operation is delayed, in response to the distance being greater than the given threshold, until the distance is below a second given threshold.

摘要翻译： 公开了一种用于扫描存储介质表的方法，信息处理系统和计算机可读介质。 该方法包括检索与至少一个其他存储介质表扫描相关联的位置信息。 基于至少另一个存储介质表扫描的位置，在存储介质表中的位置处开始存储介质表扫描。 基于至少一个存储介质表中的当前扫描位置相对于另一个表扫描的位置，将权重分配给至少一个存储介质块。 该方法确定当前扫描位置与另一个表扫描的位置之间的距离是否大于第一给定阈值。 响应于距离大于给定阈值，当前扫描操作被延迟，直到距离低于第二给定阈值。

公开(公告)号：US20080144128A1

公开(公告)日：2008-06-19

申请号：US11548875

申请日：2006-10-12

申请人： Bishwaranjan Bhattacharjee ,  Christian A. Lang ,  Timothy R. Malkemus ,  Sriram Padmanabhan ,  Kwai Wong

发明人： Bishwaranjan Bhattacharjee ,  Christian A. Lang ,  Timothy R. Malkemus ,  Sriram Padmanabhan ,  Kwai Wong

IPC分类号： H04N1/04

CPC分类号： G06F17/30952 ,  G06F17/3048 ,  G06F17/30985

摘要： Disclosed are a method, information processing system, and computer readable medium for managing table scan processes. The method includes monitoring a plurality of storage medium table scan processes. Each storage medium table scan process in the plurality of storage medium table scan processes is placed into a plurality of scan groups based on storage medium pages to be scanned by each of the storage medium table scan processes. Each storage medium table scan process in a scan group can share data within a storage medium page.

摘要翻译： 公开了一种用于管理表扫描处理的方法，信息处理系统和计算机可读介质。 该方法包括监视多个存储介质表扫描处理。 将多个存储介质台扫描处理中的每个存储介质台扫描处理基于要通过每个存储介质表扫描处理扫描的存储介质页被放置到多个扫描组中。 扫描组中的每个存储介质表扫描处理可以在存储介质页内共享数据。

公开(公告)号：US06950823B2

公开(公告)日：2005-09-27

申请号：US10328229

申请日：2002-12-23

申请人： Khalil S. Amiri ,  Sriram Padmanabhan ,  Sanghyun Park ,  Renu Tewari

发明人： Khalil S. Amiri ,  Sriram Padmanabhan ,  Sanghyun Park ,  Renu Tewari

IPC分类号： G06F7/00 ,  G06F15/16 ,  G06F17/30

CPC分类号： G06F17/3048 ,  G06F17/30457 ,  Y10S707/99932 ,  Y10S707/99933

摘要： A system, apparatus and method are provided for the dynamic caching of data based on queries performed by a local application, where the system includes a remote server having a complete database, a local database on an edge server including a subset of the complete database, the edge server in communication with the remote server, shared tables within the local database on the edge server for caching results from the complete database, receiving locally generated data, and adjusting the contents of the cache based on available storage requirements while ensuring consistency of the data between the local database and the remote database; the apparatus includes an edge data cache including a query evaluator, a cache index, cache repository, resource manager, containment checker, query parser and consistency manager all in signal communication with the query evaluator; and the method for a local server to satisfy a database query meant for at least one remote server includes dynamically caching results of previous database queries of the remote server, associating a local database with the local server, storing a plurality of the caching results in shared tables in the local database, and using the plurality of the caching results in satisfying a new database query with the local server.

摘要翻译： 提供了一种用于基于由本地应用执行的查询来动态缓存数据的系统，装置和方法，其中系统包括具有完整数据库的远程服务器，包括完整数据库的子集的边缘服务器上的本地数据库， 与远程服务器通信的边缘服务器，边缘服务器上的本地数据库中的共享表，用于从完整数据库缓存结果，接收本地生成的数据，并根据可用存储要求调整缓存的内容，同时确保 本地数据库与远程数据库之间的数据; 该装置包括与查询评估器进行信号通信的包括查询评估器，缓存索引，高速缓存存储库，资源管理器，容纳检查器，查询解析器和一致性管理器的边缘数据高速缓存器; 并且本地服务器满足用于至少一个远程服务器的数据库查询的方法包括动态缓存远程服务器的先前数据库查询的结果，将本地数据库与本地服务器相关联，将多个缓存结果存储在共享 本地数据库中的表，并且使用多个高速缓存结果来满足与本地服务器的新的数据库查询。