MX2019007886A - System and method for database queries. - Google Patents

System and method for database queries.

Info

Publication number
MX2019007886A
MX2019007886A MX2019007886A MX2019007886A MX2019007886A MX 2019007886 A MX2019007886 A MX 2019007886A MX 2019007886 A MX2019007886 A MX 2019007886A MX 2019007886 A MX2019007886 A MX 2019007886A MX 2019007886 A MX2019007886 A MX 2019007886A
Authority
MX
Mexico
Prior art keywords
processing
information
database
invoice
processing server
Prior art date
Application number
MX2019007886A
Other languages
Spanish (es)
Inventor
B Millhouse Andrew
Steven MEREDITH John
Ellis Leroy
Original Assignee
Walmart Apollo Llc
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Walmart Apollo Llc filed Critical Walmart Apollo Llc
Publication of MX2019007886A publication Critical patent/MX2019007886A/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00—Commerce
    • G06Q30/04—Billing or invoicing
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2453—Query optimisation
    • G06F16/24534—Query rewriting; Transformation
    • G06F16/24539—Query rewriting; Transformation using cached or materialised query results
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/248—Presentation of query results
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Development Economics (AREA)
  • Economics (AREA)
  • General Business, Economics & Management (AREA)
  • Strategic Management (AREA)
  • Databases & Information Systems (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Marketing (AREA)
  • Finance (AREA)
  • Accounting & Taxation (AREA)
  • Operations Research (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Human Resources & Organizations (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

Retail stores may use the claim processing server to make a claim against a distribution center. Information about the claim may be entered into the store computer via an application and user interface. The claim processing server may use the information to process the claim and validate the related data. Using the information entered via the application the claim processing server may query the item database and the invoice database to retrieve to retrieve addition information from the database regarding the claim and the items. The information from the different databases may be merged together into a single database record which is then validated and stored the claim processing database. The information may also be checked and its accuracy verified. The user interfaces at the retail stores and distribution center may then be used to identify the claims for processing. The information for the item and invoice databases needed to process the claims are available from the claims processing database and the claim may be processed. The claims may be stored in the claims processing database for processing at a later time or for batch processing, for example during off-peak hours.
MX2019007886A 2016-12-30 2017-12-08 System and method for database queries. MX2019007886A (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US201662440629P 2016-12-30 2016-12-30
PCT/US2017/065380 WO2018125544A1 (en) 2016-12-30 2017-12-08 System and method for database queries

Publications (1)

Publication Number Publication Date
MX2019007886A true MX2019007886A (en) 2020-01-15

Family

ID=62710095

Family Applications (1)

Application Number Title Priority Date Filing Date
MX2019007886A MX2019007886A (en) 2016-12-30 2017-12-08 System and method for database queries.

Country Status (4)

Country Link
US (1) US10319006B2 (en)
CA (1) CA3048659A1 (en)
MX (1) MX2019007886A (en)
WO (1) WO2018125544A1 (en)

Family Cites Families (28)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5383112A (en) * 1991-01-07 1995-01-17 Gte Service Corporation Inventory management method
US5493108A (en) * 1992-10-14 1996-02-20 Spectra-Physics Scanning Systems, Inc. Method and apparatus for recognizing and assembling optical code information from partially scanned segments
US5809479A (en) * 1994-07-21 1998-09-15 Micron Technology, Inc. On-time delivery, tracking and reporting
US6275819B1 (en) * 1999-03-16 2001-08-14 Novell, Inc. Method and apparatus for characterizing and retrieving query results
US20160098669A9 (en) * 1999-05-11 2016-04-07 June Ray Limited Techniques for processing customer service transactions at customer site using mobile computing device
US8355947B2 (en) 2000-02-02 2013-01-15 The Ohana Companies, Inc. Methods and systems for processing rebates
CN1146821C (en) * 2000-02-21 2004-04-21 国际商业机器公司 Data bank query method and system to users
US7711612B1 (en) * 2000-11-14 2010-05-04 International Business Machines Corporation Replenishment management system and method
US20030074377A1 (en) * 2000-12-22 2003-04-17 Aman Gupta Method and apparatus for reporting the status of work in progress
US7921123B2 (en) * 2001-02-20 2011-04-05 Hartford Fire Insurance Company Method and system for processing physician claims over a network
US20020184121A1 (en) 2001-05-31 2002-12-05 Sun Microsystems, Inc. Methods and system for performing business-to-business electronic invoice presentment and payment with line item level granularity
US20030130945A1 (en) * 2002-01-08 2003-07-10 Bottomline Technologies (De) Inc. Electronic transaction processing server with trend based automated transaction evaluation
US20040019567A1 (en) * 2002-07-23 2004-01-29 International Business Machines Corporation Electronic prescription ordering method, system, and program product
US20060190380A1 (en) * 2002-08-30 2006-08-24 Bottomline Technologies (De) Inc. Electronic transaction processing server with automated transaction evaluation
ATE450011T1 (en) * 2004-06-23 2009-12-15 Sap Ag SYSTEM AND METHOD FOR DATA PROCESSING
US20070011041A1 (en) * 2005-07-07 2007-01-11 David Bourne Systems and methods for communicating within a supply chain
US20070203876A1 (en) 2006-02-28 2007-08-30 Hoopes John M Method of evaluating and tracking records
CA2542379A1 (en) * 2006-04-07 2007-10-07 Cognos Incorporated Packaged warehouse solution system
WO2008039759A2 (en) * 2006-09-25 2008-04-03 Intelligent Management Systems Corporation System and method for resource management
US7548900B2 (en) * 2006-11-30 2009-06-16 Sap Ag Systems and methods for data management
US8239292B2 (en) * 2007-07-11 2012-08-07 The Toro Company Method and apparatus for dealer connectivity
US20090043594A1 (en) 2007-08-10 2009-02-12 Denys Tseng Method and system for shortage deduction processing
US8412595B2 (en) * 2008-03-07 2013-04-02 American Express Travel Related Services Company, Inc. Lifecycle tracking and management using RF
US20120084135A1 (en) 2010-10-01 2012-04-05 Smartslips Inc. System and method for tracking transaction records in a network
US9251494B2 (en) * 2010-11-05 2016-02-02 Atc Logistics & Electronics, Inc. System and method for tracking customer personal information in a warehouse management system
CA3002450C (en) * 2013-06-19 2020-12-15 United States Postal Service System and method for providing real-time tracking of items in a distribution network
US9576310B2 (en) 2013-11-27 2017-02-21 Wal-Mart Stores, Inc. Normalizing universal product codes
US9571469B2 (en) * 2015-03-05 2017-02-14 Pawaa Software Private Limited Computer implemented system and method for ahead-of-time delivery of electronic content

Also Published As

Publication number Publication date
CA3048659A1 (en) 2018-07-05
US20180189845A1 (en) 2018-07-05
US10319006B2 (en) 2019-06-11
WO2018125544A1 (en) 2018-07-05

Similar Documents

Publication Publication Date Title
JP5869662B2 (en) System, method and computer program for managing user bookmark data
EP3529716B1 (en) Join with predictive granularity modification by example
CN104899295B (en) A kind of heterogeneous data source data relation analysis method
WO2014113772A3 (en) Methods and systems for mapping repair orders within a database
US20170161323A1 (en) Automatic generation of sub-queries
GB2538625A8 (en) Systems and methods for evaluating search query terms for improving search results
JP2017503273A5 (en)
US20150058334A1 (en) Presentation of items based on a theme
US20100042657A1 (en) Method and system for saving database storage space
US20200167433A1 (en) Relevance of Search Results
US9639568B2 (en) Systems and methods for improved data structure storage
CN112527765B (en) Data migration method and device
CN107133362A (en) Commodity Information Search method, system, computer program and electronic equipment
RU2014127986A (en) METHOD, SERVER AND SYSTEM FOR IMPLEMENTATION OF GOODS
CN104484958A (en) Express delivery pickup method and system for intelligent express delivery cabinet
CN107451280B (en) Data communication method and device and electronic equipment
CN105159952A (en) Data processing method based on frequent item set mining
CN109101512B (en) Construction method of legal database, legal data query method and device
US11734275B2 (en) Estimating string intersections for database systems
CN110827101B (en) A method and device for recommending a store
GB2547388A (en) System and method for searching structured data files
US9262472B2 (en) Concatenation for relations
MX2019007886A (en) System and method for database queries.
US12019597B1 (en) Deduplication of records in large databases via clustering
Tohir et al. On-Line Analytic Processing (OLAP) modeling for graduation data presentation